Ultimately, I decided on Jacksonville because my primary objective is cash flow.

Didn't know their names and no way will my seller reveal any material information.Action points:1) I attempted to sign my own version of lease with same rates and maturity dates (but with my standard terms, conditions, and rules and regulations) --> one without issue and the other opposes.2) For the other, I have to (even very one-off) amend the contract to remove clauses that the tenant objects (immaterial items to me, so at least it's better than the "inherited" contract")Similar to your situation, I can't assume it's a problem tenant either.  

So no good options and potentially an expensive lesson...I haven't been in this particular situation before but I have had expensive lessons in Baltimore and my main in advice is remove emotion and look at this as objectively as possible.

If a long term goal of cash flow off this property is the only objective, you have to prepare for that.

@Nicholas Di Giugno you need to define which is your primary objective.

However, the ability to leverage large quantities of cash is exactly why so many choose to invest in real estate.

By sharing experiences and perspectives, you can gain insights into different approaches and determine what aligns best with your goals and objectives.

If you require proof of a building’s legal use – and it’s exempt from the CO requirement – contact the Department’s borough office where the property is located to request a Letter of No objection. 

Their info indicates they have a Property Mgt Division but I'd like objective feedback good or bad from customers etc.

I don’t know what your exact objective is with the new property but if it is for returns it would be good to look at the East Side and Oildale, the only thing I would recommend is making sure you work with someone that really knows the areas because I have seen other investors come in to a deal they thought was great just to be surprised by different factors on the property and the neighborhood.