Sugar
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
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.
For all lettings enquiries covering the Dacorum area please contact Claire Alderson and Alexandra Cooper on 01442 862533 For all St Albans based enquiries, please contact on 01727 855556. Lastly, for all Radlett lettings enquiries please contact William Susman on 01923 859444.
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.
Alexandra Cooper, Lettings Negotiator
With over 13 years’ experience in the property management and construction industry, Alexandra demonstrates initiative and confidence when matching tenants to with the right rental property. Skilled at relationship building and with an array of industry knowledge, Alexandra is the first point of contact to handle our landlord and tenant enquiries.
Alexandra Cooper
William Susman, Radlett Director
William is a Chartered Surveyor, well qualified to provide professional advice in all aspects of residential property. He has lived locally in Radlett for the past 15 years and is also a local Councillor, involved in a number of community and charitable organisations.
William
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
Please click above for our current brochure
88 properties found
LET AGREED
PCM £5,000
- 4 Beds
- 2 Baths
- 3 Receptions
A handsome double-fronted Geor... Readmore
LET
PCM £4,750
- 5 Beds
- 5 Baths
- 2 Receptions
BRAND NEW FAMILY HOUSE. RADLE... Readmore
LET AGREED
PCM £4,000
- 3 Beds
- 3 Baths
- 2 Receptions
NEWLY BUILT LUXURY HOUSE TO LE... Readmore
LET
PCM £4,000
- 3 Beds
- 3 Baths
- 2 Receptions
NEWLY BUILT LUXURY HOUSE TO LE... Readmore
LET
PCM £3,750
- 4 Beds
- 3 Baths
- 3 Receptions
We are delighted to offer for ... Readmore
TO RENT
PCM £3,500
- 2 Beds
- 2 Baths
- 1 Reception
LUXURY NEW TWO BED APARTMENT ... Readmore
LET
PCM £3,300
- 5 Beds
- 2 Baths
- 3 Receptions
FIVE BED DETACHED HOUSE RADLET... Readmore
LET
PCM £3,000
- 4 Beds
- 3 Baths
- 2 Receptions
Offered for rent is this recen... Readmore
LET AGREED
PCM £2,950
- 4 Beds
- 2 Baths
- 2 Receptions
A stunning four bedroom house ... Readmore
LET AGREED
PCM £2,500
- 4 Beds
- 2 Baths
- 1 Reception
A fantastic refurbished and be... Readmore
LET
PCM £2,500
- 4 Beds
- 2 Baths
- 3 Receptions
RADLETT. FOUR BEDROOM, THREE ... Readmore
LET AGREED
PCM £2,500
- 3 Beds
- 2 Baths
- 3 Receptions
THREE DOUBLE BEDROOM HOUSE TO ... Readmore
TO RENT
PCM £2,495
- 2 Beds
- 2 Baths
- 1 Reception
LUXURY TWO BED TWO BATH GROUND... Readmore
LET AGREED
PCM £2,490
Available from 1 April - An ex... Readmore
Firstly, how likely would you be to recommend our company on a scale of 0 - 10?

Finally, if you have specific feedback, please select a category below...

It seems you have
already provided us with feedback recently. Sorry for the inconvenience.