The Prince of Drains

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 349547,
      "site_id": 66,
      "cat_id": 78,
      "priority": 0,
      "url": "https://theprinceofdrains.com.au/",
      "title": "The Prince of Drains",
      "description": "Melbourne neighbours! We’re The Prince of Drains, your friendly local experts in keeping your drains and plumbing in tip-top shape. From Melbourne Brunswick, St Albans, Werribee, and Melton, we’ve got you covered with top-notch services like unblocking tricky drains, high-pressure jetting, and super-smart CCTV inspections to get to the root of the problem. Got a stubborn sewer issue or tree roots causing chaos? We offer trenchless repairs, drain relining, and precise excavations to fix it fast. We’re all about honest prices, quality work, and making sure you’re smiling when we’re done. Whether it’s a small clog or a big plumbing headache, we’ll sort it out with care and speed. Give us a call today, and let’s get your pipes flowing smoothly.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 100242,
      "approve_dt": "2025-07-23T00:00:00.000Z",
      "source": null,
      "submit_dt": "2025-07-23T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 0,
      "referrals": null,
      "country": 77,
      "countrycode": "AU",
      "loc_id": 77,
      "state_id": 0,
      "city_id": 0,
      "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": 5033,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": "png",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "03aea438-67cb-11f0-a909-b66e99367f32",
      "subdate": "Jul 23, 2025",
      "subcategory": "Local Plumber",
      "request_types": "",
      "visitcount": 31
   },
   "visits": {
      "storefront": 31,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 15,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "The Prince of Drains is a professional plumbing company in Melbourne offering 24/7 emergency services with fully qualified and insured plumbers. They provide first-class plumbing solutions with fast response times and expertise to handle all residential and commercial plumbing requirements throughout Melbourne.",
      "service1": "Drain Pipe Relining melbourne",
      "service2": "trenchless sewer repairs Melbourne",
      "service3": "tree root removal services",
      "service4": "Blocked drain plumber Melbourne",
      "service5": "cctv drain inspection melbourne",
      "service6": "drain jetting services Melbourne",
      "service7": "Emergency Plumbing in melbourne",
      "submit_dt": "2025-07-23 13:43:28"
   },
   "location": {
      "uuid": "03aea438-67cb-11f0-a909-b66e99367f32",
      "link_id": 349547,
      "account_id": 100242,
      "company": "The Prince of  Drains",
      "sid": 66,
      "country": 77,
      "countrycode": "AU",
      "state": 0,
      "city": "0",
      "zip": "3032",
      "address": "33 Mitchell St, Maribyrnong VIC 3032",
      "phone": "+61493112457",
      "fax": null,
      "email": "theprinceofdrains@proton.me",
      "name": "The Prince of Drains",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": null,
      "lon": null,
      "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": ""
}