Click to view page listings in map view
List View / Grid View
((WebAgencyID IN (608)) OR ((HeadWebAgencyID IS NOT NULL) AND ((HeadWebAgencyID) IN (608)))) AND ((StatusID & 70149) = 0) AND ((((TypeID & 1) > 0) AND ((NOT (SoldDate IS NOT NULL)) OR (DATEADD(ms, (CONVERT(BigInt,(CONVERT(Float,DaysAfterSold)) * 86400000)) % 86400000, DATEADD(day, (CONVERT(BigInt,(CONVERT(Float,DaysAfterSold)) * 86400000)) / 86400000, SoldDate)) >= GETDATE()))) OR (((TypeID & 6) > 0) AND ((NOT (DateLeased IS NOT NULL)) OR (DATEADD(ms, (CONVERT(BigInt,(CONVERT(Float,DaysAfterSold)) * 86400000)) % 86400000, DATEADD(day, (CONVERT(BigInt,(CONVERT(Float,DaysAfterSold)) * 86400000)) / 86400000, DateLeased)) >= GETDATE())))) AND ((TypeID & 2) > 0)
  • 2

  • 1

62b Ocean Beach Road, Tairua

$320.00

COOL COTTAGE

Beautiful views, 2 bedrooms, heat pump, good outside areas. Hardly any lawn so very low maintenance and close to main beach.

  • 6

  • 2

6B The Esplanade, Tairua

$380.00

BEACHSIDE LIVING

One house from the beach, well presented and laid out. 3 good side bedrooms, courtyard entertainment area, furnished. Good lock up and leave - just enjoy the lifestyle by the beach.

  • 2

  • 1

112E Ngatipu Place, Whangamata

$340.00

COMFORT ON NGATIPU

Just a skip from town. Nice 2 bedroom, furnished or unfurnished. Good sized bedrooms, fabulous outdoor entertainment and garden.