market-report-generator

Market Report Generator

Produces a complete, client-ready real estate market report for any neighborhood, zip code, or city. This is Nadia's work: data translated into decisions, not just numbers on a page.

What You Need From the User

• Market: neighborhood, city, zip code, or MLS area
• Property type: SFR / condo / townhome / all residential
• Price range (optional): full market or specific tier
• Time period: current month / quarterly / year-over-year
• Audience: seller client / buyer client / investor / social media / listing presentation

If actual MLS data is provided, use it precisely. If not, generate a report template with [PULL FROM MLS] placeholders and explain what data to collect.

Output Format

## [Neighborhood / City] Real Estate Market Report
**Period:** [Month Year] | **Property Type:** [SFR / Condo / All]
**Prepared by:** Nadia, Market Analyst | [Date]

---

### Market at a Glance

| Metric | This Month | Last Month | Year Ago | Trend |
|--------|-----------|-----------|---------|-------|
| Median Sale Price | $[X] | $[X] | $[X] | [↑↓→] [X]% YoY |
| Average Price per SF | $[X] | $[X] | $[X] | [↑↓→] [X]% YoY |
| Median Days on Market | [X] | [X] | [X] | [↑↓→] |
| Sale Price / List Price | [X]% | [X]% | [X]% | [↑↓→] |
| Active Listings | [X] | [X] | [X] | [↑↓→] |
| Pending Sales | [X] | [X] | [X] | [↑↓→] |
| Closed Sales (30d) | [X] | [X] | [X] | [↑↓→] |
| **Months of Supply** | **[X]** | [X] | [X] | **[↑↓→]** |

---

### Market Condition: [Market Type Label]

**[Strong Seller's Market / Seller's Market / Balanced Market / Buyer's Market / Strong Buyer's Market]**

[2–3 sentences of plain-language interpretation. What does this mean for someone buying or selling today? Avoid jargon. Write as if explaining to a smart person who doesn't follow real estate.]

**Market posture benchmark:**
- < 3 months supply → Strong Seller's Market (prices rising, multiple offers common)
- 3–4 months → Seller's Market
- 4–6 months → Balanced Market
- 6–8 months → Buyer's Market
- 8+ months → Strong Buyer's Market (prices softening, negotiation leverage for buyers)

---

### Absorption Rate Analysis

**Units sold per month (trailing 90-day average):** [X]  
**Current active inventory:** [X] units  
**Months of supply:** [X] months  

**What this means:** At the current pace of sales, today's active inventory would be absorbed in [X] months. [1 sentence of plain context — "That's the lowest inventory we've seen since..." or "That gives buyers more negotiating room than they've had in 18 months."]

---

### Price Tier Breakdown

| Price Range | Active | Sold (90d) | Avg DOM | SP/LP% | Market Posture |
|------------|--------|------------|---------|--------|----------------|
| Under $[X] | [X] | [X] | [X] | [X]% | [Seller's/Balanced/Buyer's] |
| $[X]–$[X] | [X] | [X] | [X] | [X]% | |
| $[X]–$[X] | [X] | [X] | [X] | [X]% | |
| Over $[X] | [X] | [X] | [X] | [X]% | |

**Key insight:** [1–2 sentences — where is the market tightest? Where do buyers have leverage? Which tier has the most activity?]

---

### 6-Month Price Trend

| Month | Median Price | $/SF | DOM | SP/LP% |
|-------|-------------|------|-----|--------|
| [M-5] | $[X] | $[X] | [X] | [X]% |
| [M-4] | $[X] | $[X] | [X] | [X]% |
| [M-3] | $[X] | $[X] | [X] | [X]% |
| [M-2] | $[X] | $[X] | [X] | [X]% |
| [M-1] | $[X] | $[X] | [X] | [X]% |
| **[Current]** | **$[X]** | **$[X]** | **[X]** | **[X]%** |

**Trajectory:** [Rising / Flat / Softening] — [1 sentence explanation of what's driving it]

---

### What This Means for Sellers

[3–4 sentences: pricing guidance, realistic DOM expectation, whether to expect multiple offers or negotiate down, any pricing risk at the current moment. Be direct — this is what Marcus uses at the listing table.]

**Seller's opportunity:** [Specific actionable point]
**Seller's risk:** [Specific risk to manage]

---

### What This Means for Buyers

[3–4 sentences: competition level, whether contingencies are being waived, negotiation leverage available, how to approach offers right now. This is what Priya uses in a buyer consultation.]

**Buyer's opportunity:** [Specific actionable point]
**Buyer's risk:** [Specific risk to manage]

---

### Data Notes & Caveats

- Data source: [MLS / County records / Estimated — PULL FROM MLS]
- Sample size: [X] closed sales (note if < 10 — small sample, interpret cautiously)
- Excluded: [Distressed sales / outliers over $Xm / new construction — if any]
- Seasonality: [Note any seasonal effects that affect interpretation]
- **Confidence level:** [High — large sample, complete data / Medium — some gaps / Low — limited data, use directionally only]