The reason you would hire a licensed professional is to assist with you not gettting SCAMMED and help you with negotiating prices and terms...based upon State Law. 

The East Rock area of New Haven (near Yale) is a huge outlier in terms of pricing, very expensive. 

With countless loan options, complex terms, and strict lending criteria, it’s easy to feel overwhelmed.

Refinancing: If the lender doesn’t approve, refinancing under the LLC might be required, but LLC loans typically come with stricter terms and higher rates.3.

Is the mid term rental business that you have a 'rental arbitrage' business?

What were some mishaps along the way in terms of the contract?

Then do a thorough research on tenant applicants (note: leaving this to a PM may be hazardous to your financial health) and choose the one that is most “stable” with the best potential for long term tenancy.This advice is contrary to maximization of rental income, but IMO will reduce expenses of tenant turnover, property damage, property management fees so much that the difference in bottom line income will be quite small.  

Will I be able to overcome it's reputation in getting mid term renters?

I've been on this platform for many years and, over the years, I've seen new members linked or part to Mexican real estate agencies posting educational content about investing in Mexico out of the blue shortly after becoming new members and then disappear as they realized that their efforts wasn't giving them the amount of business they were hoping for.

They thought it is a new term lol.