The reason agents don't like it is because you haven't explained to them how the listing agent and buyer agents get paid.

Seems like the sensational answer would be to direct me to a YouTube video explaining how to acquire property with “no money down.”

I feel that most people make this sound really good because it gets hype and attention online, but I have yet to hear anyone actually explain in real terms how this works...

It explains the team that you should develop to have a strong foundation under you when your investing virtually.https://www.biggerpockets.com/blog/core-four-real-estate-team

@Jason FrinkAs others have said, perhaps your CPA isn't quite explaining things properly or clearly enough? 

The only challenge I faced was explaining how my deal worked to the seller and the loan officer.

I recommend reading some good books that explain the power of leveraging and scaling.

The City explained that the zoning code doesn't have separate provisions for an ADU, and that dwelling units are considered dwelling units regardless of size.

Obviously a higher down payment will always help properties cash flow since your payment will be lower, but I did want to explain the options available when you actually live in one of the units.Definitely assemble a team that works in the areas you want to invest in and you stand to learn a whole lot - I hope this helps!

My other question is can you please explain how to remove the building and depreciation reported under the individual tax return when transferring the property to be recorded under the partnership return?