Graph and download economic data for All-Transactions House Price Index for San Francisco-San Mateo-Redwood City, CA (MSAD) (ATNHPIUS41884Q) from Q3 1975 to Q2 2025 about San Francisco, appraisers, CA, HPI, housing, price index, indexes, price, and USA.

Graph and download economic data for S&P CoreLogic Case-Shiller CA-San Francisco Home Price Index (SFXRNSA) from Jan 1987 to Jun 2025 about San Francisco, CA, HPI, housing, price index, indexes, price, and USA.

The S&P Case Shiller San Francisco Home Price Index measures changes in the prices of existing single-family homes in San Francisco. The index value was equal to 100 as of January 2000, so if the index value is equal to *** in a given month, for example, it means that the house prices have increased by ** percent since 2000. The value of the S&P Case Shiller San Francisco Home Price Index amounted to nearly ****** in August 2024. That was significantly higher than the national average.

In 2022, San Mateo, San Francisco, and Santa Clara were the most expensive districts for housing in the San Francisco Bay Area. In San Francisco, the average square footage price of single-family homes exceeded 1,000 U.S. dollars per square foot. Housing in Solano, on the other hand, was most affordable, with the average square footage price for single family homes at *** U.S. dollars.

How expensive is buying a home in San Francisco? Few metros in the U.S. are more expensive than San Francisco, CA. In 2022, the median sales price of existing single-family homes in San Francisco was about *** million U.S. dollars, making it the second priciest market in the U.S. House prices in the Golden City, were not always so high: in 2014, a two-bedroom house in the Bay Area would sell for less than ******* U.S. dollars but since then, the median price has more than doubled.

How much does renting an apartment cost? Despite rents falling in 2020, renting in San Francisco is still far from cheap. Renting a two-bedroom apartment cost close to ***** U.S. dollars in 2021. California is one of the least affordable states for renters. In fact, to afford to rent such an apartment, a household needs approximately ***** full time jobs at minimum wage or *** full time jobs at mean wage.

VITAL SIGNS INDICATOR Home Prices (EC7)

FULL MEASURE NAME Home Prices

LAST UPDATED August 2019

DESCRIPTION Home prices refer to the cost of purchasing one’s own house or condominium. While a significant share of residents may choose to rent, home prices represent a primary driver of housing affordability in a given region, county or city.

DATA SOURCE Zillow Median Sale Price (1997-2018) http://www.zillow.com/research/data/

Bureau of Labor Statistics: Consumer Price Index All Urban Consumers Data Table (1997-2018; specific to each metro area) http://data.bls.gov

CONTACT INFORMATION vitalsigns.info@bayareametro.gov

METHODOLOGY NOTES (across all datasets for this indicator) Median housing price estimates for the region, counties, cities, and zip code come from analysis of individual home sales by Zillow. The median sale price is the price separating the higher half of the sales from the lower half. In other words, 50 percent of home sales are below or above the median value. Zillow defines all homes as single-family residential, condominium, and co-operative homes with a county record. Single-family residences are detached, which means the home is an individual structure with its own lot. Condominiums are units that you own in a multi-unit complex, such as an apartment building. Co-operative homes are slightly different from condominiums where the homeowners own shares in the corporation that owns the building, not the actual units themselves.

For metropolitan area comparison values, the Bay Area metro area’s median home sale price is the population-weighted average of the nine counties’ median home prices. Home sales prices are not reliably available for Houston, because Texas is a non-disclosure state. For more information on non-disclosure states, see: http://www.zillow.com/blog/chronicles-of-data-collection-ii-non-disclosure-states-3783/

Inflation-adjusted data are presented to illustrate how home prices have grown relative to overall price increases; that said, the use of the Consumer Price Index does create some challenges given the fact that housing represents a major chunk of consumer goods bundle used to calculate CPI. This reflects a methodological tradeoff between precision and accuracy and is a common concern when working with any commodity that is a major component of CPI itself.

VITAL SIGNS INDICATOR
Home Prices (EC7)

FULL MEASURE NAME
Home Prices

LAST UPDATED
December 2022

DESCRIPTION
Home prices refer to the cost of purchasing one’s own house or condominium. While a significant share of residents may choose to rent, home prices represent a primary driver of housing affordability in a given region, county or city.

DATA SOURCE
Zillow: Zillow Home Value Index (ZHVI) - http://www.zillow.com/research/data/
2000-2021

California Department of Finance: E-4 Historical Population Estimates for Cities, Counties, and the State - https://dof.ca.gov/forecasting/demographics/estimates/
2000-2021

US Census Population and Housing Unit Estimates - https://www.census.gov/programs-surveys/popest.html
2000-2021

Bureau of Labor Statistics: Consumer Price Index - http://data.bls.gov
2000-2021

US Census ZIP Code Tabulation Areas (ZCTAs) - https://www.census.gov/programs-surveys/geography/guidance/geo-areas/zctas.html
2020 Census Blocks

CONTACT INFORMATION
vitalsigns.info@bayareametro.gov

METHODOLOGY NOTES (across all datasets for this indicator)
Housing price estimates at the regional-, county-, city- and zip code-level come from analysis of individual home sales by Zillow based upon transaction records. Zillow Home Value Index (ZHVI) is a smoothed, seasonally adjusted measure of the typical home value and market changes across a given region and housing type. It reflects the typical value for homes in the 35th to 65th percentile range. ZHVI is computed from public record transaction data as reported by counties. All standard real estate transactions are included in this metric, including REO sales and auctions. Zillow makes a substantial effort to remove transactions not typically considered a standard sale. Examples of these include bank takeovers of foreclosed properties, title transfers after a death or divorce and non arms-length transactions. Zillow defines all homes as single-family residential, condominium and co-operative homes with a county record. Single-family residences are detached, which means the home is an individual structure with its own lot. Condominiums are units that can be owned in a multi-unit complex, such as an apartment building. Co-operative homes are slightly different from condominiums in that the homeowners own shares in the corporation that owns the building, not the actual units themselves.

For metropolitan area comparison values, the Bay Area metro area’s median home sale price is the population-weighted average of the nine counties’ median home prices. Data is adjusted for inflation using Bureau of Labor Statistics metropolitan statistical area (MSA)-specific series. Inflation-adjusted data are presented to illustrate how home prices have grown relative to overall price increases; that said, the use of the Consumer Price Index (CPI) does create some challenges given the fact that housing represents a major chunk of consumer goods bundle used to calculate CPI. This reflects a methodological tradeoff between precision and accuracy and is a common concern when working with any commodity that is a major component of the CPI itself.

Graph and download economic data for Home Price Index (High Tier) for San Francisco, California (SFXRHTNSA) from Jan 1987 to Jun 2025 about high tier, San Francisco, HPI, housing, price index, indexes, price, and USA.

Graph and download economic data for All-Transactions House Price Index for San Jose-Sunnyvale-Santa Clara, CA (MSA) (ATNHPIUS41940Q) from Q3 1975 to Q2 2025 about San Jose, appraisers, CA, HPI, housing, price index, indexes, price, and USA.

VITAL SIGNS INDICATOR Home Prices (EC7)

FULL MEASURE NAME Home Prices

LAST UPDATED August 2019

DESCRIPTION Home prices refer to the cost of purchasing one’s own house or condominium. While a significant share of residents may choose to rent, home prices represent a primary driver of housing affordability in a given region, county or city.

DATA SOURCE Zillow Median Sale Price (1997-2018) http://www.zillow.com/research/data/

Bureau of Labor Statistics: Consumer Price Index All Urban Consumers Data Table (1997-2018; specific to each metro area) http://data.bls.gov

CONTACT INFORMATION vitalsigns.info@bayareametro.gov

METHODOLOGY NOTES (across all datasets for this indicator) Median housing price estimates for the region, counties, cities, and zip code come from analysis of individual home sales by Zillow. The median sale price is the price separating the higher half of the sales from the lower half. In other words, 50 percent of home sales are below or above the median value. Zillow defines all homes as single-family residential, condominium, and co-operative homes with a county record. Single-family residences are detached, which means the home is an individual structure with its own lot. Condominiums are units that you own in a multi-unit complex, such as an apartment building. Co-operative homes are slightly different from condominiums where the homeowners own shares in the corporation that owns the building, not the actual units themselves.

For metropolitan area comparison values, the Bay Area metro area’s median home sale price is the population-weighted average of the nine counties’ median home prices. Home sales prices are not reliably available for Houston, because Texas is a non-disclosure state. For more information on non-disclosure states, see: http://www.zillow.com/blog/chronicles-of-data-collection-ii-non-disclosure-states-3783/

Inflation-adjusted data are presented to illustrate how home prices have grown relative to overall price increases; that said, the use of the Consumer Price Index does create some challenges given the fact that housing represents a major chunk of consumer goods bundle used to calculate CPI. This reflects a methodological tradeoff between precision and accuracy and is a common concern when working with any commodity that is a major component of CPI itself.

The median price for *********** houses in San Francisco decreased in 2023, while in the Bay Area it slightly rose. In 2023, the median price for a *********** house in the Bay Area was *** million U.S. dollars, whereas in San Francisco, it was *** million U.S. dollars.

Graph and download economic data for Housing Inventory: Median Listing Price in San Francisco-Oakland-Hayward, CA (CBSA) (MEDLISPRI41860) from Jul 2016 to Jul 2025 about San Francisco, CA, listing, median, price, and USA.

VITAL SIGNS INDICATOR
Home Prices (EC7)

FULL MEASURE NAME
Home Prices

LAST UPDATED
December 2022

DESCRIPTION
Home prices refer to the cost of purchasing one’s own house or condominium. While a significant share of residents may choose to rent, home prices represent a primary driver of housing affordability in a given region, county or city.

DATA SOURCE
Zillow: Zillow Home Value Index (ZHVI) - http://www.zillow.com/research/data/
2000-2021

California Department of Finance: E-4 Historical Population Estimates for Cities, Counties, and the State - https://dof.ca.gov/forecasting/demographics/estimates/
2000-2021

US Census Population and Housing Unit Estimates - https://www.census.gov/programs-surveys/popest.html
2000-2021

Bureau of Labor Statistics: Consumer Price Index - http://data.bls.gov
2000-2021

US Census ZIP Code Tabulation Areas (ZCTAs) - https://www.census.gov/programs-surveys/geography/guidance/geo-areas/zctas.html
2020 Census Blocks

CONTACT INFORMATION
vitalsigns.info@bayareametro.gov

METHODOLOGY NOTES (across all datasets for this indicator)
Housing price estimates at the regional-, county-, city- and zip code-level come from analysis of individual home sales by Zillow based upon transaction records. Zillow Home Value Index (ZHVI) is a smoothed, seasonally adjusted measure of the typical home value and market changes across a given region and housing type. It reflects the typical value for homes in the 35th to 65th percentile range. ZHVI is computed from public record transaction data as reported by counties. All standard real estate transactions are included in this metric, including REO sales and auctions. Zillow makes a substantial effort to remove transactions not typically considered a standard sale. Examples of these include bank takeovers of foreclosed properties, title transfers after a death or divorce and non arms-length transactions. Zillow defines all homes as single-family residential, condominium and co-operative homes with a county record. Single-family residences are detached, which means the home is an individual structure with its own lot. Condominiums are units that can be owned in a multi-unit complex, such as an apartment building. Co-operative homes are slightly different from condominiums in that the homeowners own shares in the corporation that owns the building, not the actual units themselves.

For metropolitan area comparison values, the Bay Area metro area’s median home sale price is the population-weighted average of the nine counties’ median home prices. Data is adjusted for inflation using Bureau of Labor Statistics metropolitan statistical area (MSA)-specific series. Inflation-adjusted data are presented to illustrate how home prices have grown relative to overall price increases; that said, the use of the Consumer Price Index (CPI) does create some challenges given the fact that housing represents a major chunk of consumer goods bundle used to calculate CPI. This reflects a methodological tradeoff between precision and accuracy and is a common concern when working with any commodity that is a major component of the CPI itself.

VITAL SIGNS INDICATOR List Rents (EC9)

FULL MEASURE NAME List Rents

LAST UPDATED October 2016

DESCRIPTION List rent refers to the advertised rents for available rental housing and serves as a measure of housing costs for new households moving into a neighborhood, city, county or region.

DATA SOURCE real Answers (1994 – 2015) no link

Zillow Metro Median Listing Price All Homes (2010-2016) http://www.zillow.com/research/data/

CONTACT INFORMATION vitalsigns.info@mtc.ca.gov

METHODOLOGY NOTES (across all datasets for this indicator) List rents data reflects median rent prices advertised for available apartments rather than median rent payments; more information is available in the indicator definition above. Regional and local geographies rely on data collected by real Answers, a research organization and database publisher specializing in the multifamily housing market. real Answers focuses on collecting longitudinal data for individual rental properties through quarterly surveys. For the Bay Area, their database is comprised of properties with 40 to 3,000+ housing units. Median list prices most likely have an upward bias due to the exclusion of smaller properties. The bias may be most extreme in geographies where large rental properties represent a small portion of the overall rental market. A map of the individual properties surveyed is included in the Local Focus section.

Individual properties surveyed provided lower- and upper-bound ranges for the various types of housing available (studio, 1 bedroom, 2 bedroom, etc.). Median lower- and upper-bound prices are determined across all housing types for the regional and county geographies. The median list price represented in Vital Signs is the average of the median lower- and upper-bound prices for the region and counties. Median upper-bound prices are determined across all housing types for the city geographies. The median list price represented in Vital Signs is the median upper-bound price for cities. For simplicity, only the mean list rent is displayed for the individual properties. The metro areas geography rely upon Zillow data, which is the median price for rentals listed through www.zillow.com during the month. Like the real Answers data, Zillow's median list prices most likely have an upward bias since small properties are underrepresented in Zillow's listings. The metro area data for the Bay Area cannot be compared to the regional Bay Area data. Due to afore mentioned data limitations, this data is suitable for analyzing the change in list rents over time but not necessarily comparisons of absolute list rents. Metro area boundaries reflects today’s metro area definitions by county for consistency, rather than historical metro area boundaries.

Due to the limited number of rental properties surveyed, city-level data is unavailable for Atherton, Belvedere, Brisbane, Calistoga, Clayton, Cloverdale, Cotati, Fairfax, Half Moon Bay, Healdsburg, Hillsborough, Los Altos Hills, Monte Sereno, Moranga, Oakley, Orinda, Portola Valley, Rio Vista, Ross, San Anselmo, San Carlos, Saratoga, Sebastopol, Windsor, Woodside, and Yountville.

Inflation-adjusted data are presented to illustrate how rents have grown relative to overall price increases; that said, the use of the Consumer Price Index does create some challenges given the fact that housing represents a major chunk of consumer goods bundle used to calculate CPI. This reflects a methodological tradeoff between precision and accuracy and is a common concern when working with any commodity that is a major component of CPI itself. Percent change in inflation-adjusted median is calculated with respect to the median price from the fourth quarter or December of the base year.

The San Francisco Bay Area was the only area where single-family homes sold above the list price in October 2024. In that month, buyers paid on average one percent above the list price for single-family houses. Condos, on the other hand, sold for *** percent of the list price. As a result of the robust demand for California properties, property prices increased in the past year.

Graph and download economic data for All-Transactions House Price Index for Oakland-Berkeley-Livermore, CA (MSAD) (ATNHPIUS36084Q) from Q2 1975 to Q2 2025 about Oakland, appraisers, CA, HPI, housing, price index, indexes, price, and USA.

All-Transactions House Price Index for San Jose-Sunnyvale-Santa Clara, CA (MSA) was 558.45000 Index 1995 Q1=100 in January of 2025, according to the United States Federal Reserve. Historically, All-Transactions House Price Index for San Jose-Sunnyvale-Santa Clara, CA (MSA) reached a record high of 567.08000 in July of 2024 and a record low of 18.68000 in July of 1975. Trading Economics provides the current actual value, an historical data chart and related indicators for All-Transactions House Price Index for San Jose-Sunnyvale-Santa Clara, CA (MSA) - last updated from the United States Federal Reserve on September of 2025.

New housing price index (NHPI). Monthly data are available from January 1981. The table presents data for the most recent reference period and the last four periods. The base period for the index is (201612=100).

In October 2024, the median square footage sales price of a single-family home in the San Francisco Bay Area was approximately *** U.S. dollars. Condos, on the other hand, sold for *** U.S. dollars per square foot. The Far North was the most affordable region with sales price of *** and *** U.S. dollars for single family homes and condos, respectively.

Graph and download economic data for Condo Price Index for San Francisco, California (SFXRCSA) from Jan 1995 to Jun 2025 about San Francisco, HPI, housing, price index, indexes, price, and USA.

Source

This is the dataset used in this book: https://github.com/ageron/handson-ml/tree/master/datasets/housing to illustrate a sample end-to-end ML project workflow (pipeline). This is a great book - I highly recommend!

The data is based on California Census in 1990.

About the Data (from the book):

"This dataset is a modified version of the California Housing dataset available from Luís Torgo's page (University of Porto). Luís Torgo obtained it from the StatLib repository (which is closed now). The dataset may also be downloaded from StatLib mirrors.

The following is the description from the book author:

This dataset appeared in a 1997 paper titled Sparse Spatial Autoregressions by Pace, R. Kelley and Ronald Barry, published in the Statistics and Probability Letters journal. They built it using the 1990 California census data. It contains one row per census block group. A block group is the smallest geographical unit for which the U.S. Census Bureau publishes sample data (a block group typically has a population of 600 to 3,000 people).

The dataset in this directory is almost identical to the original, with two differences: 207 values were randomly removed from the total_bedrooms column, so we can discuss what to do with missing data. An additional categorical attribute called ocean_proximity was added, indicating (very roughly) whether each block group is near the ocean, near the Bay area, inland or on an island. This allows discussing what to do with categorical data. Note that the block groups are called "districts" in the Jupyter notebooks, simply because in some contexts the name "block group" was confusing."

About the Data (From Luís Torgo page):

http://www.dcc.fc.up.pt/%7Eltorgo/Regression/cal_housing.html

This is a dataset obtained from the StatLib repository. Here is the included description:

"We collected information on the variables using all the block groups in California from the 1990 Cens us. In this sample a block group on average includes 1425.5 individuals living in a geographically co mpact area. Naturally, the geographical area included varies inversely with the population density. W e computed distances among the centroids of each block group as measured in latitude and longitude. W e excluded all the block groups reporting zero entries for the independent and dependent variables. T he final data contained 20,640 observations on 9 variables. The dependent variable is ln(median house value)."

End-to-End ML Project Steps (Chapter 2 of the book)

1. Look at the big picture
2. Get the data
3. Discover and visualize the data to gain insights
4. Prepare the data for Machine Learning algorithms
5. Select a model and train it
6. Fine-tune your model
7. Present your solution
8. Launch, monitor, and maintain your system

The 10-Step Machine Learning Project Workflow (My Version)

1. Define business object
2. Make sense of the data from a high level
   • data types (number, text, object, etc.)
   • continuous/discrete
   • basic stats (min, max, std, median, etc.) using boxplot
   • frequency via histogram
   • scales and distributions of different features
3. Create the traning and test sets using proper sampling methods, e.g., random vs. stratified
4. Correlation analysis (pair-wise and attribute combinations)
5. Data cleaning (missing data, outliers, data errors)
6. Data transformation via pipelines (categorical text to number using one hot encoding, feature scaling via normalization/standardization, feature combinations)
7. Train and cross validate different models and select the most promising one (Linear Regression, Decision Tree, and Random Forest were tried in this tutorial)
8. Fine tune the model using trying different combinations of hyperparameters
9. Evaluate the model with best estimators in the test set
10. Launch, monitor, and refresh the model and system