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