The Porch Kitchen and Bar

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 338130,
      "site_id": 6,
      "cat_id": 39,
      "priority": 2,
      "url": "https://theporchwaihibeach.co.nz/",
      "title": "The Porch Kitchen and Bar",
      "description": "Looking for a place to unwind and enjoy a refreshing drink in Waihi Beach? Look no further than The Porch, your ultimate destination for a laid-back bar experience with a stunning ocean view. Located in the heart of Waihi Beach, our bar offers a relaxed atmosphere where you can sip on delicious cocktails, craft beers, and fine wines while soaking in the beautiful surroundings. Whether you''re catching up with friends, enjoying a romantic date night, or simply taking a moment for yourself, The Porch is the perfect spot to relax and enjoy the coastal vibe. Join us at The Porch and let us elevate your Waihi Beach experience with our friendly service, handcrafted drinks, and unforgettable ambiance.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 88849,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-11-22T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 4,
      "referrals": null,
      "country": 200,
      "countrycode": "NZ",
      "loc_id": 200,
      "state_id": 0,
      "city_id": 940,
      "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": 281,
      "d_url": null,
      "approved": null,
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "633c8f70-a8ad-11ef-a909-b66e99367f32",
      "subdate": "Nov 22, 2024",
      "subcategory": "Restaurants",
      "request_types": "",
      "visitcount": 23
   },
   "visits": {
      "storefront": 23,
      "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": "",
      "service1": "",
      "service2": "",
      "service3": "",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2024-11-22 08:40:12"
   },
   "location": {
      "uuid": "633c8f70-a8ad-11ef-a909-b66e99367f32",
      "link_id": 338130,
      "account_id": 88849,
      "company": "The Porch Kitchen and Bar",
      "sid": 6,
      "country": 200,
      "countrycode": "NZ",
      "state": 0,
      "city": "940",
      "zip": "3611",
      "address": "23 Wilson Road, Waihi Beach 3611, New Zealand",
      "phone": "6478631330",
      "fax": null,
      "email": "theporchwaihi@gmail.com",
      "name": "The Porch Kitchen and Bar",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "-37.4122827",
      "lon": "175.9431485",
      "cityname": "Auckland",
      "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": ""
}