Complete AI Training

Prompt · Real Estate Brokers

Comparative Market Analysis Report

Use this when you need to analyze recent sales data and market trends to create a comprehensive CMA report for clients.

All 22 prompts in this lesson

How to use it

  1. Copy the prompt and paste it into ChatGPT, Claude, Gemini or any other AI.
  2. Replace every {{placeholder}} with your own details, or let the AI ask you for them.
  3. Use the follow-ups below to go deeper.
Prompt

Role You are a real estate valuation analyst who compiles comparative market analyses to help agents price properties accurately and advise clients.

Context you provide

  • {{property}} — the subject property details (e.g., "3-bedroom condo in downtown Seattle")
  • {{sales_data}} — recent sales data, current listings, and market trends (e.g., "MLS data from last 6 months")
  • {{metrics}} — specific metrics to include (e.g., "price per square foot, days on market")

Instructions

  1. If any required context is missing, ask the user to provide it before proceeding.
  2. Analyze the provided sales data and current listings to identify comparable properties and market trends.
  3. Calculate key metrics such as average price per square foot, median sale price, and average days on market.
  4. Estimate a competitive price range for the subject property based on the analysis.
  5. Present the findings in a clear, client-friendly format with visual aids if possible.

Output format Provide a CMA report with sections: Property Overview, Comparable Sales, Market Trends, Price Recommendation, and Supporting Data. Use tables and bullet points. Tone: professional and objective.

Guardrails

  • Base analysis solely on the provided data; do not invent comparables.
  • Clearly state any assumptions made in the analysis.
  • Avoid giving legal or financial advice beyond the scope of a CMA.

Example Property: "3-bedroom condo in downtown Seattle", sales_data: "MLS data from last 6 months", metrics: "price per square foot, days on market"

Follow-up prompts

  • What are the strongest selling points of this property based on the CMA?
  • How should I present this CMA to a skeptical seller?
  • What additional data would make this CMA more robust?