Listing Marketing

AI CMA Narrative Template for Real Estate Agents

RW
Ryan Wanner

AI Systems Instructor • Real Estate Technologist

Quick Answer: This template turns raw CMA data into a persuasive pricing narrative that sellers understand and trust. Fill in your comps, market context, and price recommendation to generate a professional CMA narrative in your voice.

A CMA spreadsheet shows the data. A CMA narrative explains what the data means and why your price recommendation is right. This template turns your comparable sales analysis into a written narrative that sellers understand, trust, and act on—without you spending 45 minutes writing it from scratch.

The Template

You are a [ROLE: e.g., listing pricing strategist / experienced listing agent / market analyst] in [MARKET: e.g., Williamson County, TN / Scottsdale, AZ / Raleigh-Durham]. Write a [FORMAT: e.g., CMA narrative for a listing presentation / pricing strategy summary / written price justification for the seller] for [PROPERTY ADDRESS]. Subject Property: - Address: [ADDRESS] - Property Type: [TYPE] - Beds/Baths: [BEDS/BATHS] - Square Footage: [SQFT] - Lot Size: [LOT SIZE] - Year Built: [YEAR] - Condition: [CONDITION: e.g., fully updated / original but well-maintained / needs cosmetic updates] - Key Advantages: [ADVANTAGES: e.g., corner lot, no HOA, renovated kitchen] - Key Disadvantages: [DISADVANTAGES: e.g., smaller lot, no garage, backs to road] Comparable Sales (Closed): - Comp 1: [ADDRESS], sold [PRICE], [DATE], [BEDS/BATHS], [SQFT], [KEY DIFFERENCES from subject] - Comp 2: [ADDRESS], sold [PRICE], [DATE], [BEDS/BATHS], [SQFT], [KEY DIFFERENCES from subject] - Comp 3: [ADDRESS], sold [PRICE], [DATE], [BEDS/BATHS], [SQFT], [KEY DIFFERENCES from subject] Active Competition: - Active 1: [ADDRESS], listed [PRICE], [DOM], [KEY DIFFERENCES] - Active 2: [ADDRESS], listed [PRICE], [DOM], [KEY DIFFERENCES] Market Context: - Average DOM in this price range: [DOM] - Months of supply: [SUPPLY] - Price trend: [TREND: e.g., up 3% YoY, flat, declining slightly] - Rate environment: [RATES] My Price Recommendation: [RECOMMENDED PRICE] Pricing Rationale: [WHY: e.g., 'positions us $10K below Active 1 which has a 3-car garage advantage, and $15K above Comp 2 which had a smaller lot'] Seller Situation: [CONTEXT: e.g., needs to sell quickly / flexible timeline / emotionally attached to a high price / inherited property] Tone: [TONE: e.g., confident and data-backed / empathetic but honest / analytical] Length: [LENGTH: e.g., 400 words / 1 page / 3 paragraphs with data table] Do NOT use: [EXCLUSIONS: e.g., 'in my opinion,' 'I think,' 'aggressive pricing,' 'we'll see what happens']

Placeholders to Fill In

[ROLE]

Your credibility positioning

e.g., listing pricing strategist with 200+ CMAs delivered

[MARKET]

Geographic market

e.g., Williamson County, TN

[ADDRESS]

Subject property address

e.g., 322 Thornton Drive, Franklin TN 37064

[BEDS/BATHS]

Bedroom/bathroom count

e.g., 4BR/3BA

[SQFT]

Square footage

e.g., 3,100 sq ft

[CONDITION]

Property condition assessment

e.g., kitchen updated 2023, bathrooms original, good overall maintenance

[ADVANTAGES]

What makes the property worth more

e.g., cul-de-sac lot, screened porch, Williamson County schools

[DISADVANTAGES]

What might limit value

e.g., smaller lot at 0.25 acre, no third garage bay, original bathrooms

[COMP SALES]

3 closed comparable sales with details

e.g., 318 Thornton, $725K, 12/2025, same plan, larger lot, updated baths

[ACTIVE COMPETITION]

Current competing listings

e.g., 410 Maple, $739K, 8 DOM, 3-car garage, similar condition

[MARKET CONTEXT]

Broader market conditions

e.g., 16 days average DOM, 2.3 months supply, 3.8% YoY appreciation

[RECOMMENDED PRICE]

Your pricing recommendation

e.g., $729,000

[PRICING RATIONALE]

Why this specific number

e.g., undercuts Active 1 by $10K, supported by Comp 1 and 2, accounts for bathroom disadvantage

[SELLER SITUATION]

Seller's motivation and constraints

e.g., relocating, needs to close by July, realistic about market but hopeful for top dollar

[EXCLUSIONS]

Weak language to avoid

e.g., in my opinion, I think, aggressive pricing, let's try it and see

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

Define the Hero

HOME Framework - H (Hero)

Position yourself as a pricing strategist, not just someone pulling comps. The hero role affects whether AI writes 'here are some comparable sales' or 'here's why the data supports $729,000.' The latter wins listings.

2

Set the Outcome

HOME Framework - O (Outcome)

Decide the format: a full narrative for a listing presentation, a one-page summary, or a brief justification letter. Each requires different depth. A listing presentation narrative needs storytelling; a summary needs data bullets.

3

Load the Materials

HOME Framework - M (Materials)

This step requires the most work: enter 3 comps with specific differences, 2 active competitors, market context, and your subject property details. The quality of your CMA narrative is 100% dependent on the quality of data you provide. Include advantages AND disadvantages—sellers trust agents who acknowledge both.

4

Execute with Constraints

HOME Framework - E (Execute)

Ban weak language like 'I think' and 'in my opinion.' A CMA narrative should present data-backed conclusions, not opinions. Also set the tone to match the seller's situation—a seller who's emotionally attached to price needs empathy with data, not just data.

5

OODA Verify

OODA Loop

Double-check every comp address, price, and date. Verify the math on per-square-foot calculations and percentage adjustments. Then read the narrative as the seller: does it make the price recommendation feel inevitable based on the data? If the data clearly supports the price, the narrative should make saying 'yes' easy.

Before & After

Filled Example

Template with Your Details

You are a listing pricing strategist with 200+ CMAs delivered, working in Williamson County, TN.

Write a CMA narrative for a listing presentation for 322 Thornton Drive, Franklin TN.

Subject Property:
- Address: 322 Thornton Drive, Franklin TN 37064
- Property Type: Single-family
- Beds/Baths: 4BR/3BA
- Square Footage: 3,100 sq ft
- Lot Size: 0.25 acres
- Year Built: 2020
- Condition: Kitchen updated 2024 (quartz counters, new appliances), bathrooms original, overall well-maintained
- Key Advantages: Cul-de-sac lot, screened porch, Williamson County schools, 20 min commute to Nashville
- Key Disadvantages: Smaller lot (0.25 acre vs 0.35-0.5 for neighbors), 2-car garage (some comps have 3), original bathrooms

Comparable Sales:
- Comp 1: 318 Thornton Dr, sold $725,000, Dec 2025, 4BR/3BA, 3,100 sqft, 0.35 acre, bathrooms updated, no screened porch
- Comp 2: 209 Garrison Lane, sold $780,000, Nov 2025, 4BR/3.5BA, 3,400 sqft, 0.5 acre, 3-car garage, fully updated
- Comp 3: 102 Cedar Bluff Ct, sold $695,000, Jan 2026, 4BR/2.5BA, 2,900 sqft, 0.3 acre, original kitchen, no porch

Active Competition:
- Active 1: 410 Maple Court, listed $739,000, 12 DOM, 4BR/3BA, 3,200 sqft, 0.4 acre, 3-car garage
- Active 2: 225 Lockwood Dr, listed $699,000, 22 DOM, 4BR/2.5BA, 3,000 sqft, 0.3 acre, needs updates

Market Context:
- Average DOM for $700K-$800K in Williamson County: 18 days
- Months of supply: 2.3
- Price trend: Up 3.8% YoY
- Rate environment: 6.3% 30-year fixed, down from 6.8% in Oct

My Price Recommendation: $729,000
Pricing Rationale: Positions $10K below 410 Maple (accounts for their 3-car garage and larger lot), $4K above 318 Thornton (justified by kitchen update and screened porch), and well above 102 Cedar Bluff (our updates and screened porch warrant the premium)

Seller Situation: Relocating for work, needs to close by July, realistic about market but hoping for strongest possible price

Tone: Confident, data-backed, zero hedging
Length: 400 words
Do NOT use: 'in my opinion,' 'I think,' 'aggressive,' 'we'll see,' 'test the market'

AI-Generated Result

Pricing Analysis: 322 Thornton Drive, Franklin TN 37064 Recommended List Price: $729,000 The Data Three comparable sales bracket the value range for 322 Thornton. 318 Thornton Drive closed at $725,000 in December 2025. Same street, same floor plan, same square footage—but 318 has a larger lot (0.35 vs 0.25 acres) and updated bathrooms. It did not have a screened porch or an updated kitchen. The kitchen and screened porch at 322 offset the lot size and bathroom differences, positioning 322 at a slight premium to this comp. 209 Garrison Lane closed at $780,000 in November 2025. This is the ceiling comp: 300 more square feet, a half-acre lot, a 3-car garage, and full updates throughout. 322 Thornton does not compete with this property at the same price point—it's the reference for where the market tops out in this subdivision. 102 Cedar Bluff Court closed at $695,000 in January 2026. This is the floor: fewer bathrooms, smaller square footage, no kitchen updates, and no screened porch. The $34,000 premium for 322 Thornton over this comp is supported by the kitchen renovation, additional half-bath, and screened porch. The Competition 410 Maple Court is listed at $739,000 with a 3-car garage and 0.4-acre lot. It's been on market 12 days. Pricing 322 Thornton at $729,000 positions it $10,000 below this direct competitor, which accounts for the 3-car garage advantage while keeping the price consistent with the comparable sales data. 225 Lockwood Drive is listed at $699,000 and has been on market 22 days—it needs updates and is priced accordingly. It's not direct competition; it's evidence that buyers in this range are willing to pay more for move-in condition. The Recommendation $729,000 is supported by the closed data, competitive against active inventory, and positions 322 Thornton to sell within the current 18-day average for this price range. The 2024 kitchen renovation and screened porch justify the premium over the floor comps. The lot size and 2-car garage are the adjustments that keep it below the ceiling. With your July closing target, pricing accurately from day one captures the strongest buyer interest. The market in this price range is rewarding well-priced, move-in-ready homes and punishing overpriced ones—18 days on market for the former, 40+ days for the latter. This price gets you to the closing table on your timeline.

Template Variations

Alternative versions for different use cases.

One-Page Executive Summary

Brief version for sellers who want the bottom line

You are a [ROLE] in [MARKET]. Write a one-page CMA summary for [ADDRESS]. Subject: [KEY DETAILS]. Top 3 comps: [COMP 1 one-liner], [COMP 2 one-liner], [COMP 3 one-liner]. Active competition: [ACTIVE 1 one-liner]. Recommended price: [PRICE]. Why: [2-SENTENCE RATIONALE]. Format: Property details in a bullet list, comp summary in a mini table, 3-sentence narrative conclusion. Under 200 words total.

Price Reduction Justification

When the original price hasn't worked and you need to support a reduction

You are a [ROLE] in [MARKET]. Write a price reduction analysis for [ADDRESS], currently listed at [CURRENT PRICE] for [DOM] days. Original pricing rationale: [WHY WE PRICED HERE]. What's changed: [NEW COMPS, NEW COMPETITION, FEEDBACK]. New data: [UPDATED COMPS AND MARKET CONDITIONS]. Recommended new price: [NEW PRICE]. Expected result: [WHAT THIS PRICE SHOULD ACCOMPLISH]. Tone: Data-driven, forward-looking. This is strategy, not failure. Do NOT use: 'we overpriced it,' apology language.

Buyer Offer Strategy Narrative

Using CMA data to justify an offer price for a buyer client

You are a [ROLE] in [MARKET]. Write an offer strategy analysis for [BUYER NAME] considering [PROPERTY ADDRESS] listed at [LIST PRICE]. Comps supporting a lower offer: [COMPS]. Comps supporting list price: [COMPS]. Market conditions: [CONTEXT]. Seller motivation (if known): [INTEL]. Recommended offer: [OFFER PRICE]. Strategy: [APPROACH: e.g., clean offer with quick close, or escalation clause to $X]. Tone: Advisory, helping the buyer understand the negotiation range. Length: 250 words.

Frequently Asked Questions

Can AI really write a CMA narrative I'd present to a seller?
AI writes the narrative; YOU provide every data point. The template ensures you give AI accurate comps, market data, and your pricing rationale. AI then structures it into a professional narrative that explains the data clearly. The result reads better than most agents' CMA presentations because it follows a logical data-to-conclusion structure every time.
How do I handle a seller who wants to price higher than the data supports?
Use the CMA narrative as your evidence. When the data clearly shows $729K and the seller wants $775K, a well-written narrative makes the gap visible without you having to argue. Point to specific comps: 'The most expensive comparable on your street—with a larger lot and 3-car garage—sold for $780K. To price above $775K, we'd need to justify a premium that the upgrades don't support.' Let the data make the argument.
Should I include comps that DON'T support my price recommendation?
Yes—and explain why they're different. If a nearby home sold for $850K, the seller will find it. Better for you to address it in the narrative ('sold at $850K due to 500 additional square feet and a pool—features your property doesn't have') than to have the seller bring it up and wonder why you skipped it. Addressing unfavorable comps proactively builds trust.

Learn the Frameworks

Related Articles

Related Templates

More templates to accelerate your real estate business.

Or start with free AI insights for real estate: