SEARCH OUR UPCOMING

AUCTION


PDF

		string(2286) "SELECT unique_id, properties.id, type, user_id, secondary_user, description, latitude, longitude, (garage + carport + off_street_park) AS carspaces,  bedrooms, show_price as display_sold_price, bathrooms, headline, postcode, property_type, display_price as price_display, price, display_price_text as price_display_value, town_village, floor_area as building_size, land_area as land_size, date_available as available_at, status, category, deal_type, display_address, unit_number, street_number, street ,state, suburb, agent_id, office_id, xml_id,
		(SELECT meta_value FROM property_meta WHERE property_meta.property_id = properties.id and meta_key='ext_link_1' LIMIT 1) AS ext_link_1,
		(SELECT meta_value FROM property_meta WHERE property_meta.property_id = properties.id and meta_key='ext_link_2' LIMIT 1) AS ext_link_2,
		(SELECT meta_value FROM property_meta WHERE property_meta.property_id = properties.id and meta_key='virtual_tour' LIMIT 1) AS virtual_tour,
		(Case when status='2' Then sold_at	else '' END)as sold_at,
		(Case when status='2' Then sold_price else '' END)as sold_price,
		(Case when status='6' Then leased_at else '' END)as leased_at,
		(Case when status='6' Then leased_price	else '' END)as leased_price,
		(Case when datediff(curdate(),created_at)<=7 Then 'NEW' else '' END)as new,
		(Case when auction_date >= curdate() and forthcoming_auction='1' Then auction_date else '' END)as auction_date,
		(Case when auction_date >= curdate() and forthcoming_auction='1' Then auction_time	else '' END)as auction_time,
		(Case when auction_date >= curdate() and forthcoming_auction='1' Then auction_place	else '' END)as auction_place,111.045* DEGREES(ACOS(COS(RADIANS(suburb_region.latitude))
					* COS(RADIANS(properties.latitude))
					* COS(RADIANS(suburb_region.longitude) - RADIANS(properties.longitude))
					+ SIN(RADIANS(suburb_region.latitude))
					* SIN(RADIANS(properties.latitude)))) AS distance_in_km FROM properties WHERE properties.status IN ( '1', '2', '4', '6' ) AND office_id IN (15901, 16137, 16715, 18305, 18337, 18333, 18345, 18334, 18391, 18387, 18425, 18410, 18404, 18457, 18484, 18490, 18492, 18540, 18587, 18578, 18620, 18629, 18658, 18664, 18642, 18623, 18686, 18841, 18837, 18619, 18848, 18855, 19225, 20326, 21091, 15902, 21255)  ORDER BY  "
	
Saturday 25th May 2019
Bayswater
Unit
2 2 1
10:00am
Craigieburn
House
4 2 2
2:00pm
Saturday 1st June 2019
Lennox Head
House
3 2 2
10:00am
Kingaroy
House
4 4 3
11:00am
Broadbeach Waters
House
4 2 2
12:00pm
Sunday 2nd June 2019
Surfers Paradise
House
5 5 2
10:00am
Wednesday 5th June 2019
Carrara
House
4 2 2
5:30pm
Saturday 15th June 2019
Braybrook
Apartment
2 1 1
11:00am
Salisbury
House
3 1 2
2:00pm
Guildford West
House
3 2 1
2:00pm
Sunday 16th June 2019
Currumbin
Block of Units
4 4 6
1:00pm