SEARCH OUR UPCOMING

AUCTION


PDF

		string(2265) "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)  ORDER BY  "
	
Saturday 17th November 2018
Port Melbourne
House
3 1 0
12:00pm
Saturday 24th November 2018
Footscray
Retail
12:30pm
Sorrento
House
3 1 2
2:30pm
Saturday 1st December 2018
Lavington
House
4 1 1
11:00am
Rosebud
House
3 2 2
2:30pm
Sunday 2nd December 2018
Sunshine
House
3 1 2
11:00am
Bonnells Bay
House
3 1 1
12:30pm
Runaway Bay
House
5 4 4
3:00pm
Saturday 8th December 2018
Wodonga
Townhouse
2 1 2
10:30am
Sunday 9th December 2018
Wantirna
House
4 2 2
1:00pm