Hero Plumbing

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 346245,
      "site_id": 66,
      "cat_id": 78,
      "priority": 2,
      "url": "https://www.heroplumbing.com.au/",
      "title": "Hero Plumbing",
      "description": "Looking for a reliable plumber? Hero Plumbing is your go-to expert for fast, friendly, and professional plumbing services. Based locally, we offer 24/7 emergency plumbing, hot water system repairs, blocked drain solutions, gas fitting, leak detection, and much more. Our licensed and experienced plumbers are dedicated to delivering quality workmanship with upfront pricing and no hidden costs.Whether its a small leak or a major plumbing issue, Hero Plumbing arrives on time, fully equipped, and ready to get the job done right the first time. We pride ourselves on honest service, clear communication, and long-lasting results.Servicing residential and commercial properties across Sydney, Hero Plumbing is committed to customer satisfaction and peace of mind. Call us today for prompt and dependable plumbing solutions from a team that truly cares.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 96940,
      "approve_dt": "2025-08-16T00:00:00.000Z",
      "source": null,
      "submit_dt": "2025-05-01T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 1,
      "referrals": null,
      "country": 77,
      "countrycode": "AU",
      "loc_id": 77,
      "state_id": 0,
      "city_id": 1332,
      "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": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "8683749b-267b-11f0-a909-b66e99367f32",
      "subdate": "May 01, 2025",
      "subcategory": "Plumbers",
      "request_types": "",
      "visitcount": 50
   },
   "visits": {
      "storefront": 50,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 8,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Hero Plumbing is Sydney's trusted professional plumbing service providing comprehensive solutions for residential, commercial, and industrial clients throughout the Sydney area. Our expert team of master plumbers operates fully stocked vehicles around the clock, ensuring prompt and efficient service for any plumbing emergency or routine maintenance needs. With transparent upfront pricing, no hidden fees, and a commitment to the highest standards of workmanship, we aim to delight customers with outstanding service whether it's a small repair or major installation project.",
      "service1": "24/7 emergency plumbing services",
      "service2": " blocked drain clearing",
      "service3": " hot water system repairs",
      "service4": " gas fitting and installations",
      "service5": " residential and commercial plumbing",
      "service6": " strata plumbing solutions",
      "service7": " appliance installations",
      "submit_dt": "2025-05-01 11:00:42"
   },
   "location": {
      "uuid": "8683749b-267b-11f0-a909-b66e99367f32",
      "link_id": 346245,
      "account_id": 96940,
      "company": "Hero Plumbing",
      "sid": 66,
      "country": 77,
      "countrycode": "AU",
      "state": 0,
      "city": "1332",
      "zip": "2161",
      "address": "3 Dursley Rd, Yennora",
      "phone": "1300031096",
      "fax": null,
      "email": "info.heroplumbing@gmail.com",
      "name": "Hero Plumbing",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "-33.8581714",
      "lon": "150.9596526",
      "cityname": "Sydney, NSW",
      "statename": ""
   },
   "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": ""
}