4-bedroom flat · CB2 8PQ
Listing removedListed 121 days · slow let
Opportunity summary
See Archie’s verdict, returns by strategy and what to check before viewing.
About
Tucked discreetly away from one of Cambridge’s most distinguished roads lies an exclusive collection of just six newly built residences, each crafted with meticulous attention to detail.
Tucked discreetly away from one of Cambridge's most distinguished roads lies an exclusive collection of just six exclusive residences-each crafted with meticulous attention to detail.
This striking duplex apartment spans over 1,730 sq ft across two floors, offering a rare blend of contemporary design, generous proportions, and timeless sophistication.
On the second floor, three well-proportioned bedrooms and a dedicated study provide flexibility for both family life and home working.
The principal suite is a true retreat, complete with a luxurious ensuite bathroom featuring porcelain mixed-format tiles, rainfall shower, and sleek twin vanity.
A further family bathroom and discreet utility room add everyday convenience. The third floor is entirely dedicated to open-plan living.
At its heart is a beautifully designed kitchen by Naked Kitchens, finished with quartz worktops and premium Siemens and Fisher & Paykel appliances-including a flush induction hob, recessed sink, integrated oven, microwave, and dishwasher.
A central island offers relaxed seating, while sustainably sourced herringbone timber flooring and underfloor heating create a warm, inviting feel.
Expansive living and dining areas flow seamlessly to a private balcony, overlooking leafy surroundings and designed for both calm and entertaining.
Additional highlights include private driveway parking with EV charging point, secure cycle storage, and energy-efficient underfloor heating powered by an air source heat pump.
Crafted by renowned local developers Bowson Leeway Homes, this development is set to become a modern Cambridge classic. Quietly confident. Effortlessly elegant. And unmistakably Cambridge.
Available September 2026, to a professional couple, small family or single occupant.
Please refer to the 'Tenant Guide' brochure, for more information regarding the tenancy application process, referencing, terms and conditions of the holding fee and payments due before the start of the tenancy.
UK power networks suggest the gas and electricity is currently supplied by: Tbc Ofcom suggests the maximum broadband speed is: Tbc suggests the property has a very low flood risk.
Situated on Hills Road, this property is ideally placed for city life and excellent transport links.
Cambridge Station is around an 18-minute walk or a short cycle away, with the historic city centre reached on foot in about 30 minutes.
Addenbrooke's Hospital and Biomedical Campus are within easy reach, and many of the city's independent schools and university departments can be accessed quickly by bicycle.
Directly opposite lies the Cambridge University Botanic Garden, offering 40 acres of tranquil green space to enjoy away from the bustle of the city.
Education provision is excellent, with the property falling into catchment for several Ofsted-rated 'Outstanding' schools, including St. Albans Primary and Parkside Community College.
The highly regarded Hills Road Sixth Form College is also close at hand. The neighbourhood itself is well-served with a wide choice of restaurants, cafés, pubs, and shops.
Nearby Clifton Road Leisure Park provides a gym, cinema, and popular chain eateries, alongside The Junction arts venue with its programme of live music, theatre, and comedy.
Value & comps
No previous sales on record.
Rental comparables are shown in the Rental section below. Sold comparables remain for area capital context only.
Returns
We're still gathering serviced-accommodation data for this area.
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 advisors 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 Flat 5, 174, Hills Road, Cambridge
Explore nearby