{"id":41613,"date":"2026-06-30T06:27:06","date_gmt":"2026-06-30T04:27:06","guid":{"rendered":"https:\/\/www.graviton.at\/letterswaplibrary\/pulled-together-a-dataset-of-90-sf-homes-currently-for-sale-median-is-1-27m-and-the-range-is-kind-of-insane\/"},"modified":"2026-06-30T06:27:06","modified_gmt":"2026-06-30T04:27:06","slug":"pulled-together-a-dataset-of-90-sf-homes-currently-for-sale-median-is-1-27m-and-the-range-is-kind-of-insane","status":"publish","type":"post","link":"https:\/\/www.graviton.at\/letterswaplibrary\/pulled-together-a-dataset-of-90-sf-homes-currently-for-sale-median-is-1-27m-and-the-range-is-kind-of-insane\/","title":{"rendered":"Pulled Together A Dataset Of ~90 SF Homes Currently For Sale. Median Is $1.27M And The Range Is Kind Of Insane"},"content":{"rendered":"<p><!-- SC_OFF --><\/p>\n<div class=\"md\">\n<p>Was poking at the SF market and put together a clean dataset of homes + condos currently listed: list price, price\/sqft, sqft, beds\/baths, year built, lot size, agent, and the Redfin link for each.<br \/> A few things that jumped out:<br \/> &#8211; Median list price is ~$1.27M, median $980\/sqft<br \/> &#8211; Cheapest thing on the market: a $369k 523-sqft condo at 601 Van Ness<br \/> &#8211; Priciest: a $6.6M unit at 188 Minna \u2014 which works out to $3,256\/sqft lol<br \/> &#8211; Year built ranges from 1884 to 2021, which is very SF<\/p>\n<p>CSV\/XLSX here if anyone wants to take a look at it: <a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/17BhnTFkWtN6cI9Yn9f0BgPcLF6sVEk9T\/edit?usp=sharing&amp;ouid=108885207033845537587&amp;rtpof=true&amp;sd=true\">https:\/\/docs.google.com\/spreadsheets\/d\/17BhnTFkWtN6cI9Yn9f0BgPcLF6sVEk9T\/edit?usp=sharing&amp;ouid=108885207033845537587&amp;rtpof=true&amp;sd=true<\/a><\/p>\n<p>Made it with an open-source tool called Bigset where you basically describe the dataset in a sentence and it goes and pulls + verifies the data from the live web. <\/p>\n<p>Happy to pull a different slice if people want -by neighborhood, condos only, under $1M, whatever.<\/p>\n<\/div>\n<p><!-- SC_ON -->   submitted by   <a href=\"https:\/\/www.reddit.com\/user\/tinys-automation26\"> \/u\/tinys-automation26 <\/a> <br \/> <span><a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/17BhnTFkWtN6cI9Yn9f0BgPcLF6sVEk9T\/edit?usp=sharing&amp;ouid=108885207033845537587&amp;rtpof=true&amp;sd=true\">[link]<\/a><\/span>   <span><a href=\"https:\/\/www.reddit.com\/r\/datasets\/comments\/1ujdybh\/pulled_together_a_dataset_of_90_sf_homes\/\">[comments]<\/a><\/span><\/p><div class='watch-action'><div class='watch-position align-right'><div class='action-like'><a class='lbg-style1 like-41613 jlk' href='javascript:void(0)' data-task='like' data-post_id='41613' data-nonce='9de69db8d5' rel='nofollow'><img class='wti-pixel' src='https:\/\/www.graviton.at\/letterswaplibrary\/wp-content\/plugins\/wti-like-post\/images\/pixel.gif' title='Like' \/><span class='lc-41613 lc'>0<\/span><\/a><\/div><\/div> <div class='status-41613 status align-right'><\/div><\/div><div class='wti-clear'><\/div>","protected":false},"excerpt":{"rendered":"<p>Was poking at the SF market and put together a clean dataset of homes + condos currently&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[85],"tags":[],"class_list":["post-41613","post","type-post","status-publish","format-standard","hentry","category-datatards","wpcat-85-id"],"_links":{"self":[{"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/posts\/41613","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/comments?post=41613"}],"version-history":[{"count":0,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/posts\/41613\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/media?parent=41613"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/categories?post=41613"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/tags?post=41613"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}