Australia's No.1 Private and Commercial Parking Website
priorityPostCodeList: 5000,5001,5800,5810,5839,5880,5888
secondaryList: 5885,5886,5000,5887,5001,5888,5005,5900,5901,5902,5903,5800,5904,5810,5920,5839,5942,5880,5950,5881,5882,5883,5884,5067,5071,5006,5031,5069,5033,5034,5035,5061,5063,5065,5068,5081,5007,5082,5070,5008,5083,5037
finalPostCodeList: 5000,5001,5800,5810,5839,5880,5888,5885,5886,5000,5887,5001,5888,5005,5900,5901,5902,5903,5800,5904,5810,5920,5839,5942,5880,5950,5881,5882,5883,5884,5067,5071,5006,5031,5069,5033,5034,5035,5061,5063,5065,5068,5081,5007,5082,5070,5008,5083,5037
open?
SELECT p.* FROM property p INNER JOIN customer c ON p.customerid = c.customerid AND c.archived IS NULL AND c.isDisabled = 0 WHERE LISTINGSTATUS = 'L'AND (p.expirydate IS NULL or p.expirydate > now()) AND highlightAdvertPosition = 0 AND p.ADDRESSPOSTCODE IN (5000,5001,5800,5810,5839,5880,5888,5885,5886,5000,5887,5001,5888,5005,5900,5901,5902,5903,5800,5904,5810,5920,5839,5942,5880,5950,5881,5882,5883,5884,5067,5071,5006,5031,5069,5033,5034,5035,5061,5063,5065,5068,5081,5007,5082,5070,5008,5083,5037) UNION SELECT p.* FROM property p INNER JOIN customer c ON p.customerid = c.customerid AND c.archived IS NULL WHERE p.listingStatus IN ('L')AND c.isDisabled = 0 AND highlightAdvertPosition > 0 AND (p.expirydate IS NULL or p.expirydate > now())AND p.addressstate RLIKE 'SA'ORDER BY highlightAdvertPosition DESC
Search Result
No Parking Spot Found