the problem of affordable housing is actually very simple and the solution is obvious; too many people are moving to big cities; so everyone ends up competing for increasingly limited real estate (in a desperate bid to cut their commute times to less than 2 hours per day).
One of the main reasons why so many people are moving to urban centers is because that's where all the jobs are; it's a direct result of the centralization of capital in the hands of corporations. Corporate HQs are in big cities because they want to get access to the best talent and corporations are more likely to find talent in places where there are lots of people to choose from.
One solution would be for the government to introduce legislation to encourage companies to hire remote workers. Another solution would be for the government to introduce legislation to make the economy less focused on corporate growth.
Due in a large part to corporate lobbying, whenever a politician is presented a choice between a free solution and an expensive one; they tend to pick the expensive one.