Have a Claude-built tool pull expired, canceled and for-sale-by-owner listings into a call spreadsheet
Sven Andersen, team leader of Andersen Group Realty, a Keller Williams-affiliated team in Winchester, Massachusetts, in Banker & Tradesman
The team hired a college student to build a tool in Anthropic's Claude that finds expired listings, for-sale-by-owner listings and canceled listings. Connected to other tools (the article doesn't name them), it looks up the owners' addresses and phone numbers and puts everything into a spreadsheet, so the agents can call each owner and ask whether there's a new opportunity. Andersen prepaid a year of Claude for his team, which has three "super users."
Claude $17/mo billed annually ($20 monthly). The lookups behind the addresses and phone numbers come from tools the article doesn't name.
Medium · or we set it up for $197
Claude
The problem
Finding owners of expired, canceled and for-sale-by-owner listings and tracking down their addresses and phone numbers could be done by hand, but it took so long that the team rarely got to it.
What happened
Andersen says the tool led to $4 million in "unseen opportunities" the team didn't have before; the article doesn't say how much of that closed. "I could do it manually, but it would take so much longer," he says. "With the [AI] tool, it streamlined the business approach so that I could actually focus my attention, time and energy on what matters most, which is talking to people."
Quoted in the source: Sven Andersen, team leader, Andersen Group Realty. Source: Banker & Tradesman: Teams, Indie Brokerages Get Ahead with AI (Sam Lattof) (2026-10-04) · Added 2026-10-21.
How to set it up yourself
- What Andersen Group Realty does: a Claude-based tool built by a college student finds expired, canceled and for-sale-by-owner listings, looks up each owner's address and phone number through other connected tools, and puts it all into a spreadsheet the agents call from.
- Export the expired, withdrawn/canceled and FSBO listings for your farm area from your MLS or the FSBO sites you use (address, list price, days on market, date it came off) into one CSV.
- Upload the CSV to a Claude project with the prompt below to clean it, flag duplicates and relists, and rank the rows; add owner contact details only from a data source you're licensed to use, never guessed by the AI.
- Before anyone calls, check each number against the national and your state's Do Not Call lists and your brokerage's rules for calling expireds, then log every call outcome in the sheet.
Copy-paste prompt
Here is a CSV of {MARKET} listings that expired, were canceled or are for sale by owner: {CSV}. Clean it into one table with address, status, last list price, days on market and the date it came off the market. Flag duplicates and any home that has since relisted with another agent (mark [RELISTED]). Rank the rest by how recently they came off the market and how close the price was to recent sales in {NEIGHBORHOOD}. Don't invent owner names or phone numbers; leave those columns blank for me to fill from {DATA SOURCE}.We set up one AI automation in your tools, live within 48 hours of getting access, for $197. No call needed. Founding price for our first 10 customers (regular $297).
One short email a day: 3 new AI use cases from real small businesses, each with its source and setup steps, plus a Tool of the Day. Free, no spam, unsubscribe anytime.
Tools used
Claude
AI assistant for writing, long documents, analysis and coding help.
From $17/mo billed annually ($20 monthly) (checked 2026-10-21)
Visit site →Some tool links may be affiliate links. Disclosure
Checked prices: Claude: from $17/mo billed annually ($20 monthly) (verified 2026-10-21)
Rather not do it yourself?
The $197 Quick-Win: we set up one AI automation that saves you hours each week, in accounts you own, live within 48 hours of getting access. No call needed. Refund if it isn't live in 48 hours or isn't doing its job in the first 14 days. Founding price for our first 10 customers (regular $297). Terms.
See the $197 Quick-WinNeed more than one automation or ongoing care? Bigger setups: $149/mo with setup included (6-month minimum), or $497 pay-once. Satisfaction guarantee: we'll fix it until it works. Pay-once setups: or we refund your setup fee. $149/mo plan: cancel in the first 30 days and we refund your first month. We reply within 1 business day.
Related for Real estate
Draft a month of real estate social posts with ChatGPT and repurpose the winners
Each evening ChatGPT drafted 20 to 30 short Threads posts, which he scheduled; the best performers became Canva quote cards, then 30 to 6…
ChatGPT
Canva AI (Magic Studio)TThreadsWrite listing descriptions with ChatGPT and keep the agent's voice
The broker uses the free ChatGPT to draft property listings and other mundane writing, then edits for accuracy and SEO.
ChatGPTUse ChatGPT for listing copy, client follow-ups and market reports
ChatGPT drafts listing descriptions, personalised follow-ups using past conversations with each client, and neighbourhood market reports …
ChatGPTCanva AI (Magic Studio)Running something like this in your business? Submit your use case and we'll credit you with a link.
Get 3 new AI use cases every morning
One email every morning: 3 new AI use cases from real small businesses, each linked to its source, plus a Tool of the Day. Free. No spam, unsubscribe anytime. Privacy
Rather have one set up for you? The $197 Quick-Win.