Plumber

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 337570,
      "site_id": 6,
      "cat_id": 39,
      "priority": 2,
      "url": "https://www.rooterplumbingchicago.com/",
      "title": "Plumber",
      "description": "",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 88295,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-10-31T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 2,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 13,
      "city_id": 5325,
      "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": "png",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "a98dd229-9770-11ef-ab46-b66e99367f32",
      "subdate": "Oct 31, 2024",
      "subcategory": "Home And Garden",
      "request_types": "",
      "visitcount": 9
   },
   "visits": {
      "storefront": 9,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 5,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Rooter Plumbing & Sewer is a licensed and insured plumbing company in Countryside, Illinois that repairs, replaces and maintains all types of plumbing issues. We have high skilled licensed plumbers, capable of performing heavy drain and sewer cleaning high-pressure jetting, video sewer lines, faucet repairs and replacements, leak detection and line location, back-flow installations, testing and repairs. We'll do everything everyone else won't touch. Licensed for new construction water services.",
      "service1": "repair, installation, emergency, drain, leak,sewer",
      "service2": "backflow testing, water heaters, camera inspection",
      "service3": "drain & sewer inspection, sewer cleaning, rodding",
      "service4": "new water system services, new construction sewer",
      "service5": "new construction water systems, drain, sewer, rod",
      "service6": "",
      "service7": "",
      "submit_dt": "2024-10-31 10:12:40"
   },
   "location": {
      "uuid": "a98dd229-9770-11ef-ab46-b66e99367f32",
      "link_id": 337570,
      "account_id": 88295,
      "company": "Rooter Plumbing & Sewer",
      "sid": 6,
      "country": 277,
      "countrycode": "US",
      "state": 13,
      "city": "5325",
      "zip": "60525",
      "address": "1424 W 55th Pl",
      "phone": "(708) 497-9757",
      "fax": null,
      "email": "rooterplumbingsewer@burst-email.com",
      "name": "Rooter Plumbing & Sewer",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "41.7891077",
      "lon": "-87.887656",
      "cityname": "Countryside",
      "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": ""
}