Australia's No.1 Private and Commercial Parking Website
finalPostCodeList: 1231,1232,1233,1234,1416,1419,1797,2000,2008,2031,2034,2035,2048,2050,2060,2066,2067,2070,2073,2074,2085,2097,2110,2114,2120,2125,2133,2136,2138,2140,2144,2145,2147,2148,2150,2160,2161,2164,2165,2166,2170,2171,2199,2204,2207,2208,2220,2221,2224,2250,2251,2259,2280,2285,2286,2287,2289,2298,2302,2303,2304,2320,2325,2326,2330,2340,2350,2354,2355,2365,2380,2390,2401,2420,2430,2431,2439,2440,2443,2449,2460,2463,2469,2472,2478,2480,2483,2484,2485,2486,2500,2536,2537,2539,2541,2546,2549,2550,2570,2577,2579,2581,2588,2600,2611,2621,2622,2630,2640,2646,2650,2671,2681,2711,2716,2722,2729,2745,2750,2756,2760,2761,2790,2794,2795,2800,2803,2820,2830,2831,2842,2850,2877,2880,3003,3006,3011,3012,3013,3015,3020,3030,3040,3041,3042,3044,3049,3053,3055,3070,3072,3073,3081,3085,3097,3105,3121,3122,3124,3125,3128,3130,3133,3134,3136,3137,3141,3145,3152,3156,3160,3162,3167,3169,3172,3175,3182,3186,3192,3195,3199,3205,3218,3220,3241,3249,3250,3260,3265,3268,3277,3280,3283,3285,3305,3310,3314,3315,3337,3338,3341,3350,3351,3352,3355,3363,3364,3377,3379,3380,3381,3384,3400,3437,3442,3444,3453,3461,3462,3463,3465,3478,3480,3482,3483,3500,3501,3505,3517,3518,3520,3523,3525,3527,3537,3550,3551,3558,3561,3564,3567,3579,3584,3586,3588,3595,3599,3616,3621,3623,3630,3631,3634,3639,3646,3660,3669,3672,3673,3675,3677,3678,3685,3690,3691,3698,3726,3730,3735,3737,3752,3757,3802,3805,3809,3810,3818,3821,3823,3824,3825,3831,3840,3844,3851,3854,3859,3869,3870,3871,3874,3875,3885,3888,3909,3911,3937,3940,3950,3953,3956,3960,3971,3977,3992,3995,4011,4032,4060,4065,4067,4074,4077,4101,4104,4109,4121,4123,4125,4133,4157,4165,4178,4179,4214,4215,4216,4219,4280,4305,4306,4311,4340,4341,4343,4344,4350,4352,4355,4357,4358,4359,4363,4403,4424,4426,4427,4428,4454,4496,4500,4510,4551,4558,4559,4560,4570,4573,4610,4615,4621,4625,4627,4650,4660,4670,4680,4695,4700,4702,4711,4737,4740,4741,4743,4806,4810,4820,4821,4825,4829,4852,4859,4860,4870,4871,5000,5007,5008,5011,5014,5019,5020,5021,5022,5024,5031,5033,5038,5041,5045,5048,5067,5070,5072,5082,5084,5096,5106,5112,5113,5114,5115,5116,5118,5152,5157,5163,5167,5172,5214,5222,5223,5237,5253,5254,5259,5260,5264,5268,5275,5280,5291,5332,5333,5341,5373,5381,5540,5550,5573,5700,5710,6005,6007,6016,6054,6055,6056,6061,6101,6110,6111,6151,6155,6162,6164,6166,6208,6214,6230,6236,6243,6253,6280,6302,6304,6308,6309,6311,6316,6317,6318,6323,6324,6327,6328,6330,6337,6346,6352,6353,6355,6365,6367,6368,6369,6383,6401,6407,6411,6421,6423,6424,6426,6430,6432,6450,6460,6487,6488,6489,6521,6528,6530,6532,6566,6606,6635,6701,6705,6707,6722,6799,7000,7004,7009,7019,7022,7109,7120,7140,7150,7212,7215,7249,7250,7260,7264,7292,7303,7304,7306,7310,7315,7316,7320,7321,7325,7330,822,872,8865,822,872,1001,1002,1003,1004,1005,1006,1007,1008,1009,1010,1020,1021,1022,1023,1024,1025,1026,1027,1028,1029,1030,1031,1032,1033,1034,1035,1036,1037,1038,1039,1040,1041,1042,1043,1044,1045,1046,1100,1101,1102,1103,1104,1105,1106,1107,1108,1109,1110,1112,1113,1114,1115,1116,1117,1118,1119,1120,1121,1122,1123,1124,1125,1126,1127,1128,1129,1130,1131,1132,1133,1134,1135,1136,1137,1138,1139,1140,1141,1142,1143,1144,1145,1146,1147,1148,1149,1150,1151,1152,1153,1154,1155,1156,1157,1158,1159,1160,1161,1162,1163,1164,1165,1166,1167,1168,1169,1170,1171,1172,1173,1174,1175,1176,1177,1178,1179,1180,1181,1182,1183,1184,1185,1186,1187,1188,1189,1190,1191,1192,1193,1194,1195,1196,1197,1198,1199,1201,1202,1203,1205,1207,1208,1209,1210,1211,1212,1213,1214,1215,1216,1217,1218,1219,1220,1221,1222,1223,1224,1225,1226,1227,1228,1229,1230,1231,1232,1233,1234,1235,1236,1237,1238,1239,1240,1241,1242,1243,1244,1245,1246,1247,1248,1249,1250,1291,1292,1293,1294,1295,1296,1297,1298,1299,1311,1312,1313,1314,1315,1316,1317,1318,1319,1320,1321,1322,1323,1324,1325,1326,1327,1328,1329,1330,1331,1332,1333,1334,1391,1401,1416,1419,1420,1422,1423,1424,1425,1426,1427,1428,1429,2000,2001,2004,2005,2012,2013,2014,2051,2056,2058,2890,2891,1797,2750,2751,2085,2097,1685,2114,1715,1771,2120,2145,1850,1851,1854,1855,2164,2171,2250,2251,2252,2259,2280,2285,2286,2289,2320,2325,2326,2330,2340,2348,2350,2351,2354,2355,2365,2380,2390,2401,2420,2430,2431,2439,2440,2442,2443,2449,2460,2463,2469,2472,2478,2480,2483,2484,2485,2486,1921,1922,2500,2520,2521,2522,2746,2536,2537,2539,2541,2546,2549,2550,2570,2577,2579,2581,2588,200,221,291,293,294,295,296,297,298,299,2589,2600,2601,2608,2610,2611,2621,2622,2629,2630,2640,2708,2646,2650,2678,2671,2681,2711,2716,2722,2729,2745,2756,1790,2760,2790,2794,2795,2796,2800,2803,2820,2826,2830,2831,2842,2850,2877,2880,3000,3001,3003,3005,3008,3010,3050,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,3030,3049,3097,3134,3156,8659,3160,3167,3164,3175,3176,8785,3199,3218,3241,3249,3260,3265,3268,3277,3278,3279,3280,3283,3285,3305,3310,3314,3315,3337,3338,3341,3350,3353,3354,3351,3355,3363,3364,3377,3378,3379,3380,3384,3385,3387,3381,3399,3400,3402,3437,3442,3444,3453,3461,3462,3463,3465,3478,3480,3482,3483,3500,3502,3501,3505,3517,3518,3520,3523,3525,3527,3537,3550,3551,3552,3554,3558,3561,3564,3565,3567,3576,3579,3584,3586,3588,3595,3597,3599,3616,3617,3621,3623,3630,3632,3631,3634,3639,3646,3647,3660,3661,3663,3669,3671,3672,3673,3675,3676,3677,3678,3685,3689,3690,3704,3691,3698,3726,3730,3735,3736,3737,3738,3739,3752,3757,3802,3805,3809,3810,3818,3821,3823,3824,3825,3831,3840,3841,3844,3851,3854,3859,3869,3870,3871,3873,3874,3875,3885,3888,3909,3937,3940,3950,3953,3954,3956,3960,3971,3977,3992,4011,4060,4074,4077,4109,4123,4125,4157,4165,4178,4214,4216,4219,4280,4305,4306,4311,4340,4341,4343,4345,4344,4350,4353,4363,4364,4365,4352,4355,4357,4358,4359,4403,4422,4423,4424,4426,4427,4428,4454,4496,4500,4510,4551,4558,4559,4560,4570,4573,4610,4611,4615,4621,4625,4627,4650,4660,4670,4676,4680,4694,4695,4700,4711,4702,4737,4740,4741,4743,4806,4810,4820,4821,4825,4829,4852,4859,4860,4870,4871,5000,5001,5005,5800,5810,5839,5880,5881,5882,5883,5884,5885,5886,5887,5888,5900,5901,5902,5903,5904,5920,5942,5950,5096,5112,5114,5150,5152,5157,5163,5167,5172,5214,5220,5221,5222,5223,5237,5253,5259,5260,5264,5268,5269,5275,5280,5291,5332,5333,5341,5373,5381,5540,5550,5573,5700,5710,6005,6872,6054,6934,6942,6061,6941,6101,6981,6110,6990,6111,6991,6997,6155,6955,6970,6162,6164,6964,6166,6208,6214,6228,6230,6231,6232,6252,6236,6243,6244,6253,6280,6302,6304,6308,6309,6311,6316,6317,6318,6323,6322,6324,6326,6327,6328,6330,6331,6332,6337,6346,6352,6353,6357,6355,6365,6367,6368,6369,6383,6384,6385,6401,6403,6465,6466,6467,6407,6411,6412,6413,6414,6415,6420,6421,6422,6424,6480,6487,6489,6423,6426,6427,6430,6433,6432,6445,6446,6447,6448,6450,6452,6460,6488,6521,6528,6530,6531,6532,6566,6568,6571,6572,6606,6635,6701,6705,6707,6722,6723,6761,6799,7000,7001,7002,7151,7800,7802,7803,7804,7805,7806,7807,7808,7809,7810,7811,7812,7813,7814,7823,7824,7827,7828,7829,7845,7850,7019,7022,7109,7120,7139,7140,7150,7212,7215,7249,7257,7260,7264,7292,7303,7304,7306,7310,7315,7316,7320,7915,7916,7917,7918,7919,7920,7921,7321,7325,7330,1300,1335,1340,2007,2009,2010,2011,2034,2099,2136,2194,4225,3006,3051,3053,8500,8507,3951,4007,4104,4220,6160,6959,1565,2008,2016,2027,2037,2041,2061,2024,1700,2115,2126,1819,2135,2191,2192,2146,1885,1888,1900,1902,1903,1911,2200,2201,2202,1481,1493,2218,2220,2612,3002,3031,3052,3054,3065,3205,8002,8557,8865,3041,3059,3084,3104,3122,8622,3765,3162,3163,3215,3220,4010,4012,4029,4030,4059,4064,4065,4102,4103,4073,4078,4113,4154,4221,5006,5031,5067,5071,5009,5049,5098,5106,5127,5151,5165,6000,6001,6003,6007,6008,6800,6803,6809,6817,6820,6827,6830,6831,6832,6837,6838,6839,6840,6841,6842,6843,6844,6845,6846,6847,6848,6849,6850,6865,6900,6901,6902,6903,6904,6905,6102,6103,6982,6983,7010,1350,1360,1363,1440,1441,1450,1646,2006,2017,2021,2025,2028,2038,2039,2050,2055,2059,2060,2089,2026,2035,1800,1801,2131,1560,1570,2063,2064,1670,1675,2111,2113,2100,2119,1750,1765,2151,2154,2195,2162,2768,2176,1485,1487,2209,2217,2222,2227,2229,2307,2308,2291,2292,2304,2327,2770,3011,3066,3207,8873,3012,3020,3044,3043,3048,3072,3073,3074,3085,3088,3093,3094,3108,3126,3125,3127,3147,3152,3114,3138,3179,3180,3158,3178,3186,3168,3169,3202,3800,3171,3172,3173,3193,3219,3250,3356,3594,3082,3090,3976,3995,4013,4031,9464,4034,4053,4105,4076,4110,4119,4156,4008,4158,4215,4227,4572,4751,5033,5034,5035,5061,5063,5065,5069,5011,5025,5021,5019,5024,5040,5043,5044,5052,5047,5066,5136,5140,5092,5093,5108,5113,5116,5162,5169,6004,6006,6014,6892,6906,6913,6017,6060,6916,6917,6937,6938,6939,6940,6053,6063,6933,6022,6064,6106,6986,6147,6158,6159,7004,7005,7006,7021,7248,1355,1430,1435,1585,1590,1648,2015,2022,2023,2040,2042,2043,2048,2065,2090,2091,2773,1475,1476,2044,2204,1455,2019,2046,2132,2193,2206,1595,1597,1602,1604,1605,1606,1607,1608,1610,1611,2066,2068,1680,2069,2070,2112,2087,2073,2074,2075,2076,2096,2102,2137,1701,2116,2117,2125,1480,1484,2190,2208,1835,2144,2160,2161,2148,2167,2168,2169,2216,2221,2225,2226,1499,2232,2306,2287,2299,2298,2303,2309,2294,4224,1927,1928,2519,2525,2526,2602,2747,2762,2763,3004,3056,3067,3068,3141,3206,8538,3181,3182,3015,3025,3034,3016,3021,3023,3042,3070,3079,8576,3083,3105,3107,3096,3103,3123,3143,3144,3146,3128,3149,3151,3110,3131,3132,3133,3150,3136,3137,3154,3766,3767,3204,3785,3159,3789,3195,3177,3196,3200,3911,3930,3694,3697,3803,3806,3816,3939,3941,4006,4171,4000,4001,4002,4003,4004,4061,4066,4072,9000,9001,9002,9003,9005,9007,9008,9009,9010,9013,9015,9016,9017,9018,9019,9020,9021,9022,9023,4068,4120,4169,4107,4112,4152,4161,4130,4174,4173,4229,4037,4501,4564,5007,5068,5081,5082,5010,5023,5032,5084,5020,5022,5045,5039,5041,5042,5046,5050,5062,5064,5075,5086,5076,5137,5094,5088,5107,5109,5111,5117,5141,5154,5156,5166,5254,6009,6016,6050,6151,6907,6909,6915,6929,6951,6021,6914,6062,6104,6943,6984,6056,6936,6152,6952,6109,6989,6149,6157,6163,6957,6961,6963,6965,7008,7009,7015,7018,7023,1445,1465,1466,1470,2018,2029,2033,2047,2049,2052,2062,2088,2774,1460,2020,2031,2032,2045,2130,2203,2036,1805,2133,2134,2205,1502,1504,1505,1507,1511,1515,1516,1517,1690,1691,1692,1693,1694,1695,1696,1697,1698,1699,2057,2067,2110,2071,2072,2092,1639,1640,2086,2109,1710,2121,2122,1630,1635,2077,2079,2101,2138,2139,1811,1812,2118,2127,2128,2129,2140,1755,2152,2153,2196,2207,1825,1826,1856,1857,1858,1859,2141,2143,1830,1831,2142,1740,1741,2123,2124,2150,2163,2197,2199,2781,1730,1780,1781,2147,2767,2766,1860,2165,2166,2198,2177,1871,1875,2170,1891,2211,2212,2214,2215,1495,2219,2223,2210,2224,1490,2228,2282,2290,2278,2305,2293,2296,2297,2302,2300,2310,2295,2502,2505,2506,2603,2641,2761,3013,3032,3039,3055,3057,3121,3142,3019,3040,3022,3026,3033,3046,3058,3047,3060,3045,3061,3071,3078,3101,3081,3102,3075,3086,3087,3095,3113,3759,3106,3129,3124,3161,3183,8626,8627,3145,3148,3130,3166,3109,3111,3135,3153,3155,3184,3185,3165,3187,3804,3188,3189,3190,3192,3170,3174,3194,3975,3191,3910,3352,3555,3589,3590,3596,3754,3755,3912,3916,3936,3938,4005,4009,4014,4032,4018,4035,4051,4054,4101,4067,4106,4121,4151,4070,4075,4108,4111,4116,4122,4127,4118,4133,4132,4179,4155,4159,4217,9726,9728,9729,4304,4502,4556,4557,4555,5008,5037,5070,5083,5012,5013,5014,5015,5016,5017,5038,5048,5051,5072,5073,5074,5087,5085,5095,5090,5097,5115,5121,5118,5142,5144,5155,5161,5164,5168,6010,6090,6100,6910,6944,6945,6979,6051,6052,6931,6932,6018,6019,6059,6918,6921,6922,6055,6935,6068,6024,6066,6924,6105,6148,6985,6108,6988,6153,6953,6156,6956,6229,7007,7016,7250,7901,7902,7903,7904,7905,7906,7907,7908,7909,7910,7911,7912,7913,7914,7922,7923
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 (1231,1232,1233,1234,1416,1419,1797,2000,2008,2031,2034,2035,2048,2050,2060,2066,2067,2070,2073,2074,2085,2097,2110,2114,2120,2125,2133,2136,2138,2140,2144,2145,2147,2148,2150,2160,2161,2164,2165,2166,2170,2171,2199,2204,2207,2208,2220,2221,2224,2250,2251,2259,2280,2285,2286,2287,2289,2298,2302,2303,2304,2320,2325,2326,2330,2340,2350,2354,2355,2365,2380,2390,2401,2420,2430,2431,2439,2440,2443,2449,2460,2463,2469,2472,2478,2480,2483,2484,2485,2486,2500,2536,2537,2539,2541,2546,2549,2550,2570,2577,2579,2581,2588,2600,2611,2621,2622,2630,2640,2646,2650,2671,2681,2711,2716,2722,2729,2745,2750,2756,2760,2761,2790,2794,2795,2800,2803,2820,2830,2831,2842,2850,2877,2880,3003,3006,3011,3012,3013,3015,3020,3030,3040,3041,3042,3044,3049,3053,3055,3070,3072,3073,3081,3085,3097,3105,3121,3122,3124,3125,3128,3130,3133,3134,3136,3137,3141,3145,3152,3156,3160,3162,3167,3169,3172,3175,3182,3186,3192,3195,3199,3205,3218,3220,3241,3249,3250,3260,3265,3268,3277,3280,3283,3285,3305,3310,3314,3315,3337,3338,3341,3350,3351,3352,3355,3363,3364,3377,3379,3380,3381,3384,3400,3437,3442,3444,3453,3461,3462,3463,3465,3478,3480,3482,3483,3500,3501,3505,3517,3518,3520,3523,3525,3527,3537,3550,3551,3558,3561,3564,3567,3579,3584,3586,3588,3595,3599,3616,3621,3623,3630,3631,3634,3639,3646,3660,3669,3672,3673,3675,3677,3678,3685,3690,3691,3698,3726,3730,3735,3737,3752,3757,3802,3805,3809,3810,3818,3821,3823,3824,3825,3831,3840,3844,3851,3854,3859,3869,3870,3871,3874,3875,3885,3888,3909,3911,3937,3940,3950,3953,3956,3960,3971,3977,3992,3995,4011,4032,4060,4065,4067,4074,4077,4101,4104,4109,4121,4123,4125,4133,4157,4165,4178,4179,4214,4215,4216,4219,4280,4305,4306,4311,4340,4341,4343,4344,4350,4352,4355,4357,4358,4359,4363,4403,4424,4426,4427,4428,4454,4496,4500,4510,4551,4558,4559,4560,4570,4573,4610,4615,4621,4625,4627,4650,4660,4670,4680,4695,4700,4702,4711,4737,4740,4741,4743,4806,4810,4820,4821,4825,4829,4852,4859,4860,4870,4871,5000,5007,5008,5011,5014,5019,5020,5021,5022,5024,5031,5033,5038,5041,5045,5048,5067,5070,5072,5082,5084,5096,5106,5112,5113,5114,5115,5116,5118,5152,5157,5163,5167,5172,5214,5222,5223,5237,5253,5254,5259,5260,5264,5268,5275,5280,5291,5332,5333,5341,5373,5381,5540,5550,5573,5700,5710,6005,6007,6016,6054,6055,6056,6061,6101,6110,6111,6151,6155,6162,6164,6166,6208,6214,6230,6236,6243,6253,6280,6302,6304,6308,6309,6311,6316,6317,6318,6323,6324,6327,6328,6330,6337,6346,6352,6353,6355,6365,6367,6368,6369,6383,6401,6407,6411,6421,6423,6424,6426,6430,6432,6450,6460,6487,6488,6489,6521,6528,6530,6532,6566,6606,6635,6701,6705,6707,6722,6799,7000,7004,7009,7019,7022,7109,7120,7140,7150,7212,7215,7249,7250,7260,7264,7292,7303,7304,7306,7310,7315,7316,7320,7321,7325,7330,822,872,8865,822,872,1001,1002,1003,1004,1005,1006,1007,1008,1009,1010,1020,1021,1022,1023,1024,1025,1026,1027,1028,1029,1030,1031,1032,1033,1034,1035,1036,1037,1038,1039,1040,1041,1042,1043,1044,1045,1046,1100,1101,1102,1103,1104,1105,1106,1107,1108,1109,1110,1112,1113,1114,1115,1116,1117,1118,1119,1120,1121,1122,1123,1124,1125,1126,1127,1128,1129,1130,1131,1132,1133,1134,1135,1136,1137,1138,1139,1140,1141,1142,1143,1144,1145,1146,1147,1148,1149,1150,1151,1152,1153,1154,1155,1156,1157,1158,1159,1160,1161,1162,1163,1164,1165,1166,1167,1168,1169,1170,1171,1172,1173,1174,1175,1176,1177,1178,1179,1180,1181,1182,1183,1184,1185,1186,1187,1188,1189,1190,1191,1192,1193,1194,1195,1196,1197,1198,1199,1201,1202,1203,1205,1207,1208,1209,1210,1211,1212,1213,1214,1215,1216,1217,1218,1219,1220,1221,1222,1223,1224,1225,1226,1227,1228,1229,1230,1231,1232,1233,1234,1235,1236,1237,1238,1239,1240,1241,1242,1243,1244,1245,1246,1247,1248,1249,1250,1291,1292,1293,1294,1295,1296,1297,1298,1299,1311,1312,1313,1314,1315,1316,1317,1318,1319,1320,1321,1322,1323,1324,1325,1326,1327,1328,1329,1330,1331,1332,1333,1334,1391,1401,1416,1419,1420,1422,1423,1424,1425,1426,1427,1428,1429,2000,2001,2004,2005,2012,2013,2014,2051,2056,2058,2890,2891,1797,2750,2751,2085,2097,1685,2114,1715,1771,2120,2145,1850,1851,1854,1855,2164,2171,2250,2251,2252,2259,2280,2285,2286,2289,2320,2325,2326,2330,2340,2348,2350,2351,2354,2355,2365,2380,2390,2401,2420,2430,2431,2439,2440,2442,2443,2449,2460,2463,2469,2472,2478,2480,2483,2484,2485,2486,1921,1922,2500,2520,2521,2522,2746,2536,2537,2539,2541,2546,2549,2550,2570,2577,2579,2581,2588,200,221,291,293,294,295,296,297,298,299,2589,2600,2601,2608,2610,2611,2621,2622,2629,2630,2640,2708,2646,2650,2678,2671,2681,2711,2716,2722,2729,2745,2756,1790,2760,2790,2794,2795,2796,2800,2803,2820,2826,2830,2831,2842,2850,2877,2880,3000,3001,3003,3005,3008,3010,3050,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,3030,3049,3097,3134,3156,8659,3160,3167,3164,3175,3176,8785,3199,3218,3241,3249,3260,3265,3268,3277,3278,3279,3280,3283,3285,3305,3310,3314,3315,3337,3338,3341,3350,3353,3354,3351,3355,3363,3364,3377,3378,3379,3380,3384,3385,3387,3381,3399,3400,3402,3437,3442,3444,3453,3461,3462,3463,3465,3478,3480,3482,3483,3500,3502,3501,3505,3517,3518,3520,3523,3525,3527,3537,3550,3551,3552,3554,3558,3561,3564,3565,3567,3576,3579,3584,3586,3588,3595,3597,3599,3616,3617,3621,3623,3630,3632,3631,3634,3639,3646,3647,3660,3661,3663,3669,3671,3672,3673,3675,3676,3677,3678,3685,3689,3690,3704,3691,3698,3726,3730,3735,3736,3737,3738,3739,3752,3757,3802,3805,3809,3810,3818,3821,3823,3824,3825,3831,3840,3841,3844,3851,3854,3859,3869,3870,3871,3873,3874,3875,3885,3888,3909,3937,3940,3950,3953,3954,3956,3960,3971,3977,3992,4011,4060,4074,4077,4109,4123,4125,4157,4165,4178,4214,4216,4219,4280,4305,4306,4311,4340,4341,4343,4345,4344,4350,4353,4363,4364,4365,4352,4355,4357,4358,4359,4403,4422,4423,4424,4426,4427,4428,4454,4496,4500,4510,4551,4558,4559,4560,4570,4573,4610,4611,4615,4621,4625,4627,4650,4660,4670,4676,4680,4694,4695,4700,4711,4702,4737,4740,4741,4743,4806,4810,4820,4821,4825,4829,4852,4859,4860,4870,4871,5000,5001,5005,5800,5810,5839,5880,5881,5882,5883,5884,5885,5886,5887,5888,5900,5901,5902,5903,5904,5920,5942,5950,5096,5112,5114,5150,5152,5157,5163,5167,5172,5214,5220,5221,5222,5223,5237,5253,5259,5260,5264,5268,5269,5275,5280,5291,5332,5333,5341,5373,5381,5540,5550,5573,5700,5710,6005,6872,6054,6934,6942,6061,6941,6101,6981,6110,6990,6111,6991,6997,6155,6955,6970,6162,6164,6964,6166,6208,6214,6228,6230,6231,6232,6252,6236,6243,6244,6253,6280,6302,6304,6308,6309,6311,6316,6317,6318,6323,6322,6324,6326,6327,6328,6330,6331,6332,6337,6346,6352,6353,6357,6355,6365,6367,6368,6369,6383,6384,6385,6401,6403,6465,6466,6467,6407,6411,6412,6413,6414,6415,6420,6421,6422,6424,6480,6487,6489,6423,6426,6427,6430,6433,6432,6445,6446,6447,6448,6450,6452,6460,6488,6521,6528,6530,6531,6532,6566,6568,6571,6572,6606,6635,6701,6705,6707,6722,6723,6761,6799,7000,7001,7002,7151,7800,7802,7803,7804,7805,7806,7807,7808,7809,7810,7811,7812,7813,7814,7823,7824,7827,7828,7829,7845,7850,7019,7022,7109,7120,7139,7140,7150,7212,7215,7249,7257,7260,7264,7292,7303,7304,7306,7310,7315,7316,7320,7915,7916,7917,7918,7919,7920,7921,7321,7325,7330,1300,1335,1340,2007,2009,2010,2011,2034,2099,2136,2194,4225,3006,3051,3053,8500,8507,3951,4007,4104,4220,6160,6959,1565,2008,2016,2027,2037,2041,2061,2024,1700,2115,2126,1819,2135,2191,2192,2146,1885,1888,1900,1902,1903,1911,2200,2201,2202,1481,1493,2218,2220,2612,3002,3031,3052,3054,3065,3205,8002,8557,8865,3041,3059,3084,3104,3122,8622,3765,3162,3163,3215,3220,4010,4012,4029,4030,4059,4064,4065,4102,4103,4073,4078,4113,4154,4221,5006,5031,5067,5071,5009,5049,5098,5106,5127,5151,5165,6000,6001,6003,6007,6008,6800,6803,6809,6817,6820,6827,6830,6831,6832,6837,6838,6839,6840,6841,6842,6843,6844,6845,6846,6847,6848,6849,6850,6865,6900,6901,6902,6903,6904,6905,6102,6103,6982,6983,7010,1350,1360,1363,1440,1441,1450,1646,2006,2017,2021,2025,2028,2038,2039,2050,2055,2059,2060,2089,2026,2035,1800,1801,2131,1560,1570,2063,2064,1670,1675,2111,2113,2100,2119,1750,1765,2151,2154,2195,2162,2768,2176,1485,1487,2209,2217,2222,2227,2229,2307,2308,2291,2292,2304,2327,2770,3011,3066,3207,8873,3012,3020,3044,3043,3048,3072,3073,3074,3085,3088,3093,3094,3108,3126,3125,3127,3147,3152,3114,3138,3179,3180,3158,3178,3186,3168,3169,3202,3800,3171,3172,3173,3193,3219,3250,3356,3594,3082,3090,3976,3995,4013,4031,9464,4034,4053,4105,4076,4110,4119,4156,4008,4158,4215,4227,4572,4751,5033,5034,5035,5061,5063,5065,5069,5011,5025,5021,5019,5024,5040,5043,5044,5052,5047,5066,5136,5140,5092,5093,5108,5113,5116,5162,5169,6004,6006,6014,6892,6906,6913,6017,6060,6916,6917,6937,6938,6939,6940,6053,6063,6933,6022,6064,6106,6986,6147,6158,6159,7004,7005,7006,7021,7248,1355,1430,1435,1585,1590,1648,2015,2022,2023,2040,2042,2043,2048,2065,2090,2091,2773,1475,1476,2044,2204,1455,2019,2046,2132,2193,2206,1595,1597,1602,1604,1605,1606,1607,1608,1610,1611,2066,2068,1680,2069,2070,2112,2087,2073,2074,2075,2076,2096,2102,2137,1701,2116,2117,2125,1480,1484,2190,2208,1835,2144,2160,2161,2148,2167,2168,2169,2216,2221,2225,2226,1499,2232,2306,2287,2299,2298,2303,2309,2294,4224,1927,1928,2519,2525,2526,2602,2747,2762,2763,3004,3056,3067,3068,3141,3206,8538,3181,3182,3015,3025,3034,3016,3021,3023,3042,3070,3079,8576,3083,3105,3107,3096,3103,3123,3143,3144,3146,3128,3149,3151,3110,3131,3132,3133,3150,3136,3137,3154,3766,3767,3204,3785,3159,3789,3195,3177,3196,3200,3911,3930,3694,3697,3803,3806,3816,3939,3941,4006,4171,4000,4001,4002,4003,4004,4061,4066,4072,9000,9001,9002,9003,9005,9007,9008,9009,9010,9013,9015,9016,9017,9018,9019,9020,9021,9022,9023,4068,4120,4169,4107,4112,4152,4161,4130,4174,4173,4229,4037,4501,4564,5007,5068,5081,5082,5010,5023,5032,5084,5020,5022,5045,5039,5041,5042,5046,5050,5062,5064,5075,5086,5076,5137,5094,5088,5107,5109,5111,5117,5141,5154,5156,5166,5254,6009,6016,6050,6151,6907,6909,6915,6929,6951,6021,6914,6062,6104,6943,6984,6056,6936,6152,6952,6109,6989,6149,6157,6163,6957,6961,6963,6965,7008,7009,7015,7018,7023,1445,1465,1466,1470,2018,2029,2033,2047,2049,2052,2062,2088,2774,1460,2020,2031,2032,2045,2130,2203,2036,1805,2133,2134,2205,1502,1504,1505,1507,1511,1515,1516,1517,1690,1691,1692,1693,1694,1695,1696,1697,1698,1699,2057,2067,2110,2071,2072,2092,1639,1640,2086,2109,1710,2121,2122,1630,1635,2077,2079,2101,2138,2139,1811,1812,2118,2127,2128,2129,2140,1755,2152,2153,2196,2207,1825,1826,1856,1857,1858,1859,2141,2143,1830,1831,2142,1740,1741,2123,2124,2150,2163,2197,2199,2781,1730,1780,1781,2147,2767,2766,1860,2165,2166,2198,2177,1871,1875,2170,1891,2211,2212,2214,2215,1495,2219,2223,2210,2224,1490,2228,2282,2290,2278,2305,2293,2296,2297,2302,2300,2310,2295,2502,2505,2506,2603,2641,2761,3013,3032,3039,3055,3057,3121,3142,3019,3040,3022,3026,3033,3046,3058,3047,3060,3045,3061,3071,3078,3101,3081,3102,3075,3086,3087,3095,3113,3759,3106,3129,3124,3161,3183,8626,8627,3145,3148,3130,3166,3109,3111,3135,3153,3155,3184,3185,3165,3187,3804,3188,3189,3190,3192,3170,3174,3194,3975,3191,3910,3352,3555,3589,3590,3596,3754,3755,3912,3916,3936,3938,4005,4009,4014,4032,4018,4035,4051,4054,4101,4067,4106,4121,4151,4070,4075,4108,4111,4116,4122,4127,4118,4133,4132,4179,4155,4159,4217,9726,9728,9729,4304,4502,4556,4557,4555,5008,5037,5070,5083,5012,5013,5014,5015,5016,5017,5038,5048,5051,5072,5073,5074,5087,5085,5095,5090,5097,5115,5121,5118,5142,5144,5155,5161,5164,5168,6010,6090,6100,6910,6944,6945,6979,6051,6052,6931,6932,6018,6019,6059,6918,6921,6922,6055,6935,6068,6024,6066,6924,6105,6148,6985,6108,6988,6153,6953,6156,6956,6229,7007,7016,7250,7901,7902,7903,7904,7905,7906,7907,7908,7909,7910,7911,7912,7913,7914,7922,7923) 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 'NSW|ACT|VIC|QLD|SA|WA|TAS|NT'ORDER BY highlightAdvertPosition DESC
Search Result
Unable to determine location coordinates
AS SEEN ON :
Phone : 03 98277797
 
 Email : info@findacarpark.com.au
 
 
 PRIVACY POLICY
Copyright © 2015 findacarpark Pty Ltd. All Rights Reserved. Use of this web site constitutes acceptance of the findacarpark terms and conditions
car park