SFR hold their value better than condo's, and you don't have to deal with HOA, and their dues when the units are vacant.
Now for affordable, it depends. But I would say where homes are in demand are the College towns, and Cities. Where other markets are declining, these places are holding values as well rents are higher. Just general information for you.
Sure the brokers and agents will have their ideas on their locations to get your business.
Best to you.