Indeed - as someone who moved from a (large) flat in central Edinburgh - if you go one hour out of Edinburgh (which is an easy commute if you go somewhere near a train line) then you get an awful lot more for your money.

A nice single bedroom flat in the centre of Edinburgh is about £400K - that'll get you a pretty nice house with a garden somewhere like Fife.