ketteringletting.co.uk - Renting, Letting, letting agents, house to rent, property to rent, properties in Cambridge, Bristol, Leeds, London, Manchester and throughout the UK

Email all agents
select ,(((acos(sin((pi()/180)) * sin((latpi()/180)) + cos((pi()/180)) * cos((latpi()/180)) cos((( - lng)pi()/180))))180/pi())601.1515) as distance,agents.* FROM property left join agents on agents.agentid=property.propertyprefix where rentorsale='R' and propavail='1' and (((acos(sin((pi()/180)) sin((latpi()/180)) + cos((pi()/180)) * cos((latpi()/180)) cos((( - lng)pi()/180))))180/pi())601.1515) <= 5.0 and agents.private='0' and agents.agentid!='ROOM' and propertyprefix != 'ROOM' group by propertyprefix failed.