The good news is that, generally, the places most affordable are the places that have public transportation. Affordability is gained through density, and density is also conducive to public transpiration.

The places where public transportation isn't normally found are the places where the average Joe wouldn't have a hope in hell of being able to afford to live there (affluent suburbs, rural areas, etc.) anyway.