The reason to have comparables is if you are representing someone or perhaps purchasing a house for yourself to live in.

I would pull a FHA loan for $665,000 and live in one side and rent the other side out to a family member for $2,000 a month.

Because if you need to live off the cash flow what you're really looking for is a business. 

Kyle  My father-in-law did this by creating a portfolio that is primarily debt-free single-family rentals in the city he lives in.

Hey @John FriendasI have purchased 4 of my Co-Living (rent by room) properties with DSCR, 1 of them within the last few months.Not that I necessarily recommend this, but there are short-term-rental DSCR products.

If you go into Central or South Scottsdale (Old Town) $1M will buy you a smaller, older home, OR half of a big, remodeled home (as alot of the Arcadia and Old Town area are turning over old small homes to be big beautiful homes in the $2.5M range and higher).There are options.....for both buying and renting, that would work with your situation.By the way....it's 51 degrees in North Scottsdale right now where I live. 

The answer is yes, but it is generally found when the owner is also living in at least one unit (aka "House Hacking").

I know we all got to make a living but....

I'm imagining something more like add a wall, turn a bedroom into a kitchen-living on one side and a formal dining room into a bedroom on the other side, maybe add a half bath in each unit.

Yes 1k sqft is small but probably much better than living with family.