Some of it can be temporary, but ideally you'll want to be in markets where it can be sustained (ie. have barriers to entry). 

This option is ideal for penalty-free investment but comes with added complexity and strict IRS rules.Alternatively, a 60-Day Rollover allows you to withdraw funds and redeposit them into an IRA within 60 days to avoid penalties, though it carries the risk of missing the deadline.

Ideally it should still cash flow solidly but may not appreciate quite as rapidly as the bigger market.

Ideally not too much of both.The best way to learn what makes a good deal is to just keep analyzing.

Given the scope of your work, a simple plumbing leak would not concern me, it's a $200 issue at the most and ideally, it's just another line item when you do rough in plumbing for the kitchen.Being in a Milwaukee suburb, I am guessing it's a 1960s ranch, probably with galvanized plumbing.

This allows you to really niche down and target your ideal tenant demographic.

The location is ideal, as it’s situated in a neighborhood that permits short-term rentals (STRs), making it a great investment opportunity.

DSCR = rent/PITI and you want that number above 1, and ideally above 1.15.   

Ideally one side would sell out to the other, as divorce is often acrimonious or can become such.

While you might find a lender offering low down payment options, you'll still need cash reserves for repairs, maintenance, emergency fund (ideally 3-6 months of expenses), etc.