| Column |
Field name |
Description |
| A |
ID |
Unique number used to identify each record |
| B |
PAddress |
Physical property address |
| C, D, E |
Pcity, Pstate, Pzip |
City, state and zip of the property |
| F |
APN |
Assessor's parcel number of the property |
| G |
County |
County in which the property is located |
| H |
Powner |
Property owner’s name |
| I |
Phone |
Property owner’s phone number |
| J |
Maddress |
Mailing address of the homeowner, which may or may not be different than the property address. |
| K, L, M |
Mcity, Mstate, Mzip |
City, state and zip of the homeowner mailing address |
| N,O |
Bed, Bath |
Number of bedrooms and bathrooms |
| P |
Sqft |
Square footage of the property |
| Q |
Lotsize |
Lot size of the property |
| R |
Yearbuilt |
Year the property was built |
| S |
Reportdate |
Date the property was reported by Foreclosure Abstracts |
| T |
Recorddate |
Date the document was published by the court house |
| U |
Ptype |
Type of property |
| V |
Previoussaleprice |
Last selling price of property |
| W |
Previoussaledate |
Date of the last sale |
| X |
Ftype |
Title of the document filed at the courthouse |
| Y |
Lender |
Lenders name |
| Z |
Lphone |
Lender phone number |
| AA |
Loannum |
Loan number of the loan in foreclosure |
| AB |
Loandate |
Loan date of loan in foreclosure |
| AC |
Loanamt |
Amount of loan in foreclosure |
| AD |
Defaultamount |
Default amount of the loan |
| AE |
Asof |
When the default amount was calculated |
| AF |
Assessedvalue |
Total tax assessed value of the property |
| AG |
Docnum |
Court document number of the foreclosure document |
| AH |
Attorney/Trustee |
Name of the attorney or trustee handling the foreclosure |
| AI |
TS Number |
Trustee’s unique number to identify a property |
| AJ |
Trustee Phone |
Trustee or attorneys phone number |
| AK |
Sale Date |
Date of the foreclosure auction |
| AL |
Salelocation |
Location of the foreclosure auction |
| AM |
Bid Amount |
Minimum bid amount of the foreclosure auction |
| AN |
Loan1 Date |
Date of loan |
| AO |
Loan1 Amount |
Amount of loan |
| AP - AW |
Not used |
Not used |
| AX |
Market Value |
Market value of the property calculated using an AVM method |
| AY |
Total Loans |
Total value of listed loans |
| AZ |
Equity |
Total loans subtracted from market value |
| BA |
Loan-to-Value |
Loans divided by market value |
