USDA Rural Development
USDA rural rental housing
Apartment complexes financed by USDA in rural towns: units, rental assistance, vacancies, tenants, loans ending, and properties sold or leaving the program.
Published by USDA Rural Development
Finest detail facility
Tables 8
Guaranteed loans (Section 538)
Sample of 25 rows out of about 1,521
· 53 columns
| id | report_date | row_seq | state | fy_obligation_year | loan_amount | date_loan_closing | project_size | latitude | longitude | src_report_date | src_fy_obligation_year | src_lender_name | src_project_name | src_main_address_line1 | src_main_address_line2 | src_main_address_line3 | src_city | src_state_abbreviation | src_zip_code | src_date_loan_closing | src_loan_amount | src_tax_credit_indicator | src_total_development_cost | src_colonia_tribal_indicator | src_ez_ec_indicator | src_population_obligation | src_median_household_income_obligation | src_project_size | src_total_1_bedroom_units | src_total_2_bedroom_units | src_total_3_bedroom_units | src_total_4_bedroom_units | src_total_5_bedroom_units | src_br1_unit_average_contract_rent | src_br2_unit_average_contract_rent | src_br3_unit_average_contract_rent | src_br4_unit_average_contract_rent | src_br5_unit_average_contract_rent | src_construction_type | src_latitude | src_longitude | src_loan_to_cost | src_project_type | src_loan_asst_type_cd | src_loan_asst_type_desc | src_term_rsn_cd | src_borr_gls_id_key | src_prj_gls_id_key | src_fcly_gls_id_key | src_sect_515_type_cd | src_sect_515_type_desc | loaded_at |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 2026-09-23 | 1 | CA | 2016 | 1880000.00 | 2018-03-28 | 32 | 38.80077 | -123.016645 | 2026-09-23 | 2016 | BONNEVILLE MORTGAGE COMPANY, LLC | CLOVERDALE FAMILY APARTMENTS | 100 HEALDSBURG | No data | No data | CLOVERDALE | CA | 954250000 | 2018-03-28 | 1880000 | Y | 15792711 | N | N | 8618 | 63356 | 32 | 0 | 16 | 16 | 0 | 0 | 0 | 1080 | 1246 | 0 | 0 | NEW CONSTRUCTION | 38.80077 | -123.016645 | 0.1190422594322152 | MIXED | 240 | RRH-GUAR-NONSUBSDZD-SEC 538 | 01 | 505000200318936 | 298000461118936 | 143000461118936 | T | TRANSFER/REHAB REVITALIZE | 2026-10-09 07:46:29 |
| 2 | 2026-09-23 | 2 | CA | 2014 | 2037667.00 | 2015-09-09 | 52 | 34.82994 | -114.60579 | 2026-09-23 | 2014 | BONNEVILLE MORTGAGE COMPANY, LLC | LILLY HILL APARTMENTS | 1001 LILLY HILL DRIVE | No data | No data | NEEDLES | CA | 923630000 | 2015-09-09 | 2037667 | Y | 6816514 | N | N | 4844 | 55853 | 52 | 12 | 32 | 8 | 0 | 0 | 274 | 326 | 351 | 0 | 0 | REHAB/REPAIR | 34.82994 | -114.60579 | 0.29893094916257784 | FAMILY | 240 | RRH-GUAR-NONSUBSDZD-SEC 538 | 01 | 713000262116504 | 309000542516504 | 141000542516504 | T | TRANSFER/REHAB REVITALIZE | 2026-10-09 07:46:29 |
| 3 | 2026-09-23 | 3 | CA | 2019 | 6200000.00 | 2020-08-10 | 64 | 36.33605 | -121.231955 | 2026-09-23 | 2019 | BONNEVILLE MORTGAGE COMPANY, LLC | WALNUT GROVE APARTMENTS | WALNUT AVENUE | No data | No data | GREENFIELD | CA | 939270000 | 2020-08-10 | 6200000 | Y | 29296797 | N | N | 16330 | 63249 | 64 | 0 | 8 | 32 | 24 | 0 | 0 | 1300 | 1525 | 1600 | 0 | NEW CONSTRUCTION | 36.33605 | -121.231955 | 0.211627230103004 | OTHER | 240 | RRH-GUAR-NONSUBSDZD-SEC 538 | 01 | 261643963730488 | 380000100319550 | 276000100319550 | Z | 514 NEW CONSTRUCTION | 2026-10-09 07:46:29 |
| 4 | 2026-09-23 | 4 | CA | 2017 | 1068000.00 | 2018-05-09 | 40 | 39.149222 | -122.137951 | 2026-09-23 | 2017 | BONNEVILLE MORTGAGE COMPANY, LLC | GREEN VALLEY HOMES | 1006 GOLDEN VALLEY DRIVE | No data | No data | WILLIAMS | CA | 959870000 | 2018-05-09 | 1068000 | Y | 20125210 | N | N | 5123 | 50503 | 40 | 0 | 5 | 17 | 18 | 0 | 0 | 661 | 457 | 510 | 0 | NEW CONSTRUCTION | 39.149222 | -122.137951 | 0.053067769230731 | FAMILY | 240 | RRH-GUAR-NONSUBSDZD-SEC 538 | 01 | 308000473216336 | 124000103916336 | 19000103916336 | Z | 514 NEW CONSTRUCTION | 2026-10-09 07:46:29 |
| 5 | 2026-09-23 | 5 | CA | 2021 | 3800000.00 | 2021-03-29 | 68 | 35.678146 | -119.234093 | 2026-09-23 | 2021 | BONNEVILLE MORTGAGE COMPANY, LLC | KENDREA TERRACE | No data | No data | No data | MCFARLAND | CA | 932500000 | 2021-03-29 | 3800000 | Y | 31580241 | N | N | 14456 | 33281 | 68 | 0 | 8 | 30 | 30 | 0 | 0 | 995 | 1280 | 1370 | 0 | NEW CONSTRUCTION | 35.678146 | -119.234093 | 0.1203284040802601 | FAMILY | 240 | RRH-GUAR-NONSUBSDZD-SEC 538 | 01 | 370712341320131 | 130000040516371 | 104000040516371 | N | NONE | 2026-10-09 07:46:29 |
| 6 | 2026-09-23 | 6 | CA | 2013 | 975000.00 | 2015-08-19 | 48 | 35.688703 | -119.236515 | 2026-09-23 | 2013 | BONNEVILLE MORTGAGE COMPANY, LLC | KENDREA PLACE APARTMENTS | 1099 KENDREA PLACE | No data | No data | MC FARLAND | CA | 932500000 | 2015-08-19 | 975000 | Y | 11880595 | N | N | 12707 | 48021 | 48 | 8 | 24 | 16 | 0 | 0 | 538 | 387 | 447 | 0 | 0 | NEW CONSTRUCTION | 35.688703 | -119.236515 | 0.0820665968329027 | FAMILY | 240 | RRH-GUAR-NONSUBSDZD-SEC 538 | 01 | 525000562518553 | 613000574518553 | 437000574518553 | Z | 515 NEW CONSTRUCTION | 2026-10-09 07:46:29 |
| 7 | 2026-09-23 | 7 | CA | 2013 | 1100000.00 | 2016-10-28 | 48 | 36.58847 | -119.44611 | 2026-09-23 | 2013 | BONNEVILLE MORTGAGE COMPANY, LLC | REEDLEY FAMILY APARTMENTS | 1110 S. I STREET | No data | No data | REEDLEY | CA | 936540000 | 2016-10-28 | 1100000 | Y | 10337801 | N | N | 24194 | 46903 | 48 | 8 | 24 | 16 | 0 | 0 | 322 | 387 | 447 | 0 | 0 | NEW CONSTRUCTION | 36.58847 | -119.44611 | 0.1064056079237741 | FAMILY | 240 | RRH-GUAR-NONSUBSDZD-SEC 538 | 01 | 27000473820874 | 575000384420874 | 405000384420874 | N | NONE | 2026-10-09 07:46:29 |
| 8 | 2026-09-23 | 8 | CA | 2023 | 2000000.00 | 2023-06-21 | 36 | 36.554682 | -119.615296 | 2026-09-23 | 2023 | BONNEVILLE MORTGAGE COMPANY, LLC | VALLEY VIEW TERRACE III | 1480 SKELTON STREET | No data | No data | SELMA | CA | 936620000 | 2023-06-21 | 2000000 | Y | 23088992 | N | N | 24405 | 72900 | 36 | 0 | 3 | 5 | 28 | 0 | 0 | 1200 | 1350 | 1485 | 0 | NEW CONSTRUCTION | 36.554682 | -119.615296 | 0.0866213648478028 | FAMILY | 240 | RRH-GUAR-NONSUBSDZD-SEC 538 | 01 | 819816582187771 | 434000471814304 | 354000471814304 | Z | 514 NEW CONSTRUCTION | 2026-10-09 07:46:29 |
| 9 | 2026-09-23 | 9 | CA | 2012 | 1352464.00 | 2014-01-22 | 76 | 36.38229 | -119.2163 | 2026-09-23 | 2012 | BONNEVILLE MORTGAGE COMPANY, LLC | IVANHOE FAMILY APT/LINDA VISTA | 15999 AVENUE 327 | No data | No data | IVANHOE | CA | 932350000 | 2014-01-22 | 1352464 | Y | 16947368 | N | N | 4495 | 43397 | 76 | 16 | 36 | 24 | 0 | 0 | 317 | 380 | 439 | 0 | 0 | NEW CONSTRUCTION | 36.38229 | -119.2163 | 0.0798037783802181 | FAMILY | 240 | RRH-GUAR-NONSUBSDZD-SEC 538 | 01 | 923000164117432 | 949000235217432 | 703000235217432 | N | NONE | 2026-10-09 07:46:29 |
| 10 | 2026-09-23 | 10 | CA | 2013 | 653750.00 | 2015-09-09 | 46 | 34.82994 | -114.60579 | 2026-09-23 | 2013 | BONNEVILLE MORTGAGE COMPANY, LLC | MESA GRANDE APARTMENTS | 1600 LILLY HILL DRIVE | No data | No data | NEEDLES | CA | 923630000 | 2015-09-09 | 653750 | Y | 4806655 | N | N | 4844 | 55853 | 46 | 45 | 1 | 0 | 0 | 0 | 333 | 645 | 0 | 0 | 0 | REHAB/REPAIR | 34.82994 | -114.60579 | 0.1360093453763584 | SENIOR | 240 | RRH-GUAR-NONSUBSDZD-SEC 538 | 01 | 832000525816174 | 779000021317174 | 586000021317174 | T | TRANSFER/REHAB REVITALIZE | 2026-10-09 07:46:29 |
| 11 | 2026-09-23 | 11 | CA | 2015 | 1945000.00 | 2017-08-30 | 48 | 36.555861 | -119.619212 | 2026-09-23 | 2015 | BONNEVILLE MORTGAGE COMPANY, LLC | VALLEY VIEW HOMES | 1625 SAN CARLOS STREET | No data | No data | SELMA | CA | 936620000 | 2017-08-30 | 1945000 | Y | 18012427 | N | N | 23219 | 45741 | 48 | 0 | 8 | 30 | 10 | 0 | 0 | 835 | 950 | 1130 | 0 | NEW CONSTRUCTION | 36.555861 | -119.619212 | 0.10798100666834061 | FAMILY | 240 | RRH-GUAR-NONSUBSDZD-SEC 538 | 01 | 611000553415995 | 307000551618995 | 144000551618995 | Z | 514 NEW CONSTRUCTION | 2026-10-09 07:46:29 |
| 12 | 2026-09-23 | 12 | CA | 2014 | 2018077.00 | 2016-08-03 | 48 | 38.58034 | -122.58476999999999 | 2026-09-23 | 2014 | BONNEVILLE MORTGAGE COMPANY, LLC | CALISTOGA FAMILY APARTMENTS | 1715 WASHINGTON STREET | No data | No data | CALISTOGA | CA | 945150000 | 2016-08-03 | 2018077 | Y | 18739562 | N | N | 5155 | 68641 | 48 | 16 | 15 | 17 | 0 | 0 | 455 | 547 | 633 | 0 | 0 | NEW CONSTRUCTION | 38.58034 | -122.58476999999999 | 0.10769072404146901 | FAMILY | 240 | RRH-GUAR-NONSUBSDZD-SEC 538 | 01 | 139000321317014 | 963000573017014 | 817000573017014 | Z | 514 NEW CONSTRUCTION | 2026-10-09 07:46:29 |
| 13 | 2026-09-23 | 13 | CA | 2017 | 1800000.00 | 2017-10-11 | 45 | 34.59771 | -120.13505 | 2026-09-23 | 2017 | BONNEVILLE MORTGAGE COMPANY, LLC | SOLVANG SENIOR APARTMENTS | 1758 LAUREL AVENUE | No data | No data | SOLVANG | CA | 934630000 | 2017-10-11 | 1800000 | Y | 9247284 | N | N | 5245 | 72800 | 45 | 41 | 4 | 0 | 0 | 0 | 385 | 805 | 0 | 0 | 0 | NEW CONSTRUCTION | 34.59771 | -120.13505 | 0.1946517485566572 | SENIOR | 240 | RRH-GUAR-NONSUBSDZD-SEC 538 | 01 | 729000135820275 | 324000460521275 | 187000460521275 | N | NONE | 2026-10-09 07:46:29 |
| 14 | 2026-09-23 | 14 | ND | 2006 | 427489.00 | 2008-01-01 | 24 | 48.109939999999995 | -98.85933999999999 | 2026-09-23 | 2006 | MERCHANTS CAPITAL CORP. | DAKOTA MANOR APARTMENTS | 202 4TH AVE NE | No data | No data | DEVILS LAKE | ND | 583013020 | 2008-01-01 | 427489 | Y | 1219989 | N | N | 7222 | 31250 | 24 | 6 | 18 | 0 | 0 | 0 | 489 | 545 | 0 | 0 | 0 | REHAB/REPAIR | 48.109939999999995 | -98.85933999999999 | 0.3504039790522701 | No data | 241 | RRH-GUAR-SUBSIDIZED-SEC 538 | 01 | 906710033813087 | 609516053617597 | 22605053617597 | T | TRANSFER/REHAB REVITALIZE | 2026-10-09 07:46:29 |
| 15 | 2026-09-23 | 15 | ND | 2006 | 400000.00 | 2008-06-30 | 40 | 48.110687 | -98.858673 | 2026-09-23 | 2006 | CHURCHILL MORTGAGE INVESTMENT LLC | GILBERTSON FIREHOUSE APARTMENT | 416 & 418 5TH STREET | No data | No data | DEVILS LAKE | ND | 583010000 | 2008-06-30 | 400000 | Y | 1520374 | N | N | 7222 | 52550 | 40 | 32 | 8 | 0 | 0 | 0 | 532 | 620 | 0 | 0 | 0 | REHAB/REPAIR | 48.110687 | -98.858673 | 0.2630931599724804 | FAMILY | 241 | RRH-GUAR-SUBSIDIZED-SEC 538 | 01 | 332445422517897 | 161447141818897 | 971495141818897 | T | TRANSFER/REHAB REVITALIZE | 2026-10-09 07:46:29 |
| 16 | 2026-09-23 | 16 | ND | 2006 | 295000.00 | 2008-04-01 | 16 | 48.412555 | -97.422947 | 2026-09-23 | 2006 | MERCHANTS CAPITAL CORP. | GRAFTON LIVING CENTER | 809 W. 12TH STREET | No data | No data | GRAFTON | ND | 582372100 | 2008-04-01 | 295000 | Y | 1545960 | N | N | 4516 | 51600 | 16 | 16 | 0 | 0 | 0 | 0 | 495 | 0 | 0 | 0 | 0 | REHAB/REPAIR | 48.412555 | -97.422947 | 0.1908199435949183 | SENIOR | 241 | RRH-GUAR-SUBSIDIZED-SEC 538 | 01 | 16127091718087 | 950073192219897 | 985732192219897 | T | TRANSFER/REHAB REVITALIZE | 2026-10-09 07:46:29 |
| 17 | 2026-09-23 | 17 | ND | 2006 | 580000.00 | 2008-06-26 | 32 | 48.110687 | -98.858673 | 2026-09-23 | 2006 | CHURCHILL MORTGAGE INVESTMENT LLC | PARK VILLAGE OF LANGDON | 1724 6TH STREET | No data | No data | LANGDON | ND | 583010910 | 2008-06-26 | 580000 | Y | 2869783 | N | N | 2101 | 28839 | 32 | 0 | 32 | 0 | 0 | 0 | 0 | 493 | 0 | 0 | 0 | REHAB/REPAIR | 48.110687 | -98.858673 | 0.20210587351029669 | FAMILY | 241 | RRH-GUAR-SUBSIDIZED-SEC 538 | 01 | 903861302218087 | 314700443316197 | 732678433316197 | T | TRANSFER/REHAB REVITALIZE | 2026-10-09 07:46:29 |
| 18 | 2026-09-23 | 18 | CA | 2012 | 775000.00 | 2013-03-21 | 66 | 36.55802 | -119.61669 | 2026-09-23 | 2012 | BONNEVILLE MORTGAGE COMPANY, LLC | VALLEY VIEW VILLAGE | 2245 VALLEY VIEW STREET | No data | No data | SELMA | CA | 936220000 | 2013-03-21 | 775000 | Y | 16439988 | N | N | 19444 | 34725 | 66 | 15 | 51 | 0 | 0 | 0 | 582 | 739 | 0 | 0 | 0 | NEW CONSTRUCTION | 36.55802 | -119.61669 | 0.0471411536310124 | FAMILY | 240 | RRH-GUAR-NONSUBSDZD-SEC 538 | 01 | 798663503421892 | 390314104521892 | 938412104521892 | Z | 514 NEW CONSTRUCTION | 2026-10-09 07:46:29 |
| 19 | 2026-09-23 | 19 | CA | 2014 | 1235000.00 | 2014-07-29 | 60 | 36.41077 | -119.10391 | 2026-09-23 | 2014 | BONNEVILLE MORTGAGE COMPANY, LLC | BRAVO VILLAGE | 444 ROPES AVENUE | No data | No data | WOODLAKE | CA | 932860000 | 2014-07-29 | 1235000 | Y | 15673386 | N | N | 7279 | 43397 | 60 | 16 | 24 | 20 | 0 | 0 | 613 | 735 | 847 | 0 | 0 | NEW CONSTRUCTION | 36.41077 | -119.10391 | 0.07879599213596859 | FAMILY | 240 | RRH-GUAR-NONSUBSDZD-SEC 538 | 01 | 839000394317812 | 408000265017812 | 169000265017812 | Z | 515 NEW CONSTRUCTION | 2026-10-09 07:46:29 |
| 20 | 2026-09-23 | 20 | CA | 2020 | 3300000.00 | 2020-09-14 | 72 | 39.159396 | -123.201441 | 2026-09-23 | 2020 | BONNEVILLE MORTGAGE COMPANY, LLC | BRUSH MEADOW APARTMENTS | 510 BRUSH STREET | No data | No data | UKIAH | CA | 954820000 | 2020-09-14 | 3300000 | Y | 29913094 | N | N | 16075 | 46528 | 72 | 24 | 36 | 12 | 0 | 0 | 720 | 1001 | 1118 | 0 | 0 | NEW CONSTRUCTION | 39.159396 | -123.201441 | 0.1103195811172191 | FAMILY | 240 | RRH-GUAR-NONSUBSDZD-SEC 538 | 01 | 119223781889998 | 568000111920841 | 533000111920841 | Z | 514 NEW CONSTRUCTION | 2026-10-09 07:46:29 |
| 21 | 2026-09-23 | 21 | CA | 2022 | 2880000.00 | 2022-04-29 | 54 | 38.981547 | -122.83374 | 2026-09-23 | 2022 | BONNEVILLE MORTGAGE COMPANY, LLC | KELSEYVILLE FAMILY APARTMENTS | 5400 GADDY LN | No data | No data | KELSEYVILLE | CA | 954510000 | 2022-04-29 | 2880000 | Y | 29205599 | N | N | 3560 | 42418 | 54 | 0 | 18 | 18 | 18 | 0 | 0 | 777 | 898 | 1003 | 0 | NEW CONSTRUCTION | 38.981547 | -122.83374 | 0.098611228620923 | FAMILY | 240 | RRH-GUAR-NONSUBSDZD-SEC 538 | 01 | 339499837299199 | 874000164510782 | 863000164510782 | Z | NEW CONSTRUCTION SECTION 514 | 2026-10-09 07:46:29 |
| 22 | 2026-09-23 | 22 | CA | 2010 | 1863000.00 | 2012-03-29 | 80 | 35.68766 | -119.23546999999999 | 2026-09-23 | 2010 | BONNEVILLE MORTGAGE COMPANY, LLC | MCFARLAND FAMILY APARTMENTS | 1030 KENDREA ST. | No data | No data | MCFARLAND | CA | 932500000 | 2012-03-29 | 1863000 | Y | 13163602 | N | N | 9618 | 35446 | 80 | 24 | 32 | 24 | 0 | 0 | 301 | 356 | 412 | 0 | 0 | NEW CONSTRUCTION | 35.68766 | -119.23546999999999 | 0.1415266125487537 | FAMILY | 240 | RRH-GUAR-NONSUBSDZD-SEC 538 | 01 | 903443225621971 | 855372181222971 | 887090181222971 | N | NONE | 2026-10-09 07:46:29 |
| 23 | 2026-09-23 | 23 | CA | 2011 | 2720000.00 | 2011-06-29 | 80 | 35.253355 | -118.927101 | 2026-09-23 | 2011 | BONNEVILLE MORTGAGE COMPANY, LLC | DI GIORGIO FAMILY APARTMENTS | 7000 DI GIORGIO RD | No data | No data | LAMONT | CA | 932410000 | 2011-06-29 | 2720000 | Y | 11901100 | N | N | 13296 | 35466 | 80 | 16 | 32 | 32 | 0 | 0 | 297 | 297 | 297 | 0 | 0 | NEW CONSTRUCTION | 35.253355 | -118.927101 | 0.2285503020729176 | FAMILY | 240 | RRH-GUAR-NONSUBSDZD-SEC 538 | 01 | 982603524815801 | 374428560116801 | 901095560116801 | N | NONE | 2026-10-09 07:46:29 |
| 24 | 2026-09-23 | 24 | CA | 2010 | 4150000.00 | 2010-09-03 | 52 | 35.030713 | -120.487041 | 2026-09-23 | 2010 | BONNEVILLE MORTGAGE COMPANY, LLC | ROOSEVELT FAMILY APARTMENTS | 748 KELLY COURT | No data | No data | NIPOMO | CA | 934440000 | 2010-09-03 | 4150000 | Y | 14556155 | N | N | 12626 | 42428 | 52 | 0 | 0 | 24 | 28 | 0 | 0 | 0 | 457 | 457 | 0 | NEW CONSTRUCTION | 35.030713 | -120.487041 | 0.2851027623709695 | FAMILY | 240 | RRH-GUAR-NONSUBSDZD-SEC 538 | 01 | 441930381017140 | 57531521417140 | 223799511417140 | N | NONE | 2026-10-09 07:46:29 |
| 25 | 2026-09-23 | 25 | CA | 2012 | 2000000.00 | 2012-04-10 | 68 | 37.318984 | -121.020701 | 2026-09-23 | 2012 | BONNEVILLE MORTGAGE COMPANY, LLC | NEWMAN FAMILY/MUSTANG PEAK APT | 1118 M. STREET | No data | No data | NEWMAN | CA | 953600000 | 2012-04-10 | 2000000 | Y | 12800379 | N | N | 7093 | 40101 | 68 | 28 | 16 | 24 | 0 | 0 | 334 | 402 | 464 | 0 | 0 | NEW CONSTRUCTION | 37.318984 | -121.020701 | 0.1562453736721389 | FAMILY | 240 | RRH-GUAR-NONSUBSDZD-SEC 538 | 01 | 134844045819992 | 690978081920992 | 231707081920992 | N | NONE | 2026-10-09 07:46:29 |
🔒 Some columns are hidden in this preview for privacy.
Need the whole thing? Spreadsheet links, downloads, and AI access come with Level 3.
See pricing