Seaside Pro Wash

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 346187,
      "site_id": 76,
      "cat_id": 11,
      "priority": 2,
      "url": "https://washcharleston.com/",
      "title": "Seaside Pro Wash",
      "description": "Seaside Pro Wash is a Charleston-based exterior cleaning company founded by mechanical engineer Ryan Ufret, specializing in professional pressure and soft washing services for residential and commercial properties. With over 500 homes cleaned and a 98% customer satisfaction rate, they use eco-friendly solutions and guarantee 100% satisfaction on every job.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 96882,
      "approve_dt": "2025-08-17T00:00:00.000Z",
      "source": null,
      "submit_dt": "2025-05-01T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 5,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 39,
      "city_id": 20231,
      "ltop": "",
      "facebook": "",
      "tiktok": null,
      "linkedin": "",
      "twitter": "",
      "googleplus": "",
      "youtube_channel": null,
      "youtube": "",
      "youtube_title": null,
      "pinterest": "",
      "yelp": "",
      "foursquare": "",
      "instagram": "",
      "tripadvisor": null,
      "trustpilot": null,
      "blog_link": null,
      "ss_exchange": 0,
      "googlebot": null,
      "yahoobot": null,
      "msnbot": null,
      "author_id": null,
      "subcat_id": 5887,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "0ba9399b-2624-11f0-a909-b66e99367f32",
      "subdate": "May 01, 2025",
      "subcategory": "Window Cleaning",
      "request_types": "",
      "visitcount": 43
   },
   "visits": {
      "storefront": 43,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 11,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "At Seaside Pro Wash, we specialize in delivering professional pressure and soft washing services to both residential and commercial clients throughout the Charleston area. Our mission is simple: to provide top-tier exterior cleaning services that leave your property looking immaculate. Whether you need your homes exterior, driveway, or commercial property cleaned, were here to offer solutions tailored to your needs. With our expertise and dedication to customer satisfaction, you can expect nothing less than exceptional results.",
      "service1": "Window Cleaning",
      "service2": "Roof Cleaning",
      "service3": "Gutter Cleaning",
      "service4": "Fence Cleaning",
      "service5": "Solar Panel Cleaning",
      "service6": "",
      "service7": "",
      "submit_dt": "2025-05-01 00:34:30"
   },
   "location": {
      "uuid": "0ba9399b-2624-11f0-a909-b66e99367f32",
      "link_id": 346187,
      "account_id": 96882,
      "company": "Seaside Pro Wash",
      "sid": 76,
      "country": 277,
      "countrycode": "US",
      "state": 39,
      "city": "20231",
      "zip": "29412",
      "address": "",
      "phone": "(843) 790-4298",
      "fax": null,
      "email": "seasideprowash@burst-email.com",
      "name": "Seaside Pro Wash",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": null,
      "lon": null,
      "cityname": "Charleston",
      "statename": "South Carolina"
   },
   "socialmedia": [
      {
         "title": "Facebook",
         "ptype_id": 29,
         "dbtable": "links_socialmedia",
         "item": "Page",
         "cnt": null
      },
      {
         "title": "Instagram",
         "ptype_id": 30,
         "dbtable": "links_socialmedia",
         "item": "Page",
         "cnt": null
      },
      {
         "title": "Youtube",
         "ptype_id": 31,
         "dbtable": "links_socialmedia",
         "item": "Youtube Video",
         "cnt": null
      },
      {
         "title": "LinkedIn",
         "ptype_id": 32,
         "dbtable": "links_socialmedia",
         "item": "Page",
         "cnt": null
      },
      {
         "title": "TikTok",
         "ptype_id": 33,
         "dbtable": "links_socialmedia",
         "item": "Videos",
         "cnt": null
      },
      {
         "title": "Twitter",
         "ptype_id": 34,
         "dbtable": "links_socialmedia",
         "item": "Page",
         "cnt": null
      },
      {
         "title": "Reddit",
         "ptype_id": 37,
         "dbtable": "links_socialmedia",
         "item": "Reddit",
         "cnt": null
      },
      {
         "title": "SnapChat",
         "ptype_id": 38,
         "dbtable": "links_socialmedia",
         "item": "SnapChat",
         "cnt": null
      }
   ],
   "promos": [
      {
         "item": "article",
         "cnt": 0
      },
      {
         "item": "video",
         "cnt": 0
      },
      {
         "item": "product",
         "cnt": 0
      },
      {
         "item": "coupon",
         "cnt": 0
      },
      {
         "item": "service",
         "cnt": 0
      },
      {
         "item": "article_external",
         "cnt": 0
      },
      {
         "item": "video_external",
         "cnt": 0
      },
      {
         "item": "product_external",
         "cnt": 0
      },
      {
         "item": "coupon_external",
         "cnt": 0
      },
      {
         "item": "service_external",
         "cnt": 0
      }
   ],
   "featuredproduct": ""
}