# Lookup deeds for a property The LookupDeeds endpoint returns an array of deeds and/or transactions from the recorder table when given the Property MAK or the FIPs and APN. The following are the possible minimum input requirements: - FIPS and APN - PropertyMAK - FreeForm Endpoint: POST /LookupDeeds ## Request fields (application/json): - `Columns` (string) [Columns](https://docs.melissa.com/cloud-api/property/property-reference-guide.html#property-referenceguide-lookupdeeds-columns) - The column names or groups to be output. Entering the column name will return the column. Specifying a group name will return all columns in the group. Delimit multiple columns with a ,. For example: ColumnName,ColumnName. Columns: GrpAll - Recommended. Indicates to the Cloud API that all fields should be returned. GrpDocInfo - Deed document information - Book - InstrumentDate - InstrumentNumber - NumberFormatted (Deprecated) - NumberLegacy (Deprecated) - Page - RecordingDate - TypeCode GrpTxDefInfo - Deed transaction details & info - ArmsLengthFlag - ForeclosureAuctionSale - PartialInterest - QuitclaimFlag - TransactionType - TransferInfoDistressCircumstanceCode - TransferInfoMultiParcelFlag - TransferInfoPurchaseTypeCode (Deprecated) GrpTxAmtInfo - Deed transaction amount info - TransferAmount - TransferAmountInfoAccuracy - TransferTaxCounty - TransferTaxTotal GrpPrimaryGrantor - Primary deed grantor names - Name1ClassType - Name1First - Name1Full - Name1Last - Name1LegalType - Name1Middle - Name1Suffix - Name2ClassType - Name2First - Name2Full - Name2Last - Name2LegalType - Name2Middle - Name2Suffix GrpSecondaryGrantor (Deprecated) - Secondary deed grantor names - Name3ClassType (Deprecated) - Name3First (Deprecated) - Name3Full (Deprecated) - Name3Last (Deprecated) - Name3Middle (Deprecated) - Name3Suffix (Deprecated) - Name4ClassType (Deprecated) - Name4First (Deprecated) - Name4Full (Deprecated) - Name4Last (Deprecated) - Name4Middle (Deprecated) - Name4Suffix (Deprecated) GrpPrimaryGrantee - Primary deed grantee names - Name1ClassType - Name1First - Name1Full - Name1Last - Name1LegalType - Name1Middle - Name1Suffix - Name2ClassType - Name2First - Name2Full - Name2Last - Name2Middle - Name2Suffix GrpSecondaryGrantee (Deprecated) - Secondary deed grantee names - Name3ClassType (Deprecated) - Name3First (Deprecated) - Name3Full (Deprecated) - Name3Last (Deprecated) - Name3Middle (Deprecated) - Name3Suffix (Deprecated) - Name4ClassType (Deprecated) - Name4First (Deprecated) - Name4Full (Deprecated) - Name4Last (Deprecated) - Name4Middle (Deprecated) - Name4Suffix (Deprecated) GrpTitleCompInfo - Title company info - StandardizedCode (Deprecated) - StandardizedName - TitleCompanyRaw GrpMortgage1 - First mortgage info - AdjustableRateIndex - AdjustableRateRiderFlag - Amount - Book - DocNumberFormatted - DocNumberLegacy (Deprecated) - FixedStepConvRate (Deprecated) - InstrumentNumber - InterestChangeFreq - InterestIndex (Deprecated) - InterestMargin - InterestOnlyFlag - InterestOnlyPeriod - InterestRate - InterestRateMax - InterestRateType - InterestTypeChangeDate - InterestTypeInitial - IsLenderSeller - LenderAddress (Deprecated) - LenderCity (Deprecated) - LenderCode (Deprecated) - LenderFirstName - LenderFullName - LenderLastName - LenderState (Deprecated) - LenderType - LenderZip (Deprecated) - MaxInterestRateFirstChange - MinInterestRateFirstChange - Page - PrepaymentPenaltyFlag - PrepaymentTerm - RecordingDate - Term (Deprecated) - TermDate - TermType (Deprecated) - Type GrpMortgage2 (Deprecated) - Second mortgage info - AdjustableRateIndex (Deprecated) - AdjustableRateRiderFlag (Deprecated) - Amount (Deprecated) - Book (Deprecated) - DocNumberFormatted (Deprecated) - DocNumberLegacy (Deprecated) - FixedStepConvRate (Deprecated) - InstrumentNumber (Deprecated) - InterestChangeFreq (Deprecated) - InterestIndex (Deprecated) - InterestMargin (Deprecated) - InterestOnlyFlag (Deprecated) - InterestOnlyPeriod (Deprecated) - InterestRate (Deprecated) - InterestRateMax (Deprecated) - InterestRateType (Deprecated) - InterestTypeChangeDate (Deprecated) - InterestTypeInitial (Deprecated) - IsLenderSeller (Deprecated) - LenderAddress (Deprecated) - LenderCity (Deprecated) - LenderCode (Deprecated) - LenderFirstName (Deprecated) - LenderFullName (Deprecated) - LenderLastName (Deprecated) - LenderState (Deprecated) - LenderType (Deprecated) - LenderZip (Deprecated) - MaxInterestRateFirstChange (Deprecated) - MinInterestRateFirstChange (Deprecated) - Page (Deprecated) - PrepaymentPenaltyFlag (Deprecated) - PrepaymentTerm (Deprecated) - RecordingDate (Deprecated) - Term (Deprecated) - TermDate (Deprecated) - TermType (Deprecated) - Type (Deprecated) GrpValuation (Deprecated) - Estimated down payment and LTV values - EstDownPayment (Deprecated) - EstLTV (Deprecated) - `Format` (string) Desired format of the response. Enum: "json", "xml" - `CustomerId` (string, required) The [License Key](https://docs.melissa.com/melissa/license/license-information.html) issued by Melissa. - `Options` (string) [Options](https://docs.melissa.com/cloud-api/property/property-reference-guide.html#property-referenceguide-lookupdeeds-options) - Specify which options to use. List options in : format. Multiple options are delimited with a ,. For example: OptionName:Parameter,OptionName:Parameter. - Page: - Specifies which “page” to return. Acceptable values are any integer. - RecordsPerPage: - Default set to 1. Sets the records per “page”. Acceptable values are 0 to 100, inclusive. - `TransmissionReference` (string) This is a string value that serves as a unique identifier for this set of records. It is returned as sent. - `APN` (string) Assessor's Parcel Number (APN) for the property. - `FIPS` (string) Federal Information Processing Standard (FIPS) code for the property. - `FreeForm` (string) Free form address for the property. - `PropertyMAK` (string) A proprietary unique key identifier for an address derived from Address Checking. - `TransactionID` (string) Specific transaction ID to specify one deed or transaction. ## Response 200 fields (application/json): - `Version` (string) The current service version number. - `TransmissionReference` (string) Optional. Serves as a unique request identifier. - `Results` (string) Lists error codes from any errors caused by the most recent request as a whole. For more information, see [Property Result Codes](https://docs.melissa.com/cloud-api/property/result-codes.html). - `TotalRecords` (integer) Total number of records. - `Records` (array) - `Records.DocInfo` (object) - `Records.DocInfo.Book` (string) The document number book. This can contain either the recorder document book or the legal description book. - `Records.DocInfo.InstrumentDate` (string) The execution date with the format: YYYY-MM-DD. This pre-dates the RecordingDate and may be the notary date. - `Records.DocInfo.InstrumentNumber` (string) If the document is indexed by a recorder's reference number, this will contain that number. Usually the year will not be added to this field unless there is a regional requirement. - `Records.DocInfo.Page` (string) The document number page. This can contain either the recorder document page or the legal description page. - `Records.DocInfo.RecordingDate` (string) The official filing date with the format: YYYY-MM-DD. This is normally located on the document. - `Records.DocInfo.TypeCode` (string) The type of document. E.g. grand deed, quit claim, etc. - `Records.DocInfo.NumberFormatted` (string) The document number based on the document book, page, or instrument number. - `Records.DocInfo.NumberLegacy` (string) The document number from a previous platform, if different than NumberFormatted. - `Records.TxDefInfo` (object) - `Records.TxDefInfo.ArmsLengthFlag` (string) Specifies the transfer was between two unrelated parties. - `Records.TxDefInfo.ForeclosureAuctionSale` (string) Specifies if the transaction was due to a foreclosure auction. - `Records.TxDefInfo.PartialInterest` (string) Specifies what percentage of the legal ownership was transferred. - `Records.TxDefInfo.QuitclaimFlag` (string) Specifies if the transaction is a Quit claim. - `Records.TxDefInfo.TransactionType` (string) The transaction type. - `Records.TxDefInfo.TransferInfoDistressCircumstanceCode` (string) A distress scenario code. - `Records.TxDefInfo.TransferInfoMultiParcelFlag` (string) Specifies if the transaction has multiple parcels. - `Records.TxDefInfo.TransferInfoPurchaseTypeCode` (string) The type of resale transaction. E.g. construction, subdivision, etc. - `Records.TxAmtInfo` (object) - `Records.TxAmtInfo.TransferAmount` (string) The amount, in dollars, of consideration in an ownership changing transaction. - `Records.TxAmtInfo.TransferAmountInfoAccuracy` (string) The type of transaction. - `Records.TxAmtInfo.TransferTaxCounty` (string) This amount is a rate levied by the state per $1,000 of consideration paid in the transaction. Often this is a transfer tax stamp on the document. This may be the full sales price or only the equity transferred with any new financing, depending on the state. - `Records.TxAmtInfo.TransferTaxTotal` (string) The total of the city and county transfer tax amounts. Unique to some regions. - `Records.PrimaryGrantor` (object) - `Records.PrimaryGrantor.Name1ClassType` (string) Describes the class of the primary seller based off of the name and vesting. E.g. individual, trust, company. - `Records.PrimaryGrantor.Name1First` (string) The first name of the primary seller. - `Records.PrimaryGrantor.Name1Full` (string) The full name of the primary seller. - `Records.PrimaryGrantor.Name1Last` (string) The last name of the primary seller. - `Records.PrimaryGrantor.Name1LegalType` (string) The legal ownership type of the primary seller. E.g. married, beneficiary, etc. - `Records.PrimaryGrantor.Name1Middle` (string) The parsed middle name or initial of the primary seller. - `Records.PrimaryGrantor.Name1Suffix` (string) The suffix of the primary seller. E.g. Jr, III, etc. - `Records.PrimaryGrantor.Name2ClassType` (string) Describes the class of the secondary seller based off of the name and vesting. E.g. individual, trust, company. - `Records.PrimaryGrantor.Name2First` (string) The first name of the secondary seller. - `Records.PrimaryGrantor.Name2Full` (string) The full name of the secondary seller. - `Records.PrimaryGrantor.Name2Last` (string) The last name of the secondary seller. - `Records.PrimaryGrantor.Name2LegalType` (string) The legal ownership type of the secondary seller. E.g. married, beneficiary, etc. - `Records.PrimaryGrantor.Name2Middle` (string) The parsed middle name or initial of the secondary seller. - `Records.PrimaryGrantor.Name2Suffix` (string) The suffix of the secondary seller. E.g. Jr, III, etc. - `Records.PrimaryGrantee` (object) - `Records.PrimaryGrantee.Name1ClassType` (string) Describes the class of the primary buyer or borrower based off of the name and vesting. E.g. individual, trust, company. - `Records.PrimaryGrantee.Name1First` (string) The first name of the primary buyer or borrower. This will be blank if this is not an individual. - `Records.PrimaryGrantee.Name1Full` (string) The full name of the primary buyer or borrower. - `Records.PrimaryGrantee.Name1Last` (string) The last name of the primary buyer or borrower. This will be the full name if this is not an individual. - `Records.PrimaryGrantee.Name1LegalType` (string) The legal ownership type of the primary buyer or borrower. E.g. married, beneficiary, etc. - `Records.PrimaryGrantee.Name1Middle` (string) The parsed middle name or initial of the primary buyer or borrower. - `Records.PrimaryGrantee.Name1Suffix` (string) The suffix of the primary buyer or borrower. E.g. Jr, III, etc. - `Records.PrimaryGrantee.Name2ClassType` (string) Describes the class of the secondary buyer or borrower based off of the name and vesting. E.g. individual, trust, company. - `Records.PrimaryGrantee.Name2First` (string) The first name of the secondary buyer or borrower. This will be blank if this is not an individual. - `Records.PrimaryGrantee.Name2Full` (string) The full name of the secondary buyer or borrower. - `Records.PrimaryGrantee.Name2Last` (string) The last name of the secondary buyer or borrower. This will be the full name if this is not an individual. - `Records.PrimaryGrantee.Name2Middle` (string) The parsed middle name or initial of the secondary buyer or borrower. - `Records.PrimaryGrantee.Name2Suffix` (string) The suffix of the secondary buyer or borrower. E.g. Jr, III, etc. - `Records.TitleCompInfo` (object) - `Records.TitleCompInfo.StandardizedName` (string) The standardized name of the title company. - `Records.TitleCompInfo.TitleCompanyRaw` (string) The entered name of the title company. This is not standardized. - `Records.TitleCompInfo.StandardizedCode` (string) The standard code identifying the title company. - `Records.Mortgage1` (object) - `Records.Mortgage1.AdjustableRateIndex` (string) The benchmark interest rate the first mortgage's adjustable rate is based on. - `Records.Mortgage1.AdjustableRateRiderFlag` (string) Specifies if the property has an adjustable rate mortgage rider, where the loan interest rate will change on a set date. - `Records.Mortgage1.Amount` (string) The loan amount of the first mortgage. - `Records.Mortgage1.Book` (string) The first mortgage number book. This can contain either the recorder document book or the legal description book. - `Records.Mortgage1.DocNumberFormatted` (string) The first mortgage number based on the book, page, or instrument number. - `Records.Mortgage1.InstrumentNumber` (string) If the first mortgage is indexed by a recorder's reference number, this will contain that number. Usually the year will not be added to this field unless there is a regional requirement. - `Records.Mortgage1.InterestChangeFreq` (string) The frequency at which interest rates might change. - `Records.Mortgage1.InterestMargin` (string) The fixed percentage rate added to an index value to determine the fully indexed interest rate of an adjustable rate mortgage for the first mortgage. - `Records.Mortgage1.InterestOnlyFlag` (string) Specifies if the first mortgage has an interest only period. - `Records.Mortgage1.InterestOnlyPeriod` (string) The length of the interest only period, in years. - `Records.Mortgage1.InterestRate` (string) The interest rate of the first mortgage. - `Records.Mortgage1.InterestRateMax` (string) The maximum interest rate allowed for the first mortgage, if it is an adjustable rate. - `Records.Mortgage1.InterestRateType` (string) The interest rate type for the first mortgage. - `Records.Mortgage1.InterestTypeChangeDate` (string) Specifies what date the loan will convert from a fixed interest rate to an adjustable interest rate in the format: YY-MM-DD (2-digit year, e.g. 2030 = “30”) - `Records.Mortgage1.InterestTypeInitial` (string) The initial type of interest rate on the first mortgage. E.g. fixed or adjustable. - `Records.Mortgage1.IsLenderSeller` (string) Specifies if the lender is also the seller for the first mortgage. - `Records.Mortgage1.LenderFirstName` (string) The first name of the first mortgage lender. This will be the complete name if the lender is a company. - `Records.Mortgage1.LenderFullName` (string) The full standardized name of the lender for the first mortgage. - `Records.Mortgage1.LenderLastName` (string) The last name of the first mortgage lender. - `Records.Mortgage1.LenderType` (string) The lender type for the first mortgage. - `Records.Mortgage1.MaxInterestRateFirstChange` (string) The maximum interest rate allowed when the loan is switched from a fixed to an adjustable interest rate. - `Records.Mortgage1.MinInterestRateFirstChange` (string) The minimum interest rate allowed when the loan is switched from a fixed to an adjustable interest rate. - `Records.Mortgage1.Page` (string) The first mortgage number page. This can contain either the recorder document page or the legal description page. - `Records.Mortgage1.PrepaymentPenaltyFlag` (string) Specifies if the first mortgage has a pre-payment penalty. - `Records.Mortgage1.PrepaymentTerm` (string) The number of months the first mortgage must remain active. - `Records.Mortgage1.RecordingDate` (string) The first mortgage official filing date with the format: YYYY-MM-DD. This is normally located on the document. - `Records.Mortgage1.TermDate` (string) The due date of the first mortgage. - `Records.Mortgage1.Type` (string) The type of loan for the first mortgage. E.g. conventional, construction, FHA, etc. - `Records.Mortgage1.DocNumberLegacy` (string) The first mortgage loan instrument, book, or page number located on the first sequence trust deed. - `Records.Mortgage1.FixedStepConvRate` (string) The interest rate change in a fixed step conversion mortgage for the first mortgage. - `Records.Mortgage1.InterestIndex` (string) The benchmark interest rate the first mortgage’s rate is based on. - `Records.Mortgage1.LenderAddress` (string) The address of the first mortgage lender. - `Records.Mortgage1.LenderCity` (string) The city of the first mortgage lender. - `Records.Mortgage1.LenderCode` (string) The standard ID code of the lender for the first mortgage. - `Records.Mortgage1.LenderState` (string) The state of the first mortgage lender. - `Records.Mortgage1.LenderZip` (string) The ZIP Code of the first mortgage lender. - `Records.Mortgage1.Term` (string) The duration of the first mortgage. See the associated TermType to know the unit of measurement. - `Records.Mortgage1.TermType` (string) The duration unit of measurement (month, year) for the first mortgage. See the associated Term to know the duration. - `Records.SecondaryGrantor` (object) - `Records.SecondaryGrantor.Name3ClassType` (string) Describes the class of the third seller based off of the name and vesting. E.g. individual, trust, company. - `Records.SecondaryGrantor.Name3First` (string) The first name of the third seller. - `Records.SecondaryGrantor.Name3Full` (string) The full name of the third seller. - `Records.SecondaryGrantor.Name3Last` (string) The last name of the third seller. - `Records.SecondaryGrantor.Name3Middle` (string) The parsed middle name or initial of the third seller. - `Records.SecondaryGrantor.Name3Suffix` (string) The suffix of the third seller. E.g. Jr, III, etc. - `Records.SecondaryGrantor.Name4ClassType` (string) Describes the class of the fourth seller based off of the name and vesting. E.g. individual, trust, company. - `Records.SecondaryGrantor.Name4First` (string) The first name of the fourth seller. - `Records.SecondaryGrantor.Name4Full` (string) The full name of the fourth seller. - `Records.SecondaryGrantor.Name4Last` (string) The last name of the fourth seller. - `Records.SecondaryGrantor.Name4Middle` (string) The parsed middle name or initial of the fourth seller. - `Records.SecondaryGrantor.Name4Suffix` (string) The suffix of the fourth seller. E.g. Jr, III, etc. - `Records.SecondaryGrantee` (object) - `Records.SecondaryGrantee.Name3ClassType` (string) Describes the class of the third buyer or borrower based off of the name and vesting. E.g. individual, trust, company. - `Records.SecondaryGrantee.Name3First` (string) The first name of the third buyer or borrower. This will be blank if this is not an individual. - `Records.SecondaryGrantee.Name3Full` (string) The full name of the third buyer or borrower. - `Records.SecondaryGrantee.Name3Last` (string) The last name of the third buyer or borrower. This will be the full name if this is not an individual. - `Records.SecondaryGrantee.Name3Middle` (string) The parsed middle name or initial of the third buyer or borrower. - `Records.SecondaryGrantee.Name3Suffix` (string) The suffix of the third buyer or borrower. E.g. Jr, III, etc. - `Records.SecondaryGrantee.Name4ClassType` (string) Describes the class of the fourth buyer or borrower based off of the name and vesting. E.g. individual, trust, company. - `Records.SecondaryGrantee.Name4First` (string) The first name of the fourth buyer or borrower. This will be blank if this is not an individual. - `Records.SecondaryGrantee.Name4Full` (string) The full name of the fourth buyer or borrower. - `Records.SecondaryGrantee.Name4Last` (string) The last name of the fourth buyer or borrower. This will be the full name if this is not an individual. - `Records.SecondaryGrantee.Name4Middle` (string) The parsed middle name or initial of the fourth buyer or borrower. - `Records.SecondaryGrantee.Name4Suffix` (string) The suffix of the fourth buyer or borrower. E.g. Jr, III, etc. - `Records.Mortgage2` (object) - `Records.Mortgage2.AdjustableRateIndex` (string) The benchmark interest rate the second mortgage's adjustable rate is based on. - `Records.Mortgage2.Amount` (string) The loan amount of the second mortgage. - `Records.Mortgage2.Book` (string) The second mortgage number book. This can contain either the recorder document book or the legal description book. - `Records.Mortgage2.DocNumberFormatted` (string) The second mortgage number based on the book, page, or instrument number. - `Records.Mortgage2.DocNumberLegacy` (string) The second mortgage loan instrument, book, or page number located on the first sequence trust deed. - `Records.Mortgage2.FixedStepConvRate` (string) The interest rate change in a fixed step conversion mortgage for the second mortgage. - `Records.Mortgage2.InstrumentNumber` (string) If the second mortgage is indexed by a recorder’s reference number, this will contain that number. Usually the year will not be added to this field unless there is a regional requirement. - `Records.Mortgage2.InterestIndex` (string) The benchmark interest rate the second mortgage’s rate is based on. - `Records.Mortgage2.InterestMargin` (string) The fixed percentage rate added to an index value to determine the fully indexed interest rate of an adjustable rate mortgage for the second mortgage. - `Records.Mortgage2.InterestOnlyFlag` (string) Specifies if the second mortgage has an interest only period. - `Records.Mortgage2.InterestRate` (string) The interest rate of the second mortgage. - `Records.Mortgage2.InterestRateMax` (string) The maximum interest rate allowed for the second mortgage, if it is an adjustable rate. - `Records.Mortgage2.InterestRateType` (string) The interest rate type for the second mortgage. - `Records.Mortgage2.InterestTypeInitial` (string) The initial type of interest rate on the second mortgage. E.g. fixed or adjustable. - `Records.Mortgage2.IsLenderSeller` (string) Specifies if the lender is also the seller for the second mortgage. - `Records.Mortgage2.LenderAddress` (string) The address of the second mortgage lender. - `Records.Mortgage2.LenderCity` (string) The city of the second mortgage lender. - `Records.Mortgage2.LenderCode` (string) The standard ID code of the lender for the second mortgage. - `Records.Mortgage2.LenderFirstName` (string) The first name of the second mortgage lender. This will be the complete name if the lender is a company. - `Records.Mortgage2.LenderFullName` (string) The full standardized name of the lender for the second mortgage. - `Records.Mortgage2.LenderLastName` (string) The last name of the second mortgage lender. - `Records.Mortgage2.LenderState` (string) The state of the second mortgage lender. - `Records.Mortgage2.LenderType` (string) The lender type for the second mortgage. - `Records.Mortgage2.LenderZip` (string) The ZIP Code of the second mortgage lender. - `Records.Mortgage2.Page` (string) The second mortgage number page. This can contain either the recorder document page or the legal description page. - `Records.Mortgage2.PrepaymentPenaltyFlag` (string) Specifies if the second mortgage has a pre-payment penalty. - `Records.Mortgage2.PrepaymentTerm` (string) The number of months the second mortgage must remain active. - `Records.Mortgage2.RecordingDate` (string) The second mortgage official filing date with the format: YYYY-MM-DD. This is normally located on the document. - `Records.Mortgage2.Term` (string) The duration of the second mortgage. See the associated TermType to know the unit of measurement. - `Records.Mortgage2.TermDate` (string) The due date of the second mortgage. - `Records.Mortgage2.TermType` (string) The duration unit of measurement (month, year) for the second mortgage. See the associated Term to know the duration. - `Records.Mortgage2.Type` (string) The type of loan for the second mortgage. E.g. conventional, construction, FHA, etc. - `Records.Valuation` (object) - `Records.Valuation.EstDownPayment` (string) The estimated down payment made at the time of purchase. - `Records.Valuation.EstLTV` (string) The estimated loan to value at the time of purchase. - `TransactionID` (string) A unique string identifier for this record. A unique transaction ID is generated for every record handled. ## Response 400 fields (application/json): - `type` (string) The type of error that occurred. - `title` (string) A short summary of the error. - `status` (integer) The HTTP status code for the error. - `errors` (object) - `errors.$.` (array) A detailed message about the error. - `traceId` (string) A unique identifier for the request, useful for debugging.