I'd prefer a small business.

Do have an idea of your preferred acquisition price and how much rehab might be required? 

Personally, if I can hold with a little bit of cash flow but good upside appreciation over time I’d prefer to hold.

Would the person who takes on more labor to repair the property have greater preferred equity or is this usually treated differently?

Quote from @Keith Groshans: My preferred investment in my SDIRA is mortgage notes.

It also provides an opportunity to interact with the buyer.

I usually try to get 10k but sometimes its not possible and I would prefer to make something and give the investor a good deal rather than make nothing trying to move a bad deal.

.), I'd recommend that the residential units fully cash flow the loan as my experience is that mixed use properties are tougher to finance as most lenders tend to prefer one or the other and something in the middle gets more difficult.For example, and granted I don't know anything about the area/neighborhood, I would expect this property (https://www.realtor.com/realestateandhomes-detail/111-NW-Har...) to be easier to finance than the mixed-use property you mentioned. 

Curious to know opinions from real estate agents, flippers, developers and anyone in the know regarding what home buyers generally would prefer.

Additional DetailsI’m willing to invest in out-of-state properties, though I prefer areas with good property management options.My primary focus is passive income, but I’m also interested in value-add opportunities.I want to ensure these investments provide strong tax benefits and diversify my portfolio.I’d love to hear from experienced investors:What would you do in my position?