.- Stock market opportunity cost: If the brokerage account has strong holdings, consider if the return potential justifies cashing out now.Given the current market dynamics and your goals, reallocating your brokerage funds into a multifamily property in Rochester could provide substantial benefits.

Finding a condo that allows Airbnb/STR will be challenging, they're rare and cost more because of it. 

You don't always have to incentivize a tenant with a discount to get the tenant to stay, nor keep rents stagnant, but it is good to be aware of the business impact with respect to cost too.

In the beginning I want to manage by myself to save cost.

The reason I say this is because Europe experienced the exact same spike in inflation, except they never increased M2 like we did, it's just flat.

It's always better to check with your brother's CPA since he has all the background, but I would say short-term rental with material participation requirements met by your brother, then do cost segregation.

If you sell the property, a lot of the $107K cost will be eaten up in transaction cost.

Others may argue that higher rates are bad as it drives up their borrowing costs. 

Be conservative on your rehab budget, rehab timeline, holding costs, etc.

3) Your $250k with 30% down => about $750k (you also need funds for closing costs, taxes, etc.)