Contact Baker Reed Properties Ltd. UK   

SELECT a.* FROM advert a, advert_page p WHERE a.page=p.id AND p.url='agency_property_list.php' AND site=47 AND (region LIKE '%South Gloucestershire%' OR site=47)