While people talk about affordable housing, they're not really in having it appear anywhere near them. Nobody wants to see their house value go down. Nobody wants to be inconvenienced. Few want more people underfoot, with those few who do being in urban developments. And they're obviously not worried about climate or commute time, as they legislate against the former and mandate in-office work against the latter.

Building homes where the land is cheap is probably the only alternative. But that's not where the jobs are. Building out the roads/sewer/power for such areas might also be an insurmountable problem.

  Well, Dallas is a woman who will walk on you when you're down
  But when you are up, she's the kind you want to take around
  But Dallas ain't a woman to help you get your feet on the ground
  And Dallas is a woman who will walk on you when you're down

  Well, I came into Dallas with the bright lights on my mind
  But I came into Dallas with a dollar and a dime

  Well, Dallas is a rich man with a death wish in his eye
  A steel and concrete soul with a warm hearted love disguise
  A rich man who tends to believe in his own lies
  Yeah, Dallas is a rich man with a death wish in his eyes

--Jimmie D. Gilmore

from:

"Did you ever see Dallas from a DC-9 at night?"

https://www.youtube.com/watch?v=M30z7xsiGHc