The individual I am referring to contacted me via telephone, if that makes any difference. 

Our policy is agents are not allowed to show houses to anyone they haven't already met and texted us a picture ID of the individual.

Individually getting conventional loans or FHA loans (this is a viable option for us as we live in a duplex that is half owned by my partner) and hoping that if we do decide to incorporate at some point in the future and hope that due on sale doesn't bite us in rear. 

@Price KenneyYou want to connect with an accountant who is very familiar with taxation as it pertains to foreign investors.A couple things to consider.1) Depreciation calculated may be different if the ultimate owner is US or Foreign.2) Corporation tax rate decreases with the most recent tax reform made "blockers" more attractive.3) use of a blocker is favorable to many foreign investors as you are not required to file a US individual tax return and not required to disclose all other personal information to IRS.However, all the facts and circumstances should be addressed before preceding so please consult with a competent accountant.

CoreLogic’s indices tend to be better but you must pay to access them.

Even with the rent thing out of the picture I’m still currently looking for an intelligent individual to learn from.

One thing to note when looking at the individual markets, you can make or loose money in any market.

But, it all really depends on the individual doing the analysis.I have a simpler spreadsheet I've created that I'd be happy to share with you if you'd like - just PM me your email and I'll send it over.

As others have indicated, if you turn a tenant you have 0 rent until it is re-rented.

You will need to trace out the route of the heating pipes to see if they are separated out to the individual units from the basement.