I owned a rental in 2015 but sold it to make a big move to Florida.

Another thing to add is the regulations, HOAs and Cities are imposing a lot of regulation on short-term rentals or rent by a room, I have seen some HOAs regulate the amount of people authorized to rent the property too.It requires to do a lot of due dilligence to begin with mainly in such big house. 

The things that give a rental a value in cashflow are benefits to the tenant in the form of living amities. 

I like where I live and it has the potential to be a good rental for me down the line, so I've decided to go through with making the purchase. 

This will slow new demand for rentals.

We’re debating whether we should sell our rental property to pay off all our debts.

So wholesaling flip and rental.

However, given that many sellers have locked in ultra-low mortgage rates from 2020–2021, the existing home supply remains constrained, which will continue to support home prices in certain areas.For investors, rental properties remain a strong option in an inflationary environment.

If I were in your position, I would buy a duplex that has potential for value add, fix it up, live in one unit and rent out the other unit as a medium term rental or long term rental.

Quote from @Brian Clark: Looking to network in Southern Maine to learn and share about long term rental properties.