Looking for a comprehensive metropolitan US Real Estate market
analysis from a "moderately aggressive" investor's perspective with a
3-5 year planning horizon.

Consider buying 5-6 homes with a target price for each SFR around
$200,000 with 5% down.

Understanding that there is no guarantee where the RE market will move
within the next couple of years, the "optimistic" approach should
assume that in certain metropolitan areas (e.g. Phoenix, Las Vegas,
Portland, Raleigh etc.) based on their demographics and other factors
(job growth and wages, tax benefits, climate conditions et al.) the RE
home prices and the affordability index will continue their trend and
far exceed the US average, as was (is?) the case in California and
Florida.

The acceptable answer will not just contain multiple links, but, first
and foremost, investment matrix comparison with time market analysis,
e.g. investing $175,000 in SFR "fixerupper" priced below market price
of $200,000, remodeling it for $20,000 and putting it back on the
market after 90 days ("flipping") reinvesting profits according to the
1031 exchange rule, vs. holding it for a year while renting out and
then selling at, hopefully, much higher appreciated price, taking
profits out with 15% tax, or continue reinvesting etc.

As another option consider buying 12-unit income property for $500,000
with 20% down, remodeling it for, say, $50,000 within 90 days, then
renting all units out with $10,000 gross monthly income.

The numbers shown are examples only. The analysis should suggest the
current market values, going mortgage and rental rates, as well as
cost of minor remodeling in the area.

The only constant in this research should be the amount of initial
investment, which may vary between $100,000 and $200,000.