Write a CMA with AI without giving it your MLS login: you search and export the comparables, Claude reads the folder, builds the adjustment table, asks you for each adjustment, then writes the CMA: AI agent prompt

Many agents want AI help with comparative market analyses but don't want an AI agent logging into the MLS. On Oct 28, 2026 David Ursino, a managing broker who teaches AI to Canadian real estate agents, posted a demo of a CMA where the AI never touches the MLS: he does the search and export himself, Claude Code reads the exported folder, builds the adjustment table, asks him for his adjustments, and then writes the CMA. The prompt below follows the same split, so the judgement calls on value stay with you.

SalesComparative market analysisintermediate

The prompt

Help me write a comparative market analysis (CMA) from comparables I've already exported myself. You won't log into the MLS or look anything up; use only the files I give you. Subject property: [address, property type, beds, baths, square footage, lot size, year built, condition, key features]. Comparables: [attach or paste the MLS export of sold, active and expired comparables]. 1) Read the files and list each comparable in a table with sale or list price, date, distance from the subject, size, beds/baths, lot, age, condition and notable features. Mark any comparable that looks like a poor match and say why. 2) Build an adjustment table showing each difference from the subject property (size, bedrooms, bathrooms, garage, lot, condition, updates, location). Leave every adjustment amount blank and ask me for my figure for each type of difference before you calculate anything. 3) Once I give you my adjustments, work out each adjusted price, show the math, and suggest a price range with one plain sentence on how you got there. 4) Write a short CMA summary for the seller in plain English: the market right now, the three most relevant comparables, the suggested range, and what could move the price up or down. Never invent a comparable or a figure; if something is missing from the export, write 'not in the data'.
Open in ChatGPT Open in Claude Perplexity Download as agent skill (SKILL.md)

Fill in the blanks, then copy

This prompt has 1 [bracket] to fill in. Type your details below and the prompt updates as you go. Your answers stay in this browser and are reused on other prompts with the same blanks. Nothing is sent to us.

How to use it

  1. Copy the prompt above.
  2. Replace every [bracket] with your own details (use the fill-in-the-blanks box above, which remembers your answers for the next prompt).
  3. Paste it into Claude Code, Claude, ChatGPT and review the answer before you use it.

Works with: Claude Code, Claude, ChatGPT, your MLS export, Google Sheets, Excel

Real-world example: x.com/david_ursino/status/2115383137249198177

Featured in: AI prompts for Google Sheets and Excel work · ChatGPT prompts for real estate agents: listing descriptions, leads, showings and closing

Before you use it: what to check

Already built into this prompt

Check yourself

Using an AI agent? Download this prompt as a SKILL.md agent skill with these checks built in, or get the .zip for Claude.ai. How to install skills.

Share:Post on XLinkedInFacebookRedditWhatsApp
</> Embed this prompt on your site

Paste this HTML into your blog or website. It's a plain card with no tracking scripts that links back to this prompt.

Want to make this prompt even better? Grade it with the free prompt grader or build your own with the AI prompt generator.

Get the free Solo Founder Stack pack

32 copy-paste agent prompts (PDF) plus 5 new prompts every week.

Get it free

More Sales prompts

Lead qualifierLead qualification · beginnerAccount research briefProspect research · beginnerCall notes to follow-up emailFollow-up · beginner · worked exampleDuplicate contact finderCRM hygiene · intermediateLead enrichment + draft replyLead enrichment · intermediateStale quote chaserQuote follow-up · beginner · worked example

See all Sales prompts →

Related prompts from other teams

Automation script for a boring taskCoding · beginnerReceipt photos to bookkeeping entriesFinance · beginner · worked exampleWeekly staff schedule from your sales forecastOperations · beginner · worked exampleAutomate purchase-order accruals for closeFinance · advanced