RELEASE DATE TUESDAY JANUARY 8, 8:00pm PST !! - UPDATE COMPLETE
On the night of January 8th 2019, SFARMLS will be converting the Listing Statuses (in all data, past and present)
to the recognized RESO Status List extended by the RESO Special Listing Conditions field. You will see these changes
when you open SFARMLS on Wednesday January 9th, 2019.
to the recognized RESO Status List extended by the RESO Special Listing Conditions field. You will see these changes
when you open SFARMLS on Wednesday January 9th, 2019.
Our new status labels more closely match the language you are using day-to-day and will provide you with the vocabulary to talk about listings data with other real estate agents regionally, nationally, and even globally. This Status Translation Table is explained in text below the table.
STATUS TRANSLATION TABLE
|
Current Status |
Code |
New RESO Status |
Code |
Special Listing Conditions |
|
Active |
A |
Active |
A |
|
|
Active Cont. Rel. Clause Active Cont. Show Active Cont. Short Sale Active Cont. Probate Active Cont. No Show |
E C D G F |
Contingent - Show Contingent - Show Contingent - No Show Contingent - No Show Contingent - No Show |
U U F F F |
+ Release Clause – RCLS .. + Short Sale – SHSL + Probate – PROB .. |
|
Pending |
P |
Pending |
P |
|
|
Withdrawn Cancel |
W |
Canceled |
C |
|
|
Sold |
S |
Closed |
S |
|
|
Leased |
L |
Closed |
S |
|
|
Withdrawn Duplicate |
Q |
Duplicate Canceled |
D |
|
|
Expired |
X |
Expired |
X |
|
|
Temp Off Market |
T |
Hold |
H |
|
|
Coming Soon |
Z |
Coming Soon |
Z |
|
When mapping, if you do not have an accurate way to capture the two Contingent Statuses, please make sure you map them as follows:
Contingent – Show :: Map to your Active status, make sure you show any of the selected Special Listing Conditions
Contingent – No Show :: Map to your Inactive (or Pending) status, make sure you show any of the selected Special Listing Conditions
PROJECT SUMMARY
While SFARMLS has successfully differentiated itself from less innovative MLSs with several ambitious initiatives, the core MLS application has changed relatively little. Recognizing that this has to change, SFAR has embarked on a major project updating the way listing data is organized, stored and used inside the MLS application you use today. Fixing the data is the first piece of this complex puzzle of modernizing and updating the applications you need in order to be a successful agent. There is no better way to do this than to implement changes based on the work done by the Real Estate Standards Organization (RESO).
This means that our listing data types, listing statuses and data fields will be changing in ways you will clearly see in your day to day use of the MLS. For the technical out there, this means that SFARMLS will be 100% RESO standards compliant natively in the database, and by extension, in the system that is used to send data to Brokerages, Vendors, and MLS partners in the Bay Area (such as BAREIS in Marin and MLSListings in San Mateo).
This means that our listing data types, listing statuses and data fields will be changing in ways you will clearly see in your day to day use of the MLS. For the technical out there, this means that SFARMLS will be 100% RESO standards compliant natively in the database, and by extension, in the system that is used to send data to Brokerages, Vendors, and MLS partners in the Bay Area (such as BAREIS in Marin and MLSListings in San Mateo).
NOTES FOR BROKERS & AGENTS
- Brokers and Office Managers: you will need to make sure your technology providers are aware of these changes. We have reached out to them via contact information they provided during setup, but this sometimes changes and you are responsible for ensuring they are aware of how these changes could impact you.
- Your internal reporting may still use the previous terms without penalty. If you wish to continue calling listings "SOLD" instead of "CLOSED" on your internal brokerage reporting that is fine. SFARMLS (and staff) will use the RESO standards status "CLOSED" going forward.
NOTES FOR VENDORS
- Because listing status codes are frequently used in structured RETS queries (DMQL) it is critical that you analyze these changes against your system configuration to see if any changes will be required the night we convert (January 8th to 9th).
- Be aware of some transposed values (codes) in the above table: "C" used to mean "continue to show" and now it means "canceled" (dramatically differnet meaning) so be careful when updating your system.
- Some of the existing status information you may have been capturing from our MlsStatus field is now contained in a field called SPLC (Special Listing Conditions) which may require you to adjust your software/app or data processor(s).
- You are not required to adopt these status names in the display side of your applications on the date of conversion, but SFARMLS recommends you begin looking at any changes in the application you need to align your products with these permanent changes.
- If you have not received a notification about these changes directly via email, you may not have current or correct contact information stored in the SFARMLS RETS system. This email address is being protected from spambots. You need JavaScript enabled to view it. to update your contact information.
DESCRIPTIONS OF SPECIAL LISTING CONDITIONS
The complete list of new “Special Listing Conditions” values that agents can set on a listing’s status are as follows:
| CONDITION | CODE | DESCRIPTION |
| Auction | AUCT | Listing being marketed at Auction. |
| Housing Assist Program | HAPG | Listing is included in the Housing Assistance Program. |
| HUD Owned | HUDO | Listing is HUD owned property (see also Real Estate Owned). |
| Notice Of Default | NOTD | Listing property is subject to a Notice of Default. |
| Pending Litigation | PEND | Listing has a litigation pending. |
| Probate Listing | PROB | Listing is in probate. |
| Real Estate Owned | REOO | Listing is Real Estate Owned, includes “Bank Owned”. |
| Release Clause | RCLS | Listing offer is subject to a release clause. |
| Short Sale | SHSL | Listing is a short sale. |
| Subj to Court Confrm | CRTC | Listing transfer subject to a Court Confirmation. |
| Subj to Lender Confrm | LNDC | Listing transfer subject to a Lender Confirmation. |
| Succssr Trustee Sale | STRS | Listing is a Successor Trustee Sale. |
| None | NONE | Listing has no Special Listing Conditions (this is the default). |
| Other | OTHR | Listing has a Special Listing Condition not detailed above that must be described clearly in the Agent-Only Remarks section. |
