What are some websites that I can use to learn more about market trends related to population growth by states, cities, zip code, etc?

They are pretty strict about it being your primary residence.

Beyond that the chances that this building would then be both suitable and up-to-code for residential use is a very, very long shot.If your business is only using 2 of 3 floors, can the other floor be rented out, either in part or in whole?

Knowing that Oakland has very strict housing laws I am wondering what my options are before I consult an attorney so I can have a better understanding of the situation.

@Sydney Sherman, I would give them notice of the planned construction, offer to release them from their lease if they choose, and make strict start/stop times with the construction crew so the tenants know they can expect quiet times.Offering to release them from their lease negates the need to offer a discount. 

Following is the code that is referenced for this.

Review Agency, review the Code of Ethics, look at your local and state regulations; then also tally the total expenses to carry a license...

It can be done, but it should only be a strict return on money because if not, they will want more say over the renovation and that is where all the problems start even when people say they are silent investors, they rarely are.

Does anyone know if these restrictions are enforced or how strictly?

Although personally I see syndications working better as a series of smart contracts whereby you send your Ether to the contract wallet and you have a system of payments set in the code.