AI Prompts for Real Estate Market Analysis & CMAs

Overview

CMAs and market analyses are essential—but translating MLS numbers into something a buyer or seller actually understands takes time. These prompts help you do that in minutes. Each prompt is designed to accept raw data you paste in and return a polished, client-ready narrative.

Prompt 1: CMA Narrative Summary

Use this to convert your CMA data into a natural language explanation you can paste into a presentation or email.

Example Output:

Based on three comparable sales in Maplewood Estates over the past 90 days, the market is pointing to a listing price in the $415,000 to $430,000 range for your home. The closest comp at 742 Birch Lane—similar in size at 1,850 square feet with three bedrooms and two baths—sold for $422,000 after just 11 days on market. A slightly larger home on Oak Drive closed at $435,000, but that one had a fully renovated kitchen, which yours doesn't. On the other end, 118 Elm Court sold for $410,000 and sat for 28 days, likely because it backed up to the main road. Your home's updated bathrooms and quiet cul-de-sac location are real advantages. Pricing at $425,000 positions you competitively—close enough to attract serious buyers without leaving money on the table.

Why it works: Giving the AI a role ("you are a real estate agent") and a format constraint ("150 words, plain language") produces consistent, usable output.

Prompt 2: Neighborhood Market Snapshot

Perfect for a monthly market update email to your sphere.

Example Output:

The Westside Heights market continues to favor sellers heading into spring, though the pace has cooled slightly from last year's frenzy. The median sale price now sits at $389,000—up 4.2% year over year—while homes are taking an average of 18 days to go under contract. With just 1.8 months of inventory on the books, demand still outpaces supply, and sellers are capturing 98.5% of their asking price at closing. That said, overpriced listings are sitting longer than they did six months ago, which tells us buyers are being more selective even in a tight market.

For sellers, this is still an excellent window to list—especially if your home is move-in ready and priced within the current comp range. For buyers, competition remains real, but you are less likely to face five-offer bidding wars than you were a year ago.

If you are thinking about making a move, the smartest step right now is to get a current home valuation so you are working with real numbers, not assumptions.

Prompt 3: Buyer Market Conditions Explainer

When a buyer asks "is now a good time to buy?", give them a real answer.

Example Output:

Right now in Cedar Park, the housing market is steady but not runaway-hot like it was a couple of years ago. Mortgage rates are sitting around 6.8%, which means a $350,000 home at 10% down would cost roughly $2,050 per month in principal and interest—real money, but rates have actually dipped slightly since last fall. There are about 2.4 months of inventory on the market, so it is still competitive, though you will have a bit more breathing room to tour homes and make thoughtful decisions than buyers did in 2022. Prices have ticked up about 3% over the past six months, so waiting does not appear to save you money—if anything, buying now locks in today's price before spring inventory pushes more competition into the mix.

Prompt 4: Price Reduction Justification

When a seller needs to hear the price isn't working, let the data do the talking.

Example Output:

I know this is not the conversation anyone wants to have, and I want you to know I am on your side here. The market is giving us honest feedback, and I think it is worth looking at together. We have been listed at $475,000 for 34 days now. In that time we have had 12 showings, which tells us buyers are interested in your home—but the two offers that came in were both under $450,000, and neither stuck. That gap between interest and action usually means one thing: price.

When I look at what has actually closed nearby in the last 60 days, the numbers paint a clear picture. The Donovan home on Ridgewood, very similar to yours at 2,100 square feet with four bedrooms, sold for $452,000. The Petersons' place on Lakeview, which had a newer roof and updated HVAC, closed at $461,000. Both were priced right from the start and went under contract in under two weeks.

My recommendation is to adjust to $455,000. That puts us right in line with where buyers are actually writing checks, and it should generate a new wave of showings from people who filtered your home out at the current price. The goal is to create urgency, not chase the market down over the next few months.

Prompt 5: Appraisal Gap Explanation

Help buyers understand what an appraisal gap is without overwhelming them.

Example Output:

When you offer more than the asking price, the bank still sends out an appraiser to confirm the home is worth what you are agreeing to pay—and if the appraiser says it is worth less than your offer, that difference is called the appraisal gap. For example, if you offer $340,000 but the home appraises at $325,000, there is a $15,000 gap that the lender will not cover in your loan. An appraisal gap clause is a line in your offer that says you are willing to cover some or all of that difference out of pocket—so the seller knows your deal will not fall apart over it, which makes your offer much stronger in a competitive situation.

Tips for Best Results

Related Resources