Click to view page listings in map view
List View / Grid View
((WebAgencyID IN (16)) OR ((HeadWebAgencyID IS NOT NULL) AND ((HeadWebAgencyID) IN (16)))) 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/107 Ware Drive, Currumbin Waters QLD

$2233.77 per Mth plus gst

SHOP FOR LEASE IN PRIME ARTERIAL ROAD SHOPPING CENTRE

Perfect for pizza shop, general retail, professional practice, solicitor, accountant, medical, florist, butcher, clothing, giftware, natural therapy or nearly any type of retail trader. FEATURES: - 75m2 - High volu...