SELECT ann.*, ann.id as aid, pro_type.value_fr
FROM announcement ann, country,property_type pro_type
WHERE
ann.type_of_property=pro_type.id AND
ann.active_status='Y' AND
ann.expiry_date >= now() AND
ann.payment_status = 'Y' AND
member_active_status = 'Y' AND
country.id = ann.country AND
pro_type.id = ann.type_of_property AND ann.country = 3 and (region in('75','1008') AND (( `city` LIKE "Saint Etienne ls Remiremont" ) OR ( `postal_code` LIKE "Saint Etienne ls Remiremont%" ) )) AND type_of_announcement='1' ORDER BY ann.id desc LIMIT 0, 10
Vente, (88) Vosges , Saint Etienne ls Remiremont, France - NOVEMO
