Determine home values
Introduction
Many Datafiniti customers are interested in using our data to determine the value of a single home or the expected value of homes within a given area. There are a couple ways to do this.
Option 1: Download data for all homes in an area
One way to do this is to download data for all the homes in a given area. Let's start with something simple:
{
"query": "propertyType:\"Single Family Dwelling\" AND mostRecentStatus:\"For Sale\" AND postalCode:78722 AND dateUpdated:[2023-01-01 TO *]"
}
This query will match every single family home in the 78722 zip code that has been listed as for sale since January 1, 2023. We can adjust the dateUpdated value to reflect any date range we want.
Let's say we don't want to do a zip code-based search. We want to do a search around a lat/long point:
{
"query": "propertyType:\"Single Family Dwelling\" AND mostRecentStatus:\"For Sale\" AND geoLocation:[-97.7430600,30.2671500,10,mi] AND dateUpdated:[2023-01-01 TO *]"
}
This is similar to the previous query, but now it matches every property in a 10 mile radius around a single geo coordinate. Longitude goes first, latitude goes second.
If we want to go a little further and only match properties that are within a certain price range, we do this:
{
"query": "propertyType:\"Single Family Dwelling\" AND mostRecentStatus:\"For Sale\" AND geoLocation:[-97.7430600,30.2671500,10,mi] AND dateUpdated:[2023-01-01 TO *] AND prices.amountMin:>=300000 AND prices.amountMin:<=500000"
}
This filters down the matching data further by restricting it to homes that have been listed between $300,000 - $500,000.
Finally, if we want to download the entire data set, we do this:
{
"query": "propertyType:\"Single Family Dwelling\" AND mostRecentStatus:\"For Sale\" AND geoLocation:[-97.7430600,30.2671500,10,mi] AND dateUpdated:[2023-01-01 TO *]",
"download": true,
"format": "CSV"
}
We can adjust the parameters here to set format to JSON. We can also restrict the number of records to download by passing in additional num_records field.
Option 2: Find comparable homes to a single property
Let's say you have a property in mind and you want to use similar properties to determine the value of the home.
First off, if we don't have the features of the property in hand, we can try looking them up in Datafiniti.
{
"query": "address:\"123 Main St\" AND city:Austin AND province:TX"
}
This will return something like:
{
"num_found": 80,
"total_cost": 1,
"records": [
{
"address": "1708 Goodrich Ave Unit 2",
"brokers": [
{
"agent": "Liz Warren",
"company": "Realty Austin",
"dateSeen": "2023-02-24T11:33:00.205Z"
},
{
"agent": "Matthew Robins",
"company": "Compass RE Texas, LLC",
"dateSeen": "2020-05-16T04:21:10.248Z",
"phones": [
"9178825098"
],
"websites": [
"http://www.austinhomesearch.com/3471731"
]
}
],
"city": "Austin",
"country": "US",
"dateAdded": "2020-04-23T16:54:17Z",
"dateUpdated": "2023-02-24T12:12:03Z",
"descriptions": [
{
"dateSeen": "2023-02-24T11:33:00.000Z",
"value": "Contemporary standalone condo in a prime location in the heart of the Zilker neighborhood. Built in 2020. NO HOA fees. Walk to Barton Springs pool, Zilker Park, Alamo Drafthouse, and all of South Lamar's hotspots. Fenced private yard with room for cowboy pool or backyard office POD. High-quality finishes, including designer light fixtures, Bosch appliances, and stone counters. Owner installed custom automatic screen on glass sliding door to allow breezes in, while keeping bugs and harsh rays out. Two bedrooms, both on upper level, each with ensuite bathroom. Schedule a Private Showing"
},
{
"dateSeen": "2020-05-16T04:21:00.000Z",
"value": "Sleek modern farm ADU home in Zilker. 2 bed and 2.5 bath. Designed by Rodenberg Design. 2-story design with 10 ft long island and 15 ft vaulted ceiling in the living room. Lots of natural light and open space through this 1,100sqft home. A wide open gourmet kitchen featuring Bosch appliances. The home is just south of Downtown Austin close to Zilker Park, Lamar Union, and South Lamar. Schedule a Private Showing"
}
],
"features": [
{
"value": [
"Residential"
],
"key": "Structure Type"
},
{
"key": "Tax Year",
"value": [
"2019"
]
},
{
"key": "Fencing",
"value": [
"Fenced"
]
},
{
"key": "Half Baths",
"value": [
"1"
]
},
{
"key": "Foreclosure/REO",
"value": [
"No"
]
},
{
"key": "Bedrooms on Other Level",
"value": [
"2"
]
},
{
"key": "Office phone",
"value": [
"(512) 241-1300",
"(512) 575-3644"
]
},
{
"key": "FEMA 100 Yr Flood Plain",
"value": [
"No"
]
},
{
"key": "Accessibility Features",
"value": [
"None"
]
},
{
"key": "Flooring",
"value": [
"Wood",
"Hard Tile",
"Tile",
"Tile - Hard, Wood"
]
},
{
"key": "Foundation",
"value": [
"Slab"
]
},
{
"key": "High School District",
"value": [
"Austin ISD"
]
},
{
"key": "Fence",
"value": [
"Cedar"
]
},
{
"key": "HOA",
"value": [
"Yes"
]
},
{
"value": [
"https://www.realtor.com/realestateandhomes-detail/1501-Barton-Springs-Rd-Apt-210_Austin_TX_78704_M87482-38640",
"https://www.realtor.com/realestateandhomes-detail/1011-Brodie-St-Apt-7_Austin_TX_78704_M86164-00814",
"https://www.realtor.com/realestateandhomes-detail/2805-Oak-Crest-Ave-2_Austin_TX_78704_M97407-82999",
"https://www.realtor.com/realestateandhomes-detail/1706-Goodrich-Ave-2_Austin_TX_78704_M91871-89217",
"https://www.realtor.com/realestateandhomes-detail/712-W-Annie-St-B_Austin_TX_78704_M76659-25767",
"https://www.realtor.com/realestateandhomes-detail/2207-Wilson-St_Austin_TX_78704_M84470-98336",
"https://www.realtor.com/realestateandhomes-detail/1702-S-Lamar-Blvd-Unit-2_Austin_TX_78704_M88342-03954",
"https://www.realtor.com/realestateandhomes-detail/1600-S-1st-St-202_Austin_TX_78704_M92885-75451",
"https://www.realtor.com/realestateandhomes-detail/1718-Valeria-St_Austin_TX_78704_M83664-49059",
"https://www.realtor.com/realestateandhomes-detail/3111-Fontana-Dr_Austin_TX_78704_M83111-24879",
"https://www.realtor.com/realestateandhomes-detail/1705-Hether-St_Austin_TX_78704_M82123-36197",
"https://www.realtor.com/realestateandhomes-detail/2505-Del-Curto-Rd_Austin_TX_78704_M86767-05333",
"https://www.realtor.com/realestateandhomes-detail/1115-Kinney-Ave-Apt-22_Austin_TX_78704_M78387-86731",
"https://www.realtor.com/realestateandhomes-detail/702-Wickford-Cir_Austin_TX_78704_M76980-41520",
"https://www.realtor.com/realestateandhomes-detail/2216-Lindell-Ave-2_Austin_TX_78704_M85945-83758",
"https://www.realtor.com/realestateandhomes-detail/4310-Jinx-Ave-2_Austin_TX_78745_M97298-31985"
],
"key": "Similar Homes For Sale"
},
{
"key": "Construction",
"value": [
"HardiplankType"
]
},
{
"key": "Cooling",
"value": [
"Central Air"
]
},
{
"key": "Water Access",
"value": [
"No"
]
},
{
"key": "Association Fee Paid",
"value": [
"Monthly"
]
},
{
"value": [
"Central Heat"
],
"key": "Heating Features"
},
{
"value": [
"C2C"
],
"key": "Source System Name"
},
{
"key": "Beds",
"value": [
"2"
]
},
{
"key": "Lot Features",
"value": [
"Back Yard"
]
},
{
"key": "Middle Or Junior School",
"value": [
"O Henry"
]
},
{
"key": "Bathrooms Total",
"value": [
"3",
"2.5"
]
},
{
"key": "Sub Type",
"value": [
"Single Family Residence",
"House"
]
},
{
"key": "Association Fee Includes",
"value": [
"See Remarks"
]
},
{
"key": "Additional Parcels",
"value": [
"false"
]
},
{
"key": "Direction Faces",
"value": [
"SE"
]
},
{
"key": "Fireplace",
"value": [
"None"
]
},
{
"value": [
"Central Air"
],
"key": "Cooling Features"
},
{
"key": "Parcel Number",
"value": [
"0100060335",
"1708 Goodrich 2"
]
},
{
"key": "School District",
"value": [
"Austin ISD"
]
},
{
"key": "Bathrooms Full",
"value": [
"2"
]
},
{
"value": [
"Center Island,Natural Stone Counters,Open to Family Room"
],
"key": "Kitchen and Dining"
},
{
"key": "Laundry Facilities",
"value": [
"Stackable W/D Connections",
"Closet",
"Electric Sryer Connection",
"Closet, Dryer Connection - Electric, Stackable W/D Connections"
]
},
{
"key": "Association",
"value": [
"Yes",
"false"
]
},
{
"value": [
"1"
],
"key": "Covered Spaces"
},
{
"key": "Gated Community",
"value": [
"No"
]
},
{
"key": "Laundry Location",
"value": [
"Laundry Closet"
]
},
{
"value": [
"Slab"
],
"key": "Foundation Details"
},
{
"key": "Exterior Features",
"value": [
"Private Yard"
]
},
{
"key": "Living",
"value": [
"1"
]
},
{
"key": "Sprinkler System",
"value": [
"Yes"
]
},
{
"value": [
"NASH JOHN SUBD NO 2"
],
"key": "Subdivision"
},
{
"key": "Sewer",
"value": [
"City at Street",
"Public Sewer"
]
},
{
"value": [
"Monthly"
],
"key": "Association Fee Frequency"
},
{
"key": "Appliances",
"value": [
"Dishwasher"
]
},
{
"key": "Heating",
"value": [
"Central Heat",
"Central"
]
},
{
"value": [
"8000.00"
],
"key": "Annual Tax Amount"
},
{
"value": [
"Kit/Din Combo"
],
"key": "Dining Room Description"
},
{
"key": "Other Structures",
"value": [
"None"
]
},
{
"key": "Unit Number",
"value": [
"2"
]
},
{
"key": "Horses",
"value": [
"No"
]
},
{
"key": "Pool Private",
"value": [
"false"
]
},
{
"key": "Buyer Brokerage Compensation",
"value": [
"3.000"
]
},
{
"key": "Community Features",
"value": [
"None"
]
},
{
"key": "Spa",
"value": [
"No"
]
},
{
"key": "Subdivision Name",
"value": [
"Nash John 02",
"NASH JOHN SUBD NO 2"
]
},
{
"key": "Waterfront",
"value": [
"No",
"false"
]
},
{
"value": [
"2"
],
"key": "Levels or Stories"
},
{
"key": "Elementary A",
"value": [
"Zilker"
]
},
{
"key": "Utilities",
"value": [
"Internet-Fiber",
"Electricity on Property",
"Internet-Cable",
"Electricity Connected"
]
},
{
"key": "Horse",
"value": [
"false"
]
},
{
"key": "Interior Features",
"value": [
"Recessed Lighting",
"High Ceilings",
"High Ceiling",
"Vaulted Ceiling",
"Wired For Security"
]
},
{
"key": "Bedrooms Total",
"value": [
"2"
]
},
{
"key": "Middle Or Junior School District",
"value": [
"Austin ISD"
]
},
{
"value": [
"NASH JOHN SUBD NO 2"
],
"key": "Source Neighborhood"
},
{
"value": [
"1st Floor Entry"
],
"key": "House Style"
},
{
"key": "Property Condition",
"value": [
"New",
"Resale"
]
},
{
"key": "Kitchen Appliances",
"value": [
"Microwave oven",
"Refridgerator",
"Cook Top Gas",
"Freestanding Range",
"Water Heater Tankless"
]
},
{
"key": "Special Listing Conditions",
"value": [
"Standard"
]
},
{
"key": "Bathrooms Half",
"value": [
"1"
]
},
{
"value": [
"Active"
],
"key": "Source Listing Status"
},
{
"value": [
"7"
],
"key": "Area"
},
{
"key": "Contact info",
"value": [
"Sign up to see info"
]
},
{
"key": "Kitchen",
"value": [
"Open to Family Room",
"Center Island",
"Natural Stone Counters"
]
},
{
"key": "Builder Name",
"value": [
"Sett",
"Sett Studio"
]
},
{
"key": "HOA Name",
"value": [
"TBD"
]
},
{
"key": "Directions",
"value": [
"Turn on Hether",
"Turn on Hether, Right on Goodrich, Home will be on your left.",
"Right on Goodrich",
"Home will be on your left."
]
},
{
"value": [
"Travis"
],
"key": "County"
},
{
"key": "Unit Style",
"value": [
"1st Floor Entry"
]
},
{
"key": "Roof",
"value": [
"Metal"
]
},
{
"key": "Water Source",
"value": [
"Public",
"City"
]
},
{
"key": "Senior High School",
"value": [
"Austin"
]
},
{
"key": "Living Area",
"value": [
"1100"
]
},
{
"key": "Elementary School District",
"value": [
"Austin ISD"
]
},
{
"key": "Sales Restrictions",
"value": [
"None"
]
},
{
"key": "Dining",
"value": [
"1"
]
},
{
"key": "New Construction",
"value": [
"Yes",
"false"
]
},
{
"key": "Patio And Porch Features",
"value": [
"None"
]
},
{
"key": "Dining Room",
"value": [
"Kitchen/Dining Combo"
]
},
{
"key": "Master Description",
"value": [
"Walk-in Shower",
"Double Vanity"
]
},
{
"key": "Auction",
"value": [
"No"
]
},
{
"key": "Baths Total",
"value": [
"3"
]
},
{
"value": [
"Garage"
],
"key": "Parking Features"
},
{
"key": "Living Rooms",
"value": [
"1"
]
},
{
"key": "Elementary School",
"value": [
"Zilker"
]
},
{
"key": "Waterfront Features",
"value": [
"None"
]
},
{
"key": "View",
"value": [
"None",
"No View"
]
},
{
"key": "Construction Materials",
"value": [
"HardiPlank Type"
]
},
{
"key": "Window Features",
"value": [
"Screens"
]
},
{
"key": "Current Price",
"value": [
"000",
"630"
]
},
{
"key": "Pool Features",
"value": [
"None"
]
},
{
"key": "Property Type",
"value": [
"Residential"
]
},
{
"key": "A/C",
"value": [
"Central Air"
]
},
{
"key": "Spa Features",
"value": [
"None"
]
},
{
"key": "FEMA Flood Plain",
"value": [
"No"
]
},
{
"key": "Year Built Exception",
"value": [
"New"
]
},
{
"key": "Guest Accommodations",
"value": [
"No"
]
}
],
"floorSizeValue": 1100,
"floorSizeUnit": "sq ft",
"geoLocation": "POINT (-97.770640 30.253540)",
"latitude": "30.253540",
"longitude": "-97.770640",
"lotSizeValue": 7666,
"lotSizeUnit": "sq ft",
"mostRecentStatus": "For Sale",
"mostRecentStatusDate": "2023-02-24T00:00:00.000Z",
"mostRecentStatusFirstDateSeen": "2023-02-24T00:00:00.000Z",
"mlsNumber": "6293857",
"neighborhoods": [
"Zilker"
],
"numBathroom": 3,
"numBedroom": 2,
"numFloor": 2,
"parking": [
"Covered Parking Spaces: 1",
"Parking Features: Garage",
"Attached",
"Garage: true",
"Garage Parking Spaces: 1",
"Attached Garage: true"
],
"phones": [
"+1 512-496-0235"
],
"postalCode": "78704",
"prices": [
{
"amountMax": 1100000,
"amountMin": 1100000,
"availability": "true",
"currency": "USD",
"dateSeen": [
"2023-02-24T11:33:00.219Z"
],
"isSold": "false",
"pricePerSquareFoot": 1000
},
{
"amountMax": 630000,
"amountMin": 630000,
"availability": "true",
"currency": "USD",
"dateSeen": [
"2020-05-16T04:21:10.253Z",
"2020-05-07T13:57:00.040Z",
"2020-05-01T07:12:50.729Z",
"2020-04-22T23:40:39.761Z"
],
"isSold": "false",
"pricePerSquareFoot": 572
}
],
"propertyTaxes": [
{
"amount": 13332.37,
"currency": "USD",
"dateSeen": [
"2023-02-24T11:33:00.174Z"
]
},
{
"amount": 8000,
"currency": "USD",
"dateSeen": [
"2020-05-16T04:21:10.245Z",
"2020-05-07T13:57:00.034Z",
"2020-04-22T23:40:39.755Z",
"2020-05-01T07:12:50.723Z"
]
}
],
"propertyType": "Single Family Dwelling",
"province": "TX",
"statuses": [
{
"date": "2020-04-29T00:00:00.000Z",
"dateSeen": [
"2020-05-07T13:57:00.000Z"
],
"firstDateSeen": "2020-04-29T00:00:00.000Z",
"lastDateSeen": "2020-04-29T00:00:00.000Z",
"type": "For Sale"
},
{
"date": "2023-02-24T00:00:00.000Z",
"dateSeen": [
"2023-02-24T11:33:00.000Z"
],
"firstDateSeen": "2023-02-24T00:00:00.000Z",
"lastDateSeen": "2023-02-24T00:00:00.000Z",
"type": "For Sale"
},
{
"date": "2020-04-22T00:00:00.000Z",
"dateSeen": [
"2020-04-23T09:12:00.000Z",
"2020-05-07T13:57:00.000Z",
"2020-04-23T20:05:00.000Z",
"2020-04-22T23:41:00.000Z",
"2020-05-01T07:13:00.000Z",
"2020-04-23T14:59:00.000Z",
"2020-05-16T04:21:00.000Z",
"2020-04-22T21:40:00.000Z",
"2020-04-24T05:11:00.000Z"
],
"firstDateSeen": "2020-04-22T00:00:00.000Z",
"lastDateSeen": "2020-04-22T00:00:00.000Z",
"type": "For Sale"
}
],
"yearBuilt": 2020,
"id": "AXGn9iLB2qQdVO6N5QwH"
}
]
}
From here, we can grab some fields that are most commonly used to compare properties:
{
"numBedroom": 2,
"numBathroom": 3,
"propertyType": "Single Family Dwelling",
"yearBuilt": 2020,
"geoLocation": "POINT (-97.770640 30.253540)"
}
There may be other fields, but let's keep it simple for now. From here, we can automatically/programmatically build a search for comparable properties:
{
"query": "numBedroom:2 AND numbBathroom:3 AND propertyType:\"Single Family Dwelling\" AND yearBuilt:>=2018 AND yearBuilt:<=2022 AND geoLocation:[-97.770640,30.253540,10,mi]",
"num_records": 100,
"format": "JSON",
"download": true
}
This will find and download 100 similar properties in a 10 mile radius. This information will contain pricing for each of these properties that will look like this:
{
...
"mostRecentPriceAmount": 415000,
"mostRecentPriceDate": "2023-02-20T21:25:20.076Z",
"mostRecentPriceFirstDateSeen": "2023-02-14T03:37:02.654Z",
...
}
You can take each of those prices, average them, and determine an expected value for the original property!
Conclusion
Hopefully this will helps you understand how to use Datafiniti Property Data to determine values for homes. There are several Datafiniti customers that take these approaches to help power business needs like lending, underwriting, and other investment decisions. Now you can too!
Updated 25 days ago