Redfin is a real estate brokerage and publishes the US housing market data on a regular basis. Using this dataset, you can analyze and visualize housing market data for US cities. Timeline: Starting from February 2012 until the present time (Data is refreshed and updated on a monthly basis)

The dataset has the following columns: - period_begin - period_end - period_duration
- region_type
- region_type_id - table_id - is_seasonally_adjusted. (indicates if prices are seasonally adjusted; f represents False) - region - city - state - state_code - property_type - property_type_id - median_sale_price
- median_sale_price_mom (median sale price changes month over month) - median_sale_price_yoy (median sale price changes year over year) - median_list_price
- median_list_price_mom (median list price changes month over month) - median_list_price_yoy (median list price changes year over year) - median_ppsf (median sale price per square foot) - median_ppsf_mom (median sale price per square foot changes month over month) - median_ppsf_yoy (median sale price per square foot changes year over year) - median_list_ppsf (median list price per square foot) - median_list_ppsf_mom (median list price per square foot changes month over month) - median_list_ppsf_yoy. (median list price per square foot changes year over year) - homes_sold (number of homes sold) - homes_sold_mom (number of homes sold month over month) - homes_sold_yoy (number of homes sold year over year) - pending_sales
- pending_sales_mom
- pending_sales_yoy
- new_listings - new_listings_mom
- new_listings_yoy
- inventory - inventory_mom
- inventory_yoy
- months_of_supply
- months_of_supply_mom - months_of_supply_yoy
- median_dom (median days on market until property is sold) - median_dom_mom (median days on market changes month over month) - median_dom_yoy (median days on market changes year over year) - avg_sale_to_list (average sale price to list price ratio) - avg_sale_to_list_mom (average sale price to list price ratio changes month over month) - avg_sale_to_list_yoy (average sale price to list price ratio changes year over year) - sold_above_list
- sold_above_list_mom - sold_above_list_yoy - price_drops - price_drops_mom - price_drops_yoy - off_market_in_two_weeks (number of properties that will be taken off the market within 2 weeks) - off_market_in_two_weeks_mom (changes in number of properties that will be taken off the market within 2 weeks, month over month) - off_market_in_two_weeks_yoy (changes in number of properties that will be taken off the market within 2 weeks, year over year) - parent_metro_region - parent_metro_region_metro_code - last_updated

Filetype: gzip (gz) Support for gzip files in Python: https://docs.python.org/3/library/gzip.html

Data Source & Credit: Redfin.com

A dataset comprising various variables around housing and demographics for the top 50 American cities by population.

Variables:

Zip Code: Zip code within which the listing is present.

Price: Listed price for the property.

Beds: Number of beds mentioned in the listing.

Baths: Number of baths mentioned in the listing.

Living Space: The total size of the living space, in square feet, mentioned in the listing.

Address: Street address of the listing.

City: City name where the listing is located.

State: State name where the listing is located.

Zip Code Population: The estimated number of individuals within the zip code. Data from Simplemaps.com.

Zip Code Density: The estimated number of individuals per square mile within the zip code. Data from Simplemaps.com.

County: County where the listing is located.

Median Household income: Estimated median household income. Data from the U.S. Census Bureau.

Latitude: Latitude of the zip code. ** Data from Simplemaps.com.**

Longitude: Longitude of the zip code. Data from Simplemaps.com.

The year-end value of the S&P Case Shiller National Home Price Index amounted to 321.45 in 2024. The index value was equal to 100 as of January 2000, so if the index value is equal to 130 in a given year, for example, it means that the house prices increased by 30 percent since 2000. S&P/Case Shiller U.S. home indices – additional informationThe S&P Case Shiller National Home Price Index is calculated on a monthly basis and is based on the prices of single-family homes in nine U.S. Census divisions: New England, Middle Atlantic, East North Central, West North Central, South Atlantic, East South Central, West South Central, Mountain and Pacific. The index is the leading indicator of the American housing market and one of the indicators of the state of the broader economy. The index illustrates the trend of home prices and can be helpful during house purchase decisions. When house prices are rising, a house buyer might want to speed up the house purchase decision as the transaction costs can be much higher in the future. The S&P Case Shiller National Home Price Index has been on the rise since 2011.The S&P Case Shiller National Home Price Index is one of the indices included in the S&P/Case-Shiller Home Price Index Series. Other indices are the S&P/Case Shiller 20-City Composite Home Price Index, the S&P/Case Shiller 10-City Composite Home Price Index and twenty city composite indices.

Graph and download economic data for Median Sales Price of Houses Sold for the United States (MSPUS) from Q1 1963 to Q2 2025 about sales, median, housing, and USA.

The median sales price of the existing privately owned single-family homes in the United States increased slightly in 2024. The most expensive homes were found in San Jose-Sunnyvale-Santa Clara, CA, where the median sales price was *** million U.S. dollars. Hawaii and Delaware experienced the strongest home appreciation.

Median Home Sale Price: All Residential: Alexander City, AL data was reported at 170.000 USD th in Jul 2020. This records an increase from the previous number of 114.000 USD th for Jun 2020. Median Home Sale Price: All Residential: Alexander City, AL data is updated monthly, averaging 117.500 USD th from Mar 2012 (Median) to Jul 2020, with 58 observations. The data reached an all-time high of 410.000 USD th in Aug 2012 and a record low of 7.000 USD th in Mar 2014. Median Home Sale Price: All Residential: Alexander City, AL data remains active status in CEIC and is reported by Redfin. The data is categorized under Global Database’s United States – Table US.EB056: Median Home Sale Price: by Metropolitan Areas.

Graph and download economic data for Average Sales Price of Houses Sold for the United States (ASPUS) from Q1 1963 to Q2 2025 about sales, housing, and USA.

Median Home Sale Price: All Residential: Bend, OR data was reported at 470.000 USD th in Jul 2020. This records an increase from the previous number of 430.000 USD th for Jun 2020. Median Home Sale Price: All Residential: Bend, OR data is updated monthly, averaging 331.000 USD th from Feb 2012 (Median) to Jul 2020, with 102 observations. The data reached an all-time high of 470.000 USD th in Jul 2020 and a record low of 170.000 USD th in Mar 2012. Median Home Sale Price: All Residential: Bend, OR data remains active status in CEIC and is reported by Redfin. The data is categorized under Global Database’s United States – Table US.EB056: Median Home Sale Price: by Metropolitan Areas.

Median Home Sale Price: All Residential: Bridgeport, CT data was reported at 493.000 USD th in Jul 2020. This records an increase from the previous number of 485.000 USD th for Jun 2020. Median Home Sale Price: All Residential: Bridgeport, CT data is updated monthly, averaging 385.000 USD th from Feb 2015 (Median) to Jul 2020, with 66 observations. The data reached an all-time high of 493.000 USD th in Jul 2020 and a record low of 336.000 USD th in Feb 2019. Median Home Sale Price: All Residential: Bridgeport, CT data remains active status in CEIC and is reported by Redfin. The data is categorized under Global Database’s United States – Table US.EB056: Median Home Sale Price: by Metropolitan Areas.

The consumer price of housing in urban areas of the United States increased by over four percent in 2024. 2022 and 2023 saw the largest price increases on a year-over-year basis since 2000. Meanwhile, 2010 was the only year in which housing prices decreased. One of the main reasons for that may have been the subprime mortgage crisis of 2007. During that period, the value of new residential construction put in place in the U.S. stagnated.

This dataset from Zillow contains a smoothed, seasonally adjusted measure of the typical home value and market changes across across various regions in the United States from January 2000 to August 2022. The data includes monthly observations for hundreds of cities and states, offering insights into regional housing market trends over two decades.

This dataset comes from Zillow and provides a comprehensive look at U.S. housing market trends from 2018 to May 2024. It includes detailed data on median home values, average days outstanding for property sales, and their impact on reducing prices in several cities. This dataset is ideal for analyzing the correlation between home values, time to market, and price adjustments, offering valuable insights for real estate professionals, economists, and data analysts interested in the dynamics of the U.S. housing market.

About the license, taken from the Zillow website:

“For research and academic projects, we provide the following metrics that have more flexible Terms of Use regarding data storage and manipulation – https://www.zillow.com/research/data/”

Home prices in the U.S. reach new heights The American housing market continues to show remarkable resilience, with the S&P/Case Shiller U.S. National Home Price Index reaching an all-time high of 331.69 in June 2025. This figure represents a significant increase from the index value of 166.23 recorded in January 2015, highlighting the substantial growth in home prices over the past decade. The S&P Case Shiller National Home Price Index is based on the prices of single-family homes and is the leading indicator of the American housing market and one of the indicators of the state of the broader economy. The S&P Case Shiller National Home Price Index series also includes S&P/Case Shiller 20-City Composite Home Price Index and S&P/Case Shiller 10-City Composite Home Price Index – measuring the home price changes in the major U.S. metropolitan areas, as well as twenty composite indices for the leading U.S. cities. Market fluctuations and recovery Despite the overall upward trend, the housing market has experienced some fluctuations in recent years. During the housing boom in 2021, the number of existing home sales reached the highest level since 2006. However, transaction volumes quickly plummeted, as the soaring interest rates and out-of-reach prices led to housing sentiment deteriorating. Factors influencing home prices Several factors have contributed to the rise in home prices, including a chronic supply shortage, the gradual decline in interest rates, and the spike in demand during the COVID-19 pandemic. During the subprime mortgage crisis (2007-2010), the construction of new homes declined dramatically. Although it has gradually increased since then, the number of new building permits, home starts, and completions are still shy from the levels before the crisis. With demand outweighing supply, competition for homes can be fierce, leading to bidding wars and soaring prices. The supply of existing homes is further constrained, as homeowners are less likely to sell and move homes due to the worsened lending conditions.

Portugal, Canada, and the United States were the countries with the highest house price to income ratio in 2024. In all three countries, the index exceeded 130 index points, while the average for all OECD countries stood at 116.2 index points. The index measures the development of housing affordability and is calculated by dividing nominal house price by nominal disposable income per head, with 2015 set as a base year when the index amounted to 100. An index value of 120, for example, would mean that house price growth has outpaced income growth by 20 percent since 2015. How have house prices worldwide changed since the COVID-19 pandemic? House prices started to rise gradually after the global financial crisis (2007–2008), but this trend accelerated with the pandemic. The countries with advanced economies, which usually have mature housing markets, experienced stronger growth than countries with emerging economies. Real house price growth (accounting for inflation) peaked in 2022 and has since lost some of the gain. Although, many countries experienced a decline in house prices, the global house price index shows that property prices in 2023 were still substantially higher than before COVID-19. Renting vs. buying In the past, house prices have grown faster than rents. However, the home affordability has been declining notably, with a direct impact on rental prices. As people struggle to buy a property of their own, they often turn to rental accommodation. This has resulted in a growing demand for rental apartments and soaring rental prices.

Graph and download economic data for Consumer Price Index for All Urban Consumers: Housing in U.S. City Average (CPIHOSNS) from Jan 1967 to Sep 2025 about urban, consumer, CPI, housing, inflation, price index, indexes, price, and USA.

Median Home Sale Price: All Residential: Crossville, TN data was reported at 201.000 USD th in Jul 2020. This records an increase from the previous number of 180.000 USD th for Jun 2020. Median Home Sale Price: All Residential: Crossville, TN data is updated monthly, averaging 146.000 USD th from Feb 2012 (Median) to Jul 2020, with 102 observations. The data reached an all-time high of 201.000 USD th in Jul 2020 and a record low of 97.000 USD th in Feb 2014. Median Home Sale Price: All Residential: Crossville, TN data remains active status in CEIC and is reported by Redfin. The data is categorized under Global Database’s United States – Table US.EB056: Median Home Sale Price: by Metropolitan Areas.

Median Home Sale Price: All Residential: Chico, CA data was reported at 375.000 USD th in Jul 2020. This records an increase from the previous number of 363.000 USD th for Jun 2020. Median Home Sale Price: All Residential: Chico, CA data is updated monthly, averaging 256.500 USD th from Feb 2012 (Median) to Jul 2020, with 102 observations. The data reached an all-time high of 375.000 USD th in Jul 2020 and a record low of 160.000 USD th in May 2012. Median Home Sale Price: All Residential: Chico, CA data remains active status in CEIC and is reported by Redfin. The data is categorized under Global Database’s United States – Table US.EB056: Median Home Sale Price: by Metropolitan Areas.

Case Shiller Home Price Index in the United States decreased to 338.25 points in September from 339.99 points in August of 2025. This dataset provides the latest reported value for - United States S&P Case-Shiller Home Price Index - plus previous releases, historical high and low, short-term forecast and long-term prediction, economic calendar, survey consensus and news.

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.

Los Angeles, San Francisco, and San Jose had the highest share of home listings priced over *********** U.S. dollars among the biggest cities in the United States in 2023. However, considering that the median home price in these cities ranges from *** million to *** thousand U.S. dollars, housing around *********** dollars would not be considered luxurious but that of higher prices. Los Angeles city had the largest share of luxury housing above ************ U.S. dollars of **** percent, followed by New York City with *** percent.