Case 04 · Real Estate / PropTech

RentCast Property Data & AVM Deal-Memo Assistant

PropTech Integration & Applied-AI Engineersrentcast.ioAI & AutomationData & IntegrationProduct Engineering
← All case studies

RentCast is a property-data API with 140M+ US records, ML-driven AVM valuation, and rental comps (REST/JSON, X-Api-Key auth). We built an internal AI assistant on top of it that turns an address into an instant, sourced deal memo.

The challenge

A small-multifamily private-equity shop wanted instant rent and valuation comps from inside Slack. Analysts were hand-pulling county records and stitching together spreadsheets, so every deal screen took hours and key comps were missed.

  • Wrapping RentCast's REST API with reliable geocoding so a raw address resolved to the right parcel every time.
  • Combining AVM value, rent estimates, and nearby comps into a confidence-rated memo an analyst could trust.
  • Staying inside the API quota under bursty Slack usage without dropping requests.
Our solution

We built an integration layer on the RentCast API: a Slack slash command geocodes an address, calls the AVM and comps endpoints, feeds the JSON into Claude with a deal-memo prompt, and pushes the result to Notion — with responses cached in Postgres to manage quota.

  • A Slack slash command that authenticates via X-Api-Key and calls GET /v1/avm/rent and /avm/value with property type and bedroom params.
  • A Claude-powered deal-memo generator that turns AVM JSON plus nearby comps into a structured memo with confidence intervals, written straight to Notion.
  • A Postgres response cache keyed by address to absorb repeat lookups and stay within RentCast's call quota.

A customized view of the system we shipped for this engagement — the components and how requests and data flow between them.

addresscompsmemo💬Slack SlashCommand⚙️Node IntegrationSvc📍Geocoder🏘️RentCast AVM API🧠Claude Deal Memo🗄️Postgres QuotaCache📝Notion Export
Node.jsTypeScriptRentCast REST APIClaude APISlack APINotion APIPostgreSQLRedis
Turned multi-hour deal screens into a Slack command returning a sourced memo in seconds.
Pulled rent, value, and comps from 140M+ records on demand, with confidence intervals attached.
Held API usage inside quota under bursty load via address-keyed Postgres caching.
Direct value addedLets a lean investment team screen far more deals per week with consistent, sourced valuation — without standing up its own data pipeline.
Why it mattersRentCast ships an llms.txt and ML-driven AVMs, so it's natively built for AI agents. Layering an LLM on top of clean property data is exactly where a focused integration delivers outsized leverage.

Before — manual bottleneck flow

1County Record HuntBottleneck
Analyst · 2 hours

Analyst pulls tax and parcel data from disparate county portals one address at a time.

2Comp Spreadsheet BuildBottleneck
Analyst · 1 hour

Comps are copy-pasted into a spreadsheet and rated by hand, missing nearby sales.

3Memo DraftingBottleneck
Associate · 1 hour

A deal memo is written manually, delaying the go/no-go decision.

After — automated optimized flow

1Slash-Command Lookup
Slack Bot · 1 sec

Analyst issues /comps with an address; it geocodes and calls the RentCast API.

2AVM + Comps Pull
RentCast API · < 300 ms

Value, rent estimate, and nearby comps return as structured JSON with confidence data.

3AI Memo to Notion
Claude Node · 4 secs

Claude drafts a sourced deal memo with intervals and writes it directly to Notion.

Portrait of Tom Delaney
It's not magic — the call on a deal is still ours — but getting rent and value comps with a sourced memo straight in Slack means we actually look at a lot more properties before we commit capital.
Tom Delaney at Icon

Have a problem like this?

Tell us your goal and we'll turn it into a structured plan — from idea to stable, scalable reality.

Contact us