Semi-Detached 3 sales on record

17 HENSLOW MEWS

CAMBRIDGE, CAMBRIDGESHIRE, CB2 8BX

£1,595,000

Location

Map view View on Google Maps View on OpenStreetMap Street View CB2 8BX

Nearby

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

Type	Name	Distance
Bus stop	Clarendon Road	0.1 miles
Shop	Co-op Food	0.2 miles
Train station	Cambridge	0.4 miles
University	BPP	1.1 miles
Hospital	Urgent Care Cambridge	2.0 miles

Property details

Tenure

Freehold

Property type

Semi-detached

Bedrooms

Bathrooms

Floor area

202 m²

EPC rating

Year built

England and Wales: 2007-2011

Last sold

£1,595,000 Jul 2026

Price per m²

£7,896/m²

Local average

£835,375 (8 sales)

Street crime

450 incidents within 1 mile (Aug 2026)

EPC Rating & Upgrade Cost

Current rating: C

Potential rating: B

Inspection date: 06/09/2021

Expiry date: 05/09/2031

Current heating cost: £925/year

Potential heating cost: £818/year

Est. upgrade cost to C: £9,900

Recommendations

Time and temperature zone control (£350 - £450)
Solar water heating (£4,000 - £6,000)
Solar photovoltaic panels, 2.5 kWp (£3,500 - £5,500)

View full EPC on gov.uk

Price history

Event	Date	Price	Type	% change	Today’s value (HPI)	Action
Sold	09/07/2026	£1,595,000	Semi-detached	+67.9%	£1,595,000 to July 2026	View transaction
Sold	09/12/2011	£950,000	Semi-detached	+15.9%	£1,598,621 to July 2026	View transaction
Sold	24/09/2010	£820,000	Terraced	—	£1,416,626 to July 2026	View transaction

Historic listings

Listing and sale events only where we matched the listing page to a Land Registry sale already on record for this address.

Event	Date	Price
listed	22/01/2026	£1,595,000
sold	01/01/2026	£1,595,000
sold	01/01/2011	£950,000
sold	01/01/2010	£820,000

Photos · Open listing

Sold comparables

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

Address	Price	Date	Type
11 HENSLOW MEWS, CAMBRIDGE, CAMBRIDGESHIRE, CB2 8BX	£1,450,000	27/11/2023	Semi-detached
48 ABERDEEN AVENUE, CAMBRIDGE, CAMBRIDGESHIRE, CB2 8DZ	£1,450,000	03/11/2022	Semi-detached
9 COPSE WAY, CAMBRIDGE, CAMBRIDGESHIRE, CB2 8BJ	£1,111,250	25/07/2022	Semi-detached
2 MORLAND TERRACE, CAMBRIDGE, CAMBRIDGESHIRE, CB2 8DE	£1,850,000	18/03/2022	Semi-detached

Area average: £1,465,313 (4 sales)

For sale comparables

No active for-sale comparables found within 1 mile for the same bedrooms and property type.

Capital growth trend

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

5y growth 26.2%

10y growth 135.9%

House Price Index (HM Land Registry — official index, not sold-price averages): Cambridge. Series: Semi-detached. As of July 2026.

1y (index) 1.2%

5y (index) 9.3%

10y (index) 15.9%

Rental Range

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

Low £1,625/mo

Realistic £1,805/mo

Optimistic £1,986/mo

Based on Local Authority from postcode lookup → Cambridge.

LHA (30th percentile) floor for Cambridge: Apr 2025 – Mar 2026

Rental Comparables

Residential lets in the area (all bedroom counts shown — none matched the 4-bedroom count for this property). Student lets are excluded.

Title	Rent	Beds	Distance	As seen on
2 Bed Flat, Glenalmond Ave, CB2	£3,750/mo	2	0.16 miles	OpenRent
2 Bed Flat, Glenalmond Avenue, CB2	£2,250/mo	2	0.17 miles	OpenRent
3 Bed Semi-Detached House, Bancroft Close, CB1	£2,200/mo	3	0.53 miles	OpenRent
1 Bed Flat, Cambridge, CB1	£1,475/mo	1	0.62 miles	OpenRent
1 Bed Flat, Nr Addenbrookes, CB1	£1,350/mo	1	0.62 miles	OpenRent
1 Bed Flat, Nr Hospitals Cherry Hinton Road, CB1	£1,350/mo	1	0.62 miles	OpenRent
1 Bed Flat, Cherry Hinton Road, CB1	£1,350/mo	1	0.62 miles	OpenRent

Average rent: £1,961/mo (7 listings)

Rent-driven metrics

Based on OpenRent comparables.

Rent ratio 0.09%

Max investor price (0.8%) £184,375

Target investor price (1%) £147,500

Gross yield 1.1%

Cost-to-rent ratio 90.1×

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

Cash-on-cash ROI -12.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).

Flood risk

Zone: 1

Risk: Low

Not in Flood Risk Area (no data)

Registered land (INSPIRE)

This location falls inside an HM Land Registry INSPIRE registered freehold polygon.

Plot: ~20,020 m² (4.95 acres)

Source: HM Land Registry INSPIRE Index Polygons.

Street-level crime

Category	Count
Violence and sexual offences	114
Anti-social behaviour	85
Shoplifting	49
Bicycle theft	47
Public order	39
Criminal damage and arson	36
Other theft	33
Burglary	15
Drugs	10
Vehicle crime	7
Other crime	4
Robbery	4
Theft from the person	4
Possession of weapons	3
Total incidents	450

Within 1 mile during Aug 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
Hills Road Sixth Form College	Other	0.3 miles	— (No rating)
Abbey College Cambridge	Other	0.3 miles	— (No rating)
St. Andrew's College Cambridge	Other	0.3 miles	— (No rating)
St Faith's School	Other	0.3 miles	— (No rating)
St Mary's School	Other	0.4 miles	— (No rating)

FENSA

No FENSA certificates found for this address.

# 17 HENSLOW MEWS, CAMBRIDGE, CAMBRIDGESHIRE, CB2 8BX

## Property details

- Slug: `065f361` (address key hash: `065f361ad7b918a6d0e6b003bdd2eb0691ffbb4f`)
- Postcode: CB2 8BX
- Transactions on record: 3

- Tenure: Freehold
- Property type: Semi-detached
- Bedrooms: 4
- Bathrooms: 4
- Floor area: 202 m²
- EPC rating: C
- Year built: England and Wales: 2007-2011
- Last sold: £1,595,000 Jul 2026
- Price per m²: £7,896/m²
- Local average: £835,375 (8 sales)
- Street crime: 450 incidents within 1 mile (Aug 2026)

## Latest sale

- Price: £1,595,000
- Date: 2026-07-09
- Type: S
- Tenure: F

## EPC Rating & Upgrade Cost

- **Current rating:** C
- **Potential rating:** B
- **Expiry date:** 05/09/2031
- **Current heating cost:** £925/year
- **Est. upgrade cost to C:** £9,900

### Recommendations
- G (£350 - £450)
- N (£4,000 - £6,000)
- U (£3,500 - £5,500)

[View full EPC on gov.uk](https://find-energy-certificate.service.gov.uk/energy-certificate/2147-3272-1941-1780-1906)

## Price history

| Event | Date | Price | Type | % change | Today’s value (HPI) | Transaction |
|-------|------|-------|------|--------|---------------------|-------------|
| Sold | 2026-07-09 | £1,595,000 | Semi-detached | +67.9% | £1,595,000 (to July 2026) | [View](http://87.117.209.195:8080/house-prices/5834e4e8-74ea-29c7-e063-4804a8c015bc) |
| Sold | 2011-12-09 | £950,000 | Semi-detached | +15.9% | £1,598,621 (to July 2026) | [View](http://87.117.209.195:8080/house-prices/e3429c84-9442-4def-9059-54fc47470e48) |
| Sold | 2010-09-24 | £820,000 | Terraced | — | £1,416,626 (to July 2026) | [View](http://87.117.209.195:8080/house-prices/22948cf1-0869-4abd-9b01-ff7a0d403dfd) |

*Today’s value (HPI): adjusted using published house price index trends for the area and property type; not a valuation of the property today.*

## Sales History

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

| Address | Price | Date | Type |
|---------|-------|------|------|
| 17 HENSLOW MEWS, CAMBRIDGE, CAMBRIDGESHIRE, CB2 8BX | £1,595,000 | 09/07/2026 | Semi-detached |
| 17 HENSLOW MEWS, CAMBRIDGE, CAMBRIDGESHIRE, CB2 8BX | £950,000 | 09/12/2011 | Semi-detached |
| 17 HENSLOW MEWS, CAMBRIDGE, CAMBRIDGESHIRE, CB2 8BX | £820,000 | 24/09/2010 | Terraced |

## Historic listings

Listing activity only where we matched the listing to a Land Registry sale already on record for this address.

- Matched listing: [171292388](http://87.117.209.195:8080/listings/902d564)

| Event | Date | Price |
|-------|------|-------|
| listed | 2026-01-22 | £1,595,000 |
| sold | 2026-01-01 | £1,595,000 |
| sold | 2011-01-01 | £950,000 |
| sold | 2010-01-01 | £820,000 |

## Sold Comparables

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

| Address | Price | Date | Type |
|---------|-------|------|------|
| 11 HENSLOW MEWS, CAMBRIDGE, CAMBRIDGESHIRE, CB2 8BX | £1,450,000 | 27/11/2023 | Semi-detached |
| 48 ABERDEEN AVENUE, CAMBRIDGE, CAMBRIDGESHIRE, CB2 8DZ | £1,450,000 | 03/11/2022 | Semi-detached |
| 9 COPSE WAY, CAMBRIDGE, CAMBRIDGESHIRE, CB2 8BJ | £1,111,250 | 25/07/2022 | Semi-detached |
| 2 MORLAND TERRACE, CAMBRIDGE, CAMBRIDGESHIRE, CB2 8DE | £1,850,000 | 18/03/2022 | Semi-detached |

**Area average:** £1,465,313 (4 sales)

## Capital growth trend

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

- **5y growth:** 26.2%
- **10y growth:** 135.9%

## House Price Index (HM Land Registry)

*Official index for Cambridge; Semi-detached series; as of July 2026.*

- **1y growth (index):** 1.2%
- **5y growth (index):** 9.3%
- **10y growth (index):** 15.9%

## Rental Range

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

- **Low:** £1,625/mo
- **Realistic:** £1,805/mo
- **Optimistic:** £1,986/mo

## LHA (Local Housing Allowance)

*VOA 30th percentile rent floor for Cambridge (Apr 2025 – Mar 2026).*

## Rental Comparables

*Residential lets in the area (all bedroom counts shown — none matched the 4-bedroom count for this property). Student lets are excluded.*

| Title | Rent | Beds | Distance | As seen on |
|------|------|------|------|------|
| 2 Bed Flat, Glenalmond Ave, CB2 | £3,750/mo | 2 | 0.16 miles | OpenRent |
| 2 Bed Flat, Glenalmond Avenue, CB2 | £2,250/mo | 2 | 0.17 miles | OpenRent |
| 3 Bed Semi-Detached House, Bancroft Close, CB1 | £2,200/mo | 3 | 0.53 miles | OpenRent |
| 1 Bed Flat, Cambridge, CB1 | £1,475/mo | 1 | 0.62 miles | OpenRent |
| 1 Bed Flat, Nr Addenbrookes, CB1 | £1,350/mo | 1 | 0.62 miles | OpenRent |
| 1 Bed Flat, Nr Hospitals Cherry Hinton Road, CB1 | £1,350/mo | 1 | 0.62 miles | OpenRent |
| 1 Bed Flat, Cherry Hinton Road, CB1 | £1,350/mo | 1 | 0.62 miles | OpenRent |

**Average rent: £1,961/mo (7 listings)**

## 1% Rule

- **Rent ratio:** 0.09% (weak for cashflow)
- **Max investor price (0.8%):** £184,375
- **Target investor price (1%):** £147,500

*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,475/mo).*

- **Gross yield:** 1.1%
- **Cost-to-rent:** 90.1×
- **Monthly cashflow:** £-4,979/mo (75% LTV, 3.95% APR (5yr fixed), 25yr term)
- **Cash-on-cash ROI:** -12.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).*

## Flood risk

- **Zone:** 1
- **Risk:** Low
- **Source:** Not in Flood Risk Area (no data)

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

## Street-level crime

| Category | Count |
|----------|-------|
| Violence and sexual offences | 114 |
| Anti-social behaviour | 85 |
| Shoplifting | 49 |
| Bicycle theft | 47 |
| Public order | 39 |
| Criminal damage and arson | 36 |
| Other theft | 33 |
| Burglary | 15 |
| Drugs | 10 |
| Vehicle crime | 7 |
| Other crime | 4 |
| Robbery | 4 |
| Theft from the person | 4 |
| Possession of weapons | 3 |
| **Total incidents** | **450** |

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

## Schools nearby

*Nearest open schools with Ofsted ratings (England). Closed schools are not shown.*

| Name | Type | Distance | Ofsted |
|------|------|----------|--------|
| Hills Road Sixth Form College | Other | 0.3 miles | — (No rating) |
| Abbey College Cambridge | Other | 0.3 miles | — (No rating) |
| St. Andrew's College Cambridge | Other | 0.3 miles | — (No rating) |
| St Faith's School | Other | 0.3 miles | — (No rating) |
| St Mary's School | Other | 0.4 miles | — (No rating) |