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(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 19th January 2019
Springfield Lakes
House
4 2 2
9:30am
Saturday 26th January 2019
Killarney
Land
0 0 0
12:00pm
Saturday 16th February 2019
Erskine
Apartment
2 2 2
11:00am
Thursday 21st February 2019
Goovigen
Rural
3 2 3
9:00am