Australia's No.1 Private and Commercial Parking Website
finalPostCodeList: 1582,2065,4355,2065,1590,1585,4355,2064,2062,2060,2059,2055,1570,2063,2061,2089,2090,2091,1648,1646,1565,1560,2057,2041,1699,1698,1697,1696,1695,1694,1693,2066,2067,2068,1692,1691,1690,1611,1610,1608,1607,1606,1605,1604,1602,1597,1595,1517,1516,1515,1511,1507,1505,1504,1502,2058,2056,2051,2047,2039,2014,2013,2012,2009,2005,2004,2001,2000,2069,2088,2110,2890,2891,1470,1429,1428,1427,1426,1425,1424,1423,1422,1420,1419,1416,1401,1391,1334,1333,1332,1331,1330,1329,1328,1327,1326,1325,1324,1323,1322,1321,1320,1319,1318,1317,1316,1315,1314,1313,1312,1311,1299,1298,1297,1296,1295,1294,1293,1292,1291,1250,1249,1248,1247,1246,1245,1244,1243,1242,1241,1240,1239,1238,1237,1236,1235,1234,1233,1232,1231,1230,1229,1228,1227,1226,1225,1224,1223,1222,1221,1220,1219,1218,1217,1216,1215,1214,1213,1212,1211,1210,1209,1208,1207,1205,1203,1202,1201,1199,1198,1197,1196,1195,1194,1193,1192,1191,1190,1189,1188,1187,1186,1185,1184,1183,1182,1181,1180,1179,1178,1177,1176,1175,1174,1173,1172,1171,1170,1169,1168,1167,1166,1165,1164,1163,1162,1161,1160,1159,1158,1157,1156,1155,1154,1153,1152,1151,1150,1149,1148,1147,1146,1145,1144,1143,1142,1141,1140,1139,1138,1137,1136,1135,1134,1133,1132,1131,1130,1129,1128,1127,1126,1125,1124,1123,1122,1121,1120,1119,1118,1117,1116,1115,1114,1113,1112,1110,1109,1108,1107,1106,1105,1104,1103,1102,1101,1100,1046,1045,1044,1043,1042,1041,1040,1039,1038,1037,1036,1035,1034,1033,1032,1031,1030,1029,1028,1027,1026,1025,1024,1023,1022,1021,1020,1010,1009,1008,1007,1006,1005,1004,1003,1002,1001,2037,2011,2007,2092,1340,1335
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 (1582,2065,4355,2065,1590,1585,4355,2064,2062,2060,2059,2055,1570,2063,2061,2089,2090,2091,1648,1646,1565,1560,2057,2041,1699,1698,1697,1696,1695,1694,1693,2066,2067,2068,1692,1691,1690,1611,1610,1608,1607,1606,1605,1604,1602,1597,1595,1517,1516,1515,1511,1507,1505,1504,1502,2058,2056,2051,2047,2039,2014,2013,2012,2009,2005,2004,2001,2000,2069,2088,2110,2890,2891,1470,1429,1428,1427,1426,1425,1424,1423,1422,1420,1419,1416,1401,1391,1334,1333,1332,1331,1330,1329,1328,1327,1326,1325,1324,1323,1322,1321,1320,1319,1318,1317,1316,1315,1314,1313,1312,1311,1299,1298,1297,1296,1295,1294,1293,1292,1291,1250,1249,1248,1247,1246,1245,1244,1243,1242,1241,1240,1239,1238,1237,1236,1235,1234,1233,1232,1231,1230,1229,1228,1227,1226,1225,1224,1223,1222,1221,1220,1219,1218,1217,1216,1215,1214,1213,1212,1211,1210,1209,1208,1207,1205,1203,1202,1201,1199,1198,1197,1196,1195,1194,1193,1192,1191,1190,1189,1188,1187,1186,1185,1184,1183,1182,1181,1180,1179,1178,1177,1176,1175,1174,1173,1172,1171,1170,1169,1168,1167,1166,1165,1164,1163,1162,1161,1160,1159,1158,1157,1156,1155,1154,1153,1152,1151,1150,1149,1148,1147,1146,1145,1144,1143,1142,1141,1140,1139,1138,1137,1136,1135,1134,1133,1132,1131,1130,1129,1128,1127,1126,1125,1124,1123,1122,1121,1120,1119,1118,1117,1116,1115,1114,1113,1112,1110,1109,1108,1107,1106,1105,1104,1103,1102,1101,1100,1046,1045,1044,1043,1042,1041,1040,1039,1038,1037,1036,1035,1034,1033,1032,1031,1030,1029,1028,1027,1026,1025,1024,1023,1022,1021,1020,1010,1009,1008,1007,1006,1005,1004,1003,1002,1001,2037,2011,2007,2092,1340,1335) 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|QLD'ORDER BY highlightAdvertPosition DESC
Search Result
Distance
±2 km
Undercover
Secure
$450.00
/Month
 
Bond Required
$450.00
24/7 NORTH SYDNEY CAR SPACE ADJACENT TO VICTORIA C...
39 McLaren Street , North Sydney
New South Wales, 2060, Australia
View on map