Australia's No.1 Private and Commercial Parking Website
priorityPostCodeList: 2800,3444,4000
secondaryList: 2800,3444,4000,4001,4002,4003,4004,9002,9003,9005,9007,9008,9009,9010,9013,9015,9016,9018,9000,9019,9020,9021,9022,9023,9017,9001,4005,4006,4059,4064,4101,4169,4072,4102,4066,4171,4010,4029,4030,4060,4065,4067,4007,4051,4103,4104,4120,4151,4170
finalPostCodeList: 2800,3444,4000,2800,3444,4000,4001,4002,4003,4004,9002,9003,9005,9007,9008,9009,9010,9013,9015,9016,9018,9000,9019,9020,9021,9022,9023,9017,9001,4005,4006,4059,4064,4101,4169,4072,4102,4066,4171,4010,4029,4030,4060,4065,4067,4007,4051,4103,4104,4120,4151,4170
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 (2800,3444,4000,2800,3444,4000,4001,4002,4003,4004,9002,9003,9005,9007,9008,9009,9010,9013,9015,9016,9018,9000,9019,9020,9021,9022,9023,9017,9001,4005,4006,4059,4064,4101,4169,4072,4102,4066,4171,4010,4029,4030,4060,4065,4067,4007,4051,4103,4104,4120,4151,4170) 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 'NSW|VIC|QLD'ORDER BY highlightAdvertPosition DESC
Search Result
DEBUG: select * from AddressMap where Address = spring+hill
DEBUG: Found in DB
Distance
±263 m
Undercover
Secure
$46,000.00
 
 
CAR BAY FOR SALE - NO. 74
0418944618
28 Astor Terrace , Spring Hill
Queensland, 4000, Australia
View on map
Distance
±263 m
Undercover
$50,000.00
 
 
CAR PARK SPACES FOR SALE IN SPRING HILL (BRISBANE)
28 Astor Terrace , Spring Hill
Queensland, 4000, Australia
View on map
Distance
±263 m
Undercover
$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