Gilcomston

Gilcomston is dense in a way that only really makes sense once you've walked it — tenement stone, tight streets, a population packed into a footprint that runs at nearly four times the density you'd find across Scotland as a whole. It reads as a young, transient sort of place: a median age under 29 against a national figure closer to 43 tells you this is student and young-professional territory, not a place where people settle in for the school-run decades. The granite terraces give it a handsome, uniform look, but the crowd on the pavement is unmistakably twenty-something.

Housing here is the plainest piece of decision-making. The median price sits a long way below the Scottish figure you'd see in a wealthier suburb, and it's actually been drifting down over the past year rather than up — the "worsening" trend on housing isn't a crash so much as a soft, gradual cooling that fits an area of flats and rented tenements rather than family houses. There are only two schools recorded in the immediate area, so this isn't somewhere built around school catchments; it's built around proximity to the city centre and to work. Council tax at Band D runs slightly above the national median, which is the one place the "affordable-looking price tag" story gets a bit complicated.

Day-to-day, Gilcomston's strengths are social rather than scenic. The nightlife grade sits at the very top of the scale, and health services score just as strongly — between them they describe a place that's easy to live in on a Friday night and easy to get seen by a doctor on a Monday morning. Green space is thinner: fifteen pockets of it, but only four hectares in total, so this is a place of small squares and pocket parks rather than anywhere you'd go for a long walk. Connectivity is excellent — full fibre reaches the vast majority of homes, which matters more here than a back garden would, given how many residents are likely working or studying from small flats. Safety sits solidly mid-table on the grading and has stayed flat rather than sliding either way, which is reassuring in its ordinariness.