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.

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.

Median price paid for residential property in England and Wales, by property type and administrative geographies. Annual data.

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 square meter price of new residential real estate in Spain was the highest in Catalonia and the Community of Madrid in 2025. In the second quarter of the year, both regions boasted home prices of over 4,800 euros per square meter, with Catalonia at 4,893 euros and the Community of Madrid at 5,037 euros. That was substantially higher than the average for the country, which amounted to 3,151 euros per square meter. Overall, house prices in Spain have been on the rise since 2016.

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

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.

House prices in England have increased notably in the last 10 years, despite a slight decline in 2023. In December 2024, London retained its position as the most expensive regional market, with the average house price at ******* British pounds. According to the UK regional house price index, Northern Ireland saw the highest increase in house prices since 2023.

Median price paid for residential property in England and Wales, for all property types by lower layer super output area. Annual data..

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 All-Transactions House Price Index for San Diego-Chula Vista-Carlsbad, CA (MSA) (ATNHPIUS41740Q) from Q4 1975 to Q2 2025 about San Diego, appraisers, CA, HPI, housing, price index, indexes, price, and USA.

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.

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

Average house prices are derived from data supplied by the mortgage lending agencies on loans approved by them rather than loans paid. In comparing house prices figures from one period to another, account should be taken of the fact that changes in the mix of houses (incl apartments) will affect the average figures. The most current data is published on these sheets. Previously published data may be subject to revision. Any change from the originally published data will be highlighted by a comment on the cell in question. These comments will be maintained for at least a year after the date of the value change. Excluding apartments, measured in € Figure changed on the 27/6/16 as revised data received from the Local authority .hidden { display: none }

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.

This is the unadjusted median house priced for residential property sales (transactions) in the area for a 12 month period with April in the middle (year-ending September). These figures have been produced by the ONS (Office for National Statistics) using the Land Registry (LR) Price Paid data on residential dwelling transactions.

The LR Price Paid data are comprehensive in that they capture changes of ownership for individual residential properties which have sold for full market value and covers both cash sales and those involving a mortgage.

The median is the value determined by putting all the house sales for a given year, area and type in order of price and then selecting the price of the house sale which falls in the middle. The median is less susceptible to distortion by the presence of extreme values than is the mean. It is the most appropriate average to use because it best takes account of the skewed distribution of house prices.

Note that a transaction occurs when a change of freeholder or leaseholder takes place regardless of the amount of money involved and a property can transact more than once in the time period.

The LR records the actual price for which the property changed hands. This will usually be an accurate reflection of the market value for the individual property, but it is not always the case. In order to generate statistics that more accurately reflect market values, the LR has excluded records of houses that were not sold at market value from the dataset. The remaining data are considered a good reflection of market values at the time of the transaction. For full details of exclusions and more information on the methodology used to produce these statistics please see http://www.ons.gov.uk/peoplepopulationandcommunity/housing/qmis/housepricestatisticsforsmallareasqmi

The LR Price Paid data are not adjusted to reflect the mix of houses in a given area. Fluctuations in the types of house that are sold in that area can cause differences between the median transactional value of houses and the overall market value of houses. Therefore these statistics differ to the new UK House Price Index (HPI) which reports mix-adjusted average house prices and house price indices.

If, for a given year, for house type and area there were fewer than 5 sales records in the LR Price Paid data, the house price statistics are not reported. Data is Powered by LG Inform Plus and automatically checked for new data on the 3rd of each month.

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.

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.

House prices in the second most populous state in the United States, Texas, have increased more than two-fold since 2011. In 2023, the median house price reached ******* U.S. dollars, a decrease of *** percent from the previous year. Texas is one of the more affordable states for buying a home with house prices below the national average.