5-bedroom detached house · CB22 5EN
Sold STCReduced £510k (−14.6%) on 22 SepListed 737 days
Opportunity summary
See Archie’s verdict, returns by strategy and what to check before viewing.
About
An extensive and award-winning luxury home, with pool and leisure complex, sitting in 0.56 acres, on a highly sought after private road in this desirable south Cambridgeshire village.
Cambridge City Centre 4 miles, M11 (junction 11) 3 miles, Great Shelford Railway Station (King’s Cross and Liverpool lines) 0.5 of a mile, Addenbrooke’s Hospital/Biomedical Campus 3 miles (distances are approximate).
Aspen House was constructed by Fairfield Homes and won the UK Single Unit Development of the Year title at the labc Warranty Brick Awards in 2017.
The property features spacious, well-proportioned accommodation and current owners have carried out an extensive programme of improvements including a state-of-the-art indoor swimming pool and leisure complex, landscaping of the gardens and installation of the latest technologies, resulting in a wonderful, modern home.
A particularly attractive feature of the property is the pool and leisure complex, housing a 12m x 4m indoor pool constructed by the award-winning Origin Leisure and features jacuzzi, automatic pool cover, automatic dozing systems coupled with uv light technology, total temperature control, a waterproof 55-inch TV with surrounding Yamaha audio system and a stand-in shower.
The complex also benefits from a Norwegian infra-red Sauna, a robotic full tennis table and leisure area.
Great Shelford is one of the most popular of the necklace villages around Cambridge, benefitting from a good range of local facilities including a variety of shops, bank, primary school, library, church, health centre and recreation ground with tennis courts.
It is also conveniently placed for commuters by road or rail with the M11 (junction 11) about 3 miles away, providing good access to Stansted Airport and the M25.
There is a mainline railway station in the village with services to King’s Cross and Liverpool Street.
Nearby, Cambridge is a highly acclaimed University city and is also recognised as the centre of the ‘high tech’ and ‘bio tech’ industries with the University Research and Development Laboratories, the internationally renowned Cambridge Science Park and Addenbrooke’s Hospital/Biomedical Campus.
The city provides an attractive combination of ancient and modern buildings, colleges, winding lanes, extensive shopping facilities and an excellent choice of private schools on the south and west sides of the city including the Perse (pre-school, prep & upper), the Stephen Perse foundation schools, The Leys, St Mary’s, St John’s & King’s College prep Schools and a primary school in Great Shelford.
Value & comps
No previous sales on record.
Returns
Set an offer; the calculator follows it.
We're still gathering serviced-accommodation data for this area.
Archie refurb estimate: a Pro feature
0.0% below asking
This is not financial or investment advice. Prop AI Deals is not authorised by the Financial Conduct Authority (FCA) to provide investment advice.
All investment calculators, property analyses, and AI-generated insights are for informational purposes only. Property investment carries risk and may result in financial loss. All calculations should be independently verified and you should consult with FCA-authorised financial advisers before making any investment decisions.
Past performance does not guarantee future results. Tax implications vary by individual circumstances.
Deal
Properties like this can earn 2–3x BTL yields when converted to HMO, with retrofit costs around £10k/room. Sign in to see the full tier, yield projection, and cost breakdown.
Commercial properties like this can earn 30-50% higher yields when converted to residential under Class MA / Q / P / PA, with prior approval costing ~GBP 96/unit. Sign in to see the recommended route, yield uplift, and cost breakdown.
BRRR-suited properties can recycle 80-100% of investor capital on refi, leaving a high-yielding rental with most of the money out. Sign in to see the refurb cost stack, ARV projection, and refinance maths.
Detached + large garden = sub-division play. Pro tier unlocks the tier badge, plot size, uplift estimate, and regional land benchmark.
Short-lease flats trade at deep discount, but extending under the 1993 Act often costs far less than the discount. Pro tier unlocks the tier badge, premium breakdown, long-lease ARV and arbitrage maths.
See projected short-stay revenue vs a vanilla BTL for this property.
See real sub-let margins (HMO room rates & SA nightly rates) vs the landlord rent.
Area
Agent & docs
.png)
FAQ
About Aspen House,, Kings Mill Lane, Cambridge
Explore nearby