Semi-Detached 2 sales on record

21 RENARD WAY

TRUMPINGTON, CAMBRIDGE, CAMBRIDGESHIRE, CB2 9EW

£740,000

Location

Map view View on Google Maps View on OpenStreetMap Street View CB2 9EW

Nearby

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

Type	Name	Distance
Shop	Frankie's Salon	0.1 miles
Bus stop	The Busway Trumpington Park-and-Ride	0.2 miles
Train station	Shelford	2.1 miles
University	BPP	2.5 miles
Hospital	Urgent Care Cambridge	3.6 miles

Property details

Tenure

Freehold

Property type

Semi-detached

Floor area

160 m²

EPC rating

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)

EPC Rating & Upgrade Cost

This certificate expired on 07/06/2026. A new EPC may be required before the property can be marketed or let.

Current rating: B

Potential rating: B

Inspection date: 08/06/2016

Expiry date: 07/06/2026 (expired)

Current heating cost: £352/year

Potential heating cost: £354/year

Est. upgrade cost to C: £5,000

Recommendations

Solar water heating (£4,000 - £6,000)

View full EPC on gov.uk

Price history

Event	Date	Price	Type	% change	Today’s value (HPI)	Action
Sold	26/01/2026	£740,000	Semi-detached	+13.8%	£744,370 to March 2026	View transaction
Sold	29/06/2016	£649,995	Semi-detached	—	£823,166 to March 2026	View transaction

Historic listings

No historic listing events could be matched to the sales on record for this address. We only show events where a listing page could be linked to a Land Registry sale here.

Sold comparables

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

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)

For sale comparables

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

Capital growth trend

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

5y growth -37.2%

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

1y (index) 0.4%

5y (index) 13.1%

10y (index) 26.8%

Rental Range

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

Low £1,262/mo

Realistic £1,402/mo

Optimistic £1,542/mo

Based on Local Authority from postcode lookup → South Cambridgeshire.

LHA (30th percentile) 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)

Rent-driven metrics

Based on OpenRent comparables.

Rent ratio 0.26%

Max investor price (0.8%) £243,750

Target investor price (1%) £195,000

Gross yield 3.2%

Cost-to-rent ratio 31.6×

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

Cash-on-cash ROI -6.6%

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)

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. Data from Get Information about Schools and Ofsted.

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)

FENSA

Checking FENSA certificates for this address. Refresh in a few minutes.

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