It starts with the location.The location, not the property, is the most important investment decision because it determines all the long-term income characteristics including:Whether rents will keep pace with inflationHow long your income stream will lastHow reliable your income stream will beThe location selection process involves eliminating cities unlikely to provide the dependable passive income you need through a series of elimination filters.

The location determines all long-term income characteristics.

But curious what those common themes or characteristics that signal what type of partnership structure makes sense ? 

What would you recommend looking out for (characteristics, credentials, etc. they should or shouldn't have)?

The chart in that article goes as far as 8/2020 so the current numbers are likely different.The metrics for what a high risk loan are "A high risk loan has at least two of the following characteristics: a loan-to-value (LTV) ratio higher than 90 percent, a borrower debt-to-income (DTI) ratio above 45 percent, and a borrower credit score below 680."

What are the characteristics of the neighborhood/area that would best suit my criteria given below?

At least, some savvy people must have developed some sort of a proxy by which they look up certain demographic characteristics or some specific retail presence (Starbucks or something) to identify target neighbourhoods?

For maximum rentals and property characteristics that are ideal for an ADU, here are a few neighborhoods in City of San Diego I focus on: Normal Heights, South Park, City Heights, North Park, University Heights, and College Area.

Cool and complex tables and graphs can be made using professional presentation slides, they will look like these + provide detailed information about the property, including the physical characteristics, recent renovations or upgrades

We cleared out scrub and unsightly nuisance vegetation, bushhogging entire 340 acres.