Would it be better to do some remodeling and deduct those costs from the sale proceeds, or should I foreclose and sell the property "as-is"?

This could allow you to use the full amount for purchasing real estate without needing to sell your stocks outright and incurring significant tax implications.

I THINK you could probably just expense your deductible if insurance didn’t cover 100%.

You only want to file a claim if it's much greater than deductible or your rates shoot up pretty quickly. 

The majority of landlords don't allow pets in there properties.

A property allowing one-night stays may be more prone to fraternity parties and similar.

Finding a condo that allows Airbnb/STR will be challenging, they're rare and cost more because of it. 

- You can buy using FHA 203(k) loan which allows you to finance repairs into the purchase mortgage.If you find you like being a landlord, you can BRRRR a property every year.You can also start BRRRing rentals w/o planning to live in them.

Yes, we can provide a digital issue but we are not allowed to past links here, sorry.

You already seemed to conclude you are forcing this deal, I would agree unless there's a reason why this property will appreciate significantly in the near future and the 40 year amortization schedule allows you to hold on for that to occur.