GuidesAPI ReferenceDiscussions
Guides

Track property status changes

Suggest Edits

Introduction

Many Datafiniti customers are interested in using our property data to track the status of property as they on/off the market. This guide will show you how to track this feed from historical to daily.

Finding the most recent status change

Datafiniti allows you to search on the most recent changes to the data in the record itself. For this example we will be looking for the most recent For Sale homes in Houston, Texas for the last 30 days since July 1st. Here is the query:

{
    "query": "country:\"US\" AND province:TX AND city:houston AND mostRecentStatus:\"For Sale\" AND mostRecentStatusFirstDateSeen:[2023-07-01 TO *]",
    "num_records": 10
}

We used a combination of mostRecentStatus and mostRecentStatusFirstDateSeen to limit this query to only For Sale status. mostRecentStatusFirstDateSeen will state the date when the mostRecentStatus changed last.

📘

mostRecentStatusFirstDateSeen vs mostRecentStatusDate

Please note that mostRecentStatusFirstDateSeen is a static field that show when the status change was first made. mostRecentStatusDate is a fluid field that will update even if the status is verified to be the same.

We are using a wildcard ended range to dictate the till present date. Please change your date range to which ever represent your use case better.

Verify Status of a property

Based off of our previous example we are going to check if the status of the address 1914 Augusta Dr Unit 21 is still for sale. We will use the following query to do so:

{
    "query": "country:\"US\" AND province:TX AND city:houston AND address:\"1914 Augusta Dr Unit 21\"",
    "num_records": 1
}

📘

Address normalization

Datafiniti uses our own street name normalization. Converting street to st, drive to dr, etc, you can learn more about our address normalization here: Normalized Property Addresses


This will return the following property data. We will focus on the most recent data fields for this example. 

{
	"mostRecentPriceAmount": 227900,
	"mostRecentPriceDomain": "www.redfin.com",
	"mostRecentPriceSourceURL": "https://www.redfin.com/TX/Houston/1914-Augusta-Dr-77057/unit-21/home/30396468",
	"mostRecentPriceDate": "2023-08-08T15:42:45.733Z",
	"mostRecentPriceFirstDateSeen": "2023-07-19T13:02:01.347Z",
	"mostRecentStatus": "For Sale",
	"mostRecentStatusDate": "2023-08-08T00:00:00.000Z",
	"mostRecentStatusFirstDateSeen": "2023-07-19T00:00:00.000Z"
}

We can see that the property has been on the market for longer than 14 days by comparing mostRecentStatusDate to mostRecentStatusFirstDateSeen. Using this method will allow you boarder insight on market trends in your area with any query you search with.

Example files

Here are example bulk download files of our previous queries:

Conclusion

By utilizing our most recent status field you will be able to track the life cycle of a property as it comes on/off the market. Search for the statuses you care about and setting up date ranges will allow you to better analyze the property markets you are most interested in.

Updated 9 months ago