First time here? Check out the FAQ!

Specific listing queries are returning no records, but MLS says its there.


My client has had issues for some time now with listings not getting updated once sold. When I query the listing by specific ID, it comes back with a Count of 0. Like the listing doesn't exist. However the MLS group admins can see the listing. I assume this was something to do with my user they gave me and limitations, however, they said I am setup exactly the same as all other users. What could be causing this? As a proof of concept I used the query on a live "for sale" property and it returned the property just fine, it works on a lot of listings, but for 3 or 4 specific listings, its says it doesn't exist once set to sold.

tvirelli's avatar
asked 2021-02-09 14:13:34 -0500, updated 2021-02-09 14:14:40 -0500
edit flag offensive 0 remove flag close merge delete


Can you give me the L_ListingID for the listings you can't pull?

bwolven's avatar bwolven (2021-02-09 14:47:24 -0500) edit

811302, 811296, 811502

tvirelli's avatar tvirelli (2021-02-09 14:59:29 -0500) edit
add a comment see more comments

1 Answer


Those three listings all have LM_char30_2 (Special Showing Instructions)=NS.
Your account profile only displays sold listings where the field set either blank or CTS (Continue to Show).

bwolven's avatar
answered 2021-02-09 15:15:24 -0500, updated 2021-02-09 15:39:19 -0500
edit flag offensive 0 remove flag delete link


Thank you, I am working with the local MLS now to see if this solves the issue.

tvirelli's avatar tvirelli (2021-02-09 15:36:19 -0500) edit
add a comment see more comments

Your Answer

Login/Signup to Answer