Carolina Foundation Solutions

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 343057,
      "site_id": 76,
      "cat_id": 11,
      "priority": 2,
      "url": "https://www.carolinafoundationsolutions.com/?utm_source=google&utm_medium=organic&utm_campaign=GMB%20Listing%20Charlotte",
      "title": "Carolina Foundation Solutions",
      "description": "",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 93752,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2025-02-27T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 1,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 32,
      "city_id": 15779,
      "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": 6285,
      "d_url": null,
      "approved": null,
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "7b9de88e-f508-11ef-a909-b66e99367f32",
      "subdate": "Feb 27, 2025",
      "subcategory": "Contractor",
      "request_types": "",
      "visitcount": 18
   },
   "visits": {
      "storefront": 18,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 9,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Carolina Foundation Solutions is a family-owned company proudly serving Charlotte and nearby areas, including Belmont, Mount Holly, Stanley, Pineville, Gastonia, Huntersville, Tega Cay, Fort Mill, Matthews, Cornelius, and Davidson. We specialize in foundation repair, basement waterproofing, crawl space services, concrete slab repairs, and drainage solutions. Our experts address wet basements, foundation cracks, bowing walls, and crawl space moisture with tailored solutions to protect your home. Schedule a free inspection now.",
      "service1": "",
      "service2": "",
      "service3": "",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2025-02-27 12:43:45"
   },
   "location": {
      "uuid": "7b9de88e-f508-11ef-a909-b66e99367f32",
      "link_id": 343057,
      "account_id": 93752,
      "company": "",
      "sid": 76,
      "country": 277,
      "countrycode": "US",
      "state": 32,
      "city": "15779",
      "zip": "28214",
      "address": "8610 Wilkinson Boulevard",
      "phone": "+1 336-715-0028",
      "fax": null,
      "email": "carolinafoundation@brite-email.com",
      "name": "",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "35.243037",
      "lon": "-80.9858294",
      "cityname": "Charlotte",
      "statename": "North 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": ""
}