ASHEVILLE WATER HEATERS LLC

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 319557,
      "site_id": 66,
      "cat_id": 78,
      "priority": 2,
      "url": "http://ashevillewaterheaters.com",
      "title": "ASHEVILLE WATER HEATERS LLC",
      "description": "An experienced plumbing professional, Carl has dedicated his life to learning the diagnostic and technical skills needed to solve and repair even the most complex plumbing problems.\r\nWith certificates of advanced training in water filtration, plumbing safety codes and high tech tankless water heater repair, Carl and our team personally strive to exceed expectations by ensuring that all plumbing work is completed to the highest standards. ",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 70751,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2020-08-08T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 148,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 32,
      "city_id": 15686,
      "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": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "957af5a1-56da-11ed-b77c-b66e99367f32",
      "subdate": "Aug 08, 2020",
      "subcategory": "General Plumbing",
      "request_types": "",
      "visitcount": 210
   },
   "visits": {
      "storefront": 210,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 11,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "We are a small company, locally owned by Licensed Master Plumber Carl Dordelman, North Carolina UNLIMITED PLUMBING CONTRACTOR'S LICENSE #29134.\r\nCarl has 22 years experience in the plumbing business and has served the greater Asheville Area since 2004.  If you have lived in Buncombe or Henderson County in the last 20 years, there is a good chance you have had Carl work in your home or business before! ",
      "service1": "plumbing repair",
      "service2": "water heater install",
      "service3": "water heater repair",
      "service4": "plumbing company",
      "service5": "plumber",
      "service6": "",
      "service7": "",
      "submit_dt": "2020-08-08 05:53:39"
   },
   "location": {
      "uuid": "957af5a1-56da-11ed-b77c-b66e99367f32",
      "link_id": 319557,
      "account_id": 70751,
      "company": "ASHEVILLE WATER HEATERS LLC",
      "sid": 66,
      "country": 277,
      "countrycode": "US",
      "state": 32,
      "city": "15686",
      "zip": "28805",
      "address": "407 HAW CREEK MEWS DR",
      "phone": "828-589-9608",
      "fax": null,
      "email": "ashevillewaterheaters@outlook.com",
      "name": "ASHEVILLE WATER HEATERS LLC",
      "status": "hide",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "35.5923541",
      "lon": "-82.5022049",
      "cityname": "Asheville",
      "statename": "North Carolina"
   },
   "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": ""
}