A few facts of life need putting in here to balance things up.
In the real world if YOU want to live in a "Nice" area you pay a premium, thats why similar houses in say Bramhall compared to Moston will have a different price.
Social housing is provided at a subsidy for those not in a position to buy a house, there is NO security as to where that house will be, it will never be YOURS, no matter how long you have lived there unless you buy it, there is no transfer of tenancy to the children, as many people have found out on the death of their parents.
The local council has a duty to manage on a budget, if the land on which houses stand becomes valuable enough to fund building more houses in a cheaper area then thats basic sense, because it provides more houses for people who can not afford to buy an that is its job.
Its not there to ensure aunt Mavis lives around the corner from her bingo hall, but that she has a f*cking roof over her head.