IMRMLS MLS RETS Data Field Mappings KBA

Real Estate Software - ProGold i2 web site: www.progoldi2.com

Real Estate Search Engine - ViewMyListing.com web site: www.viewmylisting.com

Search Local Classifieds – www.viewmylisting.com/buy-sale-trade

Agent Tools web site: real estate agent software

MLS Data Feed Implementation and Technical Specifications

Article: 4035

Description: IMRMLS MLS RETS Data Field Mappings

Last Modified: December 6, 2013

Reference KBA 4148 for Interface Setup and Procedures

Board Contact: Arcadia Association of REALTORS

Citrus Valley Association of REALTORS

Corona-Norco Association of REALTORS

East Valley Association of REALTORS

Inland Valleys Association of REALTORS

Montebello District Board of REALTORS

Southwest River County Association of REALTORS

Tri Counties Association of REALTORS

West San Gabriel Valley Association of REALTORS

MLS Contact: MRMLS

800-925-1525 phone

RETS Server is provided by: MRMLS

MRMLS Field Mappings

Resi
Position	RETS SystemName	RETS LongName	ProGold Field	Lookup
1	ageyr	YearBuilt
2	apno	APNumber
3	aptnum	UnitNumber	Address Two
4	area	Area	Township	AREA
5	attach	Attached
6	bath	Bath	Baths
7	bath2	BathFraction
8	bedrm	Bedroom	Bedrooms
9	bonus	Bonus
10	cable	CableTV
11	city	City	City	CITY
12	den	OfficeDen
13	dinrm	DiningRoom
14	directnl	StreetDirection	Address One
15	drsar	DressingArea
16	entry	LivingRoomEntry
17	famrm	FamilyRoom
18	feat	PropertyFeatures	Features
19	fence	Fence
20	fireplace	Fireplace
21	floor	Floor
22	garag	GarageDescription
23	garno	NumberOfGarageSpaces
24	horse	HorseProperty
25	hsdst	SchoolDistrict
26	la_fname	ListingAgentFirstName	Agent Name
27	la_lname	ListingAgentLastName	Agent Name
28	la_publicid	ListingAgentPublicID	Agent ID
29	laund	LocationOfLaundry
30	listprice	ListPrice	List Price
31	listpricelow	ListPriceLow
32	livrm	LivingRoom
33	lo_code	OfficeCode	Office ID
34	lo_name	OfficeName	Office Name
35	lsqft	LotSqFt	Lot Size
36	Matrix_Unique_ID	Matrix_Unique_ID	(unique index)
37	mbedrm	MasterBedRoom
38	mbrret	MasterBedroomRetreat
39	mlnum	MLSNum	MLS
40	patdim	Patio
41	photomodifieddate	PhotoModifiedDate
42	piccount	NumberOfPictures
43	pool	Pool
44	rem	PropertyDesc	Listing Notes
45	roof	Roof
46	rvacc	RVAccessDimensions
47	schgr	ElementarySchool
48	schjr	JuniorHighSchool
49	schsr	HighSchool
50	secsys	SecurityAlarmSystem
51	spayn	Spa
52	spklr	LawnSprinklers
53	sqft	SquareFootage	Sq. Ft
54	State	State	State
55	status	Status	Status	STATUS
56	stnam	StreetName	Address One
57	stnum	StreetNumber	Address One
58	story	Story
59	strsfx	StreetSuffix	Address One
60	tgno	ThomasGuideNumber
61	trndate	TransactionDate	(to get current records)
62	tvant	TVAntenna
63	type	Type		TYPE
64	view1	View
65	virtualtour	VirtualTour
66	walkin	WalkInCloset
67	wetbar	WetBar
68	yard	Yard
69	zip	ZipCode	Zip code

Land
Position	RETS SystemName	RETS LongName	Progold Field	Lookup
1	acres	Acres
2	apno	APNumber
3	area	Area	Township	AREA
4	city	City	City	CITY
5	directnl	StreetDirection	Address One
6	dwater	Distance To Water
7	feat	PropertyFeatures	Features
8	fenced	Fenced
9	grossequity	Gross Equity
10	la_fname	ListingAgentFirstName	Agent Name
11	la_lname	ListingAgentLastName	Agent Name
12	la_publicid	ListingAgentPublicID	Agent ID
13	land2	Land Lease Amount Per Year
14	listprice	ListPrice	List Price
15	listpricelow	ListPriceL
16	lo_code	OfficeCode	Office ID
17	lo_name	OfficeName	Office Name
18	loans	Loans
19	lotdim	LotDimensions	Lot Size
20	Matrix_Unique_ID	Matrix_Unique_ID	(unique inex)
21	mlnum	MLSNum	MLS
22	parcelsz	ParcelSizeInAcres	Acres
23	paved	Paved Streets
24	photomodifieddate	photomodifieddate
25	piccount	Number of Pictures
26	potuse	Potential Use
27	presuse	Present Use
28	prsqft	Price Per Square Foot
29	pusable	Total Percent Usable Land
30	rem	PropertyDesc	Listing Notes
31	state	State	State
32	status	Status	Status
33	stnam	StreetName	Address One
34	stnum	StreetNumber	Address One
35	strsfx	StreetSuffix	Address One
36	tgno	Thomas Guide Number
37	topogpy	Topography
38	trndate	TransactionDate	(to get current records)
39	virtualtour	Virtual Tour
40	zip	ZipCode	Zip code

mobhomes
Position	RETS SystemName	RETS LongName	ProGold Field	Lookup
1	ac	Air Conditioning
2	apno	APNumber
3	area	Area	Township	AREA
4	asqft	SqFt	Sq. Ft.
5	bath	Bath	Baths
6	bedrm	Bedroom	Bedrooms
7	city	City	City	CITY
8	directnl	StreetDirection	Address One
9	equity	Equity
10	feat	PropertyFeatures	Features
11	gar1	Number of Garage Spaces
12	la_fname	ListingAgentFirstName	Agent Name
13	la_lname	ListingAgentLastName	Agent Name
14	la_publicid	ListingAgentPublicID	Agent ID
15	land	Land Fee/Lease
16	lgt	Length
17	listprice	ListPrice	List Price
18	listpricelow	ListPriceL
19	lo_code	OfficeCode	Office ID
20	lo_name	OfficeName	Office Name
21	lotsqft	LotSqFt	Lot Size
22	manager	Manager's Name
23	Matrix_Unique_ID	Matrix_Unique_ID	(unique index)
24	mlnum	MLSNum	MLS
25	parkname	Park Name
26	parktype	Park Type
27	permitrmn	Permit for Mobile Home to Remain
28	pets	Pets Allowed
29	photomodifieddate	photomodifieddate
30	piccount	Number of Images
31	pool	Pool
32	ptype	Type of Mobile Home
33	rem	PropertyDescription	Listing Notes
34	roof	Roofing Materials
35	spcnum	SpaceNumber
36	sprtinc	Space Rent Includes
37	State	State	State
38	status	Status	Status
39	stnam	StreetName	Address One
40	stnum	StreetNumber	Address One
41	strsfx	StreetSuffix	Address One
42	tgno	Thomas Guide Number
43	trndate	TransactionDate	(to get current records)
44	view1	View
45	virtualtour	Virtual Tour
46	width	Width
47	yrblt	YearBuilt
48	zip	ZipCode	Zip code

rinc
Position	RETS Position	RETS LongName	Progold Field	Lookup
1	ageyr	YearBuilt
2	apno	APNumber
3	area	Area	Township	AREA
4	city	City	City	CITY
5	directnl	StreetDirection	Address One
6	elec	# of Separate Electric Meters
7	feat	PropertyFeatures	Features
8	gasd	Number of Separate Gas Meters
9	grosssched	Gross Scheduled Income
10	la_fname	ListingAgentFirstName	Agent Name
11	la_lname	ListingAgentLastName	Agent Name
12	la_publicid	ListingAgentPublicID	Agent ID
13	listprice	ListPrice	List Price
14	listpricelow	ListPriceL
15	lo_code	OfficeCode	Office ID
16	lo_name	OfficeName	Office Name
17	lotsqft	LotSqFt	Lot size
18	Matrix_Unique_ID	Matrix_Unique_ID	(unique index)
19	mlnum	MLSNum	MLS
20	mongsi	Monthly Gross Scheduled Income
21	netopinc	Net Operating Income Percent
22	nogar	Number of Garage Spaces
23	opexpp	Operating Expense Dollar Amount
24	photomodifieddate	photomodifieddate
25	piccount	Number of Images
26	priceunit	Price Per Unit
27	rem	PropertyDesc	Listing Notes
28	state	State	State
29	status	Status	Status
30	stnam	StreetName	Address One
31	stnum	StreetNumber	Address One
32	strsfx	StreetSuffix	Address One
33	tgno	Thomas Guide Number
34	totald	Total Expenses
35	totpark	Total Parking Spaces
36	totsqft	Total Building Square Footage	Sq. Ft.
37	trndate	TransactionDate	(to get current records)
38	units	Number of Units
39	virtualtour	Virtual Tour
40	wtr	Number of Separate Water Meters
41	zip	ZipCode	Zip code

rlse
Position	RETS Position	RETS LongName	ProGold Field	Lookup
1	ageyr	YearBuild
2	aptnum	UnitNumber	Address Two
3	area	Area	Township	AREA
4	attach	attach
5	bath	bath	Baths
6	bath2	bath2
7	bedrm	Bedroom	Bedrooms
8	bonus	bonus
9	cable	cable
10	city	City	City	CITY
11	den	den
12	dinrm	dinrm
13	directnl	StreetDirection	Address One
14	drsar	drsar
15	entry	entry
16	famrm	famrm
17	feat	PropertyFeatures	Features
18	fence	fence
19	fireplace	fireplace
20	floor	floor
21	garag	garag
22	garno	garno
23	horse	horse
24	hsdst	hsdst
25	la_fname	ListingAgentFirst	Agent Name
26	la_lname	ListingAgentLast	Agent Name
27	la_publicid	ListingAgentPublicID
28	laund	laund
29	listprice	ListPrice	List Price
30	listpricelow	ListPriceL
31	livrm	livrm
32	lo_code	OfficeCode	Office ID
33	lo_name	OfficeName	Office Name
34	lsqft	LotSqFt	Lot size
35	Matrix_Unique_ID	Matrix_Unique_ID	(unique index)
36	mbedrm	mbedrm
37	mbrret	mbrret
38	mlnum	MLSNum	MLS
39	patdim	patdim
40	photomodifieddate	photomodifieddate
41	piccount	piccount
42	pool	pool
43	rem	PropertyDesc	Listing Notes
44	roof	roof
45	rvacc	rvacc
46	schgr	schgr
47	schjr	schjr
48	schsr	schsr
49	secsys	secsys
50	spayn	spayn
51	spklr	spklr
52	sqft	SqFt	Sq. Ft.
53	State	State	State
54	status	Status	Status
55	stnam	StreetName	Address One
56	stnum	StreetNumber	Address One
57	story	story
58	strsfx	StreetSuffix	Address One
59	tgno	tgno
60	trndate	TransactionDate	(to get current records)
61	tvant	tvant
62	type	Type
63	view1	view1
64	virtualtour	virtualtour
65	walkin	walkin
66	wetbar	wetbar
67	yard	yard
68	zip	ZipCode	Zip code

Knowledge Base Article