The average price per square foot of floor space in new single-family housing in the United States decreased after the great financial crisis, followed by several years of stagnation. Since 2012, the price has continuously risen, hitting ****** U.S. dollars per square foot in 2024. In 2024, the average sales price of a new home exceeded ******* U.S. dollars. Development of house sales in the U.S. One of the reasons for rising property prices is the gradual growth of house sales between 2011 and 2020. This period was marked by the gradual recovery following the subprime mortgage crisis and a growing housing sentiment. Another significant factor for the housing demand was the growing number of new household formations each year. Despite this trend, housing transactions plummeted in 2021, amid soaring prices and borrowing costs. In 2021, the average construction cost for single-family housing rose by nearly ** percent year-on-year, and in 2022, the increase was even higher, at close to ** percent. Financing a house purchase Mortgage interest rates in the U.S. rose dramatically in 2022 and remained elevated until 2024. In 2020, a homebuyer could lock in a 30-year fixed interest rate of under ***** percent, whereas in 2024, the average rate for the same mortgage type was more than twice higher. That has led to a decline in homebuyer sentiment, and an increasing share of the population pessimistic about buying a home in the current market.

Graph and download economic data for Housing Inventory: Median Listing Price per Square Feet in the United States (MEDLISPRIPERSQUFEEUS) from Jul 2016 to Oct 2025 about square feet, listing, median, price, and USA.

Graph and download economic data for Housing Inventory: Median Listing Price per Square Feet in Minnesota (MEDLISPRIPERSQUFEEMN) from Jul 2016 to Oct 2025 about MN, square feet, listing, median, price, and USA.

House prices in the second most populous state in the United States, Texas have doubled since 2011. In 2023, the average house price reached ***** U.S. dollars per square foot, up from approximately *** U.S. dollars in 2020. Despite the increase, the median home price was still below the national average.

Graph and download economic data for Housing Inventory: Median Listing Price per Square Feet in Ohio (MEDLISPRIPERSQUFEEOH) from Jul 2016 to Oct 2025 about square feet, OH, listing, median, price, and USA.

Graph and download economic data for Housing Inventory: Median Listing Price per Square Feet in Texas (MEDLISPRIPERSQUFEETX) from Jul 2016 to Oct 2025 about square feet, TX, listing, median, price, and USA.

Prices for luxury housing in July 2024 were slightly lower than the market peak in 2021 and 2022. Luxury single-family properties had a median square footage price of *** U.S. dollars in July 2024, down from *** U.S. dollars in July 2022. Attached houses, on the other hand, had a median price of *** U.S. dollars per square foot, down from *** U.S. dollars in July 2021.

In 2022, San Mateo, San Francisco, and Santa Clara were the most expensive districts for housing in the San Francisco Bay Area. In San Francisco, the average square footage price of single-family homes exceeded 1,000 U.S. dollars per square foot. Housing in Solano, on the other hand, was most affordable, with the average square footage price for single family homes at *** U.S. dollars.

How expensive is buying a home in San Francisco? Few metros in the U.S. are more expensive than San Francisco, CA. In 2022, the median sales price of existing single-family homes in San Francisco was about *** million U.S. dollars, making it the second priciest market in the U.S. House prices in the Golden City, were not always so high: in 2014, a two-bedroom house in the Bay Area would sell for less than ******* U.S. dollars but since then, the median price has more than doubled.

How much does renting an apartment cost? Despite rents falling in 2020, renting in San Francisco is still far from cheap. Renting a two-bedroom apartment cost close to ***** U.S. dollars in 2021. California is one of the least affordable states for renters. In fact, to afford to rent such an apartment, a household needs approximately ***** full time jobs at minimum wage or *** full time jobs at mean wage.

The average price per square foot of floor space in new single-family houses in North-east, United States increased from 2000 to 2021. In 2021, the average price for a new single-family house in that region was approximately *** U.S. dollars per square foot of floor space.

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.

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

Between 2020 and 2022, the average square footage price of one-to-three family homes in Queens, New York increased. Existing condo prices, on the other hand, fell from ***** U.S. dollars per square foot in the ********************* to *** U.S. dollars per square foot in the *********************.

The average price for residential real estate in Manhattan, New York increased for luxury, new developments, and condos. Conversely, prices for re-sale and co-op properties declined slightly. In the third quarter of 2024, the average square footage price for a re-sale property was ***** U.S. dollars per square foot.

Geneva stands out as Europe's most expensive city for apartment purchases in early 2025, with prices reaching a staggering 15,720 euros per square meter. This Swiss city's real estate market dwarfs even high-cost locations like Zurich and London, highlighting the extreme disparities in housing affordability across the continent. The stark contrast between Geneva and more affordable cities like Nantes, France, where the price was 3,700 euros per square meter, underscores the complex factors influencing urban property markets in Europe. Rental market dynamics and affordability challenges While purchase prices vary widely, rental markets across Europe also show significant differences. London maintained its position as the continent's priciest city for apartment rentals in 2023, with the average monthly costs for a rental apartment amounting to 36.1 euros per square meter. This figure is double the rent in Lisbon, Portugal or Madrid, Spain, and substantially higher than in other major capitals like Paris and Berlin. The disparity in rental costs reflects broader economic trends, housing policies, and the intricate balance of supply and demand in urban centers. Economic factors influencing housing costs The European housing market is influenced by various economic factors, including inflation and energy costs. As of April 2025, the European Union's inflation rate stood at 2.4 percent, with significant variations among member states. Romania experienced the highest inflation at 4.9 percent, while France and Cyprus maintained lower rates. These economic pressures, coupled with rising energy costs, contribute to the overall cost of living and housing affordability across Europe. The volatility in electricity prices, particularly in countries like Italy where rates are projected to reach 153.83 euros per megawatt hour by February 2025, further impacts housing-related expenses for both homeowners and renters.

Graph and download economic data for Housing Inventory: Median Listing Price per Square Feet in Arizona (MEDLISPRIPERSQUFEEAZ) from Jul 2016 to Oct 2025 about AZ, square feet, listing, median, price, and USA.

In the first quarter of 2025, San Francisco, Chicago, New York, and Honolulu were some of the U.S. cities with the highest housing construction costs. Meanwhile, Phoenix had one of the lowest construction costs for high-end multifamily homes at *** U.S. dollars per square foot and Las Vegas for single-family homes between *** and *** U.S. dollars per square foot. Construction cost disparities As seen here, the construction cost for a high-end multi-family home in San Francisco in the first quarter of 2024 was over ***** more expensive than in Phoenix. Meanwhile, there were also great differences in the cost of building a single-family house in New York and in Portland or Seattle. Some factors that may cause these disparities are the construction materials, installation, and composite costs, differing land values, wages, etc. For example, although the price of construction materials in the U.S. was rising at a slower level than in 2022 and 2023, several materials that are essential in most construction projects had growth rates of over **** percent in 2024. Growing industry revenue Despite the economic uncertainty and other challenges, the size of the private construction market in the U.S. rose during the past years. It is important to consider that supply and demand for housing influences the revenue of this segment of the construction market. On the supply side, single-family home construction fell in 2023, but it is expected to rise in 2024 and 2025. On the demand side, some of the U.S. metropolitan areas with the highest sale prices of single-family homes were located in California, with San Jose-Sunnyvale-Santa Clara at the top of the ranking.

In 2024, the average square footage price of condos and new development condos in Brooklyn, NY declined slightly. Prices of one-to-three family homes, on the other hand, increased from *** U.S. dollars per square foot in the third quarter of 2023 to *** U.S. dollars in the third quarter of 2024.

Housing Inventory: Median Listing Price per Square Feet in Virginia was 230.00000 U.S. $ in September of 2025, according to the United States Federal Reserve. Historically, Housing Inventory: Median Listing Price per Square Feet in Virginia reached a record high of 235.00000 in May of 2025 and a record low of 131.00000 in December of 2016. Trading Economics provides the current actual value, an historical data chart and related indicators for Housing Inventory: Median Listing Price per Square Feet in Virginia - last updated from the United States Federal Reserve on November of 2025.

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