Episode Overview
Episode Title: AI Just Beat Zillow: My CMA Prompt Is Insane
Host: Tristan Ahumada
Date: October 16, 2025
Duration: ~5 minutes
Tristan Ahumada explains how his newly updated AI-powered CMA (Comparative Market Analysis) prompt now outperforms traditional tools like Zillow. He walks listeners through the detailed, systematic approach his prompt uses, the practical impact on agents’ workflows, and how to use the AI to create presentations in minutes. Tristan encourages real estate professionals to leverage AI to save time, gain an edge, and deliver standout client experiences.
Key Discussion Points and Insights
1. Introduction to the New CMA AI Prompt
-
Tristan has upgraded his CMA prompt for use with AI tools, making it easy for agents to generate robust valuation reports.
-
The prompt is over a page long and designed for customization—the more detail provided, the better the output.
"The better you input these items, the better the outputs."
— Tristan (00:39) -
The AI integrates data from Zillow and other sources, enhanced by constant tweaks over four and a half months of testing.
2. Six Essential Sections in the AI CMA Output
-
Tristan details the six major sections included in the AI-generated valuation report:
-
Two Scenario Prices:
-
Offers "as is" and "fully renovated" property values.
-
Exceptional for setting client expectations and exploring upgrade scenarios.
-
Example used: 232 via Colinas in Westlake Village.
“Section one, it gives you two scenario prices as is and fully renovated. That is if you want the fully renovated option...”
— Tristan (01:30)
-
-
Key Numbers:
-
Includes beds, baths, square footage, year built, HOA, Zillow estimate, sale-to-list ratio.
“Key numbers. What we're looking for, we're looking for bed, baths, square footage, year built, HOA... Zillow estimate, which is important because everyone goes to Zillow Search for their estimate.”
— Tristan (01:49)
-
-
Comparable Sales:
-
Pulls area sales from the last six months (customizable).
-
Organizes comps into fixer, mid-market, high-end, and premium, based on images too.
“It outlines those comparables, pulls them up for you very nice... it bases it all on the pictures that it sees as well.”
— Tristan (02:26)
-
-
Active and Pending Listings:
-
Shows matching properties currently on the market or pending.
-
Useful for understanding real-time competition.
"Number four, active and pending. Very nice. So it shows you exactly the ones that match with yours."
— Tristan (02:59)
-
-
Takeaways and Strategies:
-
Offers actionable, client-facing strategies for pricing and positioning.
“I love this one because it actually gives you the strategies that you can then talk about when you're in front of your clients...”
— Tristan (03:11)
-
-
Plain English Wrap Up:
-
A straightforward section summarizing the suggested approach, customizable to fit your voice.
“It outlines the strategy for you in plain English... this is where I think we should be.”
— Tristan (03:27)
-
-
3. Seamless Presentation Creation via Canva & ChatGPT
-
The AI can export results directly to Canva, auto-generating a presentation or outline.
-
Typically produces 7–9 slides covering property summary, pricing, comps, actives/pending, strategies, wrap-up, and agent contact info.
“Did you do me a favor and put this into a Canva presentation right out of ChatGPT?... If you just want a presentation outline, it'll also give you the outline. And I did both and I'm looking at them right now.”
— Tristan (03:41) -
Encourages delegation to admins—AI gives them a "head start", improving output speed and quality.
“If you've got an admin, even better, give it to them. They can clean it up... they can perform better actions faster for you.”
— Tristan (04:48)
4. Call to Action
-
Listeners can request the prompt from Tristan via Instagram or email.
“Just message me and I'll send this over to you and share this with somebody who you think may love it.”
— Tristan (04:58)
Notable Quotes and Memorable Moments
-
On AI’s Rapid Improvement:
“AI is just getting better and better. Now it's connected to Zillow, right? Because of the app... But you still have the data from everywhere else it can pull.”
— Tristan (00:19) -
On Client-Facing Value:
“You can tweak all of this, obviously... If we want to be here, this is what we need to do.”
— Tristan (03:19) -
On Time Savings:
“It's going to save you time and it's going to make you look a lot better.”
— Tristan (04:37)
Timestamped Important Segments
- 00:00–01:04 — Episode intro, announcing the updated CMA prompt and its evolution
- 01:05–03:39 — Detailed rundown of the six report sections
- 03:40–04:37 — Using AI to create Canva presentations; workflow tips
- 04:38–05:00 — Final advice: save time, leverage your team, and connect with Tristan for the prompt
Takeaways
- Tristan’s AI CMA prompt creates faster, more detailed, and more client-friendly reports than legacy tools like Zillow.
- Real estate professionals should use AI to save time, enhance client presentations, and delegate with confidence.
- The offer: message Tristan for the free, customizable AI prompt.
