Pipe Relining Sydney - Sherlock Drains

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 325336,
      "site_id": 66,
      "cat_id": 78,
      "priority": 2,
      "url": "https://sherlockdrains.com.au/pipe-relining-sydney/",
      "title": "Pipe Relining Sydney - Sherlock Drains",
      "description": "In the world of pipe relining Sydney, Sherlock Drains is the detective you need to solve your plumbing mysteries. Like a needle in a haystack, we''ll find and fix any issues with your pipes, ensuring a smooth water flow in Sydney and beyond. With our innovative pipe relining technology, we eliminate the need for costly and disruptive excavation. Our experts will reline your pipes with durable epoxy resin, creating a strong, long-lasting barrier against leaks and corrosion. Trust Sherlock Drains to handle your pipe relining needs with precision and expertise. Don''t let your plumbing go down the drain, contact us today for a reliable solution.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 76289,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2023-07-12T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 4,
      "referrals": null,
      "country": 77,
      "countrycode": "AU",
      "loc_id": 77,
      "state_id": 0,
      "city_id": 36,
      "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": 5030,
      "d_url": null,
      "approved": null,
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "ef31312c-2086-11ee-8344-b66e99367f32",
      "subdate": "Jul 12, 2023",
      "subcategory": "Plumber Tools",
      "request_types": "",
      "visitcount": 14
   },
   "visits": {
      "storefront": 14,
      "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": "",
      "service1": "",
      "service2": "",
      "service3": "",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2023-07-12 07:37:20"
   },
   "location": {
      "uuid": "ef31312c-2086-11ee-8344-b66e99367f32",
      "link_id": 325336,
      "account_id": 76289,
      "company": "Pipe Relining Sydney - Sherlock Drains",
      "sid": 66,
      "country": 77,
      "countrycode": "AU",
      "state": 0,
      "city": "36",
      "zip": "2229",
      "address": "8/26-28 Wallumatta Road",
      "phone": "0480 009 581",
      "fax": null,
      "email": "sherlockdrainsaus@gmail.com",
      "name": "Pipe Relining Sydney - Sherlock Drains",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "-34.0433985",
      "lon": "151.1321658",
      "cityname": "Sydney",
      "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": ""
}