Just thinking about the comment on the show tonight about affordable housing for Free Staters, something I'm involved with in the UK which started not far over the state line in
Burlington, VT (sure, it was Bernie Sanders, but don't hold that against the idea!) is called "Community Land Trusts". It's often arranged as a co-operative, in which residents buy as much of the equity as they can afford, rather than according to the size of unit they need. So you might get a relatively well off single with a one bedroomed apartment but who owns a bigger chunk of the equity in the development (and which is what he or he gets to sell out if they decide to move) and they are effectively cross-subsidising the less well off family that needs a three bedroomed property on a lower income.
Another fun option for some type of people, especially if they share a common interest, but which can actually often work out more expensive, is something called "co-housing" which is a development where everyone gets the house they want, but there's also usually "common space" built in - such as a common dining room for when you want to share meals, space for home-schooling or home-working and so on.