Getting Data for my area

[Bob Bartel]

In the next year I will be purchasing a number of buy-hold single family rental properties in my area. I have access to the MLS and Zillow, and any internet site, but on the surface I can't seem to extract from these tools the information I need. What I am looking for is the ability to review (hopefully in Excel) the prices, square footage, number of bedrooms, etc. and potential monthly rental values for properties in a specific geographic area. What I hope to discover is the average rental potential for a house with a specific square footage, number of bedrooms, etc. (on average). I can see this information one-at-a-time, say on Zillow, but what I'm looking for is a more streamlined approach where I can load many, perhaps even hundreds of homes into Excel in order to create averages.

I'm hoping this will allow me the ability to see the potential or lack of potential for any home that comes on the market in my area.  Is there a way to quickly get this information for dozens or hundreds of properties so that I can create these averages?