Housing is multiple markets even within narrow geographic bounds. We could produce a lot of apartments and they would be affordable, but a single family home a mile away may still gain value faster than inflation.

Making the ownership of a single family home affordable is in contradiction with making that a good investment vehicle.