Property Listing Price History
This dataset provides a comprehensive record of property listing price changes over time, including detailed property attributes, location information, and event types for each price change. It enables in-depth analysis of real estate market dynamics, pricing strategies, and property value trends across regions and property types.
Sample rows
preview · 8 of 90 rows · all 18 columns| listing_idstring | property_typestring | bedroomsinteger | address_countrystring | property_idstring | price_history_idstring | pricefloat | currencystring | price_change_datedatetime | price_change_typestring | agent_idstring | address_streetstring | address_citystring | address_statestring | address_postal_codestring | bathroomsfloat | square_feetinteger | listing_statusstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| LIST10001 | single_family | 4 | USA | PROP20001 | PH0001 | 475000 | USD | 2023-04-03T10:15:00 | initial_listing | AGT001 | 123 Oak Ridge Dr | Denver | CO | 80220 | 3.5 | 2650 | active |
| LIST10001 | single_family | 4 | USA | PROP20001 | PH0002 | 470000 | USD | 2023-05-01T10:30:00 | price_decrease | AGT001 | 123 Oak Ridge Dr | Denver | CO | 80220 | 3.5 | 2650 | active |
| LIST10001 | single_family | 4 | USA | PROP20001 | PH0003 | 465000 | USD | 2023-06-02T14:50:00 | price_decrease | AGT001 | 123 Oak Ridge Dr | Denver | CO | 80220 | 3.5 | 2650 | pending |
| LIST10002 | townhouse | 3 | USA | PROP20002 | PH0004 | 950000 | USD | 2023-03-15T09:00:00 | initial_listing | AGT002 | 88 Maple St | San Francisco | CA | 94110 | 2 | 1820 | active |
| LIST10002 | townhouse | 3 | USA | PROP20002 | PH0005 | 975000 | USD | 2023-04-10T12:20:00 | price_increase | AGT002 | 88 Maple St | San Francisco | CA | 94110 | 2 | 1820 | active |
| LIST10002 | townhouse | 3 | USA | PROP20002 | PH0006 | 950000 | USD | 2023-06-15T16:40:00 | price_decrease | AGT002 | 88 Maple St | San Francisco | CA | 94110 | 2 | 1820 | pending |
| LIST10003 | condo | 2 | USA | PROP20003 | PH0007 | 315000 | USD | 2023-07-10T11:05:00 | initial_listing | AGT003 | 159 Cedar Ave | Austin | TX | 78704 | 1 | 920 | active |
| LIST10003 | condo | 2 | USA | PROP20003 | PH0008 | 315000 | USD | 2023-08-05T13:25:00 | relisted | AGT003 | 159 Cedar Ave | Austin | TX | 78704 | 1 | 920 | active |
| LIST10004 | single_family | 5 | USA | PROP20004 | PH0009 | 1375000 | USD | 2022-11-20T14:00:00 | initial_listing | AGT004 | 2 Beacon Hill | Boston | MA | 02114 | 4.5 | 3100 | active |
| LIST10004 | single_family | 5 | USA | PROP20004 | PH0010 | 1345000 | USD | 2023-01-15T15:15:00 | price_decrease | AGT004 | 2 Beacon Hill | Boston | MA | 02114 | 4.5 | 3100 | pending |
| LIST10005 | apartment | 1 | CAN | PROP20005 | PH0011 | 225000 | CAD | 2023-02-16T13:00:00 | initial_listing | AGT005 | 77 Birchmount Rd | Toronto | ON | M1N 3M6 | 1 | 620 | active |
| LIST10005 | apartment | 1 | CAN | PROP20005 | PH0012 | 210000 | CAD | 2023-03-16T13:15:00 | price_decrease | AGT005 | 77 Birchmount Rd | Toronto | ON | M1N 3M6 | 1 | 620 | pending |
| LIST10006 | apartment | 2 | FRA | PROP20006 | PH0013 | 720000 | EUR | 2023-02-05T16:10:00 | initial_listing | AGT006 | 12 Rue de Rivoli | Paris | IDF | 75004 | 1 | 870 | active |
| LIST10006 | apartment | 2 | FRA | PROP20006 | PH0014 | 700000 | EUR | 2023-03-18T18:15:00 | price_decrease | AGT006 | 12 Rue de Rivoli | Paris | IDF | 75004 | 1 | 870 | pending |
| LIST10007 | condo | 3 | USA | PROP20007 | PH0015 | 1150000 | USD | 2023-06-23T12:45:00 | initial_listing | AGT007 | 501 Ocean Dr | Miami Beach | FL | 33139 | 2.5 | 2100 | active |
| LIST10008 | commercial | 0 | GBR | PROP20008 | PH0016 | 68000 | GBP | 2023-05-15T10:00:00 | initial_listing | AGT008 | 15 Piccadilly | London | LDN | W1J 9HS | 2 | 3400 | active |
| LIST10009 | single_family | 4 | USA | PROP20009 | PH0017 | 510000 | USD | 2023-04-11T09:30:00 | initial_listing | AGT009 | 341 Sunflower Ln | Phoenix | AZ | 85016 | 3 | 2320 | active |
| LIST10009 | single_family | 4 | USA | PROP20009 | PH0018 | 495000 | USD | 2023-05-16T11:00:00 | price_decrease | AGT009 | 341 Sunflower Ln | Phoenix | AZ | 85016 | 3 | 2320 | pending |
| LIST10010 | townhouse | 2 | USA | PROP20010 | PH0019 | 310000 | USD | 2023-07-01T13:45:00 | initial_listing | AGT010 | 20 Willow Tree Ln | Seattle | WA | 98115 | 1.5 | 1300 | active |
| LIST10010 | townhouse | 2 | USA | PROP20010 | PH0020 | 299000 | USD | 2023-08-12T10:30:00 | price_decrease | AGT010 | 20 Willow Tree Ln | Seattle | WA | 98115 | 1.5 | 1300 | pending |
What the 90 rows show
from the 90-row sampleSingle_
- 2median bedrooms
- 4currencies
- 4listing statuses
- 5price change types
- 467,500median price
- 1.5median bathrooms
Median 2, from 0 to 6.
- string 13
- integer 2
- float 2
- datetime 1
Columns
18 columns in three groups| column | type | description | example |
|---|---|---|---|
| Text 13 columns | |||
listing_id | string | Unique identifier for the property listing. Remains constant for the same property across all price history records. | LIST10001 |
property_id | string | Unique identifier for the property itself. Used to group multiple listings of the same property. | PROP20001 |
price_history_id | string | Unique identifier for each price history record.unique | PH0001 |
currency | string | Currency code for the listing price (e.g., USD, EUR, GBP).4 currencies | USD |
price_change_type | string | Type of price change event (e.g., initial_listing, price_increase, price_decrease, relisted, withdrawn).5 values | initial_listing |
agent_id | string | Identifier for the listing agent or agency responsible for the price change.optional | AGT001 |
address_street | string | Street address of the property. | 123 Oak Ridge Dr |
address_city | string | City where the property is located. | Denver |
address_state | string | State or region where the property is located. | CO |
address_postal_code | string | Postal or ZIP code of the property. | 80220 |
address_country | string | Country where the property is located.10 countries | USA |
property_type | string | Type of property (e.g., single_family, condo, townhouse, apartment, land, commercial).7 values · optional | single_family |
listing_status | string | Current status of the listing (e.g., active, pending, sold, withdrawn, expired).active · pending · sold · withdrawn · expired · optional | active |
| Numbers 4 columns | |||
price | float | Listing price of the property at the time of the record.0 or more | 475000 |
bedrooms | integer | Number of bedrooms in the property.0 or more · optional | 4 |
bathrooms | float | Number of bathrooms in the property (can be fractional, e.g., 1.5).0 or more · optional | 3.5 |
square_feet | integer | Total living area of the property in square feet.0 or more · optional | 2650 |
| Dates and times 1 column | |||
price_change_date | datetime | Date and time when the price was changed or recorded. | 2023-04-03T10:15:00 |
Use it for
A real estate dashboard
Bedrooms by property_
type and a breakdown of address_ country. Excel, Power BI or Tableau. Why do the 22 single_
family rows have a mean bedrooms of 4.0? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Listings90LIST100014single_f…LIST100014single_f…LIST100014single_f…
A software demo
Believable listings with property_
id, price_ history_ id and price to fill a screen in front of a buyer.
blueprint · property-listing-price-history
Behind this dataset
Same schema. As many rows as you need.
These 90 rows came out of a blueprint — 18 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.
- Record initial and updated prices with dates
- Capture property type and size
- Flag properties with >3 price changes
- Include neighborhood and listing agent
- Mark listings sold within 30 days
1 credit per row. New accounts start with 25 free credits.
- Exports
- CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
- Licence
- yours to use, including commercially
- API slug
- property-listing-price-history