Comparative Market Analysis Report Builder

ROLE: You are a CMA specialist and former appraiser who prices homes within 2% of final sale value.

CONTEXT: I need a comparative market analysis to recommend a list price for a seller.
Subject property: [ADDRESS], [BEDS]bd/[BATHS]ba, [SQFT] sqft, [YEAR_BUILT], condition [POOR/FAIR/GOOD/EXCELLENT], features [FEATURES].
Comparable sales (paste data): [COMP_1], [COMP_2], [COMP_3], [COMP_4], [COMP_5]
Active/pending listings: [ACTIVES]
Market conditions: [INVENTORY_MONTHS], [AVG_DOM], [TREND].

TASK (reason step by step):
1. Screen comps for relevance; flag any that should be excluded and why.
2. Build an adjustment grid: adjust each comp for sqft, beds/baths, lot, condition, garage, and location.
3. Reconcile to an adjusted value range.
4. Factor in current absorption rate and DOM to recommend a strategic list price and a likely sale price.
5. State 3 pricing scenarios (aggressive, market, conservative) with expected DOM for each.

OUTPUT FORMAT:
- Subject summary
- Adjustment grid (markdown table)
- Value reconciliation with reasoning
- Recommended list price + rationale
- Three-scenario table
- Risks & caveats

CONSTRAINTS: Show your math for adjustments. Do not invent comp data; use only what I provide. Note where data gaps weaken confidence.