We got it for $635k, thinking we'd be able to rent out 2 of the units (including basement) and live in one.

My name is Kim Wells and I am currently living in Albany, NY.

Rule #1 of househacking is to like where you live.

Looking at Redfin's data, it is appreciating over time (probably more than $15,600/year), but probably not as fast as other highly desirable neighborhoods in the Bay.I previously lived in this home before I moved and converted it into a rental property.

Based on the conversation my realtor had with the seller's agent, the family selling the home is humanitarian in nature and would like to "help a family."

Her and her husband would live in one unit and the other three units would be rented out. 

Step in to a bright and airy living room with large windows that allow natural light to flood in.

We want to live in the next property and fully rent our first duplex.

And to your point the better tenants also want to live there. 

This is actually my Grandfather's property that I am trying to get him a monthly cashflow since he is now in an assisted living situation.