# 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) |