C&S Remodeling

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 335505,
      "site_id": 6,
      "cat_id": 39,
      "priority": 2,
      "url": "https://www.cs-enterprises.net/",
      "title": "C&S Remodeling",
      "description": "Welcome to C&S Remodeling, where Scott and Carol Kressner lead a team dedicated to realizing your dream home. With a focus on personalized service and client involvement, we guide you through every stage of your project, from ideation to implementation. Leveraging our extensive experience and cutting-edge technology, we transform your vision into tangible designs, all while upholding the highest standards of quality and integrity. Explore our portfolio to witness the craftsmanship and attention to details.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 86248,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-09-17T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 13,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 42,
      "city_id": 22482,
      "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": 288,
      "d_url": null,
      "approved": null,
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "3ae16fb0-7507-11ef-ab46-b66e99367f32",
      "subdate": "Sep 17, 2024",
      "subcategory": "Home And Garden",
      "request_types": "",
      "visitcount": 35
   },
   "visits": {
      "storefront": 35,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 2,
      "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": "2024-09-17 15:12:18"
   },
   "location": {
      "uuid": "3ae16fb0-7507-11ef-ab46-b66e99367f32",
      "link_id": 335505,
      "account_id": 86248,
      "company": "",
      "sid": 6,
      "country": 277,
      "countrycode": "US",
      "state": 42,
      "city": "22482",
      "zip": "78224",
      "address": "7550 Interstate 10, Suite 1434",
      "phone": "(210) 867-0011",
      "fax": null,
      "email": "candsremodeling@burst-email.com",
      "name": "C&S Remodeling",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "29.5042445",
      "lon": "-98.5514523",
      "cityname": "San Antonio",
      "statename": "Texas"
   },
   "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": ""
}