RETS Query Examples?

[NancyDennisAssociates]

Do people still use this technology? If so, how do you get access to the RETS server?

[kcmerrill]

Yes, (sadly) rets is still being used today. More and more MLS areas are switching from their standard IDX feeds to these.

[kcmerrill]

Just figured I would post the queries that I created, in case they can help anyone.
Residential properties from my office #ListingOfficeMLSID=550000042

Class=RESI&Select=MLNumber,Status,ListingPrice,StreetNumber,StreetName,StreetSuffix,City,State,ZipCode,Subdivision,Area,RESIPROP,RESIWATE,RESIWTRT,Bedrooms,FullBathrooms,HalfBathrooms,SquareFootage,YearBuilt,Longitude,Latitude,ListingAgentFirstName,ListingAgentLastName,RESILTFR,RESILTLT,RESILTRR,RESILTRT,RESIANND,RESIAPPL,RESIDIND,RESIEXTF,RESIFIRE,RESIFLOR,RESIINTR,RESIWTRS,MarketingRemarks&Query=(ListingOfficeMLSID=550000042),(MLNumber=1+)&SearchType=Property&Format=COMPACT-DECODED&QueryType=DMQL2&Limit=NONE&Count=0

Land properties from my office #ListingOfficeMLSID=550000042

Class=LAND&Select=MLNumber,Status,ListingPrice,StreetNumber,StreetName,StreetSuffix,City,State,ZipCode,Subdivision,Area,LANDPROP,LANDWATE,LANDWTRT,LANDWTRV,LANDWTVT,LANDLTFR,LANDLTLT,LANDLTRR,LANDLTRT,LANDIRRL,LANDTOPO,LANDUTIL,LANDPOTU,LANDUTAV,LANDSEPT,Longitude,Latitude,ListingAgentFirstName,ListingAgentLastName,MarketingRemarks&Query=(ListingOfficeMLSID=550000042),(MLNumber=1+)&SearchType=Property&Format=COMPACT-DECODED&QueryType=DMQL2&Limit=NONE&Count=0

No spaces......for some reason the forums are adding spaces in the query example.

I know this is an old post, but I wanted to make a quick comment(just some things that I've had alot of trouble with in the past) given this is a top search result within Google.

I've found that be leaving the select statement off, you actually get all the columns you have access too. A word of caution, I've noticed(RAMDC for example) you only get about 25 or so columns back when using StandardNames, however, using their system names you get 50+ back. Another positive to not using the select statement is that when they go to change their coluumn names/format and you don't get the email, it won't completley break your query.

Of course, YMMV and there may be specific needs as to why you go about using the select statement, but if you need everything you have access to, this is the way to go.

Anyways, I hope this will help elliviate some of the headaches, or at least headaches I've encountered in the past.

Cheers,
-kc