Here are my two cents...I recommend starting in a market with strong fundamentals, such as steady population growth, an influx of major corporations or large businesses relocating to the area, an affordable cost of living, and high rental demand.

I'm eager to learn about how to find and fund properties that help my family financially and my community with affordable/reasonable dwellings for young families and newlyweds.

If its a Class C I'd go for a more affordable unit, there's no point in putting in more money than you have to. 

And I will stay in my condo until I can afford to buy a bigger place.However, with high interest rates, I’m reconsidering.

You might decide that you absolutely want to own your own residence there and I assume you can afford it since you already own properties elsewhere, likely in beautiful Hawaï.

For your scenario, you would be able to afford $8300 monthly mortgage assuming no debts. ($200K/12 months = $16k/ month of 50% = $8333.

But if you can’t afford that you don’t get to take advantage of the tax code complexity.

. - What price point can you afford?

You should start with a focus on a 2 unit multifamily property in a market that you can afford to get into. 

With affordable property prices and a growing rental market, it can be a great option for long-term cash flow.If maximizing short-term rental income is your priority, a home closer to Nashville could be worth the extra cost.