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.
A few things that jumped out:
– Median list price is ~$1.27M, median $980/sqft
– Cheapest thing on the market: a $369k 523-sqft condo at 601 Van Ness
– Priciest: a $6.6M unit at 188 Minna — which works out to $3,256/sqft lol
– Year built ranges from 1884 to 2021, which is very SF
CSV/XLSX here if anyone wants to take a look at it: https://docs.google.com/spreadsheets/d/17BhnTFkWtN6cI9Yn9f0BgPcLF6sVEk9T/edit?usp=sharing&ouid=108885207033845537587&rtpof=true&sd=true
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.
Happy to pull a different slice if people want -by neighborhood, condos only, under $1M, whatever.
submitted by /u/tinys-automation26
[link] [comments]
