I really wouldn't waste 250kplus to stay in a block of tenement flats. I have never understood the fascination with it.
You could move somewhere decent just outside of Glasgow, for the same price, but with a much bigger house. Glasgow has many decent parts though, if that is truly what you want.