January 2, 2010

Biggest Discounts by City in November

Let’s check in on our stats to find out where buyers are currently getting the biggest discounts off asking price. If you are a potential buyer, this will help you to know which neighborhoods may be softer in terms of sale price discounts off list price, and help you know where to look for potential bargains.

In the charts below, we have taken all sales data from the month of November in Redfin’s Washington DC service area and sorted it by city.

Methodology
First, we compiled a list of every sale that took place in the month, calculating each sale’s sale-to-list ratio (based on the final list price). Next, we simply take an average of every individual sale’s sale-to-list ratio to calculate an entire area’s sale-to-list ratio. Any sales that came in with a sale-to-list ratio above 150% or below 50% are excluded from the calculation, and areas with fewer than twenty sales are excluded from the top and bottom ten rankings. Interested readers may download the full data summary in Excel format (xls).

Here are the top ten areas with the largest overall discount:

DC Sale to List most 2009 11 Biggest Discounts by City in November

The overall discount dropped a bit from our last update (based on August sales), moving from 2.0% to 1.7%.

Here are the ten areas with the smallest discounts:

DC Sale to List least 2009 11 Biggest Discounts by City in November

In the 79 areas we ranked, the median discount was 1.9%.

Is the area you’re shopping not on either the top 10 or bottom 10? No problem, just download the full rankings in Excel format and check out the appropriate “Full” sheet.

Of the 6,560 sales we tracked in the 1-month period, 1,415 homes sold for 5% or more off the asking price, while 573 homes sold for 5% or more above the asking price.


  • Chick LoMein
    One thing I notice is that the major decliners are more wealthly zip codes and seem to have had, at least in the last 1.5 years, a less severe decline. Many of those areas which declined the least or even gained, it appears, were, generally speaking, less wealthy zip codes.

    The reason for this seemingly upside down result is probably due to the fact that the major decliners are late to the game and still have a way to go and do not benefit as much from the tax incentive, while on the otherhand the areas that declined the least have been brutalized earlier, bottomed out already and benfit more from the tax increase because of the generally lower housing prices.
  • Leslie White
    Hi Tim,

    I'm looking at your recent data about sales to list prices here in the DC area and I wonder if it's possible to make a request. On the spreadsheet of all data, I see that the 'count' for Washington is the highest of all counts in the region. Yet there is no break down at all by area within the city. It really is hard to understand what is happening in one part of town vs another because there is no differentiation in this data.

    Just as a comparison, I looked at the report for the Seattle area and see it's the same thing ... Seattle as a whole lumped together, but all the surrounding communities broken down well enough for a useful comparison.

    Given how hard it would be to figure out what property is actually in which neighborhood, I wonder if you can break out this data by zipcode within the cities like DC or Seattle. Would be so much more useful for folks like me, working in a city.
  • Sorry, I should have been more clear. What information I have is limited to what the Redfin data gatherers pull from the local MLS for me. Unfortunately I do not personally have direct access to any of the MLS systems.
  • Frank
    Sure you do.
    In the DC area, the seller subsidy is an exposed field (unlike Seattle). You should easily be able to pull it into Excel and use the more real "net" number.
  • No, unfortunately I do not have that information available to me. This is just strictly the reported sales price vs. the last listing price.
  • Frank LL0SA
    This is really awesome!

    Did you take into account the net price after seller subsidy? I wonder if that would change anything since many areas with lower priced homes have larger and more frequent subsidies.

    Thanks again!

    Frank
    - Broker
blog comments powered by Disqus
close