Australia's No.1 Private and Commercial Parking Website

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.LISTINGTYPE = 'M'AND (p.expirydate IS NULL or p.expirydate > now()) AND highlightAdvertPosition = 0 AND p.ADDRESSPOSTCODE IN (2444,2529,2580,2601,3032,3152,3207,4000,4001,4002,4006,4007,4029,4053,4101,4106,4114,4169,4214,4350,4500,4700,4870,5000,6000,6015,9000,9001,9002,9003,9005,9007,9008,9009,9010,9013,9015,9016,9017,9018,9019,9020,9021,9022,9023,2444,1930,1929,2529,2580,2600,2589,2601,2608,2610,299,298,297,296,295,294,293,291,221,200,3032,3152,3207,8873,4000,4001,4002,4003,4004,9000,9001,9002,9003,9005,9007,9008,9009,9010,9013,9015,9016,9017,9018,9019,9020,9021,9022,9023,4053,4106,4114,4214,4350,4353,4363,4364,4365,4500,4700,4711,4870,5000,5001,5005,5800,5810,5839,5880,5881,5882,5883,5884,5885,5886,5887,5888,5900,5901,5902,5903,5904,5920,5942,5950,6000,6001,6003,6800,6803,6809,6817,6820,6827,6830,6831,6832,6837,6838,6839,6840,6841,6842,6843,6844,6845,6846,6847,6848,6849,6850,6865,6905,6015,3039,6004,6892,2612,3031,3040,3050,3010,3008,3005,3001,3000,8001,8003,8004,8005,8006,8007,8008,8009,8010,8045,8051,8060,8061,8066,8069,8070,8071,8100,8101,8102,8103,8107,8108,8111,8120,8205,8383,8386,8388,8390,8393,8394,8396,8399,4005,4006,4059,4064,4101,4169,4075,4108,4117,5006,5031,5067,5071,6005,6006,6007,6050,6872,6900,6901,6902,6903,6906,6929,3011,3034,3055,3133,3179,3180,3206,3205,3015,3006,8865,4066,4072,4102,4171,4054,4107,4131,4215,5033,5034,5035,5061,5063,5065,5069,6051,6090,6100,6151,6931,6944,6945,6951,6979,6010,6019,6910,6922,2602,3019,3013,3012,3051,3052,8500,3150,3016,3004,4010,4029,4030,4060,4065,4067,4011,4031,4012,4013,4172,9464,4068,4073,4112,4119,4127,4132,4121,4037,4501,5007,5068,5081,5082,6008,6016,6052,6904,6915,6932,2528,2603,3003,3033,3041,3044,3054,3056,8538,3135,3132,3153,3155,3141,3065,3053,3002,8002,8507,8557,4007,4051,4103,4104,4120,4151,4170,4009,4032,4035,4055,4105,4111,4116,4152,4217,9726,9728,9729,4502,5008,5037,5070,5083,6014,6060,6103,6913,6937,6938,6939,6940,6017,6018,6916,6917,6918,6921) 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 p.LISTINGTYPE = 'M'AND c.isDisabled = 0 AND highlightAdvertPosition > 0 AND (p.expirydate IS NULL or p.expirydate > now())AND p.addressstate RLIKE 'ACT|NSW|VIC|QLD|SA|WA'ORDER BY highlightAdvertPosition DESC