Ask Your Question

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

asked 2021-02-09 14:13:34 -0600

updated 2021-02-09 14:14:40 -0600


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.

edit retag flag offensive close merge delete


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

bwolven gravatar imagebwolven ( 2021-02-09 14:47:24 -0600 )edit

811302, 811296, 811502

tvirelli gravatar imagetvirelli ( 2021-02-09 14:59:29 -0600 )edit

1 Answer

Sort by ยป oldest newest most voted

answered 2021-02-09 15:15:24 -0600

updated 2021-02-09 15:39:19 -0600

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).

edit flag offensive delete link more


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

tvirelli gravatar imagetvirelli ( 2021-02-09 15:36:19 -0600 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2021-02-09 14:13:34 -0600

Seen: 303 times

Last updated: Feb 09 '21