SEARCH OUR UPCOMING

AUCTION


PDF

		
Warning: array_merge(): Argument #2 is not an array in /home/atrealty/public_html/wp-content/plugins/zoorealty/realty.php on line 992

Warning: Invalid argument supplied for foreach() in /home/atrealty/public_html/wp-content/plugins/zoorealty/realty.php on line 996

Warning: Invalid argument supplied for foreach() in /home/atrealty/public_html/wp-content/plugins/zoorealty/realty.php on line 1220

Warning: Illegal string offset 'limit' in /home/atrealty/public_html/wp-content/plugins/zoorealty/realty.php on line 366

Warning: Illegal string offset 'related' in /home/atrealty/public_html/wp-content/plugins/zoorealty/realty.php on line 373

Warning: Illegal string offset 'related' in /home/atrealty/public_html/wp-content/plugins/zoorealty/realty.php on line 374
string(2258) "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) ORDER BY "
Sunday 30th September 2018
Hendra
House
3 2 2
10:00am
Saturday 6th October 2018
Burwood
Apartment
2 1 1
11:00am
Noble Park
Unit
3 3 2
11:30am
Sunday 7th October 2018
Rye
House
4 2 2
2:30pm
Saturday 20th October 2018
Bowraville
House
3 1 0
11:00am