Downloading Farm RETS Listing Content

Before you will be given access to RETS listing content, you must complete all of the steps of the Broker Only FTP/ RETS subscription wizard and have at least one active Broker Subscriber to your service. In order to connect and download listing content, the following information is also required:

• RETS Server:  rets.wfrmls.com
• Port: 6103
• Your Vendor Login
• Your Vendor Password

Farm RETS Profile

Below is the list of all the fields contained within the RETS profile for the farm property type. The data type together with a short description of the field's value is included here for each of the fields mentioned above for completeness. The fields are listed in the same order that they are delivered in the dump.

Field Name	Field Type	Description
access	string	Comma-separated string representing driveway access featurs
acres	numeric(8,2)	Acres
agentid	integer	ID number of the listing agent
area	smallint	Area of the property
city	character(25)	Property city
confee	string	Comma-separated string representing connection fees
county	string	Property county
crops	character(40)	Crops
daysonmkt	smallint	Number of days on market
dirpost	character(2)	Street directional post (eg. N, S, E, W)
dirpre	character(2)	Street directional pre (eg. N, S, E, W)
dryacres	integer	Dry acres
ewcoord	integer	East-West address number
farmtype	character(20)	Farm type
gas	string	Gas
housenbr	integer	Property address number
imprvmnts	character(40)	Improvements
irrigacres	integer	Irrigation acres
jpgname	string	Primary property photo name
legaldes	character(80)	Legal description
listdt	timestamp	Timestamp of listing date
listno	integer	Listing number of property
listtype	integer	Listing type (EAL or ERS)
livestoc	character(40)	Livestock
lot	string	Comma-separated string representing lot facts for property
lsdacres	integer	Leased acres
lseprice	integer	Lease price
lstprice	integer	Listing price
machinery	character(40)	Machinery
minrgts	string	Mineral rights
nscoord	integer	North-South addresss number
officeid	integer	ID number of listing office
permits	character(12)	Permits
photofull	smallint	Number of photos
power	string	Power features
prcpercost	string	Price per cost
prcperunit	string	Price per unit (eg. none, acre, sq ft, month, year)
publicid	character(10)	Listing agent user name
quadrant	character(2)	Property quadrant (eg. NW, SW, NE, SE)
rngacres	integer	Range acres
rstrct	string	Project restrictions (yes or no)
sewer	string	Comma-separated string representing sewer features
state	character(2)	State
status	string	Property status
street	character(20)	Street name of property
strtype	character(4)	Street type (eg. Ave, Blvd, Rd)
taxes	integer	Property taxes
taxid	character(20)	Tax ID
timeclause	smallint	Time clause
tour	string	Property Tour
water	string	Comma-separated string representing water features
wtrvol	character(12)	Water volume
zip	character(9)	Zip code
zoning	character(6)	Property zoning
wa	character(36)	Web analytics image url used by UtahRealEstate for reporting/statistics
agtfirst	character(30)	Agent's first name
agtinitial	character(10)	Agent's middle initial
agtlast	character(30)	Agent's last name
agtphone1	character(14)	Agent's phone number one
agtphone2	character(14)	Agent's phone number two
coagentid	integer	ID number of the co-listing agent
coagtfirst	character(30)	Coagent's first name
coagtinitial	character(10)	Coagent's middle initial
coagtlast	character(30)	Coagent's last name
coagtphone1	character(14)	Coagent's phone number one
coagtphone2	character(14)	Coagent's phone number two
offname	character(50)	Office's name
offadd1	character(50)	Office's address
offcity	character(25)	Office's city
offstate	character(2)	Office's state
offzip	character(12)	Office's zip
offphone1	character(12)	Office's phone number one
offphone2	character(12)	Office's phone number two
publicremarks	string	Public remarks of listing