Afterhours Plumbing & Drainage Services

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 339088,
      "site_id": 66,
      "cat_id": 78,
      "priority": 2,
      "url": "https://afterhoursplumbingco.com/",
      "title": "Afterhours Plumbing & Drainage Services",
      "description": "AfterHours Plumbing & Drainage Services was built on a foundation of excellence and integrity. With years of industry experience, our founders saw the need for a plumbing company that places customer satisfaction and top-notch service at the forefront. Today, we are proud to be a trusted name in the community, recognized for our expertise and dedication to our clients.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 89797,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-12-11T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 1,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 6,
      "city_id": 2896,
      "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": 5033,
      "d_url": null,
      "approved": null,
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "348a011d-b7e3-11ef-a909-b66e99367f32",
      "subdate": "Dec 11, 2024",
      "subcategory": "Local Plumber",
      "request_types": "",
      "visitcount": 33
   },
   "visits": {
      "storefront": 33,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 14,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "AfterHours Plumbing&Drainage Services offers reliable, 24/7 emergency plumbing services in Denver area for unexpected issues like pipe repair, drain unclogging, and gas leak repair. Our dedicated team is committed to fast, effective service to protect your home and restore your peace of mind. No matter the time of day, you can count on us for professional, best plumbing services that get your system back in working order quickly and efficiently. We're here when you need us most.\r
",
      "service1": "After Hours Plumber",
      "service2": "Emergency Plumbing",
      "service3": "24/7 Plumbing Services",
      "service4": "Plumbing Services",
      "service5": "Drainage Services",
      "service6": "Residential Plumbing",
      "service7": "Commercial Plumbing",
      "submit_dt": "2024-12-11 17:13:13"
   },
   "location": {
      "uuid": "348a011d-b7e3-11ef-a909-b66e99367f32",
      "link_id": 339088,
      "account_id": 89797,
      "company": "Afterhours Plumbing & Drainage Services",
      "sid": 66,
      "country": 277,
      "countrycode": "US",
      "state": 6,
      "city": "2896",
      "zip": "80127",
      "address": "5736 S. Pierson St.",
      "phone": "7206870052",
      "fax": null,
      "email": "afterhoursplumbingdenver@gmail.com",
      "name": "Afterhours Plumbing & Drainage Services",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "39.6118788",
      "lon": "-105.1227885",
      "cityname": "Littleton",
      "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": ""
}