Generate a detailed comparative market analysis report by evaluating subject property details, comparable sales, market conditions, and value adjustments.
You are an experienced real estate analyst preparing a comparative market analysis report. I need this CMA for a property located at [PROPERTY_ADDRESS] in [CITY_STATE_ZIP]. The property is a [PROPERTY_TYPE:select:single-family home,condominium,townhouse,multi-family (2-4 units),manufactured home,vacant land] with [BEDROOMS:number:1-10] bedrooms and [BATHROOMS:number:1-8] bathrooms, totaling approximately [SQUARE_FEET:number:400-15000] square feet on a [LOT_SIZE] lot. It was built in [YEAR_BUILT:number:1900-2099] and I would describe the overall condition as [CONDITION:select:excellent,good,fair,needs work,major renovation needed]. Notable features or upgrades include [NOTABLE_FEATURES?]. The purpose of this analysis is [PURPOSE:select:pricing a new listing,making a purchase offer,refinancing,estate settlement,investment evaluation,property tax appeal]. The local market is currently trending [MARKET_TREND:select:strong seller's market,slight seller's market,balanced market,slight buyer's market,strong buyer's market] and the average days on market for similar homes in the area is approximately [DAYS_ON_MARKET?]. Please identify [COMP_COUNT:number:3-10] comparable properties that have sold within the past [TIMEFRAME:select:3 months,6 months,9 months,12 months] and are located within [RADIUS:select:0.25 miles,0.5 miles,1 mile,2 miles,5 miles] of the subject property. For each comparable, provide the sale price, sale date, square footage, bedroom and bathroom count, lot size, year built, condition at sale, and any relevant features that differ from the subject property. After listing the comparables, create an adjustment grid where you account for differences between each comp and the subject property. Adjust for square footage variance, bedroom and bathroom count, lot size, property age and condition, garage or parking differences, location quality within the neighborhood, and any unique features such as pools, views, or recent renovations. Show each adjustment as a dollar amount with a brief explanation of the reasoning behind it. Calculate the adjusted sale price for each comparable after all adjustments are applied. Synthesize the adjusted values into a recommended price range and a single most probable value for the subject property. Explain how you weighted each comparable and why certain comps received more influence in the final estimate. Summarize the key market conditions that support your conclusion, including absorption rate, inventory levels, and any pricing trends you observe. Present the full report in a structured format with a property summary at the top, followed by the comparable sales grid, the adjustment table, your value conclusion, and a brief section with recommended next steps based on my stated [PURPOSE]. Include any caveats about data limitations or factors that could shift the value estimate.
Range: 1 - 10
Range: 1 - 8
Range: 400 - 15000
Range: 1900 - 2099
Range: 3 - 10
Use this prompt anywhere
10,000+ expert prompts for ChatGPT, Claude, Gemini, and wherever you use AI.
Get Early AccessA comparative market analysis is the foundation of every sound real estate pricing decision. Whether you are listing a home, preparing a purchase offer, or appealing a tax assessment, the CMA process hinges on finding truly comparable properties and making accurate adjustments for differences in size, condition, location, and features. Without a structured approach, it is easy to cherry-pick comps that confirm a desired price rather than reflect actual market value.
This comparative market analysis template walks you through the full CMA workflow by collecting your [PROPERTY_TYPE], [SQUARE_FEET], [CONDITION], and [PURPOSE], then generating a professional report with comparable sales, an adjustment grid, and a final value conclusion. You control how many comps to include with [COMP_COUNT], the search [RADIUS], and the [TIMEFRAME] for recent sales. The output mirrors what a licensed appraiser produces, giving you a defensible pricing position backed by data.
Open the template in the Dock Editor and fill in your property details to get started. For a broader valuation that includes income and cost approaches alongside sales comparisons, try the property valuation assessment. If you need to prepare for an appraiser visit after completing your CMA, the home appraisal checklist covers every item appraisers evaluate.
Select the [PROPERTY_TYPE] and fill in [BEDROOMS], [BATHROOMS], [SQUARE_FEET], [LOT_SIZE], [YEAR_BUILT], and [CONDITION]. Add any [NOTABLE_FEATURES] such as a pool, recent kitchen renovation, or basement finish. These fields establish the baseline for finding accurate comps.
Choose the [PURPOSE] for the analysis, such as pricing a listing or making a purchase offer. Set the [MARKET_TREND] to reflect current conditions and add the approximate [DAYS_ON_MARKET] for your area. This context shapes how the AI weights the final value conclusion.
Pick a [COMP_COUNT] between 3 and 10, select a [TIMEFRAME] for how far back to look for sales, and choose a [RADIUS] from the subject property. Tighter parameters yield more precise results in dense markets, while wider settings work better in rural areas with fewer transactions.
Run the prompt in ChatGPT, Claude, Gemini, or the Dock Editor. Examine each line-item adjustment for reasonableness, check the adjusted sale prices, and evaluate the recommended price range. Refine your inputs and regenerate if the comps do not closely match your property.
Build a data-backed pricing recommendation for seller consultations. Present the adjustment grid and value range during your listing presentation to demonstrate exactly how you arrived at the suggested list price.
Evaluate whether an asking price is fair before submitting an offer. Use the CMA output to identify overpriced listings and to build a negotiation strategy grounded in recent comparable sales data.
Analyze potential acquisitions by comparing the asking price against adjusted comp values. Pair this template with the cap rate calculator to layer cash flow analysis on top of market value estimates.
Produce a structured CMA report to present at a property tax hearing. The adjustment grid documents why comparable sales support a lower assessed value than the county currently assigns.
Discover more prompts that could help with your workflow.
Generate a customized home selling checklist covering pricing strategy, property preparation, marketing, showings, negotiations, and closing tasks tailored to your property and selling approach.
Generate a customized home closing checklist covering every step from final walkthrough to signing day, tailored to your role, property type, and transaction details.
Create comprehensive sublease agreements that protect sublessors and sublessees while maintaining compliance with the original lease
10,000+ expert-curated prompts for ChatGPT, Claude, Gemini, and wherever you use AI. Our extension helps any prompt deliver better results.