AI CMA Narrative Report Template for Real Estate

The Template

You are a [ROLE] specializing in [MARKET_AREA] with deep knowledge of neighborhood-level pricing trends. Generate a CMA narrative report for a listing presentation. The report should explain the pricing recommendation in clear, non-technical language that a homeowner can follow. Subject Property: - Address: [SUBJECT_ADDRESS] - Beds/Baths: [SUBJECT_BEDS_BATHS] - Square Footage: [SUBJECT_SQFT] - Year Built/Renovated: [SUBJECT_YEAR] - Lot Size: [SUBJECT_LOT] - Key Upgrades: [SUBJECT_UPGRADES] - Condition: [SUBJECT_CONDITION] - Unique Features: [SUBJECT_UNIQUE] Comparable Sale 1: - Address: [COMP_1_ADDRESS] - Sale Price: [COMP_1_PRICE] - Sold Date: [COMP_1_DATE] - Beds/Baths/Sqft: [COMP_1_DETAILS] - Adjustments: [COMP_1_ADJUSTMENTS] Comparable Sale 2: - Address: [COMP_2_ADDRESS] - Sale Price: [COMP_2_PRICE] - Sold Date: [COMP_2_DATE] - Beds/Baths/Sqft: [COMP_2_DETAILS] - Adjustments: [COMP_2_ADJUSTMENTS] Comparable Sale 3: - Address: [COMP_3_ADDRESS] - Sale Price: [COMP_3_PRICE] - Sold Date: [COMP_3_DATE] - Beds/Baths/Sqft: [COMP_3_DETAILS] - Adjustments: [COMP_3_ADJUSTMENTS] Market Context: - Current market trend: [MARKET_TREND] - Average DOM in area: [AVG_DOM] - Inventory level: [INVENTORY] - Interest rate impact: [RATE_IMPACT] Additional Adjustment Notes: [ADJUSTMENT_NOTES] Client Name: [CLIENT_NAME] Recommended List Price: [PRICE_RECOMMENDATION] Pricing Strategy: [PRICING_STRATEGY] Report Format: 1. Executive Summary (2-3 sentences with the recommendation) 2. Market Overview (current conditions in plain English) 3. Comparable Sales Analysis (each comp with why it's relevant and adjustments explained) 4. Price Recommendation (the number and the reasoning) 5. Pricing Strategy (recommended approach and expected timeline) Tone: Authoritative but conversational. Use data to build confidence, not to overwhelm. Write like you're explaining this to the homeowner at their kitchen table.

Placeholders to Fill In

[ROLE]

AI persona with local expertise

e.g., senior residential appraiser and listing strategist

[MARKET_AREA]

Your geographic market

e.g., Williamson County, Tennessee

[SUBJECT_ADDRESS]

The property being priced

e.g., 892 Elm Creek Drive, Franklin TN 37067

[COMP_1 through COMP_3]

Three comparable sales with address, price, date, details, and adjustments

e.g., 445 Oak Valley Rd, sold $615K on 12/15/25, 4BR/3BA 2,800sqft, +$15K adjustment for smaller lot

[MARKET_TREND]

Current market direction and velocity

e.g., Appreciating 3-4% annually, slight inventory increase but still under 3 months supply

[ADJUSTMENT_NOTES]

Any special adjustments or considerations

e.g., Subject has pool (+$25K value) but backs to commercial property (-$15K). Updated kitchen in 2024 (+$20K vs comp 2)

[CLIENT_NAME]

Seller's name for personalization

e.g., Michael and Sarah

[PRICE_RECOMMENDATION]

Your recommended list price

e.g., $649,000

[PRICING_STRATEGY]

Your approach to pricing and timeline

e.g., Price at market value to attract multiple offers within 14-21 days

5 Essentials + HOME Framework

How to Use This Template

Follow these steps to get the best results. Each step maps to proven frameworks taught in AI Acceleration.

1

Gather Your Comps and Adjustments

HOME Framework - M (Materials)

Pull 3 comparable sales from the MLS. Choose comps that are truly comparable—same neighborhood or similar, similar size, sold within the last 90 days if possible. Calculate your adjustments before you give them to AI. AI can explain adjustments clearly, but you need to determine the dollar amounts based on your market knowledge and appraisal principles.

2

Set the Market Context

HOME Framework - M (Materials)

AI needs the macro picture to frame the micro analysis. Is inventory rising or falling? Are homes selling above or below list? What's the average DOM? This context transforms a list of comps into a market story. Without it, the CMA narrative floats in a vacuum and the seller can't anchor the recommendation to anything real.

3

Define Your Pricing Strategy

5 Essentials - Essential 2: Context Engineering

Your price recommendation is a number. Your pricing strategy is the reasoning. Are you recommending market value to attract multiple offers? Slightly below to create urgency? At the top of the range to test the market first? Tell AI your strategy and it will frame the recommendation accordingly. The strategy section is what separates a CMA from a number on a napkin.

4

Generate and Personalize the Report

HOME Framework - E (Execute)

Run the template and review the narrative. Verify every number. AI doesn't double-check math. Add personal touches: reference the seller's kitchen renovation you noticed during the walkthrough. Mention the neighbor's home that sold last month. Include a detail that shows you know THIS home, not just the comps. That's what makes the report feel like a custom analysis instead of a generic printout.

5

OODA Review Before the Presentation

OODA Loop - Full Cycle

Before you present: Observe—read the full report as if you're the seller hearing it for the first time. Orient—does the recommendation feel justified by the evidence? Decide—is there anything the seller might challenge that needs stronger support? Act—edit accordingly. Pay special attention to the adjustment explanations. Sellers always ask 'why is that comp relevant to MY home?' Make sure the report answers that for each comp.

Before & After

Filled Example

Template with Your Details

You are a senior residential analyst and listing strategist specializing in Williamson County, Tennessee.

Subject Property:
- Address: 892 Elm Creek Drive, Franklin TN 37067
- Beds/Baths: 4BR/3BA
- Square Footage: 2,950 sqft
- Year Built: 2018, kitchen renovated 2024
- Lot Size: 0.38 acres
- Key Upgrades: Full kitchen remodel (2024), new HVAC (2025), hardwood throughout main level
- Condition: Excellent
- Unique Features: Screened porch with ceiling fan, fenced backyard, cul-de-sac lot

Comparable Sale 1:
- 445 Oak Valley Road, Franklin TN 37067 (same subdivision)
- Sale Price: $615,000
- Sold Date: December 15, 2025
- 4BR/2.5BA, 2,680 sqft, built 2017
- Adjustments: +$25K for 270 sqft smaller, -$5K for newer build. Net: +$20K. Adjusted: $635,000

Comparable Sale 2:
- 1203 Meadow Glen Lane, Franklin TN 37067 (adjacent subdivision)
- Sale Price: $658,000
- Sold Date: January 8, 2026
- 4BR/3BA, 3,100 sqft, built 2019
- Adjustments: -$12K for 150 sqft larger, +$20K for subject's 2024 kitchen renovation. Net: +$8K. Adjusted: $666,000

Comparable Sale 3:
- 78 River Birch Court, Franklin TN 37067 (0.5 miles away)
- Sale Price: $642,000
- Sold Date: January 22, 2026
- 4BR/3BA, 2,900 sqft, built 2020
- Adjustments: +$5K for 50 sqft smaller, -$10K for newer construction, +$15K for subject's screened porch. Net: +$10K. Adjusted: $652,000

Market Context:
- Williamson County market trend: Appreciating 4.2% annually, 2.6 months inventory
- Average DOM: 28 days
- Homes priced within 3% of market value: 22-day average DOM
- Overpriced listings (5%+ above comps): 58-day average DOM
- Current mortgage rate: 6.4% (30-yr fixed)

Adjustment Notes: Subject's 2024 kitchen renovation is a significant differentiator—none of the comps have a recently updated kitchen. Cul-de-sac lot adds perceived value for families. Screened porch is uncommon in this price range.

Client Name: Michael and Sarah
Recommended List Price: $649,000
Pricing Strategy: Price at market value to attract strong offers within 21 days. Position just below the adjusted comp 2 to capture buyers searching under $650K.

AI-Generated Result

CMA NARRATIVE REPORT — 892 Elm Creek Drive, Franklin TN Prepared for Michael and Sarah 1. EXECUTIVE SUMMARY Based on three recent comparable sales in and around your subdivision, your home at 892 Elm Creek Drive supports a list price of $649,000. This positions you competitively in Williamson County's current seller-favorable market while capturing buyers searching under the $650,000 threshold. At this price, I expect strong showing activity within the first two weeks and a contract within 21 days. 2. MARKET OVERVIEW Williamson County is appreciating at 4.2% annually with 2.6 months of inventory—still a seller's market by any measure. Homes priced within 3% of their true market value are selling in 22 days on average. Homes priced more than 5% above are sitting for 58 days. That's not a typo. Overpricing by just two percentage points more than doubles your time on market. Mortgage rates at 6.4% haven't slowed demand in Franklin—buyers have adjusted their budgets and they're buying. What rates HAVE done is make buyers less tolerant of overpriced homes. They know exactly what they can afford, and they skip listings that don't match the comps. 3. COMPARABLE SALES ANALYSIS Comp 1: 445 Oak Valley Road — $615,000 (December 2025) This is your most direct comparison. Same subdivision, similar layout, sold 8 weeks ago. It's slightly smaller at 2,680 sqft with one fewer bathroom. After adjusting up $25K for the size difference and down $5K because it's a year newer, the adjusted value is $635,000. Your home has two advantages 445 Oak Valley didn't: the 2024 kitchen renovation and the screened porch. Both add meaningful value above this baseline. Comp 2: 1203 Meadow Glen Lane — $658,000 (January 2026) This home is 150 sqft larger at 3,100 sqft and sold for $658K in the adjacent subdivision. After adjusting down $12K for the size difference and up $20K for your kitchen renovation (Meadow Glen had the original 2019 kitchen), the adjusted value is $666,000. This comp establishes the ceiling of your range. Your home could approach this price but at 2,950 sqft it's a stretch to match it without the extra square footage. Comp 3: 78 River Birch Court — $642,000 (January 2026) The most recent sale at just 3 weeks old. Nearly identical in size at 2,900 sqft, same bedroom and bathroom count. It's two years newer but doesn't have your screened porch or updated kitchen. After adjustments, the value comes to $652,000. This is the closest apples-to-apples comparison and strongly supports the $649K recommendation. 4. PRICE RECOMMENDATION: $649,000 The adjusted comps range from $635,000 to $666,000. Your home's 2024 kitchen renovation, screened porch, and cul-de-sac lot position it in the upper half of that range. I'm recommending $649,000 for a specific reason beyond the comps: it captures every buyer searching 'under $650K' in Franklin. That search filter is one of the most common in our MLS and puts your home in front of the maximum number of qualified buyers. 5. PRICING STRATEGY List at $649,000 with professional photography and marketing live by Thursday. Based on current absorption rates, I expect 8-12 showings in the first weekend and an offer within 14-21 days. If we receive multiple offers, we evaluate based on terms, not just price—closing timeline and inspection contingencies matter as much as the number. If we don't receive an offer within 21 days, we reassess. But at $649K with the current market velocity, that scenario is unlikely. Michael and Sarah, your home is in excellent condition, in a high-demand subdivision, at a price the comps clearly support. The market is ready for this listing.

Template Variations

Alternative versions for different use cases.

Luxury CMA Narrative ($1M+)

Elevated language and additional considerations for luxury properties

You are a luxury market analyst in [MARKET_AREA]. Generate a CMA narrative for a [PRICE]+ property. Include: comparable sales analysis with lifestyle positioning, days-on-market analysis for the luxury segment specifically, buyer pool size estimate, and marketing investment recommendation. Tone: sophisticated, confident, data-anchored. Property: [SUBJECT DETAILS]. Comps: [COMP DETAILS].

Investment Property CMA

CMA focused on cap rates, rental income, and investor metrics

You are a real estate investment analyst in [MARKET_AREA]. Generate a CMA narrative for an investor client considering [SUBJECT ADDRESS]. Include: comparable sales, cap rate analysis, current rental income vs market rents, cash-on-cash return estimate, and appreciation forecast. Client goal: [INVESTMENT_GOAL]. Comps: [COMP DETAILS].

Competitive CMA (Multiple Agent Situation)

When the seller is interviewing multiple agents and needs a differentiating presentation

You are a [ROLE] in [MARKET_AREA]. This seller is interviewing 3 agents. Generate a CMA narrative that differentiates through: (1) more granular comp analysis than competitors will provide, (2) a clear pricing strategy with timeline expectations, (3) specific marketing plan tied to the pricing. Demonstrate analytical depth that shows expertise, not just access to MLS data. Property: [SUBJECT DETAILS]. Comps: [COMP DETAILS].

Frequently Asked Questions

Can AI actually do a reliable CMA?

AI doesn't replace your CMA analysis. It changes how you present it. You still pull the comps, determine the adjustments, and decide the price. AI turns your data into a narrative sellers can follow and trust. Most CMAs fail not because the data is wrong but because the presentation doesn't connect. A spreadsheet with three comps tells the seller what to list at. A narrative report tells them why. That's what gets the signature.

What if the seller disagrees with the AI-generated narrative?

The narrative is YOUR recommendation presented through AI. Not AI's opinion. If a seller pushes back on price, the conversation is the same as it would be without AI: you explain the comps, discuss the adjustments, walk through the market context. The narrative just means your explanation is better organized and easier for the seller to reference after you leave. Seller wants to list higher? Show them the DOM penalty for overpricing. It's in the report.

Should I show the seller that I used AI to generate the report?

That's a personal branding decision. Some agents present the AI-generated narrative as-is and position themselves as tech-forward. Others use the AI output as a draft and reformat it into their branded presentation. Either way, the value is in the analysis, not the tool that formatted it. No seller has ever chosen a less-competent agent because that agent wrote the CMA by hand. They choose the agent whose analysis is most convincing and whose pricing recommendation is most trustworthy.

How do I verify the AI output before presenting to a seller?

Three checks. First, verify every number—AI can transpose digits or miscalculate adjustments. Read each comp's adjusted price and confirm the math. Second, verify the narrative doesn't contradict your recommendation. If you're recommending $649K but the narrative makes a stronger case for $670K, the seller will notice the disconnect. Third, read it as if you're the seller. Does the recommendation feel earned by the end of the report? If not, the evidence section needs strengthening. This is the OODA Loop: Observe the output, Orient against accuracy, Decide what to fix, Act.

Learn the Frameworks

HOME Framework Context Cards OODA Loop for AI

Related Templates

More templates to accelerate your real estate business.

Listing Marketing

AI CMA Narrative Report Template for Real Estate Agents