SEARCH OUR UPCOMING

AUCTION


PDF

		string(2307) "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, 21328, 21365, 21366)  ORDER BY  "
	
Saturday 20th July 2019
Salisbury Downs
House
4 2 2
12:00pm
East Albury
House
5 2 2
12:30pm
Sunday 21st July 2019
Knoxfield
Unit
3 1 2
1:00pm
Saturday 27th July 2019
Gordonvale
Acreage/Semi-Rural
3 1 1
11:00am
Saturday 3rd August 2019
Slacks Creek
House
3 1 4
11:00am
Dallas
House
3 1 2
2:00pm
Saturday 10th August 2019
Boronia
Townhouse
3 2 2
12:30pm