Australia's No.1 Private and Commercial Parking Website
priorityPostCodeList: 6000
secondaryList: 6837,6838,6839,6840,6841,6000,6842,6001,6843,6905,6003,6800,6844,6803,6845,6809,6846,6817,6847,6820,6848,6827,6849,6830,6850,6831,6865,6832,6892,6004,6900,6901,6902,6903,6906,6005,6006,6929,6007,6050,6872,6051,6944,6945,6090,6951,6100,6979,6151,6931,6052,6904,6915,6008,6932,6016,6940,6060,6103,6913,6014,6937,6938,6939
finalPostCodeList: 6000,6837,6838,6839,6840,6841,6000,6842,6001,6843,6905,6003,6800,6844,6803,6845,6809,6846,6817,6847,6820,6848,6827,6849,6830,6850,6831,6865,6832,6892,6004,6900,6901,6902,6903,6906,6005,6006,6929,6007,6050,6872,6051,6944,6945,6090,6951,6100,6979,6151,6931,6052,6904,6915,6008,6932,6016,6940,6060,6103,6913,6014,6937,6938,6939
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 (6000,6837,6838,6839,6840,6841,6000,6842,6001,6843,6905,6003,6800,6844,6803,6845,6809,6846,6817,6847,6820,6848,6827,6849,6830,6850,6831,6865,6832,6892,6004,6900,6901,6902,6903,6906,6005,6006,6929,6007,6050,6872,6051,6944,6945,6090,6951,6100,6979,6151,6931,6052,6904,6915,6008,6932,6016,6940,6060,6103,6913,6014,6937,6938,6939) 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 'WA|WA'ORDER BY highlightAdvertPosition DESC
Search Result
No Parking Spot Found