Stonehaven Remodeling Services Inc..

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 343776,
      "site_id": 76,
      "cat_id": 11,
      "priority": 2,
      "url": "https://www.stonehavenremodeling.com/",
      "title": "Stonehaven Remodeling Services Inc..",
      "description": "Here at Stonehaven Remodeling we understand that beginning a new project, although exciting, can also be a stressful time for you. We strive to make the process easy on you by careful planning, scheduling, efficient job site supervision, assistance with selections and ensuring that all work performed is of the best quality. We pride ourselves on great customer relations. Our goal is to keep your project running smooth from start to finish. Whether your next project is a new home, an addition to your existing home, or a Remodeling project, we are there for you. Our commitment to customer satisfaction means that we draw on our long experience to keep your project on time and on budget. We would appreciate the opportunity to work with you.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 94471,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2025-03-13T00: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": 39,
      "city_id": 20285,
      "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": 5878,
      "d_url": null,
      "approved": null,
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "366f8653-0025-11f0-a909-b66e99367f32",
      "subdate": "Mar 13, 2025",
      "subcategory": "Renovations",
      "request_types": "",
      "visitcount": 22
   },
   "visits": {
      "storefront": 22,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 7,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "",
      "service1": "",
      "service2": "",
      "service3": "",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2025-03-13 16:07:07"
   },
   "location": {
      "uuid": "366f8653-0025-11f0-a909-b66e99367f32",
      "link_id": 343776,
      "account_id": 94471,
      "company": "Stonehaven Remodeling Services Inc..",
      "sid": 76,
      "country": 277,
      "countrycode": "US",
      "state": 39,
      "city": "20285",
      "zip": "29708",
      "address": "1692 Katy Ln",
      "phone": "803-804-7105",
      "fax": null,
      "email": "stonehavenremodelinginc@gmail.com",
      "name": "Stonehaven Remodeling Services Inc..",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "35.0475994",
      "lon": "-80.9902341",
      "cityname": "Fort Mill",
      "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": ""
}