Red Brick Farm, Flat 2, Main Street, Hardwick, Cambridge, CB23 7QS
About Red Brick Farm
Red Brick Farm is a semi-detached house in Hardwick, Cambridge, Cambridge (CB23 7QS). It has a recorded floor area of 84 m² (around 904 sq ft), construction records dating it to 1900-1929 and council tax band D. The latest certificate (May 2017) shows an E (score 51), well below the UK norm with real room to improve. The recommended improvements would lift it to A (score 107), a 4-band jump. Main heating runs on oil.
Held since January 1999 — that's 27 years off the open market, well above the local norm. Only one transfer is on record with HM Land Registry, suggesting it has stayed in the same hands for a long time. At 84 m² it sits well below the postcode median (205 m² across 10 EPCs), making it one of the more compact homes locally. On energy efficiency it sits in the bottom 10% of properties in this postcode — significant headroom for improvement. Today's modelled estimate of £454,000 sits 354% above the 1999 sale of £100,000. On a £-per-square-foot basis, the last sale (£111/sq ft) was about 64.8% below the postcode norm.
Know exactly what you're buying at Red Brick Farm
Before you offer, see what the listing won't tell you, the true value, the red flags and the full history.
Already flagged here
Launch offer · save £5
Valuation
against the asking price
Risks
planning & flood
Sold prices
similar homes nearby
Trends
the local market
Energy performance
Red Brick Farm sits at the bottom of the postcode for energy efficiency — meaningful headroom to improve.
EPC Rating
Planning history
Red Brick Farm has no planning applications on record.
Notable planning nearby
1applications of note in the surrounding area
We flagged 1 thing worth checking at Red Brick Farm
Independent checks surfaced things a buyer would want to understand before offering. The report explains each one in full, with the underlying data and what to ask.
- Larger development activity nearby
30-day money-back guarantee
Sales history & valuation
Latest sale on Red Brick Farm was the lowest on Land Registry record across the postcode.
£454,000
Modelled from EPC, postcode comparables.
£100,000
Recorded with HM Land Registry.
Sales timeline
14 January 1999Most recent
£100,000
Median price across the last 5 sales in CB23 7QS: £1,375,000 (2023–2020).
Nearby sales in CB23 7QS
1 St Marys Court, Main Street, Hardwick, Cambridge, CB23 7QS
Sold Nov 2023
£1,460,00044 Main Street, Hardwick, Cambridge, CB23 7QS
Sold Feb 2023
£1,450,00030 Main Street, Hardwick, Cambridge, CB23 7QS
Sold Aug 2021
£525,0008 Main Street, Hardwick, Cambridge, CB23 7QS
Sold Aug 2021
£1,375,0002 Main Street, Hardwick, Cambridge, CB23 7QS
Sold Nov 2020
£557,000
Everything we know about Red Brick Farm, in one report
What it's really worth, what could be wrong, and the planning, sales and area data in full.
What we flagged
- Larger development activity nearby

Versus other Main Street homes
Red Brick Farm is notably below the street on price per m².
Price per m²
£1,190
Street avg £3,752
Floor Area
84 m²
Street avg 214 m²
Habitable Rooms
5 rooms
Street avg 7 rooms
CO₂ Emissions
5.5 t/year
Street avg 6.4 t/year
Similar properties nearby
Red Brick Farm, Flat 1, Main Street, Hardwick
CB23 7QS
Flat, 2 Comberton Road, Barton
CB23 7BA
School Court, Flat 3, Furlong Way, Highfields Caldecote
CB23 7AA
School Court, Flat 4, Furlong Way, Highfields Caldecote
CB23 7AA
School Court, Flat 5, Furlong Way, Highfields Caldecote
CB23 7AA
School Court, Flat 6, Furlong Way, Highfields Caldecote
CB23 7AA
Flat, 3 Roman Hill, Barton
CB23 7AX
The neighbourhood at a glance
Daytime road noise here sits well below conversation level — a quiet pocket of the postcode.
Crime
2/mo
Steady year-on-year across the wider district.
Closest school
0.5 km
Hardwick and Cambourne Community Primary School. 4 schools nearby.
Go deeper on the local area
The full report breaks down crime, transport links, schools and air quality in depth.
Road noise across the postcode

Daytime· 07:00 – 23:00
44.3dB

Night-time· 23:00 – 07:00
37.6dB