One classic example I came across few years back; JDA had 13 floors of residential building, 8 floors for Developer, 5 for Landowner.

You can filter by the beds and baths and other aspects to make the results as close as possible to the one you're comparing.When I build my semi-automated hotsheet for investors, I take exports from the MLS from both the sales side and the rentals side, pull them into a SQL Server database, do some data cleaning to screen out as much of the garbage as possible, and run what I call my "magic query" that joins sale listing locations to rental listing locations by a conditional match on subdivision and beds/baths, or the average of the entire MLS if the subdivision is given as "METES & BOUNDS", with a flag in the output showing that those M 'n B rental numbers are MLS-wide averages for a given beds/baths and will need a more in-depth evaluation (like rentometer) if the estimated cash on cash return for a classic 20% down scenario, looks promising. 

For example; if you were getting a commercial loan in New England; the bank would usually base the interest rate off of the FHL Bank Boston Long-Term Classic Advance Rates: (https://www.fhlbboston.com/fhl...)

For investment purchases the classic scenario is "20% down" due to an LTV of 80% but if a bidding war drives the price up to $20k higher than appraised value, the 20% down is now 20% plus $20k cash requirement in addition to closing costs. 

If I found a duplex+ going for 380k or less and the cash on cash ROI for the scenario looked good (classic investment due diligence on whatever deal I find), I would sell off the stocks, both indexed and aggressive, go to a lender with that cash position and bank statements and tax returns, get qualified, and make an offer.  

YUP sounds like the classic  bait and switch some agents are famous for.. 

The upshot may be that you go with a classic 70 to 80% LTV commercial loan, but it seems you might have a cash position to support that just from the stocks.

The classic answer is to leverage and buy multiple!

This is the classic reason given for why you should never use home warranties with rentals.

Classical Post Hoc Fallacy.