Property
The Property Resource includes fields commonly used in a Multiple Listing Service (MLS) listing.
See the Property Resource in the RESO Data Dictionary.
Please note that an update to a photo or document for a listing will only update the PhotosChangeTimestamp or DocumentsChangeTimestamp fields. The listing ModificationTimestamp will not be updated in this case.
The ModificationTimestamp is changed when the core listing data is changed only.
The Amplify system does not update a listings ModificationTimestamp if the only change is to a media record (photos or documents).
Property Child Associations
The Property entity has three one-to-many child associations:
Rooms→PropertyRoomsMedia→MediaOpenHouses→OpenHouse
These are exposed as OData navigation properties and may be queried using $expand. Each child entity also maintains a navigation property back to its parent Property.
Examples
Remember to URL Encode query string values prior to sending HTTP requests. To aid with readability, the URLs in this document are displayed without URL encoding and wrapped over multiple lines.
Retrieve a Property by ListingKey
This query will retrieve the Property with a ListingKey equal to 123456:
https://query.ampre.ca/odata/Property('123456')
Retrieve Available Properties by ModificationTimestamp
This query will retrieve all Properties that are currently Available and have been modified after a specific date and time:
https://query.ampre.ca/odata/Property
?$filter=ContractStatus eq'Available'
and ModificationTimestamp ge 2023-07-27T04:00:00Z
&$orderby=ModificationTimestamp,ListingKey
Retrieve Properties and their child association entities
This query will retrieve a set of Properties and their child association entities
https://query.ampre.ca/odata/Property
?$count=true&$top=50
&$expand=Media($select=MediaKey,MediaModificationTimestamp,MediaURL,MediaType;$filter=MediaType eq 'image/jpeg'),Rooms($select=RoomKey,RoomType,ListingKey;$filter=RoomType eq 'Kitchen'),OpenHouses($select=OpenHouseDate)
&$select=Latitude,ListPrice,Longitude,ListingKey,ListingContractDate,ModificationTimestamp,StandardStatus
&$orderby=ModificationTimestamp desc