Listing — data dictionary
MLS listing events — list date, price, status, days-on-market. · 105 fields · source FA Listing Data Dictionary Layout v24 20250601 (v24 · 2025-06-01).
listing_duration_months feature (under leakage audit).
| Field | Type | Display | Code table | Description |
|---|---|---|---|---|
| PROPERTY ADDRESS INFORMATION | ||||
| SitusFullStreetAddress | varchar(97) | Public Display | text | Street Address: 123 S MAIN ST # 4 |
| SitusHouseNbr | varchar(50) | Public Display | text | House Number: 123 S MAIN ST # 4 |
| SitusDirectionLeft | varchar(10) | Public Display | text | Alpha characters found to the left of the street name: 123 S MAIN ST # 4 |
| SitusStreet | varchar(200) | Public Display | text | Name or number of the street. 123 S MAIN ST # 4 |
| SitusMode | varchar(10) | Public Display | text | Suffix of the Street: 123 S MAIN ST # 4 |
| SitusDirectionRight | varchar(10) | Public Display | text | Represents the quadrant of the city the street segment lies: 123 S MAIN ST NW # 4 |
| SitusUnitNbr | varchar(10) | Public Display | text | The unit or suite number of the property address: 123 S Main St # 4 |
| SitusCity | varchar(55) | Public Display | text | The city for the property address. |
| SitusState | varchar(2) | Public Display | text | Two letter state abbreviation for the property. |
| SitusZIP5 | varchar(5) | Public Display | text | Five digit code assigned by the USPS: 90001-1000 |
| SitusZIP4 | varchar(4) | Public Display | text | Four digit code assigned by the USPS: 90001-1000 |
| PROPERTY IDENTIFICATION INFORMATION | ||||
| APN | varchar(100) | No Display | text | Assessor's Parcel Number or Parcel Identification Number. An arbitrary parcel identifier assigned by the county Assessor to simplify identification and expedite the locating of parcels. |
| FIPS | varchar(5) | Public Display | text | FIPS: Federal Information Processing Standard. Five digit code. First two digits represent the STATE, while the last three digits represent the COUNTY or county equivalents. |
| PropertyID | Big int(11) | No Display | number | The First American Derived ID that uniquely identifies a property in the First American Database. |
| PropertyType | varchar(Max) | Restricted Display | text | General description of the type of property being listed (eg: Residential, Condo, Duplex, etc.) |
| PropertySubType | varchar(Max) | Restricted Display | text | Additional description of the type of property being listed |
| LotSizeSqFt | numeric(30) | Restricted Display | number | Area of the parcel, measured in square feet for the subject listing property |
| HomeSize | numeric(15) | Restricted Display | number | Square footage of the building of the subject listing property |
| PROPERTY CHARACTERISTIC INFORMATION | ||||
| Style | varchar(Max) | Restricted Display | text | Description of the subject listing property style (eg: Craftsman, Colonial, Log, etc.). |
| HeatingType | varchar(Max) | Restricted Display | text | Description of the type of heat within the subject listing property (eg: Fireplace, Central Forced Air, Water Heater, etc.). |
| HeatingFuelType | varchar(Max) | Restricted Display | text | Description of the fuel source for the heat within the subject listing property (eg: Electric, Gas, Solar, etc.). |
| CoolingType | varchar(Max) | Restricted Display | text | Description of the type of cooling system within the subject listing property (eg: Central AC, Ceiling Fan, Window/Wall Unit, etc.). |
| CoolingFuelType | varchar(Max) | Restricted Display | text | Description of the fuel source for the cooling system within the subject listing property (eg: Electric, Geothermal, Solar, etc.). |
| StoriesNbr | varchar(Max) | Restricted Display | text | Description of the number of stories for the subject listing property. |
| YearBuilt | varchar(30) | Restricted Display | text | The year the subject listing property was constructed. |
| RoofType | varchar(Max) | Restricted Display | text | Description of the type of roof for the subject listing property (eg: Clay Tile, Composition, Wood Shingle). |
| ExteriorConstruction | varchar(Max) | Restricted Display | text | Description of the type of construction used and/or features contained as part of the exterior of the subject listing property (eg: Aluminum Siding, Stone, Stucco, Dual Pane Windows, etc.) May contain multiple values per subject listing property.. |
| Bedrooms | varchar(30) | Restricted Display | text | Numeric representation of the number of bedrooms within the subject listing property. |
| Bathrooms | varchar(30) | Restricted Display | text | Numeric representation of the number of bathrooms within the subject listing property. |
| Garages | varchar(30) | Restricted Display | text | Numeric representation of the number of garages belonging to the subject listing property. |
| GarageType | varchar(Max) | Restricted Display | text | Description of the type of garage(s) belonging to the subject property (eg: Attached, Detached, Carport, etc.). |
| PoolFeatures | varchar(Max) | Restricted Display | text | Description of the type of pool(s) belonging to the subject property (eg: Granite, Spa, Under Ground, etc.). |
| ViewFeatures | varchar(Max) | Restricted Display | text | Description of any view(s) belonging to the subject property (eg: Ocean, Lake, Vista, etc.). |
| PricePerSqFt | varchar(30) | Restricted Display | text | The dollar value determination of the price per square feet. |
| Porch | varchar(Max) | Restricted Display | text | Description of the porch for the subject listing property. |
| Patio | varchar(Max) | Restricted Display | text | Description of the patio for the subject listing property. |
| Deck | varchar(Max) | Restricted Display | text | Description of the deck for the subject listing property. |
| Basement | varchar(3) | Restricted Display | text | Yes or No value representing when the subject listing property has a basement. |
| AirConditioner | varchar(Max) | Restricted Display | text | Description of the type of air conditioner for the subject listing property (eg: Central, Wall Unit, etc.) May contain multiple values per subject listing property. |
| FireplaceNbr | varchar(30) | Restricted Display | text | Numeric representation of the number of fireplaces within the subject listing property. |
| Fireplace | varchar(Max) | Restricted Display | text | Yes or No value representing when the subject listing property has a fireplace. |
| FireplaceDescription | varchar(Max) | Restricted Display | text | Description of the fireplaces belonging to a subject listing property. |
| InteriorFeatures | varchar(Max) | Restricted Display | text | Description of the interior of the subject listing property (eg: Recessed Lighting, Internet Ready, Wet Bar, etc.) May contain multiple values per subject listing property. |
| ExteriorFeatures | varchar(Max) | Restricted Display | text | Description of the type of exterior features for the subject listing property (eg: Fenced Yard, In ground irrigation, etc.) May contain multiple values per subject listing property. |
| ExistingStructures | varchar(Max) | Restricted Display | text | Description of the structures that are currently on or related to the property for sale. May contain multiple values per subject listing property. |
| LotFeatures | varchar(Max) | Restricted Display | text | Description of the features of the lot for the subject listing property (eg: Regular Lot, Premium Lot, Sloped Lot, etc.) May contain multiple values per subject listing property. |
| Zoning | varchar(Max) | Restricted Display | text | Description of the municipal zoning for the subject listing property. |
| Neighborhood | varchar(Max) | Restricted Display | text | Description of the Neighborhood as entered by the agent representing the subject property listing for sale. |
| SchoolDistrict | varchar(Max) | Restricted Display | text | Name of the school district for the subject listing property. |
| ElementarySchool | varchar(Max) | Restricted Display | text | Name of the Elementary School(s) available for the subject listing property. |
| MiddleSchool | varchar(Max) | Restricted Display | text | Name of the Middle School(s) available for the subject listing property. |
| HighSchool | varchar(Max) | Restricted Display | text | Name of the High School(s) available for the subject listing property. |
| Appliances | varchar(Max) | Restricted Display | text | Description of any appliances that are included as part of the subject listing property (eg: Dishwasher, Refrigerator, Microwave, etc.) May contain multiple values per subject listing property. |
| ApproximateLotDimensions | varchar(200) | Restricted Display | text | Numeric representation of the dimensions of the subject listing property lot. |
| Topogrophy | varchar(Max) | Restricted Display | text | Description of the land that the subject listing property resides on (eg: Level, Open Land Area, Above Grade, etc.) May contain multiple values per subject listing property. |
| WaterfrontFeatures | varchar(Max) | Restricted Display | text | Description of any applicable waterfront features for the subject listing property (eg: Lake, River, Bay, etc.) May contain multiple values per subject listing property. |
| Water | varchar(Max) | Restricted Display | text | Yes or No indicator to identify if the subject listing property has a water source connected. |
| WaterSource | varchar(Max) | Restricted Display | text | Description of the water source for the subject listing property (eg: Domestic Well, Public Water Supply, etc.) May contain multiple values per subject listing property. |
| WaterAmenities | varchar(Max) | Restricted Display | text | Description of additional features for the water for the subject listing property (eg: Sump Pump, Water Treatment System, etc.) May contain multiple values per subject listing property. |
| WaterAccess | varchar(Max) | Restricted Display | text | Description of the municipal authority responsible for providing water to the subject listing property (eg: Vista Irrigation District, City of Los Angeles, etc.). |
| WaterHeater | varchar(Max) | Restricted Display | text | Description of the water heater for the subject listing property (eg: Multi Tank Water Heater, Central Water Heater, etc.) May contain multiple values per subject listing property. |
| LISTING INFORMATION | ||||
| FAInitialListDate | date(10) | Restricted Display | yyyy-mm-dd | The first date the subject listing property was made available - as determined by FA. |
| FACalculatedDaysOnMarket | small int(10) | Restricted Display | number | Number of calendar days the subject property has been listed for sale - as determined by FA. |
| CurrentOriginalListingDate | date(10) | Restricted Display | yyyy-mm-dd | The date the subject listing property was put on the market - as per listing record. |
| InitialListStatus | varchar(30) | Restricted Display | text | A description of the initial status of the subject listing property. |
| ListingNumber | varchar(50) | Restricted Display | text | The multiple listing service identification number for the subject listing property. |
| Status | varchar(30) | Restricted Display | text | Description of the most current status of the subject listing property as it relates to the sales cycle (eg: Active, Contingent, Pending Lender Approval, etc.). |
| StatusSubType | varchar(27) | Restricted Display | text | Granular description of the most current status of the subject listing property as it relates to the sales cycle (eg: Back on Market, Bumpable Buyer, Canceled, Expired, etc.). |
| RentalIndicator | varchar(1) | Restricted Display | text | Indicates when the current listing is a rental. |
| CurrentListingPrice | varchar(15) | Restricted Display | text | Price in dollar value of the subject listing property. |
| MaxListPrice | varchar(15) | Restricted Display | text | Maximum List Price for the current listing for the subject property. |
| MaxListPriceDate | date(10) | Restricted Display | yyyy-mm-dd | Effective date for maximum list price for the current listing for the subject property. |
| MinListPrice | varchar(15) | Restricted Display | text | Minimum List Price for the current listing for the subject property. |
| MinListPriceDate | date(10) | Restricted Display | yyyy-mm-dd | Effective date for minimum list price for the current listing for the subject property. |
| SoldPrice | varchar(15) | Restricted Display | text | Price that the subject listing property has been purchased for. |
| SoldDate | date(10) | Restricted Display | yyyy-mm-dd | Date that the subject listing property has been purchased. |
| FAAdjustedSoldPrice | varchar(15) | Restricted Display | text | FA adjusted sold price value for purchased subject listing property. |
| FASoldPriceRange | varchar(31) | Restricted Display | number-number | FA adjusted sold price range value for purchased subject listing property. |
| LISTING VALUE CHANGE INFORMATION | ||||
| LastListingPriceChangeAmount | varchar(15) | Restricted Display | text | Price change dollar amount from the last listing for the subject property to the current dollar amount of the subject property. |
| LastListingPriceChangeDate | date(10) | Restricted Display | yyyy-mm-dd | Date the price change occurred between the last listing for the subject property and the current listing for the subject property. |
| PriorListingPriceChangeAmount | varchar(15) | Restricted Display | text | Price change dollar amount from the prior listing for the subject property to the last dollar amount of the subject property. |
| PriorListingPriceChangeDate | date(10) | Restricted Display | yyyy-mm-dd | Date the price change occurred between the prior listing for the subject property and the last listing for the subject property. |
| LastListingStatusChange | varchar(30) | Restricted Display | text | Status change from the last listing for the subject property to the current status of the subject property. |
| LastListingStatusChangeDate | date(10) | Restricted Display | yyyy-mm-dd | Date the status change occurred between the last listing for the subject property and the current listing for the subject property |
| LastListingStatusSubTypeChange | varchar(30) | Restricted Display | text | Status Sub Type change from the last listing for the subject property to the current status of the subject property |
| LastListingStatusSubTypeChangeDate | date(10) | Restricted Display | yyyy-mm-dd | Date the status sub type change occurred between the last listing for the subject property and the current listing for the subject property |
| PriorListingStatusChange | varchar(30) | Restricted Display | text | Status change from the prior listing for the subject property to the last status of the subject property |
| PriorListingStatusChangeDate | date(10) | Restricted Display | yyyy-mm-dd | Date the status change occurred between the prior listing for the subject property and the last listing for the subject property |
| PriorListingStatusSubTypeChange | varchar(30) | Restricted Display | text | Status Sub Type change from the prior listing for the subject property to the last status of the subject property |
| PriorListingStatusSubTypeChangeDate | date(10) | Restricted Display | yyyy-mm-dd | Date the status sub type change occurred between the prior listing for the subject property and the last listing for the subject property |
| AGENT AND OFFICE INFORMATION | ||||
| ListingAgentLicenseNumber | varchar(100) | Restricted Display | text | Listing Agent's License Number. |
| ListingAgentName | varchar(500) | Restricted Display | text | Listing Agent's Name. |
| ListingAgentAddress | varchar(1000) | Restricted Display | text | Listing Agent's Address. |
| ListingAgentPhone | varchar(30) | Restricted Display | text | Listing Agent's Phone. |
| ListingAgentEmail | varchar(50) | Restricted Display | text | Listing Agent's Email. |
| OfficeName | varchar(200) | Restricted Display | text | Office Name. |
| OfficeAddress | varchar(1000) | Restricted Display | text | Office Address. |
| OfficePhone | varchar(100) | Restricted Display | text | Office Phone. |
| OfficeEmail | varchar(100) | Restricted Display | text | Office Email. |
| FIRST AMERICAN PROCESSING INFORMATION | ||||
| ListingTrackingID | int(11) | No Display | number | Identifies a unique listing series of events and can be used to update, group & manage different stages in the listing event sequence. |
| FAUniqueListingIdentifierRefID | varchar(36) | No Display | number | FA internal record number -- 2015-09-25. |
| UpdateTimestamp | date(10) | No Display | yyyymmdd | Last date and time that record has been added or modified. |
| Add,Change,DeleteIndicator | char(1) | No Display | text | Record level indicator to determine for record should be managed on the target system. |
| CurrentListingInd | varchar(1) | No Display | text | Indicates the most current FOR SALE listing for the subject property (not available historically) - Y or blank. |
| CurrentRentalInd | varchar(1) | No Display | text | Indicates the most current FOR RENT listing for the subject property (not available historically) - Y or blank. |