Coldstream

Coldstream sits low and stone-built along the Tweed, the kind of border town where the terraced high street gives way quickly to farmland, and the average person walking it is well past their working years rather than pushing a pram. The median age here is 56, more than a decade above the Scotland-wide figure, and that single fact colours almost everything else about the place — the pace, the shop mix, the quiet.

There's only one school picked up in the local data, so this isn't a place to move to chasing a catchment area — families with school-age children are the exception here, not the rule, and you should treat that as a genuine gap to check rather than assume it away. Housing, by contrast, tells a more encouraging story: a median price around £183,000 is modest by national standards, and the market has been drifting upward gently rather than spiking, which is the sort of trend that suggests stability more than opportunity. Council tax at Band D runs a little above both the Scottish and regional medians, a small tax on living somewhere this settled.

Green space is genuinely part of daily life rather than a line on a brochure — fourteen separate pockets of it across a village this size, working out to a decent stretch of open ground for a population of under two thousand. That, paired with an overall grade that reads well above the Scottish average, and top marks specifically for safety, health, and the environment, paints Coldstream as a place where the outdoors and a sense of order do a lot of the heavy lifting. The one grade that breaks the pattern is housing, sitting at a middling C+ while everything else scores near the top — worth noting if you're buying, since it suggests the stock itself (age, condition, choice) may be more limiting than the price would imply. Connectivity is respectable rather than exceptional, with roughly two-thirds of properties on full-fibre broadband, enough for most remote-working needs without being a selling point in itself.