Australia's No.1 Private and Commercial Parking Website
priorityPostCodeList: 2000
secondaryList: 2000,2001,2004,2005,2012,2013,2014,2051,2056,2058,2890,2891,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,2007,2009,2010,2011,1340,1335,1300,2008,2016,2027,2037,2041,2061,1565,2006,2017,2021,2025,2028,2038,2039,2050,2055,2059,2060,2089,1646,1450,1441,1440,1363,1360,1350,2015,2022,2023,2040,2042,2043,2048,2065,2090,2091,1648,1590,1585,1435,1430,1355,2018,2029,2033,2047,2049,2052,2062,2088,1470,1466,1465,1445
finalPostCodeList: 2000,2000,2001,2004,2005,2012,2013,2014,2051,2056,2058,2890,2891,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,2007,2009,2010,2011,1340,1335,1300,2008,2016,2027,2037,2041,2061,1565,2006,2017,2021,2025,2028,2038,2039,2050,2055,2059,2060,2089,1646,1450,1441,1440,1363,1360,1350,2015,2022,2023,2040,2042,2043,2048,2065,2090,2091,1648,1590,1585,1435,1430,1355,2018,2029,2033,2047,2049,2052,2062,2088,1470,1466,1465,1445
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 (2000,2000,2001,2004,2005,2012,2013,2014,2051,2056,2058,2890,2891,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,2007,2009,2010,2011,1340,1335,1300,2008,2016,2027,2037,2041,2061,1565,2006,2017,2021,2025,2028,2038,2039,2050,2055,2059,2060,2089,1646,1450,1441,1440,1363,1360,1350,2015,2022,2023,2040,2042,2043,2048,2065,2090,2091,1648,1590,1585,1435,1430,1355,2018,2029,2033,2047,2049,2052,2062,2088,1470,1466,1465,1445) 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|NSW'ORDER BY highlightAdvertPosition DESC
Search Result
Undercover
Secure
$150.00
/Month
 
Bond Required
$100.00
SECURE CAR SPACE TO RENT
0481 280 001
219 Chalmers Street , Redfern
New South Wales, 2016, Australia
View on map
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