I've used it for everything from artwork approval on skincare projects, to an automated center for communications out to clients based on the status of the project in question. 

I have a simple IRA that I'm considering withdrawing from to complete the down payment and was hoping to fall under the "first-time homebuyer" status.

Are there banks out there that would take the 90% LTV and “payoff” the mortgage, leaving the $266k balance on the heloc and giving it a 1st position lien status.

Deciding when to sell is a very personal decision based on your status, your goals, your investment strategy, job stability, family disposition, and about 17 other factors.

What is the status of the leases of the other tenants, or are the other spaces vacant?

No other legal proceedings took place, just the pre-foreclosure status. 

And some have Status "FULLY REDEEMED"  I'm assuming FULLY REDEEMED means paid?

The house was advertised as a potential "income producing" unit if I wanted to rent out the back.I am now finding out that the property LOST it's non-conforming status while the prior owner (who flipped the house) had it.

I am hopeful my employment status will change for the better. 

Regardless of the status of SB 9, building or buying an ADU is a regulatory play as well as a cash flow play.