Ask Your Question

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

asked 2018-04-13 12:06:13 -0600

updated 2018-04-13 16:42:21 -0600


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

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted

answered 2018-04-13 15:05:32 -0600


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,

edit flag offensive delete link more


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 gravatar imagedcgllc ( 2018-04-13 15:43:42 -0600 )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 gravatar imagedcgllc ( 2018-04-13 15:52:17 -0600 )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 gravatar imagedcgllc ( 2018-04-13 15:55:32 -0600 )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 gravatar imageSadie ( 2018-04-13 17:01:06 -0600 )edit


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

Sadie gravatar imageSadie ( 2018-04-13 17:06:52 -0600 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-04-13 12:06:13 -0600

Seen: 529 times

Last updated: Apr 13 '18