{"id":14142,"date":"2011-01-24T10:25:31","date_gmt":"2011-01-24T18:25:31","guid":{"rendered":"http:\/\/seattlebubble.com\/blog\/?p=14142"},"modified":"2011-01-24T10:37:01","modified_gmt":"2011-01-24T18:37:01","slug":"listings-stale-in-west-seattle-fresh-in-north-seattle","status":"publish","type":"post","link":"https:\/\/seattlebubble.com\/blog\/2011\/01\/24\/listings-stale-in-west-seattle-fresh-in-north-seattle\/","title":{"rendered":"Listings: Stale in West Seattle, Fresh in North Seattle"},"content":{"rendered":"<p>I spent some time this weekend compiling a giant spreadsheet of every active listing in all of King, Snohomish, and Pierce counties, so if you don&#8217;t like the interactive Tableau maps, this probably isn&#8217;t going to be your favorite week.<\/p>\n<p>First up, let&#8217;s have a look at a map of the &#8220;staleness&#8221; of listings.  The map below has a circle for every zip code with at least five listings.  The circles are sized according to the number of listings, and color-coded based on the &#8220;staleness&#8221; of the listings.  This is based on the <em>original<\/em> listing date, not the latest time the agent pulled and re-posted the same house.<\/p>\n<p>Zip codes near the market-wide median of 92 days on the market are grey, above the median is blue, and below the median is red.<\/p>\n<div style=\"width:600px; height:900px; margin:0 auto;\">\n<script type=\"text\/javascript\" src=\"http:\/\/public.tableausoftware.com\/javascripts\/api\/viz_v1.js\"><\/script><object class=\"tableauViz\" width=\"604\" height=\"869\" style=\"display:none;\"><param name=\"name\" value=\"Active-Listings_2011-01-21\/DOM\" \/><param name=\"toolbar\" value=\"yes\" \/><param name=\"tabs\" value=\"no\" \/><\/object><noscript>DOM <br \/><a href=\"http:\/\/seattlebubble.com\/blog\/2011\/01\/24\/listings-stale-in-west-seattle-fresh-in-north-seattle\/\"><img decoding=\"async\" alt=\"DOM \" src=\"http:\/\/public.tableausoftware.com\/static\/images\/Ac\/Active-Listings_2011-01-21\/DOM\/1_rss.png\" height=\"100%\" \/><\/a><\/noscript><\/p>\n<div style=\"width:604px;height:22px;padding:0px 10px 0px 0px; color:black;font:normal 8pt verdana,helvetica,arial,sans-serif;\">\n<div style=\"float:right; padding-right:8px;\"><a href=\"http:\/\/www.tableausoftware.com\/public?ref=http:\/\/public.tableausoftware.com\/views\/Active-Listings_2011-01-21\/DOM\" target=\"_blank\">Powered by Tableau<\/a><\/div>\n<\/div>\n<\/div>\n<p>Here in King County, Medina (98039) has the most stale listings, with the median days on market coming in at 149.  Of the zip codes with over 100 listings, West Seattle (98116) takes the cake with 129 median days on market for its 181 listings.<\/p>\n<p>The freshest listings in King County are in downtown Seattle (98101), at just 54 median days on market.  The north Seattle neighborhoods of Ballard (98107), Fremont\/Greenlake (98103), and U District (98105) all came in well below the median as well, at 55, 74, and 63 respectively.<\/p>\n<p>King and Snohomish County both had a county-wide median days on market of 90, while Pierce was slightly higher at 95.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I spent some time this weekend compiling a giant spreadsheet of every active listing in all of King, Snohomish, and Pierce counties, so if you don&#8217;t like the interactive Tableau maps, this probably isn&#8217;t going to be your favorite week. First up, let&#8217;s have a look at a map of the &#8220;staleness&#8221; of listings. The&#8230;<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[8,217],"tags":[566,481,200,531],"coauthors":[],"class_list":["post-14142","post","type-post","status-publish","format-standard","hentry","category-stats","category-neighborhoods","tag-listings","tag-stale-listings","tag-statistics","tag-tableau"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.2 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Listings: Stale in West Seattle, Fresh in North Seattle \u2022 Seattle Bubble<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/seattlebubble.com\/blog\/2011\/01\/24\/listings-stale-in-west-seattle-fresh-in-north-seattle\/\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Listings: Stale in West Seattle, Fresh in North Seattle \u2022 Seattle Bubble\" \/>\n<meta name=\"twitter:description\" content=\"I spent some time this weekend compiling a giant spreadsheet of every active listing in all of King, Snohomish, and Pierce counties, so if you don&#8217;t like the interactive Tableau maps, this probably isn&#8217;t going to be your favorite week. First up, let&#8217;s have a look at a map of the &#8220;staleness&#8221; of listings. The...\" \/>\n<meta name=\"twitter:image\" content=\"http:\/\/public.tableausoftware.com\/static\/images\/Ac\/Active-Listings_2011-01-21\/DOM\/1_rss.png\" \/>\n<meta name=\"twitter:creator\" content=\"@The_Tim\" \/>\n<meta name=\"twitter:site\" content=\"@SeattleBubble\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"The Tim\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/seattlebubble.com\/blog\/2011\/01\/24\/listings-stale-in-west-seattle-fresh-in-north-seattle\/\",\"url\":\"https:\/\/seattlebubble.com\/blog\/2011\/01\/24\/listings-stale-in-west-seattle-fresh-in-north-seattle\/\",\"name\":\"Listings: Stale in West Seattle, Fresh in North Seattle \u2022 Seattle Bubble\",\"isPartOf\":{\"@id\":\"https:\/\/seattlebubble.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/seattlebubble.com\/blog\/2011\/01\/24\/listings-stale-in-west-seattle-fresh-in-north-seattle\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/seattlebubble.com\/blog\/2011\/01\/24\/listings-stale-in-west-seattle-fresh-in-north-seattle\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/public.tableausoftware.com\/static\/images\/Ac\/Active-Listings_2011-01-21\/DOM\/1_rss.png\",\"datePublished\":\"2011-01-24T18:25:31+00:00\",\"dateModified\":\"2011-01-24T18:37:01+00:00\",\"author\":{\"@id\":\"https:\/\/seattlebubble.com\/blog\/#\/schema\/person\/7de7c0dd14bee1a2c67f7ce86bc4505f\"},\"breadcrumb\":{\"@id\":\"https:\/\/seattlebubble.com\/blog\/2011\/01\/24\/listings-stale-in-west-seattle-fresh-in-north-seattle\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/seattlebubble.com\/blog\/2011\/01\/24\/listings-stale-in-west-seattle-fresh-in-north-seattle\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/seattlebubble.com\/blog\/2011\/01\/24\/listings-stale-in-west-seattle-fresh-in-north-seattle\/#primaryimage\",\"url\":\"http:\/\/public.tableausoftware.com\/static\/images\/Ac\/Active-Listings_2011-01-21\/DOM\/1_rss.png\",\"contentUrl\":\"http:\/\/public.tableausoftware.com\/static\/images\/Ac\/Active-Listings_2011-01-21\/DOM\/1_rss.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/seattlebubble.com\/blog\/2011\/01\/24\/listings-stale-in-west-seattle-fresh-in-north-seattle\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/seattlebubble.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Listings: Stale in West Seattle, Fresh in North Seattle\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/seattlebubble.com\/blog\/#website\",\"url\":\"https:\/\/seattlebubble.com\/blog\/\",\"name\":\"Seattle Bubble\",\"description\":\"local\u00a0real\u00a0estate\u00a0news, statistics,\u00a0and\u00a0commentary without\u00a0the\u00a0sales\u00a0spin.\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/seattlebubble.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/seattlebubble.com\/blog\/#\/schema\/person\/7de7c0dd14bee1a2c67f7ce86bc4505f\",\"name\":\"The Tim\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/seattlebubble.com\/blog\/#\/schema\/person\/image\/37756956c11dcc50d2559761ffa5ee70\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/19e5770990a1681615608091b2de571b10c3e03bbac7d07bb2ae15297ee72fbc?s=96&d=retro&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/19e5770990a1681615608091b2de571b10c3e03bbac7d07bb2ae15297ee72fbc?s=96&d=retro&r=g\",\"caption\":\"The Tim\"},\"description\":\"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. Tim also hosts the weekly improv comedy sci-fi podcast Dispatches from the Multiverse.\",\"sameAs\":[\"http:\/\/SeattleBubble.com\/\",\"http:\/\/facebook.com\/is.totally.pointless\",\"https:\/\/x.com\/The_Tim\"],\"url\":\"https:\/\/seattlebubble.com\/blog\/author\/timothyellis\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Listings: Stale in West Seattle, Fresh in North Seattle \u2022 Seattle Bubble","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/seattlebubble.com\/blog\/2011\/01\/24\/listings-stale-in-west-seattle-fresh-in-north-seattle\/","twitter_card":"summary_large_image","twitter_title":"Listings: Stale in West Seattle, Fresh in North Seattle \u2022 Seattle Bubble","twitter_description":"I spent some time this weekend compiling a giant spreadsheet of every active listing in all of King, Snohomish, and Pierce counties, so if you don&#8217;t like the interactive Tableau maps, this probably isn&#8217;t going to be your favorite week. First up, let&#8217;s have a look at a map of the &#8220;staleness&#8221; of listings. The...","twitter_image":"http:\/\/public.tableausoftware.com\/static\/images\/Ac\/Active-Listings_2011-01-21\/DOM\/1_rss.png","twitter_creator":"@The_Tim","twitter_site":"@SeattleBubble","twitter_misc":{"Written by":"The Tim","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/seattlebubble.com\/blog\/2011\/01\/24\/listings-stale-in-west-seattle-fresh-in-north-seattle\/","url":"https:\/\/seattlebubble.com\/blog\/2011\/01\/24\/listings-stale-in-west-seattle-fresh-in-north-seattle\/","name":"Listings: Stale in West Seattle, Fresh in North Seattle \u2022 Seattle Bubble","isPartOf":{"@id":"https:\/\/seattlebubble.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/seattlebubble.com\/blog\/2011\/01\/24\/listings-stale-in-west-seattle-fresh-in-north-seattle\/#primaryimage"},"image":{"@id":"https:\/\/seattlebubble.com\/blog\/2011\/01\/24\/listings-stale-in-west-seattle-fresh-in-north-seattle\/#primaryimage"},"thumbnailUrl":"http:\/\/public.tableausoftware.com\/static\/images\/Ac\/Active-Listings_2011-01-21\/DOM\/1_rss.png","datePublished":"2011-01-24T18:25:31+00:00","dateModified":"2011-01-24T18:37:01+00:00","author":{"@id":"https:\/\/seattlebubble.com\/blog\/#\/schema\/person\/7de7c0dd14bee1a2c67f7ce86bc4505f"},"breadcrumb":{"@id":"https:\/\/seattlebubble.com\/blog\/2011\/01\/24\/listings-stale-in-west-seattle-fresh-in-north-seattle\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/seattlebubble.com\/blog\/2011\/01\/24\/listings-stale-in-west-seattle-fresh-in-north-seattle\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/seattlebubble.com\/blog\/2011\/01\/24\/listings-stale-in-west-seattle-fresh-in-north-seattle\/#primaryimage","url":"http:\/\/public.tableausoftware.com\/static\/images\/Ac\/Active-Listings_2011-01-21\/DOM\/1_rss.png","contentUrl":"http:\/\/public.tableausoftware.com\/static\/images\/Ac\/Active-Listings_2011-01-21\/DOM\/1_rss.png"},{"@type":"BreadcrumbList","@id":"https:\/\/seattlebubble.com\/blog\/2011\/01\/24\/listings-stale-in-west-seattle-fresh-in-north-seattle\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/seattlebubble.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Listings: Stale in West Seattle, Fresh in North Seattle"}]},{"@type":"WebSite","@id":"https:\/\/seattlebubble.com\/blog\/#website","url":"https:\/\/seattlebubble.com\/blog\/","name":"Seattle Bubble","description":"local\u00a0real\u00a0estate\u00a0news, statistics,\u00a0and\u00a0commentary without\u00a0the\u00a0sales\u00a0spin.","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/seattlebubble.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/seattlebubble.com\/blog\/#\/schema\/person\/7de7c0dd14bee1a2c67f7ce86bc4505f","name":"The Tim","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/seattlebubble.com\/blog\/#\/schema\/person\/image\/37756956c11dcc50d2559761ffa5ee70","url":"https:\/\/secure.gravatar.com\/avatar\/19e5770990a1681615608091b2de571b10c3e03bbac7d07bb2ae15297ee72fbc?s=96&d=retro&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/19e5770990a1681615608091b2de571b10c3e03bbac7d07bb2ae15297ee72fbc?s=96&d=retro&r=g","caption":"The Tim"},"description":"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. Tim also hosts the weekly improv comedy sci-fi podcast Dispatches from the Multiverse.","sameAs":["http:\/\/SeattleBubble.com\/","http:\/\/facebook.com\/is.totally.pointless","https:\/\/x.com\/The_Tim"],"url":"https:\/\/seattlebubble.com\/blog\/author\/timothyellis\/"}]}},"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p6wh0F-3G6","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/seattlebubble.com\/blog\/wp-json\/wp\/v2\/posts\/14142","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/seattlebubble.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/seattlebubble.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/seattlebubble.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/seattlebubble.com\/blog\/wp-json\/wp\/v2\/comments?post=14142"}],"version-history":[{"count":0,"href":"https:\/\/seattlebubble.com\/blog\/wp-json\/wp\/v2\/posts\/14142\/revisions"}],"wp:attachment":[{"href":"https:\/\/seattlebubble.com\/blog\/wp-json\/wp\/v2\/media?parent=14142"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/seattlebubble.com\/blog\/wp-json\/wp\/v2\/categories?post=14142"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/seattlebubble.com\/blog\/wp-json\/wp\/v2\/tags?post=14142"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/seattlebubble.com\/blog\/wp-json\/wp\/v2\/coauthors?post=14142"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}