You can assume about 1% in closing costs in addition to commissions so you're starting around 7% before the seller gets any cash at closing. 

Feel free to email me if you get any info on this moving forward.

you need to dodge capital gains and foreign buyer tax.. you should consult a tax expert..If I was in this situation I would just sell (not advice) and buy a cash flowing mobile home park in the midwest

(The power company in MN will offer you a chance to buy the warranty after the furnace/ac is broken and come back the next day to fix for free.)

If the property cash flow starts in 2024, personal usage is not that impactful.Talk to your CPA if renovation counts as QIP for bonus depreciation.

SFHs are easier to finance and manage but have limited cash flow and scalability.

Assuming the area checks out, I’d rather buy in a high price area that has little to no cash flow rather than an area that has cash flow but lower price.  

The school is very good, but middle is not so much.I have some cash to invest, but can't decide what route to take.

Now you have the Tenants Bill of Rights and every tenant now gets a free lawyer if you try to evict them.

This property will lose money for anyone not paying cash, and if they are paying cash they will make a very low ROI.