Property Data Schema

The property data schema below lists all available fields in a property record. Note that actual property records (actually, most of them) may not have every field present.

Field NameExample Value (in JSON)Description
address"address": "7206 Walling Ln"The physical street address for this property.
Field type: text
brokers"brokers": [ { "agent": "Frances Zuckerman", "company": "Fillmore", "dateSeen": "2017-01-17T09:47:16Z", "emails": [ "[email protected]" ], "licenseNumber": "XXXX #0171717" "phones": [ "3214561234" ] } ]A list of brokers that have represented this property over time. Each broker may contain:
Field type: nested

agent: The name of the real estate agent representing this property.
Field type: text

company: The company this agent works for (or the company representing this property).
Field type: text

dateSeen: The date this agent/company was seen representing the property.
Field type: date

emails: A list of email addresses associated with the agent or company.
Field type: keyword

licenseNumber: The license number of the agent representing the property.
Field type: text

phones: A phone number associated with the agent or company.
Field type: keyword

websites: A list of websites associated with the agent or company.
Field type: keyword
buildingName"buildingName":"Castle Beach Club"The name of the building where this property is located. This field is specific to apartments, condos, and similar property types.
Field type: text
city"city": "Dallas"The city where the property is located.
Field type: text
country"country": "US"The two-letter country code for the business location's country.
Field type: text
dateAdded"dateAdded": "2017-01-08T19:12:13Z"The date this property was first added to the property database.
Field type: date
dateUpdated"dateUpdated": "2017-01-08T19:12:13Z"The most recent date this property was updated or seen by our system.
Field type: date
deposits"deposits": [ { "amount": 104, "currency": "USD", "dateSeen": [ "2016-08-07T18:07:05Z" ], } ]A list of deposit fees that have been seen for this property. Each deposit contains:
Field type: nested

amount: The fee amount.
Field type: float

currency: The currency for the amount.
Field type: keyword

dateSeen: A list of dates this deposit fee was seen.
Field type: date
descriptions"descriptions": [ { "dateSeen": "2016-08-07T18:07:05Z", "value": "charming starter home priced to sell. full finished basement with bath and with separate entrance." } ]A list of descriptions for this property from various sources. Each description contains:
Field type: nested

dateSeen: The date when this description has been seen for this property.
Field type: date

value: A unique description for this property.
Field type: text
domains"domains": [ ""www.airbnb.com" ]A list of each unique domain found in the sourceURLs field.
Field type: domain
features"features": [ { "key": "Community District", "replace": "true", "value": [ "318" ] } ]A list of features associated with this property. The feature list can be collected from specific feature sections available on listings for this property. It can also serve as a catch-all field for miscellaneous characteristics of this property that don't make sense to include as top-level fields.
Field type: nested

Each feature contains:
key: A label for this feature.
Field type: text

replace: Flag indicating value field is replaced versus appended.
Field type: boolean

value: A list of possible values for this feature.
Field type: text
fees"fees": [ { "amountMax": 11, "amountMin": 11, "currency": "USD", "dateSeen": [ "2016-08-07T18:07:05Z" ], "type": "Cleaning Fee" } ]A list of various fees that have been seen for this property. Each fee will contain:
Field type: text

amountMax: The minimum fee value listed.
Field type: float

amountMin: The maximum fee value listed.
Field type: float

currency: The currency listed for amountMin and amountMax
Field type: keyword

dateSeen: A list of dates when this fee was seen.
Field type: date

type: A classification value for the fee.
Field type: text
floorSizeValue"floorSizeValue": 947The size of the walkable area of the property. For apartments and condos, this is the size of the property. For homes and buildings, this is the combined size of each floor and does not include lot size.
Field type: float
floorSizeUnit"floorSizeUnit": "Sq. ft"The units of measurement for floorSize.
Field type: keyword
geoLocation"geoLocation": "POINT (-119.5094 37.229366)"A location value that stores the latitude and longitude in a format that allows geospatial querying.
Field type: geo_shape

The value is stored as Well-Known Text format, which resembles an (x, y) value, i.e. (longitude latitude).
imageURLs"imageURLs": [ "http://image.rent.com/imgr/61bbc9f535f0e180bc804ac8f4c50067" ]A list of image URLs for this property.
Field type: keyword
keys"keys": [ "us/ca/nhills/9411brightwoodct" ]A list of internal Datafiniti identifiers for this property. The keys field is used to merge raw data from individual sources into the master Datafiniti record. Learn how this works
Field type: keyword
languagesSpoken"languagesSpoken: [ "French", "English" ]A list of the languages spoken at this property.
Field type: text
latitude"latitude": "32.860858"The latitude coordinates for this property.
Field type: text
leasingTerms"leasingTerms: [ { "dateSeen": "2016-07-30T20:41:01Z", "value": "12 Months" } ]A list of leasing terms that have been associated with this property. Each leasing term will contain:
Field type: nested

dateSeen: The date when this term was seen.
Field type: date

value: The leasing term description.
Field type: text
listingName"listingName": "Antico Appartamento"The name of the property listing. This isn't the name of the building. It's a descriptive name supplied for the listing itself.
Field type: text
longitude"longitude": "-96.735808"The longitude coordinates for this property.
Field type: text
lotSizeValue"lotSizeValue": 2219The lot size for the property. This is the ground area covered by the property.
Field type: integer
lotSizeUnit"lotSizeUnit": "Sq. ft"The units of measurement for lotSize.
Field type: keyword
managedBy"managedBy": [ { "dateSeen": [ "2016-03-03T15:02:13Z" ], "value": "ROM Investments" } ]A list of companies or people that have managed this property. Each managedBy object will contain:
Field type: nested

dateSeen: A list of dates when this information was seen.
Field type: date

value: The name of the company or person.
Field type: text
mlsNumber"mlsNumber": "16177277"The MLS number for the property. Learn more about MLS numbers.
Field type: keyword
mostRecentPriceAmount"mostRecentPriceAmount": 85The product's most recent price amount scraped.
Field type: BigDecimal
mostRecentPriceCurrency"mostRecentPriceCurrency": "USD"The currency listed for mostRecentPriceAmount.
Field type: text
mostRecentPriceDomain"mostRecentPriceDomain": "www.nordstrom.com"The domain of the most recent price scraped by Datafiniti
Field type: domain
mostRecentPriceDate"mostRecentPriceDate": "2022-03-29T19:26:49.157Z"The most recent price date of the product record.
Field type: date
mostRecentStatus"mostRecentStatus": "For Sale"The most recent value for statuses.type for this property. See possible values here.
Field type: keyword
mostRecentStatusDate"mostRecentStatus": "2017-01-10T20:12:16Z"The date that corresponds to the mostRecentStatus for this property.
Field type: date
mostRecentStatusFirstDateSeen"mostRecentStatusFirstDateSeen": "2021-09-09T00:00:00.000"This date corresponds to the earliest date seen from the source of the property listing.
Field type: date
neighborhoods"neighborhoods": [ "Canarsie" ]A list of neighborhoods where this property is located. Sometimes an area can belong to multiple neighborhoods, which is why this field is a list.
Field type: text
numBathroom"numBathroom": 1.25The number of bathrooms in this property. Can be a whole number (e.g. "1") or a float (e.g., 1.25).
Field type: float
numBedroom"numBedroom": 3The number of bedrooms in this property.
Field type: integer
numFloor"numFloor": 2The number of floors or stories in this property.
Field type: integer
numPeople"numPeople": 6The number of people that can occupy this property.
Field type: integer
numRoom"numRoom": 2The number of rooms in this property.
Field type: integer
numUnit"numUnit": 1The number of units available in this property.
Field type: integer
parking"parking": [ "Garage" ]A list of details regarding parking at this property.
Field type: text
paymentTypes"paymentTypes": [ "Visa" ]A list of payment options accepted by the property.
Field type: text
people"people": [ { "dateSeen": "2017-06-11T11:40:54Z", "name": "Pulcano Yvonne", "title": "Owner" } ]A list of known people associated with or employed by this property.
Field type: nested

Each person may contain:
dateSeen: The date when this person was seen.
Field type: date

email: The person's email.
Field type: text

name: The person's name.
Field type: text

phone: The person's phone number.
Field type: text

title: The person's title.
Field type: text
petPolicy"petPolicy": "Pets are not allowed."The pet policy for the property.
Field type: text
phones"phones": [ "5058982700" ]A list of phone numbers for the property.
Field type: keyword
postalCode"postalCode": "75231"The postal or zip code of the property.
Field type: keyword
prices"prices": [ { "amountMax": 289000, "amountMin": 289000, "availability": "true", "comment": ""Listed by Awaye Realty Management", "currency": "USD", "date": "2017-10-21T00:00:00Z", "dateSeen": [ "2017-10-09T00:00:00Z" ], "isSale": "false", "isSold": "false", "pricePerSquareFoot": 197, }, { "amountMax": 817, "amountMin": 817, "currency": "USD", "dateSeen": [ "2016-01-20T00:00:00Z" ], "isSale": "false", "minStay": "7 nights", "period": "Per week", } ]A list of prices for this property.
Field type: nested

Price objects may contain:
amountMin: The minimum price value listed.
Field type: float

amountMax: The maximum price value listed. This is typically the same as amountMin, except in cases where a price range is listed.
Field type: float

availability: The property's availability at this price.
Field type: keyword

comment: A note related to this price.
Field type: text

currency: The currency listed for amountMin and amountMax.
Field type: text

date: A list of date when the property was set to this price.
Field type: date

dateSeen: A list of dates when this price was seen.
Field type: date

dateValidStart: The date when this price becomes valid.
Field type: date

dateValidEnd: The date when this price is no longer valid.
Field type: date

isSale: A true/false for whether or not this is a sale price.
Field type: boolean

isSold: A true/false for whether or not this is the sold price.
Field type: boolean

minStay: The minimum length of stay required for this price.
Field type: text

period: The calendar period for which this price is valid.
Field type: text

pricePerSquareFoot: The price divide by the square footage.
Field type: float
propertyTaxes"propertyTaxes": [ { "amount": 1582, "currency": "USD", "dateSeen": [ "2016-08-09T09:34:15Z" ], } ]A list of property taxes that have been seen for this property. Each property tax will include:
Field type: nested

amount: The tax amount.
Field type: float

currency: The amount's currency.
Field type: text

dateSeen: A list of dates when this tax has been seen for this property.
Field type: date
propertyType"propertyType": "Condo"A classification for the property type. See possible values here.
Field type: text
province"province": "TX"The province or state for this property.
Field type: text
reviews"reviews": [ { "dateSeen": "2016-08-17T00:00:00Z", "text": "We love this place a lot!", "username": "Yuwei" } ]A list of reviews for this property.
Field type: nested

Review objects may contain:
date: The date the review was posted.
Field type: date

dateSeen: The date when the review was seen by Datafiniti.
Field type: date

doRecommend: A true/false for whether or not the reviewer recommends the product.
Field type: boolean

rating: A 1 to 5 star value for the review.
Field type: float

text: The full (or available) text of the review.
Field type: text

title: The review's title.
Field type: text

userCity: The reviewer's city.
Field type: text

username: The reviewer's username.
Field type: text

userProvince: The reviewer's province or state.
Field type: text
rules"rules": [ "No smoking" ]A list of rules for living or staying at this property.
Field type: text
statuses"statuses": [ { "dateSeen": [ "2017-10-10T20:12:16Z" ], "date": "2017-01-10T20:12:16Z", "isUnderContract": "false", "type": "Sold" } ]A list of statuses for this property. This field is used to indicate when the property is for sale, etc.
Field type: nested

Each status includes:
date: Date the status occurred
Field type: date

dateSeen: A list of dates when this status was seen by Datafiniti.
Field type: date

isUnderContract: A true/false value to indicate if this status is under contract.
Field type: boolean

type: The status. See possible values here.
Field type: keyword
taxID"taxID": "30-9011-019-0029758"The tax ID for the property.
Field type: keyword
transactions "transactions": [ { saleDate: 2023-01-04T12:00:00Z, firstDateSeen: 2023-01-04T12:00:00Z, lastDateSeen: 2023-01-04T12:00:00Z, documentType: Warranty Deed, price: 112900.00, sellerFirstName: Anita, sellerMiddleName: Brian, sellerLastName: Powell, buyerFirstName: Ben, buyerMiddleName: Cherelle, buyerLastName: Emaline, lenderName: Ameris Bank, loanType: Conventional, loanAmount: 10725.00, mortgageTerm: 360, interestType: Adjustable, parcelNumber: 17-07-26-0-001-005.000, ownerType: Company, contactOwnerMailAddressFull: 2337 JULIAN DR } ], county: Calhoun, countyFIPS: 1015, subdivision: Crescent Heights Sub, congressionalDistrictHouse: 4, legalDescription: SEC 26 TSP 15S RNG 07E, legalRange: 08E, currentOwnerType: Company, instrumentNumber: 3312-0576 } ]A list of transactional data for this property. This field is used to indicate when the property was purchased and by who.
Field type: nested

Each transaction includes:
saleData: Date the when transaction occurred
Field type: date

firstDateSeen: Earliest date seen from the source of the property listing by Datafiniti.
Field type: date

lastDateSeen: Latest date seen from the source of the property listing by Datafiniti.
Field type: date

documentType: Contains all documents attached in this transaction.
Field type: string

price: Price of the property for this transaction.
Field type: double

sellerFirstName: First name of the seller.
Field type: string

sellerMiddleName: Middle name of the seller.
Field type: string

sellerLastName: Last name of the seller.
Field type: string

buyerFirstName: First name of the buyer.
Field type: string

buyerMiddleName: Middle name of the buyer.
Field type: string

buyerLastName: Last name of the buyer.
Field type: string

lenderName: Name of the lender.
Field type: string

loanType: Type of loan for this transaction.
Field type: string

loanAmount: Loan amount by lending company.
Field type: double

mortgageTerm: Length in months of the loan.
Field type: integer

interestType: interest rate by the lender.
Field type: string

parcelNumber: Number parcel was created.
Field type: string

ownerType: Type of owner for transaction.
Field type: string

contactOwnerMailAddressFull: Mailing address of the owner of the property.
Field type: string

county: County of the property.
Field type: string

countyFIPS: County FIPS # of the property.
Field type: integer

subdivision: Subdivision / neighborhood of the property.
Field type: string

congressionalDistrictHouse: District of the property.
Field type: string

legalDescription: Legal description of the property.
Field type: string

legalRange: Legal range of the property.
Field type: string

currentOwnerType: Current owner type of the property.
Field type: string

instrumentNumber: Instrument # of the property.
Field type: string
websiteIDs"websiteIDs": [ "domain.com-123", "website.com-4567" ]A list of website IDs for this product. Website IDs are tied to a specific online retailer. They are the unique identifier used by website. They are used by Datafiniti when other unique identifiers are not available for a product.
Field type: keyword
yearBuilt"yearBuilt": 2021The year the property was built.
Field type: integer