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:                       4037

Description:             Property Information Network (MLS_PIN) IDX Data Feed

Last Modified:         September 6, 2013

Before setting us your MLS data feed you will need to update your Pro Gold XP application to the most recent published version.

If you are a new client currently in training, you must complete “Training Session Topic 3” before proceeding.  Contact your trainer with questions.

STEP 1  Update ProGold i2.  (Requires Resource Center Subscription).

Download/Install ProGold i2 updates

1. Go to Setup Tab
2. Select Download Live Update Icon and click Continue
3. Wait for the download to complete and extract and click OK when prompted
4. Multi-User customers should have all other users exit out of Pro Gold XP before continuing at this time.
5. Select Install Update Icon from the Setup main menu. Pro Gold XP will restart automatically when the update is complete.
6. Once the update is installed to the database other workstations will be automatically prompted to install a new version, click on yes to install the newer version of Pro Gold XP to that workstation.
7. Review the Release Notes and close.
8. To ensure your update was successfully installed, login to Pro Gold XP and confirm that the program version and the data version are the same number.

Download and Install the latest MLS Import Driver (Unique MLS mapping schema files).  Perform this for all workstations.

9. Go to Setup Tab

10.   Select Import/Export Utility Icon

11. Select Update Import Driver button
12. Wait for the download to complete and extract and click OK when prompted. 

STEP 2  Download and setup the IDX Utility application. This only needs to be    done once.

1.       From the Setup tab select Download Live Update.

2.       Select Custom

3.       Enter MLS_PIN in the space provided and select Continue.          

4.       You will be prompted to enter your board FTP/IDX Credentials:

a.       URL  idx.mlspin.com

b.        Pic URL ftp.mlspin.com (required for Pro Gold XP 3.07 or higher)

c.       User Name – provided by your board

d.       Password – provided by your board 

e.       Click on Download.

5.    Wait for the download to complete and click OK when prompted  

STEP 3 Setup your Non Co-op office with your MLS public ID’s. This only needs to be done once.

Any existing office in Pro Gold XP that is not setup with a Board Name and Entity ID will be added, during the import, possible causing duplicates offices.  All Non Co-op Offices must be mapped with your public MLS ID.

Note: Only listings for Non Co-op offices will import from your MLS data feed. 

1.       From the Properties Menu select Office Setup.  Using the Quick Find, search for the office you wish to assign the MLS public ID to.  Repeat for all Non Co-op Offices.  (Figure A)

a.       For Board Name Select: Property Information Network

b.       For Entity ID:        Your Office Public ID Provided by your Board

c.       Click on Save button

(Figure A)

STEP 4  Setup your Agents with your MLS public ID’s. This only needs                                         to be done once.

Your agents will not be assigned to their listings from MLS until their public MLS ID is mapped.

1.       From the Properties Menu select Agent Information.  Use the Find button to search for an agent you wish to assign their public MLS ID to and select retrieve.

2.       Select the Data Import Tab  (Figure B).

a.       For Board Name Select: Property Information Network

b.       For Entity ID:        Agent’s Public ID Provided by your Board/MLS PIN

c.       Click on Save Agent button

(Figure B)

STEP 5  Importing Your MLS data. This should be done daily.

1.       From the Setup menu select Import/Export Utility menu.

2.       Select “Select from Below” and click on your data feed/board name and click open.

3.       Click on the retrieve button.  This will download your listings from the FTP site to your computer and extract the files. If photos are available and you’re using Pro Gold XP 3.07 or greater you can select to include photos. Based on the number of photos included in the data feed from your Board and your Internet connection speed, photos can take a few hours to download.  You may find it more convenient to download photos weekly or during off peak times daily. (photos are not available on your initial download)

4.       Click OK when the download has finished downloading the file

5.       Select the options to include import co-op agents and offices and photos.  Click on the Import button to start importing the listing data into Pro Gold XP.

6.       Wait for the download to complete and click OK when prompted

MLS Vendor Contact                  Property Information Network

                                                www.mlspin.com

FTP Site is Provided by              Property Information Network

Special Notes:

• See field mappings for status and property type included in data feed.
• User should review listings and make any necessary changes.
• Co-op Office and Agent Roster are not provided.
• Pictures are provided for Pro Gold XP version 3.07 or greater.
• Features are not supported.
• MLS imports should be performed during off peak hours  when including photos.
• Recommended that you have a minimum 2 gigs of RAM.
• Please allow 1.5 hours when downloading photos.

Fields provided in MF file:  (230)

LIST_NO,ACRE,ADULT_COMMUNITY,ALERT_COMMENTS,AMENITIES,ANT_SOLD_DATE,APOD_AVAILABLE,APP_COMMON,APP_DSCRP_1,APP_DSCRP_2,APP_DSCRP_3,APP_DSCRP_4,AREA,ASSESSMENTS,AUCTION_BUYERS_PREMIUM,AUCTION_BUYERS_PREMIUM_PERCENT,AUCTION_DEPOSIT,AUCTION_SELLERS_CONFIRMATION,AUCTION_TERMS,BASEMENT,BASEMENT_FEATURE,BEACH_DESCRIPTION,BEACH_MILES_TO,BEACH_OWNERSHIP,BEACHFRONT_FLAG,BEDRMS_1,BEDRMS_2,BEDRMS_3,BEDRMS_4,BLOCK,BOOK,BUYER_BROKER_COMP,CERTIFICATE_NUMBER,COL_COMMON,COL_DSCRP_1,COL_DSCRP_2,COL_DSCRP_3,COL_DSCRP_4,COLOR,CONSTRUCTION,COOLING_UNITS,COOLING_ZONES,DIRECTION,DISCLOSURE,DISCLOSURES,ELEC,ELECTRIC_FEATURE,ENERGY_FEATURES,ENTRY_ONLY,EXCLUSIONS,EXPENSES_SOURCE,EXPENSES_YEAR_END,EXPIRE_DATE,EXTERIOR,EXTERIOR_FEATURES,F_BTHS_1,F_BTHS_2,F_BTHS_3,F_BTHS_4,FIN_CODE,FIRE_PLACES,FIRM_RMK1,FLOORING,FLRS_1,FLRS_2,FLRS_3,FLRS_4,FOUNDATION,FOUNDATION_SIZE,FRONTAGE,FRPLCS_1,FRPLCS_2,FRPLCS_3,FRPLCS_4,GARAGE_SPACES,GOI,GRADE_SCHOOL,GRE,GSE,H_BTHS_1,H_BTHS_2,H_BTHS_3,H_BTHS_4,HEA_COMMON,HEA_DSCRP_1,HEA_DSCRP_2,HEA_DSCRP_3,HEA_DSCRP_4,HEAT_UNITS,HEAT_ZONES,HIGH_SCHOOL,HOT_WATER,HOW_SHOWN_BB,HOW_SHOWN_FB,HOW_SHOWN_SB,HTE,IFE_COMMON,IFE_DSCRP_1,IFE_DSCRP_2,IFE_DSCRP_3,IFE_DSCRP_4,INSC,LEAD_PAINT,LEASE_1,LEASE_2,LEASE_3,LEASE_4,LEVELS,LEVELS_1,LEVELS_2,LEVELS_3,LEVELS_4,LIST_AGENT,LIST_DATE,LIST_DATE_RCVD,LIST_NO1,LIST_OFFICE,LIST_PRICE,LIST_PRICE_PER_SQFT,LISTING_AGREEMENT,LISTING_ALERT,LOT,LOT_DESCRIPTION,LOT_SIZE,MAIN_LO,MAIN_SO,MAP,MARKET_TIME_BROKER,MARKET_TIME_PROPERTY,MASTER_BATH,MF_TYPE,MGF,MIDDLE_SCHOOL,MSE,NEIGHBORHOOD,NO_BEDROOMS,NO_FULL_BATHS,NO_HALF_BATHS,NO_ROOMS,NO_UNITS,NOI,OFF_MKT_DATE,ORIG_PRICE,OTHER_AGENT_COMP,PAGE,PARCEL_NUMBER,PARKING_FEATURE,PARKING_SPACES,PHOTO_COUNT,PHOTO_DATE,PHOTO_MASK,PROP_TYPE,REMARKS,RENT_PRICE,RENT1,RENT2,RENT3,RENT4,RFS,RME,RMS_1,RMS_2,RMS_3,RMS_4,RMS_COMMON,RMS_DSCRP_1,RMS_DSCRP_2,RMS_DSCRP_3,RMS_DSCRP_4,RNT_DSCRP_1,RNT_DSCRP_2,RNT_DSCRP_3,RNT_DSCRP_4,ROAD_TYPE,ROOF_MATERIAL,SALE_AGENT,SALE_OFFICE,SALE_PRICE,SELLER_CONCESSIONS_AT_CLOSING,SELLER_DISCOUNT_PTS,SELLING_BROKER_COMP,SETTLED_DATE,SEW,SEWAGE_DISTRICT,SEWER_AND_WATER,SHOW_INSTRUCTION,SHOWINGS_DEFERRAL_DATE,SOLD_PRICE_PER_SQFT,SOLD_VS_RENT,SQUARE_FEET,SQUARE_FEET_DESCL,SQUARE_FEET_BASE,SQUARE_FEET_OTHER,SQUARE_FEET_SOURCE,STATUS,STATUS_DATE,STREET_NAME,STREET_NO,STREET_NUM,SUB_AGENCY_OFFERED,SUB_AREA,TAX_YEAR,TAXES,TEAM_MEMBER,TERMS_FEATURE,TOTAL_BRS,TOTAL_FBH,TOTAL_FLRS,TOTAL_FRPLCS,TOTAL_HBH,TOTAL_LEVELS,TOTAL_RENT,TOTAL_RMS,TOTAL_ROOMS,TOWN_NUM,UFFI,UNIT_NO,UPDATE_DATE,UTILITY_CONNECTIONS,WARRANTY,WATERFRONT,WATERFRONT_FLAG,WSE,YEAR_BUILT,YEAR_BUILT_DESCRP,YEAR_BUILT_SOURCE,YEAR_ROUND,ZIP_CODE,ZIP_CODE_4,ZONING

Fields provided in MH file:  (208)

LIST_NO,ACRE,ADULT_COMMUNITY,ALERT_COMMENTS,AMENITIES,ANT_SOLD_DATE,APPLIANCES,AREA,ASSESSMENTS,AUCTION_BUYERS_PREMIUM,AUCTION_BUYERS_PREMIUM_PERCENT,AUCTION_DEPOSIT,AUCTION_SELLERS_CONFIRMATION,AUCTION_TERMS,BASEMENT,BASEMENT_FEATURE,BEACH_DESCRIPTION,BEACH_MILES_TO,BEACH_OWNERSHIP,BEACHFRONT_FLAG,BED2_DIMEN,BED2_DSCRP,BED2_LEVEL,BED3_DIMEN,BED3_DSCRP,BED3_LEVEL,BED4_DIMEN,BED4_DSCRP,BED4_LEVEL,BED5_DIMEN,BED5_DSCRP,BED5_LEVEL,BLOCK,BOOK,BTH1_DIMEN,BTH1_DSCRP,BTH1_LEVEL,BTH2_DIMEN,BTH2_DSCRP,BTH2_LEVEL,BTH3_DIMEN,BTH3_DSCRP,BTH3_LEVEL,BUYER_BROKER_COMP,CERTIFICATE_NUMBER,COLOR,CONSTRUCTION,COOLING,COOLING_ZONES,DIN_DIMEN,DIN_DSCRP,DIN_LEVEL,DIRECTION,DISCLOSURE,DISCLOSURES,ELECTRIC_FEATURE,ENERGY_FEATURES,ENTRY_ONLY,EXCLUSIONS,EXPIRE_DATE,EXTERIOR,EXTERIOR_FEATURES,FAM_DIMEN,FAM_DSCRP,FAM_LEVEL,FIN_CODE,FIRE_PLACES,FIRM_RMK1,FLOORING,FOUNDATION,FOUNDATION_SIZE,FRONTAGE,GARAGE_PARKING,GARAGE_SPACES,GRADE_SCHOOL,HEAT_ZONES,HEATING,HIGH_SCHOOL,HOA_FEE,HOME_OWN_ASSOCIATION,HOT_WATER,HOW_SHOWN_BB,HOW_SHOWN_FB,HOW_SHOWN_SB,INSULATION_FEATURE,INTERIOR_FEATURES,KIT_DIMEN,KIT_DSCRP,KIT_LEVEL,LAUNDRY_DIMEN,LAUNDRY_DSCRP,LAUNDRY_LEVEL,LEAD_PAINT,LIST_AGENT,LIST_DATE,LIST_DATE_RCVD,LIST_NO1,LIST_OFFICE,LIST_PRICE,LIST_PRICE_PER_SQFT,LISTING_AGREEMENT,LISTING_ALERT,LIV_DIMEN,LIV_DSCRP,LIV_LEVEL,LOT,LOT_DESCRIPTION,LOT_SIZE,MAIN_LO,MAIN_SO,MAP,MARKET_TIME_BROKER,MARKET_TIME_PROPERTY,MASTER_BATH,MBR_DIMEN,MBR_DSCRP,MBR_LEVEL,MIDDLE_SCHOOL,NEIGHBORHOOD,NO_BEDROOMS,NO_FULL_BATHS,NO_HALF_BATHS,NO_ROOMS,OFF_MKT_DATE,ORIG_PRICE,OTH1_DIMEN,OTH1_DSCRP,OTH1_LEVEL,OTH1_ROOM_NAME,OTH2_DIMEN,OTH2_DSCRP,OTH2_LEVEL,OTH2_ROOM_NAME,OTH3_DIMEN,OTH3_DSCRP,OTH3_LEVEL,OTH3_ROOM_NAME,OTH4_DIMEN,OTH4_DSCRP,OTH4_LEVEL,OTH4_ROOM_NAME,OTH5_DIMEN,OTH5_DSCRP,OTH5_LEVEL,OTH5_ROOM_NAME,OTH6_DIMEN,OTH6_DSCRP,OTH6_LEVEL,OTH6_ROOM_NAME,OTHER_AGENT_COMP,PAGE,PARCEL_NUMBER,PARKING_FEATURE,PARKING_SPACES,PHOTO_COUNT,PHOTO_DATE,PHOTO_MASK,PROP_TYPE,REMARKS,RENT_PRICE,REQD_OWN_ASSOCIATION,ROAD_TYPE,ROOF_MATERIAL,SALE_AGENT,SALE_OFFICE,SALE_PRICE,SELLER_CONCESSIONS_AT_CLOSING,SELLER_DISCOUNT_PTS,SELLING_BROKER_COMP,SETTLED_DATE,SEWAGE_DISTRICT,SEWER_AND_WATER,SHOW_INSTRUCTION,SHOWINGS_DEFERRAL_DATE,SOLD_PRICE_PER_SQFT,SOLD_VS_RENT,SQUARE_FEET,SQUARE_FEET_DESCL,SQUARE_FEET_BASE,SQUARE_FEET_OTHER,SQUARE_FEET_SOURCE,STATUS,STATUS_DATE,STREET_NAME,STREET_NO,STREET_NUM,STYLE,SUB_AGENCY_OFFERED,SUB_AREA,TAX_YEAR,TAXES,TEAM_MEMBER,TERMS_FEATURE,TOWN_NUM,UFFI,UNIT_NO,UPDATE_DATE,UTILITY_CONNECTIONS,WARRANTY,WATERFRONT,WATERFRONT_FLAG,YEAR_BUILT,YEAR_BUILT_DESCRP,YEAR_BUILT_SOURCE,YEAR_ROUND,ZIP_CODE,ZIP_CODE_4,ZONING

Fields provided in RN file:  (131)

LIST_NO,ACRE,ADULT_COMMUNITY,AIR_CONDITION,ALERT_COMMENTS,AMENITIES,ANT_SOLD_DATE,APPLIANCES,AREA,ASSESSMENTS,AUCTION_BUYERS_PREMIUM,AUCTION_BUYERS_PREMIUM_PERCENT,AUCTION_DEPOSIT,AUCTION_SELLERS_CONFIRMATION,AUCTION_TERMS,BASEMENT,BEACH_MILES_TO,BEACHFRONT_FLAG,BLOCK,BOOK,BUYER_BROKER_COMP,CERTIFICATE_NUMBER,CONDO_ASSOCIATION,COOP_COMP,DEPOSIT_REQD,DIRECTION,DISCLOSURE,DISCLOSURES,ENTRY_ONLY,EXCLUSIONS,EXPIRE_DATE,EXTERIOR_FEATURES,FIN_CODE,FIRE_PLACES,FIRM_RMK1,FIRST_MON_REQD,FOR_SALE,FRONTAGE,GRADE_SCHOOL,HEATING,HIGH_SCHOOL,HOW_SHOWN_BB,HOW_SHOWN_FB,HOW_SHOWN_SB,INSURANCE_REQD,INTERIOR_BLDG_FEAT,LAST_MON_REQD,LEAD_PAINT,LEASE_TERMS,LIST_AGENT,LIST_DATE,LIST_DATE_RCVD,LIST_NO1,LIST_OFFICE,LIST_PRICE,LIST_PRICE_PER_SQFT,LISTING_AGREEMENT,LISTING_ALERT,LOT,LOT_SIZE,MAIN_LO,MAIN_SO,MAP,MARKET_TIME_BROKER,MARKET_TIME_PROPERTY,MASTER_BATH,MIDDLE_SCHOOL,NEIGHBORHOOD,NO_BEDROOMS,NO_FULL_BATHS,NO_HALF_BATHS,NO_ROOMS,OFF_MKT_DATE,ORIG_PRICE,OTHER_AGENT_COMP,PAGE,PARCEL_NUMBER,PARKING_SPACES,PETS_ALLOWED,PHOTO_COUNT,PHOTO_DATE,PHOTO_MASK,POSSESSION,PROP_TYPE,REFERENCES_REQD,REMARKS,RENT_FEE_INCLUDES,RENT_PRICE,RENTAL_TERMS,RN_TYPE,SALE_AGENT,SALE_OFFICE,SALE_PRICE,SEC_DEPOSIT,SELLER_CONCESSIONS_AT_CLOSING,SELLER_DISCOUNT_PTS,SELLING_BROKER_COMP,SETTLED_DATE,SHOW_INSTRUCTION,SHOWINGS_DEFERRAL_DATE,SOLD_PRICE_PER_SQFT,SOLD_VS_RENT,SQUARE_FEET,SQUARE_FEET_DESCL,SQUARE_FEET_BASE,SQUARE_FEET_OTHER,SQUARE_FEET_SOURCE,STATUS,STATUS_DATE,STREET_NAME,STREET_NO,STREET_NUM,SUB_AGENCY_OFFERED,SUB_AREA,TAX_YEAR,TAXES,TEAM_MEMBER,TERM_OF_RENTAL,TOWN_NUM,UFFI,UNIT_LEVEL,UNIT_NO,UPDATE_DATE,WATERFRONT_FLAG,YEAR_BUILT,YEAR_BUILT_DESCRP,YEAR_BUILT_SOURCE,YEAR_ROUND,ZIP_CODE,ZIP_CODE_4,ZONING

Fields provided in SF file:  (209)

LIST_NO,ACRE,ADULT_COMMUNITY,ALERT_COMMENTS,AMENITIES,ANT_SOLD_DATE,APPLIANCES,AREA,ASSESSMENTS,AUCTION_BUYERS_PREMIUM,AUCTION_BUYERS_PREMIUM_PERCENT,AUCTION_DEPOSIT,AUCTION_SELLERS_CONFIRMATION,AUCTION_TERMS,BASEMENT,BASEMENT_FEATURE,BEACH_DESCRIPTION,BEACH_MILES_TO,BEACH_OWNERSHIP,BEACHFRONT_FLAG,BED2_DIMEN,BED2_DSCRP,BED2_LEVEL,BED3_DIMEN,BED3_DSCRP,BED3_LEVEL,BED4_DIMEN,BED4_DSCRP,BED4_LEVEL,BED5_DIMEN,BED5_DSCRP,BED5_LEVEL,BLOCK,BOOK,BTH1_DIMEN,BTH1_DSCRP,BTH1_LEVEL,BTH2_DIMEN,BTH2_DSCRP,BTH2_LEVEL,BTH3_DIMEN,BTH3_DSCRP,BTH3_LEVEL,BUYER_BROKER_COMP,CERTIFICATE_NUMBER,COLOR,CONSTRUCTION,COOLING,COOLING_ZONES,DIN_DIMEN,DIN_DSCRP,DIN_LEVEL,DIRECTION,DISCLOSURE,DISCLOSURES,ELECTRIC_FEATURE,ENERGY_FEATURES,ENTRY_ONLY,EXCLUSIONS,EXPIRE_DATE,EXTERIOR,EXTERIOR_FEATURES,FAM_DIMEN,FAM_DSCRP,FAM_LEVEL,FIN_CODE,FIRE_PLACES,FIRM_RMK1,FLOORING,FOUNDATION,FOUNDATION_SIZE,FRONTAGE,GARAGE_PARKING,GARAGE_SPACES,GRADE_SCHOOL,HEAT_ZONES,HEATING,HIGH_SCHOOL,HOA_FEE,HOME_OWN_ASSOCIATION,HOT_WATER,HOW_SHOWN_BB,HOW_SHOWN_FB,HOW_SHOWN_SB,INSULATION_FEATURE,INTERIOR_FEATURES,KIT_DIMEN,KIT_DSCRP,KIT_LEVEL,LAUNDRY_DIMEN,LAUNDRY_DSCRP,LAUNDRY_LEVEL,LEAD_PAINT,LIST_AGENT,LIST_DATE,LIST_DATE_RCVD,LIST_NO1,LIST_OFFICE,LIST_PRICE,LIST_PRICE_PER_SQFT,LISTING_AGREEMENT,LISTING_ALERT,LIV_DIMEN,LIV_DSCRP,LIV_LEVEL,LOT,LOT_DESCRIPTION,LOT_SIZE,MAIN_LO,MAIN_SO,MAP,MARKET_TIME_BROKER,MARKET_TIME_PROPERTY,MASTER_BATH,MBR_DIMEN,MBR_DSCRP,MBR_LEVEL,MIDDLE_SCHOOL,NEIGHBORHOOD,NO_BEDROOMS,NO_FULL_BATHS,NO_HALF_BATHS,NO_ROOMS,OFF_MKT_DATE,ORIG_PRICE,OTH1_DIMEN,OTH1_DSCRP,OTH1_LEVEL,OTH1_ROOM_NAME,OTH2_DIMEN,OTH2_DSCRP,OTH2_LEVEL,OTH2_ROOM_NAME,OTH3_DIMEN,OTH3_DSCRP,OTH3_LEVEL,OTH3_ROOM_NAME,OTH4_DIMEN,OTH4_DSCRP,OTH4_LEVEL,OTH4_ROOM_NAME,OTH5_DIMEN,OTH5_DSCRP,OTH5_LEVEL,OTH5_ROOM_NAME,OTH6_DIMEN,OTH6_DSCRP,OTH6_LEVEL,OTH6_ROOM_NAME,OTHER_AGENT_COMP,PAGE,PARCEL_NUMBER,PARKING_FEATURE,PARKING_SPACES,PHOTO_COUNT,PHOTO_DATE,PHOTO_MASK,PROP_TYPE,REMARKS,RENT_PRICE,REQD_OWN_ASSOCIATION,ROAD_TYPE,ROOF_MATERIAL,SALE_AGENT,SALE_OFFICE,SALE_PRICE,SELLER_CONCESSIONS_AT_CLOSING,SELLER_DISCOUNT_PTS,SELLING_BROKER_COMP,SETTLED_DATE,SEWAGE_DISTRICT,SEWER_AND_WATER,SF_TYPE,SHOW_INSTRUCTION,SHOWINGS_DEFERRAL_DATE,SOLD_PRICE_PER_SQFT,SOLD_VS_RENT,SQUARE_FEET,SQUARE_FEET_DESCL,SQUARE_FEET_BASE,SQUARE_FEET_OTHER,SQUARE_FEET_SOURCE,STATUS,STATUS_DATE,STREET_NAME,STREET_NO,STREET_NUM,STYLE,SUB_AGENCY_OFFERED,SUB_AREA,TAX_YEAR,TAXES,TEAM_MEMBER,TERMS_FEATURE,TOWN_NUM,UFFI,UNIT_NO,UPDATE_DATE,UTILITY_CONNECTIONS,WARRANTY,WATERFRONT,WATERFRONT_FLAG,YEAR_BUILT,YEAR_BUILT_DESCRP,YEAR_BUILT_SOURCE,YEAR_ROUND,ZIP_CODE,ZIP_CODE_4,ZONIG

Fields provided in BU file: (135)

LIST_NO,ACRE,ADULT_COMMUNITY,ALERT_COMMENTS,ANT_SOLD_DATE,AREA,ASSESSMENTS,AUCTION_BUYERS_PREMIUM,AUCTION_BUYERS_PREMIUM_PERCENT,AUCTION_DEPOSIT,AUCTION_SELLERS_CONFIRMATION,AUCTION_TERMS,BASEMENT,BASEMENT_FEATURE,BEACHFRONT_FLAG,BLDG_SQ_FEET,BLOCK,BOOK,BU_TYPE,BUILDING_CONSTRUCTION,BUSINESS_HRS,BUYER_BROKER_COMP,CERTIFICATE_NUMBER,DIRECTION,DISCLOSURE,DISCLOSURES,DOCUMENTS_ON_FILE,ELEVATOR,ENTRY_ONLY,EQUIP_LIST_AVAIL,EXCLUSIONS,EXPIRE_DATE,FACILITIES,FIN_CODE,FIRE_PLACES,FIRM_RMK1,FORM,FRONTAGE,GRADE_SCHOOL,GROSS_ANNUAL_EXP,GROSS_ANNUAL_INCOME,HANDICAP_ACCESS,HIGH_SCHOOL,HOW_SHOWN_BB,HOW_SHOWN_FB,HOW_SHOWN_SB,INVENTORY_AVAIL,LIST_AGENT,LIST_DATE,LIST_DATE_RCVD,LIST_NO1,LIST_OFFICE,LIST_PRICE,LIST_PRICE_PER_SQFT,LISTING_AGREEMENT,LISTING_ALERT,LOCATION,LOT,LOT_SIZE,MAIN_LO,MAIN_SO,MAP,MARKET_TIME_BROKER,MARKET_TIME_PROPERTY,MASTER_BATH,MIDDLE_SCHOOL,NEIGHBORHOOD,NET_OPERATING_INC,NO_BEDROOMS,NO_FULL_BATHS,NO_HALF_BATHS,NO_OF_DRIVING_DOORS,NO_OF_LOADING_DOCKS,NO_OF_RESTROOMS,NO_ROOMS,OFF_MKT_DATE,ORIG_PRICE,OTHER_AGENT_COMP,OWNER_TRAINING,PAGE,PARCEL_NUMBER,PARKING_SPCS,PHOTO_COUNT,PHOTO_DATE,PHOTO_MASK,PROP_TYPE,REAL_ESTATE_INCLD,REAL_ESTATE_LN,REASON_FOR_SELL,REMARKS,RENT_PRICE,SALE_AGENT,SALE_OFFICE,SALE_PRICE,SELLER_CONCESSIONS_AT_CLOSING,SELLER_DISCOUNT_PTS,SELLING_BROKER_COMP,SETTLED_DATE,SHOW_INSTRUCTION,SHOWINGS_DEFERRAL_DATE,SOLD_PRICE_PER_SQFT,SOLD_VS_RENT,SPECIAL_FINANCING,SPECIAL_LICENSES,SQUARE_FEET,SQUARE_FEET_DESCL,SQUARE_FEET_BASE,SQUARE_FEET_OTHER,SQUARE_FEET_SOURCE,STATUS,STATUS_DATE,STREET_NAME,STREET_NO,STREET_NUM,SUB_AGENCY_OFFERED,SUB_AREA,SYSTEM,TAX_YEAR,TAXES,TEAM_MEMBER,TENANT_EXPENSES,TERMS_FEATURE,TOWN_NUM,TRAFFIC_COUNT,UNIT_NO,UPDATE_DATE,UTILITIES,WATERFRONT_FLAG,YEAR_BUILT,YEAR_BUILT_DESCRP,YEAR_BUILT_SOURCE,ZIP_CODE,ZIP_CODE_4,ZONE_DESCRIPTION,ZONING

Fields provided in CC file:  (229)

LIST_NO,ACRE,ADULT_COMMUNITY,ALERT_COMMENTS,AMENITIES,ANT_SOLD_DATE,APPLIANCES,AREA,ASSC_FEE_INCLUDES,ASSC_POOL,ASSESSMENTS,ASSOC_SECURITY,AUCTION_BUYERS_PREMIUM,AUCTION_BUYERS_PREMIUM_PERCENT,AUCTION_DEPOSIT,AUCTION_SELLERS_CONFIRMATION,AUCTION_TERMS,BASEMENT,BEACH_DESCRIPTION,BEACH_MILES_TO,BEACH_OWNERSHIP,BEACHFRONT_FLAG,BED2_DIMEN,BED2_DSCRP,BED2_LEVEL,BED3_DIMEN,BED3_DSCRP,BED3_LEVEL,BED4_DIMEN,BED4_DSCRP,BED4_LEVEL,BED5_DIMEN,BED5_DSCRP,BED5_LEVEL,BLOCK,BOOK,BTH1_DIMEN,BTH1_DSCRP,BTH1_LEVEL,BTH2_DIMEN,BTH2_DSCRP,BTH2_LEVEL,BTH3_DIMEN,BTH3_DSCRP,BTH3_LEVEL,BUYER_BROKER_COMP,CC_TYPE,CERTIFICATE_NUMBER,COMPLEX_COMPLETE,CONDO_ASSOCIATION,CONDOMINIUM_NAME,CONSTRUCTION,COOLING,COOLING_ZONES,DIN_DIMEN,DIN_DSCRP,DIN_LEVEL,DIRECTION,DISCLOSURE,DISCLOSURES,DOCUMENTS_ON_FILE,ELECTRIC_FEATURE,ENERGY_FEATURES,ENTRY_ONLY,EXCLUSIONS,EXPIRE_DATE,EXTERIOR,EXTERIOR_UNIT_FEATURES,FAM_DIMEN,FAM_DSCRP,FAM_LEVEL,FIN_CODE,FIRE_PLACES,FIRM_RMK1,FLOORING,FRONTAGE,GARAGE_PARKING,GARAGE_SPACES,GRADE_SCHOOL,HEAT_ZONES,HEATING,HIGH_SCHOOL,HOA_FEE,HOT_WATER,HOW_SHOWN_BB,HOW_SHOWN_FB,HOW_SHOWN_SB,INSULATION_FEATURE,INTERIOR_FEATURES,KIT_DIMEN,KIT_DSCRP,KIT_LEVEL,LAUNDRY_DIMEN,LAUNDRY_DSCRP,LAUNDRY_LEVEL,LEAD_PAINT,LIST_AGENT,LIST_DATE,LIST_DATE_RCVD,LIST_NO1,LIST_OFFICE,LIST_PRICE,LIST_PRICE_PER_SQFT,LISTING_AGREEMENT,LISTING_ALERT,LIV_DIMEN,LIV_DSCRP,LIV_LEVEL,LOT,LOT_SIZE,MAIN_LO,MAIN_SO,MANAGEMENT,MAP,MARKET_TIME_BROKER,MARKET_TIME_PROPERTY,MASTER_BATH,MASTER_BOOK,MASTER_PAGE,MBR_DIMEN,MBR_DSCRP,MBR_LEVEL,MIDDLE_SCHOOL,NEIGHBORHOOD,NO_BEDROOMS,NO_FULL_BATHS,NO_HALF_BATHS,NO_LIVING_LEVELS,NO_ROOMS,NO_UNITS,NO_UNITS_OWNER_OCC,OFF_MKT_DATE,OPT_FEE_INCLUDES,OPTIONAL_FEE,ORIG_PRICE,OTH1_DIMEN,OTH1_DSCRP,OTH1_LEVEL,OTH1_ROOM_NAME,OTH1_ROOM_NAME_LONG,OTH2_DIMEN,OTH2_DSCRP,OTH2_LEVEL,OTH2_ROOM_NAME,OTH2_ROOM_NAME_LONG,OTH3_DIMEN,OTH3_DSCRP,OTH3_LEVEL,OTH3_ROOM_NAME,OTH3_ROOM_NAME_LONG,OTH4_DIMEN,OTH4_DSCRP,OTH4_LEVEL,OTH4_ROOM_NAME,OTH4_ROOM_NAME_LONG,OTH5_DIMEN,OTH5_DSCRP,OTH5_LEVEL,OTH5_ROOM_NAME,OTH5_ROOM_NAME_LONG,OTH6_DIMEN,OTH6_DSCRP,OTH6_LEVEL,OTH6_ROOM_NAME,OTH6_ROOM_NAME_LONG,OTHER_AGENT_COMP,OWNER_OCC_SOURCE,PAGE,PARCEL_NUMBER,PARKING_FEATURE,PARKING_SPACES,PETS_ALLOWED,PHOTO_COUNT,PHOTO_DATE,PHOTO_MASK,POOL_DESCRIPTION,PROP_TYPE,REMARKS,RENT_PRICE,RESTRICTIONS,ROOF_MATERIAL,SALE_AGENT,SALE_OFFICE,SALE_PRICE,SELLER_CONCESSIONS_AT_CLOSING,SELLER_DISCOUNT_PTS,SELLING_BROKER_COMP,SETTLED_DATE,SEWAGE_DISTRICT,SEWER_AND_WATER,SHOW_INSTRUCTION,SHOWINGS_DEFERRAL_DATE,SOLD_PRICE_PER_SQFT,SOLD_VS_RENT,SQUARE_FEET,SQUARE_FEET_OTHER,SQUARE_FEET_OTHER_DESCL,SQUARE_FEET_OTHER_BASE,SQUARE_FEET_SOURCE,STATUS,STATUS_DATE,STREET_NAME,STREET_NO,STREET_NUM,STYLE,SUB_AGENCY_OFFERED,SUB_AREA,TAX_YEAR,TAXES,TEAM_MEMBER,TERMS_FEATURE,TOWN_NUM,UFFI,UNIT_LEVEL,UNIT_NO,UNIT_PLACEMENT,UPDATE_DATE,UTILITY_CONNECTIONS,WARRANTY,WATERFRONT,WATERFRONT_FLAG,YEAR_BUILT,YEAR_BUILT_DESCRP,YEAR_BUILT_SOURCE,YEAR_CONVERTED,YEAR_ROUND,ZIP_CODE,ZIP_CODE_4,ZONING

Fields provided in CI file:  (163)

LIST_NO,ACRE,ADULT_COMMUNITY,ALERT_COMMENTS,ANT_SOLD_DATE,AREA,ASSC_FEE_INCLUDES,ASSESSED_VALUE_BLDG,ASSESSED_VALUE_LAND,ASSESSMENTS,AUCTION_BUYERS_PREMIUM,AUCTION_BUYERS_PREMIUM_PERCENT,AUCTION_DEPOSIT,AUCTION_SELLERS_CONFIRMATION,AUCTION_TERMS,BASEMENT,BEACHFRONT_FLAG,BLOCK,BOOK,BUYER_BROKER_COMP,CEILING_HEIGHT,CERTIFICATE_NUMBER,CI_TYPE,CONDO_ASSOCIATION,CONSTRUCTION,DEPTH,DIRECTION,DISCLOSURE,DISCLOSURES,DIVIDABLE,EASEMENTS,ELEVATOR,ENTRY_ONLY,EXCHANGE,EXCLUSIONS,EXPANDABLE,EXPIRE_DATE,FIN_CODE,FIRE_PLACES,FIRM_RMK1,FRONTAGE,GRADE_SCHOOL,GROSS_ANNUAL_EXP,GROSS_ANNUAL_INCOME,HANDICAP_ACCESS,HIGH_SCHOOL,HOA_FEE,HOW_SHOWN_BB,HOW_SHOWN_FB,HOW_SHOWN_SB,LEASE,LEASE_PRICE_INCLUDES,LEASE_TYPE,LIEN_AND_ENCUMBENT,LIST_AGENT,LIST_DATE,LIST_DATE_RCVD,LIST_NO1,LIST_OFFICE,LIST_PRICE,LIST_PRICE_PER_SQFT,LISTING_AGREEMENT,LISTING_ALERT,LOCATION,LOT,LOT_SIZE,MAF_BLDG_SF,MAIN_LO,MAIN_SO,MAP,MARKET_TIME_BROKER,MARKET_TIME_PROPERTY,MASTER_BATH,MAU_UNITS,MIDDLE_SCHOOL,MILL_RATE,NEIGHBORHOOD,NET_OPERATING_INC,NO_BEDROOMS,NO_BUILDINGS,NO_FULL_BATHS,NO_HALF_BATHS,NO_OF_DRIVING_DOORS,NO_OF_LOADING_DOCKS,NO_OF_RESTROOMS,NO_ROOMS,NO_STORIES,NO_UNITS,OFF_BLDG_SF,OFF_MKT_DATE,OFU_UNITS,ON_FILE_21E,ORIG_PRICE,OTHER_AGENT_COMP,PAGE,PARCEL_NUMBER,PARKING_FEATURE,PARKING_SPACES,PHOTO_COUNT,PHOTO_DATE,PHOTO_MASK,PLAT_PLAN,PROP_TYPE,RAILROAD_SIDING,REF_BLDG_SF,REMARKS,RENT_PRICE,REU_UNITS,ROOF_MATERIAL,RSF_BLDG_SF,RSU_UNITS,SALE_AGENT,SALE_OFFICE,SALE_PRICE,SELLER_CONCESSIONS_AT_CLOSING,SELLER_DISCOUNT_PTS,SELLING_BROKER_COMP,SETTLED_DATE,SHOW_INSTRUCTION,SHOWINGS_DEFERRAL_DATE,SITE_CONDITION,SOLD_PRICE_PER_SQFT,SOLD_VS_RENT,SPACE_AVAILABLE,SPECIAL_FINANCING,SPRINKLERS,SQUARE_FEET,SQUARE_FEET_DESCL,SQUARE_FEET_BASE,SQUARE_FEET_OTHER,SQUARE_FEET_SOURCE,STATUS,STATUS_DATE,STREET_NAME,STREET_NO,STREET_NUM,SUB_AGENCY_OFFERED,SUB_AREA,SUB_DIVIDABLE,SUBLET,SURVEY,TAX_YEAR,TAXES,TEAM_MEMBER,TOTAL_ASSESSED_VALUE,TOTAL_BLDG_SF,TOTAL_UNITS,TOWN_NUM,TRAFFIC_COUNT,UNDRGRND_TANK,UNIT_NO,UPDATE_DATE,UTILITIES,WAF_BLDG_SF,WATERFRONT_FLAG,WAU_UNITS,YEAR_BUILT,YEAR_BUILT_DESCRP,YEAR_BUILT_SOURCE,ZIP_CODE,ZIP_CODE_4,ZONE_DESCRIPTION,ZONING

Fields provided in LD file:  (130)

LIST_NO,ACRE,ADULT_COMMUNITY,ALERT_COMMENTS,AMENITIES,ANT_SOLD_DATE,AREA,ASSESSMENTS,AUCTION_BUYERS_PREMIUM,AUCTION_BUYERS_PREMIUM_PERCENT,AUCTION_DEPOSIT,AUCTION_SELLERS_CONFIRMATION,AUCTION_TERMS,BASEMENT,BEACH_DESCRIPTION,BEACH_MILES_TO,BEACH_OWNERSHIP,BEACHFRONT_FLAG,BLOCK,BOOK,BUYER_BROKER_COMP,CABLE_AVAILABLE,CERTIFICATE_NUMBER,CULTIVATION_ACRES,DEQE,DIRECTION,DISCLOSURE,DISCLOSURES,DOCUMENTS_ON_FILE,ELECTRIC_FEATURE,ENTRY_ONLY,EXCLUSIONS,EXPIRE_DATE,FIN_CODE,FIRE_PLACES,FIRM_RMK1,FRONTAGE,GAS,GRADE_SCHOOL,HIGH_SCHOOL,HOA_FEE,HOME_OWN_ASSOCIATION,HOW_SHOWN_BB,HOW_SHOWN_FB,HOW_SHOWN_SB,IMPROVEMENTS,LAND_DESC,LD_TYPE,LIST_AGENT,LIST_DATE,LIST_DATE_RCVD,LIST_NO1,LIST_OFFICE,LIST_PRICE,LIST_PRICE_PER_SQFT,LISTING_AGREEMENT,LISTING_ALERT,LOT,LOT_SIZE,MAIN_LO,MAIN_SO,MAP,MARKET_TIME_BROKER,MARKET_TIME_PROPERTY,MASTER_BATH,MIDDLE_SCHOOL,NEIGHBORHOOD,NO_BEDROOMS,NO_FULL_BATHS,NO_HALF_BATHS,NO_LOTS,NO_ROOMS,OFF_MKT_DATE,ORIG_PRICE,OTHER_AGENT_COMP,PAGE,PARCEL_NUMBER,PASTURE_ACRES,PERC_TEST,PERC_TEST_DATE,PHOTO_COUNT,PHOTO_DATE,PHOTO_MASK,PROP_TYPE,REMARKS,RENT_PRICE,REQD_OWN_ASSOCIATION,ROAD_TYPE,SALE_AGENT,SALE_OFFICE,SALE_PRICE,SELLER_CONCESSIONS_AT_CLOSING,SELLER_DISCOUNT_PTS,SELLING_BROKER_COMP,SETTLED_DATE,SEWAGE_DISTRICT,SEWER,SHOW_INSTRUCTION,SHOWINGS_DEFERRAL_DATE,SOLD_PRICE_PER_SQFT,SOLD_VS_RENT,SQUARE_FEET,SQUARE_FEET_DISCL,SQUARE_FEET_BASE,SQUARE_FEET_OTHER,SQUARE_FEET_SOURCE,STATUS,STATUS_DATE,STREET_NAME,STREET_NO,STREET_NUM,SUB_AGENCY_OFFERED,SUB_AREA,TAX_YEAR,TAXES,TEAM_MEMBER,TIMBER_ACRES,TOWN_NUM,UNIT_NO,UPDATE_DATE,WATER,WATERFRONT,WATERFRONT_FLAG,YEAR_BUILT,YEAR_BUILT_DESCRP,YEAR_BUILT_SOURCE,ZIP_CODE,ZIP_CODE_4,ZONE_USAGE,ZONING