SELECT a.web_address, a.latitude, a.longitude, a.account, a.date_pom, a.ref, a.web_address, a.search_address, a.bathrooms, a.general_desc, a.description2, a.fk_lookup_protyp_id, a.date_pom, a.description3, a.internet_desc, a.postcode, 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.under_offer, c.sold_stc, c.asking_price, d.description, e.description, f.description, g.description, a.special_offer, a.special_offer_text, a.date_pom, c.fk_lookup_tentyp_id, h.description FROM tblproperty a, tbllookup_user b, tblproperty_sale_details c, tbllookup_system d, tbllookup_user e, tbllookup_system f, tbllookup_system g, tbllookup_system h WHERE = 1 AND a.market_property = 1 AND a.fk_lookup_locati_id = AND c.fk_property_ref = a.ref AND c.fk_lookup_prista_id = AND c.fk_lookup_prioff_id = AND a.fk_lookup_protyp_id = AND = a.fk_lookup_prosec_id AND = c.fk_lookup_tentyp_id AND (fk_lookup_prosec_id = 92 OR CONCAT(',', prosec_multi, ',') like '%,92,%')AND a.fk_lookup_protyp_id = 556 AND a.fk_lookup_protyp_id NOT IN (153, 608, 558, 151, 152, 573) AND a.fk_lookup_prosec_id <> 93 ORDER BY c.asking_price DESC
  • List
  • Grid
We couldn't find any properties for your search