Property to rent in Warwickshire from local letting agents.   

all SELECT a.* FROM advert a, advert_page p WHERE a.page=p.id AND p.url='region' AND site=55 AND (region LIKE '%Warwickshire%' OR site=55) AND rental=1