I recently learned that Union Bank can do it in Northern California.

What interest rate did you get for this 30 year and what bank did you use?

I get that they are not done to often but I'm finding that most of the Nod's and Les Pendens have little to no equity and in typical, or optimum, circumstances there is no solution for these home owners except for the bank to foreclose.

I am soon to buy my first Real Estate property using 100% financing from a local bank.

Having a hefty security deposit in the bank is much more beneficial.Also, don't lock yourself into a 2-year lease.

I wish you much success.First reaction to your post is to urge you to keep enough in the bank for a rainy day. 

As part of the broker's license requirement, I need to open a broker trust or escrow account at a Real Estate Commission bank.

You will typically have 1 or 2 local banks who will issue mortgages on the property.

Or has it been foreclosed and now bank owned?

or not.Many banks will go as high as 80-90% LTV on a HELOC for your primary residence.