I would like to invest in Real Estate in a "buy and hold" property, with long term gain objectives (I don't have much time to manage it, so can't flip houses, just a simple renting set up would work for me.

@Henri MeliHey Henri,I am over the shiny object syndrome.

Once you've proven you can sell blue shoes to blue-shoe-shoppers, then you can get into broader marketing objectives like Facebook interests and behaviors (Facebook retargeting Adwords traffic being the only exception here).

I used the lead generation objective for the campaign.

Ultimately, the two objectives are to defer tax on the sale, and participate in 50% of the profit/loss and appreciation of the new property.Perhaps a better way would be to use the $250K proceeds to purchase a 25% interest in the $1M property and have my parter get 75% interest while being solely liable for the $750K mortgage? 

As noted, more information is needed for sure but I can think of a few possible scenarios depending on each of your goals and objectives. 

@Rosario Aiello start by defining and quantifying your objectives and criteria.

I suspect if your neighbors object to a permit being issued for a multi family project being built the application will be rejected. 

I still see the Bay Area as prime, and if immediate cashflow was not a primary objective for you, I do believe that you'll still see the values appreciate over the long term. 

The object is for you to offer terms without creating a contract, especially since you wouldn't have had an attorney prepare it yet for you.