SEARCH OUR UPCOMING

AUCTION


PDF

		string(2279) "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)  ORDER BY  "
	
Friday 29th March 2019
Deception Bay
Unit
3 2 2
3:00pm
Saturday 6th April 2019
Banyo
House
3 1 1
9:30am
Doncaster East
Unit
3 1 1
12:00pm
Norman Park
House
4 1 2
12:00pm
Sunday 7th April 2019
Elanora
House
3 2 1
11:30am
Friday 12th April 2019
Bexhill
Acreage/Semi-Rural
7 3 3
11:00am
Saturday 13th April 2019
Upper Mount Gravatt
House
3 1 2
11:00am
Saturday 4th May 2019
Albury
House
2 1 0
11:30am
Birtinya
House
3 2 2
3:00pm