Real Estate Listings Australia wide Search and Find Properties in Sydney, Melbourne and Brisbane and Link to Real Estate Agents Websites
RURAL PROPERTIES FOR SALE
Select State to start your search ...
NSW | VIC | QLD | SA | WA | NT | TAS | ACT
Western Australia Northern Territory South Australia Tasmania Victoria Queensland New South Wales Australian Capital Territory
PROPERTY SEARCH
  
enter suburb, postcode, or property id
 
 
mysql_query (30) failed. Column 'type' in where clause is ambiguous : 1052
Query: SELECT distinct est.id, est.special FROM premises2.realestate AS est, premises2.limages AS img where est.special = '1' and est.id=img.listingid AND est.postcode>0 and est.status!='sold' and est.status!='leased' AND img.imgno!='' and est.id>='6000000' and type='Rural'
Database: premises

User Name: premises