My current understanding is that ADUs may offer better cash flow, although they may not necessarily provide superior appreciation compared to condo investments, considering the anticipated decline in interest rates over the next couple of years.Thank you for your expertise and guidance!

We've done about 2000 ADU's in the Southern California area, and I am also building roughly 20 ADUs currently in San Diego, I'd love to help you understand the process and how I can help.

If you don't fully understand the investment, do not invest. 

I'd be willing to live in it which appears to have some benefits for a condo conversion depending what town you're in.The thought being that we could buy a duplex/triplex/quad, convert it to a condo, and sell off the remaining units leaving me with (at the end of the day) an affordable housing option.Here are the condo zoning laws that I found for Sunnyvale: https://www.huduser.gov/portal...My understanding is that they don't do condo conversions with <3% rental vacancy rate, but it looks like it was 3.1% from the most recent HUD market analysis for my area that I could find: https://www.huduser.gov/portal...Does anyone know someone who has done a condo conversion in the Bay Area?  

@Nate P.Your profile hints that you are living abroad.If you are a US citizen - you want to make sure that the CPA you work with understands the foreign earned income exclusion(FEIE).If you purchase a property and are expecting valuable feedback on how that property will impact your tax return, you will need to provide a rough profit and loss projection(rental income and expenses) along with purchase price to have a conversation with your accountant so that they can provide you good feedback. 

These are, or should be standards in design and build, that translate to any and all economic markets:1 - Treat the design as the first few times (changes) you will build, and pay for, the house.2 - Treat the design as a system, made up of a series of interacting systems.3 - Understand that design is a series of decisions, with each decision impacting more than just the immediate decision you are making. 

(even though buying something else would also put me at the same rate)My understanding is that an owner occupier would pay more for the property than an investor, but i  have leases that end in September, which is not the best time to sell. 

  :)I don't think you understand the brokering side with DSCR loans, lol.

I understand the general concept of how it works, but not a lot of the intricacies.

Specifically, you'll want to collect and analyze a LOT of comp sales data (including data pertaining to days on market, price reductions, the buyer pool, etc.) so that you have a very good understanding of the buyer pool, and how difficult it could be to sell this type of property...I'd suggest talking with multiple agents who have experience with this type of property, and asking them what type of DOM, ARV, and sale experience they would predict for the property.Before you take on $25k+ of credit card debt for a rehab, you'll want to consider all the potential problems you might face with your strategy, and potential solutions to those problems.