However, conventional lenders generally prohibit borrowing the downpayment. 

The only time you are not allowed to assign a contract is if it is prohibited in the contract itself.

That sounds like a good person to start with in helping me search (provided it isn't too cost prohibitive on my wimpy budget!).

New builds for smaller flex industrials are very cost prohibitive and getting required zoning for infill locations are almost impossible. 

Although the CC&Rs of the neighborhood prohibit short term rentals, there is an exemption for renting out individual rooms.

Is it that much more cost prohibitive to start from scratch?

The term “transient accommodation uses” does not prohibit the owner of a residential dwelling unit fromoccupying the dwelling unit as infrequently as the owner may desire.

In the event it is uncovered that a Fannie Mae broker is a party to any such prohibited conduct, the broker may be subject to termination and the case may be reported to the agency responsible for investigating and prosecuting such cases.ACTION!

They fix it up for sale over the course of a year as I believe the deed contains o one year resale prohibition.

The use, possession or sale of illegal drugs at the Dwelling is prohibited.