SERVPRO of The Dutch Fork

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 332215,
      "site_id": 58,
      "cat_id": 53,
      "priority": 2,
      "url": "https://www.servpro.com/locations/sc/servpro-of-the-dutch-fork",
      "title": "SERVPRO of The Dutch Fork",
      "description": "",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 83004,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-06-26T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 5,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 39,
      "city_id": 20532,
      "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": 6468,
      "d_url": null,
      "approved": null,
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "2e5d74f2-3388-11ef-8344-b66e99367f32",
      "subdate": "Jun 26, 2024",
      "subcategory": "Water Restoration And Damage",
      "request_types": "",
      "visitcount": 37
   },
   "visits": {
      "storefront": 37,
      "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": "We offer 24-hour damage restoration services in Chapin, Irmo, Columbia, and surrounding areas of South Carolina. Our services include water damage restoration, fire damage restoration, mold remediation, biohazard cleanup, and decontamination. Our SERVPRO franchise has served South Carolina for over 25 years, and we have helped thousands of families and businesses restore their properties. We're ready to help you, too! We're open 24-hours a day, 365 days a year.",
      "service1": "Water Damage Restoration",
      "service2": "Fire Damage Restoration",
      "service3": "Storm Damage Restoration",
      "service4": "Mold Remediation",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2024-06-26 06:49:05"
   },
   "location": {
      "uuid": "2e5d74f2-3388-11ef-8344-b66e99367f32",
      "link_id": 332215,
      "account_id": 83004,
      "company": "SERVPRO of The Dutch Fork",
      "sid": 58,
      "country": 277,
      "countrycode": "US",
      "state": 39,
      "city": "20532",
      "zip": "29169",
      "address": "1055 Sunset Blvd",
      "phone": "+1 803-749-0178",
      "fax": null,
      "email": "servprowcolumbia@brite-post.com",
      "name": "SERVPRO of The Dutch Fork",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "33.9973529",
      "lon": "-81.0740427",
      "cityname": "West 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": ""
}