Question about duplex, triplex, fourplex

[Gary Nicholson]

I live in southern California. I am considering a multifamily unit, but the real estate prices are high here. If I bought  say a triplex, I could live in one unit and rent out the other two, but I would still have to pay my part of the mortgage, so no positive cashflow. Is it worth it doing this? Or should I consider buying in another market? Triplexes here are around $850K+ I could hold on to the property for appreciation, but I wonder just how much they would appreciate since they cost so much?  Thank you