Sugar
Free Instant Valuation
Saved Property

SELECT *,CONVERT(REPLACE(REPLACE(minp.meta_value,'£',''),',',''),UNSIGNED INTEGER) Price, CASE WHEN (minpp.meta_value = 'POA') THEN '1' WHEN (minpp.meta_value != 'POA') THEN '2' END as `mainsort1` FROM wp_posts p inner join wp_postmeta minp on minp.post_id = p.Id and CONVERT(REPLACE(REPLACE(minp.meta_value,'£',''),',',''),UNSIGNED INTEGER) >= CONVERT('',UNSIGNED INTEGER) and minp.meta_key = 'cp_price' inner join wp_term_relationships tr on tr.object_id = p.Id and tr.term_taxonomy_id =10 inner join wp_postmeta minpp on minpp.post_id = p.Id and minpp.meta_key = 'cp_price_qualifier' ORDER BY CONVERT(REPLACE(REPLACE(minp.meta_value,'£',''),',',''),UNSIGNED INTEGER) desc

Lettings

Welcome to our Lettings Division

Aitchisons are able to offer landlords a full range of lettings services tailored to meet your own particular requirements. Our advice is totally impartial and our understanding of rental demand, rental values, tenant selection and care of property is our priority.

Whether you are an investment landlord with a number of properties in your property portfolio, or a first time landlord, our experience and advice will ensure the minimum of hassle and will maximise the financial return on your rental.

We act for a number of relocation agents seeking corporate lets so if you are considering letting a property please contact us for further information.

Please use the buttons below for more details and the fees relating to our services.

What our clients say

This is the fourth tenancy you arranged for me and on each occasion you have managed to let the property quickly . You have acted in a very professional manner and been sensitive to my requirements. I wouldn't hesitate in recommending Aitchisons as a letting agent to anyone.

- Mrs Georganas- Berkhamsted Landlord

letting images

Please click above for our current brochure

View:

No properties found

Your privacy and our use of cookies Read more about cookies and learn how to disable them.

close