Dr. Drain Cleaning Expert Drain Cleaning Services Boulder Colorado

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 309657,
      "site_id": 66,
      "cat_id": 78,
      "priority": 0,
      "url": "http://www.drdrainco.com",
      "title": "Dr. Drain Cleaning Expert Drain Cleaning Services Boulder Colorado",
      "description": "Dr. Drain is an established full service plumbing contractor offering a broad spectrum of services to homeowners and commercial property owners. We are known as the experts in our field using the latest in technology and best practices to get the job done successfully.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 60893,
      "approve_dt": "2015-08-04T00:00:00.000Z",
      "source": null,
      "submit_dt": "2015-06-05T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 2457,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 6,
      "city_id": 2729,
      "ltop": "",
      "facebook": "",
      "tiktok": "",
      "linkedin": "",
      "twitter": "",
      "googleplus": "",
      "youtube_channel": "",
      "youtube": "",
      "youtube_title": "",
      "pinterest": "",
      "yelp": "",
      "foursquare": "",
      "instagram": "",
      "tripadvisor": null,
      "trustpilot": null,
      "blog_link": "",
      "ss_exchange": 0,
      "googlebot": 0,
      "yahoobot": 0,
      "msnbot": 0,
      "author_id": 1801,
      "subcat_id": 5026,
      "d_url": "",
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "95491cea-56da-11ed-b77c-b66e99367f32",
      "subdate": "Jun 05, 2015",
      "subcategory": "Plumbers",
      "request_types": "",
      "visitcount": 3215
   },
   "visits": {
      "storefront": 3215,
      "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": "Cemented in Boulder County, Colorado, Dr. Drain serves as the go to business for emergency drain clogs and repairs. Keeping our service area small and specializing in only drains we are able to react and get the problem fixed quickly, and fixed right. We do drains PERIOD!\n\nBlockages\nUnfortunately these types of problems, stoppages, blockages and backups happen at the worst possible times. The Holidays are always a busy time for us rescuing homeowners that need drain cleaning, for clogged kitchen sinks, bathtubs and of course toilets.\n\nDrain Repair\nSlow drains? Clogged toilet? Do you smell sewer gas? When this problems occur it’s not fun, especially when you have company over. Don’t be shy we’ve seen it all and can handle all those nasty drain & sewer problems.\n\nCamera Inspection\nExpert sewer camera inspections. Great for both homeowners, buyers, and sellers. We inspect all sewer pipes both interior and exterior and provide both hard copy reporting and dvd’s for review.\n\nSecond Opinions\nPlumbing’s not always glorious. If you have a drain & sewer problem, reach out and let us know. New line replacement isn’t the only option. Give us a call. It could save you thousands of dollars and a ton of headaches. Call now.\n     ",
      "service1": "Dr. Drain is an established full service plumbing contractor offering Camer",
      "service2": " Drain Line Repair and Replacement",
      "service3": " Hydro Jetting",
      "service4": " Slow Drains",
      "service5": " Sewer Repairs",
      "service6": " Clean-outs Installed",
      "service7": " Rooter",
      "submit_dt": "2015-06-05 22:21:07"
   },
   "location": {
      "uuid": "95491cea-56da-11ed-b77c-b66e99367f32",
      "link_id": 309657,
      "account_id": 60893,
      "company": "Dr. Drain Cleaning",
      "sid": 66,
      "country": 277,
      "countrycode": "US",
      "state": 6,
      "city": "2729",
      "zip": "80301",
      "address": "5422 Baca Circle",
      "phone": "",
      "fax": "",
      "email": "JordanSpiegel@hotmail.com",
      "name": "Dr. Drain Cleaning",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "40.0731416",
      "lon": "-105.1897431",
      "cityname": "Boulder",
      "statename": "Colorado"
   },
   "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": ""
}