I would appreciate any advice on anything I may be missing with putting this together or should neogotiate before finanlizing.Negotiated so far:Property: 9 Unit - 7 Apartments + 2 Commercial Garages (4 unit apt building + 3 unit apt building w/ commercial garage attached + standalone commercial garage on same lot)Background/Why owner is selling: A seasoned builder of 50 years, the owner purchased the property in the 1970s for around $8,000.00, later developing three apartments and two commercial structures.

In your case, changing the property from a rental to your primary residence constitutes a change in use.The depreciation recapture will be calculated based on the fair market value of the building at the time of conversion, not including the land value.Since you're tearing down the existing structure, the entire amount of depreciation taken over the past two years will likely be recaptured, as the building's value at conversion will effectively be zero.The recaptured amount will be taxed as ordinary income, up to a maximum rate of 25% for residential rental property (Section 1250 property).

My tax professional is stating that I would need an appraisal to show the lot/structure are valued at $400k if I try to claim $200k as a donation.

Beyond real estate investing, BiggerPockets Money has great episodes on how to avoid the middle class trap with your investments - ie how to structure your investment best so that they're not all locked up in accounts with penalties until you're 65. 

For property owners in this area, what have you seen in terms of supply and demand. 

While I understand the basic structure of General Partners (GP) and Limited Partners (LP), I was under the impression that GPs always had to put 'skin in the game.'

The country simply does not have enough affordable housing units, and the new supply of affordable housing units is not keeping up with new demand.

Trying to make this as structured and organized as possible.Thank you.

Appreciation is driven by demand outstripping supply, and cost of new supply. 

.- If you chose to set up your LLC as a pass-thru entity, then you will need to supply your SSN.FYI - to avoid getting nasty letters from the IRS about errors (which might cause us to be audited), we will ask for a copy of your EIN assignment letter or a copy of your SSN card to confirm those numbers.