Keene on AI.AboutWork with meAI PromptsInsightsMarket ReportBook a call

Free prompt ยท Keene on AI

Turn your MLS export into local market conversations

This is the exact prompt I used in my Alamo Heights video. Drop in your MLS export, swap in your area, and you will get price bands, a condition comparison, and five conversation starters you can use at the grocery store, school pickup, or the ballfield. It works in Claude or ChatGPT.

How to use it

  1. Export your sold listings. Pull the last 12 months from your MLS and include the public and agent remarks columns. The condition comparison reads the remarks, so without them your results will be weaker.
  2. Open Claude or ChatGPT. Start a new chat and attach your export.
  3. Copy the prompt below. Fill in the two brackets with your ZIP code and your school district, neighborhood, or subdivision, then send it.

The prompt

Copy the prompt

I'm a real estate agent in [ZIP CODE]. Using the attached MLS export, focus only on homes within [SCHOOL DISTRICT, NEIGHBORHOOD, OR SUBDIVISION] that sold in the last 12 months. First, break the market into 4 to 5 price bands based on where the data naturally clusters. For each band, show the number of sales, median price, price per square foot, days on market, and sale to list price ratio.

Then read the remarks on every sold listing and sort each home as new construction, updated or remodeled, or as is and original condition, based on what the remarks actually say. Compare price per square foot, days on market, and sale to original price for each group, using homes of similar size. Flag any lot sales or teardown activity.

From that, give me 5 market insights I can bring up naturally in everyday conversations around the neighborhood, at the grocery store, school pickup, a coffee shop, or a kid's soccer game. Each one should work whether I'm talking to a neighbor thinking about selling, a family hoping to buy in, or someone who's just curious what their house is worth. For each insight, give me the data behind it, a casual one sentence way to bring it up, and a natural follow up question that keeps the conversation going.

Before you share a number

AI can misread a column or a remark. Spot check a few listings against your MLS before any figure goes into a post or a conversation.

Want more tools like this?

The Agent AI Toolkit has tested prompts and kits for listing agents, built for Claude or ChatGPT. Or book a free call and we will talk through where AI fits in your business.

Keene on AI.

AI readiness, systems and training for real estate professionals. Based in San Antonio, working with agents anywhere.

Follow along

@keeneonai@pollykeenePolly KeeneAI Strategy for Realtors
AboutWork with meAI PromptsAI Prompts for Busy LifeInsightsBook a call

Keene on AI is the personal practice of Polly Keene and is independent of her employer.

TermsPrivacyRefundsDisclaimer