Dirty Plumber Reno

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 347045,
      "site_id": 66,
      "cat_id": 78,
      "priority": 2,
      "url": "https://dirtyplumberreno.com",
      "title": "Dirty Plumber Reno",
      "description": "Dirty Plumber has been serving the Reno/Sparks and surrounding Washoe County community since 2004, starting as Dr. Plumber before embracing our unique identity in 2012. As members of Plumbers Union 350, our dedicated team of skilled craftsmen is deeply rooted in the local community, specializing in water heating solutions including tankless water heaters, energy-efficient boilers, and hybrid systems while delivering honest, fair service and quality plumbing work that stands the test of time.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 97740,
      "approve_dt": "2025-07-28T00:00:00.000Z",
      "source": null,
      "submit_dt": "2025-05-16T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 2,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 27,
      "city_id": 13798,
      "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": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": "png",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "9ee6fdfc-3256-11f0-a909-b66e99367f32",
      "subdate": "May 16, 2025",
      "subcategory": "Plumbers",
      "request_types": "",
      "visitcount": 28
   },
   "visits": {
      "storefront": 28,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 7,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Dirty Plumber Reno has been serving Reno, Sparks, Incline Village and Washoe County's surrounding areas since 2004. All of our plumbers are skilled and trained to give you the best service possible. We install tank, tankless, boilers and hybrid tankless/boilers; we are your hot water specialist. Our team provides residential and commercial services. If it's hot water you need let us take care of your needs. If it is replacing your old tank water heater with a new tank or upgrading to a new energy efficient tankless let us install what would be best for your hot water needs. Quality and Integrity you can trust and depend on for all your plumbing needs.",
      "service1": "tankless water heater installation and service",
      "service2": " energy-efficient boiler systems installation",
      "service3": " hybrid water heating system setup",
      "service4": " tank water heater repair and replacement",
      "service5": " up-to-code plumbing installation and maintenance",
      "service6": " comprehensive plumbing repair and troubleshooting",
      "service7": " personalized plumbing consultation and system recommendations",
      "submit_dt": "2025-05-16 13:06:46"
   },
   "location": {
      "uuid": "9ee6fdfc-3256-11f0-a909-b66e99367f32",
      "link_id": 347045,
      "account_id": 97740,
      "company": "Dirty Plumber Reno",
      "sid": 66,
      "country": 277,
      "countrycode": "US",
      "state": 27,
      "city": "13798",
      "zip": "89509",
      "address": "635 Hunter Lake",
      "phone": "(775) 333-9880",
      "fax": null,
      "email": "dirtyplumbernv@burst-email.com",
      "name": "Dirty Plumber Reno",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "39.5149558",
      "lon": "-119.8360489",
      "cityname": "Reno",
      "statename": "Nevada"
   },
   "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": ""
}