twitter youtube  facebook  linkedin 

You are here: Home | News | Listing Status Update for SFARMLS

Listing Status Update for SFARMLS

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.

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). 

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.

Real Estate Industry News

Daily News

24 May 2019

Upcoming Events

You are here: Home | News | Listing Status Update for SFARMLS