Drain King

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 320970,
      "site_id": 66,
      "cat_id": 78,
      "priority": 2,
      "url": "https://drainkingofchicago.com/",
      "title": "Drain King",
      "description": "Drain King Sewer & Plumbing is a trusted name in sewer and plumbing. Our team of highly trained professionals can handle any general plumbing issues. Contact now for more details.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 72162,
      "approve_dt": "2021-06-25T00:00:00.000Z",
      "source": null,
      "submit_dt": "2021-06-23T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 519,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 13,
      "city_id": 5284,
      "ltop": "",
      "facebook": "https://drainkingofchicago.com/services/#",
      "tiktok": null,
      "linkedin": "https://drainkingofchicago.com/services/#",
      "twitter": "https://drainkingofchicago.com/services/#",
      "googleplus": "",
      "youtube_channel": "",
      "youtube": "",
      "youtube_title": null,
      "pinterest": "",
      "yelp": "",
      "foursquare": "",
      "instagram": "https://drainkingofchicago.com/services/#",
      "tripadvisor": null,
      "trustpilot": null,
      "blog_link": "",
      "ss_exchange": 0,
      "googlebot": null,
      "yahoobot": null,
      "msnbot": null,
      "author_id": null,
      "subcat_id": 5026,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": "png",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "95827d13-56da-11ed-b77c-b66e99367f32",
      "subdate": "Jun 23, 2021",
      "subcategory": "Plumbers",
      "request_types": "",
      "visitcount": 805
   },
   "visits": {
      "storefront": 805,
      "articles": 0,
      "videos": 0,
      "reviews": 27,
      "coupons": 0,
      "products": 0,
      "social": 3,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "As a veteran owned company, Drain King Sewer & Plumbing, Inc. makes available the most experienced, qualified personnel performing expert services for the businesses and homeowners of Chicago and surrounding areas.\n\nOur goal is to not only be the definitive sewer and plumbing service provider, but also a contributing member of our community, offering excellence in superior performance, creating lasting business relationships.",
      "service1": "Catch Basin Cleaning",
      "service2": " Grease Trap Cleaning",
      "service3": " Sewer Line Jetting",
      "service4": " Video Camera Inspection",
      "service5": " Private Drain Program",
      "service6": "",
      "service7": "",
      "submit_dt": "2021-06-23 08:25:12"
   },
   "location": {
      "uuid": "95827d13-56da-11ed-b77c-b66e99367f32",
      "link_id": 320970,
      "account_id": 72162,
      "company": "Drain King",
      "sid": 66,
      "country": 277,
      "countrycode": "US",
      "state": 13,
      "city": "5284",
      "zip": "60620",
      "address": "8524 South Racine Avenue",
      "phone": "773-238-4801",
      "fax": null,
      "email": "drainkingofchicago@outlook.com",
      "name": "Drain King",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "41.738759",
      "lon": "-87.6537589",
      "cityname": "Chicago",
      "statename": "Illinois"
   },
   "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": ""
}