by Jana Safy & Hameed Almukhtar
Last updated on December 3, 2024
for Data Visualization for Allwith Prof. Jack DoughertyTrinity College, Hartford CT, USA
Owning a home has long symbolized the "American Dream"—a cornerstone of financial stability. Yet, for many, achieving this dream remains a challenge, as housing costs soar, and affordability fluctuates across cities and towns. Community Land Trusts (CLTs) offer a promising solution. These non-profit organizations are designed to bridge the gap between housing needs and affordability in two ways. First, CLT’s purchase land and then sell the homes located on the properties to low-income residents. By selling the homes—but not the land—CLTs drastically reduce homeownership costs. Second, to ensure that these properties remain affordable to the CLT’s respective community, residents must agree to a formula that calculates an “allowable sales price” when they wish to sell in the future, to keep the home affordable for the community. The formula allows owners to earn up to 50 percent of any appreciation in the value of the home that rose while they owned it, plus up to 100 percent of any home improvements they made plus closing costs. This way residents are able to grow their personal wealth, while the property continues to benefit local needs.
Our project focuses on community land trusts in the Hartford region of Connecticut, specifically, Urban Suburban Affordables (USA), managed by the Center for Leadership and Justice (CLJ). The CLJ is a grassroots organization dedicated to advancing social and economic equity across Hartford and its surrounding communities. With a strong focus on empowering historically marginalized populations, they work to address systemic injustices through advocacy, education and community organization. The organization's initiatives span a variety of critical issues, but we will focus on its work on affordable housing in the Hartford region. USA’s portfolio contains over 200 properties which it distributes among those in need of affordable housing. A significant portion of these properties are within the Hartford region (44%), hence looking into the Hartford properties may provide a better reflection of the programs work across the board in the greater Hartford Area (officially known as the Capital Planning region).
To evaluate the success of USA’s program, first we examine how home sales prices and homeownership status have changed over time for a sample of 20 single-family homes within Hartford, selected randomly from the USA’s housing portfolio. By focusing exclusively on single-family homes, we aim to eliminate variables associated with other property types, such as multi-family units or condominiums, that could obscure general trends in home sales prices and ownership patterns. Second, we compare this subset of USA properties to broader trends for other homes in Hartford and across Connecticut between 2000-2024. By focusing on these trends, we aim to assess whether efforts to maintain affordability and accessibility in the housing market have been effective.
By underscoring the impact of USA on addressing housing affordability, we can provide them with critical insight into their model’s effectiveness. This knowledge could also enable the CLJ to advocate for policies that expand the program or address barriers to its effectiveness.
Ultimately, this work matters because housing isn’t just about shelter, it’s about creating stable communities for families to thrive in. For the CLJ, ensuring the success and growth of USA is a step toward reducing housing inequality and empowering Hartford’s communities to build a more just and equitable future.
The data reveals a compelling story about the impact of Urban Suburban Affordables (USA) on housing affordability and stability in Hartford. Through an analysis of pricing trends and ownership patterns, we uncovered how USA’s Community Land Trust model has maintained affordability while allowing homeowners to build equity. While the value of this subset of USA properties has tripled they still remain lower and thus more affordable in comparable neighborhoods like East Hartford.
Significant price increases have been observed across all USA single-family homes in our Hartford sample. The median home in our sample increased 253% in market value over three decades, with estimated market prices appreciating within the range of 103% and 400% since acquisition. Data from the initial purchase prices and current Zillow evaluations illustrate this trend clearly. For instance, a property acquired by the USA program for $53,000 in 1997 is now valued on Zillow at $265,200, marking a 400% increase. Another example is a home purchased for $65,000 in 2000, now valued at $253,800—a 290% increase.
Figure 1 tracks the estimated market values of 20 USA single-family homes in Hartford from their earliest acquisition (typically in the 1990s) to the present.. The bold blue line shows the median value, which has risen from approximately $50,000 in the early 1990s to almost $250,000 in recent years. Individual home values (gray lines) vary, but all follow a similar upward trend, with no properties showing stagnation or significant depreciation. This data illustrates the appreciation of housing assets over time, bolstered by factors like inflation, neighborhood development, and increased housing demand.
Figure 2 complements the findings in Figure 1 by illustrating the geographical distribution of percent changes in home values since acquisition. Each circle represents a property, with the size of the circle corresponding to the percentage increase in value. The visual highlights that all properties in the sample experienced substantial appreciation regardless of their location, further emphasizing the consistency of value growth across the program. For example, homes in southwest and northwest Hartford neighborhoods saw comparable price increases, demonstrating that value appreciation is not confined to a specific area but is widespread across these regions.
Combining the analysis of Figure 1 with the geographical perspective of Figure 2, the findings underscore the success of the USA program in acquiring homes that align with broader market trends of appreciation. Both figures reinforce that the properties have not only retained but significantly increased their value over time
Over the past three decades, median home prices have shown steady growth. Nationally, the median home price increased by $300,400, or 250%, from approximately $120,000 in the early 1990s to $420,400 by the third quarter of 2024. Similarly, in the USA program homes sample values appreciated by 103% to 400%, depending on the property, over the same period.
From the third quarter of 2000 to the third quarter of 2024, national median home prices rose from $168,800 to $420,400—a $251,600 (149%) increase. By comparison, USA program homes, despite resale restrictions designed to maintain affordability, saw appreciation rates that closely mirrored this trend. However, caution is advised when interpreting these figures, as the wide range of appreciation within the USA program sample reflects varying local market dynamics and individual property characteristics.
Figure 3 shows the median sales price of houses sold in the United States from 1990 to 2024, with data sourced from the U.S. Census (Bennefield, 2021) and U.S. Department of Housing and Urban Development (Bureau, 2019). The observed appreciation in USA program homes, with values increasing by 103% to 400% over the past three decades, underscores the program's effectiveness in enabling homeowners to build equity comparable to national trends. This growth not only enhances individual financial stability but also contributes to community development by fostering long-term residency and investment. By aligning with broader market appreciation, the program demonstrates its capacity to offer affordable housing options that simultaneously promote wealth accumulation, thereby supporting both personal and community prosperity.
Next we compare single-family home prices in the USA Hartford sample to typical sales in the Hartford region calculated by Zillow. Since Zillow data is only available from 2000 to 2024, we need to recalculate our USA Hartford sample for the same time period. We found that USA Hartford homes increased 238%. In comparison, typical Zillow sales in the Hartford region during the same period increased 142%.
Figure 4 shows the typical single-home values for the Hartford-East Hartford-Middletown area in the 35th to 65th percentile range from 2000 to 2024 (Zillow). Similar to the USA program sample, this market experienced steady growth in home values over time, punctuated by a significant dip during the 2008 housing crisis. After stabilizing post-2012, the market saw accelerated growth from 2020 onward, with home values reaching approximately $300,000 in 2024.
Despite dramatic appreciations in our sample, the USA program’s resale restrictions have kept prices below comparable market-rate homes shown in figure 4. This means that while an average neighborhood home in the area may now list for $300,000, USA homes in our sample remain available to moderate-income buyers at prices of approximately $250,000 and under.
These findings highlight the dual impact of the USA program: enabling substantial wealth-building for homeowners while ensuring long-term affordability. By tethering resale prices to a capped formula, the program mitigates the effects of market forces, safeguarding access to housing for future buyers. This strategy not only strengthens community stability but also provides a replicable model for addressing housing affordability amid rising property values.
Most of the homes in the sample of 20 USA homes (12 out of 20, or 60%) have been owned by two or fewer families since their acquisition by USA. This observation highlights the effectiveness of Community Land Trust (CLT) homes in fostering long-term stability. The low turnover rate is significant because it reflects the success of CLTs in achieving their mission of providing sustainable housing solutions for low-income families.
The relatively low number of families that have owned these homes, makes it evident that CLTs are not just offering temporary housing, but rather creating opportunities for families to establish roots in their communities. This stability is crucial for fostering economic security, community engagement, and social cohesion. For families, stable housing can lead to better educational outcomes for children, improved health, and stronger financial footing as they are less likely to face the disruptions of frequent moves or evictions.
Additionally, the model's ability to preserve affordability across ownership transitions ensures that these homes remain accessible to other low-income families in the future. This aligns with the long-term goal of CLTs: breaking the cycle of housing instability and addressing systemic inequities in housing access. By offering a pathway to stability and community integration, CLTs make a profound contribution to addressing the housing crisis and building resilient communities.
Figure 5 categorizes the number of times homes in our USA sample have been transferred (ownership changes) based on their location within Hartford—either the North Side or South Side.
Across the entire sample, a significant portion of the homes (40%) have had only one owner since their acquisition, showcasing a high level of stability and long-term occupancy among homeowners. These single-owner homes are distributed between the Northwest (3 homes) and the Southwest (5 homes) of Hartford, highlighting a slight tendency toward greater stability on the South Side.
Meanwhile, 20% of the homes have had two owners, reflecting moderate turnover. These homes are evenly distributed between the North and South sides, suggesting consistent dynamics across both regions for this category.
Interestingly, 30% of the homes have had three owners, indicating a more dynamic turnover for a subset of the program's homes. All of these homes are located on the South Side, suggesting that turnover may be higher in this region due to factors such as market demand, personal circumstances, or mobility trends among residents.
Notably, The highest number of owners recorded for any single home is four, which occurred in just two houses, representing 10% of the sample. These two homes, acquired in 1992 and 2000, reflect the rarity of frequent ownership turnover in the program.
This distribution highlights the program's overall success in maintaining stability while allowing some flexibility for ownership transitions. The relatively small percentage of homes with three or more owners indicates that the program has largely achieved its goal of fostering long-term residency and community building, particularly among single-owner households. The balance between stability and turnover also reflects the program's capacity to accommodate changing homeowner needs over time.
We cannot find comparable data on ownership turnover for all Hartford homes. Instead, the best available data comes from the American Community Survey (ACS), a comprehensive governmental survey tracking housing trends across the United States. According to the ACS, only 20.77% of Hartford residents have continuously owned their homes since 1990. This remarkably low rate underscores the challenges in promoting housing stability and economic equity within the city.
In this context, the work of USA takes on particular importance. By creating affordable housing opportunities and supporting long-term stability for low-income families, USA has the potential to make a substantial impact in increasing homeownership rates. This is especially vital in communities like Hartford, where the barriers to homeownership are pronounced, and the need for stable, affordable housing solutions is critical.
To begin we formed a sample of 20 single family USA homes in Hartford. To do this we filtered out all multi family homes in the database of all USA properties. What was left was all the single family homes belonging to USA. We then utilized a random number generator to pick 20 random numbers. We used those 20 numbers to pick our sample according to the House code each property is assigned such as ‘H2’ or ‘H13’.
We gathered historical house prices and the years of purchase for the properties in question using data from Zillow, a leading real estate marketplace that provides information on home values and property histories. Recognizing that it can be challenging to pinpoint the exact year each home was acquired by USA Properties, we made an assumption: if the acquisition date was uncertain, we considered any purchase from the early 1990s onward as a valid starting point.
To benchmark and compare our findings with broader trends in the housing market, we sourced national data from the United States Census Bureau. This government agency provides comprehensive and reliable statistics on housing prices and trends across the United States. By analyzing these publications, we were able to find the average sales price of homes in the nation and compare them to the sales prices of the properties from our sample of USA owned properties. This comparison allowed us to assess how USA Properties stay affordable in comparison to the national real estate market.
We also gathered data from the American Community Survey (ACS), a governmental survey that tracks housing trends across the United States, to analyze homeownership rates in Hartford from 1990 to the present. This data provided an estimated percentage of homes currently owned by their residents, offering valuable insight into local housing trends.
Something to be aware of is that the available resources were missing some data. We couldn’t find all the sale prices for every year on each of the houses in our sample. In order to visualize the data in figure one, we used a method called interpolation. This allows us to fill in the gaps between unknown numbers on an excel sheet. It connects two points and figures out what the values would be in between them, based on a pattern or trend. In other words, we filled in the blanks with predictions on what these numbers would be. Now with the data points that we interpolated we were able to construct figure 1 that represents the change in home value for our subset of USA properties.
To visualize our findings, we utilized Datawrapper, a Germany-based platform known for its user-friendly tools for creating interactive maps and graphs. Unless otherwise noted, all the maps featured in this project were created using Datawrapper.
The authors would like to give credit to our professor, Jack Dougherty, for all his help throughout the semester. We would also like to thank our TA, Nellie Conklin, who was invaluable in constantly editing our drafts.
Bennefield, R. L. (2021a, October 8). Census 2000 brief: Home values: 2000. Census.gov.https://www.census.gov/library/publications/2003/dec/c2kbr-20.html
Bureau, U. C. (2019, April 15). New Residential Sales Press Release. United States Census Bureau. https://www.census.gov/construction/nrs/current/#:~:text=The%20median%20sales%20price%20of,average%20sales%20price%20was%20%24501%2C000.&text=The%20seasonally%2Dadjusted%20estimate%20of,at%20the%20current%20sales%20rate.
Housing unit by year householder moved into unit. Social explorer. (n.d.-a). https://www.socialexplorer.com/reports/socialexplorer/en/report/b20afe48-adb2-11ef-ad35-4f8fb25a2b08
Patriot properties WebPro. (n.d.). http://assessor1.hartford.gov/Default.asp
Real estate, apartments, Mortgages & Home values. Zillow. (n.d.). https://www.zillow.com/
Search Online Records. SearchIQS. (n.d.). http://searchiqs.com/
Tenure (owner-occupied vs renter-occupied housing units). Social explorer. (n.d.-b). https://www.socialexplorer.com/reports/socialexplorer/en/report/fb3d3810-adb2-11ef-af57-4fcb3e8b4a31
Year Householder Moved Into Unit. Social explorer. (n.d.). https://www.socialexplorer.com/reports/socialexplorer/en/report/994a995a-adb1-11ef-86dd-0f6c4c450013