Worst House on the Street Logo
Lot 2 - Waterloo Farmhouse, Great Stukeley, Huntingdon, Cambridgeshire, PE28 - Image 1
Lot 2 - Waterloo Farmhouse, Great Stukeley, Huntingdon, Cambridgeshire, PE28 - Image 2
Lot 2 - Waterloo Farmhouse, Great Stukeley, Huntingdon, Cambridgeshire, PE28 - Image 3
Lot 2 - Waterloo Farmhouse, Great Stukeley, Huntingdon, Cambridgeshire, PE28 - Image 4
Lot 2 - Waterloo Farmhouse, Great Stukeley, Huntingdon, Cambridgeshire, PE28 - Image 5

Lot 2 - Waterloo Farmhouse, Great Stukeley, Huntingdon, Cambridgeshire, PE28

East of England

£550,000
Listed on 30/01/2026

Property Details

Bedrooms
6
Type
Detached house
Area
2887 sqft

Description

Waterloo Farmhouse, a spacious six-bedroom detached property nestled within approximately 0.91 acres, offers significant potential for both residential and commercial development amidst a serene rural backdrop. The farmhouse, constructed of brick with double-glazed windows, boasts a generous living space of around 2,887 sq ft, complete with an attached garage. The ground floor features practical amenities such as a utility room and W/C, alongside four bedrooms and two bathrooms. A staircase leads to the first floor, where you’ll find two additional double bedrooms and a versatile games room, providing ample opportunity for reconfiguration. In addition to the farmhouse, the site includes an extensive set of twelve farm buildings over a total area of about 2.93 acres. Notably, one building—a former grain store—offers promising prospects for conversion into residential units (subject to planning permission). This building spans approximately 2,356 sq ft and is ready for transformation with its concrete flooring and robust construction. With diverse possibilities for renovation or redevelopment (STPP), Waterloo Farmhouse stands as an attractive investment opportunity in close proximity to key transport links and local amenities.

Investment Analysis

(PE28 area)

Below Market Value

This property is priced -41.7% below area average per sq ft

-41.7%
Potential saving
This Property
£191/sq ft
Area Average
£327/sq ft
Avg Rent (weekly)
£316
Avg Yield
4.0%

Renovation Potential

Medium Refurb
Est. Renovation Cost
£100,000 - £150,000
Target Value
£1,038,454
10% above area average per sq ft
Potential ROI
+48.4%
After renovation
Note: Renovation cost estimates are AI-generated based on property location and general characteristics, and may not reflect actual costs.
Monthly Sales
52
Average per month
Market Turnover
33%
Properties sold annually

Local Market Trend (PE28)

Area prices are stable by 0.0% over the last 12 months
3 year growth: -1.9%
5 year growth: +9.1%
Investment Disclaimer: Analysis based on PE28 area averages and may not reflect property-specific factors like condition, exact location, or unique features. Any renovation cost estimates provided are AI-generated and should be considered indicative only. Renovation costs vary significantly based on property condition and scope of work. Always conduct professional surveys and get multiple quotes before making investment decisions.

Location

Lot 2 - Waterloo Farmhouse, Great Stukeley, Huntingdon, Cambridgeshire, PE28
Loading map...

Mortgage Calculator

£
£
£
%
%
years

Current average 2-year fixed rate is 4.06%

Current average variable rate is 6.81%

Monthly Repayments
£1,984
Based on a loan of £412,500 over 30 years at 4.06% interest

These results are estimates and are only intended as a guide. Make sure you obtain accurate figures from your lender before committing to any mortgage. Your home may be repossessed if you do not keep up repayments on a mortgage.

Next Steps

Explore services to help you with this property purchase.

Get help with this property

Financing, surveys and more – choose a service and we’ll connect you with our trusted partners.

Finance for Buy-to-Let, Bridging & Development