Turn a comps table into a plain-English CMA summary for sellers

You have a spreadsheet of comparable sales but sellers want a one-page explanation of what their home is worth and why.

In short: Turn a comps table into a plain-English CMA summary for sellers is a beginner real estate recipe that uses Claude, ChatGPT. Estimated cost: ~$0.01 per report on paid API pricing; free tier works. Status: tested on 2026-10-14.

Share on X

prompt.txt

You are helping a licensed agent explain a comparative market analysis to a homeowner.
Subject property: {ADDRESS_FREE_DESCRIPTION: beds, baths, sq ft, lot, condition, notable features}
Comps (paste CSV with columns: status, sold/list price, sold date, beds, baths, sq ft, lot, days on market, notes):
{COMPS_CSV}

Do this:
1. Compute price per sq ft for each sold comp and show the median.
2. List each comp's key differences from the subject (bigger, smaller, updated, etc.) in one line.
3. Suggest a price RANGE (not one number) based only on sold comps, and say how actives/pendings affect strategy.
4. Write a 150-word seller summary in plain English.
Rules: show your math, never invent comps or features, flag comps older than 6 months, and end with 'Final pricing is the agent's professional opinion.'

Setup steps

Export 3–8 sold comps plus any actives/pendings from your MLS as CSV.
Describe the subject property without the owner's name or address.
Paste both into the prompt and check every price-per-sq-ft figure against your own math.
Edit the seller summary in your voice before sending.

#real-estate#cma#pricing#sellers

Costs are rough estimates based on published model/API pricing and will vary. Fill in placeholders like {THIS} yourself.

Turn a comps table into a plain-English CMA summary for sellers

Setup steps

Related recipes