First time here? Check out the FAQ!

class[ Property] type[ RE_1 ] Fails to Produce All Records


Username: del0211

The "Answer" below merely is list of filters that I did not set up, and most importantly, does not state how they need to be changed [and by whom] to get all of the RE_1 Property records available using the bulk queries stated below, or why three L_City's out of 20+ work fine. If there is a filter issue, How can that be remedied? Please also see the comments below and help me to solve the problem.

Software to extract data is: phrets.php

As an example of a score of "L-City" queries that work as expected is the following:

query: [ (L_City=Francestow),(L_State=NH) ] class[ Property] type[ RE_1 ] limit[ 5000 ]

15 MLS records found of 15 without "closed" status: 4478390, 4483929, 4659483, 4668562, 4668895, 4674115, 4674205, 4678569, 4678782, 4679416, 4679541, 4682083, 4683082, 4685084, 4685510

The only variable in the following queries is "L_City" whereby "Francestow" is substituted with "Merrimack", "Nashua" and "Manchester".

The following three queries fail to produce expected results:

query: [ (L_City=Merrimack),(L_State=NH) ] class[ Property] type[ RE_1 ] limit[ 5000 ]

2 MLS records found of 71 without "closed" status: 4619170, 4629832

query: [ (L_City=Nashua),(L_State=NH) ] class[ Property] type[ RE_1 ] limit[ 5000 ]

0 MLS records found of 339 without "closed" status

query: [ (L_City=Manchester),(L_State=NH) ] class[ Property] type[ RE_1 ] limit[ 5000 ]

0 MLS records found of 331 without "closed" status

dcgllc's avatar
asked 2018-04-13 12:06:13 -0500, updated 2018-04-13 16:42:21 -0500
edit flag offensive 0 remove flag close merge delete


add a comment see more comments

1 Answer



We had a chance to review your account, and the RETS profile you're currently attached to has the following filters by default (aside from the ones you are adding to your query): ((L_StatusCatID=1,3),(LV_vow_include=Y))|((L_StatusCatID=2),(L_ClosingDate=2012-01-01+),(LV_vow_include=Y))|((L_StatusCatID=6),(LM_DateTime_7=2012-01-01+),(LV_vow_include=Y))

So the listings have to meet all of the above criteria, AND (L_City=Merrimack),(L_State=NH) OR (L_City=Nashua),(L_State=NH) OR (L_City=Manchester),(L_State=NH).

If you have a specific listing you're wondering why it did not returned, please let us know and we can review the exact listing!

Thank you,

Sadie's avatar
answered 2018-04-13 15:05:32 -0500
edit flag offensive 0 remove flag delete link


I can pull all RE-1 Properties in Merrimack, Nashua and Manchester individually by a query on MLS#. But to pull them in bulk by RE-1 fails. If the filters are consistently applied and still the same for 20+ towns in my profile why do only 3 L_City's fail? I need a solution, not a filter list?

dcgllc's avatar dcgllc (2018-04-13 15:43:42 -0500) edit

If my account has consistent filters, why do none of these four Merrimack examples appear on a bulk query by Property and RE_1: 685990, 4685733, 4685656 and 4685495; and all of them can be queried by individual MLS# [ListingID]. How can this be a filter problem?

dcgllc's avatar dcgllc (2018-04-13 15:52:17 -0500) edit

Where can a list of the filter definitions and effects for the following be found: ((L_StatusCatID=1,3),(LV_vow_include=Y))|((L_StatusCatID=2),(L_ClosingDate=2012-01-01+),(LV_vow_include=Y))|((L_StatusCatID=6),(LM_DateTime_7=2012-01-01+),(LV_vow_include=Y))?

dcgllc's avatar dcgllc (2018-04-13 15:55:32 -0500) edit

So I did review one of the example listings, 4685495. I think the issue is the Max results returned here is 2,500. 4685495 would be in the next 2,500 results. So you would need to utilize offset. Here is an example of how to get the next set of listings, which would include 4695495:

Sadie's avatar Sadie (2018-04-13 17:01:06 -0500) edit


Also below is a helpful guide as well: RETS Best Practices

Sadie's avatar Sadie (2018-04-13 17:06:52 -0500) edit
add a comment see more comments

Your Answer

Login/Signup to Answer