Campbell Plumbing and Drain Cleaning

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 317173,
      "site_id": 66,
      "cat_id": 78,
      "priority": 2,
      "url": "https://www.campbellplumbing.net/mentor/",
      "title": " Campbell Plumbing and Drain Cleaning",
      "description": "                                                                                                                                                                                 ",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 68371,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2019-06-03T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": 1,
      "clickcount": 144,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 0,
      "city_id": 0,
      "ltop": "",
      "facebook": "https://www.facebook.com/Campbell-Plumbing-Drain-Cleaning-596767377002440/",
      "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": 5026,
      "d_url": null,
      "approved": null,
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "956e534c-56da-11ed-b77c-b66e99367f32",
      "subdate": "Jun 03, 2019",
      "subcategory": "Plumbers",
      "request_types": "",
      "visitcount": 190
   },
   "visits": {
      "storefront": 190,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 1,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "If faced with a plumbing concern, call the professionals at Campbell Plumbing! Whenever you call, you will can talk directly to an expert plumber who can help you in identifying the cause of your concern. When we do visit, the plumber will be quick, respectful, punctual and clean! We also consider in offering fair, upfront costing.\r\n\r\nThere is no job too small that we can't help with. Regardless if it is handling or replacing your water heater, unfreezing a frozen pipe, leakage detection, or hydro jetting, our greatly trained and professional team can help you! We have been greatly providing for the Mentor area from 1985. Get in touch with us today to find out for yourself why we have earned a 5 star recognition and multiple year Angie's List Super Service Award receiver!",
      "service1": "Plumbers",
      "service2": "Plumbing",
      "service3": "Plumber",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2019-06-04 00:15:39"
   },
   "location": {
      "uuid": "956e534c-56da-11ed-b77c-b66e99367f32",
      "link_id": 317173,
      "account_id": 68371,
      "company": " Campbell Plumbing and Drain Cleaning",
      "sid": 66,
      "country": 277,
      "countrycode": "US",
      "state": 0,
      "city": "",
      "zip": "",
      "address": "7575 Tyler Boulevard Suite# 52 Mentor OH 44060 ",
      "phone": "4409537970",
      "fax": null,
      "email": "campbellplumbingohio@gmail.com",
      "name": " Campbell Plumbing and Drain Cleaning",
      "status": "hide",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "41.6677801",
      "lon": "-81.3722484"
   },
   "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": ""
}