Isn't this, what a housing cooperative are about? They are very common in Germany and seen as valuable cultural heritage.
In his book, and the chapter exerpt I've linked in an earlier comment, Phillips explains why all three elements are key.
Co-ops (or similar co-housing or community-housing arrangements) cannot of and by themselves address the greater supply problem, or provide subsidies for at-risk, disabled (temporarily or permanently) individuals, children, or retirees. They're useful, but insufficient.