Sold House Prices on Castlegate, Berwick-upon-tweed

Figures use HM Land Registry Price Paid Data, standard sales only - HM Land Registry's "category A". That excludes repossessions and other sales under a power of sale, buy-to-lets identifiable by a mortgage, sales to companies and other non-private buyers, and properties classed as "Other". We also ignore entries under £1,000. Auctions are not excluded: a normal auction sale between a private buyer and seller is a standard sale and is counted here. HM Land Registry only began flagging these categories in October 2013, so sales before then are all counted as standard. Price Paid Data also leaves out sales never lodged for registration and transfers not for value - right-to-buy discounts, gifts, divorce transfers and compulsory purchases. Land Registry records some towns under two spellings; we treat them as one town, so a street's full history appears on a single page. England and Wales only; HM Land Registry publishes with a 1-2 month lag.

Average price

The arithmetic mean of every standard full-value sale on this street, all property types and all years since 1995 combined. Because it spans decades it typically sits below current values - see the year-by-year trend below for the recent level.

Typical sold price (median)

The middle recorded sale price on the street - half of recorded sales were below this and half above. Less swayed by a single unusual sale than the mean, which matters on a street where a handful of sales is normal - and why the headline and stats lead with it. With fewer than 3 recorded sales no median is stated; the actual prices are shown instead, and with 3 or 4 sales the median is flagged with its sale count.

Total sales

A straight count of the standard sales recorded on this street, with the dates of the first and most recent.

Lowest / highest sale

The single lowest and highest individual sale prices recorded on the street in any year - two transactions, not a typical range.

Every-sale chart

One mark per standard sale recorded on the street: its position is the completion date and the price actually paid. Nothing is averaged, smoothed or projected, and no estimate of today's value is implied.

Sold again (same home)

Addresses with two or more recorded sales, matched on the exact address. The annualised % is the steady yearly rate that would turn the earlier price into the later one over the time between the two sales (compound growth), and is only stated when the sales are at least a year apart. It takes no account of extensions, renovation or condition, and no value today is estimated from it.

Filtered stats bar

The count, median, mean, lowest and highest above the sales table recompute over exactly the sales matching your current filters - the same set the table and the CSV download cover. With fewer than 3 matching sales no median is shown; the lowest and highest are then the actual individual prices.

District trend (% change & chart)

Calculated across the wider TD15 postcode district, not this street alone (one street rarely has enough sales each year for a reliable trend). We compare the district's median sold price in its earliest year with at least 10 recorded sales against its most recent complete such year - a median-on-median comparison. The current calendar year is excluded because its registrations are still arriving.

Property-type mix

Share of standard sales by property type across the TD15 district. Any new-build figure compares the average new-build price with the average existing-home price, weighted by number of sales.

Instant estimate

An automated estimate from nearby Land Registry sold prices adjusted for market trends - not a formal valuation. A local agent's valuation will be more accurate.

Change since previous sale

Where a sale row shows "up/down X% since {year}", that compares the sale price with the most recent earlier recorded sale of the same property - not an area trend.