Hastings
Click to view page listings in map view
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)
  • 3

  • 1

  • 1

500a Miller Street, Parkvale

$480 per week

MOVE TO MILLER!

This spacious home has the wow factor and features all the bells and whistles. It has recently undergone a renovation and is presented to the highest of standards - everything is immaculate! The home has three g...

  • 3

  • 2

  • 2

3a Duart Road, Havelock North

$690 per week

DELIGHTFUL ON DUART

A modern, low maintenance townhouse in the heart of Havelock North Village. 2 Generous upstairs bedrooms with their own bathrooms and impressive views. Bi-fold doors open out from the lounge to the private entertainm...