Home Renovation Impact Dataset
This dataset provides detailed records of residential properties, including renovation history, sale transactions, and agent involvement, enabling robust analysis of how specific renovations affect home values and marketability. It is ideal for homeowners, agents, and analysts seeking actionable insights into renovation ROI, pricing trends, and listing performance.
Sample rows
preview · 8 of 200 rows · all 26 columns| property_idstring | property_typestring | bathroomsfloat | renovation_typestring | address_streetstring | address_citystring | address_statestring | address_postal_codestring | address_countrystring | bedroomsinteger | square_footageinteger | year_builtinteger | renovation_idstring | renovation_costfloat | renovation_datedate | pre_renovation_valuefloat | post_renovation_valuefloat | sale_idstring | sale_datedate | sale_pricefloat | days_on_marketinteger | agent_idstring | agent_namestring | agent_contactstring | listing_statusstring | renovation_descriptionstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| P0001 | single-family | 3.5 | kitchen | 192 Oakridge Lane | Springfield | IL | 62704 | USA | 4 | 2650 | 1994 | R0001 | 32000 | 2022-03-15 | 370000 | 415000 | S0001 | 2022-11-05 | 425000 | 18 | A0001 | Susan Morales | susan.morales@ | sold | Full kitchen remodel including new appliances and cabinets. |
| P0002 | townhouse | 2.5 | blank | 85 Maplewood Drive | Vancouver | BC | V5K 0A1 | Canada | 3 | 1450 | 2014 | blank | blank | blank | blank | blank | S0002 | 2023-01-18 | 610000 | 21 | A0002 | Laura Choi | laura.choi@ | sold | blank |
| P0003 | condo | 1.5 | windows | 703 Kingfisher Street | Seattle | WA | 98103 | USA | 2 | 970 | 2002 | R0002 | 11000 | 2021-09-30 | 340000 | 355000 | blank | blank | blank | blank | A0003 | Erik Lindstrom | elindstrom@ | active | Replaced all windows with energy-efficient models. |
| P0004 | condo | 2 | blank | 412 Easton Avenue | Toronto | ON | M4C 1B4 | Canada | 2 | 1100 | 2019 | blank | blank | blank | blank | blank | blank | blank | blank | blank | A0004 | Megan Patel | megan.patel@ | active | blank |
| P0005 | townhouse | 2.5 | roof | 15 Glenview Crescent | Dublin | LD | D02W086 | Ireland | 4 | 1950 | 2007 | R0003 | 18500 | 2020-06-18 | 410000 | 445000 | S0003 | 2022-03-25 | 450000 | 13 | A0005 | Declan O'Shea | declan.oshea@ | sold | Replaced the roof and added new insulation. |
| P0006 | single-family | 4 | blank | 2708 Pine Ridge Road | Denver | CO | 80205 | USA | 5 | 3400 | 2005 | blank | blank | blank | blank | blank | blank | blank | blank | blank | A0001 | Susan Morales | susan.morales@ | active | blank |
| P0007 | multi-family | 6 | windows | 1185 Willow Bend | Calgary | AB | T2P 2M5 | Canada | 8 | 5400 | 1978 | R0004 | 26000 | 2019-07-22 | 980000 | 1035000 | blank | blank | blank | blank | A0006 | James Stewart | j.stewart@ | pending | Upgraded windows in all units. |
| P0008 | condo | 1 | blank | 362 Birch Hill Road | London | LDN | SW1A 1AA | UK | 1 | 650 | 1999 | blank | blank | blank | blank | blank | S0004 | 2023-05-10 | 328000 | 30 | A0007 | Hannah Taylor | htaylor@ | sold | blank |
| P0009 | single-family | 2 | blank | 500 Sunrise Court | Phoenix | AZ | 85016 | USA | 3 | 1800 | 2018 | blank | blank | blank | blank | blank | S0005 | 2023-07-15 | 490000 | 35 | A0008 | Jared Kim | jared.kim@ | sold | blank |
| P0010 | multi-family | 8 | blank | 77 Northshore Drive | Houston | TX | 77007 | USA | 10 | 8500 | 1982 | blank | blank | blank | blank | blank | S0006 | 2022-08-02 | 2300000 | 51 | A0009 | William Martinez | wmartinez@ | sold | blank |
| P0011 | single-family | 2.5 | landscaping | 3642 White Pine Lane | Miami | FL | 33176 | USA | 4 | 2950 | 2010 | R0005 | 14000 | 2020-04-11 | 510000 | 535000 | S0007 | 2020-09-25 | 540000 | 16 | A0010 | Angela Torres | atorres@ | sold | Installed new sod, flower beds, and backyard patio. |
| P0012 | townhouse | 1.5 | blank | 201 Beverly Crest | Victoria | BC | V8V 2N9 | Canada | 2 | 1120 | 2017 | blank | blank | blank | blank | blank | blank | blank | blank | blank | A0002 | Laura Choi | laura.choi@ | active | blank |
| P0013 | condo | 1.5 | blank | 8417 Aspen Circle | Oslo | OS | 0155 | Norway | 2 | 890 | 2011 | blank | blank | blank | blank | blank | blank | blank | blank | blank | A0011 | Kari Johansen | kari.johansen@ | pending | blank |
| P0014 | single-family | 4.5 | basement | 304 Cedar Springs Blvd | Dallas | TX | 75219 | USA | 5 | 3400 | 1989 | R0006 | 42000 | 2022-11-07 | 495000 | 550000 | blank | blank | blank | blank | A0009 | William Martinez | wmartinez@ | active | Finished basement with home theater and gym. |
| P0015 | condo | 2 | blank | 19 Willowbrook Road | New York | NY | 10028 | USA | 3 | 1300 | 1964 | blank | blank | blank | blank | blank | S0008 | 2022-02-14 | 785000 | 42 | A0012 | Teresa Goodwin | teresa.goodwin@ | sold | blank |
| P0016 | townhouse | 1 | blank | 620 Elmwood Place | Cork | CK | T12XH2A | Ireland | 2 | 980 | 2016 | blank | blank | blank | blank | blank | blank | blank | blank | blank | A0005 | Declan O'Shea | declan.oshea@ | active | blank |
| P0017 | multi-family | 8 | exterior | 1077 Lakeside Drive | Chicago | IL | 60611 | USA | 12 | 12000 | 1973 | R0007 | 39000 | 2021-05-19 | 1890000 | 1955000 | S0009 | 2022-03-09 | 2100000 | 77 | A0013 | Michael Lee | m.lee@ | sold | Exterior painting and facade upgrades. |
| P0018 | single-family | 4 | flooring | 8843 Red Maple Lane | Boulder | CO | 80302 | USA | 5 | 3100 | 2015 | R0008 | 18000 | 2022-08-03 | 895000 | 915000 | blank | blank | blank | blank | A0001 | Susan Morales | susan.morales@ | active | Installed hardwood floors throughout main level. |
| P0019 | multi-family | 5.5 | bathroom | 47 Cedar Glen | Edmonton | AB | T5J 2J7 | Canada | 7 | 6400 | 1988 | R0009 | 30000 | 2020-12-02 | 1150000 | 1200000 | blank | blank | blank | blank | A0006 | James Stewart | j.stewart@ | pending | Remodeled bathrooms in all units. |
| P0020 | single-family | 2 | blank | 111 Spruce Avenue | Las Vegas | NV | 89107 | USA | 3 | 1750 | 2012 | blank | blank | blank | blank | blank | S0010 | 2023-03-03 | 475000 | 25 | A0008 | Jared Kim | jared.kim@ | sold | blank |
What the 200 rows show
from the 200-row sampleOther (property type) stands out: mean bathrooms is 44.4, against 3.1 for the rest.
- 2.5median bathrooms
- 4listing statuses
- 9address countries
- 57address states
- 4median bedrooms
- 1,935median square_
footage
Median 2.5, from 0.0 to 99.9.
- string 15
- integer 4
- float 5
- date 2
Columns
26 columns in three groups| column | type | description | example |
|---|---|---|---|
| Text 15 columns | |||
property_id | string | Unique identifier for each propertyunique | P0001 |
address_street | string | Street address of the property | 192 Oakridge Lane |
address_city | string | City where the property is located | Springfield |
address_state | string | State where the property is located | IL |
address_postal_code | string | Postal code of the property | 62704 |
address_country | string | Country where the property is located9 countries | USA |
property_type | string | Type of property (e.g., single-family, condo, townhouse)single-family · condo · townhouse · multi-family · other | single-family |
renovation_id | string | Unique identifier for each renovation eventoptional | R0001 |
renovation_type | string | Type of renovation performed (e.g., kitchen, bathroom, roof, landscaping)9 values · optional | kitchen |
renovation_description | string | Detailed description of the renovationoptional | Full kitchen remodel incl… |
sale_id | string | Unique identifier for each sale transactionoptional | S0001 |
agent_id | string | Unique identifier for the listing agentoptional | A0001 |
agent_name | string | Full name of the listing agentoptional | Susan Morales |
agent_contact | string | Contact information for the listing agent (phone or email)optional | htaylor@ |
listing_status | string | Current status of the property listingactive · pending · sold · off-market | sold |
| Numbers 9 columns | |||
bedrooms | integer | Number of bedrooms in the property0 or more | 4 |
bathrooms | float | Number of bathrooms in the property (can be fractional)0 or more | 3.5 |
square_footage | integer | Total finished square footage of the property0 or more | 2650 |
year_built | integer | Year the property was originally built1,800 to 2,100 | 1994 |
renovation_cost | float | Cost of the renovation in local currency0 or more · optional | 32000 |
pre_renovation_value | float | Estimated market value of the property before renovation0 or more · optional | 370000 |
post_renovation_value | float | Estimated market value of the property after renovation0 or more · optional | 415000 |
sale_price | float | Final sale price of the property0 or more · optional | 425000 |
days_on_market | integer | Number of days the property was listed before sale0 or more · optional | 18 |
| Dates and times 2 columns | |||
renovation_date | date | Date when the renovation was completedoptional | 2022-03-15 |
sale_date | date | Date when the property was soldoptional | 2022-11-05 |
Use it for
A real estate dashboard
Bathrooms by property_
type and a breakdown of renovation_ type. Excel, Power BI or Tableau. Why do the 18 other rows have a mean bathrooms of 44.4?
A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Properties200P00013.5single-f…P00022.5townhouseP00031.5condo
A software demo
Believable properties with address_
street, address_ city and address_ state to fill a screen in front of a buyer.
blueprint · home-renovation-impact-dataset
Behind this dataset
Same schema. As many rows as you need.
These 200 rows came out of a blueprint — 26 columns with generation rules behind each one. Open it in Data Factory to retune a column, add your own, wire in foreign keys, and run it at the size you actually need.
- Include renovation type and date
- Track resulting sale price change
- Flag high-ROI projects
- Exclude owner-occupied properties
1 credit per row. Preview 20 rows free. Buy rows for the full run.
- Exports
- CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
- Licence
- yours to use, including commercially
- API slug
- home-renovation-impact-dataset