NTREIS RETS Servers
· NTREIS is running RETS 1.5 Production on two load-balanced servers. The URL’s for the RETS Servers are:
Production RETS Server: http://rets.ntreis.mlsrets.com/rets/login
This server points directly to the MLS Production Database and Production Media Server. The MLS Database is approximately 60 GB in size. Any changes made in MLS appear instantly in this Database and/or Media Server.
Transition RETS Server: http://retstransition.ntreis.mlsrets.com/rets/login
This server points to a MLS Staging Database used for testing. The data is usually not current and may be a smaller data set than the MLS Production Database. In some instances, it may be several months before the data is refreshed on the Staging Database. The RETS Transition Server is used for testing prior to publishing any RETS changes to production.
· You can login to RETS and obtain the product and version with this URL:
http://rets.ntreis.mlsrets.com/rets/GetMetaData?type=metadata-System&format=Standard-XML
· If your RETS Client or script requires a port, the correct port is 80. The MarketLinx Client, RETS Connector, is programmed to use port 80. Be sure your firewall allows Port 80.
· The RETS Server does not require a User-Agent.
· The RETS Server users GMT. The data is in Central Time.
· The RETS server does not support “OFFSET”. It does support “FULL DMQL”.
· The MLS SQL Server and RETS servers reboot between 2 and 3 am. If you are downloading data during this window, be sure your client/script has the ability to automatically re-try in case the server are not available due to the server’s rebooting..
· NTREIS RETS has a default download limit of 400 records. You will need to change the LIMIT parameter in RETS in your RETS Client to allow for more records. See the ‘RETS 1.5 Specification Manual section 7.4.3’ for information on the LIMIT parameter. Currently a maximum limit has not been set for RETS downloads. Below is a table showing the number of listings by class and status:
|
Status |
RES |
MUL |
LND |
COM |
LSE |
Total |
|
ACT |
47,000 |
1,000 |
15,000 |
2,700 |
4,500 |
70,200 |
|
CON |
300 |
10 |
25 |
10 |
|
345 |
|
OPT |
1,700 |
25 |
100 |
30 |
100 |
1,955 |
|
KO |
100 |
|
10 |
5 |
|
115 |
|
TOM |
2,600 |
50 |
300 |
100 |
800 |
3,850 |
|
PND |
9,600 |
200 |
1,000 |
200 |
75 |
11,075 |
|
SLD |
610,000 |
6,000 |
37,000 |
4,500 |
500 |
658,000 |
|
LSE |
3 |
|
|
300 |
80,000 |
80,303 |
|
EXP |
150,000 |
2,500 |
31,000 |
7,500 |
16,000 |
207,000 |
|
CAN |
135,000 |
2,000 |
12,000 |
3,000 |
15,000 |
167,000 |
|
WTH |
1,200 |
50 |
200 |
50 |
250 |
1,750 |
|
WS |
150 |
25 |
200 |
25 |
25 |
425 |
|
Total |
957,653 |
11,860 |
96,835 |
18,420 |
117,250 |
1,202,018 |
*Although these number are not static, they will help you understand reasonable limits for your RETS download.
Updated: 2/19/2008