Contents

Collateral Real Estate

Collateral Real Estate conditions allow you to query accounts based on real estate collateral criteria.

Condition	Table	Column	Description
1099AFiledDate	Collateral_RealEstate	1099AFiledDate	Date the lender filed a 1099-A with the IRS for the property foreclosure.
1099CFiledDate	Collateral_RealEstate	1099CFiledDate	Date the lender filed a 1099-C with the IRS for the acquisition of the secured property (or the debtor's abandonment of the property) and cancellation of the debt.
1stMortgageBalance	Collateral_RealEstate	1stMortgageBalance	Balance due on the first mortgage.
1stMortgageHolder	Collateral_RealEstate	1stMortgageHolder	Lender who holds the first mortgage.
2ndMortgageSubjecttoFirstMortgage	Collateral_RealEstate	2ndMortgageSubjecttoFirstMortgage	Indicates whether the borrower has a second mortgage on the property.
AccountID	Collateral_RealEstate	AccountID	Code that identifies the Latitude account associated to the piece of collateral.
AppraisalOrderedDate	Collateral_RealEstate	AppraisalOrderedDate	Date the lender ordered an appraisal of the property.
AttorneyDemandExpirationDate	Collateral_RealEstate	AttorneyDemandExpirationDate	Date the demand notice expires. If the borrower doesn't pay the amount specified in the demand letter, the lender starts the foreclosure process.
AttorneyDemandSent	Collateral_RealEstate	AttorneyDemandSent	Date the attorney sent notice to the borrower demanding that the borrower return the loan to good standing.
AttorneyName	Collateral_RealEstate	AttorneyName	Name of the borrower's attorney.
AttorneyPhone	Collateral_RealEstate	AttorneyPhone	Phone number of the lender's attorney.
BreachLetterDate	Collateral_RealEstate	BreachLetterDate	Date the lender sent a breach letter to the borrower to notify the borrower that the loan is in default.
CBSpecialComment	Collateral_RealEstate	CBSpecialComment	Credit Bureau special comment.
Created	Collateral_RealEstate	Created	Date the collateral was first created
CreatedBy	Collateral_RealEstate	CreatedBy	User who created the collateral
CurrentValue	Collateral_RealEstate	CurrentValue	Current appraised value of the property.
DateOfAppraisal	Collateral_RealEstate	DateOfAppraisal	Date an appraiser appraised the property.
DateSentForForeclosure	Collateral_RealEstate	DateSentForForeclosure	Date the lender sent the paperwork to the attorney to start the foreclosure process.
DeedInLieu	Collateral_RealEstate	DeedInLieu	Indicates whether the borrower conveyed all interest in the property to the lender to satisfy the loan and avoid foreclosure proceedings.
DeedRecordingDate	Collateral_RealEstate	DeedRecordingDate	Date the recorder or clerk recorded the sheriff's deed.
Description	Collateral_RealEstate	Description	Description of the property.
ForcePlacedInsurance	Collateral_RealEstate	ForcePlacedInsurance	Indicates whether the lender placed an insurance policy on the property.
ForeclosureBidAmount	Collateral_RealEstate	ForeclosureBidAmount	Amount the lender bid on the property at the foreclosure sale.
ForeclosureOrREOCode	Collateral_RealEstate	ForeclosureOrREOCode	Code that identifies the foreclosure type.
ForeclosurePetitionFiledDate	Collateral_RealEstate	ForeclosurePetitionFiledDate	Date the lender's attorney filed a petition for foreclosure with the court.
ForeclosureResolutionDate	Collateral_RealEstate	ForeclosureResolutionDate	Date the lender recovered the balance of the loan by forcing the sale of the asset used as collateral for the loan.
ForeclosureSaleDate	Collateral_RealEstate	ForeclosureSaleDate	Date the sheriff scheduled an auction to sell the property.
ForeclosureServiceDate	Collateral_RealEstate	ForeclosureServiceDate	Date the court served the borrower with the complaint for foreclosure document and a summons.
FRBCode	Collateral_RealEstate	FRBCode	Code that identifies the Federal Reserve Bank in which the lender is a member.
FREMCollateralDescription	Collateral_RealEstate	FREMCollateralDescription	Description of the First Real Estate Mortgage loan collateral.
FREMCurrentBalance	Collateral_RealEstate	FREMCurrentBalance	Current First Real Estate Mortgage loan balance.
FREMCurrentValue	Collateral_RealEstate	FREMCurrentValue	First Real Estate Mortgage's current appraised value of the property.
FREMCustomerName	Collateral_RealEstate	FREMCustomerName	Name of the First Real Estate Mortgage customer.
FREMDueDate	Collateral_RealEstate	FREMDueDate	Date the First Real Estate Mortgage loan payment is due.
FREMLoanNumber	Collateral_RealEstate	FREMLoanNumber	Number that First Real Estate Mortgage assigned to identify the loan.
FREMNoteDate	Collateral_RealEstate	FREMNoteDate	Date the borrower signed the First Real Estate Mortgage note.
FREMOriginalBalance	Collateral_RealEstate	FREMOriginalBalance	Original First Real Estate Mortgage loan balance.
FREMOriginalValue	Collateral_RealEstate	FREMOriginalValue	First Real Estate Mortgage's original appraised value of the property.
ID	Collateral_RealEstate	ID	Code that Latitude assigned to identify the real estate record in Latitude.
InternalLienPosition	Collateral_RealEstate	InternalLienPosition	Your organization's position in line in regard to benefitting from collateral liquidation. The senior position is first in line to benefit.
JudgmentAmount	Collateral_RealEstate	JudgmentAmount	Total amount that the court awarded to the lender.
JudgmentDate	Collateral_RealEstate	JudgmentDate	Date the court entered a final judgment of foreclosure against the borrower.
LoanToValuePercentage	Collateral_RealEstate	LoanToValuePercentage	It is used by the lenders to express the ratio of a loan to the value of an asset purchased
OccupantCode	Collateral_RealEstate	OccupantCode	Code that identifies the property's usage.
OriginalLoanToValuePercentage	Collateral_RealEstate	OriginalLoanToValuePercentage	It is used by the lenders to express the ratio of a loan to the original value of an asset purchased
OriginalValue	Collateral_RealEstate	OriginalValue	Original appraised value of the property.
OtherLienHolderPosition	Collateral_RealEstate	OtherLienHolderPosition	Position in line of other lien holders in regard to benefitting from collateral liquidation. The senior position is first in line to benefit.
PMI	Collateral_RealEstate	PMI	Indicates whether the borrower has private mortgage insurance on the property loan.
PropertyAddress	Collateral_RealEstate	PropertyAddress	Property's house number, street, city, state, and ZIP code.
PropertyOccupancy	Collateral_RealEstate	PropertyOccupancy	Property occupancy, such as vacant or occupied.
PropertyType	Collateral_RealEstate	PropertyType	Type of property, such as single family residence or raw land.
SaleConfirmationDate	Collateral_RealEstate	SaleConfirmationDate	Date the court approved the terms, price, and conditions of the sale.
SCRAOrderedDate	Collateral_RealEstate	SCRAOrderedDate	Date the lender obtained a court order to foreclose on the property as required under the Servicemembers Civil Relief Act.
>>> ORIGINAL //latitude/juice_su01/products/Documentation/Source/AccountAnalysis_TR/Collateral_Real_Estate.htm#3 width="95"> Sequence	Collateral_RealEstate	Sequence	Customer internal identifier for each piece of collateral.
Sequence	Collateral_RealEstate	Sequence	Client internal identifier for each piece of collateral.
Status	Collateral_RealEstate	Status	Current status of the property.
TypeOfSale	Collateral_RealEstate	TypeOfSale	Indicates whether the foreclosure sale is judicial (through a court process) or non-judicial (without a court's involvement).
Updated	Collateral_RealEstate	Updated	Date the collateral was last updated
UpdatedBy	Collateral_RealEstate	UpdatedBy	User who last updated the collateral