I'm willing to go under the wings of veterans in this business model, do you know who might be of help to me?

Depending on the total square footage of the residential vs commercial space, you will be between a full commercial lender or a wholesale investment lender that can dabble in the mixed-use space.

It really depends on the condition and if the person smoked indoors and was a heavy smoker.You are going to have to wash all of the surfaces with TSP, chances are you will need to repaint (especially if they've been there for 10 years) and may need to stain block the ceilings before painting. 

Unfortunately, Marriott generally restricts franchisees from incorporating other businesses into their interstate properties, although they do allow for more creative designs in urban markets.According to the STR report I commissioned for the five closest competing properties, their occupancy rates were 73% in 2022 and 75% in 2023.

I am more flexible with them on holidays if one cannot be cleaned by EOD but this is a hospitality business and holidays are expected to work days IMO

Cons: Property taxes can vary widely depending on the county.

Analyzing your property depends largely on your target tenant.

Jacksonville is ok market growing fast like all of florida but you still have less multifamily. similar average cost per housing unit to columbus but columbus speaks for itself. state capital, ohio state, developer friendly, fast growing market. those are the two stronger markets. depending on your liquidity I wouldn't look far away from home either. homestead, other areas there are massive deals being done.

That will depend on your time, capital, energy, and skills.

It depends on how much I can sell my land here.