In short I want to know ways that you have made deals like this work and/or any creative solutions for keeping a tenant in place. 

I love those deals.

You're absolutely right, creativity is essential to make deals work in this environment, and building from the ground up, especially in high-demand areas like Raleigh, can be a great solution.Your current project sounds like a smart move, particularly with the zoning for a duplex and ADUs.

You do not need a negative cash flow deal to show a loss on your Schedule E.

Having to get super create just means you aren't prepared for the deal. 

Having a property manager is the solution for dealing with matters that occur with problematic elements of our population, and in alleviating yourself from these kind of stressful encounters.  

I spend all day sourcing deals now.

Additionally, I also have another K1 (LP only)- Since I am not a GP in this deal.

As you mentioned here, we are also reducing our commission on certain deals whether its to make the #s work or to have the seller pay our entire fee.I also agree that many brokerages haven't prepared agents for this.

If the amenities make the fees worth it, then it may not be a bad deal.