This is an important point and I have been in similar situations when we have moved into new counties (I am a PM so manage in about 8 different counties). 

You bring up some great points, especially about the importance of thorough due diligence.

Depending on your level or preference of analysis, data and their providers are incredibly important and difficult to obtain when it comes to real estate underwriting.

That's why I stress the importance of building a relationship first.

Obviously the net number is what's most important to sellers typically but I have found escaltion clauses and offering free rent backs to the seller are just a couple of ways to make your offer stand out. 

However, it’s important to understand the loan’s key requirements:Owner-Occupancy: The borrower must live in one of the units as their primary residence for at least 12 months.Single Borrower: FHA loans are issued to individuals, not partnerships or entities, which means the loan would need to be in your name alone.Given your scenario, only you can qualify for the 203(k) loan since your partner does not intend to occupy the property.2.

PassivePockets is a great place to do this as well as live events such as BPCON every October.Just as important as networking is education. 

However, with the condos, I do know that the in/out element is very very important.

It's an important metric as it gives you an idea of how long it may take you to fill a vacancy. 

This is especially important since you say you want to live in the ADU with your wife.