Drainbusters Plumbing

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 330951,
      "site_id": 66,
      "cat_id": 78,
      "priority": 2,
      "url": "http://www.drainbustersplumbingservices.com/",
      "title": "Drainbusters Plumbing",
      "description": "Drainbusters Plumbing",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 81752,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-05-19T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 12,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 1,
      "city_id": 302,
      "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": 5026,
      "d_url": null,
      "approved": null,
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "fd6eb620-15e7-11ef-8344-b66e99367f32",
      "subdate": "May 19, 2024",
      "subcategory": "Plumbers",
      "request_types": "",
      "visitcount": 83
   },
   "visits": {
      "storefront": 83,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 15,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Welcome to DrainBusters Plumbing, your premier emergency plumbing repair, installation, and drain cleaning service in Mobile, Alabama, and neighboring areas. Our professional plumbers are dedicated to providing same-day services, ensuring prompt resolution of your plumbing issues. From leaky pipes to clogged drains, we offer reliable solutions tailored to your needs.\r
\r
\"Who are you gonna call? When you have plumbing problems,\" trust DrainBusters Plumbing for all your plumbing needs.",
      "service1": "Plumbing repairs and installation",
      "service2": "Drain cleaning and clog removal",
      "service3": "Drain repairs and installation",
      "service4": "Water heater service",
      "service5": "repair and installation, Pump service, repair and installation",
      "service6": "",
      "service7": "",
      "submit_dt": "2024-05-19 13:59:20"
   },
   "location": {
      "uuid": "fd6eb620-15e7-11ef-8344-b66e99367f32",
      "link_id": 330951,
      "account_id": 81752,
      "company": "Drainbusters Plumbing",
      "sid": 66,
      "country": 277,
      "countrycode": "US",
      "state": 1,
      "city": "302",
      "zip": "36608",
      "address": "701-A Schillinger Road North",
      "phone": "251-370-6549",
      "fax": null,
      "email": "drainbusters@brite-mail.com",
      "name": "Drainbusters Plumbing",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "30.7055104",
      "lon": "-88.2259102",
      "cityname": "Mobile",
      "statename": "Alabama"
   },
   "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": ""
}