Knowledge Base Article



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

 

 

 

 

 


Search All Knowledgebase Articles (click here)


Company Info
  About Us
  News
  Help
  Contact Us
Opportunities
  Careers
  Advertising
  FAQ
Login
  Login to My Account
  Create Account
Products
  ViewMyListing 9ae
  Pro Gold i2
  MyListingBlog
  Latest News


Home Page | Taro Systems, Inc.  | Terms  | FHEO Fair Housing and Equal Opportunity
© 2014 Taro Systems, Inc.