Australia's No.1 Private and Commercial Parking Website
priorityPostCodeList: 4000
secondaryList: 9021,4002,9008,9022,4003,9009,9023,4004,9010,9013,9015,9000,9016,9001,9017,9002,9018,9003,9019,4000,9005,9020,4001,9007,4059,4064,4169,4005,4006,4101,4066,4171,4072,4102,4060,4065,4067,4010,4029,4030,4120,4151,4170,4007,4103,4051,4104
finalPostCodeList: 4000,9021,4002,9008,9022,4003,9009,9023,4004,9010,9013,9015,9000,9016,9001,9017,9002,9018,9003,9019,4000,9005,9020,4001,9007,4059,4064,4169,4005,4006,4101,4066,4171,4072,4102,4060,4065,4067,4010,4029,4030,4120,4151,4170,4007,4103,4051,4104
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,9021,4002,9008,9022,4003,9009,9023,4004,9010,9013,9015,9000,9016,9001,9017,9002,9018,9003,9019,4000,9005,9020,4001,9007,4059,4064,4169,4005,4006,4101,4066,4171,4072,4102,4060,4065,4067,4010,4029,4030,4120,4151,4170,4007,4103,4051,4104) 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
$320.00
/Month
 
Bond Required
$200.00
SUITABLE FOR EITHER MEDICAL SPECIALIST OR BUSINESS...
07-3262-5034
51 ASTOR TERR, SPRING HILL
QLD, 4004, Australia
View on map
Undercover
Secure
$45,000.00
 
 
CAR BAYS FOR SALE!
0418944618
67 Astor Terrace , Spring Hill
Queensland, 4000, Australia
View on map
Undercover
Short term
$10.00
/Day
$250.00
/Month
Bond Required
$150.00
SECURE UNDERCOVER CARPARK
0414173960
477 Boundary Street , Spring Hill
Queensland, 4000, Australia
View on map
Undercover
$300.00
/Month
 
Bond Required
$50.00
BRISBANE CITY BALLOW CHAMBERS
0403 466604
25 Astor Terrace , Spring Hill
Queensland, 4000, Australia
View on map
Undercover
$0.00
/Month
 
 
INNER BRISBANE CITY PARKING
0419984189
100 Bowen Street , Spring Hill
Queensland, 4000, Australia
View on map
 
$175.00
/Month
 
Bond Required
$175.00
SECURE CARPARK IN SPRING HILL - MONTH TO MONTH
26 Berry Street , Spring Hill
Queensland, 4000, Australia
View on map
Undercover
Secure
$300.00
/Month
 
Bond Required
$100.00
CAR PARK FOR RENT
51 Astor Terrace , Spring Hill
Queensland, 4000, Australia
View on map
Undercover
Secure
$45,000.00
 
 
CENTRAL PARKING SPACE
225 Wickham TERR, SPRING HILL
QLD, 4000, Australia
View on map
Undercover
Secure
$320.00
/Month
 
Bond Required
$100.00
15 MINUTES WALK TO THE CITY!
0418944618
28 Astor TERR, Spring Hill
QLD, 4004, Australia
View on map