Identifying_Expiring_Affordable_Housing_Properties_Figure_6.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL	AM	AN	AO	AP	AQ	AR	AS	AT	AU	AV	AW	AX	AY	AZ	BA	BB	BC	BD	BE	BF	BG	BH	BI	BJ	BK	BL	BM	BN	BO	BP	BQ	BR	BS	BT	BU	BV	BW	BX	BY	BZ	CA	CB	CC	CD	CE	CF	CG	CH	CI	CJ	CK	CL	CM	CN	CO	CP	CQ	CR	CS	CT	CU	CV
1	ReacScore1	year	EarliestEndDate	NHPDPropertyID	PropertyName	PropertyAddress	City	State	Zip	CBSACode	CBSAType	County	CountyCode	CensusTract	CongressionalDistrict	PropertyStatus	ActiveSubsidies	TotalInconclusiveSubsidies	TotalInactiveSubsidies	TotalUnits	EarliestStartDate	LatestEndDate	Owner	OwnerType	ManagerName	ManagerType	HUDPropertyID	ReacScore1Date	ReacScore2	ReacScore2Date	ReacScore3	ReacScore3Date	StudioOneBedroomUnits	TwoBedroomUnits	ThreePlusBedroomUnits	PercentofELIHouseholds	TargetTenantType	FairMarketRent_2BR	EarliestConstructionDate	LatestConstructionDate	OccupancyRate	AverageMonthsOfTenancy	NumberActiveSection8	NumberInconclusiveSection8	NumberInactiveSection8	S8_1_ID	S8_1_Status	S8_1_ProgramName	S8_1_RenewalStatus	S8_1_StartDate	S8_1_EndDate	S8_1_AssistedUnits	S8_1_RentToFMR	S8_1_InacStatusDesc	S8_2_ID	S8_2_Status	S8_2_ProgramName	S8_2_RenewalStatus	S8_2_StartDate	S8_2_EndDate	S8_2_AssistedUnits	S8_2_RentToFMR	S8_2_InacStatusDesc	NumberActiveSection202	NumberInconclusiveSection202	NumberInactiveSection202	S202_1_ID	S202_1_Status	S202_1_ProgramName	S202_1_StartDate	S202_1_EndDate	S202_1_AssistedUnits	S202_1_PrincipalBalance	S202_1_InacStatusDesc	S202_2_ID	S202_2_Status	S202_2_ProgramName	S202_2_StartDate	S202_2_EndDate	S202_2_AssistedUnits	S202_2_PrincipalBalance	S202_2_InacStatusDesc	NumberActiveSection236	NumberInconclusiveSection236	NumberInactiveSection236	S236_1_ID	S236_1_Status	S236_1_ProgramName	S236_1_StartDate	S236_1_EndDate	S236_1_AssistedUnits	S236_1_InacStatusDesc	S236_2_ID	S236_2_Status	S236_2_ProgramName	S236_2_StartDate	S236_2_EndDate	S236_2_AssistedUnits	S236_2_InacStatusDesc	NumberActiveHUDInsured
2	98	2025	2025-05-31	1034337	HART RESIDENCES INC	640 Middletown Ave	new haven	CT	06513-1011	35300	Metropolitan Statistical Area	South Central Connecticut	09170	09170142601	03	Active	1	0	1	12	1989-08-30 00:00:00 UTC	2025-05-31 00:00:00 UTC	Hart Residences Inc.	Multiple	HART RESIDENCES INC	Non-Profit	800003483	2022-02-25 00:00:00 UTC	71b	2019-07-31 00:00:00 UTC	78b	2018-02-26 00:00:00 UTC	12	0	0	100	Disabled		1981-01-01 00:00:00 UTC	1981-01-01 00:00:00 UTC	93	144	1	0	0	CT26T801022	Active	202/8 NC	4: Request Renewal for Projects Exempt from OAHP	2024-06-01 00:00:00 UTC	2025-05-31 00:00:00 UTC	12	86.68											0	0	0																	0	0	0															0
3	95	2025	2025-08-01	1034817	BREWERY SQUARE APARTMENTS	1 Brewery St	new haven	CT	06511-5935	35300	Metropolitan Statistical Area	South Central Connecticut	09170	09170140200	03	Active	2	1	0	104	1985-09-01 00:00:00 UTC	2051-05-01 00:00:00 UTC	Brewery Square LP	Profit Motivated	The Shoreline Corporation	Profit Motivated	800003284	2024-04-01 00:00:00 UTC	87c*	2022-03-01 00:00:00 UTC	83c*	2019-01-30 00:00:00 UTC	24	12	2	68	Family		1981-01-01 00:00:00 UTC	1981-01-01 00:00:00 UTC	98	145	1	0	0	CT26M000219	Active	LMSA	2: Request Renewal Without Restructuring at or Below Comparable Rents	2014-07-01 00:00:00 UTC	2034-06-30 00:00:00 UTC	38	119.14											0	0	0																	0	0	0															1
4	99	2026	2026-06-30	1034140	CASA OTONAL	135 Sylvan Ave	new haven	CT	06519-1037	35300	Metropolitan Statistical Area	South Central Connecticut	09170	09170140600	03	Active	2	0	0	105	2006-06-27 00:00:00 UTC	2042-09-01 00:00:00 UTC	CASA OTONAL HOUSING CORP	NON PROFIT	WinnResidential Connecticut LLC	Profit Motivated	800003305	2022-04-12 00:00:00 UTC	97c*	2019-02-27 00:00:00 UTC	97b	2016-01-29 00:00:00 UTC	104	0	0	94	Elderly		1982-01-01 00:00:00 UTC	1982-01-01 00:00:00 UTC	97	88	1	0	0	CT26T811002	Active	202/8 NC	4: Request Renewal for Projects Exempt from OAHP	2006-06-27 00:00:00 UTC	2026-06-30 00:00:00 UTC	104	144.32											0	0	0																	0	0	0															1
5	87	2028	2028-01-01	1034764	ELM HAVEN RENTAL I	69 Webster St	new haven	CT	06511-3613	35300	Metropolitan Statistical Area	South Central Connecticut	09170	09170141600	03	Active	4	1	2	236	1999-12-21 00:00:00 UTC	2030-01-01 00:00:00 UTC	BEACON COMMUNITIES LLC	Public Entity	HOUSING AUTHORITY OF THE CITY OF NEW HAVEN	Public Entity		2014-12-19 00:00:00 UTC	97	2011-02-07 00:00:00 UTC	92	2009-12-03 00:00:00 UTC	173	38	25				2000-01-01 00:00:00 UTC	2000-01-01 00:00:00 UTC			0	0	0																			0	0	0																	0	0	0															0
6	84	2029	2029-05-29	1034573	QUINNIPIAC TERRACE PHASE I	378 Front St	new haven	CT	06513-2222	35300	Metropolitan Statistical Area	South Central Connecticut	09170	09170142500	03	Active	3	0	0	81	2006-01-01 00:00:00 UTC	2036-01-01 00:00:00 UTC	TRINITY NEW HAVEN PARTNERS LLC	Multiple	HOUSING AUTHORITY OF THE CITY OF NEW HAVEN	Public Entity		2022-08-05 00:00:00 UTC	84	2020-01-10 00:00:00 UTC	82	2017-11-07 00:00:00 UTC	0	54	27	50	Family		2006-01-01 00:00:00 UTC	2006-01-01 00:00:00 UTC	97	123	0	0	0																			0	0	0																	0	0	0															0
7	96	2030	2030-04-05	1013179	VICTORY GARDENS	309 Dixwell Ave	new haven	CT	06511-3420	35300	Metropolitan Statistical Area	South Central Connecticut	09170	09170141600	03	Active	2	0	0	42	2010-04-05 00:00:00 UTC	2045-11-30 00:00:00 UTC	VICTORY GARDENS INC	NON PROFIT	THE COMMUNITY BUILDERS INC	Non-Profit	800214971	2021-11-16 00:00:00 UTC	98b	2018-02-28 00:00:00 UTC	99b	2014-10-27 00:00:00 UTC	41	0	0	74	Elderly		2003-01-01 00:00:00 UTC	2003-01-01 00:00:00 UTC	99	100	1	0	0	CT26S011002	Active	PRAC/202		2023-12-01 00:00:00 UTC	2045-11-30 00:00:00 UTC	41	102.69											0	0	0																	0	0	0															0
8	86	2031	2031-08-31	1034684	WILLIAM T ROWE	33 Sylvan Ave	new haven	CT	06519-1056	35300	Metropolitan Statistical Area	South Central Connecticut	09170	09170140600	03	Active	3	1	0	104	2011-08-31 00:00:00 UTC	2031-08-31 00:00:00 UTC	TRINITY ROWE LP	Public Entity	Housing Authority of the City of New Haven	Public Entity		2022-06-27 00:00:00 UTC	90	2017-11-02 00:00:00 UTC	99	2015-03-23 00:00:00 UTC			0	76			2011-01-01 00:00:00 UTC	2011-01-01 00:00:00 UTC	100	156	0	0	0																			0	0	0																	0	0	0															0
9	93	2032	2032-04-01	1034250	RIVER RUN APARTMENTS	50 Grand Ave	new haven	CT	06513-3949	35300	Metropolitan Statistical Area	South Central Connecticut	09170	09170142300	03	Active	2	0	0	325	2012-03-30 00:00:00 UTC	2052-01-01 00:00:00 UTC	River Run Preservation L.P.	Profit Motivated	RA MANAGEMENT LLC	Profit Motivated	800056596	2023-05-25 00:00:00 UTC	87c*	2021-07-16 00:00:00 UTC	92c*	2016-09-21 00:00:00 UTC	128	12	0	95	Elderly		1994-01-01 00:00:00 UTC	1994-01-01 00:00:00 UTC	97	119	1	0	0	CT26H037098	Active	HFDA/8 NC	4: Request Renewal for Projects Exempt from OAHP	2012-04-02 00:00:00 UTC	2032-04-01 00:00:00 UTC	140	118.15											0	0	0																	0	0	0															0
10	88	2032	2032-07-01	1034428	FLORENCE VIRTUE HOMES	37 Orchard Pl	new haven	CT	06511-3317	35300	Metropolitan Statistical Area	South Central Connecticut	09170	09170141600	03	Active	1	1	0	129	2003-10-01 00:00:00 UTC	2032-07-01 00:00:00 UTC	CONNECTICUT HOUSING FINANCE AU		WILDER RICHMAN MANAGEMENT CORPORATION		800220367	2022-08-18 00:00:00 UTC	89c*	2019-12-23 00:00:00 UTC	91c*	2016-12-27 00:00:00 UTC	14	56	59		Family						0	0	0																			0	0	0																	0	0	0															1
11	55	2033	2033-09-30	1034198	UNIVERSITY ROW COOPERATIVE	127 Henry St	new haven	CT	06511-3328	35300	Metropolitan Statistical Area	South Central Connecticut	09170	09170141600	03	Active	1	0	1	18	1969-03-01 00:00:00 UTC	2033-09-30 00:00:00 UTC	UNIVERSITYROW HOMES INC. c/o PRES Mike Maynard	NON PROFIT	Better Quality Management Corporation	Non-Profit	800003615	2023-05-12 00:00:00 UTC	82c	2021-08-02 00:00:00 UTC	64b*	2018-11-06 00:00:00 UTC	3	6	9	75	Family		1967-01-01 00:00:00 UTC	1967-01-01 00:00:00 UTC	70	190	1	0	0	CT26L000025	Active	LMSA	2: Request Renewal Without Restructuring at or Below Comparable Rents	2013-10-01 00:00:00 UTC	2033-09-30 00:00:00 UTC	18	82.95											0	0	0																	0	0	0															0
12	81	2033	2033-11-30	1034310	RENAISSANCE HILL	25 Ward St	new haven	CT	06519-1344	35300	Metropolitan Statistical Area	South Central Connecticut	09170	09170140600	03	Active	1	0	0	43	2023-12-01 00:00:00 UTC	2033-11-30 00:00:00 UTC	ASPIC Renaissance LLC	Profit Motivated	RENAISSANCE MANAGEMENT COMPANY INC	Profit Motivated	800003521	2023-06-08 00:00:00 UTC	67c*	2022-01-14 00:00:00 UTC	81c*	2018-12-07 00:00:00 UTC	2	10	31	85	Family		1982-01-01 00:00:00 UTC	1982-01-01 00:00:00 UTC	94	83	1	0	0	CT26H037114	Active	HFDA/8 SR	1a: Mark-Up-To-Market Eligibility	2023-12-01 00:00:00 UTC	2033-11-30 00:00:00 UTC	43	140.63											0	0	0																	0	0	0															0
13	94	2034	2034-03-31	1034116	BERGER APARTMENTS	135 Derby Ave	new haven	CT	06511-5156	35300	Metropolitan Statistical Area	South Central Connecticut	09170	09170140800	03	Active	2	0	1	144	2014-04-01 00:00:00 UTC	2055-01-01 00:00:00 UTC	Steele Berger LIHTC LLC	Profit Motivated	MONROE GROUP LTD	Profit Motivated	800003277	2024-08-07 00:00:00 UTC	95c	2019-04-26 00:00:00 UTC	83c	2017-04-17 00:00:00 UTC	123	21	0	89	Elderly		1979-01-01 00:00:00 UTC	1979-01-01 00:00:00 UTC	98	113	1	0	0	CT26A004002	Active	HFDA/8 SR	1b: Discretionary Authority Eligibility Mark-Up-To-Market	2014-04-01 00:00:00 UTC	2034-03-31 00:00:00 UTC	144	116.36											0	0	0																	0	0	0															0
14	70	2035	2035-07-31	1018197	SEABURY COOPERATIVE	400 Elm St	new haven	CT	06511-7030	35300	Metropolitan Statistical Area	South Central Connecticut	09170	09170140700	03	Active	1	0	1	88	1974-02-01 00:00:00 UTC	2035-07-31 00:00:00 UTC	SEABURY CO-OP Inc.	NON PROFIT	KONOVER RESIDENTIAL CORPORATION	Profit Motivated	800003544	2023-02-09 00:00:00 UTC	44c*	2018-10-22 00:00:00 UTC	55c*	2016-03-02 00:00:00 UTC	18	0	0	92	Family		1971-01-01 00:00:00 UTC	1971-01-01 00:00:00 UTC	97	160	1	0	0	CT26M000110	Active	LMSA	2: Request Renewal Without Restructuring at or Below Comparable Rents	2015-08-01 00:00:00 UTC	2035-07-31 00:00:00 UTC	18	112.23											0	0	0																	0	0	0															0
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100