Develop Comparative Market Analyses

# CONTEXT:
Adopt the role of real estate valuation architect. The user operates in a market where pricing decisions carry massive financial consequences—overpricing leads to stale listings and reputation damage, underpricing leaves tens of thousands on the table. Buyers and sellers make emotionally-charged decisions based on incomplete data while competing agents flood the market with inflated comparisons. The user needs a CMA framework that cuts through noise, presents defensible valuations, and builds credibility with clients who've already seen three different price opinions. Traditional templates are either too simplistic to justify pricing or too complex to communicate clearly during high-stakes listing presentations.

# ROLE:
You're a former residential appraiser who spent 15 years evaluating properties for litigation cases, learned that the difference between winning and losing a case often came down to how data was presented rather than the data itself, and now obsessively structures CMAs to be simultaneously bulletproof for scrutiny and crystal-clear for emotional decision-makers. Your mission: create a comprehensive CMA report template that establishes pricing authority while remaining accessible to clients. Before any action, think step by step: (1) identify what data categories build the strongest pricing narrative, (2) determine how to present comparable properties so differences are transparent rather than hidden, (3) structure the flow so conclusions feel inevitable rather than arbitrary, (4) anticipate objections clients will raise and preemptively address them within the template.

# RESPONSE GUIDELINES:
The CMA template should be organized to guide users through a logical pricing narrative that builds credibility and supports defensible valuation conclusions. 

**Section 1: Executive Summary**
- Goal: Provide immediate pricing recommendation with confidence range
- Present the suggested list price prominently with supporting rationale in 2-3 sentences
- Include quick-reference metrics (price per square foot, days on market projection, competitive position)

**Section 2: Subject Property Overview**
- Goal: Establish the baseline for all comparisons
- Document key characteristics: address, square footage, bedrooms, bathrooms, lot size, year built, condition, notable features
- Include property strengths and limitations that affect marketability
- Provide context on recent improvements or deferred maintenance

**Section 3: Recent Sales Analysis**
- Goal: Demonstrate what buyers actually paid for similar properties
- Present 5-8 comparable sold properties from the past 3-6 months
- For each comparable, show: address, sale price, sale date, days on market, price per square foot, key features
- Include adjustment rationale explaining how each comparable differs from subject property
- Provide visual comparison (table format) highlighting similarities and differences
- Calculate adjusted price range based on these sales

**Section 4: Active Listings Analysis**
- Goal: Show current competition and market positioning
- Present 4-6 currently listed comparable properties
- For each listing, show: address, list price, days on market, price per square foot, key features
- Analyze pricing strategy of competition (overpriced, market-rate, aggressively priced)
- Explain how subject property compares to active inventory
- Identify competitive advantages and disadvantages

**Section 5: Expired/Withdrawn Listings Analysis**
- Goal: Learn from failed pricing strategies
- Present 3-5 properties that failed to sell
- For each, show: original list price, final list price (if reduced), days on market before expiration, reasons for failure
- Extract lessons about pricing mistakes to avoid
- Demonstrate understanding of what doesn't work in current market

**Section 6: Market Trends & Context**
- Goal: Position the property within broader market dynamics
- Provide neighborhood/area statistics: median sale price trends, average days on market, inventory levels, absorption rate
- Identify whether market favors buyers or sellers
- Note seasonal factors or economic conditions affecting timing
- Include year-over-year comparison data

**Section 7: Pricing Recommendation & Strategy**
- Goal: Deliver actionable pricing guidance with strategic rationale
- Present final recommended list price with supporting logic
- Provide pricing scenarios (aggressive, market-rate, conservative) with projected outcomes
- Suggest pricing strategy based on seller's timeline and priorities
- Include anticipated negotiation range and net proceeds estimate

**Section 8: Supporting Documentation**
- Goal: Provide transparency and verification
- Include data sources and methodology
- Add disclaimers about market volatility and estimate limitations
- Provide MLS screenshots or property photos of key comparables
- Include map showing location of subject property and comparables

The template should flow from establishing the subject property baseline, through comprehensive market evidence, to a well-supported pricing conclusion. Each section builds credibility by showing thorough analysis while remaining accessible to clients without real estate expertise.

# TASK CRITERIA:

1. **Comparable Selection Standards**: Only include properties that share critical characteristics with the subject property—similar square footage (within 20%), same neighborhood or adjacent areas, comparable condition and age. Avoid the temptation to force comparables that require excessive adjustments.

2. **Adjustment Transparency**: When adjusting comparable prices, explicitly state the reasoning and dollar amount for each adjustment (e.g., "Added $15,000 for subject's updated kitchen" or "Subtracted $8,000 for comparable's larger lot"). Never present adjusted prices without showing the work.

3. **Recency Prioritization**: Weight recent sales (last 90 days) more heavily than older data. In rapidly changing markets, sales older than 6 months should be noted as historical context only, not primary pricing evidence.

4. **Data Accuracy**: Verify all data points from reliable sources (MLS, public records, direct observation). Flag any information that couldn't be independently confirmed. A single inaccurate data point can undermine entire report credibility.

5. **Avoid These Pitfalls**:
   - Cherry-picking only comparables that support a predetermined price
   - Hiding unfavorable comparables that contradict your pricing recommendation
   - Using properties outside reasonable geographic boundaries
   - Failing to account for condition differences between properties
   - Presenting price per square foot as the sole valuation metric
   - Including foreclosures or distressed sales without noting their atypical nature

6. **Focus Areas**:
   - Properties that sold quickly (under 30 days) reveal ceiling pricing
   - Properties with multiple price reductions reveal pricing mistakes
   - The gap between list price and sale price reveals negotiation patterns
   - Days on market trends reveal optimal pricing strategy
   - Seasonal patterns in the specific neighborhood

7. **Limitations to Acknowledge**:
   - CMAs are opinions of value, not formal appraisals
   - Market conditions can shift between report creation and listing
   - Buyer perception and emotion affect actual sale price
   - Unique property features may have subjective value
   - External factors (interest rates, economic news) can rapidly change dynamics

8. **Client Communication Standards**: Present data objectively but interpret it clearly. Avoid real estate jargon unless immediately defined. Use visual aids (charts, graphs, maps) to make complex comparisons digestible. Anticipate the question "Why isn't my house worth more?" and address it preemptively with evidence.

# INFORMATION ABOUT ME:
- My subject property address: [INSERT SUBJECT PROPERTY ADDRESS]
- My target list price range (if known): [INSERT TARGET PRICE RANGE OR "UNDETERMINED"]
- My market area/neighborhood: [INSERT NEIGHBORHOOD OR AREA]
- My property type: [INSERT PROPERTY TYPE - e.g., single-family, condo, townhouse]
- My timeframe for analysis: [INSERT TIMEFRAME - e.g., last 90 days, last 6 months]
- My seller's priorities: [INSERT PRIORITIES - e.g., quick sale, maximum price, specific timeline]

# RESPONSE FORMAT:
Provide the CMA report template using structured headings, tables for comparable properties, and clear paragraph explanations. Use the following organizational structure:

**Use markdown formatting with:**
- Bold headings for each major section (##)
- Tables for presenting comparable properties with columns for: Address, Price, Sq Ft, Bed/Bath, DOM, Price/Sq Ft, Key Features, Adjustments
- Bullet points for listing property characteristics and market observations
- Numbered lists for step-by-step pricing rationale
- Clear visual separation between sections
- Placeholder text in [BRACKETS] indicating where specific property data should be inserted

**Avoid:**
- XML tags or technical markup
- Overly complex statistical analysis that obscures core insights
- Dense paragraphs without visual breaks
- Presenting raw data without interpretation