Hmm...there are a lot of ways to look at the data and come to a conclusion about it.
Lies, damn lies and statistics comes to mind.
Garbage in, garbage out does too.
But I am a cynical appraiser, who won't appraise anymore, because I am a little too good at math, and a little too honest to do it anymore. Many of my "peers" however, charge me as incompetent, and have other things to say on the subject. Let 'er rip. Computers will likely replace appraisers, and that is going to be much worse than simply dealing with the flaws of humans. The bright side will be, you will get approved for a loan in a few clicks, because who cares, the taxpayer will bail it all out anyways, and money can be re-printed as fast as it is lost. Sigh.
Anywhos...what were we talking about? O, statistics. Right.
I think you are attempting to determine the absorption rate and months of existing housing stock right? Which could give you an idea of how long it might take to sell?
That goes like this, but you will need access to the data and plug in the right data too:
Total number of closed sales in the prior year, divided by 12 = average number of sales per month in the prior year (historical absorption rate)
Total number of active listings, divided by the absorption rate = likely number of months it will take to sell the existing stock (months of housing supply)
Now, if you have the data that will tell you how long it is currently taking to sell property, called the DOM or Days On Market, you can compare that to your results, and get an idea if the market is getting better or worse as compared to last year.
Hopefully the realtors in your area are not playing with the data, and causing the DOM to reset. Naughty naughty.
If you have access to average DOM data, be weary of where it comes from. I've found the MLS algorithms to be interesting too. You might want to do your own calcluation, again if you have access to reliable data.
But besides all that and just going for it, as a general rule, so long as the entire economy is not in the crapper, all properties sell, usually quickly, when appropriately priced.
It's usually an over-priced property, or a property with issues, that keeps it from selling, if that is the concern you are trying to work out.
As far as identifying areas to farm (lol I thought you were trying to buy a farm on the first read) well, if you don't have access to the data to figure it out, maybe following the leader is your best bet.
Best thing about the Zillows of the world is they publish solds. You can see the sale price and sometimes look at the interior photos. Look at a few thousand of those (not kidding), and the trends will begin to show themselves. And on that note, let me leave you with this one little piece of sage advice, if I do say so myself - one comp does not a market make.
...but but but, the house down the street sold for X...
Yes, yes it did. And your point is?