I'm going to assume you don't want to live in the same house as the renters, meaning no separate entrance? If that is the case I don't think its an area of town as much as typically homes built before 1980, I've seen homes before 1980 typically can have more creative options to convert a garage with sep entrance, have a casita or 1 single family house that can be converted to a duplex with separate entrance. I'm East Valley so I typically see these in older parts of Tempe, downtown Chandler, downtown Gilbert or all over in Mesa. The exception is Lennar and I think one other builder is constructing multi gen homes, I saw a cool one from Lennar we almost purchased to move in and Airbnb the casita, I ran #'s and saw that we could be within 300-500/mo of having our mortgage/tax/insurance paid. There would be in HOA if you did that but have heard from others who do it that they are more forgiving if you live in the premises. Lennar calls them Next Gen.