Real Estate For Rent

List View / Grid View
((WebAgencyID IN (371)) OR ((HeadWebAgencyID IS NOT NULL) AND ((HeadWebAgencyID) IN (371)))) 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)
  • 5

  • 3

  • 2

B/37 Sheehan Avenue, Papakura

$760 per week

Excellent 5 bedroom, 3 bathroom Standalone House

Under Contract so NO Viewings available Near New Immaculate two storey home, built with solid Brick and weatherboard. 5 good size bedrooms, 3 bathrooms, Internal Garage plus many other modern features. Fully fenced b...