@Eric Oszczypala, let me address the problem with bringing in used homes, it often costs way more to transport and set up than to just rehab what you already have and with the issues of affordable housing you could remodel a 40 year old home and still make great money selling or renting, good luck with whatever you do with the home I vote just rehab what you have 

@Ruika Lin This is true that condos do not appreciate at the same rate as SFH or townhouses in Northern Virginia and yes it includes even the ones in great location and access to public transportation.

or what is your family's mode of transportation?

I think you have identified en emerging market with transportation connections.

Mine are A class,  all hard surfaces nice finish out -  $110/sf with transport 

Economically, we are fairly diverse, not relying on any one thing too much, we’ve got manufacturing, some tech- Amazon World Transportation Hub, service and hospitality.

@Andrew Syrios The opposite, most CA cities are highly encouraging density, public transportation, walk-ability, affordable housing, etc.

Markets with relatively affordable housing may offer more opportunities for investment.Rental demand: Markets with a high demand for rental properties can be attractive to investors, as they may be able to generate steady rental income.Foreclosure activity: Markets with a high number of foreclosures may offer opportunities to buy properties at a discount, but they may also be riskier due to the potential for lower property values.Transportation: Markets with good transportation networks, such as access to public transit or major highways, may be more attractive to renters and buyers.Amenities: Markets with a wide range of amenities, such as shopping, dining, and entertainment options, may be more attractive to renters and buyers.Ultimately, the best market for you will depend on your investment goals, risk tolerance, and financial situation.

There is the trolley in downtown which allows for some public transportation as well.

Become familiar with comparable sales, market rents, proximity to points of interest (transportation, shopping, downtown areas,etc), and begin running numbers.