HUD Logo
Site Map         A-Z Index         Text   A   A   A
HUD   >   Program Offices   >   Housing   >   Comp   >   Reports   >   Multifamily   >   HUD Terminated Multifamily Mortgages Database
Terminated Multifamily Mortgages Database
This Excel 2010 file includes all terminated HUD Multifamily insured mortgages. It includes the Holder and Servicer at the time the mortgage was terminated. The data is as of June 30, 2015 and is updated monthly. It is extracted from MFIS and includes the following data elements:
FHA Project Number
Premise ID
Project Name
Project Street
Project City
Project State
Project Zip Code
Number of total Units (or total beds for health or hospital care)
Initial Endorsement Date
Final Endorsement Date
Original Mortgage Amount
First Payment Date
Maturity Date
Term of loan in months
Interest Rate
Holder Name
Holder City
Holder State
Servicer Name
Servicer City
Servicer State
Section of the Act Code (SoA)
SoA Category (Note: The SOA codes are available on this list: soalist.xls.)
Term Type
Term Type Description
Type (Claim/Non Claim)
Termination Date

Tax Exempt Bond Financing Code (Mortgages financed by tax exempt bonds are indicated by "TE" code. This field was updated on new endorsements beginning in CY 2000).

Tax Credit Code (Mortgages that include Low Income Housing Tax Credits (LIHTC) are indicated by the "TC" code. This field was updated on new endorsements beginning in the middle of 1998).

This file can be used with Access or Excel. If you wish to use the file in an Access database, simply select the option in Access to import an Excel file.