Mr. Rooter Plumbing of Wichita, KS

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 329721,
      "site_id": 66,
      "cat_id": 78,
      "priority": 2,
      "url": "https://www.mrrooter.com/wichita/",
      "title": "Mr. Rooter Plumbing of Wichita, KS",
      "description": "                    ",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 80534,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-04-07T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 26,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 16,
      "city_id": 8546,
      "ltop": "",
      "facebook": "https://www.facebook.com/Mr-Rooter-Plumbing-of-Wichita-KS-141268129281852/",
      "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": 5006,
      "d_url": null,
      "approved": null,
      "logo_ext": "png",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "376b8bdc-f4e5-11ee-8344-b66e99367f32",
      "subdate": "Apr 07, 2024",
      "subcategory": "Commercial Plumbing",
      "request_types": "",
      "visitcount": 103
   },
   "visits": {
      "storefront": 103,
      "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": "Mr. Rooter Plumbing of Wichita, KS. is a trusted plumbing company that addresses many residential and commercial plumbing concerns. Our experts are licensed, insured, and experienced to handle repair issues of any size or complexity. Our courteous and reliable service is backed by the Neighborly Done Right Promise - if it's not done right, we promise to make it right. By providing upfront, flat-rate pricing with no overtime charges, we earn the trust that communities expect.",
      "service1": "Plumbing Repair & Service",
      "service2": "",
      "service3": "",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2024-04-07 13:46:20"
   },
   "location": {
      "uuid": "376b8bdc-f4e5-11ee-8344-b66e99367f32",
      "link_id": 329721,
      "account_id": 80534,
      "company": "Mr. Rooter Plumbing of Wichita, KS",
      "sid": 66,
      "country": 277,
      "countrycode": "US",
      "state": 16,
      "city": "8546",
      "zip": "67202",
      "address": "922 E Central Ave",
      "phone": "(316) 202-3835",
      "fax": null,
      "email": "mrrooterplumbingw@mail-burst.com",
      "name": "Mr. Rooter Plumbing of Wichita, KS",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "37.6938791",
      "lon": "-97.3267038",
      "cityname": "Wichita",
      "statename": "Kansas"
   },
   "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": ""
}