Analyzing Greystar's performance as manager across Sun Belt markets...
 
Metric                    Greystar     Market Avg    Variance
──────────────────────────────────────────────────────────────
Renewal Rent Growth         4.8%         3.9%        +0.9% ▲
NOI Margin                  52.3%        49.1%        +3.2% ▲
Turnover Rate               34.2%        38.7%        -4.5% ▼ (better)
Occupancy                   94.1%        92.8%        +1.3% ▲

Running rent growth analysis for Camden Property Trust (owner)...
 
Property               Submarket     Camden YoY    Sub YoY    Comp Set    Delta vs Sub
───────────────────────────────────────────────────────────────────────────────────
Camden Buckhead        Atlanta NE     +3.2%         +2.7%       +2.9%       +0.5% ▲
Camden South End       Charlotte Core +4.1%         +3.8%       +3.5%       +0.3% ▲
Camden Brickell        Miami CBD      +5.8%         +6.4%       +6.1%       -0.6% ▼
Camden Design District Dallas Uptown  +2.9%         +1.8%       +2.2%       +1.1% ▲
 
Portfolio Summary:
• 3 of 4 highlighted properties are outpacing their respective submarket averages.
• Miami Brickell (-0.6% vs submarket) is the lone underperformer in rent growth.
• Strongest outperformance: Dallas Uptown property at +1.1% above submarket YoY.

Distressed Asset Identifier— Dallas–Fort Worth
Screening Dallas–Fort Worth for distressed multifamily assets (DSCR < 1.2, Occupancy < 85%)...
 
Found 6 distressed assets:
 
Property                   Units   DSCR    Occupancy   Loan Maturity   Risk Level
────────────────────────────────────────────────────────────────────────────────────
Pinnacle at Cypress        312     0.88    82.1%        Jun 2025        CRITICAL
The Reserve at Garland     228     1.04    83.7%        Sep 2024        HIGH
Lakeview Commons           186     0.97    79.4%        Dec 2025        CRITICAL
Sunset Ridge Apartments    144     1.11    84.2%        Mar 2026        ELEVATED
Park at Ridgewood          408     1.08    81.9%        Aug 2025        HIGH
Willowbrook Estates        264     1.15    83.4%        Nov 2025        ELEVATED
 
Summary: 3 CRITICAL assets with DSCR < 1.0 and near-term loan maturities — likely
motivated sellers. Pinnacle at Cypress and Lakeview Commons present the highest urgency
given sub-1.0 DSCR and 2025 maturities.

Pulling GSE watch list for Fannie Mae and Freddie Mac (risk threshold: 0.7)...
 
GSE Type      Property                  Market          Risk Score   DSCR    Occupancy
──────────────────────────────────────────────────────────────────────────────────────
Fannie Mae    The Villas at Mesa        Phoenix, AZ      0.84        1.07    83.2%
Fannie Mae    Bridgewater Crossing      Atlanta, GA      0.78        1.13    85.8%
Freddie Mac   Harbor Point Residences   Tampa, FL        0.91        0.96    81.4%
Freddie Mac   Creekside Village         Denver, CO       0.75        1.18    86.1%
Fannie Mae    Northgate Commons         Charlotte, NC    0.72        1.21    88.3%
 
5 loans flagged. Harbor Point Residences carries the highest risk score (0.91) with
sub-1.0 DSCR — likely a candidate for special servicing. Recommend prioritizing this
asset for immediate review.

Scanning Austin for construction starts 2022+ with loan maturities due...
 
Property                   Units   Start Year   Loan Maturity   Occupancy   Status
────────────────────────────────────────────────────────────────────────────────────
Novel South Congress       342     2022         Aug 2025        71.4%       LEASE-UP
The Aldrich Domain North   286     2023         Mar 2026        58.2%       LEASE-UP
Broadstone Eastside        412     2022         Nov 2025        79.8%       SLOW
Hanover Republic Square    224     2023         Jun 2026        62.1%       LEASE-UP
AMLI 5th Street            318     2022         Oct 2025        67.3%       SLOW
 
All 5 properties are in active lease-up or experiencing slow absorption. Combined with
near-term construction loan maturities, these assets represent elevated refinancing risk
as developers will likely need to refinance before stabilization. Novel South Congress
and AMLI 5th Street face the tightest timelines.

Screening Southeast markets for DSCR < 1.25 (excluding already-distressed assets)...
 
Property                     Market         DSCR    Occupancy   Loan Maturity
──────────────────────────────────────────────────────────────────────────────
The Monroe at Perimeter      Atlanta, GA    1.22    90.4%       Apr 2026
Ashford Green                Nashville, TN  1.19    88.7%       Jul 2026
Retreat at Palmetto Bay      Miami, FL      1.17    91.2%       Jan 2027
Summit at Concord Mills      Charlotte, NC  1.24    89.9%       Sep 2026
Harbor Lights                Tampa, FL      1.14    87.6%       Nov 2025
 
5 pre-distressed assets identified. These properties are not yet flagged as distressed
but show DSCR compression that warrants monitoring. Harbor Lights (Tampa) has the lowest
DSCR at 1.14 with a Nov 2025 maturity — earliest watch priority.

Identifying Phoenix properties with loan maturities in 2024–2025...
 
Property                    Units   Loan Maturity   DSCR    Occupancy   Refi Risk
────────────────────────────────────────────────────────────────────────────────────
Desert Ridge Apartments     284     Mar 2025        0.92    81.3%       CRITICAL
Arcadia Place               196     Jun 2025        1.08    88.4%       HIGH
The Palms at Tempe          322     Aug 2025        1.21    91.7%       MODERATE
Sunstone at Chandler        248     Oct 2025        1.31    93.2%       LOW
Camelback Crossing          410     Dec 2024        1.03    84.1%       HIGH
 
5 properties identified. Desert Ridge Apartments is the highest priority with sub-1.0
DSCR, below-threshold occupancy, and a March 2025 maturity — refinancing at current rates
would be extremely challenging. Camelback Crossing also warrants attention given its
December 2024 maturity and borderline DSCR of 1.03.

Scanning Denver for recently delivered properties with slow lease-up (YoY occ. change < -10%, occ. < 90%)...
 
Property                    Units   Delivered   Occupancy   YoY Change   Submarket Avg
──────────────────────────────────────────────────────────────────────────────────────
Nexus RiNo                  286     Q1 2023     67.4%        -14.2%       +1.8%
The Huxley Uptown           324     Q3 2022     72.1%        -11.8%       +0.9%
Modera LoDo                 412     Q2 2023     74.8%        -13.1%       +1.2%
Broadstone Congress Park    198     Q4 2022     78.3%        -10.4%       +0.7%
 
Market Context: Denver's overall lease-up pace has slowed materially as 6,800+ units
were delivered in 2022–2023. Nexus RiNo shows the steepest occupancy decline at -14.2%
against a submarket that grew +1.8% — indicating property-specific operational issues
beyond market headwinds. Potential value-add acquisition opportunity.

Scoring Southeast MSAs for LIHTC success (stability weight: 0.7, min 1,000 units)...
 
Rank   MSA                      LIHTC Score   Stability   Rent Growth   Competition
────────────────────────────────────────────────────────────────────────────────────
1      Greenville, SC            87.4          High        +3.1%         Low
2      Huntsville, AL            84.2          High        +3.8%         Low
3      Columbia, SC              82.9          High        +2.7%         Low-Med
4      Chattanooga, TN           81.1          High        +2.9%         Low
5      Augusta, GA               79.6          Med-High    +2.4%         Low
6      Knoxville, TN             78.3          High        +2.2%         Low
7      Savannah, GA              77.8          Med-High    +3.3%         Med
8      Baton Rouge, LA           76.4          Med-High    +2.0%         Low-Med
 
Recommendation: Greenville and Huntsville lead the Southeast LIHTC rankings with
strong stability scores and low competition. Both markets have experienced consistent
rent growth without oversupply, creating favorable conditions for LIHTC absorption.

Screening for assumable debt ≤ 5% interest rate, 1yr inv. growth < 5%, 2yr growth < 10%...
 
Property                     Market            Units   Rate     DSCR   Rating   1yr Inv.
──────────────────────────────────────────────────────────────────────────────────────────
Meridian at Mueller          Austin, TX         318    3.82%    1.34    7/10    3.2%
The Addison at Perimeter     Atlanta, GA        244    4.15%    1.28    8/10    2.9%
Lofts at Sawyer Yards        Houston, TX        196    3.67%    1.41    7/10    4.1%
Elan City Lights             Dallas, TX         286    4.48%    1.22    6/10    3.8%
Novel Turtle Creek           Dallas, TX         214    3.94%    1.37    8/10    3.4%
 
Top Pick: Meridian at Mueller (Austin) — 3.82% assumable rate, DSCR 1.34, and a supply-
constrained submarket with only 3.2% inventory growth forecast. The 91bp rate advantage
vs current market rates represents significant structural value for a buyer.

Benchmarking portfolio: comparing each property against portfolio median...
 
Property                  Market          NOI Margin  Renewal Rate  Occupancy  Rank
────────────────────────────────────────────────────────────────────────────────────────
Broadstone Midtown        Atlanta, GA       58.4%        74.2%        96.1%    #1
The Ashton at Harbor Bay  Tampa, FL         56.9%        71.8%        95.3%    #2
Novel Peachtree           Atlanta, GA       55.7%        70.4%        94.8%    #3
The Wren                  Austin, TX        55.1%        69.9%        94.2%    #4
Ovation at Arrowhead      Phoenix, AZ       54.3%        68.7%        93.7%    #5
 
Top 5 portfolio performers identified. Broadstone Midtown leads with 58.4% NOI margin
and 74.2% renewal rate — 6.2 points and 9.4 points above portfolio median respectively.
Common factor: all top performers have stabilized occupancy above 93% and active
revenue management programs. Recommend sharing operational practices across portfolio.

Calculating risk scores across all factors: DSCR, occupancy, loan maturity, rent growth...
 
Property                   Market         Risk Score  DSCR   Occ.   Mat.    Flag
──────────────────────────────────────────────────────────────────────────────────────
Lakeview Commons           Dallas, TX        0.93    0.97   79.4%  Dec-25  CRITICAL
Harbor Point Residences    Tampa, FL         0.91    0.96   81.4%  Mar-26  CRITICAL
Pinnacle at Cypress        Dallas, TX        0.88    0.88   82.1%  Jun-25  CRITICAL
The Reserve at Garland     Dallas, TX        0.82    1.04   83.7%  Sep-24  HIGH
Camelback Crossing         Phoenix, AZ       0.79    1.03   84.1%  Dec-24  HIGH
Desert Ridge Apartments    Phoenix, AZ       0.77    0.92   81.3%  Mar-25  HIGH
 
6 properties flagged above 0.7 risk threshold. 3 CRITICAL assets have sub-1.0 DSCR
combined with near-term loan maturities — these represent the most urgent action items.
Remaining portfolio (27 properties) scores below 0.65 risk threshold with stable
fundamentals. Recommend quarterly re-scoring cadence for flagged properties.

Pulling time series rent data for Austin, Denver, and Phoenix (2022-2024)...
 
Year    Quarter    Austin YoY    Denver YoY    Phoenix YoY    National Avg
────────────────────────────────────────────────────────────────────────
2022    Q1          +12.4%        +14.2%         +16.8%          +11.3%
2022    Q3           +9.8%        +11.7%         +13.1%           +9.2%
2023    Q1           +4.2%         +1.8%          +2.9%           +3.4%
2023    Q3           +1.1%         -1.4%          +0.7%           +1.2%
2024    Q1           -0.8%         -2.9%          -1.2%           -0.4%
2024    Q3           +0.4%         -1.1%          +0.3%           +0.6%
 
All three metros followed similar trajectories: peak growth in 2022 driven by pandemic
demand surge, rapid deceleration through 2023, and mild negative corrections in early
2024 due to heavy supply deliveries. Denver shows the most persistent softness at
-2.9% in Q1 2024. Austin and Phoenix are stabilizing and trending toward recovery.

Executing: SELECT PropertyName, Market, Units, Occupancy, DSCR FROM Properties
  WHERE State = 'TX' AND Units > 300 AND Occupancy > 0.90 ORDER BY Units DESC
 
PropertyName                 Market      Units  Occupancy   DSCR
────────────────────────────────────────────────────────────────────
The Domain at Barton Creek   Austin        612    93.4%     1.38
Elan Westside                Houston       524    91.8%     1.29
Camden Travis Street         Houston       487    92.6%     1.31
Arium Grandview              Dallas        456    90.7%     1.24
Broadstone Midtown           Dallas        412    94.2%     1.41
The Ashby High Rise          Houston       388    91.4%     1.27
Cortland River Oaks          Houston       347    93.1%     1.35
Arrive Katy                  Houston       321    90.3%     1.22
 
8 rows returned in 0.42 seconds.
 
Query returned 8 properties across 3 Texas metros. Houston leads with 5 qualifying
properties, followed by Dallas (2) and Austin (1). The Domain at Barton Creek is
the largest at 612 units with a healthy DSCR of 1.38. All 8 properties maintain
DSCR above 1.2, indicating strong debt service coverage across this cohort.

Fetching financial forecast data for Broadstone Midtown (Property ID: ATL-0482)...
 
Current Financials:
  NOI (Trailing 12M):         $4,218,400
  NOI Margin:                    58.4%
  DSCR (Current):                 1.41
  Debt Service (Annual):      $2,991,000
  Loan Balance:              $38,200,000
  Loan Maturity:             August 2028
  Loan Type:                  Fannie Mae
  Interest Rate:                  3.95%
 
12-Month Forecast:
  Projected NOI:             $4,394,000   (+4.2%)
  Projected DSCR:                  1.47   (+0.06)
  Rent Growth Forecast:            +3.8%
  Occupancy Forecast:             95.1%
  Risk Flag:                        NONE
 
Broadstone Midtown presents a strong financial profile with improving fundamentals.
DSCR is projected to expand to 1.47 over the next 12 months, well above distress
thresholds. The 2028 loan maturity provides runway, and the 3.95% fixed rate offers
significant below-market advantage. No risk flags identified.

Fetching demographic data for Harbor Point Residences (1-mile, 3-mile, 5-mile radius)...
 
Metric                        1-Mile       3-Mile       5-Mile
──────────────────────────────────────────────────────────────
Median Household Income       $74,200      $68,400      $62,100
Median Renter Income          $52,800      $48,700      $44,200
Population (2024 est.)         18,400       87,300      214,600
5yr Population Growth           +4.2%        +3.8%        +3.1%
Renter Occupied Units           61.4%        54.7%        49.2%
Bachelor Degree or Higher       48.3%        42.1%        36.8%
Median Age                       33.2         34.8         36.1
Unemployment Rate                4.1%         4.6%         5.2%
 
The 1-mile trade area skews young (median age 33), educated (48% college+), and
renter-dominant (61% renter-occupied). Median renter income of $52,800 supports
rents in the $1,320-$1,760/mo range (30% income threshold). Population growth
trend of +4.2% within 1-mile indicates continued demand fundamentals.

Fetching unit mix and rent trends for The Domain at Barton Creek (Property ID: AUS-0187)...
 
Unit Type  Units   Avg SF   Asking Rent  Eff. Rent   Occupancy  YoY Chg
──────────────────────────────────────────────────────────────────────────────
Studio       48     512      $1,420       $1,385        91.7%    +1.2%
1BR/1BA     198     748      $1,890       $1,847        93.8%    +0.8%
1BR/1BA+D    84     864      $2,050       $2,001        94.1%    +1.4%
2BR/2BA     196    1,142     $2,580       $2,512        93.2%    +0.6%
2BR/2BA+D    62    1,284     $2,790       $2,718        92.3%    +0.4%
3BR/2BA      24    1,520     $3,410       $3,326        91.7%    +0.9%
 
Total/Avg   612     964      $2,190       $2,135        93.4%    +0.9%
 
The 1BR/1BA unit type is the most in-demand tier (93.8% occupancy) and contributes
the largest revenue share. Studio units show the highest relative rent growth at
+1.2% YoY. Overall portfolio effective rent of $2,135 is tracking in line with
Austin submarket averages. No meaningful concession activity observed.

Screening full national database: DSCR < 1.0 AND Occupancy < 80%...
 
Property                    Market          DSCR    Occ.   Maturity   Urgency
──────────────────────────────────────────────────────────────────────────────────
Pinnacle at Cypress         Dallas, TX      0.88   79.4%  Dec-2025   CRITICAL
Harbor Point Residences     Tampa, FL       0.96   78.8%  Mar-2026   CRITICAL
Lakeview Commons            Dallas, TX      0.97   79.1%  Jun-2025   CRITICAL
Sunset Pines                Las Vegas, NV   0.91   77.3%  Aug-2025   CRITICAL
The Ashford at Mesa         Phoenix, AZ     0.94   78.4%  Oct-2025   HIGH
Creekside Manor             Atlanta, GA     0.98   79.8%  Jan-2026   HIGH
Willowbrook Commons         Houston, TX     0.99   79.3%  Feb-2026   HIGH
 
7 properties meet criteria across 5 markets.
 
4 CRITICAL assets have overlapping sub-1.0 DSCR, sub-80% occupancy, and loan
maturities within 12 months — perfect storm conditions for distressed sales.
Dallas and Phoenix are the highest-concentration markets. Sunset Pines (Las Vegas)
stands out with 77.3% occupancy — the lowest in the cohort — suggesting acute
operational distress beyond financing pressure.

Generating comprehensive market intelligence report for Nashville, TN...
 
NASHVILLE MULTIFAMILY MARKET OVERVIEW
Report Date: Q4 2024  |  Data Source: Yardi Matrix
 
Supply & Demand:
  Total Inventory:        128,400 units  (+3.1% YoY)
  Units Under Construction: 12,800 units  (10.0% of stock)
  Deliveries (TTM):         8,200 units
  Absorption (TTM):         7,100 units
  Supply/Demand Ratio:          0.87  (demand lagging supply)
 
Rent Trends:
  Avg Asking Rent:         $1,742/mo  (+2.4% YoY)
  Effective Rent:          $1,698/mo  (+1.9% YoY)
  Concessions:              1.4% of asking rent
 
Occupancy:
  Market Average:          91.2%  (-1.1pp YoY)
  Stabilized Assets:       93.8%
  Lease-Up Assets:         79.4%
 
Top Performing Submarkets:
  1. Germantown / Salemtown  —  Occ: 95.2%, Rent: $2,180, Growth: +4.1%
  2. The Gulch / SoBro        —  Occ: 94.1%, Rent: $2,340, Growth: +3.8%
  3. East Nashville           —  Occ: 93.7%, Rent: $1,890, Growth: +3.2%
 
Nashville faces moderate near-term supply pressure with 12,800 units under construction
(10% of stock). Absorption is lagging supply, contributing to a -1.1pp occupancy
decline. However, urban core submarkets (Germantown, Gulch) remain resilient with
sub-5% vacancy. Long-term employment fundamentals (healthcare, tech, corporate
relocations) support continued demand recovery through 2025-2026.

Loading dataset summary for Yardi Matrix Virtuoso...
 
Property Coverage:
  Total Properties Tracked:       87,400+
  Multifamily Units Covered:    13.2 million
  Geographic Coverage:          All 50 states, 400+ MSAs
  Property Size Range:          5 units to 6,000+ units
  Vintage Range:                Pre-1970 through 2025 (YTD)
 
Data Categories Available:
  Rent & Occupancy:             Monthly asking and effective rents, occupancy
  Financial:                    DSCR, NOI, loan details, maturity dates
  Transactions:                 Sale prices, cap rates, buyer/seller info
  Construction:                 Permits, starts, deliveries, pipeline
  Demographics:                 Population, income, education (1/3/5-mile)
  Ownership:                    Owner and manager names, portfolio mapping
  Time Series:                  Monthly data back to 2012 for major metros
 
Loan Data:
  Total Loans Tracked:          42,000+
  Loan Types:                   Fannie Mae, Freddie Mac, CMBS, Bank, Life Co
  Maturity Coverage:            2024 through 2040+
 
Yardi Matrix provides one of the most comprehensive multifamily datasets available,
covering 87,400+ properties and 13.2 million units across all major US markets.
Monthly time series data back to 2012 enables robust trend analysis. Loan and
ownership data layers add unique intelligence for acquisition and risk workflows.

Searching for Camden Property Trust properties in Charlotte market...
 
Property Name              UPropertyID    Units  Submarket                       Status
────────────────────────────────────────────────────────────────────────────────────────
Camden South Charlotte     1358141         420   32 - Ballantyne - Providence    Under Construction
Camden Ballantyne          78012           400   32 - Ballantyne - Providence    Completed
Camden NoDa                861744          385   8 - Tryon Hills                 Completed
Camden Sedgebrook          77824           368   27 - Huntersville               Completed
Camden Blakeney            1394647         349   32 - Ballantyne - Providence    Under Construction
Camden Gallery             78738           323   14 - Southside Park             Completed
Camden Stonecrest          78013           306   32 - Ballantyne - Providence    Completed
Camden South End           77954           299   7 - Third Ward - Lakewood       Completed
Camden Grandview           77951           294   2 - Uptown                      Completed
Camden Southline           78739           266   6 - Myers Park                  Completed
Camden Foxcroft            77950           256   12 - Foxcroft                   Completed
Camden Cotton Mills        77691           180   2 - Uptown                      Completed
Camden Dilworth            77948           145   6 - Myers Park                  Completed
Camden Fairview            77949           135   12 - Foxcroft                   Completed
Camden Touchstone          77987           132   23 - Pineville                  Completed
 
15 properties found (13 completed, 2 under construction). Total: 4,258 units.
Use UPropertyID values above with fetch_financial_forecast, fetch_property_unit_mix,
and fetch_property_demographics for property-level analysis.
 
15 Camden Property Trust assets confirmed in the Charlotte market totaling 4,258 units. 13 completed and 2 under construction (Camden South Charlotte, 420 units; Camden Blakeney,349 units). Ballantyne - Providence is the most concentrated submarket with 4 properties.

Resolving query approach for unit-type rent trends...
  get_query_guidance: unit mix rents by property over time
  > Table: dbo.UnitMixRents | Required filters: upropertyid + period
 
  get_property_ids: property_name=Camden South End, market=Charlotte
  > UPropertyID: 77954
 
Unit Type               Units   Mar-25   Jun-25   Sep-25   Dec-25   Mar-26   YoY Δ
────────────────────────────────────────────────────────────────────────────────
Studio (599 sqft)          18   $1,551   $1,463   $1,521   $1,531   $1,447   -6.7%
One Bedroom (814 sqft)    183   $1,719   $1,778   $1,699   $1,659   $1,587   -7.7%
Two Bed/1.5 Bath (1009sf)   1   $2,182   $2,400   $2,169   $2,074   $2,010   -7.9%
Two Bed/2 Bath (1190 sqft)  97  $2,317   $2,527   $2,421   $2,367   $2,351   +1.5%
────────────────────────────────────────────────────────────────────────────────
Weighted Avg (299 units)      $1,904   $2,004   $1,924   $1,882   $1,828   -4.0%
 
Peak: Jun-25 at $2,004 (portfolio avg). Current: $1,828 as of Mar-26.
Data sourced from Yardi Matrix (UPropertyID 77954). 66 months of history available.
 
Rents at Camden South End peaked in June 2025 and declined -4.0% year-over-year by
March 2026. Two Bed/2 Bath is the only unit type showing positive YoY growth (+1.5%),
while Studios and One Bedrooms softened the most (-6.7% and -7.7% respectively).
The 2BR/2BA tier (97 units, 32% of the building) is anchoring overall performance.

Checking data definitions via get_schema_info...
Consulting get_query_guidance for rent field definitions...
  > Rent figures in dbo.UnitMixRents (field: monthlyrent) represent asking rents
    (advertised/listed rent), not effective rents (net of concessions or discounts).
 
Weighted average calculation (confirmed from fetch_property_unit_mix response):
  Weighted Avg Rent = SUM(unit_type_rent x unit_count) / total_units
 
  Studio:          18 units x $1,447  =   $26,046
  One Bedroom:    183 units x $1,587  =  $290,421
  2BR/1.5BA:        1 unit  x $2,010  =    $2,010
  2BR/2BA:         97 units x $2,351  =  $228,047
                  ──────────────────────────
  Total:          299 units            = $546,524  /  299  =  $1,827.84
 
  Reported weighted avg: $1,827.84 ✓  Matches API output.
 
Note: Yardi Matrix tracks asking rent only. Effective rent (after concessions)
is not available at the unit-type level in this dataset.
 
The $1,904 → $1,828 movement reflects asking rent, not effective rent. The weighted
average is unit-count weighted across the four unit types in the property. One Bedrooms (183 of 299 units, 61% of the building) dominate the calculation.

Loading time series catalog and metro coverage...
 
Available Time Series Metrics:
 
  Rent Metrics:
    asking_rent             Monthly average asking rent (per unit)
    effective_rent          Monthly average effective rent (net of concessions)
    rent_growth_yoy         Year-over-year effective rent change (%)
    concession_rate         Concessions as % of asking rent
 
  Occupancy Metrics:
    occupancy_rate          Monthly average physical occupancy
    absorption_units        Net units absorbed (monthly)
 
  Supply Metrics:
    units_under_const       Units currently under construction
    units_delivered         Units delivered (monthly/quarterly)
    inventory_growth_yoy    YoY inventory growth (%)
 
  Financial Metrics (quarterly):
    noi_margin              Net operating income margin
    dscr_avg                Portfolio average DSCR
 
Metro Coverage:   420 MSAs with full monthly history
Data Start Date:  January 2012 (major metros); 2016 (secondary markets)
Update Frequency: Monthly (rents/occupancy); Quarterly (financials)
 
Yardi Matrix offers 10 core time series metrics across 420 metros, with rent and
occupancy data available monthly back to 2012. This enables 12-year trend analysis
covering multiple market cycles. Financial metrics (NOI, DSCR) are reported
quarterly. Use query_timeseries_data to pull any metric for any market.

Analyzing occupancy trends for Miami metro (2022 Q1 through 2024 Q3)...
 
Period       Occupancy   QoQ Change   YoY Change   Trend Signal
──────────────────────────────────────────────────────────────────────
2022 Q1        96.1%        +0.4%        +2.8%       PEAK
2022 Q3        95.8%        -0.3%        +2.1%       PLATEAU
2023 Q1        94.2%        -1.6%        -1.9%       INFLECTION ▼
2023 Q3        92.8%        -1.4%        -3.0%       DECLINING
2024 Q1        91.9%        -0.9%        -2.3%       STABILIZING
2024 Q3        92.4%        +0.5%        -0.4%       RECOVERING ▲
 
Key Inflection Points:
  ▼ 2023 Q1: Occupancy broke below 95% — first sub-95% reading since 2019.
     Catalyst: Surge in new supply deliveries (+9,200 units in 2022-2023).
  ▲ 2024 Q3: First positive QoQ reading in 6 quarters — recovery signal.
     Catalyst: Absorption pace exceeding new deliveries for first time.
 
Miami occupancy peaked at 96.1% in Q1 2022 and declined 4.2 points through Q1 2024
as supply wave absorbed. The Q3 2024 inflection (+0.5% QoQ) signals the market is
turning, though YoY comparisons remain slightly negative. Monitor Q4 2024 data to
confirm recovery trend before underwriting aggressive rent growth assumptions.

Analyzing CMBS loan maturities across Sun Belt markets (2025-2026)...
 
Market           # Loans   Total Exposure    Avg DSCR   High Risk   Critical
──────────────────────────────────────────────────────────────────────────
Dallas, TX          48      $2.84B             1.18        12          4
Houston, TX         37      $1.97B             1.21         9          2
Atlanta, GA         31      $1.62B             1.24         7          1
Phoenix, AZ         28      $1.44B             1.16        11          3
Austin, TX          22      $1.18B             1.19         8          2
Tampa, FL           19      $0.94B             1.22         6          1
Charlotte, NC       14      $0.71B             1.31         3          0
Nashville, TN       11      $0.58B             1.28         4          0
 
Totals             210     $11.28B             1.20        60         13
 
210 CMBS loans totaling $11.28B mature across Sun Belt markets in 2025-2026.
Dallas and Phoenix show the highest concentration of critical risk (4 and 3 assets
respectively) with DSCR below 1.0. 60 loans (29%) are flagged high risk —
meaning refinancing at current rates will require equity infusion or loan
modification. Charlotte and Nashville show the healthiest average DSCR profiles.

Running market analysis for Seattle metro (King, Snohomish, Pierce counties)...
 
MARKET PERFORMANCE SNAPSHOT
  Total Inventory:          142,800 units
  Avg Asking Rent:          $2,184/mo  (+1.8% YoY)
  Avg Effective Rent:       $2,106/mo  (+1.2% YoY)
  Market Occupancy:          93.1%     (-0.7pp YoY)
  Concession Rate:            3.2%
 
SUPPLY PIPELINE
  Under Construction:       11,400 units  (8.0% of stock)
  Expected 2025 Deliveries:  5,200 units
  Expected 2026 Deliveries:  4,800 units
  Absorption Rate (TTM):     4,900 units/year
 
TOP SUBMARKETS BY RENT GROWTH
  South Lake Union:  $3,210/mo  +4.2% YoY  Occ: 95.8%
  Capitol Hill:      $2,480/mo  +3.1% YoY  Occ: 94.6%
  Bellevue CBD:      $2,890/mo  +2.8% YoY  Occ: 94.2%
 
OUTLOOK: Neutral — supply and demand near equilibrium, tech sector employment
         stabilization limiting upside; urban core submarkets outperforming.
 
Seattle presents a balanced market with modest rent growth (+1.8%) and slight
occupancy softening from the supply pipeline. The 2025-2026 delivery schedule
matches trailing absorption, limiting further occupancy declines. South Lake Union
and Capitol Hill are standout submarkets. Risk-adjusted, Seattle is a hold market
with selective buy opportunities in core urban product.

Benchmarking portfolio performance in Denver against market and submarket averages...
 
Metric                  Portfolio   Market Avg   Submarket Avg   vs. Market
──────────────────────────────────────────────────────────────────────────
Avg Asking Rent          $1,984       $1,847        $1,912          +7.4% ▲
Avg Effective Rent       $1,928       $1,791        $1,861          +7.7% ▲
Occupancy Rate            93.8%        91.4%         92.6%          +2.4pp ▲
Rent Growth YoY           +1.8%        -0.6%         +0.4%         +2.4pp ▲
Concession Rate           1.4%         3.8%          2.9%          -2.4pp ▲
Avg DSCR                  1.38         1.21          1.29           +0.17 ▲
Avg NOI Margin            55.2%        49.7%         52.1%          +5.5pp ▲
 
Portfolio significantly outperforms Denver market across all seven tracked metrics.
Most notable outperformance: effective rent (+7.7% premium) and occupancy (+2.4pp)
achieved while running below-market concessions (1.4% vs. 3.8%). This suggests
portfolio assets are well-located and operationally superior. Maintain current
strategy; consider selectively increasing asking rents given occupancy cushion.

Querying time series: Atlanta metro, metrics: effective_rent + occupancy_rate,
  date range: 2022-01 through 2024-12, aggregation: monthly...
 
Month       Eff. Rent   MoM Chg    Occupancy   MoM Chg
────────────────────────────────────────────────────────────
Jan-2022     $1,618      +0.8%       94.8%      +0.3pp
Apr-2022     $1,712      +1.4%       95.6%      +0.2pp
Jul-2022     $1,784      +0.6%       95.2%      -0.4pp
Oct-2022     $1,748      -0.4%       94.4%      -0.5pp
Jan-2023     $1,724      -0.3%       93.7%      -0.2pp
Apr-2023     $1,741      +0.4%       93.4%      -0.1pp
Jul-2023     $1,758      +0.3%       93.1%      -0.2pp
Oct-2023     $1,749      -0.2%       92.6%      -0.3pp
Jan-2024     $1,736      -0.2%       92.2%      -0.2pp
Apr-2024     $1,752      +0.5%       92.4%      +0.1pp
Jul-2024     $1,771      +0.4%       92.8%      +0.3pp
Oct-2024     $1,782      +0.3%       93.1%      +0.2pp
 
36 months returned. Peak: Jul-2022 ($1,784 / 95.2%). Trough: Jan-2024
  ($1,736 / 92.2%). Recovery trajectory confirmed Q2-Q4 2024.
 
Atlanta followed a classic peak-to-trough-to-recovery pattern: peak rents in mid-2022,
gradual correction through 2023, and stabilization/recovery beginning Q2 2024.
The occupancy decline from 95.6% to 92.2% (-3.4pp) is consistent with Sun Belt
supply surge dynamics. Q4 2024 momentum (+0.3% MoM, +0.2pp occupancy) suggests
positive entry point for long-term underwriting.

Searching for Blackstone-affiliated properties in Sun Belt markets...
 
Market           Properties   Units    Avg Occ.   Avg DSCR   Est. Value
────────────────────────────────────────────────────────────────────────
Atlanta, GA           14      6,820     93.4%       1.32      $1.84B
Dallas, TX            11      5,480     92.8%       1.28      $1.47B
Phoenix, AZ            9      4,120     91.9%       1.24      $1.09B
Tampa, FL              7      3,280     93.1%       1.29      $0.84B
Charlotte, NC          6      2,640     94.2%       1.38      $0.68B
Austin, TX             5      2,180     92.4%       1.31      $0.62B
Nashville, TN          4      1,840     93.8%       1.34      $0.52B
 
Total:                56     26,360     93.0%       1.30      $7.06B
 
Note: Ownership mapped via entity affiliation — includes JV and subsidiary holdings.
 
Blackstone holds an estimated 56 properties and 26,360 units in Sun Belt markets
valued at approximately $7.06B. Atlanta is the largest concentration at 14 properties.
Portfolio-wide occupancy of 93.0% and DSCR of 1.30 indicate healthy fundamentals.
Charlotte shows the strongest DSCR (1.38) and occupancy (94.2%) in the portfolio.

Searching available data types for: concessions, lease-up, absorption...
 
Results — Concession Metrics:
  concession_rate          Concessions as % of asking rent (monthly, property/market)
  concession_weeks         Free rent weeks offered (monthly, property)
  net_effective_rent       Asking rent net of concessions (monthly)
  concession_trend_3m      3-month rolling concession change direction
 
Results — Lease-Up & Absorption Metrics:
  lease_up_occupancy       Occupancy for sub-2-year properties (monthly)
  absorption_units         Net units absorbed per month (market level)
  absorption_pace          Months to stabilization at current pace (property)
  days_vacant              Average days a unit sits vacant before leasing
  lease_velocity           Leases signed per week (property, rolling 4wk avg)
 
Coverage:
  concession_rate:         All 87,400+ properties, back to 2018
  lease_up metrics:        Properties delivered 2018+, monthly
 
8 relevant data types found across concession and lease-up categories.
Concession metrics are available property-level back to 2018, making it possible
to track concession cycles across multiple market downturns. Lease-up metrics
require a delivery date and are available for all properties delivered since 2018.
Use query_timeseries_data to pull any of these metrics for analysis.

Searching: market=Charlotte, min_units=200, min_vintage=2015,
           min_occupancy=0.92, min_dscr=1.2...
 
Property                      Units  Vintage  Occupancy  DSCR   Manager
────────────────────────────────────────────────────────────────────────────────
Camden South End               348    2017      94.2%    1.38   Camden Property
Broadstone South End           312    2019      93.8%    1.34   Alliance Residential
Novel South End                286    2018      93.1%    1.29   Novel Residential
The Ashton at SouthPark        274    2016      92.8%    1.31   Greystar
Cortland Ballantyne            384    2020      93.4%    1.35   Cortland
Waterford Place at Riverbend   248    2015      92.4%    1.24   Greystar
The Emerson                    224    2021      94.1%    1.41   Aimco
 
7 properties returned. All meet quality and stabilization criteria.
 
7 properties meet all search criteria in Charlotte. The Emerson (2021, 224 units)
has the highest DSCR at 1.41 and 94.1% occupancy despite being the newest asset.
Camden South End has the largest unit count at 348. All 7 properties are managed
by institutional operators, indicating well-maintained assets with professional
revenue management — aligned with the quality screen intent.

Running data quality validation across portfolio (33 properties)...
 
Check                          Pass   Warn   Fail
────────────────────────────────────────────────
Occupancy data (< 60 days old)   29      3      1
Rent data (< 60 days old)         31      2      0
DSCR populated                    30      0      3
Loan maturity date populated      32      0      1
Owner/manager name match          33      0      0
Unit count validated              33      0      0
Vintage year populated            33      0      0
 
Issues Requiring Attention:
  FAIL  Creekside Manor (ATL-0287)  — Occupancy last updated 94 days ago
  FAIL  The Ashford at Mesa (PHX-0341) — DSCR missing (no loan data on file)
  FAIL  Lakeview Commons (DAL-0198)  — DSCR missing (under special servicing)
  FAIL  Willowbrook Commons (HOU-0412) — Loan maturity date missing
  WARN  3 properties — occupancy data 45-60 days old (approaching threshold)
  WARN  2 properties — rent data 50-60 days old (approaching threshold)
 
Overall data quality is strong: 30 of 33 properties have full, current financial
data. 4 FAIL-level issues require immediate attention — notably 3 properties with
missing DSCR data (2 distressed assets likely in forbearance/special servicing).
Recommend requesting updated servicer data for Ashford at Mesa and Lakeview Commons.
Run validate_data_quality monthly to maintain data integrity for risk reporting.