First time here? Check out the FAQ!

How to get How sold data

  • retag add tags

Hi team,

We are unable to fetch the sold status data from paragonrels.


User Name - genreal

image description

Rakhesh Kumar's avatar
Rakhesh Kumar
asked 2023-05-19 07:46:41 -0500
bwolven's avatar
updated 2023-05-25 04:34:01 -0500
edit flag offensive 0 remove flag close merge delete


Hello Rakhesh,

I'm sorry, but we can't reproduce. Using your credentials, and sending the following Query=(L_StatusCatID=2), we were able to pull sold listings. Further more, Query=(L_ListingId=20224232) returned the listing in your screenshot. Can you please verify with these two queries? If not, please include your query for us to review.

Joe_Brueske's avatar Joe_Brueske (2023-05-19 08:28:20 -0500) edit
add a comment see more comments

2 Answers


Hi Rakhesh,

The field in question is called L_HowSold. It was not enabled, but is now. You will need to check the Metadata for the lookup values.

<COLUMNS>   L_ListingID L_Status    L_HowSold   </COLUMNS>
<DATA>  20224232    SOLD    FHA </DATA>

My apologies for getting hung up on the word status, and not picking up on what you were trying to communicate in the screenshot. Hopefully, this is the answer you're looking for.

Joe_Brueske's avatar
answered 2023-05-19 11:38:05 -0500, updated 2023-05-19 11:39:23 -0500
edit flag offensive 0 remove flag delete link


add a comment see more comments

Hi Joe,

We are using this (L_StatusCatID=2),(ListingStatus=2) query to fetch the sold data from paragonrels. We are able to fetch all data except the Sold Status. We want to fetch sold data also.

Please help on this.

Rakhesh Kumar's avatar
Rakhesh Kumar
answered 2023-05-19 08:53:21 -0500
edit flag offensive 0 remove flag delete link


ListingStatus is not a valid RETS field. Here are the available fields for a listing's status and what they're used for.

L_Status: Concatenated form of L_StatusCatId and L_StatusID
eg: 2_0
L_StatusCatID: The category ID for the Status Category/Group
1: Active
2: Sold
3: Pending
L_StatusID: The ID for the specific Status in the Status Category/Group

We usually recommend just sticking with L_StatusCatID if you're pulling one specific status group. Also, please check the metadata for the specific statuses available if you use L_Status.

Joe_Brueske's avatar Joe_Brueske (2023-05-19 10:07:06 -0500) edit

Hi Joe,

We have changed our query as you suggested but we are not able to fetch the Sold Status data.

And in which column we will get the How sold status.

Please suggest us.

Rakhesh Kumar's avatar Rakhesh Kumar (2023-05-19 11:22:44 -0500) edit

Hi Joe,

Thanks for your support.

Now we are able to fetch the How Sold status.

Rakhesh Kumar's avatar Rakhesh Kumar (2023-05-19 11:58:31 -0500) edit
add a comment see more comments

Your Answer

Login/Signup to Answer