There are several different options whether it be passively investing utilizing some of the larger companies who do all the work for you or more active investment that will make your money go a little farther if you are comfortable doing more work.

Yes - LLCs can get 30-year loans - as others have mentioned, DSCR Loans are probably your best option. 

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

As Chris points out, private money is your only option. you cannot get conventional financing because you can't get anyone to issue a title policy on an active foreclosure.

True, Being a IT guy, Maybe I just like to talk to people in person :-/But you're right, I should stay open minded and be open to all options ..Thanks Marc

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. ...

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.