By the Top AI Tools for Realtors editorial team
Helps agents build farming & content systems · Last updated July 2, 2026
A real estate market report is a short, recurring snapshot of what's happening with prices, inventory and demand in a specific area — the kind of monthly market update top agents mail to their sphere, post on social, and hand to sellers at the kitchen table. Done consistently, it's the highest-leverage farming tool in the business: it positions you as the local expert, keeps you top of mind between transactions, and quietly generates listings. The problem is that most guides stop at one piece of the puzzle. This one covers the entire pipeline — what to include, where to pull the data, a free template to drop it into, how to write the commentary with AI, and how to distribute it as an email, a social carousel and a video. Use the jump links to grab the free template builder or the data-source table right now.
Tip: pair the builder with the six-step process below. Pull real numbers from the data-source table, paste them in, then use the AI commentary prompt to expand the auto-generated summary into a full narrative.
What is a real estate market report?
A real estate market report is a periodic summary of key housing statistics for a defined geography — usually a city, neighborhood or zip code — presented so a normal homeowner can understand it. At its core it answers three questions: Are prices going up or down? How fast are homes selling? And is it a buyer's or a seller's market? Agents publish them as a monthly market update (also called a market snapshot or market activity report) and use them for farming, listing presentations, social content and email newsletters. Because the data is factual and genuinely useful, a market report earns attention that a "just listed" post never will — which is exactly why it captures searches like what is a market report in real estate and monthly real estate market report.
Market report vs. CMA vs. market analysis
These three get used interchangeably, but they're different tools for different jobs:
Market report — area-wide trends (median price, days on market, months of supply). Audience: your whole sphere. Job: farming and authority. Market analysis — a deeper look at the why: inventory, interest rates, employment, migration and long-term trends. Audience: investors and strategic sellers. CMA (comparative market analysis) — prices a single property against recent comparable sales. Audience: one seller. Job: win the listing at the right number.
The overlap is real: a great market report gives a seller the context, and the CMA gives them the price. If pricing individual homes is your bottleneck, see our roundup of the best CMA software — many of those platforms (Cloud CMA, RPR) also spit out area market reports, so one subscription can cover both.
Who reads it — buyers, sellers and your farm
A monthly report quietly serves three audiences at once. Sellers see proof you know their neighborhood's numbers cold — that's what converts a market update into a listing appointment. Buyers use days on market and list-to-sale ratio to set expectations before they write an offer. And your broader sphere and farm — past clients, neighbors, that guy from the gym — get a reason to keep hearing from you every 30 days without feeling "sold to." Market reports are one of the most reliable lead-generation and farming tactics precisely because they lead with value.
What to include in a market report (the key metrics)
A report is only as good as the numbers in it — and only as useful as your reader's ability to understand them. Here's the metric glossary every market report should cover, with what each one signals for buyers and sellers. Show each with a month-over-month (MoM) and year-over-year (YoY) change so the trend is obvious at a glance.
| Metric | What it means | Buyer / seller signal |
|---|---|---|
| Median sale price | The midpoint of all closed sale prices — less skewed by outliers than the average. | Rising = seller leverage; the headline number of your report. |
| Median list price | The midpoint of what sellers are asking on active listings. | Gap vs. sale price hints at negotiating room. |
| Days on market (DOM/CDOM) | How long the typical home takes to go under contract. CDOM counts cumulative time across relistings. | Low DOM = hot, seller's market; rising DOM = cooling. |
| Months of supply | How long it would take to sell all active inventory at the current pace (the absorption rate). | Under 4 = seller's; 4–6 = balanced; over 6 = buyer's. |
| List-to-sale ratio | Sale price ÷ list price. Also called the sale-to-list ratio. | Over 100% = bidding wars; under 97% = room to negotiate. |
| New / pending / closed | Counts of new listings, homes under contract, and completed sales. | Direction of the funnel — future supply and demand. |
| Price per square foot | Sale price normalized by size, for cleaner comparisons. | Best apples-to-apples trend across mixed home sizes. |
| Active inventory | Total homes currently for sale. | Context for months of supply and buyer choice. |
Median sale & list price (MoM / YoY)
Price is the headline every reader looks for first. Always report the median, not the average — one $4M sale can drag an average sideways and make your report look wrong. Pair the median sale price with its YoY change so seasonality doesn't fool anyone: a 3% dip from spring to winter is normal, while a 3% drop versus the same month last year is a real signal.
Days on market (DOM/CDOM) — and why by-zip matters
Days on market is the single most intuitive "temperature" reading in your report. National or even city-wide DOM is nearly useless to a homeowner, though — the number that matters is days on market by zip code. A metro can average 40 days while one hot zip clears in 9. Reporting DOM at the zip level is what makes a market update feel written for the reader's street, and it's a search agents actively look for, so we cover exactly where to pull it in the by-zip section below.
Months of supply / absorption rate (buyer's vs seller's market)
Months of supply (a.k.a. the absorption rate or months of inventory) is the metric that lets you say the magic words: "this is a seller's market." Divide active listings by the number of homes selling per month. Under ~4 months favors sellers, 4–6 is balanced, and over 6 tips toward buyers. Translating this one number into plain English is the highest-value sentence in any report.
List-to-sale ratio, new/closed/pending listings, $/sqft
Round out the picture with the list-to-sale (or sale-to-list) price ratio — over 100% means bidding wars — plus the counts of new, pending and closed listings to show the direction of the funnel, and price per square foot for a size-adjusted trend. You don't need all of them every month; pick five or six that tell the clearest story for your area and keep them consistent.
Types of market reports
"Market report" is really a family of formats. Match the format to the channel and audience:
Monthly newsletter / market update
The workhorse. A one-page monthly market update emailed to your database and mirrored on your blog. It's the format the free builder above is designed for, and the one that drives the most farming ROI because consistency compounds.
Neighborhood or zip-code report
A hyper-local version scoped to a single subdivision or zip. This is where the real estate market report by zip code intent lives — the tighter the geography, the more it feels personal and the more listings it produces. Run one per farm area.
One-page infographic
A visual, share-optimized layout — big numbers, up/down arrows, minimal text. Perfect for Instagram, a printed door-hanger, or a quick text to a client. The real estate market report infographic format gets the most social engagement of any variant.
Seller-facing vs buyer-facing versions
Same data, different lens. A seller-facing report leads with price appreciation and low days on market ("now's the time to list"); a buyer-facing version emphasizes new inventory and negotiating room. Keeping two headline framings ready lets you send the right one to the right list.
Step-by-step: how to create your market report
Here's the exact six-step process I teach agents. The first time takes an afternoon; after that, a monthly report is a 30–45 minute job because your template and data sources are already set.
- 1Define your market area. Pick one city, neighborhood or zip to farm. Narrow beats broad — a zip-level report reads as personal and produces cleaner numbers.
- 2Pull the data. Gather median price, DOM, months of supply, list-to-sale ratio and the new/pending/closed counts from your MLS, RPR, the Redfin Data Center or Realtor.com. See the data-source table.
- 3Drop the numbers into a template. Use the builder above, a Canva/Slides layout, or RPR's PDF so the design stays consistent month to month.
- 4Write the commentary with AI. Turn the raw stats into a "what this means for you" narrative with the ChatGPT prompt — then fact-check every number.
- 5Brand & design it. Add your headshot, logo and colors; export a clean one-page PDF and a matching infographic.
- 6Distribute it. Send it as an email newsletter, chop it into social carousels, and record a short monthly market-update video. See the repurpose kit.
Step 1 — Define your market area (city, neighborhood, or zip)
Resist the urge to report on the whole metro. A defined farm — one neighborhood, subdivision or zip code — gives you numbers that actually move month to month and a report that lands as "this is about my street." It also keeps your data-pull fast because you're filtering one MLS area, not a county.
Step 2 — Pull the data
Collect the five or six metrics from the glossary for your area and the same month last year (for YoY). Your MLS is the gold standard; RPR, the Redfin Data Center and Realtor.com Research fill in the gaps and give you the coveted zip-level figures. The full source table maps each metric to a free place to find it.
Step 3 — Drop numbers into a template
Consistency is the whole game, so use a template. Paste your figures into the builder above for an instant copy/print version, or keep a reusable Canva or Google Slides file. Whatever you pick, don't redesign it every month — the point is a recognizable, repeatable format.
Step 4 — Write the commentary with AI
Numbers without a takeaway don't get read. Feed your verified stats into the AI commentary prompt and let it draft a short buyer/seller narrative and a social caption in your voice. This is where our AI-tools angle shines — but the rule is firm: AI writes the words, you supply and verify the numbers.
Step 5 — Brand, design & the infographic
Add your headshot, brokerage logo and brand colors, then export two artifacts: a clean one-page PDF for email and a bold infographic for social. Tools like Canva make both trivial once your template exists. Consistent branding is what turns a data sheet into your market report.
Step 6 — Distribute (email, social, video)
A report nobody sees is wasted work. Send it to your database as a newsletter, repurpose it into a social carousel, and — the move almost no agent makes — record a 60-second market-update video. The repurpose kit below shows how to get all three from one report.
Free real estate market report templates
You don't need to design anything from scratch. The interactive builder above is the fastest path — type your numbers, hit copy or print, done. For a fully designed, brand-it-yourself file, here are the free real estate market report template and market update template options worth using:
Fill the fields above, copy the text or print a one-page PDF. Zero design work.
Search "real estate market update" in Canva for free, brandable infographic layouts.
Duplicate a market-report deck each month; great for team consistency.
NAR members generate a branded PDF market activity report in a few clicks.
Filled example: "June 2026 — Buckhead (30327): median sale price $612,000, up 4.2% YoY. Homes are selling in a median of 14 days at 99.5% of list. With 2.1 months of supply, it remains a strong seller's market." That four-sentence block — which the builder generates for you — is a complete, sendable monthly update.
Where to find the data — free market data sources
This is the step that stumps most agents. Below is the "Find Your Local Numbers" table: every core metric mapped to a free (or freemium) source, including which ones give you data by zip code. Your MLS is always the most accurate; the public portals are the best free fallback and the easiest to cite in a client-facing report.
| Source | Metrics covered | Free? | By zip? |
|---|---|---|---|
 RPR (Realtors Property Resource) |
Everything — price, DOM, supply, comps, branded reports | Free for NAR members | Yes |
| Your local MLS | The most accurate source for every metric in your area | Included with membership | Yes |
 Redfin Data Center |
Median price, DOM, supply, sale-to-list — downloadable | Free | Yes |
 Realtor.com Research |
Median list price, DOM, active inventory, price/sqft | Free | Yes |
 NAR Research |
National & regional existing-home sales, price trends | Free | No (metro) |
 Altos Research |
Weekly price, DOM & inventory — always-current agent feed | Paid | Yes |
 FRED (St. Louis Fed) |
Mortgage rates, macro housing & economic context | Free | No (national) |
 Zillow Research (ZHVI) |
Home value index, rent index, market heat | Free | Yes |
Days on market & prices by zip code
If you only bookmark one thing, make it a source that goes to the zip level. For free days on market by zip code and prices by zip, the Redfin Data Center and Realtor.com Research are the best public options — both let you filter to a zip and download a CSV. For the most accurate, up-to-the-week figure, your MLS or RPR wins, and Altos Research is the paid tool agents use when they want zip-level data refreshed weekly without touching the MLS. That combination is how you answer the real estate market report by zip code question with real numbers.
Use AI to write your market commentary
Raw stats are table stakes; the commentary is what makes a report feel like it came from a local expert. This is the perfect job for AI — you supply the verified numbers, and a tool like ChatGPT turns them into a warm, plain-English narrative and a matching social caption in seconds. Copy the prompt below, paste in the figures the builder generated, and you have your written market update:
You are a friendly, expert local real estate agent writing a monthly market update for your email newsletter and social media. Here are this month's verified stats for [AREA], [MONTH YEAR]: - Median sale price: $[PRICE] ([+/-]% YoY) - Median days on market: [DOM] - Months of supply: [SUPPLY] - List-to-sale ratio: [RATIO]% - Homes sold: [CLOSED] | New listings: [NEW] | Pending: [PENDING] Write: 1. A 120-150 word market summary a homeowner can understand, ending with whether it's a buyer's or seller's market and one sentence of "what this means for you." 2. A 40-word Instagram caption with 3 relevant hashtags. Keep the tone confident but not salesy. Do not invent any numbers beyond those provided.
Because this is our home turf, we've written a full playbook on prompting for listings, follow-ups and content — see ChatGPT for real estate agents. And if you want AI to also polish your listing copy, our listing description generator uses the same idea. The non-negotiable rule bears repeating: verify every figure before you publish — AI is a writer, not a data source.
Turn your report into content (repurpose it)
One report should power a month of marketing. Here's the repurpose kit — three channels from a single set of numbers, closing the loop no competitor bothers to close.
Email newsletter
Your database is your most valuable asset, and a monthly market update is the perfect reason to touch it. Drop the report into a clean email, lead with the one-line takeaway, and link to the full version on your site. Grab a ready-made layout from our real estate email templates so you can send it as a newsletter in minutes.
Social carousels & posts
The infographic version is built for social. Break the report into a 4–5 slide carousel — one big stat per slide — and post it with the AI caption from the prompt above. Scheduling and design tools in our real estate social media tools roundup let you turn your report into social posts and queue a month at once.
A monthly market-update video
The highest-performing agent content format is a short talking-head or slideshow video walking through the month's numbers — and almost nobody does it consistently. Record a 60-second update or turn your stats into a branded clip with VideoTour.ai, then post it to Reels, YouTube and your newsletter. Our real estate video editor guide covers the editing side.
Turn your market report into a video — VideoTour.ai
A monthly market-update video is the content agents skip because it feels hard. Turn your stats and listings into a branded, cinematic clip in minutes — the distribution move that makes your report impossible to ignore.
Best tools to automate market reports
Once you've built a few reports by hand, you may want software that pulls the data and generates the branded report for you. Here are the tools worth knowing — from free NAR-member platforms to automated homeowner reports. Browse more in our AI tools directory and best AI tools for realtors pillar.
| Tool ▲▼ | Best for ▲▼ | Starting price ▲▼ | Reports it builds ▲▼ |
|---|---|---|---|
| RPR |
NAR members | Free (NAR) | Market activity & neighborhood reports, CMAs |
 Cloud CMA |
Listing presentations | $35/mo | CMAs, buyer tours, market reports |
 Homebot |
Automated client reports | ~$30/mo | Automated monthly home & market digests |
| Altos Research |
Weekly zip data | ~$60/mo | Weekly market reports & live zip-level charts |
 VideoTour.ai |
Video distribution | Free trial | Turns reports & listings into branded videos |
Prices are typical 2026 entry points and change often — confirm on each vendor's site. For pricing single homes rather than areas, compare the best CMA software.
More market analysis & CRE tools worth a look
Beyond the report-builders above, these are newer or adjacent market-analysis tools we've researched but not yet fully tested hands-on. They lean toward investor-focused agents and commercial (CRE) work — rent comps, STR analysis, foot traffic and proforma modeling. Ratings reflect our desk research and published user reviews, so verify fit with a trial before committing.
Instant rent estimates, comps and market trends for any US property, plus portfolio tracking with real-time alerts.
Validate any rent price in seconds with hyperlocal comps and generate branded Pro Reports clients trust.
Analyze short-term and long-term rental investments nationwide with Airbnb data, calculators and AI-picked deals.
CRE investment analysis and marketing in minutes — DCF modeling, demographics and offering memorandums in one app.
Build a commercial real estate proforma in minutes with 100% web-based analysis and shareable client links.
Foot traffic and location intelligence that shows CRE pros how retail, office and multifamily sites really perform.
Frequently asked questions
A solid market report includes the median sale and list price, days on market (DOM), months of supply/absorption rate, list-to-sale price ratio, and the count of new, pending and closed listings — each shown with a month-over-month and year-over-year change. Add one or two sentences of plain-English commentary explaining whether it's a buyer's or seller's market.
Follow six steps: (1) define your market area, (2) pull the data from your MLS, RPR, Redfin Data Center or Realtor.com, (3) drop the numbers into a template, (4) write the commentary with an AI prompt, (5) brand and design it as a one-page PDF or infographic, and (6) distribute it by email, social and a short video. Our free builder handles steps 3–5 for you.
Start with a one-line takeaway (e.g., "Homes in 30327 are selling in 12 days — still a strong seller's market"), then explain the two or three metrics that moved most and what they mean for a buyer or seller. Keep it under 200 words. The AI commentary prompt above drafts it from your stats in seconds — just verify the numbers first.
The Redfin Data Center and Realtor.com Research both publish median days on market down to the zip-code level for free, and your local MLS or RPR gives the most accurate figure for your farm area. Altos Research offers weekly zip-level DOM and price data for agents who want an always-current paid feed. See the by-zip section.
A market report is a snapshot of area-wide trends; a full market analysis digs into the drivers (inventory, rates, demographics, employment) behind those trends; and a CMA prices one specific property against recent comparable sales. Use the report for farming, the analysis for strategy, and a CMA for listing appointments.
ChatGPT can write the commentary and social captions around your numbers extremely well, but it shouldn't invent the numbers. Pull the verified stats yourself, paste them into a prompt, and let AI turn them into a polished narrative. Always fact-check figures before publishing. See ChatGPT for real estate agents.
Monthly is the standard cadence for a farming or newsletter market update — frequent enough to keep you top of mind without overwhelming your database. Some agents also send a quarterly deep-dive and a fast weekly social post when a major stat shifts.
No. A CMA prices a single home using recent comparable sales and is used to win listings. A market report covers an entire area's trends — median price, days on market, supply — and is used for farming and content. See our best CMA software guide for the tools that build them.
Our free market-report builder on this page lets you enter your numbers and instantly copy or print a branded report. Canva and Google Slides also offer free, editable market-update templates you can reuse each month, and RPR generates a branded PDF market activity report for NAR members.
Nationally, the winter months — typically December and January — are the slowest, with fewer buyers, longer days on market and the year's softest prices. But it's local: your own market report will show whether your farm area follows that seasonal pattern, which is exactly why a monthly report is so useful.
Start sending a market report this month
A monthly market report is the rare marketing task that's both easy and genuinely high-ROI: it makes you the local authority, gives your database a reason to hear from you, and turns into listings over time. Run the pipeline once — build the report, pull real numbers from the data sources, write the commentary with AI, and distribute it across email, social and video — and every month after is a 30-minute repeat. Pair it with a broader farming plan from our real estate marketing plan template and you have a referral engine that compounds.