Australia's No.1 Private and Commercial Parking Website
finalPostCodeList: 2089,1646,1648,2089,2090,2091,1565,2055,2059,2060,2061,2062,1560,1585,1590,2063,2065,2088,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,1335,1340,1391,1401,1416,1419,1420,1422,1423,1424,1425,1426,1427,1428,1429,2000,2001,2004,2005,2011,2012,2013,2014,2051,2056,2058,2890,2891,1570,2009,2027,2041,2064,2068,1300,1360,1502,1504,1505,1507,1511,1515,1516,1517,1595,1597,1602,1604,1605,1606,1607,1608,1610,1611,1690,1691,1692,1693,1694,1695,1696,1697,1698,1699,2007,2010,2028,2037,2039,2057,2066,2067,2092
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.LISTINGTYPE = 'M'AND (p.expirydate IS NULL or p.expirydate > now()) AND highlightAdvertPosition = 0 AND p.ADDRESSPOSTCODE IN (2089,1646,1648,2089,2090,2091,1565,2055,2059,2060,2061,2062,1560,1585,1590,2063,2065,2088,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,1335,1340,1391,1401,1416,1419,1420,1422,1423,1424,1425,1426,1427,1428,1429,2000,2001,2004,2005,2011,2012,2013,2014,2051,2056,2058,2890,2891,1570,2009,2027,2041,2064,2068,1300,1360,1502,1504,1505,1507,1511,1515,1516,1517,1595,1597,1602,1604,1605,1606,1607,1608,1610,1611,1690,1691,1692,1693,1694,1695,1696,1697,1698,1699,2007,2010,2028,2037,2039,2057,2066,2067,2092) 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'ORDER BY highlightAdvertPosition DESC
Search Result
No Parking Spot Found
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