I currently live in Charleston and am a fishing guide by trade so I have a good base understanding of how water moves through salt marsh areas, but it'd make me feel a lot better about this purchase if I could have an expert look at it.

Based on my experience builders make a lot of mistakes during construction.

4) any Charlotte based resources that come recommended to help me structure this properly?

Always weigh the pros and cons of each option based on your financial goals and circumstances.

Based on your description of the situation, you're not going to cashflow while you live there, but the question you should really ask is, will it cashflow after you move out? 

If you refinance, you can always use a DSCR loan on the next purchase if you think the refinance will impact your Debt to Income ratio.

When there are no events, the venue has been booked for short-term rentals.Business has no debt, and is turn-key (advertising is creating a healthy pipeline, there are existing employees, and will come with all the inventory and FFE&V). 

Demand for short-term rentals is based on emotions, the allure of this view or that amenity or this undefined "feel" or "design" of a place.I'd love a pamphlet that says simply, "Hot tubs increase gross annual revenue by $22,000."

Hello,Im an aspiring Real Estate investor..and I appreciate your feedback to know what could be a good strategy and still being creative if you want to buy a deal with good equity but still important debt? 

And based off of the price and interest rate we have, I don't really want to let if go.Any input is appreciated.Best Regards