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

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.

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.

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.

https://raw.githubusercontent.com/Masterx-AI/Project_Housing_Price_Prediction_/main/hs.jpg" alt="">

Description:

A simple yet challenging project, to predict the housing price based on certain factors like house area, bedrooms, furnished, nearness to mainroad, etc. The dataset is small yet, it's complexity arises due to the fact that it has strong multicollinearity. Can you overcome these obstacles & build a decent predictive model?

Acknowledgement:

Harrison, D. and Rubinfeld, D.L. (1978) Hedonic prices and the demand for clean air. J. Environ. Economics and Management 5, 81–102. Belsley D.A., Kuh, E. and Welsch, R.E. (1980) Regression Diagnostics. Identifying Influential Data and Sources of Collinearity. New York: Wiley.

Objective:

• Understand the Dataset & cleanup (if required).
• Build Regression models to predict the sales w.r.t a single & multiple feature.
• Also evaluate the models & compare thier respective scores like R2, RMSE, etc.

Mexico's housing market demonstrates significant regional price variations, with Mexico City emerging as the most expensive area for residential property in the third quarter of 2025. The capital city's average house price of 3.93 million Mexican pesos far exceeds the national average of 1.86 million pesos, highlighting the stark contrast in property values across the country. This disparity reflects broader economic and demographic trends shaping Mexico's real estate landscape. Sustained growth in housing prices The Mexican housing market has experienced substantial growth over the past decade, with home prices more than doubling since 2010. By the second quarter of 2025, the nominal house price index reached 287 points, representing a 187 percent increase from the baseline year. Even when adjusted for inflation, the real house price index showed a notable 50 percent growth, underscoring the market's resilience and attractiveness to investors. The mortgage market is dominated by three main player types: Infonavit, Fovissste, and commercial banks including Sofomes. In 2023, Infonavit, a scheme by Mexico's National Housing Fund Institute which provides lending to workers in the formal sector, was responsible for the majority of mortgages granted to individuals. Challenges in mortgage lending Despite the overall growth in housing prices, Mexico's mortgage market has faced challenges in recent years. The number of new mortgage loans granted has declined over the past decade, falling by approximately 200,000 loans between 2008 and 2023. This decrease in lending activity may be attributed to various factors, including economic uncertainties and changing consumer preferences. The state of Mexico, which is home to 13 percent of the country's population, likely plays a significant role in shaping these trends given its large demographic influence on the national housing market.

Average House Prices in the United States increased to 534100 USD in August from 478200 USD in July of 2025. This dataset includes a chart with historical data for the United States New Home Average Sales Price.

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.

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 average price of detached and duplex houses in the biggest cities in Germany varied between approximately ***** euros and 10,000 euros per square meter in 2024. Housing was most expensive in Munich, where the square meter price of houses amounted to ***** euros. Conversely, Berlin was most affordable, with the square meter price at ***** euros. How have German house prices evolved? House prices maintained an upward trend for more than a decade, with 2020 and 2021 experiencing exceptionally high growth rates. In 2021, the nominal year-on-year change exceeded 10 percent. Nevertheless, the second half of 2022 saw the market slowing, with the annual percentage change turning negative for the first time in 12 years. Another way to examine the price growth is through the house price index, which uses 2015 as a base. At its peak in 2022, the German house price index measured about *** percent, which means that a house bought in 2015 would have appreciated by ** percent. Is housing affordable in Germany? Housing affordability depends greatly on income: High-income areas often tend to have more expensive housing, which does not necessarily make them unaffordable. The house price to income index measures the development of the cost of housing relative to income. In the first quarter of 2024, the index value stood at ***, meaning that since 2015, house price growth has outpaced income growth by about ** percent. Compared with the average for the euro area, this value was lower.

Average House Price: Mexico City data was reported at 3,087,111.000 MXN in Mar 2019. This records an increase from the previous number of 1,479,381.000 MXN for Dec 2018. Average House Price: Mexico City data is updated quarterly, averaging 1,462,320.000 MXN from Dec 2014 (Median) to Mar 2019, with 18 observations. The data reached an all-time high of 3,087,111.000 MXN in Mar 2019 and a record low of 1,352,679.000 MXN in Dec 2014. Average House Price: Mexico City data remains active status in CEIC and is reported by Federal Mortgage Society. The data is categorized under Global Database’s Mexico – Table MX.EB005: Average House Price.

Graph and download economic data for All-Transactions House Price Index for Baltimore city, MD (ATNHPIUS24510A) from 1975 to 2024 about Baltimore City, MD; Baltimore; MD; HPI; housing; price index; indexes; price; and USA.

The UK housing market continued to show significant regional variations in 2025, with London maintaining its position as the most expensive city for homebuyers. The average house price in the capital stood at ******* British pounds in February, nearly double the national average. However, the market dynamics are shifting, with London experiencing only a modest *** percent annual increase, while other cities like Belfast and Liverpool saw more substantial growth of over **** percent respectively. Affordability challenges and market slowdown Despite the continued price growth in many cities, the UK housing market is facing headwinds. The affordability of mortgage repayments has become the biggest barrier to property purchases, with the majority of the respondents in a recent survey citing it as their main challenge. Moreover, a rising share of Brits have reported affordability as a challenge since 2021, reflecting the impact of rising house prices and higher mortgage rates. The market slowdown is evident in the declining housing transaction volumes, which have plummeted since 2021. European context The stark price differences are mirrored in the broader European context. While London boasts some of the highest property prices among European cities, a comparison of the average transaction price for new homes in different European countries shows a different picture. In 2023, the highest prices were found in Austria, Germany, and France.

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: 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.

View monthly updates and historical trends for US Existing Home Median Sales Price. from United States. Source: National Association of Realtors. Track ec…

Single Family Home Prices in the United States increased to 415200 USD in October from 412300 USD in September of 2025. This dataset provides - United States Existing Single Family Home Prices- actual values, historical data, forecast, chart, statistics, economic calendar and news.

House Price Index YoY in the United States decreased to 1.70 percent in September from 2.40 percent in August of 2025. This dataset includes a chart with historical data for the United States FHFA House Price Index YoY.

Graph and download economic data for All-Transactions House Price Index for Oklahoma City, OK (MSA) (ATNHPIUS36420Q) from Q1 1977 to Q3 2025 about Oklahoma City, OK, appraisers, HPI, housing, price index, indexes, price, and USA.

Median Home Sale Price: All Residential: Alice, TX data was reported at 65.000 USD th in Jun 2020. This records a decrease from the previous number of 193.000 USD th for Apr 2020. Median Home Sale Price: All Residential: Alice, TX data is updated monthly, averaging 126.500 USD th from Jun 2013 (Median) to Jun 2020, with 14 observations. The data reached an all-time high of 276.000 USD th in Nov 2018 and a record low of 20.000 USD th in Sep 2017. Median Home Sale Price: All Residential: Alice, TX 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.