Mr. Gutter SC

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 344138,
      "site_id": 67,
      "cat_id": 81,
      "priority": 2,
      "url": "https://mrguttersc.com/",
      "title": "Mr. Gutter SC",
      "description": "At Mr. Gutter SC, we are your trusted experts in gutter services, offering comprehensive solutions including installation, cleaning, repair, and maintenance for both residential and commercial properties in Columbia, SC. With years of experience, we specialize in seamless gutters, gutter guards, and downspout care, ensuring your property is protected from water damage year-round. Our commitment to quality, professionalism, and customer satisfaction makes us the go-to choice for durable, reliable gutter systems. Protect your home or business with our expert services tailored to meet your needs. Contact us today for a free estimate!",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 94833,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2025-03-22T00: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": 20245,
      "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": 5046,
      "d_url": null,
      "approved": null,
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "4dc65b86-06fb-11f0-a909-b66e99367f32",
      "subdate": "Mar 22, 2025",
      "subcategory": "Roofing",
      "request_types": "",
      "visitcount": 16
   },
   "visits": {
      "storefront": 16,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 8,
      "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-22 08:54:46"
   },
   "location": {
      "uuid": "4dc65b86-06fb-11f0-a909-b66e99367f32",
      "link_id": 344138,
      "account_id": 94833,
      "company": "Mr. Gutter SC",
      "sid": 67,
      "country": 277,
      "countrycode": "US",
      "state": 39,
      "city": "20245",
      "zip": "29201",
      "address": "1320 Main St Suite 300",
      "phone": "(803) 360-8890",
      "fax": null,
      "email": "cahalhougland@gmail.com",
      "name": "Mr. Gutter SC",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "34.0033211",
      "lon": "-81.0339306",
      "cityname": "Columbia",
      "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": ""
}