Charleston French Drains

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 321425,
      "site_id": 76,
      "cat_id": 11,
      "priority": 2,
      "url": "http://www.charlestonfrenchdrain.com/",
      "title": "Charleston French Drains",
      "description": "A wet basement is more than a bothersome annoyance. Prolonged and excessive moisture on the basement floor and walls can contribute to several types of property damage. For example, mildew growth and foundation issues may be more likely when you are constantly dealing with a wet basement. While this is an unfortunately common issue that many Charleston-area homeowners deal with regularly, there is a straightforward solution available.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 72615,
      "approve_dt": "2025-04-14T00:00:00.000Z",
      "source": null,
      "submit_dt": "2021-11-01T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": 3,
      "clickcount": 322,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 0,
      "city_id": 0,
      "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": 5864,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "95850d54-56da-11ed-b77c-b66e99367f32",
      "subdate": "Nov 01, 2021",
      "subcategory": "Home Cleaners",
      "request_types": "",
      "visitcount": 423
   },
   "visits": {
      "storefront": 423,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 0,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "A wet basement is more than just a bothersome annoyance - it's a serious threat to your property's structural integrity and your family's health. Prolonged moisture on basement floors and walls can lead to mildew growth, foundation damage, and decreased property value.\n\nWhile this is an unfortunately common issue for many Charleston-area homeowners, professional waterproofing solutions can effectively address and prevent these problems.",
      "service1": "French Drain Installation",
      "service2": "",
      "service3": "",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2021-11-01 06:17:09"
   },
   "location": {
      "uuid": "95850d54-56da-11ed-b77c-b66e99367f32",
      "link_id": 321425,
      "account_id": 72615,
      "company": "Charleston French Drains",
      "sid": 76,
      "country": 277,
      "countrycode": "US",
      "state": 0,
      "city": "0",
      "zip": "29418",
      "address": "7187 Bryhawke Cir Unit #700, North Charleston, SC 29418",
      "phone": "843-428-8723",
      "fax": null,
      "email": "casseverhart13@gmail.com",
      "name": "Charleston French Drains",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "32.9105797",
      "lon": "-80.0685468",
      "cityname": "",
      "statename": ""
   },
   "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": ""
}