I have options for a one time second lien on investment properties.

Other tips I might consider could be Expanding your search area: Look beyond immediate local markets and explore options in up-and-coming areas or cities with diverse economies.

I'm in search of an option that is not only cost-effective but also offers detailed sub-market intelligence.

Do that with options.

I’d love to learn more about things like: what other options can I consider for liability protection besides an LLC(I haven’t met a lender willing to lend via an LLC), what are some gotchas to be wary of,etc.

This is one option to consider that can help differ taxes and depreciation recapture. ...

Some lenders are better than others in helping strategize the best options.

No doubt that house hacking has become more challenging in the last few years but it is often still a much better option compared to both renting and buying a primary home just to live in.

have you looked into DSCR options?

Explore alternative options like hard money loans (fast but high-interest), seeking private investors, or obtaining a business line of credit if your business generates income.