During Covid I worked for a Medical Travel company so i would highly suggest with your knowledge to use that in your benefit.

This hands-on experience helped us develop some DIY skills and boosted our confidence.In 2020, we bought a single-family home that we’re currently living in and rehabbing.

Most CPAs have the research skills and experience to sort out state-specific issues. 

There are people on the Internet who teach this skill for price- I don't have a direct recommendation, but they're out there.

The medical traveler wants to work at the local hospital.

I'm Val, I'm a full-time therapist, part-time photographer and everyday creative looking to translate my skill set into house flipping and landlording.

You just don't have the requisite experience or skill set yet. 

I would work with an experienced agent where good negotiating skills were table stakes and that's their value proposition (they do it all day, every day).   

Your pivoting skills are commendable!

However, long story short, yes there is, although I would recommend finding an advisor who is skilled in holistic financial planning that includes not just traditional stock market investments or real estate investments exclusively, but all investment strategies to help in your specific goals.In general though, you can either find a fee-only CFP that has expertise in real estate and other alternative investments, or you can find an advisor who is at the very least willing to have a conversation free of charge prior to any actual investments so they can give you a very good idea of whether they would be able to help you prior to beginning a relationship.