Result
as reportedA Claude-built tool that finds expired, canceled and for-sale-by-owner listings, with addresses and phone numbers in a spreadsheet, led to $4 million in "unseen opportunities" the team leader says he didn’t have before.
Sven Andersen leads Andersen Realty Group, a Keller Williams-affiliated team in the Boston area. Finding expired, canceled and for-sale-by-owner listings by hand takes a long time, so the team hired a college student to build a tool in Claude. Connected to other tools, it uncovers the owners’ addresses and phone numbers and puts them all in a spreadsheet the team can call from. Andersen says it freed his time for talking to people and led to $4 million in "unseen opportunities." He also prepaid Claude for the year for his team, and newer agents use AI to rehearse open-house and buyer or seller conversations.
Who did it
Try it now
- List the lead types you want each week: expired, canceled and for-sale-by-owner listings.
- Ask Claude to help build a simple tool that gathers them from the sources you already use.
- Have it add the owner’s address and phone number and put everything in one spreadsheet.
- Check each number against the Do Not Call list before anyone dials.
- Call from the sheet every week and track which leads turn into appointments.
Help me build a weekly lead list for my real estate team. I want expired, canceled and for-sale-by-owner listings in [area] from [your MLS export or sources]. For each one, put the property address, owner name, phone number if available, list date, price and status in a spreadsheet. Add a column for Do Not Call status and one for call notes. Walk me through the setup step by step.
Make it run every week
A play works once. Turn it into a routine in three small steps:
- Run it once and check the result yourself.
- Give your AI a schedule. Tell it when to run this play (every week, or every month) and to message you with what it found before you act.
- Keep a log. One line per run: what was checked, anything flagged, what you did.
What to watch out for
As reported in Banker & Tradesman. The $4 million is "unseen opportunities," not closed sales. Follow Do Not Call rules and your MLS terms before you cold call anyone.
Did it work?
PageMotor keeps this site free.