Purchase price: $34,700,000 Cash invested: $7,500,000 192-unit institutional class B+ property located in between the Research Triangle Park area and Greensboro, NC.

Has anyone else gone through this process of rezoning and can provide me with some links/guidance on the process? 

You can get the STR data from something like AirDNA and then check out what your competitors offer on sites like Airbnb/VRBO.Negotiations will also depend on their cash flow and how much of the business you buy.

I'm buying the property with cash, in a trendy neighborhood.

Purchase price: $89,000 Cash invested: $65,000 Sale price: $259,9002/1 brick ranch on 1acre

Looking at the data you provided for Melbourne, FL:- Average rent is around $2,000-$2,100- Rents have actually decreased slightly year-over-year- There's a wide range of rental prices ($650 to $6,500)This suggests a diverse market with potential opportunities, but also some volatility.

If you have had positive experiences with insurance providers in the area or know someone who provides excellent coverage tailored for vacation rentals, I would be grateful for your recommendations.Additionally, during the property inspection, we found a few minor repairs that need some attention before we officially welcome guests.

Contact the Tax Claim Bureau and ask if the Pa lien is on their title search, if not provide them with the evidence so they can pay it off.  

As long as you are cash flowing or have the capacity to stick it out in the higher interest rate market buying at a lower price is always a win.

Make sure they provide all relevant financial data, vendor contracts, and other important documentation for the properties.