Mean price paid for residential property in England and Wales, by property type and electoral ward. Annual data.

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.

The average home in the U.S. sold for several percent below its asking price in December 2022, as a result of the housing market slowing. Just a few months before that, In the second quarter of 2022, the so-called sale-to-list price ratio went above ***. This reflected the high housing demand and the need of prospective home buyers to bid above the asking price. Housing demand - as measured in pending home sales - went up, as mortgage rates were historically low and plummeted once rates were increased.

PLEASE UPVOTE IF YOU LIKE THIS CONTENT! 😍

Same dataset as "House Sales in King County, USA", but with treated content and with a split version (train-test) allowing direct use in machine learning models.

We have 14 columns in the dataset, as it follows:

• date: Date of the home sale
• price: Price of each home sold
• bedrooms: Number of bedrooms
• bathrooms: Number of bathrooms
• living_in_m2: Square meters of the apartments interior living space
• nice_view: A flag that indicates the view's quality of a property
• perfect_condition: A flag that indicates the maximum index of the apartment condition
• grade: An index from 1 to 5, where 1 falls short of quality level and 5 have a high quality level of construction and design
• has_basement: A flag indicating whether or not a property has a basement
• renovated: A flag if the property was renovated
• has_lavatory: Check for the presence of these incomplete/secondary bathrooms (bathtub, sink, toilet)
• single_floor: A flag indicating whether the property had only one floor
• month: The month of the home sale
• quartile_zone: A quartile distribution index of the most expensive zip codes, where 1 means less expansive and 4 most expansive.

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.

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.

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

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.

The U.S. housing market continues to evolve, with the median price for existing homes forecast to fall to ******* U.S. dollars by 2027. This projection comes after a period of significant growth and recent fluctuations, reflecting the complex interplay of economic factors affecting the real estate sector. The rising costs have not only impacted home prices but also down payments, with the median down payment more than doubling since 2012. Regional variations in housing costs Home prices and down payments vary dramatically across the United States. While the national median down payment stood at approximately ****** U.S. dollars in early 2024, homebuyers in states like California, Massachusetts, and Hawaii faced down payments exceeding ****** U.S. dollars. This disparity highlights the challenges of homeownership in high-cost markets and underscores the importance of location in determining housing affordability. Market dynamics and future outlook The housing market has shown signs of cooling after years of rapid growth, with a modest price increase of *** percent in 2024. This slowdown can be attributed in part to rising mortgage rates, which have tempered demand. Despite these challenges, most states continued to see year-over-year price growth in 2025, with Rhode Island and West Virginia leading the packby home appreciation. As the market adjusts to new economic realities, potential homebuyers and investors alike will be watching closely for signs of stabilization or renewed growth in the coming years.

The median sales price of new homes sold in the United States increased steadily from 1965 to 2022, followed by two years of decline. In 2024, a newly built home cost approximately ******* U.S. dollars. That was a decline from the peak price of 434,500 U.S. dollars in 2022. Prices varied greatly across different regions in the country, with the most expensive housing found in the Northeast region.

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

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

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.

In 2022, house price growth in the UK slowed, after a period of decade-long increase. Nevertheless, in June 2025, prices reached a new peak, with the average home costing ******* British pounds. This figure refers to all property types, including detached, semi-detached, terraced houses, and flats and maisonettes. Compared to other European countries, the UK had some of the highest house prices. How have UK house prices increased over the last 10 years? Property prices have risen dramatically over the past decade. According to the UK house price index, the average house price has grown by over ** percent since 2015. This price development has led to the gap between the cost of buying and renting a property to close. In 2023, buying a three-bedroom house in the UK was no longer more affordable than renting one. Consequently, Brits have become more likely to rent longer and push off making a house purchase until they have saved up enough for a down payment and achieved the financial stability required to make the step. What caused the recent fluctuations in house prices? House prices are affected by multiple factors, such as mortgage rates, supply, and demand on the market. For nearly a decade, the UK experienced uninterrupted house price growth as a result of strong demand and a chronic undersupply. Homebuyers who purchased a property at the peak of the housing boom in July 2022 paid ** percent more compared to what they would have paid a year before. Additionally, 2022 saw the most dramatic increase in mortgage rates in recent history. Between December 2021 and December 2022, the **-year fixed mortgage rate doubled, adding further strain to prospective homebuyers. As a result, the market cooled, leading to a correction in pricing.

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 lower quartile 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 lower quartile 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 three quarters of the way down the list, such that 75Percentage of transactions lie above and 25Percentage lie below that value. These are particularly useful for assessing housing affordability when viewed alongside average and lower quartile income for given areas.

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 lower quartile transactional value of houses and the overall market value of houses.

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 dataset mainly provides actual information about pre-sale house transactions declared by applicants nationwide, including actual transaction prices and key attributes such as area, land use zoning, and other information. (Provide MANIFEST.CSV, schema-main.csv, schema-build.csv, schema-land.csv, schema-park.csv) Released once on the 1st, 11th, and 21st of each month.

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.

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.