Sold STC Detached

47 MERLIN DRIVE

ELY, ELY, CAMBRIDGESHIRE CB6 3EE

3 beds Listed 3 May 2011 (-5513d)

£215,000

Save

# 3 bedroom detached house for sale (CB6 3EE)

## Property Details

| Key | Value |
|-----|-------|
| Address | 47 MERLIN DRIVE, ELY, ELY, CAMBRIDGESHIRE CB6 3EE |
| Price | £215,000 |
| Bedrooms | 3 |
| Last sold | £178,500 Jul 2006 |

## Description

An immaculate 3 bedroom link detached family home situated within walking distance of the City Centre and catchment area for the Lantern Primary School. The property has been very well maintained and presented by the current vendors and its extended accommodation comprises entrance porch, lounge with gas fire and back boiler, dining room, superb extended fitted kitchen/breakfast room, integral garage and rear entrance hall. On the first floor a landing leads to 2 double bedrooms both with built-in wardrobe, a single bedroom and family bathroom. The home benefits from gas fired central heating, double glazing, garage and off road parking for 2 cars. The enclosed southerly facing rear garden is predominantly laid to lawn with patio area, 2 garden sheds, garden pond with water feature, raised plant and shrub beds and flower border.

## Property Photos

- ![Photo](/listings/photos/18687594/185229)
- ![Photo](/listings/photos/18687594/185231)
- ![Photo](/listings/photos/18687594/185232)
- ![Photo](/listings/photos/18687594/185233)
- ![Photo](/listings/photos/18687594/185235)
- ![Photo](/listings/photos/18687594/185236)
- ![Photo](/listings/photos/18687594/185238)
- ![Photo](/listings/photos/18687594/185240)
- ![Photo](/listings/photos/18687594/185242)
- ![Photo](/listings/photos/18687594/185244)
- ![Photo](/listings/photos/18687594/185246)
- ![Photo](/listings/photos/18687594/185248)
- ![Photo](/listings/photos/18687594/185251)

## Floorplans

- ![Floorplan 1](/listings/photos/18687594/185254) - Floorplan 1

## FENSA Certificates

This property has 1 FENSA certificate(s) on record.

### FENSA Certificate #11182169
- **Address:** 47 Merlin Drive, ELY, CB6 3EE
- **Certificate Issued:** 04/09/2015
- **Work Completed:** 28/07/2015
- **Items:** 6 window(s)

## Sales History

*Recorded sales for this property. Data from Land Registry Price Paid.*

| Address | Price | Date | Type |
|---------|-------|------|------|
| 47 MERLIN DRIVE, ELY, EAST CAMBRIDGESHIRE, CAMBRIDGESHIRE, CB6 3EE | £178,500 | 19/07/2006 | Semi-detached |

## Sold Comparables

*Same street and nearby sales within 0.25 miles. Data from Land Registry Price Paid. Last 5 years.*

| Address | Price | Date | Type |
|---------|-------|------|------|
| 2 RAVENS COURT, ELY, EAST CAMBRIDGESHIRE, CAMBRIDGESHIRE, CB6 3ED | £420,000 | 27/03/2025 | Detached |
| [Same street] 38 MERLIN DRIVE, ELY, EAST CAMBRIDGESHIRE, CAMBRIDGESHIRE, CB6 3EE | £385,000 | 08/11/2023 | Semi-detached |
| [Same street] 49 MERLIN DRIVE, ELY, EAST CAMBRIDGESHIRE, CAMBRIDGESHIRE, CB6 3EE | £475,000 | 01/11/2023 | Semi-detached |
| [Same street] 32 MERLIN DRIVE, ELY, EAST CAMBRIDGESHIRE, CAMBRIDGESHIRE, CB6 3EE | £335,000 | 30/08/2023 | Semi-detached |
| 71 DOWNHAM ROAD, ELY, EAST CAMBRIDGESHIRE, CAMBRIDGESHIRE, CB6 1BB | £520,000 | 08/06/2023 | Detached |
| [Same street] 17 MERLIN DRIVE, ELY, EAST CAMBRIDGESHIRE, CAMBRIDGESHIRE, CB6 3EE | £340,000 | 28/03/2023 | Detached |
| 90 DUNSTAN STREET, ELY, EAST CAMBRIDGESHIRE, CAMBRIDGESHIRE, CB6 3AQ | £470,000 | 24/03/2023 | Detached |
| [Same street] 28 MERLIN DRIVE, ELY, EAST CAMBRIDGESHIRE, CAMBRIDGESHIRE, CB6 3EE | £405,750 | 17/03/2023 | Terraced |
| 18 ALTHORPE COURT, ELY, EAST CAMBRIDGESHIRE, CAMBRIDGESHIRE, CB6 3DH | £345,000 | 05/12/2022 | Detached |
| 234 COLUMBINE ROAD, ELY, EAST CAMBRIDGESHIRE, CAMBRIDGESHIRE, CB6 3WP | £375,000 | 04/10/2022 | Detached |
| 34 ST ANDREWS WAY, ELY, EAST CAMBRIDGESHIRE, CAMBRIDGESHIRE, CB6 3DZ | £407,000 | 26/09/2022 | Detached |
| 11 BERNARD STREET, ELY, EAST CAMBRIDGESHIRE, CAMBRIDGESHIRE, CB6 1AU | £335,000 | 02/09/2022 | Detached |
| 10 CHIEFS STREET, ELY, EAST CAMBRIDGESHIRE, CAMBRIDGESHIRE, CB6 1AR | £345,000 | 26/08/2022 | Detached |
| 91 DOWNHAM ROAD, ELY, EAST CAMBRIDGESHIRE, CAMBRIDGESHIRE, CB6 3DY | £677,000 | 07/07/2022 | Detached |
| 34 DOWNHAM ROAD, ELY, EAST CAMBRIDGESHIRE, CAMBRIDGESHIRE, CB6 1BL | £800,000 | 16/03/2022 | Detached |
| 89 DOWNHAM ROAD, ELY, EAST CAMBRIDGESHIRE, CAMBRIDGESHIRE, CB6 3DY | £880,000 | 12/01/2022 | Detached |
| 162 WEST FEN ROAD, ELY, EAST CAMBRIDGESHIRE, CAMBRIDGESHIRE, CB6 3AD | £345,000 | 22/12/2021 | Detached |
| [Same street] 44 MERLIN DRIVE, ELY, EAST CAMBRIDGESHIRE, CAMBRIDGESHIRE, CB6 3EE | £420,000 | 10/12/2021 | Detached |
| [Same street] 25 MERLIN DRIVE, ELY, EAST CAMBRIDGESHIRE, CAMBRIDGESHIRE, CB6 3EE | £330,000 | 12/11/2021 | Detached |
| 108 COLUMBINE ROAD, ELY, EAST CAMBRIDGESHIRE, CAMBRIDGESHIRE, CB6 3WN | £530,000 | 24/09/2021 | Detached |
| 31 UPHERDS LANE, ELY, EAST CAMBRIDGESHIRE, CAMBRIDGESHIRE, CB6 1BA | £481,375 | 30/06/2021 | Detached |
| 51 WEST FEN ROAD, ELY, EAST CAMBRIDGESHIRE, CAMBRIDGESHIRE, CB6 1AN | £600,000 | 30/06/2021 | Detached |
| [Same street] 51 MERLIN DRIVE, ELY, EAST CAMBRIDGESHIRE, CAMBRIDGESHIRE, CB6 3EE | £431,111 | 28/06/2021 | Detached |
| 59 DOWNHAM ROAD, ELY, EAST CAMBRIDGESHIRE, CAMBRIDGESHIRE, CB6 1BB | £775,000 | 21/06/2021 | Detached |
| 83 DOWNHAM ROAD, ELY, EAST CAMBRIDGESHIRE, CAMBRIDGESHIRE, CB6 3DY | £435,000 | 11/06/2021 | Detached |

**Street average:** £390,233 (8 sales)
**Area average:** £514,140 (17 sales)

## Price vs local average

*Outcode + property type (HousePrices, last 2 years).*

- **Local average:** £456,840 (49 Detached, CB6, 2024–2026)
- **Deviation:** -52.9%

## Rental Range

*ONS Price Index of Private Rents (East Cambridgeshire). Low / Realistic / Optimistic = conservative / average / best case.*

- **Low:** £916/mo
- **Realistic:** £1,018/mo
- **Optimistic:** £1,120/mo

## Rental Comparables

*Residential lets from OpenRent and Rightmove for the area (same bedroom count). Use to validate rent estimates. Student lets are excluded.*

| Title | Rent | Beds | Distance | As seen on |
|------|------|------|------|------|
| 3 Bed End Terrace, West Fen Road, CB6 | £1,495/mo | 3 | 0.15 miles | OpenRent |
| 3 Bed Terraced House, St. Marys Street, CB7 | £1,350/mo | 3 | 0.37 miles | OpenRent |

**Average rent: £1,423/mo (2 listings)**

## 1% Rule

- **Rent ratio:** 0.66% (weak for cashflow)
- **Max investor price (0.8%):** £177,875
- **Target investor price (1%):** £142,300

*Monthly rent ÷ price. 1%+ = strong, 0.8–1% = okay, <0.8% = weak. Max investor price = rent ÷ 0.8% (Stoke-style target). Target investor price = rent ÷ 1% (strong cashflow band). Based on OpenRent comparables.*

## Rent-driven metrics

*Based on OpenRent comparables (median £1,423/mo).*

- **Gross yield:** 7.9%
- **Cost-to-rent:** 12.6×
- **Monthly cashflow:** £409/mo (75% LTV, 3.95% APR (5yr fixed), 25yr term)
- **Cash-on-cash ROI:** 7.9%

*Gross yield = annual rent as % of price (no costs). Cost-to-rent = price ÷ annual rent (from OpenRent comparables); under 14× = strong, 14–16× = acceptable, 17×+ = compressed. Cashflow = rent − mortgage − 10% maintenance − £25/mo compliance; assumes 75% LTV, 3.95% APR (5yr fixed), 25yr term. ROI = annual profit ÷ cash in (deposit + 4% purchase costs).*

## Capital growth trend

*Land Registry outcode average from sold prices: last 12 months vs 5y and 10y ago.*

- **5y growth:** 36.1%
- **10y growth:** 40.2%

## House Price Index (HM Land Registry)

*Official index for East Cambridgeshire; Detached series; as of March 2026.*

- **1y growth (index):** 0.4%
- **5y growth (index):** 17.9%
- **10y growth (index):** 34.3%

## Flood risk

- **Zone:** 1
- **Risk:** Low
- **Source:** Job (default Low)

[Check long-term flood risk (GOV.UK)](https://check-long-term-flood-risk.service.gov.uk/postcode)

Photo 1 Photo 2 Photo 3 Photo 4 Photo 5 Photo 6 Photo 7 Photo 8 Photo 9 Photo 10 Photo 11 Photo 12 Photo 13

/ 13

Property details

Last sold

£178,500 Jul 2006

Local average

£456,840 (-52.9%)

Deprivation

Decile 10 (30,855 of 33,755)

Street crime

127 incidents within 1 mile (Mar 2026)

Additional details

Parking: Yes
Garden: Yes

Description

Listed by

Ely

David Clark & Company

Reference: 18687594

EPC Rating & Upgrade Cost

Fetching EPC data… Refresh this page in a moment.

Flood risk

Zone: 1

Risk: Low

Job (default Low)

Floorplans

Floorplan 1

FENSA Certificates

This property has 1 FENSA certificate(s) on record, indicating window/door installations by FENSA-approved installers.

FENSA Certificate #11182169

Property Details

Street: 47 Merlin Drive

Town: ELY

Postcode: CB6 3EE

Installation Details

Items: 6 windows

Certificate Issued: 04/09/2015

Work Completed: 28/07/2015

This certificate data was retrieved from FENSA's database

What is FENSA? FENSA (Fenestration Self-Assessment Scheme) is a government-authorised scheme that monitors building regulation compliance for replacement windows and doors. Certificates indicate that work was completed by FENSA-approved installers.

Price history

Event	Date	Price	% change
Sold	19/07/2006 (19 years ago)	£178,500	—

Source: HM Land Registry Price Paid Data. Crown copyright.

Sold Comparables

Same street and nearby sales within 0.25 miles (last 5 years). Data from Land Registry Price Paid.

Address	Price	Date	Type
2 RAVENS COURT, ELY, EAST CAMBRIDGESHIRE, CAMBRIDGESHIRE, CB6 3ED	£420,000	27/03/2025	Detached
Same street 38 MERLIN DRIVE, ELY, EAST CAMBRIDGESHIRE, CAMBRIDGESHIRE, CB6 3EE	£385,000	08/11/2023	Semi-detached
Same street 49 MERLIN DRIVE, ELY, EAST CAMBRIDGESHIRE, CAMBRIDGESHIRE, CB6 3EE	£475,000	01/11/2023	Semi-detached
Same street 32 MERLIN DRIVE, ELY, EAST CAMBRIDGESHIRE, CAMBRIDGESHIRE, CB6 3EE	£335,000	30/08/2023	Semi-detached
71 DOWNHAM ROAD, ELY, EAST CAMBRIDGESHIRE, CAMBRIDGESHIRE, CB6 1BB	£520,000	08/06/2023	Detached
Same street 17 MERLIN DRIVE, ELY, EAST CAMBRIDGESHIRE, CAMBRIDGESHIRE, CB6 3EE	£340,000	28/03/2023	Detached
90 DUNSTAN STREET, ELY, EAST CAMBRIDGESHIRE, CAMBRIDGESHIRE, CB6 3AQ	£470,000	24/03/2023	Detached
Same street 28 MERLIN DRIVE, ELY, EAST CAMBRIDGESHIRE, CAMBRIDGESHIRE, CB6 3EE	£405,750	17/03/2023	Terraced
18 ALTHORPE COURT, ELY, EAST CAMBRIDGESHIRE, CAMBRIDGESHIRE, CB6 3DH	£345,000	05/12/2022	Detached
234 COLUMBINE ROAD, ELY, EAST CAMBRIDGESHIRE, CAMBRIDGESHIRE, CB6 3WP	£375,000	04/10/2022	Detached
34 ST ANDREWS WAY, ELY, EAST CAMBRIDGESHIRE, CAMBRIDGESHIRE, CB6 3DZ	£407,000	26/09/2022	Detached
11 BERNARD STREET, ELY, EAST CAMBRIDGESHIRE, CAMBRIDGESHIRE, CB6 1AU	£335,000	02/09/2022	Detached
10 CHIEFS STREET, ELY, EAST CAMBRIDGESHIRE, CAMBRIDGESHIRE, CB6 1AR	£345,000	26/08/2022	Detached
91 DOWNHAM ROAD, ELY, EAST CAMBRIDGESHIRE, CAMBRIDGESHIRE, CB6 3DY	£677,000	07/07/2022	Detached
34 DOWNHAM ROAD, ELY, EAST CAMBRIDGESHIRE, CAMBRIDGESHIRE, CB6 1BL	£800,000	16/03/2022	Detached
89 DOWNHAM ROAD, ELY, EAST CAMBRIDGESHIRE, CAMBRIDGESHIRE, CB6 3DY	£880,000	12/01/2022	Detached
162 WEST FEN ROAD, ELY, EAST CAMBRIDGESHIRE, CAMBRIDGESHIRE, CB6 3AD	£345,000	22/12/2021	Detached
Same street 44 MERLIN DRIVE, ELY, EAST CAMBRIDGESHIRE, CAMBRIDGESHIRE, CB6 3EE	£420,000	10/12/2021	Detached
Same street 25 MERLIN DRIVE, ELY, EAST CAMBRIDGESHIRE, CAMBRIDGESHIRE, CB6 3EE	£330,000	12/11/2021	Detached
108 COLUMBINE ROAD, ELY, EAST CAMBRIDGESHIRE, CAMBRIDGESHIRE, CB6 3WN	£530,000	24/09/2021	Detached
31 UPHERDS LANE, ELY, EAST CAMBRIDGESHIRE, CAMBRIDGESHIRE, CB6 1BA	£481,375	30/06/2021	Detached
51 WEST FEN ROAD, ELY, EAST CAMBRIDGESHIRE, CAMBRIDGESHIRE, CB6 1AN	£600,000	30/06/2021	Detached
Same street 51 MERLIN DRIVE, ELY, EAST CAMBRIDGESHIRE, CAMBRIDGESHIRE, CB6 3EE	£431,111	28/06/2021	Detached
59 DOWNHAM ROAD, ELY, EAST CAMBRIDGESHIRE, CAMBRIDGESHIRE, CB6 1BB	£775,000	21/06/2021	Detached
83 DOWNHAM ROAD, ELY, EAST CAMBRIDGESHIRE, CAMBRIDGESHIRE, CB6 3DY	£435,000	11/06/2021	Detached

Street average: £390,233 (8 sales)

Area average: £514,140 (17 sales)

Capital growth trend

Land Registry outcode average: last 12 months vs 5y and 10y ago (from sold prices).

5y growth 36.1%

10y growth 40.2%

House Price Index (HM Land Registry — official index, not sold-price averages): East Cambridgeshire. Series: Detached. As of March 2026.

1y (index) 0.4%

5y (index) 17.9%

10y (index) 34.3%

Rental Range

Estimated market rent for East Cambridgeshire. Low = conservative, Realistic = average, Optimistic = best case.

Low £916/mo

Realistic £1,018/mo

Optimistic £1,120/mo

Based on Local Authority from postcode lookup → East Cambridgeshire.

Location

Map view View on Google Maps View on OpenStreetMap Street View CB6 3EE

Nearby

Nearest stations, universities and amenities (distance from property).

Type	Name	Distance
Bus stop	Wrens Close	0.0 miles
Shop	Rowley Fine Art	0.3 miles
Shop	One Stop	0.3 miles
Train station	Ely	1.0 miles
Hospital	Princess of Wales Hospital	1.1 miles
University	Cambridge University Boathouse	1.4 miles
Train station	Littleport	4.8 miles
Hospital	Doddington Community Hospital	10.7 miles

Street-level crime

Category	Count
Violence and sexual offences	41
Anti-social behaviour	33
Shoplifting	27
Criminal damage and arson	5
Public order	5
Other crime	4
Burglary	3
Vehicle crime	3
Drugs	2
Theft from the person	2
Other theft	1
Possession of weapons	1
Total incidents	127

Within 1 mile during Mar 2026. Source: data.police.uk (England & Wales).

Schools nearby

Nearest open schools with Ofsted ratings (England). Closed schools are not shown. Data from Get Information about Schools and Ofsted.

Name	Type	Distance	Ofsted
Active Learning Trust Linc 19 - 25	Other	0.2 miles	— (No rating)
Highfield Ely Academy	Other	0.2 miles	Good — 7 Nov 2014
Ely College	Secondary	0.3 miles	Good — 8 Jul 2019
Lantern Community Primary School	Primary	0.4 miles	Good — 23 Jul 2014
King's Ely	Other	0.5 miles	— (No rating)

Rental Comparables

Residential lets from OpenRent and Rightmove for the area (same bedroom count). Use to validate rent estimates. Student lets are excluded.

Title	Rent	Beds	Distance	As seen on
3 Bed End Terrace, West Fen Road, CB6	£1,495/mo	3	0.15 miles	OpenRent
3 Bed Terraced House, St. Marys Street, CB7	£1,350/mo	3	0.37 miles	OpenRent

Average rent: £1,423/mo (2 listings)

Rent-driven metrics

Based on OpenRent comparables.

Rent ratio 0.66%

Max investor price (0.8%) £177,875

Target investor price (1%) £142,300

Gross yield 7.9%

Cost-to-rent ratio 12.6×

Monthly cashflow £409/mo 75% LTV, 3.95% APR (5yr fixed), 25yr term

Cash-on-cash ROI 7.9%

Rent ratio — Monthly rent ÷ purchase price (1% rule). 1%+ = strong, 0.8–1% = okay, <0.8% = weak for cashflow.
Max investor price — Rent ÷ 0.8%; the price at which rent would be 0.8% of price (Stoke-style target).
Target investor price — Rent ÷ 1%; the price at which rent would be 1% of price (strong cashflow band).
Gross yield — Annual rent as % of purchase price (no costs).
Cost-to-rent — Price ÷ annual rent (from OpenRent comparables). Under 14× = strong, 14–16× = acceptable, 17×+ = compressed.
Cashflow — Rent minus mortgage, 10% maintenance, £25/mo compliance. Assumes 75% LTV, 3.95% APR (5yr fixed), 25yr term.
ROI — Annual profit ÷ cash in (deposit + 4% purchase costs).