The most obvious is that you will be able to offset your mortgage with renting out a few rooms.

Looking for a newer property move in ready to rent one side of the Duplex or the tiny home or a room in the home.2.

The most obvious is that you will be able to offset your mortgage with renting out a few rooms.

Is there a heat source for this system in each room?

House hacking with a rent by the room model may allow you to be able to be breakeven or slightly cashflow positive.

But, currently looking around the Saint Cloud area where I could do room rentals for college students or into the twin cities area, but the property insurance and taxes are a lot higher there. 

To be successful right now in STR, you either need to go all out and beat everyone else on their table stakes (pickleball, basketball, game rooms, saunas, hot tubs, etc.) or you need to understand the market better than anyone and pick a niche for that market.Right now, you are one post in and just asking for someone to tell you anywhere in the United States to invest, which is silly.

The prior, new tenant turned on the utilities a day before moving in and the laundry room valves were wide open, flooding the home. 

There is no room for easily avoidable mistakes like these.

Do you personally manage rent by the room?