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 May 31, 2016 and is updated monthly. It is extracted from MFIS and includes the following data elements*
FHA Project Number
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
Term of loan in months
Section of the Act Code (SoA)
SoA Category (Note: The SOA codes are available on this list: soalist.xlsx
Term Type Description
Type (Claim/Non Claim)
Tax Exempt Bond Financing Code (Mortgages financed by tax exempt bonds are indicated by "TE" code.
Tax Credit Code (Mortgages that include Low Income Housing Tax Credits (LIHTC) are indicated by the "TC" code.
* Premise ID is no longer included in this file.