properties_all

The properties_all_nested view will display all available fields in our Property Data Schema.

If using the csv format, it will keep all elements in multi-valued field lists in a single cell. This means a field like reviews will show up as a nested JSON object within the CSV.

Included Fields

Field	Included Sub-fields
`address`	N/A
`availableDates`	`dateSeen` `endDate` `sourceURLs` `startDate`
`brokers`	`agent` `company` `dateSeen` `emails` `phones` `websites`
`buildingName`	N/A
`city`	N/A
`country`	N/A
`dateAdded`	N/A
`dateUpdated`	N/A
`deposits`	`amount` `currency` `dateSeen` `sourceURLs`
`descriptions`	`dateSeen` `sourceURLs` `value`
`features`	`key` `value`
`fees`	`amountMax` `amountMin` `currency` `dateSeen` `sourceURLs` `type`
`floorSizeValue`	N/A
`floorSizeUnit`	N/A
`hours`	`day` `hour`
`imageURLs`	N/A
`keys`	N/A
`languagesSpoken`	N/A
`latitude`	N/A
`leasingTerms`	`dateSeen` `sourceURLs` `value`
`listingName`	N/A
`longitude`	N/A
`lotSizeValue`	N/A
`lotSizeUnit`	N/A
`managedBy`	`dateSeen` `sourceURLs` `value`
`mlsNumber`	N/A
`nearbySchools`	`assigned` `address` `city` `country` `dateSeen` `distanceValue` `distanceUnit` `faxes` `gradeLevels` `name` `phones` `postalCode` `province` `sourceURLs`
`neighborhoods`	N/A
`numBathroom`	N/A
`numBedroom`	N/A
`numFloor`	N/A
`numPeople`	N/A
`numRoom`	N/A
`numUnit`	N/A
`parking`	N/A
`paymentTypes`	N/A
`people`	`dateSeen` `email` `name` `phone` `title`
`petPolicy`	N/A
`phones`	N/A
`postalCode`	N/A
`prices`	`amountMin` `amountMax` `availability` `comment` `currency` `date` `dateAdded` `dateSeen` `dateValidStart` `dateValidEnd` `isSale` `minStay` `period` `pricePerSquareFoot` `sourceURLs`
`propertyTaxes`	`amount` `currency` `dateSeen` `sourceURLs`
`propertyType`	N/A
`province`	N/A
`reviews`	`date` `dateAdded` `dateSeen` `doRecommend` `rating` `sourceURLs` `text` `title` `userCity` `username` `userProvince`
`rules`	N/A
`sourceURLs`	N/A
`statuses`	`dateSeen` `isUnderContract` `sourceURLs` `type`
`taxID`	N/A
`unavailableDates`	`dateSeen` `endDate` `sourceURLs` `startDate`
`websiteIDs`	N/A

Sample CSV Output

Right-click and choose "Save link as..." to download this sample so you can see it in Excel: properties_all-CSV-example.csv

Included Fields

Sample CSV Output

Sample JSON Output