As such, many aren't incentivized to advise you along that path (sad but true).

If the property appraises for $500,000, you would only be able to cash out $375,000.Would this still be true as a primary residence or would we be able to find something like 5-10% down on a 30 yr loan?

They are just partnerships with local teams and the true beneficiaries here are FS and the teams at your expense.

IF it's too good to be true, then it IS!

Bottom line, if it sounds too good to be true, it probably is.

True off market deals are ones that you find yourself, direct from the seller without a wholesaler or any other middle person involved. 

The same is true for a house—placing a tax-advantaged asset into a tax-advantaged investing account cancels the tax advantages (or many of the immediate ones).Maybe @Michael Plaks or @Kaaren Hall can explain this better or correct my understanding here?

Is that true ?

True if it is not negative cash flow.  

True, another good option is to link forces with another wholesaler and advance it together.Good luck!