FIND YOUR NEW PROPERTY

SELECT a.web_address, a.latitude, a.longitude, a.account, a.date_pom, a.ref, a.web_address, a.search_address, a.bathrooms, a.postcode, a.general_desc, a.description2, a.fk_lookup_protyp_id, a.date_pom, a.description3, a.internet_desc, b.description, a.feature1, a.feature2, a.feature3, a.feature4, a.feature5, a.feature6, a.feature7, a.feature8, a.feature9, a.feature10, a.bedrooms, c.reduced, c.rental_amount, c.fk_lookup_prstle_id, d.description, e.description, f.description, a.special_offer, a.special_offer_text, a.date_pom FROM tblproperty a, tbllookup_user b, tblproperty_rental_details c, tbllookup_system d, tbllookup_system e, tbllookup_system f WHERE a.active = 1 AND a.market_property = 1 AND a.fk_lookup_locati_id = b.id AND c.fk_property_ref = a.ref AND c.fk_lookup_letfre_id = d.id AND a.fk_lookup_protyp_id = e.id AND a.fk_lookup_prosec_id = f.id AND a.fk_lookup_protyp_id NOT IN (153, 608, 558, 151, 152, 573, 557) AND a.fk_lookup_prosec_id <> 93 ORDER BY c.rental_amount DESC
  • List
  • Grid
We couldn't find any properties for your search