Documents

IDX CMA Report

Try it

Generate comparative market analysis (CMA) and home valuation reports from IDX listing data and selected comparable properties. Use when a user wants to pick...

What it does

Use this skill to turn subject-property data and IDX comparables into a defensible CMA package with:

The skill document

IDX CMA Report

Use this skill to turn subject-property data and IDX comparables into a defensible CMA package with:

  • Structured valuation calculations
  • A written report for agent/client review
  • An interactive handoff prompt for Google Gemini Canvas / Google AI Studio

Workflow

1. Gather Data Through IDX MCP/CLI

Use the IDX MCP/CLI skill already available in the environment to pull:

  • Subject property details
  • Candidate comparable listings (closed/pending/active based on user preference)

Ask the user which comps to include when the choice is ambiguous. Keep 3 to 8 comps unless the user requests otherwise.

Normalize data to JSON using the schema in references/cma-input-schema.md.

2. Build CMA Outputs

Run:

python3 scripts/build_cma.py \
  --subject subject.json \
  --comps comps.json \
  --output-dir cma-output

The script produces:

  • cma-output/cma_report.md (summary report)
  • cma-output/cma_data.json (calculation payload)
  • cma-output/interactive_local.html (local interactive view)
  • cma-output/gemini_canvas_prompt.md (prompt for Google tools)

3. Review and Explain Adjustments

Before final delivery:

  • Show the comp set used
  • Show estimated range and central estimate
  • Explain assumptions and major adjustments in plain language
  • Flag missing/low-quality fields that weaken confidence

Use references/valuation-guidelines.md for adjustment defaults and confidence guidance.

4. Publish Interactive Version in Gemini

Use cma-output/gemini_canvas_prompt.md as the base prompt. Then:

  1. Open Google AI Studio or Gemini Canvas.
  2. Paste the generated prompt and provide cma_data.json.
  3. Ask for an interactive CMA web app with:
    • Comp table with sorting/filtering
    • Map-ready data fields (if lat/lng present)
    • Value-range visualization
    • Notes panel explaining adjustments
  4. Request hosted/shareable output if available in the chosen Google tool.

See references/gemini-canvas-publish.md for a copy-ready checklist.

Safety Rules

  • Treat outputs as broker/agent CMA support, not a licensed appraisal.
  • Surface data gaps, outliers, or stale comps before presenting a valuation.
  • Never invent listing attributes; mark missing values as unknown.
  • Keep a clear boundary between factual listing data and model assumptions.

References

  • references/cma-input-schema.md
  • references/valuation-guidelines.md
  • references/gemini-canvas-publish.md

Related skills

Fetch raw ad creative, app, ranking, and revenue data from AdMapix as structured JSON.

by fly0pants4.3k installs296 stars

Generate and edit Draw.io, Mermaid, and Excalidraw diagrams from natural language using a structured JSON spec.

by nssa.io1.0k installs47 stars

Stores durable facts in a categorized, plain-markdown vault on disk, alongside your agent's built-in memory.

by Iván559 installs18 stars

Join a video meeting as an AI bot with voice, avatar, and screenshare across four operating modes.

by johnpatternai22 installs8 stars

Find why your productivity system keeps failing, then apply the smallest fix — capacity math, bottleneck routing, durable local notes.

by Iván855 installs69 stars

More from danielfoch

Browse all skills

Send physical mail from CRM contacts using PostGrid. Use when pulling contacts from GoHighLevel (GHL) or Follow Up Boss (FUB), mapping contact/address fields...

by danielfoch25 installs

Manage realtor tasks in GoHighLevel CRM including contact search and updates, pipeline tracking, messaging, calendar slots, and workflow enrollment via API v2.

by danielfoch49 installs2 stars

Book real estate showing tours from emailed or pasted listing details, including extracting listing data, preparing outbound call jobs, coordinating a callin...

by danielfoch48 installs

Command-line tool to manage contacts, tasks, notes, deals, events, and communications via the Follow Up Boss API.

by danielfoch53 installs

Send Slybroadcast ringless voicemail campaigns from OpenClaw/LLMs using CLI or MCP, including AI voice generation (ElevenLabs or generic HTTP voice API) and...

by danielfoch51 installs

Manage Pipedrive CRM from OpenClaw using API v1, including people, organizations, deals, leads, activities, notes, pipelines, and custom endpoint actions. Us...

by danielfoch41 installs