For fetching the Off_Market Listing what is the Parameter?

asked 2022-07-14 10:18:22 -0500

updated 2022-07-14 15:03:23 -0500

Right now we are fetching only sold and active properties using below parameter. For Active - "L_StatusCatID"= "1" For Sold - "L_StatusCatID"= "2" So please can you please let me know how can I fetch other status properties from Rets Connector Except Active and Sold.

edit retag flag offensive close merge delete


Many times the RETS feed is configured to only allow certain status values based on the MLS.
You can find all of the various status values available for a MLS by looking at the RETS Metadata.
The feed may only allow a few, but you can put each one in a query to see if data is availble.
Or you can ask the MLS which ones your feed allows.
Without the login URL and account name I can't check to see.

bwolven gravatar imagebwolven ( 2022-07-14 17:59:42 -0500 )edit

We are using below Login URL and UserName "LoginUrl": "", "Username": "genreal",

Rakhesh Kumar gravatar imageRakhesh Kumar ( 2022-07-15 09:36:50 -0500 )edit

You can use a query like this: ~(L_StatusCatID=|1,2) to exclude those status values.
Or you can query the L_Status field for finer status value filtering.
So for example you can use (L_Status=|1_3) to pull "Withdrawn/Off-Market" properties on Yuma.

bwolven gravatar imagebwolven ( 2022-07-15 10:19:41 -0500 )edit

we are able to fetch Sold, Active, CONTINGENCY, WITHDRAWN/OFF_MARKET, U/C - TAKE BACK UPS, Please let me know how can I fetch the Cancelled and Expired.

Rakhesh Kumar gravatar imageRakhesh Kumar ( 2022-07-18 13:01:53 -0500 )edit

Expired: (L_Status=|4_0)
Cancelled: (L_Status=|5_1)

bwolven gravatar imagebwolven ( 2022-07-18 18:04:00 -0500 )edit

Were you able to get this working?

bwolven gravatar imagebwolven ( 2022-07-26 04:37:41 -0500 )edit

No We are not able could you help on that? what else we can do?

Rakhesh Kumar gravatar imageRakhesh Kumar ( 2022-07-27 07:17:19 -0500 )edit

I'm not sure exactly what you are still wanting to do?
A Query like: (L_Status=|4_0,5_1) would return Cancelled and Expired using your account.
What exactly are you having trouble with?

bwolven gravatar imagebwolven ( 2022-07-28 09:52:16 -0500 )edit