Expand Drawer

Office

GET

/trestle/odata/Office

GET

/trestle/rets/search?SearchType=Office&Class=Office

info icon

OfficeKey is the primary key and uniquely identifies records in the Office resource.

info icon

The following fields are considered InKeyIndex fields and may be queried in batches up to 300,000 at a time: ModificationTimestamp, OfficeKey, OfficeMlsId.

Fields

Field Type Size Description
BillingOfficeKey String 300 This is the office that will be billed (e.g., corporate headquarters).
FranchiseAffiliation String 50 The name of the franchise to which the broker/office is contracted.
FranchiseNationalAssociationID String 30 The national association ID of the franchise (i.e., in the U.S., this is the NRDS number).
HumanModifiedYN Boolean HumanModifiedYN
IDXOfficeParticipationYN Boolean Does the Office/Broker participate in IDX.
MainOfficeKey String 20 OfficeKey of the Main Office in a firm/company of offices. This is a self referencing foreign key relating to this resource's OfficeKey. This key may be the same value as the OfficeKey for a given record if the given office is the Main Office.
MainOfficeKeyNumeric Int32 4 MainOfficeKeyNumeric
MainOfficeMlsId String 25 OfficeMlsId of the Main Office in a firm/company of offices.
ModificationTimestamp InKey DateTimeOffset Date/time the roster (member or office) record was last modified.
NumberOfBranches Int32 4 The calculated value for the number of active branches. The count for multiple related offices.
NumberOfNonMemberSalespersons Int32 4 The total number of active salespersons that are not a member of the national association.
OfficeAddress1 String 50 The street number, direction, name and suffix of the office.
OfficeAddress2 String 50 The unit/suite number of the office.
OfficeAlternateId String 50 This is an alternate ID with no specific use.
OfficeAOR AOR Enum The Office's Board or Association of REALTORS.
OfficeAORkey String 255 A system unique identifier. Specifically, in aggregation systems, the OfficeAORkey is the system unique identifier from the system that the record was retrieved. This may be identical to the related xxxId. This is a foreign key relating to the AOR's member management system in which the record was originated.
OfficeAORkeyNumeric Int32 4 OfficeAORkeyNumeric
OfficeAORMlsId String 25 The local, well-known identifier for the office's Association of REALTORS. This value may not be unique, specifically in the case of aggregation systems, this value should be the identifier from the original system.
OfficeAssociationComments String 500 Notes relating to the office.
OfficeBranchType OfficeBranchType Enum The level of the office in the hierarchy of Main, Branch, Stand Alone, etc.,
OfficeBrokerKey String 255 The MemberKey of the responsible/owning broker. This is a foreign key relating to the Member resource's MemberKey.
OfficeBrokerKeyNumeric Int32 4 OfficeBrokerKeyNumeric
OfficeBrokerMlsId String 25 The MemberMlsId of the responsible/owning broker.
OfficeBrokerNationalAssociationID String 50 The national association ID of the broker (i.e., in the U.S., this is the NRDS number).
OfficeCity String 50 The city of the office.
OfficeCityRegion String 150 OfficeCityRegion
OfficeCorporateLicense String 50 When an office/firm is a corporation, an independent license number is issued.
OfficeCountry Country Enum The office's country code for the street address.
OfficeCountyOrParish String 50 The county or parish in which the offices is located.
OfficeEmail String 80 The email address of the office
OfficeFax String 16 North American 10 digit phone numbers should be in the format of ###-###-#### (separated by hyphens). Other conventions should use the common local standard. International numbers should be preceded by a plus symbol.
OfficeKey Key InKey String 20 A system unique identifier. Specifically, in aggregation systems, the Key is the system unique identifier from the system that the record was just retrieved. This may be identical to the related xxxId identifier, but the key is guaranteed unique for this record set.
OfficeKeyNumeric Int32 4 OfficeKeyNumeric
OfficeMailAddress1 String 100 The street number, direction, name and suffix of the member.
OfficeMailAddress2 String 100 The unit/suite number of the member.
OfficeMailCareOf String 50 The care of (c/o) for the office's mailing address.
OfficeMailCity String 50 The office's city for the mailing address.
OfficeMailCountry Country Enum The office's country code for the mailling address.
OfficeMailCountyOrParish String 50 The office's county of the mailing address.
OfficeMailPostalCode String 10 The postal code of the office's mailing address.
OfficeMailPostalCodePlus4 String 10 The four-digit extension of the U.S. ZIP Code.
OfficeMailStateOrProvince StateOrProvince Enum The office's state or province of the mailing address.
OfficeManagerKey String 255 The lead Office Manager for the given office. This is a foreign key relating to the Member resource's MemberKey.
OfficeManagerKeyNumeric Int32 4 OfficeManagerKeyNumeric
OfficeManagerMlsId String 25 The lead Office Manager for the given office.
OfficeMlsId InKey String 25 The local, well-known identifier. This value may not be unique, specifically in the case of aggregation systems, this value should be the identifier from the original system.
OfficeName String 255 The legal name of the brokerage.
OfficeNationalAssociationId String 25 The national association ID of the office. i.e. in the U.S. is the NRDS number.
OfficeNationalAssociationIdInsertDate DateTime The date the office record was initally created in the national association's database (e.g., the date the record was added to NRDS in the U.S.).
OfficePhone String 16 North American 10 digit phone numbers should be in the format of ###-###-#### (separated by hyphens). Other conventions should use the common local standard. International numbers should be preceded by a plus symbol.
OfficePhoneExt String 10 The extension of the given phone number (if applicable).
OfficePostalCode String 10 The postal code of the office.
OfficePostalCodePlus4 String 4 The extension of the postal/zip code. i.e. +4
OfficePreferredMedia PreferredMedia Enum The method the office prefers to receive media.
OfficePrimaryAorId String 30 The primary association of REALTORS® (AOR) associated with the member. This may be another AOR where the member has their primary membership.
OfficePrimaryStateOrProvince StateOrProvince Enum The office's primary state or province.
OfficeStateOrProvince StateOrProvince Enum The state or province in which the office is located.
OfficeStatus OfficeStatus Enum Is the office active, inactive or under disciplinary action.
OfficeStreetAdditionalInfo String 50 OfficeStreetAdditionalInfo
OfficeType OfficeType Enum The type of business conducted by the office. i.e. Real Estate, Appraiser, etc.
OriginalEntryTimestamp DateTimeOffset Date/time the roster (member or office) record was originally input into the source system.
OriginatingSystemID String 25 The RESO OUID's OrganizationUniqueId of the Originating record provider. The Originating system is the system with authoritative control over the record. For example; the name of the MLS where the office was input. In cases where the Originating system was not where the record originated (the authoritative system), see the Originating System fields.
OriginatingSystemMainOfficeKey String 255 OriginatingSystemMainOfficeKey
OriginatingSystemName String 255 The name of the Originating record provider. Most commonly the name of the MLS. The place where the office is originally input by the member. The legal name of the company.
OriginatingSystemOfficeBrokerKey String 50 OriginatingSystemOfficeBrokerKey
OriginatingSystemOfficeKey String 255 The system key, a unique record identifier, from the Originating system. The Originating system is the system with authoritative control over the record. For example, the Multiple Listing Service where the office was input. There may be cases where the Source System (how you received the record) is not the Originating System. See Source System Key for more information.
OriginatingSystemOfficeManagerKey String 50 OriginatingSystemOfficeManagerKey
OriginatingSystemSubName String 255 OriginatingSystemSubName
OtherPhone String 30 North American 10-digit phone numbers should be in the format of ###-###-#### (separated by hyphens). Other conventions should use the common local standard. International numbers should be preceded by a plus symbol.
Permission Permission Enum Permission
PermissionPrivate String 8000 PermissionPrivate
SocialMediaType SocialMediaType Enum A list of types of sites, blogs and social media the office URL or ID is referring to (e.g., Website, Blog, Facebook, Twitter, LinkedIn, Instagram).
SourceSystemID String 25 The RESO OUID's OrganizationUniqueId of the Source record provider. The source system is the system from which the record was directly received. In cases where the source system was not where the record originated (the authoritative system), see the Originating System fields.
SourceSystemName String 255 The name of the immediate record provider. The system from which the record was directly received. The legal name of the company.
SourceSystemOfficeKey String 255 The system key, a unique record identifier, from the Source System. The Source System is the system from which the record was directly received. In cases where the Source System was not where the record originated (the authoritative system), see the Originating System fields.
SyndicateAgentOption SyndicateAgentOption Enum A list of options allowing the broker to pass the decision of syndication choice down to the listing agents. i.e. No Agent Choice, Allow Agent Choice, Restrict Agent Choice, etc.
SyndicateTo SyndicateTo Enum The principal broker's choice on where they would like their listings syndicated. i.e. Zillow, Trulia, Homes.com, etc.
VirtualOfficeWebsiteYN Boolean Indicates whether or not this is a Virtual Office Website (VOW).

Expands

Name Target
BuyerOfficeProperties Property
CoBuyerOfficeProperties Property
CoListOfficeProperties Property
ListOfficeProperties Property