NTREIS RETS Servers

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://ntreisrets.mls.ntreis.net/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://ntreisretsstage1.mls.ntreis.net/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://ntreisrets.mls.ntreis.net/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 is 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 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/10/2009