Hastings
Click to view page listings in map view
Hold down CTRL key to select multiple suburbs
List View / Grid View
((WebAgencyID IN (657)) OR ((HeadWebAgencyID IS NOT NULL) AND ((HeadWebAgencyID) IN (657)))) 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

  • 1

0 Kopanga Heights Lane, Havelock North

$500 per week

FULLY FURNISHED EXECUTIVE APARTMENT

Two bedroom, fully furnished upstairs apartment with study. Single garage with auto door opener, single dishdrawer, gas cooktop, electric oven, shower over bath. *Gardens and lawns will be maintained by landlord. ...