Australia's No.1 Private and Commercial Parking Website
priorityPostCodeList: 4000
secondaryList: 9019,9020,9000,9021,9001,9022,9002,9023,9003,4000,9005,4001,9007,4002,9008,4003,9009,4004,9010,9013,9015,9016,9017,9018,4059,4064,4101,4005,4006,4169,4171,4066,4072,4102,4030,4060,4065,4067,4010,4029,4170,4051,4103,4104,4007,4120,4151
finalPostCodeList: 4000,9019,9020,9000,9021,9001,9022,9002,9023,9003,4000,9005,4001,9007,4002,9008,4003,9009,4004,9010,9013,9015,9016,9017,9018,4059,4064,4101,4005,4006,4169,4171,4066,4072,4102,4030,4060,4065,4067,4010,4029,4170,4051,4103,4104,4007,4120,4151
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.expirydate IS NULL or p.expirydate > now()) AND highlightAdvertPosition = 0 AND p.ADDRESSPOSTCODE IN (4000,9019,9020,9000,9021,9001,9022,9002,9023,9003,4000,9005,4001,9007,4002,9008,4003,9009,4004,9010,9013,9015,9016,9017,9018,4059,4064,4101,4005,4006,4169,4171,4066,4072,4102,4030,4060,4065,4067,4010,4029,4170,4051,4103,4104,4007,4120,4151) 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 c.isDisabled = 0 AND highlightAdvertPosition > 0 AND (p.expirydate IS NULL or p.expirydate > now())AND p.addressstate RLIKE 'QLD|QLD'ORDER BY highlightAdvertPosition DESC
Search Result
DEBUG: select * from AddressMap where Address = 4000
DEBUG: Found in DB
Undercover
Secure
$45,000.00
 
 
CENTRAL PARKING SPACE
225 Wickham TERR, SPRING HILL
QLD, 4000, Australia
View on map
Undercover
Secure
$275.00
/Month
 
Bond Required
$100.00
SPRING HILL CONVENIENT AND SECURE 24/7 PARKING
0408725743
28 Astor Terrace , Spring Hill
Queensland, 4000, Australia
View on map
Undercover
$40,000.00
 
 
51 ASTOR TERRACE SPRING HILL - BALLOW CHAMBERS STR...
0420 940 125
51 Astor Terrace , Spring Hill
Queensland, 4000, Australia
View on map
Undercover
Secure
$48,000.00
 
 
CAR BAYS FOR SALE!
67 Astor Terrace , Spring Hill
Queensland, 4000, Australia
View on map
Undercover
Secure
$380.00
/Month
 
Bond Required
$100.00
15 MINUTES WALK TO THE CITY!
0418944618
28 Astor TERR, Spring Hill
QLD, 4004, Australia
View on map
Undercover
$320.00
/Month
 
Bond Required
$100.00
540 QUEEN STREET - INNER CITY CAR SPACE
07 3839 5000
540 Queen Street , Brisbane City
Queensland, 4000, Australia
View on map
Undercover
Secure
$36,500.00
 
 
SECURE UNDER COVER CAR PARK IN CENTRAL BRISBANE
Spring Hill
Queensland, 4000, Australia
View on map
 
$250.00
/Month
 
Bond Required
$250.00
CAR PARKS AVAILABLE IN HEART OF WEST END /SOUTH BR...
0418721784
Carpark 'West End Central', South Brisbane/ West End, 220 Melbourne St (Corner Boundary St and Melbourne ST, South Brisbane/ West End
QLD, 4101, Australia
View on map
Undercover
Secure
$0.00
/Month
 
 
NEW FARM VERY CLOSE TO CITY
0421345064
119 Moray Street , New Farm
Queensland, 4005, Australia
View on map