Drain Terrier

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 327059,
      "site_id": 66,
      "cat_id": 78,
      "priority": 2,
      "url": "https://drainterrier.com",
      "title": "Drain Terrier",
      "description": "https://drainterrier.com/ : Drain Terrier LLC is a family-owned and operated company with more than 30 years of experience in plumbing and drains, providing high-quality plumbing repair and drain cleaning service in Denver, Wheat Ridge & Littleton CO 24/7. We strive to earn repeat customers, which is what drives us to provide the best customer service possible. We also offer emergency plumbing repairs and drain cleaning services. We are available for all your plumbing needs. Our team of licensed plumbers offers 24/7 emergency plumbing services. We are your local plumbing company offering fast response times, affordable pricing, and friendly customer service. We are committed to providing excellent customer service and we will always strive to provide prompt and quality services. For more details on our plumbing and drain cleaning services, call us on (720) 999-6120 . 3820 Quay St, Wheat Ridge, CO 80033",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 77920,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2023-12-20T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 26,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 6,
      "city_id": 3037,
      "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": 5018,
      "d_url": null,
      "approved": null,
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "13d28d16-9eec-11ee-8344-b66e99367f32",
      "subdate": "Dec 20, 2023",
      "subcategory": "General Plumbing",
      "request_types": "",
      "visitcount": 58
   },
   "visits": {
      "storefront": 58,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 2,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "https://drainterrier.com/ : Drain Terrier LLC is a family-owned and operated company with more than 30 years of experience in plumbing and drains, providing high-quality plumbing repair and drain cleaning service in Denver, Wheat Ridge&Littleton CO 24/7. We strive to earn repeat customers, which is what drives us to provide the best customer service possible. We also offer emergency plumbing repairs and drain cleaning services. We are available for all your plumbing needs. Our team of licensed plumbers offers 24/7 emergency plumbing services. We are your local plumbing company offering fast response times, affordable pricing, and friendly customer service. We are committed to providing excellent customer service and we will always strive to provide prompt and quality services. For more details on our plumbing and drain cleaning services, call us on (720) 999-6120 . \r
3820 Quay St, Wheat Ridge, CO 80033",
      "service1": "",
      "service2": "",
      "service3": "",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2023-12-20 03:58:47"
   },
   "location": {
      "uuid": "13d28d16-9eec-11ee-8344-b66e99367f32",
      "link_id": 327059,
      "account_id": 77920,
      "company": "Drain Terrier",
      "sid": 66,
      "country": 277,
      "countrycode": "US",
      "state": 6,
      "city": "3037",
      "zip": "80033",
      "address": "3820 Quay St,",
      "phone": "(720) 999-6120",
      "fax": null,
      "email": "drainterrier1@gmail.com",
      "name": "Drain Terrier",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "39.7699787",
      "lon": "-105.0729803",
      "cityname": "Wheat Ridge",
      "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": ""
}