Overstated home sale numbers?
How many homes are people buying, and how much did they pay?
The go-to source for that information has long been the National Association of Realtors. But real estate data firm CoreLogic says the trade group's tally of the number of homes sold is too high by a substantial amount:
Historically, the CoreLogic existing sales data have covered about 85% to 90% of all NAR’s existing home sales data. However, in 2006 NAR’s sales data became elevated relative to the CoreLogic, MBA [Mortgage Bankers Association], HMDA [Home Mortgage Disclosure Act] and Census sales related data, and that trend has continued and become more pronounced through 2010. There are several reasons for the divergence, including benchmarking drift, more sales going through MLS systems due to consolidation and a lower share of for sale by owners (FSBO) home sales. Net, NAR’s existing home sales data are overstated by about 15% to 20%.
A CoreLogic economist told The Wall Street Journal that he sees it as the difficulty of adjusting data accurately in times of big changes -- the National Association of Realtors' statistics are built on a sample -- rather than a "gaming-the-numbers issue."
But some were quick to see ill intent from a group whose members benefit if people think it's a good time to buy. "Where are the subpoenas and Congressional hearings?" asked trader Karl Denninger on the Seeking Alpha blog, suggesting that people overpaid for homes as a result of relying on faulty sale data.
The National Association of Realtors is re-examining its numbers, The Wall Street Journal said. (Reuters reported afterward that the NAR was calling any overcounting "relatively minor.")
So what about the local figures?
They're reported by the company that runs the area's multiple-listing service, Metropolitan Regional Information Systems (specifically, its stats arm, RealEstate Business Intelligence). If there's any intentional adjusting going -- starting with a sample and extrapolating upward or trying to account for unlisted sales -- it would be news to me. So that seems to be a more solid starting point, at least. But the recent back-and-forth that came when MRIS's stats arm redesigned its statistics database wasn't exactly confidence-inspiring.
One useful comparison is the multiple-list sales vs. all recorded arms-length home sales. The multiple list should account for most but not all the arms-length sales, because not all homes are listed before they're sold. The state Department of Assessments and Taxation, as it happens, just shipped me data on all arms-length sales recorded in 2010.
Baltimore metro area home sales last year as originally reported by MRIS: just under 21,500.
Baltimore metro area home sales last year as recorded with the state: just over 23,900.
Does that mean everything's hunky dory? I'd need prior years to see if the difference is typical, and since I'm on vacation this week I don't have access to most of my files. But at least the multiple-list figure is less than the state's figure.
Statewide, that's not the case.
MRIS covers most of Maryland, with the rest handled by the Coastal Association of Realtors. Together, they show just under 50,900 homes sold last year, according to the tally by the Maryland Association of Realtors.
The state, meanwhile, has records of 47,817 arms-length home sales -- about 3,000 less than were supposedly sold on the multiple list.
Hmm.
Thoughts?







Comments
What do you expect from the NAR?!?!? They will do ANYTHING to sell homes and put that precious commission in their pockets; including "upping" the numbers to make the environment appear better than it is. People (Buyers and Sellers!!) have to learn this: Realtors make a commission, so your needs may be outweighed by the need to pay their bills!!! They are no different than car salespeople.
Posted by: Assnap Kined | February 23, 2011 8:35 AM
The National Association of Realtors is re-examining its numbers...
Haha, that's a good one.
Although some elementary math might need re-examining, when this association comes up with numbers, I instinctively divide everything by 2.
Posted by: Not Flabbergasted | February 23, 2011 10:18 AM
So far they have replaced their "economist" for (too obviously) specious projection and bloviating...
now they get to replace their accountants too.
Posted by: MrRational | February 23, 2011 12:06 PM
Hi Jamie - I always check in with your blog for the latest on Baltimore housing! Great information for your readers.
I am an independent appraiser/market analyst brought in by MRIS/RBI to provide additional analysis and commentary on the Baltimore housing market.
Here's what I wrote about the NAR controversy last week in my own blog. I think the NAR controversy is more about the multiplier tying the 2000 Census' American home survey to MLS sales totals and the fact that a decade went by without any modification of the adjustment despite the changing landscape. CoreLogic compared against the NAR extrapolated numbers and noticed a widening gap between their results and NAR's. I think your effort here is to do a reality check between public record results against the MLS results.
I'm just curious - in your Baltimore Metro to Baltimore Metro comparison, RBI includes Baltimore City, Baltimore County, Anne Arundel County, Carroll County, Harford County, and Howard County. Does the data you are comparing include the same geographic boundaries?
I find it fascinating, especially in the current market, how much the real estate conversation revolves around national/regional home price indices that lag the market by as much as 6 months. I'm guessing that most consumers don't realize it.
With the systems upgrade, which was brief but painful, RBI provides more market transparency with even more robust analytics. Look for a lot more reporting on market conditions from moi, especially pending home sales.
Posted by: Jonathan Miller | February 23, 2011 3:44 PM
Hi, Jonathan -- thanks for popping in. I am indeed using the same definition of the Baltimore metro area to compare the MRIS/RBI numbers with the public records (the federal definition of the metro area includes Queen Anne's County, but locally, it's usually left out).
Do you have any thoughts about why the two MLS systems in Maryland would be showing more sales in 2010 for the state as a whole than were recorded? Inevitably some sales are settled in late November or December but aren't recorded until January, so the timelines aren't identical. However, that happens every year. Is there something else I'm missing?
Posted by: Jamie Smith Hopkins | February 23, 2011 4:19 PM
Ok good to know about Baltimore. As far as comparing Maryland statewide and 2 different systems, I am not sure - I am always leery about arm's length classifications in public record - from well-earned experience as an appraiser. ;-) However I'll look into it and get back.
Posted by: Jonathan Miller | February 23, 2011 5:00 PM
Ah, have you seen a trend of arms-length sales classified as not arms-length? (Short sales and REO sales, perhaps?)
Posted by: Jamie Smith Hopkins | February 23, 2011 5:12 PM
Here are a few thoughts on the earlier points you brought up relating to Baltimore stats. RBI hasn't posted it's year end 2010 data so I am not clear what is being aggregated. I think you'll see more consistency once the data goes live (soon). The Baltimore area state data captures owner occupied and does not include auctions, foreclosures, etc. MD uses fiscal year for their stats July 1 - June 30 so perhaps that is why the statewide data doesn't match up.
I haven't specifically observed that trend but it is logical. If the state omits REOs and short sales as arm's length (I am not specifically sure about that - off the top of my head) and we clearly see a general increase in distressed sales activity, then yes, the data will not match up.
Incidentally, I've linked out to you from Matrix for a while now.
Posted by: Jonathan Miller | February 24, 2011 9:41 AM
Are you sure those MRIS numbers are accurate? Sometimes they take longer for the realtors to really report what is happening.
Posted by: fsbo mls new york | February 24, 2011 10:09 AM
Jonathan, the state recordation figures I used are calendar year. I have the underlying data, so I can see that the dates run January-December. For the MRIS/RBI numbers, I tallied the initially reported monthly figures for a full-year number. That's not going to account for any changes that happened after the initial snapshots -- sales entered late, for instance -- but they are the figures that people look at from month to month.
I know that there are short sales and foreclosure resales being entered into the state's system as arms-length transactions, because I've seen plenty of examples in past data. What's more difficult to tell is whether most/all short sales and foreclosure resales are getting coded that way, or whether a significant number are knocked into the "not arms-length" category. No dataset is perfect, that's for sure.
Interesting commentary on the numbers fight, by the way: http://matrix.millersamuel.com/?p=10476
Posted by: Jamie Smith Hopkins | February 24, 2011 1:18 PM
Ok good to know on the Baltimore data.
If I understand your methodology, annualizing the monthly creates a high probability of skewing the annualized from actual, high or low because of seasonality. Maybe that's the reason for the statewide disparity.
Aren't you on vacation BTW? If so, you are definitely a wonk. ;-)
Posted by: Jonathan Miller | February 24, 2011 3:03 PM
Yeah, vacation isn't what it used to be. :-D
I didn't annualize one monthly figure (i.e. December times 12), but rather added up January through December. That's never exactly the same as the year-end total MRIS/RBI releases in February or March, but it's usually pretty close, if memory serves.
Posted by: Jamie Smith Hopkins | February 24, 2011 10:57 PM
MRIS numbers come from data where one can associate a property to each transaction and they used to be aggregated on the same day of the following month every month. RBI seems to still be working this out. Transfer recordation does lag MRIS reporting and this lag seems to vary by jurisdiction, not metro area. Also, there are areas on the Eastern Shore where properties are sometimes listed with two multiple listing services and may then be reported as sold by both those services. This is not a big number but would make it difficult to reconcile SDAT and multiple listing service data.
Note that December 2010 was the best December for Baltimore Metro closings since 2007, and thus, a lag in SDAT reflecting this data until January will make it impossible to reconcile the data. If the market was consistently seasonal, the same percentage of annual sales in each month each year, we could establish the lag in recodation data and reconcile. However, the month of the year is only one of the factors contributing to this roller coaster ride the real estate market has been on. There have been tax credits. There have been interest rate and underwriting changes. There have been swings in consumer confidence.
I believe it less important that one can reconcile all the different data banks and more important that you look at the changes in each given one. This is what we do with all the indices.
Do not lose sight of the fact that for most of us a home is a place to live first and I expect that where we live may just cost money, not be an ATM.
Posted by: Ross | February 25, 2011 11:01 AM
Hi, Ross, I'm glad you weighed in -- you would have been one of my calls had I been in the office this week. Good point about December 2010, and I didn't realize that there was MLS overlap on the Eastern Shore -- that's interesting.
Posted by: Jamie Smith Hopkins | February 25, 2011 3:48 PM