| RowNo | INTEGER | True | Row# | Sequential number within a set of listings |
| RecNo | INTEGER | True | List# | Unique number identifying each listing in our system |
| StageNo | NUMERIC(1.0) | True | Stage# | Number of Stage in foreclosure process (1=PreSale, 2=Sale, 3=PostSale) |
| StageNm | VARCHAR(20) | True | Stage | Name of Stage in foreclosure process (state-specific) |
| State | CHAR(2) | True | State | Property State |
| CountyNo | CHAR(5) | True | County# | Federal Information Processing Standard code for Property County |
| CountyNm | VARCHAR(40) | True | County | Property County |
| PubDate | DATE | True | Publish Date | Date the record was published by foreclosureS.com |
| MktVal | CURRENCY | False | Market Val | Estimated Market Value of the Property |
| MktHigh | CURRENCY | False | High End | High end of reasonable range for Market Value |
| MktLow | CURRENCY | False | Low End | Low end of reasonable range for Market Value |
| DocNo | VARCHAR(15) | False | # | County Recorder's Instrument# (or Book#-Page# if no Instrument# provided, see DocBkPg below) for this listing |
| APN | VARCHAR(45) | False | APN | County Assessor's Parcel Number for the Property |
| HouseNo | VARCHAR(12) | False | House# | Property House Number |
| StreetNm | VARCHAR(100) | True | Street Name | Property Street Name (or description) |
| UnitNo | VARCHAR(25) | False | Unit# | Property Unit Number |
| Address | VARCHAR(200) | True | Address | Property Address (House + Street + Unit) |
| City | VARCHAR(40) | True | City | Property City Name |
| ZipCode | CHAR(5) | True | Zip | Property Zip Code |
| Zip4 | CHAR(4) | False | Zip+4 | Property Zip+4 |
| LoanRcDt | DATE | False | Loan Date | Date on which the loan being foreclosed on was originally recorded |
| LoanAmt | CURRENCY | False | Loan Amount | Amount financed by the loan being foreclosed on |
| LoanDocN | VARCHAR(15) | False | Loan Doc# | County Recorder's Instrument# (or Book#-Page# if no Instrument# provided, see LoanBkPg below) for the loan being foreclosed on |
| CrtCasNo | VARCHAR(20) | False | Court Case# | Court Case Number |
| TrSaleNo | VARCHAR(25) | False | Trustee Sale# | Trustee's Sale Number |
| AuctDate | DATE | False | Auction Date | Proposed date for Property to be sold at Auction |
| AuctTime | VARCHAR(5) | False | Auction Time | Time of the Proposed Auction |
| MinBid | CURRENCY | False | Minimum Bid | Minimum amount the Lender will accept for the Property |
| EqAmt | CURRENCY | False | Equity | Estimate of Equity, based on Market Value estimate and Loan Amount (Stage 1) or Minimum Bid (Stage 2) |
| EqPct | NUMERIC(3.0) | False | Equity% | Equity estimate as a percentage of Market Value estimate |
| DefltDat | DATE | False | As Of | Date 'as of' which the Lender calculated the Amount needed to bring the loan current |
| DefltAmt | CURRENCY | False | Delinq Amt | Delinquent Amount needed to bring the loan current |
| RepoDate | DATE | False | Repo Date | Date on which the Grantee took title (Stage 3) |
| RepoAmt | CURRENCY | False | Repo Amount | Amount for which the Grantee took title (Stage 3) |
| DocType | VARCHAR(40) | True | Doc Type | Specific type of Foreclosure Document or Deed |
| LienType | VARCHAR(10) | False | Lien Type | Identifies whether the loan being foreclosed on was a Mortgage, Homeowner's Association Lien, or Mechanic's Realty Lien |
| OwnerNm | VARCHAR(250) | False | Trustor/Grantee |
For Preforeclosures and Auctions, this is the Borrower (Trustor) on the Loan being foreclosed on, also known as the Defendant.
If the Current Owner is listed contact the Current Owner.
For REO / Bank Owned, this is the new owner on title(Grantee) after sale, which is often the Lender/Plaintiff (Beneficiary),
but may also be a third-party investor who submitted the winning bid at the Auction.
Note that this can be multiple names separated by commas; see OwnerNm1 (below).
The Trustor Name is used when completing a title search, along with the Current Owner, to determine what is owed on the property.
Click here to read Your Fastest Way to Find "What is Owed." |
| OwnerHNo | VARCHAR(12) | False | Mailing House# | Owner Mailing House Number |
| OwnerSNm | VARCHAR(100) | False | Mailing Street Name | Owner Mailing Street Name |
| OwnerUNo | VARCHAR(25) | False | Mailing Unit# | Owner Mailing Unit Number |
| OwnerAdr | VARCHAR(200) | False | Owner Mailing | Owner Mailing Address (House + Street + Unit).
Note that this is the same as the Property Address, unless the Absentee Flag (below) is Y.
Note also that this is still the Address of the FORECLOSED owner after sale (Stage 3)); see OwnerNm1 (below).
|
| OwnerCty | VARCHAR(40) | True | Mailing City | Owner Mailing City Name (State is below) |
| OwnerZip | CHAR(5) | True | Mailing Zip | Owner Mailing Zip Code |
| OwnerZp4 | CHAR(4) | False | Mailing Zip+4 | Owner Mailing Zip+4 |
| AttyName | VARCHAR(80) | False | Attorney | Attorney retained by the Lender (Plaintiff) or their Agent (Trustee) |
| AttyPhon | CHAR(12) | False | Attorney Phone | Attorney's Phone Number |
| Plaintff | VARCHAR(200) | False | Plaintiff | Entity used in the court case against the Borrower, generally the Lender (Creditor) or Trustee |
| LndrName | VARCHAR(150) | False | Lender | Lender or other Beneficiary of the loan being foreclosed on |
| LndrPhon | CHAR(12) | False | Lender Phone | Lender's Phone Number |
| LndrAddr | VARCHAR(100) | False | Lender Address | Lender's Mailing Address |
| LndrCity | VARCHAR(40) | False | Lender City | Lender's Mailing City |
| LndrStat | CHAR(2) | False | Lender State | Lender's Mailing State |
| LndrZip | CHAR(5) | False | Lender Zip | Lender's Mailing Zip Code |
| LndrZip4 | CHAR(4) | False | Lender Zip+4 | Lender's Mailing Zip+4 |
| TrstName | VARCHAR(70) | False | Trustee | Lender's Agent, and/or the entity or person conducting the Sale (Referee) |
| TrstPhon | CHAR(12) | False | Trustee Phone | Trustee's Phone Number |
| TrstAddr | VARCHAR(60) | False | Trustee Address | Trustee's Mailing Address |
| TrstCity | VARCHAR(40) | False | Trustee City | Trustee's Mailing City |
| TrstStat | CHAR(2) | False | Trustee State | Trustee's Mailing State |
| TrstZip | CHAR(5) | False | Trustee Zip | Trustee's Mailing Zip Code |
| TrstZip4 | CHAR(4) | False | Trustee Zip+4 | Trustee's Mailing Zip+4 |
| AuctAddr | VARCHAR(80) | False | Auction Place | Location of the Proposed Auction |
| AuctCity | VARCHAR(40) | False | Auction City | City of the Location of the Proposed Auction |
| YrBuilt | NUMERIC(4.0) | False | Year | Year in which the Primary Building on the Property was constructed |
| LvngSqFt | NUMERIC(9.0) | False | SqFt | Approximate area of the Primary Building on the Property |
| LotAcre | NUMERIC(5.2) | False | Lot Ac | Approximate area of the Property, in acres |
| Beds | NUMERIC(5.0) | False | Beds | Number of Bedrooms in the Primary Building on the Property |
| Baths | NUMERIC(3.2) | False | Baths | Number of Bathrooms in the Primary Building on the Property (including halves or quarters) |
| Garages | NUMERIC(3.0) | False | Garages | Number of inside Parking Spaces on the Property |
| Units | NUMERIC(5.0) | False | Units | Number of Units in the Property |
| TypeGrp | VARCHAR(40) | False | Property Type Group | Name for general Property Type |
| TypeCode | CHAR(3) | False | Property Type Code | Unique Code for specific Property Type |
| TypeName | VARCHAR(40) | False | Prop Type | Name for specific Property Type |
| AsesdAmt | CURRENCY | False | Assessed | Property Tax Assessment Value (Do not use as Market Value. Used to calculate a properties annual tax bill for the year) |
| AsesdYr | NUMERIC(4.0) | False | Assessed Yr | Property Tax Assessment Fiscal Tax Year |
| Absentee | CHAR(1) | True | Absentee Flag | Whether Owner Mailing Address is different from Property Address |
| OwnrSt | VARCHAR(10) | False | Mailing State | Owner Mailing State |
| RecDate | DATE | True | Recording Date |
Date the document was recorded by or filed with the County.
If no such date is available, this will be the same as the Publish Date (above).
|
| AddlInfo | VARCHAR(150) | False | Additional Info | Any information we can provide (as a courtesy, not guaranteed)
which does not fit into one of the other fields.
List of information provided as courtesy:
Investors' Choice - Potential leads missing Tax Assessors information.
For investors who don’t mind doing the extra leg work, these often overlooked leads can be very promising.
These are possible properties with equity or developers looking to build on vacant and undeveloped land.
|
| Thomas | VARCHAR(11) | False | TM | Thomas Brothers Map-Grid (as listed by the County, e.g. '1234-A1') |
| OwnerNm1 | VARCHAR(80) | False | Current/Previous Owner (Mailin |
One name to go with the Owner Mailing Address.
For Preforeclosures and Auctions, if the Current Owner is different from Trustor, they have purchased the Trustor's home, buth ave not paid off the loans (used a subject to purchase). This is the current owner and person to contact regarding the property; see OwnerDif (directly below).
For REO / Bank Owned, this is the FORECLOSED owner's name if known; see OwnerNm (above).
|
| OwnerDif | CHAR(1) | True | Owner Change Flag |
Whether OwnerNm1 (directly above) is different from the primary OwnerNm (above).
This is the case in Stage 1 and 2 if a new owner has taken over the property and the loan, or if the owner's legal name changed due to marital or trust status,
or if a foreclosure has already occurred and was contested. For Stage 3, this is the case if the FORECLOSED owner's name is known.
|
| BorGrtPh | CHAR(12) | False | Trustor/Grantee Phone | Phone Number for Borrower (Trustor/Defendant) on Stage 1 and 2, or new owner (Grantee) after sale (Stage 3). |
| UpdateDt | DATE | False | Updated | Date after PubDate, if any, on which this listing was last updated in our system (indicates a minor change). |
| OrgPubDt | DATE | False | Orig. Pub. |
Date before PubDate, if any, on which this listing was originally published in our system
(indicates a change affecting your ability to locate the property or its owner).
|
| DocBkPg | VARCHAR(15) | False | Doc Bk-Pg# | County Recorder's Book#-Page# (if provided in addition to Instrument#, see DocNo above) for this listing |
| DocBook | VARCHAR(15) | False | Doc Book# | County Recorder's Book# for this listing (in SharkBait this appears in the Assessor's Map Book field) |
| DocPage | VARCHAR(15) | False | Doc Page# | County Recorder's Page# for this listing (in SharkBait this appears in the Assessor's Map Page field) |
| LoanBkPg | VARCHAR(15) | False | Loan Bk-Pg# | County Recorder's Book#-Page# (if provided in addition to Instrument#, see LoanDocN above) for the loan being foreclosed on |
| LoanBook | VARCHAR(15) | False | Loan Book# | County Recorder's Book# for the loan being foreclosed on |
| LoanPage | VARCHAR(15) | False | Loan Page# | County Recorder's Page# for the loan being foreclosed on |
| UpdtMsg | VARCHAR(80) | False | Orig. Pub., Updated | Text message including Originally Published Date (OrgPubDt) and Updated Date (UpdateDt), if any |
| Legal | VARCHAR(250) | False | Property Legal Desc. | County Assessor's Legal Description for the Property |
| InCareOf | VARCHAR(60) | False | In Care Of | Recipient of Tax Statements |
| SaleAmt | CURRENCY | False | Last Sale Amount | Amount of Last Full transfer (This is the amount for which the owner purchased the property.) |
| SaleDt | DATE | False | Last Sale Date |
Date of last Full Transfer (Owner took title of property)
• If "Deeded", the loan was part of a sale transaction
|
| SaleDocNo | VARCHAR(15) | False | Sale Doc# | County Recorder's Instrument # of the transaction. |
| SaleDocBkPg | VARCHAR(15) | False | Sale Bk-Pg# | County Recorder's Book-Page# of the transaction. |
| TransAmt | CURRENCY | False | Transferred For |
Amount paid the last time the property changed hands, according to the County Assessors.
Note that this can be a very small amount, depending on the nature of the transaction. (2nd loan, etc.)
|
| TransfDt | DATE | False | Transferred On |
Date when the property last changed hands, according to the County Assessors.
• If "Transferred On" date is earlier than the loan recording date (LoanRcDt), the loan was a refinance or additional loan;
• If "Transferred On" date is later than the loan recording date, there was a change in ownership subject to the loan.
|
| TransDocNo | VARCHAR(15) | False | Transfer Doc# | County Recorder's Instrument # of the last transaction. |
| TransDocBkPg | VARCHAR(15) | False | Transfer Bk-Pg# | County Recorder's Book-Page# of the last transaction. |
| FirstMissedPaymentDate | DATE | False | First Missed Payment Date | Due date of the mortage payment, or the date of the first missed payment. |
| IsGranteeForeclosingBene | CHAR(1) | False | Grantee Foreclosing Beneficiar | Whether or not the grantee was the foreclosing beneficiary. |
| Disclaimer | VARCHAR(155) | False | Disclaimer | Legal Disclaimer |