this is very common.. 

I will give some example numbers, and please let me know what you all think.Perfect scenario example :Buy a property for 80k, put 25k into rehab, and it appraises for 150k.

Heard many flipping disaster stories and want to learn how to avoid the most common pitfalls?

This is a common term used for someone whose primary role in the partnership is to secure the loan, commonly through their financial wherewithal of their net worth and liquid capital.

Common rookie mistakes can impact your property value, income, time, and sanity.

You would have to create an HOA to manage the common area and keep control of that or create a self-managing HOA for the four owners to manage together.

Looking to invest in a few properties over the next 5-10 years and want to get a sense for tenants, common issues, etc.

In your experience do you see people commonly attempting to offset ordinary income / W2 with syndicated losses, despite the above?

I have doubts about his experience in RE, which I believe may be common among CFP. 

As others have commented, this is a scenario where you will have most luck with a private individual lender or some other local financing - just too small for pretty much all the national platform hard money lenders