How many home sales are taking place outside of the multiple listing service in your market? Clareity Consulting’s Matt Cohen says MLS executives around the country are showing an interest in getting to the bottom of that question, and he’s written a blog post explaining how to do just that.

Pocket listings are not new, but recent inventory shortages in many markets could be creating conditions — lots of buyers competing for scarce listings — that are ripe for real estate brokers and agents to close deals outside of the MLS.

A study by Silicon Valley-based MLSListings Inc. suggests that pocket listings constitute a significant and growing chunk of home sales. That study found that pocket listings made up 26 percent of home sales in five Northern California counties in the first quarter of 2013, up from 15 percent in 2012.

A wider, but still limited, study of four large U.S. counties from CoreLogic earlier this month suggested that MLSs played little or no role in nearly half of home sales in 2013, offering more insight into a topic that has generated plenty of rhetoric, but not a lot of hard data, in the industry.

The limited scope of these studies has prompted criticism from some, who say real estate is local, and the trend cannot be generalized to the nation as a whole. Cohen says MLSs “around the country are beginning to consider replicating the original MLSListings study in their market.”

“Understanding the scope of the practice and the harm that may be caused to consumers is necessary if an MLS is to discuss the trend with membership at the local market level,” Cohen wrote. “Such studies may also inform further discussions at the national level.”

He describes MLSListings’ study method this way:

1. Pull all sales for single-family homes, townhomes and condos from tax records within a particular settlement date range. Exclude all records with a blank price field to remove “nominal transactions” such as quitclaim, interfamily trusts and similar deed transfers.

Review records manually to get rid of nonapplicable transaction records, such as those where each unit in a multi-unit property is shown with the price of the entire property and those where the sales price is well below the reasonable low limit of a comparable property.

Format county APNs (assessor parcel numbers) to match MLS data record APNs.

2. Pull MLS data for the same time period, matching the settlement date in county records to the MLS’ close of escrow (COE) date.

3. Match APNs and eliminate duplicate records. The result is properties sold off-MLS.

4. Compare median prices for MLS and off-MLS sales. If the final sale price is omitted from the MLS record because the MLS does not enforce its entry, use the last list price as the best available match.

“For the price comparison, I would consider an alternate approach of using AVMs (automated valuation models) as the starting point to compare both on and off-MLS transactions, rather than comparing one against the other directly,” Cohen said.

Show Comments Hide Comments


Sign up for Inman’s Morning Headlines
What you need to know to start your day with all the latest industry developments
By submitting your email address, you agree to receive marketing emails from Inman.
Thank you for subscribing to Morning Headlines.
Back to top
Only 3 days left to register for Inman Connect Las Vegas before prices go up! Don't miss the premier event for real estate pros.Register Now ×
Limited Time Offer: Get 1 year of Inman Select for $199SUBSCRIBE×
Log in
If you created your account with Google or Facebook
Don't have an account?
Forgot your password?
No Problem

Simply enter the email address you used to create your account and click "Reset Password". You will receive additional instructions via email.

Forgot your username? If so please contact customer support at (510) 658-9252

Password Reset Confirmation

Password Reset Instructions have been sent to

Subscribe to The Weekender
Get the week's leading headlines delivered straight to your inbox.
Top headlines from around the real estate industry. Breaking news as it happens.
15 stories covering tech, special reports, video and opinion.
Unique features from hacker profiles to portal watch and video interviews.
Unique features from hacker profiles to portal watch and video interviews.
It looks like you’re already a Select Member!
To subscribe to exclusive newsletters, visit your email preferences in the account settings.
Up-to-the-minute news and interviews in your inbox, ticket discounts for Inman events and more
1-Step CheckoutPay with a credit card
By continuing, you agree to Inman’s Terms of Use and Privacy Policy.

You will be charged . Your subscription will automatically renew for on . For more details on our payment terms and how to cancel, click here.

Interested in a group subscription?
Finish setting up your subscription