# 21 RENARD WAY, TRUMPINGTON, CAMBRIDGE, CAMBRIDGESHIRE, CB2 9EW

## Property details

- Slug: `23011c3` (address key hash: `23011c3f3d593b803d7f954aca06f2930bbf5ce3`)
- Postcode: CB2 9EW
- Transactions on record: 2

- Tenure: Freehold
- Property type: Semi-detached
- Floor area: 160 m²
- EPC rating: B
- Last sold: £740,000 Jan 2026
- Price per m²: £4,625/m²
- Local average: £716,333 (6 sales)
- Street crime: 88 incidents within 1 mile (Apr 2026)

## Latest sale

- Price: £740,000
- Date: 2026-01-26
- Type: S
- Tenure: F

## EPC Rating & Upgrade Cost

- **Current rating:** B
- **Potential rating:** B
- **Expiry date:** 07/06/2026 — **EXPIRED** (no longer valid for marketing or letting)
- **Current heating cost:** £352/year
- **Est. upgrade cost to C:** £5,000

### Recommendations
- N (£4,000 - £6,000)

[View full EPC on gov.uk](https://find-energy-certificate.service.gov.uk/energy-certificate/8408-2284-5539-9007-8663)

## Price history

| Event | Date | Price | Type | % change | Today’s value (HPI) | Transaction |
|-------|------|-------|------|--------|---------------------|-------------|
| Sold | 2026-01-26 | £740,000 | Semi-detached | +13.8% | £744,370 (to March 2026) | [View](http://87.117.209.195:8080/house-prices/49e87c31-9e55-591c-e063-4704a8c00c31) |
| Sold | 2016-06-29 | £649,995 | Semi-detached | — | £823,166 (to March 2026) | [View](http://87.117.209.195:8080/house-prices/3b7e0b8f-8b90-ea99-e050-a8c062057e77) |

*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 |
|---------|-------|------|------|
| 21 RENARD WAY, TRUMPINGTON, CAMBRIDGE, CAMBRIDGESHIRE, CB2 9EW | £740,000 | 26/01/2026 | Semi-detached |
| 21 RENARD WAY, TRUMPINGTON, CAMBRIDGE, CAMBRIDGESHIRE, CB2 9EW | £649,995 | 29/06/2016 | 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 |
|---------|-------|------|------|
| 54 CHARGER ROAD, TRUMPINGTON, CAMBRIDGE, CAMBRIDGESHIRE, CB2 9EA | £800,000 | 05/11/2025 | Semi-detached |
| 151 OSPREY DRIVE, TRUMPINGTON, CAMBRIDGE, SOUTH CAMBRIDGESHIRE, CAMBRIDGESHIRE, CB2 9FU | £818,000 | 11/07/2025 | Semi-detached |
| 2 CARMINE ROAD, TRUMPINGTON, CAMBRIDGE, CAMBRIDGESHIRE, CB2 9ED | £765,000 | 10/11/2022 | Semi-detached |
| 10 CHARGER ROAD, TRUMPINGTON, CAMBRIDGE, CAMBRIDGESHIRE, CB2 9EA | £770,100 | 17/06/2022 | Semi-detached |
| 89 OSPREY DRIVE, TRUMPINGTON, CAMBRIDGE, SOUTH CAMBRIDGESHIRE, CAMBRIDGESHIRE, CB2 9FU | £750,000 | 10/03/2022 | Semi-detached |
| 117 OSPREY DRIVE, TRUMPINGTON, CAMBRIDGE, SOUTH CAMBRIDGESHIRE, CAMBRIDGESHIRE, CB2 9FU | £148,000 | 11/02/2022 | Semi-detached |
| 147 OSPREY DRIVE, TRUMPINGTON, CAMBRIDGE, SOUTH CAMBRIDGESHIRE, CAMBRIDGESHIRE, CB2 9FU | £839,995 | 07/01/2022 | Semi-detached |
| 34 PLOUGHMAN WAY, TRUMPINGTON, CAMBRIDGE, SOUTH CAMBRIDGESHIRE, CAMBRIDGESHIRE, CB2 9GE | £172,000 | 29/10/2021 | Semi-detached |
| 31 RENARD WAY, TRUMPINGTON, CAMBRIDGE, SOUTH CAMBRIDGESHIRE, CAMBRIDGESHIRE, CB2 9EW | £795,000 | 27/10/2021 | Semi-detached |
| 14 HUNTSMAN ROAD, TRUMPINGTON, CAMBRIDGE, CAMBRIDGESHIRE, CB2 9BJ | £500,000 | 29/06/2021 | Semi-detached |
| 37 CONSORT AVENUE, TRUMPINGTON, CAMBRIDGE, CAMBRIDGESHIRE, CB2 9AE | £510,000 | 23/06/2021 | Semi-detached |
| 7 BRITANNIA WALK, TRUMPINGTON, CAMBRIDGE, SOUTH CAMBRIDGESHIRE, CAMBRIDGESHIRE, CB2 9GG | £759,995 | 18/06/2021 | Semi-detached |

**Area average:** £635,674 (12 sales)

## Capital growth trend

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

- **5y growth:** -37.2%

## House Price Index (HM Land Registry)

*Official index for South Cambridgeshire; Semi-detached series; as of March 2026.*

- **1y growth (index):** 0.4%
- **5y growth (index):** 13.1%
- **10y growth (index):** 26.8%

## Rental Range

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

- **Low:** £1,262/mo
- **Realistic:** £1,402/mo
- **Optimistic:** £1,542/mo

## LHA (Local Housing Allowance)

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

## Rental Comparables

*Residential lets from OpenRent and Rightmove for the area. Bedroom counts vary — use the Beds column to compare like-for-like lets. Student lets are excluded.*

| Title | Rent | Beds | Distance | As seen on |
|------|------|------|------|------|
| 1 Bed Flat, Trumpington, CB2 | £1,480/mo | 1 | 0.86 miles | OpenRent |
| 2 Bed Flat, Trumpington, CB2 | £1,950/mo | 2 | 0.9 miles | OpenRent |
| 4 Bed End Terrace, Baker Lane, CB2 | £3,000/mo | 4 | 0.91 miles | OpenRent |

**Average rent: £2,143/mo (3 listings)**

## 1% Rule

- **Rent ratio:** 0.26% (weak for cashflow)
- **Max investor price (0.8%):** £243,750
- **Target investor price (1%):** £195,000

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

- **Gross yield:** 3.2%
- **Cost-to-rent:** 31.6×
- **Monthly cashflow:** £-1,184/mo (75% LTV, 3.95% APR (5yr fixed), 25yr term)
- **Cash-on-cash ROI:** -6.6%

*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 | 20 |
| Anti-social behaviour | 18 |
| Shoplifting | 9 |
| Other theft | 8 |
| Bicycle theft | 6 |
| Criminal damage and arson | 6 |
| Other crime | 5 |
| Public order | 5 |
| Burglary | 4 |
| Vehicle crime | 3 |
| Drugs | 2 |
| Theft from the person | 2 |
| **Total incidents** | **88** |

*Within 1 mile during Apr 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 |
|------|------|----------|--------|
| Trumpington Meadows Primary School | Primary | 0.1 miles | Good — 23 Mar 2018 |
| Trumpington Park Primary School | Primary | 0.8 miles | Good — 23 Mar 2022 |
| Fawcett Primary School | Primary | 0.8 miles | Good — 20 Oct 2011 |
| Trumpington Community College | Secondary | 1.1 miles | Good — 23 Jan 2024 |
| Long Road Sixth Form College | Other | 1.4 miles | — (No rating) |