Posted by: The Tim

Tim Ellis is the founder of Seattle Bubble. His background in engineering and computer / internet technology, a fondness of data-based analysis of problems, and an addiction to spreadsheets all influence his perspective on the Seattle-area real estate market.

32 responses to “Puget Sound Counties Interactive May Update”

  1. NMike

    Ok, I’m new at this. If MOS is below 6 in Seattle, does that mean it’s a sellers market?

    Rate this comment: Thumb up 0 Thumb down 0

  2. WestSeattleDave

    The Tim…I’ve noticed over time that when the NWMLS numbers are reported by different media, they never seem to report the same numbers. There would be articles in both the Seattle Times and the PI (when they had a “real” paper) both quoting slightly different numbers from the same NWMLS data. They are not off by much, but they are off.

    As an example, today’s PI has an article by Aubrey Cohen that states: “In King County, the medians were $361,250 for a house and $259,000 for a condo, down 16.4 percent and 8 percent, respectively, from a year earlier and down 3.2 percent for houses and up 5.7 percent for condos from April.” Meanwhile, you report that the King county median is $375,000, down 15.7% YOY (per your snazzy interactive chart).

    Why the discrepancy? Is the King County median $361K or $375K?

    Rate this comment: Thumb up 0 Thumb down 0

  3. masaba

    RE: The Tim @ 2

    Where did the idea of seller’s market being 6 MOS come from? Is that something that the NWMLS made up, or did it come from somewhere else? The reason that I ask is that if you can arbitrarily change the definition of pending sales and thus the MOS, it is really meaningless. Seems kind of like a pointless measurement if there is no standardization.

    Rate this comment: Thumb up 0 Thumb down 0

  4. Roger

    I would say here in Island county the MOS for anything over about 450K is approaching infinity. Lots and lots on the market up there and hardly any closed sales. Some exceptional properties sell above 450 – 500K, but the rest are just sitting. Exceptional means just that, nice waterfront or really nice estates on big acreage.

    Rate this comment: Thumb up 0 Thumb down 0

  5. Kary L. Krismer

    RE: WestSeattleDave @ 3 – I sent Aubrey an email about the $361,250. I think it’s a typo, or maybe it’s Seattle, or 1st or 2nd quarter, but it doesn’t appear to be a monthly number for King County.

    Rate this comment: Thumb up 0 Thumb down 0

  6. Kary L. Krismer

    RE: The Tim @ 7 – Again, if you do absorption rates using solds instead of pendings you don’t have those, and other issues. But in any case the six months is completely arbitrary. I’ve heard the cutoff be as short as 4 months. I think locally that would actually be a better cutoff because we’re used to relatively short time on market compared to other areas. Also, is any seller really going to feel good knowing the average time on market is six months?

    Rate this comment: Thumb up 0 Thumb down 0

  7. aldreth

    Yawn, same old fraudulent crap.

    This country is hopeless.

    Rate this comment: Thumb up 0 Thumb down 0

  8. shawn

    When sellers are showing dirty properties, and you must buy as is, and bid to be lucky enough to buy it, then it I say it is a sellers market. Now that they are dropping the prices and staging the homes, and letting you get the property inspected, I call it a buyers market. Let them fudge the numbers on MOS, that does not change what I just said.

    The only real question is: do you want to buy a property that will worth less tomorrow than today and may take decades to appreciate?

    Rate this comment: Thumb up 0 Thumb down 0

  9. ARDELL

    I LOVE these graphs!

    King County May median sold price, if you take out houseboats, mobile homes and townhomes is $386,500 for May 2009 (median asking $399,000 at time of sale) and $457,741 (median asking $469,000) for May 2008. 15.5% decrease.

    Median Price Per Square foot is $216.9 vs. $191.3 = 11.8% decrease YOY.

    Most townhomes are single family in Seattle, but are condos most everywhere else in King County. Doesn’t seem right to count them as single family in some places and not in others, so best to exclude them altoghether in the stats.

    May 2007 $480,000 – mppsf $227.

    Given the discussion about “discrepancies” in reporting, I just calculated that while typing this comment. (required disclosure: *Stats are not compiled, verified or posted by NWMLS*)

    Rate this comment: Thumb up 0 Thumb down 0

  10. ARDELL

    A seller’s market is when more people want to buy than want to sell.

    Much lower than a 6 month supply. 6 months is a balanced market, not a seller’s market. 3 months…or even less, I’d say for a “seller’s market”.

    But even if you had a 3 month supply right now it wouldn’t be a seller’s market, as there are too many sellers who “want” to sell but aren’t, or can’t because they are upside down (hence all the rental signs). So by the true definition of a seller’s market, unless all of the sellers who truly want to sell were actually for sale, you can’t have a seller’s market. The minute it turned to an actual seller’s market, more sellers would come on market, tipping it back the other way again. It would be a false read.

    Rate this comment: Thumb up 0 Thumb down 0

  11. jon

    Calculated risk did some regression in past markets and found prices were flat when MOS was 6 months. It would be interesting to see how that varies with the price of the house. I would expect the lower end would have stable prices at a lower MOS level than the higher end.

    Rate this comment: Thumb up 0 Thumb down 0

  12. Greg Perry

    I consider a seller’s market under 3 MOS. Between 3 and 6 MOS balanced. Over 6 MOS, a buyer’s market.

    Rate this comment: Thumb up 0 Thumb down 0

  13. patient

    I regard any measure that includes pending sales as useless given the extreme difference between pendings and actual closings. It’s a shame on such nice charts. A change to use closed sales or at least additional charts and numbers based on closed sales would make these much more interresting to me.

    Rate this comment: Thumb up 0 Thumb down 0

  14. NoMoreWork

    RE: The Tim @ 10 – Love the new charts, still like messing around with the old ones. Might think about adjusting the horizontal time scale on the graphs in excel tho, many only go until 12/1/08 and don’t tell the whole story. Just a thought! Thanks again Tim.

    Rate this comment: Thumb up 0 Thumb down 0

  15. Kary L. Krismer

    RE: patient @ 16 – An alternative would be to exclude the short sales from the pendings. I’d still prefer using closed sales, however.

    BTW, I just re-ran the numbers, and we’re now over 1000 closed month to date, and only 28 are short sales. That compares to over 20% of the pendings and over 10% of the actives.

    Numbers from NWMLS sources, but not compiled or guaranteed by the NWMLS.

    Rate this comment: Thumb up 0 Thumb down 0

  16. ARDELL

    Kary,

    Where are you getting the “only 28 are short sales”. If you are using the new search feature, it is not working properly yet, and unreliable.

    Rate this comment: Thumb up 0 Thumb down 0

  17. ARDELL

    RE: Greg Perry @ 15

    ditto

    Rate this comment: Thumb up 0 Thumb down 0

  18. Kary L. Krismer

    RE: ARDELL @ 19 – I’d agree it’s unreliable for pendings and actives at this point, but I don’t see any reason why it would be unreliable for month to date solds.

    Rate this comment: Thumb up 0 Thumb down 0

  19. Kary L. Krismer

    How about this? It’s a seller’s market when most sellers are confident enough to buy a new house before selling their old one. It’s a buyer’s market when most are not.

    Rate this comment: Thumb up 0 Thumb down 0

  20. ARDELL

    Kary,

    I’ll assume that means you did use that feature to come up with that figure. Many agents who listed the property before the data field was available, did not go back and edit their original listing. Most new listings will be accurate, but the pendings and solds…not so much.

    Rate this comment: Thumb up 0 Thumb down 0

  21. Kary L. Krismer

    RE: ARDELL @ 24 – Which is why I said the actives and pendings are suspect. But on the solds for this month (or since the rule went into effect earlier), the agent is prompted to input the information. Thus the sold information is much more likely to be accurate. That’s what I’ve been saying all along here. That’s also why in post 19 I said “over X%” for the active and pending information.

    Sure it’s possible that an agent wouldn’t enter the information correctly. I ran across a bankruptcy listing recently where the agent wasn’t aware the box needed to be selected.

    Rate this comment: Thumb up 0 Thumb down 0

  22. Kary L. Krismer

    BTW, just so people will have an idea what Ardell and I are discussing, there’s a new field in the NWMLS Locator input system that asks if the property is REO/Short Sale or other third party approval (court, etc.) required. When an agent changes status or price, the system prompts the agent to fill in that information if it hasn’t been provided previously. So at this point, active properties where the price has not been changed in a couple of months, and properties that have been pending for a couple of months–those are likely to not have had the information put into the system.

    Rate this comment: Thumb up 0 Thumb down 0

  23. Kary L. Krismer

    I just did a search of sales month to date in King County (SFR). Where the owner was referenced as “bank” there were 69 listings sold, 11 as “undisclosed” (which is another common way of referencing bank owned properties) and using the bank owned field resulted in 85. That would tend to indicate that the numbers provided from the sales data are reasonably likely to be accurate.

    Numbers from NWLMS sources but not compiled or guaranteed by the NWMLS.

    Rate this comment: Thumb up 0 Thumb down 0

  24. truthtold

    Is it the just plain wrong and still posturing realtor from rcg?
    Yikes! How can inevitable rcg gas and fumes be prevented from spoiling seattlebubble’s considerable content? Consistently parasitic and far too comfortable with misinformation…a casual relationship with truth and a professional fondness for suckers – dishonest realtors are of limited value.

    Rate this comment: Thumb up 0 Thumb down 0

  25. Kary L. Krismer

    RE: Kary L. Krismer @ 27 – I take that back. I just found 19 bank owned that were not changed when the sales data was entered.

    Rate this comment: Thumb up 0 Thumb down 0

  26. NMike

    Wow, what a response. Thank you all for your help. FYI I got this 6 MOS standard from seattlecondoreview.com and seattlecondoblog.com, more specifically http://www.stroupecondoblog.com/category/market-trends/weekly-sales-ratios/ . I was puzzled because even if you assume this MOS standard is correct, prices are still dropping. How could that be positive for sellers? In any case, it seems to me that buying a home is a matter of evaluating the particular property, while calling a market is more an indicator of when to start looking or when to stop.

    Rate this comment: Thumb up 0 Thumb down 0

  27. Kary L. Krismer

    RE: NMike @ 30 – Probably what your seeing is the differences in the different markets. In some neighborhoods there is less of a relative supply, and in some price ranges a lot more of a relatively supply. The high end stuff could be pushing the overall numbers down, while the value of a given house in a given neighborhood might not be changing at all, or even going up.

    Also, if you removed the bank owned and short sales from the mix, the median for King County would probably be about 10k higher. Again a different market that might not affect an individual seller or the value of their property.

    Rate this comment: Thumb up 0 Thumb down 0

  28. Kary L. Krismer

    I just did a search, and for June partial to date the difference is just over $10,000.

    Rate this comment: Thumb up 0 Thumb down 0

Leave a Reply

Do you want a nifty avatar picture next to your name, instead of a photograph of Tim's dog? Just sign up with Gravatar, and make sure to use the same email address in the form below. It's that easy!

Please read the rules before posting a comment.

You have 5 comments remaining on this post.

Archives