Househacking a quadplex in an appreciation market

[Dainmeyen Brown]

Question: Currently searching for a quaplex to househack in an appreciation market. All of what I've learned says if you're not receiving positive cash flow, DON'T DO IT. However of all the properties I've seen and analyzed in this market, I haven't seen 1 property in this market that allowed for a househack AND positive cash flow.

Is there ever a scenario where purchasing a multifamily that gives negative cash flow is a good choice? What would that look like?