Australia's No.1 Private and Commercial Parking Website
priorityPostCodeList: 4000
secondaryList: 4000,4001,4002,4003,4004,9018,9001,9017,9016,9015,9013,9010,9003,9009,9002,9008,9007,9005,9000,9019,9020,9021,9022,9023,4169,4006,4059,4064,4101,4005,4102,4066,4072,4171,4067,4065,4060,4030,4029,4010,4103,4051,4007,4151,4170,4120,4104
finalPostCodeList: 4000,4000,4001,4002,4003,4004,9018,9001,9017,9016,9015,9013,9010,9003,9009,9002,9008,9007,9005,9000,9019,9020,9021,9022,9023,4169,4006,4059,4064,4101,4005,4102,4066,4072,4171,4067,4065,4060,4030,4029,4010,4103,4051,4007,4151,4170,4120,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,4000,4001,4002,4003,4004,9018,9001,9017,9016,9015,9013,9010,9003,9009,9002,9008,9007,9005,9000,9019,9020,9021,9022,9023,4169,4006,4059,4064,4101,4005,4102,4066,4072,4171,4067,4065,4060,4030,4029,4010,4103,4051,4007,4151,4170,4120,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
$275.00
/Month
 
Bond Required
$100.00
5 MINUTE WALK TO CBD
07-32625034
51 Astor Terrace , Spring Hill
Queensland, 4000, Australia
View on map
Undercover
Secure
$0.00
/Month
 
 
UNDERCOVER SECURED CAR PARK IN SPRINGHILL
170 Leichhardt Street , Spring Hill
Queensland, 4000, Australia
View on map
Undercover
Secure
$36,000.00
 
 
SPRING HILL CAR PARK FOR SALE
0411223222
51 Astor Terrace , Spring Hill
Queensland, 4000, Australia
View on map
Undercover
$300.00
/Month
 
Bond Required
$100.00
SPRING HILL CONVENIENT AND SECURE 24/7 PARKING
0408 725 743
28 Astor Terrace , Spring Hill
Queensland, 4000, Australia
View on map
Undercover
$47,500.00
 
 
CAR PARK SPACE FOR SALE IN SPRING HILL (BRISBANE)
0408 725 743
28 Astor Terrace , Spring Hill
Queensland, 4000, Australia
View on map
 
$300.00
/Month
 
Bond Required
$150.00
UNDERCOVER SECURE CARPARK - MONTHLY
0738395000
26 Berry Street , Spring Hill
Queensland, 4000, Australia
View on map
Secure
$550.00
/Month
 
Bond Required
$100.00
SECURE CARPARK FOR LONG TERM LEASE
51 Astor Terrace , Spring Hill
Queensland, 4000, Australia
View on map
Undercover
Secure
$280.00
/Month
 
Bond Required
$280.00
SECURED, UNDERCOVER, 24/7 ACCESS, 2.5M HEIGHT, AT...
300 Wickham St , Fortitude Valley
Queensland, 4006, Australia
View on map