Property for sale in South Yorkshire . Buy houses from South Yorkshire estate agents.   

all SELECT a.* FROM advert a, advert_page p WHERE a.page=p.id AND p.url='region' AND site=48 AND (region LIKE '%South Yorkshire%' OR site=48) AND (rental=0 OR rental=NULL)