Aspen at Mercer Crossing is priced as stabilized—likely a hold or portfolio play rather than value-add. The 4.7% implied cap rate sits 11 basis points below the 4.81% submarket average, while the $10.6K NOI per unit tracks inline with comparable Class A product in Dallas. The 45% opex ratio is healthy for a 2018 vintage, and 3.5% vacancy suggests strong operational execution. However, the property commands a $1.1K premium per unit relative to submarket comps ($189.9K), indicating the buyer has priced in location or operational outperformance rather than significant upside from capital deployment or operational improvement.

Aspen at Mercer Crossing is a 260-unit garden-style apartment community built in 2018 with masonry/tilt-wall construction across three stories; the property totals 209K SF gross building area with a quality rating of "Very Good" and excellent condition. Unit mix spans studios through 3-bedrooms with modern finishes including walk-in closets, high ceilings, and in-unit washer/dryer. Parking consists of detached garages and carports (select units). Located in Farmers Branch with a walk score of 31, the property features resort-oriented amenities (resort pool, outdoor kitchen, dog wash, lake views) but lacks car-dependent urban positioning. Pet policy is permissive at $400 fee plus $25/month rent per pet (2-pet limit); no utilities are included in rent.

Aspen at Mercer Crossing is underletting across all unit types relative to submarket benchmarks, with concessions widening sharply to move 17 vacant units. The property averages $1.66M across the portfolio but trails market rents by 7.8% for 1-beds ($1.38M vs. $1.63M), 11.9% for 2-beds ($1.91M vs. $2.17M), and 11.5% for 3-beds ($2.45M vs. $2.76M). Concession depth jumped from 0.9 weeks free on 3/21 to 8.7 weeks (roughly $2.0K off first month) by 3/24—a signal of weakening lease velocity despite a 3.3% submarket growth rate. With 9 active listings (3.5% vacancy implied) and availability spiking from 0 to 17 units in three days, the property is losing occupancy momentum and leaning on price relief rather than rate increases to fill units.

The 67.1% renter concentration within the 3-mile radius—paired with a 21.6% affordability ratio and $94.6K median household income—indicates this is a workforce-to-affluent renter market where rent absorption is feasible but tight. The income distribution is heavily weighted toward $100K+ earners (47.3% of households), suggesting the property captures upper-middle-class renters rather than cost-constrained tenants, though the affordability ratio edges close to the 20% threshold where rent-burdened dynamics emerge. The modest 3- to 5-mile income lift ($94.6K to $97.6K) and declining renter share (67.1% to 59.4%) signal an urban-core location with strong local renter demand but a transition to suburban ownership patterns beyond the 3-mile perimeter. The lack of population growth or employment data limits forward-demand assessment, but current demographics support the $1.66K rent point for a stabilized, affluent renter-focused asset.

Critical data integrity issue: unit mix totals only 12 units against a stated 260-unit property. The listingsbybedroom array captures 9 units total (1 studio, 4 one-BR, 3 two-BR, 1 three-BR), suggesting this dataset represents only active or recent leasing activity rather than the full inventory. Without complete unit mix breakdown, meaningful concentration or market alignment analysis is not possible. Recommend obtaining full as-built unit schedule before proceeding with acquisition underwriting.

Aspen at Mercer Crossing posted 4.7% YoY appreciation to $58.6M, translating to $225.5K per unit—a modest gain for a 2018 vintage asset in a stabilized market. The 6.2% land-to-total ratio is tight, indicating minimal redevelopment optionality; the improvement value of $54.99M reflects a modern, as-built structure with limited value-add leverage on the physical plant. Single-year data limits trend analysis, but the mid-single-digit appreciation suggests market normalization after pandemic-era volatility rather than outsized momentum.

Rating trajectory masks a critical maintenance issue. While the property improved from 4.4 to 4.8 over the past six months, the all-time 4.2 rating reflects 54 one-star reviews (16.1% of 336 total) concentrated on deferred maintenance—specifically common area cleanliness and snow/ice removal. Recent five-star saturation (239 of 260 units, 92%) suggests either selective sampling bias, management-driven review campaigns, or genuine operational improvements, but cannot fully offset the pattern of systemic neglect documented in older complaints. Management responsiveness and staff quality emerge consistently across reviews, yet operational failures in facilities maintenance undermine the investment thesis unless capex and grounds management have materially shifted post-2024.