# 29 KINGS STAND, MANSFIELD, NOTTINGHAMSHIRE, NG18 4AY

## Property details

- Slug: `c526cc0` (address key hash: `c526cc0d08137c867450e5f85a56f8aa3fa3eebb`)
- Postcode: NG18 4AY
- Transactions on record: 1

- Tenure: Leasehold
- Property type: Flat
- Floor area: 55 m²
- EPC rating: C
- Year built: England and Wales: 1996-2002
- Last sold: £135,000 Feb 2026
- Price per m²: £2,455/m²
- Local average: £117,656 (16 sales)
- Street crime: 264 incidents within 1 mile (May 2026)

## Latest sale

- Price: £135,000
- Date: 2026-02-23
- Type: F
- Tenure: L

## EPC Rating & Upgrade Cost

- **Current rating:** C
- **Potential rating:** C
- **Expiry date:** 17/08/2035
- **Current heating cost:** £527/year

[View full EPC on gov.uk](https://find-energy-certificate.service.gov.uk/energy-certificate/2270-9678-5050-4200-8095)

## Price history

| Event | Date | Price | Type | % change | Today’s value (HPI) | Transaction |
|-------|------|-------|------|--------|---------------------|-------------|
| Sold | 2026-02-23 | £135,000 | Flat | — | £132,888 (to April 2026) | [View](http://87.117.209.195:8080/house-prices/4e75c29d-8714-8922-e063-4804a8c094d0) |

*Today’s value (HPI): adjusted using published house price index trends for the area and property type; not a valuation of the property today.*

## Sales History

*Recorded sales for this property. Data from Land Registry Price Paid.*

| Address | Price | Date | Type |
|---------|-------|------|------|
| 29 KINGS STAND, MANSFIELD, NOTTINGHAMSHIRE, NG18 4AY | £135,000 | 23/02/2026 | Flat |

## Sold Comparables

*Same street and nearby sales within 0.25 miles. Data from Land Registry Price Paid. Last 5 years.*

| Address | Price | Date | Type |
|---------|-------|------|------|
| 20 SAPPHIRE STREET, MANSFIELD, NOTTINGHAMSHIRE, NG18 4XG | £125,000 | 18/12/2025 | Flat |
| 3 RUBY WAY, MANSFIELD, NOTTINGHAMSHIRE, NG18 4XQ | £105,000 | 14/11/2025 | Flat |
| 5 SAPPHIRE STREET, MANSFIELD, NOTTINGHAMSHIRE, NG18 4XG | £118,000 | 10/07/2025 | Flat |
| BERRY HILL HALL APARTMENT 9 BERRY HILL LANE, MANSFIELD, NOTTINGHAMSHIRE, NG18 4FH | £200,000 | 04/07/2025 | Flat |
| 16 TOPAZ GROVE, MANSFIELD, NOTTINGHAMSHIRE, NG18 4XE | £143,000 | 08/11/2024 | Flat |
| BERRY HILL HALL APARTMENT 7 BERRY HILL LANE, MANSFIELD, NOTTINGHAMSHIRE, NG18 4FH | £295,000 | 15/12/2023 | Flat |
| THE COURTYARD APARTMENT 10 BERRY HILL LANE, MANSFIELD, NOTTINGHAMSHIRE, NG18 4FZ | £150,000 | 11/08/2023 | Flat |
| 5 SAPPHIRE STREET, MANSFIELD, NOTTINGHAMSHIRE, NG18 4XG | £117,500 | 20/01/2023 | Flat |
| 26 RUBY WAY, MANSFIELD, NOTTINGHAMSHIRE, NG18 4XA | £126,000 | 21/11/2022 | Flat |
| BERRY HILL HALL APARTMENT 4A BERRY HILL LANE, MANSFIELD, NOTTINGHAMSHIRE, NG18 4FH | £195,000 | 15/11/2022 | Flat |
| THE COURTYARD APARTMENT 4 BERRY HILL LANE, MANSFIELD, NOTTINGHAMSHIRE, NG18 4FZ | £160,000 | 20/10/2022 | Flat |
| THE COURTYARD APARTMENT 5 BERRY HILL LANE, MANSFIELD, NOTTINGHAMSHIRE, NG18 4FZ | £156,000 | 14/10/2022 | Flat |
| BERRY HILL HALL APARTMENT 3 BERRY HILL LANE, MANSFIELD, NOTTINGHAMSHIRE, NG18 4FH | £270,000 | 09/09/2022 | Flat |
| THE COURTYARD APARTMENT 6 BERRY HILL LANE, MANSFIELD, NOTTINGHAMSHIRE, NG18 4FZ | £155,000 | 02/09/2022 | Flat |
| BERRY HILL HALL APARTMENT 1 BERRY HILL LANE, MANSFIELD, NOTTINGHAMSHIRE, NG18 4FH | £310,000 | 07/07/2022 | Flat |
| BERRY HILL HALL APARTMENT 12 BERRY HILL LANE, MANSFIELD, NOTTINGHAMSHIRE, NG18 4FH | £198,000 | 08/06/2022 | Flat |
| 75 KINGS STAND, MANSFIELD, NOTTINGHAMSHIRE, NG18 4AY | £130,000 | 20/05/2022 | Flat |
| BERRY HILL HALL APARTMENT 2 BERRY HILL LANE, MANSFIELD, NOTTINGHAMSHIRE, NG18 4FH | £155,000 | 13/05/2022 | Flat |
| THE HAYLOFT APARTMENT 4 BERRY HILL LANE, MANSFIELD, NOTTINGHAMSHIRE, NG18 4FT | £170,000 | 13/05/2022 | Flat |
| 7 CAIRNGORM DRIVE, MANSFIELD, NOTTINGHAMSHIRE, NG18 4XT | £111,000 | 04/05/2022 | Flat |

**Area average:** £169,475 (20 sales)

## Capital growth trend

*Land Registry outcode average from sold prices: last 12 months vs 5y and 10y ago.*

- **5y growth:** 18.9%
- **10y growth:** -4.6%

## House Price Index (HM Land Registry)

*Official index for Mansfield; Flats and maisonettes series; as of April 2026.*

- **1y growth (index):** -7.4%
- **5y growth (index):** 7.2%
- **10y growth (index):** 36%

## Rental Range

*ONS Price Index of Private Rents (Mansfield). Low / Realistic / Optimistic = conservative / average / best case.*

- **Low:** £701/mo
- **Realistic:** £779/mo
- **Optimistic:** £857/mo

## LHA (Local Housing Allowance)

*VOA 30th percentile rent floor for North Nottingham (Apr 2025 – Mar 2026).*

## Rental Comparables

*Residential lets from OpenRent and Rightmove for the area. Bedroom counts vary — use the Beds column to compare like-for-like lets. Student lets are excluded.*

| Title | Rent | Beds | Distance | As seen on |
|------|------|------|------|------|
| 3 Bed Terraced House, King St, NG18 | £800/mo | 3 | 0.81 miles | OpenRent |

**Average rent: £800/mo (1 listing)**

## 1% Rule

- **Rent ratio:** 0.59% (weak for cashflow)
- **Max investor price (0.8%):** £100,000
- **Target investor price (1%):** £80,000

*Monthly rent ÷ price. 1%+ = strong, 0.8–1% = okay, <0.8% = weak. Max investor price = rent ÷ 0.8% (Stoke-style target). Target investor price = rent ÷ 1% (strong cashflow band). Based on OpenRent comparables.*

## Rent-driven metrics

*Based on OpenRent comparables (median £800/mo).*

- **Gross yield:** 7.1%
- **Cost-to-rent:** 14.1×
- **Monthly cashflow:** £163/mo (75% LTV, 3.95% APR (5yr fixed), 25yr term)
- **Cash-on-cash ROI:** 5%

*Gross yield = annual rent as % of price (no costs). Cost-to-rent = price ÷ annual rent (from OpenRent comparables); under 14× = strong, 14–16× = acceptable, 17×+ = compressed. Cashflow = rent − mortgage − 10% maintenance − £25/mo compliance; assumes 75% LTV, 3.95% APR (5yr fixed), 25yr term. ROI = annual profit ÷ cash in (deposit + 4% purchase costs).*

## Flood risk

- **Zone:** 1
- **Risk:** Low
- **Source:** Not in Flood Risk Area (no data)

[Check long-term flood risk (GOV.UK)](https://check-long-term-flood-risk.service.gov.uk/postcode)

## Street-level crime

| Category | Count |
|----------|-------|
| Violence and sexual offences | 108 |
| Shoplifting | 52 |
| Anti-social behaviour | 22 |
| Public order | 17 |
| Criminal damage and arson | 16 |
| Vehicle crime | 12 |
| Other theft | 11 |
| Burglary | 6 |
| Drugs | 6 |
| Other crime | 4 |
| Possession of weapons | 4 |
| Bicycle theft | 2 |
| Robbery | 2 |
| Theft from the person | 2 |
| **Total incidents** | **264** |

*Within 1 mile during May 2026. Source: data.police.uk (England & Wales).*

## Schools nearby

*Nearest open schools with Ofsted ratings (England). Closed schools are not shown.*

| Name | Type | Distance | Ofsted |
|------|------|----------|--------|
| Berry Hill Primary School | Primary | 0.3 miles | Good — 13 Feb 2020 |
| Wynndale Primary School | Primary | 0.7 miles | Good — 7 Nov 2011 |
| High Oakham Primary School | Primary | 0.7 miles | Good — 6 Dec 2012 |
| Asquith Primary School | Primary | 0.7 miles | Requires improvement — 22 Jun 2023 |
| King Edward Primary School & Nursery | Primary | 0.8 miles | Good — 20 Sep 2023 |