YOUR ONE-STOP PLUMBING SHOP

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 352715,
      "site_id": 76,
      "cat_id": 11,
      "priority": 0,
      "url": "https://borehamplumbing.kiwi/",
      "title": "YOUR ONE-STOP PLUMBING SHOP",
      "description": "Serving residential and commercial clients throughout West Auckland, skilled local plumbers handle repairs, maintenance, and plumbing upgrades with care and precision. The focus remains on dependable service, clear communication, and cost-effective solutions designed to keep plumbing systems running smoothly.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 103465,
      "approve_dt": "2026-04-17T00:00:00.000Z",
      "source": null,
      "submit_dt": "2026-04-17T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 0,
      "referrals": null,
      "country": null,
      "countrycode": null,
      "loc_id": null,
      "state_id": null,
      "city_id": null,
      "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": 5877,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "30e82222-3a47-11f1-bb42-b66e99367f32",
      "subdate": "Apr 17, 2026",
      "subcategory": "Plumbers",
      "request_types": "",
      "visitcount": 2
   },
   "visits": {
      "storefront": 2,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 0,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Serving residential and commercial clients throughout West Auckland, skilled local plumbers handle repairs, maintenance, and plumbing upgrades with care and precision. The focus remains on dependable service, clear communication, and cost-effective solutions designed to keep plumbing systems running smoothly.",
      "service1": "24/7 Plumber Auckland",
      "service2": "Emergency Plumber In Auckland",
      "service3": "Local Plumbers In West Auckland",
      "service4": "Plumbers In West Auckland",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2026-04-17 10:21:26"
   },
   "location": {
      "uuid": "30e82222-3a47-11f1-bb42-b66e99367f32",
      "link_id": 352715,
      "account_id": 103465,
      "company": "Boreham  Plumbing",
      "sid": 76,
      "country": 200,
      "countrycode": "NZ",
      "state": 0,
      "city": "940",
      "zip": "0612",
      "address": "67 Turanga Road",
      "phone": "027 2525 438",
      "fax": null,
      "email": "borehamplumbing@protonmail.com",
      "name": "YOUR ONE-STOP PLUMBING SHOP",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": null,
      "lon": null,
      "cityname": "Auckland",
      "statename": ""
   },
   "socialmedia": [
      {
         "title": "Facebook",
         "ptype_id": 29,
         "dbtable": "links_socialmedia",
         "item": "Facebook",
         "cnt": null
      },
      {
         "title": "Instagram",
         "ptype_id": 30,
         "dbtable": "links_socialmedia",
         "item": "Instagram",
         "cnt": null
      },
      {
         "title": "Youtube",
         "ptype_id": 31,
         "dbtable": "links_socialmedia",
         "item": "Youtube Video",
         "cnt": null
      },
      {
         "title": "LinkedIn",
         "ptype_id": 32,
         "dbtable": "links_socialmedia",
         "item": "LinkedIn",
         "cnt": null
      },
      {
         "title": "TikTok",
         "ptype_id": 33,
         "dbtable": "links_socialmedia",
         "item": "TikTok",
         "cnt": null
      },
      {
         "title": "Twitter",
         "ptype_id": 34,
         "dbtable": "links_socialmedia",
         "item": "Twitter",
         "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": ""
}