Smedley Plumbing

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 336611,
      "site_id": 76,
      "cat_id": 11,
      "priority": 2,
      "url": "https://callsmedley.com/",
      "title": "Smedley Plumbing",
      "description": "",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 87344,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-10-10T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 9,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 0,
      "city_id": 0,
      "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": 5877,
      "d_url": null,
      "approved": null,
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "7b43517c-86fd-11ef-ab46-b66e99367f32",
      "subdate": "Oct 10, 2024",
      "subcategory": "Plumbers",
      "request_types": "",
      "visitcount": 31
   },
   "visits": {
      "storefront": 31,
      "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": "We offer plumbing repair and replacement services for Blue Springs, Lee's Summit, Independence, Grain Valley and surrounding areas. We are fully prepared for any clogged drain, water heater, sump pump, pipe leak, bathtub, shower, faucet, hose bib, flood, freeze, or any other plumbing issue you may have. Our 10,000 hour guarantee means we guarantee any plumber we send diagnose your plumbing repairs satisfies that criteria. Our promise to you is that master-level plumbers are solving your problems",
      "service1": "Water Heater Repair and Replacement",
      "service2": "Faucets & Toilets",
      "service3": "Clogged Drains",
      "service4": "Gas Pipes",
      "service5": "Sump Pumps",
      "service6": "",
      "service7": "",
      "submit_dt": "2024-10-10 11:47:52"
   },
   "location": {
      "uuid": "7b43517c-86fd-11ef-ab46-b66e99367f32",
      "link_id": 336611,
      "account_id": 87344,
      "company": "",
      "sid": 76,
      "country": 277,
      "countrycode": "US",
      "state": 0,
      "city": "0",
      "zip": "64014-4801",
      "address": "651 NE Jefferson, Suite 6, Blue Springs, Missouri",
      "phone": "(816) 763-3539",
      "fax": null,
      "email": "callsmedleyplumb@mail-burst.com",
      "name": "",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "39.0289279",
      "lon": "-94.2542567",
      "cityname": "",
      "statename": ""
   },
   "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": ""
}