Debt structure presents material refinancing risk and potential seller motivation. The property carries $71.1M in aggregate debt across three loans—$363K per unit—against an appraised value of $49M, implying negative equity or near-parity at best; the estimated sale price of $39M suggests the owner is already underwater by $32M in total debt. The 2019 HFF loan ($27.3M, 84-month term, adjustable rate) matured in July 2023 without recorded payoff or refinance, indicating either a forbearance situation or data lag; the Dougherty mortgage ($26M, originated 2016) and older CW Capital loan ($17.8M, 2012) lack maturity dates in records but are likely seasoned. The five transactions over 17 years—including three financing events and a 2022 ownership transfer to Avalon Addison LP—suggest the current operator inherited a leveraged, underwater position; absentee ownership combined with negative spreads makes this a likely distressed refinance or disposition candidate within 12–24 months.

Waterford Court is significantly overvalued relative to market fundamentals. The $39.0M estimated sale price implies a 4.96% cap rate, 237 basis points below the 7.33% Dallas submarket average and 129 bps below the property's own 6.22% stabilized estimate—pricing that reflects either distressed seller motivation or appraisal inflation. At $199.2K per unit versus $128.5K submarket average, the acquisition cost commands a 55.0% unit premium that NOI cannot justify: $12.4K per unit annually trails what a market-rate 7.33% cap would yield ($9.4K), suggesting the seller is betting on future rent growth or the buyer is overpaying. The 45.0% opex ratio is healthy and the 2.0% vacancy conservative, but the $10.0M gap between appraised value and estimated sale price signals the appraisal is either outdated or inflated.

Waterford Court is a 196-unit, 2-story garden-style apartment community built in 1995 with brick exterior and wood-frame construction totaling 207.8K SF. Units feature excellent finishes including quartz countertops, stainless steel appliances, and hard-surface flooring, with all homes offering private attached garages and in-unit washer/dryer. Located in Addison minutes from Downtown Dallas (Walk Score 62), the property is pet-centric with enclosed dog park, pet stations, and social events, though residents bear Electric, Water, Trash, and Sewer costs. Google rating of 4.2 and amenities (fitness center, pool, lounge) indicate strong operational execution in the Addison submarket.

Waterford Court is pricing above market across all unit types, with two-bedrooms commanding a 18.6% premium to submarket benchmarks. Current asking rents average $1.9M for the 196-unit asset, with two-bedrooms at $2.3K (vs. $1.97K market) and one-bedrooms at $1.78K (vs. $1.41K market). The property is lightly leasing with only 4 active listings against 6 available units as of March 2026, suggesting tight occupancy rather than aggressive velocity. No concessions are currently offered, which is defensible given the premium positioning, though the absence of free rent in recent lease events indicates either strong demand absorption or market softness requiring clean pricing to move units.

Waterford Court sits in an urban-core renter enclave with strong affordability but deteriorating fundamentals at scale. The 1-mile radius shows 67.3% renter occupancy and a 26.6% affordability ratio—tight but serviceable for $1,916 ASR against $80.3K median HHI. However, the 5-mile expansion reveals income stratification: median HHI jumps to $95.3K and renter concentration falls to 55.6%, signaling the property anchors a lower-income pocket within a wealthier suburban ring. Income skews toward dual poles—30.4% earn under $50K in the 1-mile radius versus 40.2% over $100K—suggesting a workforce/service-worker tenant base competing against affluent owner-occupancy trends. The 3-mile affordability ratio (23.4%) provides moderate demand buffer, but declining renter %-age and rising home values as you move outward indicate limited geographic spillover for lease-up if the immediate submarket softens.

Critical data integrity issue: The unitmix object reports only 1 one-bedroom unit across a 196-unit property, while listingsby_bedroom shows 4 units (3x1BR, 1x2BR). This 195-unit discrepancy makes portfolio composition analysis unreliable. Cannot assess concentration, rent progression, or market alignment without verified unit counts by type. Recommend data reconciliation before underwriting proceeds.

Appraisal Trend & Value Analysis

Waterford Court's single 2025 appraisal of $49.0M reflects 6.5% YoY appreciation, positioning the asset at $250.0K per unit—a healthy mark for a 30-year-old garden-style property. The improvement-to-land ratio of 86.4% / 13.6% offers minimal redevelopment optionality; at $33.8K per unit, the land value is too constrained to justify a teardown scenario in most Dallas submarkts. Without historical appraisal depth, directional momentum cannot be assessed, but the 2025 valuation suggests stable income generation with modest cap rate compression rather than distress.

Critical deterioration in resident satisfaction signals operational breakdown under current management. The 1.4-point drop in average rating over six months (4.5 to 3.1) reflects a sharp shift in Q1 2026, with 14.3% of all reviews now 1-star versus 4.5% historically. Negative reviews cluster around infrastructure failures (water shutoff during freeze event causing pipe breaks), slow maintenance response times, security breaches, and management communication gaps—distinct from typical staffing turnover issues. The stark contrast between praise for individual leasing staff (Soncya Williams, Joseph Godly, Tami) and systemic complaints about ownership/corporate decision-making suggests the property's operational deterioration stems from capital allocation or corporate policy changes rather than local team capability, materially undermining the investment thesis unless ownership/management is replaced pre-close.