This is prime real estate, and is just about the last piece of land in this area.I have begun to develop a commercial property that I own with contractor garages, which is the extent of my experience in this space.I'm trying to get a sense of how to structure something like this, with using LP's, and also partnering with a builder, and carving something out in that regard.Does anyone have recommendations on who is currently working in this space and could provide some insight?

No one is going to give you money when you have little no experience at all yet.

I am small time but haven't ever  had a disaster experience with pets.

AS you get more experience you will learn how to screen better.  

What is your real estate experience (generally and specifically)?

What are other options do we have if we don't have piror experience? 

Quote from @John Williams: Has anyone been on the lender side of private money and had a bad experience that they are willing to share?

Just my personal opinion - get a mentor or a person who already has good experience running STR business, preferably in your area (but not 100% required). 

My name is Kevin Upton, i am new to Real Estate Investing and looking to learn from those with more experience than i do.

You don't need to know everything to get started; you need a foundation to build on, and the rest will come through experience and then refining your education.You can build a basic understanding of investing in 3-6 months.