Dream Plumbing & Gas

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 345854,
      "site_id": 66,
      "cat_id": 78,
      "priority": 2,
      "url": "https://dreamplumbing.com.au/",
      "title": "Dream Plumbing & Gas",
      "description": "Dream Plumbing & Gas is your trusted local plumber, proudly serving the community with reliable, high-quality plumbing services. Based in the heart of the area, we specialise in everything from emergency repairs and blocked drains to hot water system installations and gas fitting. With years of hands-on experience and a commitment to excellence, our licensed plumbers provide prompt, professional solutions tailored to your needs. At Dream Plumbing & Gas, we believe in transparent pricing, honest advice, and doing the job right the first time. Whether youre dealing with a leaking tap or planning a bathroom renovation, were here to help  24/7. Locally owned and operated, we understand the unique plumbing challenges of our region and deliver services that are efficient, affordable, and built to last. When you need a dependable plumber who genuinely cares, choose Dream Plumbing & Gas  where your plumbing problems meet expert solutions.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 96549,
      "approve_dt": "2025-08-20T00:00:00.000Z",
      "source": null,
      "submit_dt": "2025-04-24T00: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": "4ef19687-20ca-11f0-a909-b66e99367f32",
      "subdate": "Apr 24, 2025",
      "subcategory": "Plumbers",
      "request_types": "",
      "visitcount": 36
   },
   "visits": {
      "storefront": 36,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 13,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Dream Plumbing is a trusted local plumbing service based in Hornsby, serving all Sydney areas with award-winning licensed plumbers ready to handle projects of any size, from small repairs to major renovations. With 24/7 emergency callout service and fully equipped teams offering upfront fixed quotes with no unexpected charges, they provide comprehensive plumbing solutions for domestic, business, and commercial clients, specializing in everything from basic maintenance to complete bathroom renovations and building fit-outs.",
      "service1": "Emergency plumbing and 24/7 callout service",
      "service2": " Blocked drain and pipe clearing with CCTV inspection",
      "service3": " Hot water system installation and repair including solar",
      "service4": " Roof and gutter maintenance and repairs",
      "service5": " Gas plumbing and sewerage services",
      "service6": " Bathroom renovations and building fit-outs",
      "service7": " Backflow prevention and high-pressure jetting",
      "submit_dt": "2025-04-24 05:09:32"
   },
   "location": {
      "uuid": "4ef19687-20ca-11f0-a909-b66e99367f32",
      "link_id": 345854,
      "account_id": 96549,
      "company": "Dream Plumbing & Gas",
      "sid": 66,
      "country": 77,
      "countrycode": "AU",
      "state": 0,
      "city": "1332",
      "zip": "2079",
      "address": "96 Beryl Ave, Mount Colah NSW 2079",
      "phone": "1300511936",
      "fax": null,
      "email": "info.dreamplumbing@gmail.com",
      "name": "Dream Plumbing & Gas",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "-33.6562264",
      "lon": "151.1150577",
      "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": ""
}