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(2223) "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, 15902, 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) ORDER BY "
Saturday 28th April 2018
Nunawading
House
3 1 2
11:00am
Ashwood
House
5 2 2
11:00am
Broadmeadows
Townhouse
4 2 2
1:00pm
Sunday 29th April 2018
Woolloongabba
Development
11:00am
Saturday 5th May 2018
Rochester
Acreage/Semi-Rural
4 2 4
11:00am
Newtown
House
3 1 0
12:30pm
Saturday 12th May 2018
Broadmeadows
House
3 1 4
11:30am
Petersham
House
3 2 0
12:45pm
Broadmeadows
House
3 1 3
2:30pm
Sunday 13th May 2018
Taylors Lakes
House
4 2 2
10:30am
Benowa
House
4 2 2
11:00am
Saturday 19th May 2018
Ashwood
House
3 1 4
11:00am
South Albury
Unit
4 2 2
11:00am
Jacana
Land
0 0 0
1:00pm
Saturday 26th May 2018
Albury
Block of Units
8 7 7
1:00pm