Affordability does not translate into desirability. In fact, there is an inverse relationship, as the affordable index goes up, the desirable index drops, sometimes precipitously.
The other thing is desirable affordable homes tend to get scooped up by institutional investors who turn them into rental properties.