We're not likely to see major appreciation in the coming years, but I do think buyer sentiment will improve which will likely lead to better pricing via competitive offers vs. the current market. 

It’s a historic property that holds a lot of sentimental value for me.My goal is to rent it out after I move.

Hey Nolan, I echo the sentiment of many of the posters here - banks will straight up lie to you sometimes regarding what options are available (especially if that particular bank doesn't offer it) 

I do agree with the sentiments from others regarding the experience factor.

Along the sentiments of previous replies, your first concern is pretty straightforward to address.

Consumer sentiment is expected to improve with inflation easing.

I noted the year-over-year increase in STR permits, the decrease in average nightly revenue, and the sentiment that economically-incentivized sellers would flood the market after this winter season (effectively increasing housing supply and decreasing prices).

welcome to bp, your sentiment around leverage is 100% correct, and I'd challenge you to follow your own advice and use that leverage to put as little as possible into the real estate rather than the coveted "pay cash for it" or while one can pay cash, utilizing your w2 to refinance is a unique skill and ability you can have.house hacking in the mid west is where its at for sure.

Yeah, it's evident that there's a strong pro-real estate sentiment here on the forums haha, and sometimes we can get caught in a self-confirming loop.

This would qualify the property for long-term capital gains treatment. also, if you command decent rents, it’s going to help you flip that property at a higher price point with solid tenants.I also agree with the sentiment that if you decide to flip it and pay tax that’s a good problem to have because it means you made money on your flip and that’s the goal!