Here's some relevant data [1], sorting by the 'affordability index' should give you a few ideas. Milwaukee, WI is in the top 10. I have to travel there frequently for work. It's on both a river and a great lake, and the people there are quite possibly the most friendly people on the planet.

[1] https://www.numbeo.com/property-investment/rankings.jsp