I know, nitpicky, but if you have a chance. might as well make it perfect :-)Be patient, if your area is a popular one, you will definitely fill up and stay full.

Would the federal tax liability be $140k at year 5 for the sale, with long term capital gains (ignoring any Net Investment Income Tax)?

It’s a local community bank locator that might have a better chance with setting up bank account for Series LLC.https://www.icba.org/bank-loca...

However, this does not impact the sale proceeds.This post does not create a CPA-Client relationship.

Nationally, the levels of pre-existing home sales are back at 1995 levels mostly because of the interest rate conundrum, so I'm interested to know what's happening in your area that high rates are causing more people to sell?

It is coming to market in our off season, should we wait closer to our peak season to release it so that we have the best chance for the most bookings in a short time frame? 

Some pros:- You'll have plenty of cookie-cutter comps so you should be able to get a very accurate estimate of ARV and/or sale price in the case of a flip.- Your maintenance and repairs will be mostly limited to the interior of the property as the condo management will maintain the building- You won't have to worry about tenants maintaining the grounds around the buildingCons:- Condo fees may change drastically over time and it's largely not in your control- Condo bylaws can be tough to work around.

Is there any creative way to avoid/reduce capital gains tax on the sale ?

But if there is a chance that the previous person could have done something and it just became dislodged and blocked it, no. 

Right, seriously, there's a game on Steam called "Tenants" which, I suppose, is a landlord business simulator.On sale now for $17.49.Quick blurb (not trying to advertise for them, honest):Become a landlord and deal with problematic tenantsas you build your rental property empire.