Real Estate For Rent

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

  • 1

B/39 Newcastle Street, Clyde

$375 per week

ONE BEDROOM PET FRIENDLY UNIT

A 1 bedroom, 1 bathroom unit on large easy care section with plenty of off street parking. Quiet and private back section. Close to shops and opposite park. Portable elements for cooking. Mostly unfurnished with Washi...