Home | Contact

phone 01206 752212

 

8934
members


SELECT distinct a.id, a.*, o.id as owner_id, o.owner, o.logo as logo, o.website as owebsite FROM #__osrs_properties as a RIGHT JOIN #__osrs_owners as o on o.id = a.owner_id WHERE a.published = '1' AND a.approved = '1' AND ( a.address like '%Ashby%252520de%252520la%252520Zouch%' OR a.address2 like '%Ashby%252520de%252520la%252520Zouch%' OR a.city like '%Ashby%252520de%252520la%252520Zouch%' OR a.postcode like '%Ashby%252520de%252520la%252520Zouch%' ) ORDER BY a.pro_name

Cask Marque Pubs in Ashby%252520de%252520la%252520Zouch