Ask Your Question

For fetching the Off_Market Listing what is the Parameter?

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

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

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 -0600 )edit

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

Rakhesh Kumar gravatar imageRakhesh Kumar ( 2022-07-15 09:36:50 -0600 )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 -0600 )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 -0600 )edit

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

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

Were you able to get this working?

bwolven gravatar imagebwolven ( 2022-07-26 04:37:41 -0600 )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 -0600 )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 -0600 )edit

1 Answer

Sort by ยป oldest newest most voted

answered 2022-08-24 09:04:15 -0600

Thanks now we are able to get the properties

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2022-07-14 10:18:22 -0600

Seen: 60 times

Last updated: Jul 14 '22