@Anthony Swain
Thank You for your response. I know a condo is not the best way to go even without the conversion issue. I am set on Los Angeles because that's where we are at least for the forseeable future (minimum 3 years). Not only am I in Los Angeles but the area I am limited to is one of the more expensive in the city.
That's why I had the condo idea, it would be the only way to get a 2 bedroom for my family of five and be able to rent out a two bedroom and cost in the $1M range. (I know, prices here are whacky).
The next option would be a small duplex, which at the lowest in my area is $1.5M! SFHs in my area are many times even more expensive than duplexes, but never significantly cheaper. That being the case, even with an ADU, I would be paying at least 10k a month for the mortgage and taxes, and then have to get extra funds for the ADU, and I would not have that income for the first while.
I am on the lookout for duplexes and fourplexes that may work, albeit with me just breaking even. But if the condo would have been possible it would have been a great deal. Spoke to a local real estate agent and some others and so far everyone says that it would be a huge headache (legalities etc) and would cost a ton up front.
As far as renting out rooms, that would probably be the most feasible option but not going to work for our family (we have three small children thank G-D)
Would love to hear if you have any suggestions!