Market Analysis - Housing Data

About This Dataset

This page presents a curated selection of 14 properties drawn from the Kaggle Housing Prices dataset (545 total entries, 13 attributes each). The data grid below is sorted by Price (highest to lowest) and lets you explore how features like area, bedrooms, bathrooms, and amenities relate to housing value.

Property Data Grid

Property	Price	Area (sqft)	Bed	Bath	Stories	Parking	Furnishing	AC	Basement
P-001	13,300,000	7,420	4	2	3	2	Furnished	Yes	No
P-002	12,250,000	8,960	4	4	4	3	Semi-Furnished	Yes	Yes
P-003	10,150,000	6,000	3	2	2	2	Furnished	Yes	Yes
P-004	8,400,000	7,500	4	2	2	3	Semi-Furnished	Yes	No
P-005	7,700,000	6,550	3	2	2	2	Unfurnished	Yes	Yes
P-006	6,300,000	5,320	3	1	2	2	Furnished	Yes	No
P-007	5,600,000	4,600	3	1	2	0	Semi-Furnished	No	Yes
P-008	4,900,000	3,850	2	1	1	2	Furnished	Yes	Yes
P-009	4,200,000	5,000	3	1	1	2	Unfurnished	No	No
P-010	3,850,000	3,600	2	1	2	0	Semi-Furnished	Yes	No
P-011	3,150,000	4,000	3	1	1	1	Unfurnished	No	No
P-012	2,800,000	3,500	2	1	1	0	Semi-Furnished	No	No
P-013	2,275,000	2,910	2	1	1	1	Unfurnished	No	No
P-014	1,750,000	2,135	1	1	1	0	Unfurnished	No	No

Table sorted by Price (descending). Data source: Kaggle — Housing Prices by Sadia Javed.

Analysis

Does More Space Always Mean a Higher Price?

A common assumption is that larger homes cost more. But comparing P-002 (8,960 sqft, $12.25M) with P-001 (7,420 sqft, $13.3M) reveals that the largest property is not the most expensive.

P-001 is Furnished while P-002 is only Semi-Furnished. This suggests that furnishing status and other amenities can outweigh raw square footage when it comes to pricing.

                    Key Insight: While area is the strongest single numerical predictor of price (correlation: 0.54), categorical features like furnishing status and preferred area can override the size advantage.
                

The "Value Sweet Spot"

The mid-range properties (P-005 through P-007, priced $5.6M-$7.7M) offer the highest variance in value. P-005 costs $2.1M more than P-007, despite both having 3 bedrooms.

The key differences: P-005 has AC, is in a preferred area, and has 2 parking spots. P-007 has no AC, is not in a preferred area, and has zero parking.

                    Key Insight: Buyers willing to forego air conditioning or furnishing can find significantly more space for their budget. P-009 at 5,000 sqft / $4.2M gives roughly 1,190 sqft per million — compared to P-001's 558 sqft per million at the top end.
                

Housing Glossary

Price: The sale price of the property in local currency. In this dataset, prices range from approximately 1.75 million to 13.3 million, with a dataset average of roughly 4.77 million.
Area (sqft): Total livable area measured in square feet. The dataset average is about 5,150 sqft. Area has a moderate positive correlation (0.54) with price, making it one of the strongest predictors of property value.
Bathrooms: Number of bathrooms in the property (1-4). Bathrooms have a strong positive correlation with price (0.52), making them the second-strongest numerical predictor after area.
Furnishing Status: Furnished (move-in ready), Semi-Furnished (some fixtures included), or Unfurnished (empty). Furnished properties tend to command premium prices.
Preferred Area: Whether the property is located in a premium neighborhood. This is one of the strongest categorical predictors of higher property prices in the dataset.