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.

The average sales price of new homes in the United States experienced a slight decrease in 2024, dropping to 512,2000 U.S. dollars from the peak of 521,500 U.S. dollars in 2022. This decline came after years of substantial price increases, with the average price surpassing 400,000 U.S. dollars for the first time in 2021. The recent cooling in the housing market reflects broader economic trends and changing consumer sentiment towards homeownership. Factors influencing home prices and affordability The rapid rise in home prices over the past few years has been driven by several factors, including historically low mortgage rates and increased demand during the COVID-19 pandemic. However, the market has since slowed down, with the number of home sales declining by over two million between 2021 and 2023. This decline can be attributed to rising mortgage rates and decreased affordability. The Housing Affordability Index hit a record low of 98.1 in 2023, indicating that the median-income family could no longer afford a median-priced home. Future outlook for the housing market Despite the recent cooling, experts forecast a potential recovery in the coming years. The Freddie Mac House Price Index showed a growth of 6.5 percent in 2023, which is still above the long-term average of 4.4 percent since 1990. However, homebuyer sentiment remains low across all age groups, with people aged 45 to 64 expressing the most pessimistic outlook. The median sales price of existing homes is expected to increase slightly until 2025, suggesting that affordability challenges may persist in the near future.

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.

House Price Prediction Dataset.

The dataset contains 2000 rows of house-related data, representing various features that could influence house prices. Below, we discuss key aspects of the dataset, which include its structure, the choice of features, and potential use cases for analysis.

1. Dataset Features

The dataset is designed to capture essential attributes for predicting house prices, including:

Area: Square footage of the house, which is generally one of the most important predictors of price. Bedrooms & Bathrooms: The number of rooms in a house significantly affects its value. Homes with more rooms tend to be priced higher. Floors: The number of floors in a house could indicate a larger, more luxurious home, potentially raising its price. Year Built: The age of the house can affect its condition and value. Newly built houses are generally more expensive than older ones. Location: Houses in desirable locations such as downtown or urban areas tend to be priced higher than those in suburban or rural areas. Condition: The current condition of the house is critical, as well-maintained houses (in 'Excellent' or 'Good' condition) will attract higher prices compared to houses in 'Fair' or 'Poor' condition. Garage: Availability of a garage can increase the price due to added convenience and space. Price: The target variable, representing the sale price of the house, used to train machine learning models to predict house prices based on the other features.

2. Feature Distributions

Area Distribution: The area of the houses in the dataset ranges from 500 to 5000 square feet, which allows analysis across different types of homes, from smaller apartments to larger luxury houses. Bedrooms and Bathrooms: The number of bedrooms varies from 1 to 5, and bathrooms from 1 to 4. This variance enables analysis of homes with different sizes and layouts. Floors: Houses in the dataset have between 1 and 3 floors. This feature could be useful for identifying the influence of multi-level homes on house prices. Year Built: The dataset contains houses built from 1900 to 2023, giving a wide range of house ages to analyze the effects of new vs. older construction. Location: There is a mix of urban, suburban, downtown, and rural locations. Urban and downtown homes may command higher prices due to proximity to amenities. Condition: Houses are labeled as 'Excellent', 'Good', 'Fair', or 'Poor'. This feature helps model the price differences based on the current state of the house. Price Distribution: Prices range between $50,000 and $1,000,000, offering a broad spectrum of property values. This range makes the dataset appropriate for predicting a wide variety of housing prices, from affordable homes to luxury properties.

3. Correlation Between Features

A key area of interest is the relationship between various features and house price: Area and Price: Typically, a strong positive correlation is expected between the size of the house (Area) and its price. Larger homes are likely to be more expensive. Location and Price: Location is another major factor. Houses in urban or downtown areas may show a higher price on average compared to suburban and rural locations. Condition and Price: The condition of the house should show a positive correlation with price. Houses in better condition should be priced higher, as they require less maintenance and repair. Year Built and Price: Newer houses might command a higher price due to better construction standards, modern amenities, and less wear-and-tear, but some older homes in good condition may retain historical value. Garage and Price: A house with a garage may be more expensive than one without, as it provides extra storage or parking space.

4. Potential Use Cases

The dataset is well-suited for various machine learning and data analysis applications, including:

House Price Prediction: Using regression techniques, this dataset can be used to build a model to predict house prices based on the available features. Feature Importance Analysis: By using techniques such as feature importance ranking, data scientists can determine which features (e.g., location, area, or condition) have the greatest impact on house prices. Clustering: Clustering techniques like k-means could help identify patterns in the data, such as grouping houses into segments based on their characteristics (e.g., luxury homes, affordable homes). Market Segmentation: The dataset can be used to perform segmentation by location, price range, or house type to analyze trends in specific sub-markets, like luxury vs. affordable housing. Time-Based Analysis: By studying how house prices vary with the year built or the age of the house, analysts can derive insights into the trends of older vs. newer homes.

5. Limitations and ...

The number of U.S. home sales in the United States declined in 2024, after soaring in 2021. A total of four million transactions of existing homes, including single-family, condo, and co-ops, were completed in 2024, down from 6.12 million in 2021. According to the forecast, the housing market is forecast to head for recovery in 2025, despite transaction volumes expected to remain below the long-term average. Why have home sales declined? The housing boom during the coronavirus pandemic has demonstrated that being a homeowner is still an integral part of the American dream. Nevertheless, sentiment declined in the second half of 2022 and Americans across all generations agreed that the time was not right to buy a home. A combination of factors has led to house prices rocketing and making homeownership unaffordable for the average buyer. A survey among owners and renters found that the high home prices and unfavorable economic conditions were the two main barriers to making a home purchase. People who would like to purchase their own home need to save up a deposit, have a good credit score, and a steady and sufficient income to be approved for a mortgage. In 2022, mortgage rates experienced the most aggressive increase in history, making the total cost of homeownership substantially higher. Are U.S. home prices expected to fall? The median sales price of existing homes stood at 413,000 U.S. dollars in 2024 and was forecast to increase slightly until 2026. The development of the S&P/Case Shiller U.S. National Home Price Index shows that home prices experienced seven consecutive months of decline between June 2022 and January 2023, but this trend reversed in the following months. Despite mild fluctuations throughout the year, home prices in many metros are forecast to continue to grow, albeit at a much slower rate.

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.

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 prices grew year-on-year in most states in the U.S. in the first quarter of 2025. Hawaii was the only exception, with a decline of **** percent. The annual appreciation for single-family housing in the U.S. was **** percent, while in Rhode Island—the state where homes appreciated the most—the increase was ******percent. How have home prices developed in recent years? House price growth in the U.S. has been going strong for years. In 2025, the median sales price of a single-family home exceeded ******* U.S. dollars, up from ******* U.S. dollars five years ago. One of the factors driving house prices was the cost of credit. The record-low federal funds effective rate allowed mortgage lenders to set mortgage interest rates as low as *** percent. With interest rates on the rise, home buying has also slowed, causing fluctuations in house prices. Why are house prices growing? Many markets in the U.S. are overheated because supply has not been able to keep up with demand. How many homes enter the housing market depends on the construction output, whereas the availability of existing homes for purchase depends on many other factors, such as the willingness of owners to sell. Furthermore, growing investor appetite in the housing sector means that prospective homebuyers have some extra competition to worry about. In certain metros, for example, the share of homes bought by investors exceeded ** percent in 2025.

The U.S. housing market has slowed, after ** consecutive years of rising home prices. In 2021, house prices surged by an unprecedented ** percent, marking the highest increase on record. However, the market has since cooled, with the Freddie Mac House Price Index showing more modest growth between 2022 and 2024. In 2024, home prices increased by *** percent. That was lower than the long-term average of *** percent since 1990. Impact of mortgage rates on homebuying The recent cooling in the housing market can be partly attributed to rising mortgage rates. After reaching a record low of **** percent in 2021, the average annual rate on a 30-year fixed-rate mortgage more than doubled in 2023. This significant increase has made homeownership less affordable for many potential buyers, contributing to a substantial decline in home sales. Despite these challenges, forecasts suggest a potential recovery in the coming years. How much does it cost to buy a house in the U.S.? In 2023, the median sales price of an existing single-family home reached a record high of over ******* U.S. dollars. Newly built homes were even pricier, despite a slight decline in the median sales price in 2023. Naturally, home prices continue to vary significantly across the country, with West Virginia being the most affordable state for homebuyers.

Existing Home Sales in the United States increased to 4100 Thousand in October from 4050 Thousand in September of 2025. This dataset provides the latest reported value for - United States Existing Home Sales - plus previous releases, historical high and low, short-term forecast and long-term prediction, economic calendar, survey consensus and news.

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

Explore the Redfin USA Properties Dataset, available in CSV format. This extensive dataset provides valuable insights into the U.S. real estate market, including detailed property listings, prices, property types, and more across various states and cities. Perfect for those looking to conduct in-depth market analysis, real estate investment research, or financial forecasting.

Key Features:

• Comprehensive Property Data: Includes essential details such as listing prices, property types, square footage, and the number of bedrooms and bathrooms.
• Geographic Coverage: Encompasses a wide range of U.S. states and cities, providing a broad view of the national real estate market.
• Historical Trends: Analyze past market data to understand price movements, regional differences, and market trends over time.
• Geo-Location Details: Enables spatial analysis and mapping by including precise geographical coordinates of properties.

Who Can Benefit From This Dataset:

• Real Estate Investors: Identify lucrative opportunities by analyzing property values, market trends, and regional price variations.
• Market Analysts: Gain a deeper understanding of the U.S. housing market dynamics to inform research and reporting.
• Data Scientists and Researchers: Leverage detailed real estate data for modeling, urban studies, or economic analysis.
• Financial Analysts: Utilize the dataset for financial modeling, helping to predict market behavior and assess investment risks.

Download the Redfin USA Properties Dataset to access essential information on the U.S. housing market, ideal for professionals in real estate, finance, and data analytics. Unlock key insights to make informed decisions in a dynamic market environment.

Looking for deeper insights or a custom data pull from Redfin?
Send a request with just one click and explore detailed property listings, price trends, and housing data.
🔗 Request Redfin Real Estate Data

The dataset originates from the book "Practical Statistics for Data Scientists" by Peter Bruce, Andrew Bruce, and Peter Gedeck.

Context:

You work for a real estate agency in the King County area, USA, and the company aims to develop a prediction model to estimate house prices based on various characteristics. The goal is to provide accurate estimates that help clients set the right sale or purchase price.

To achieve this, you use a detailed dataset that includes information about past sales, such as sale price, property size, number of bedrooms and bathrooms, as well as specific variables like the year of construction and real estate value indices. You use this data to create a predictive model that analyzes the impact of these factors on house prices in the region.

The objective is to provide a powerful tool for the agency’s real estate agents, allowing them to quickly and accurately estimate house prices and thus help clients make informed decisions.

Content:

The dataset has 22 variables and 22 688 sales.

Key information about House Prices Growth

• US house prices grew 3.3% YoY in Sep 2025, following an increase of 4.1% YoY in the previous quarter.
• YoY growth data is updated quarterly, available from Mar 1992 to Sep 2025, with an average growth rate of -12.4%.
• House price data reached an all-time high of 17.7% in Sep 2021 and a record low of -12.4% in Dec 2008.

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.

House Prices Dataset

Subtitle:

Detailed Real Estate Data for Predicting House Prices and Analyzing Market Trends

Description:

This dataset contains information on 21,613 properties, making it a comprehensive resource for exploring real estate market trends and building predictive models for house prices. The data includes various features capturing property details, location, and market conditions, providing ample opportunities for data exploration, visualization, and machine learning applications.

Key Features:

• General Information:

  • id: Unique identifier for each property.
  • date: Date of sale.

• Price Details:

  • price: Sale price of the house.

• Property Features:

  • bedrooms: Number of bedrooms.
  • bathrooms: Number of bathrooms (including partials as fractions).
  • sqft_living: Living space area in square feet.
  • sqft_lot: Lot size in square feet.
  • floors: Number of floors.
  • waterfront: Whether the property has a waterfront view.
  • view: Quality of the view rating.
  • condition: Overall condition of the house.
  • grade: Grade of construction and design (scale of 1–13).

• Additional Metrics:

  • sqft_above: Square footage of the property above ground.
  • sqft_basement: Basement area in square feet.
  • yr_built: Year the property was built.
  • yr_renovated: Year of last renovation.

• Location Coordinates:

  • zipcode: ZIP code of the property.
  • lat and long: Latitude and longitude coordinates.

• Neighbor Comparisons:

  • sqft_living15: Average living space of 15 nearest properties.
  • sqft_lot15: Average lot size of 15 nearest properties.

Use Cases:

• Predicting house prices using regression models.
• Identifying the impact of various features (e.g., number of bedrooms, location) on property prices.
• Analyzing market trends and spatial distribution of real estate prices.

This dataset is a valuable resource for anyone interested in real estate analytics, machine learning, or geographic data visualization.

Like other Assessor and Recorder data sets from First American, BlackKnight, ATTOM or HouseCanary, we provide both residential real estate and commercial restate data on homes, properties and pracels nationally.

Over 250M parcels, updated daily.

Access detailed property and tax assessment records with our extensive nationwide database. This robust dataset provides comprehensive information about residential and commercial properties, including detailed ownership, valuation, and transaction history. Core Data Elements:

Complete property identification (APNs, Tax IDs) Full property addresses with geocoding Precise latitude/longitude coordinates FIPS codes and Census tract information School district assignments

Property Characteristics:

Detailed lot dimensions and size Building square footage breakdowns Living area measurements Basement and attic specifications Garage and parking information Year built and effective year Number of bedrooms and bathrooms Room counts and configurations Building class and condition codes Construction details and materials Property amenities and features

Valuation Information:

Current AVM (Automated Valuation Model) values Confidence scores and value ranges Market valuations with dates Assessed values (land and improvements) Tax amounts and years Tax rate codes and districts Various tax exemption statuses

Transaction History:

Current and previous sale details Recording dates and document numbers Sale prices and price codes Buyer and seller information Multiple mortgage records including:

Loan amounts and terms Lender information Recording dates Interest rates Due dates Loan types and positions

Ownership Details:

Current owner information Corporate ownership indicators Owner-occupied status Mailing addresses Care of names Foreign address indicators

Legal Information:

Complete legal descriptions Subdivision details Lot and block numbers Zoning information Land use codes HOA information and fees

Property Status Indicators:

Vacancy flags Pre-foreclosure status Current listing status Price ranges Market position

Perfect For:

Real Estate Professionals

Property researchers Title companies Real estate attorneys Appraisers Market analysts

Financial Services

Mortgage lenders Insurance companies Investment firms Risk assessment teams Portfolio managers

Government & Planning

Urban planners Tax assessors Economic developers Policy researchers Municipal agencies

Data Analytics

Market researchers Data scientists Economic analysts GIS specialists Demographics experts

Data Delivery Features:

Multiple format options Regular updates Bulk download capability Custom field selection Geographic filtering API access available Standardized formatting Quality assured data

Quality Assurance:

Verified against public records Regular updates Standardized formatting Address verification Geocoding validation Duplicate removal Data normalization Quality control processes

This comprehensive property database provides unprecedented access to detailed property information, perfect for industry professionals requiring in-depth property data for analysis, research, or business development. Our data undergoes rigorous quality control processes to ensure accuracy and completeness, making it an invaluable resource for real estate professionals, financial institutions, and government agencies. Updated continuously from authoritative sources, this dataset offers the most current and accurate property information available in the market. Custom data extracts and specific geographic coverage options are available to meet your exact needs.

Weekly/Quarterly/Annual and One-time options are available for sale.

See our sample

Purpose and brief description The house price index measures the inflation in the residential property market. The house price index reflects price developments for all residential properties purchased by households (apartments, terraced houses, detached houses), regardless of whether they are new or existing. Only market prices are taken into account, so self-build homes are excluded. The price of the land is included in the price of the properties. Population Real estate transactions involving residential properties Periodicity Quarterly. Release calendar Results available 3 months after the reference period Definitions House price index: The house price index measures changes in the prices of new or existing dwellings, regardless of their use or previous owner. Inflation - house price index: Inflation is defined as the ratio between the value of a given quarter and that of the same quarter of the previous year. Weighting - house price index: Weighting based on the national accounts (gross fixed capital formation in housing) and the total number of real estate transactions involving residential properties. Type of dwelling according to the classification set out in Regulation (EU) No 93/2013 on housing price indices. Technical information The house price index measures the price evolution of real estate prices on the market of private property. The index follows price changes of new or existing residential real estate purchased by households, irrespective of their purpose (letting or owner-occupying). Only market prices are taken into account. Houses built by their owners are therefore not included. The price of the building plot is included in the house price. The house price index is based on real estate transaction data from the General Administration of the Patrimonial Documentation of the FPS Finances. The prices used are those included in the deeds of sale. Given the time between the date on which the preliminary sales agreement is signed and the date on which the deed is executed (between three and four months), this index measures the price evolution with a delay compared to the actual date on which the sales price is set. This delay is inherent to the data source. The house price index is calculated by the European Union Member States, Norway and Iceland. Eurostat calculates the index for the Euro area (as well as for the European Union as a whole) using the harmonised indices of the Member States. Given the role of the housing market in the economic and financial crisis of 2008, the house price index was included in the indicators used in the procedure to prevent and correct macroeconomic imbalances in the European Union. The house price index is calculated under the European Regulation 2016/792 on harmonised indices of consumer prices and the house price index and 2023/1470 laying down the methodological and technical specifications as regards the house price index and the owner-occupied housing price index. Data are available from 2005 onward for Belgium as well as for the European Union and the majority of European countries. The house price index can be broken down by new houses and existing houses. The weights of these two items in the overall index are determined by the gross fixed capital formation in houses (for the new houses) and the total value of transactions of the previous year (for the existing houses). Until 2013, the house price index of new houses was roughly estimated based on the output price index in the construction sector. Since 2014, it is also based on real estate transaction data. House price index for existing houses is available per region since 2010. The data have therefore been completely reviewed when the results for the fourth quarter of 2023 were published in March 2024. Since the houses that are put up for sale differ from one quarter to another, the changes in characteristics are processed with hedonic regression models to eliminate price fluctuations due to changes in characteristics of the properties sold. These models aim to estimate the theoretical price based on the characteristics and location of the houses sold. The index is then calculated based on changes in the average prices observed and adjusted by a factor depending on the differences in quality observed between dwellings sold during the different periods.