Walnut Tree Farm, Plunder Street, Cleeve, Bristol, BS49 4PQ

UPRN:24059391Detached House5 bedsBuilt before 1900

FreeholdCouncil Tax: Band HEPC: G (13)

Data freshness:Listing· freshPrice Paid· freshPlanning· 4mo agoEPC· 6mo agoRisk· 5mo agoConnectivity· 1mo agoSchools· 1mo agoAmenities· 1mo agoArea· Census 2021

Walnut Tree Farm, Plunder Street, Cleeve, Bristol, BS49 4PQ

HP Score

/ 100

Mixed

Verdict

yesterday

Verdict: INVESTIGATE, on a scale of Buy, Investigate, Avoid.
Mixed signals - investigate

Evidence

17 of 21 sources

Sale Estimate

£1,778,000

£1.60M - £1.96MMedium

Estimate

£1.78M

Range

£1.60M – £1.96M

Rent Estimate (pcm)

£3,900

£3k - £5k

Monthly

£3,900

Yield

2.60%

Verdict

Derived from HomePortfolio scores

Walnut Tree Farm earns an INVESTIGATE rating with HP Score 60/100. Investment score 45/100 reflects below-average fundamentals. Crime intensity is low. Walkability is limited (13/100). Flood risk is not assessed: check the Environment Agency long-term flood map before offering. Tenure is freehold. Every figure here comes from the live HomePortfolio API; anything it does not publish is left out.

Key SourcesEPC RegisterPortal listingsOfcom Connected NationsOfcom mobile coverageMarket estimates (third-party AVM)Defra strategic noise mapping, England Round 4 (Contains Defra data © Crown copyright and database right 2023-2024, Open Government Licence v3.0)Walk ScoreONS Census 2021Police.ukHM Land Registry covenantsHM Land Registry Price PaidPlanIt / council planning portalsOverture Maps PlacesOfsted / DfE GIAS

HP Score

60/ 100

Mixed

Investment Score

45/ 100

Mixed

Crime Score

20/ 100

Moderate

Walkability

13/ 100

Low

Transit & Bike

Transit 4Bike 17

Walk Score, out of 100

Opportunity

Why this could be an opportunity

Low confidence0 independent sourcesListing checked 31 Oct 2026

This rests largely on a single source. Treat the score as a prompt to investigate, not a conclusion.

Valuation edge0/15
claims [AVM -1.2% (MEDIUM)] → measured edge +0.00pp of the ask; on later-registered sales an AVM discount carried no edge and a sold-evidence gap at most +0.5pp
Market estimate used (MEDIUM confidence) · snapshot 9 Oct 2026
- valuation_snapshotsestimate for 24059391· as of 9 Oct 2026
Rental economics0/40
gross yield 2.6%; range width penalty ×0.51
- valuation_snapshotsrent estimate 3900/mo (range 3200-4550)· as of 9 Oct 2026· verify before relying on this
Stress margin0/30
stressed cash flow -4,857/mo, -125% of rent (6.75% on a 75% loan; no service charge or ground rent disclosed); fails the stress - earns nothing
- underwriting_assumptionscosts not disclosed by the advert· as of 31 Oct 2026
Seller motivationNot scored
context, not scored: 0 price cut(s), 430 days on market; homes with a cut sold 0.2-0.3pp further below the cut ask, which is not an edge
- portal_listingsprice_changes + first_published_date· as of 31 Oct 2026
Risk & liquidity12.8/15
149 sales/12mo in area; valuation range width 20%
- property_intelligencetransactions_12mo

4 of 4 components scored. Ranks on gross yield, the stress margin, risk and disclosed facts. A pricing claim earns only its measured edge: today 0 for the market estimate and at most +0.5pp for sold evidence. The score itself is not yet checked against the outcomes of homes it scored.

Economics

What happens to your money

Price sensitivity

£1,350,000£1,980,000

The same scorer re-run at hypothetical asking prices, holding rent, comps and listing history constant. Not a prediction of what the seller would accept.

Your assumptions

Purchase price£1,800,000

At the asking price

Monthly rent£3,900/mo

Evidenced range £3,200-£4,550

Interest rate5.4%

Loan to value75%

Cash required: £671,050
Net cash flow: -£3,375/mo
Cash on cash: -6.0%
Score at this price: 13

After a 8% void allowance, 15% management and 10% maintenance. Lender coverage (rent ÷ interest): 0.64 - below the usual 1.25 test. These are your assumptions, not evidence: only the pre-filled rent and price come from the record.

Evidence

Where every number comes from

valuation_snapshotsestimate for 24059391Valuation edge · as of 9 Oct 2026
valuation_snapshotsrent estimate 3900/mo (range 3200-4550)Rental economics · as of 9 Oct 2026 · verify before relying on this
underwriting_assumptionscosts not disclosed by the advertStress margin · as of 31 Oct 2026
portal_listingsprice_changes + first_published_dateSeller motivation · as of 31 Oct 2026
property_intelligencetransactions_12moRisk & liquidity

Sold comparables in depth

Risks

What could kill this deal

Score confidence is low
largely a single source - treat the number as a prompt, not a conclusion
Rental economics needs verification before you rely on it
rent estimate 3900/mo (range 3200-4550)
Seller motivation could not be scored
context, not scored: 0 price cut(s), 430 days on market; homes with a cut sold 0.2-0.3pp further below the cut ask, which is not an edge

Property risk deep-dive →

Plan

Before you offer

1. Get two written rental appraisals from local lettings agents.
The rent estimate rests on area-level evidence, not lettings on this street.
2. Commission a full structural survey, not a basic condition report.
The score prices market evidence, not the fabric of the building.

Every step above was generated from a specific gap or flag in the evidence - no generic advice, no invented tasks.

Valuation & Market

Sale Estimate£1,778,000

Rent Estimate (pcm)£3,900

Gross Yield2.60%

1y Growth-

3y Growth+0.3%

5y Growth+1.5%

10y Growth+3.1%

Last Sold Price-

View Market Details

Risk Overview

Flood RiskUnknown
SubsidenceLow
RadonModerate
MiningLow
LandslideLow
Air QualityLow
NoiseLow

View Full Risk Report

Planning Activity

Recent Apps

0BS49 4PQ

Approval Rate

-12mo

Development

low

26/P/1710/FUH
Proposed erection of a single-storey flat-roof extension and a two-storey side extension, replacement front entrance porch, loft conversion with rear dormer and windows and new front boundary wall and parking area (amendments to approved scheme 25/P/1655/FUH).
Approved
26/P/1314/S73
Section 73 application to vary condition 2 (plans) attached to permission 25/P/1655/FUH (Proposed demolition of existing rear conservatory, front porch and side extension with subsequent erection of single storey front, rear and side extensions. Loft conversion and roofing alterations including the creation of front, side and rear gables, rear and side flat-roof dormers and an integrated rear balcony. Fenestration alterations throughout and creation of off-road parking with vehicular access via the removal and replacement of existing boundary wall.) to allow for the removal of the front bedroom extensions and large entrance overhanging porch and roof and retention of the existing bedroom bay window and kitchen window. Reduction and change of design for entrance porch, removal of approved first floor rear extension. Changes to loft conversion with dormer roof and windows to rear and re-alignment/reduction in footprint of side storage area to suit neighbouring boundary and minor fenestration changes.
Rejected
26/P/1033/TPO
Ash (T1) Fell. Tree appears to be dead with no leaf coverage. Ash (T2) Fell. Ash dieback present with less than 50% leaf coverage.
Approved

View Planning Timeline

Ownership

Corporate Ownership69%
Overseas OwnershipNo
Lease Term Remaining-
CovenantsRestrictive
Lease TypeFreehold
Last Ownership Change-
SourceLand Registry

View Ownership Details

Connectivity

Broadband (Standard)

12 Mbps

Mobile 4G/5G Coverage

EEThreeO2Vodafone

EV Charger

PTAL Rating

View Connectivity Map

Area Profile

Median EarningsLocal authority£32,996

Population Density-

Owner Occupied90%

Age Distribution

0-15 16%16-64 56%65+ 28%

View Area Profile

Schools Nearby

Court-De-Wyck Church School
0.8 mi
Good
Yatton Church of England Junior School
1.7 mi
Good
Yatton Infant School
1.7 mi
Good
Wrington Church of England Primary School
1.8 mi
Area grades2025
Inspected after Ofsted withdrew the single overall grade.

3 of 11 nearby schools with published figures were oversubscribed in 2026 - demand, not a catchment.

View All Schools

Comparables

View All

Goblin Combe Plunder Street
-
£1.63M
-
Biddulph House Plunder Street
-
£312k
-
The Old School House Plunder Street
-
£600k
-
The Old School House Plunder Street
-
£670k
-

Boundary data not available for this property

No registered title polygon, building footprint, or street match for this property yet.

Why: No HMLR INSPIRE / OSM footprint / OS Open USRN match for this UPRN

Source: HM Land Registry INSPIRE / OpenStreetMap / OS Open USRN