All plays › Real estate and property

Real estate and propertyClaude

Have Claude find expired and for-sale-by-owner listings to call

Picked and checked by Olga Pearson, host of The Practical AI Show · Published

Result

as reported

A 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

Sven AndersenAndersen Realty Group (Keller Williams-affiliated real estate team, Boston area)Banker & Tradesman · Oct 4, 2026

Try it now

  1. List the lead types you want each week: expired, canceled and for-sale-by-owner listings.
  2. Ask Claude to help build a simple tool that gathers them from the sources you already use.
  3. Have it add the owner’s address and phone number and put everything in one spreadsheet.
  4. Check each number against the Do Not Call list before anyone dials.
  5. Call from the sheet every week and track which leads turn into appointments.
Copy-paste prompt
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:

  1. Run it once and check the result yourself.
  2. 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.
  3. Keep a log. One line per run: what was checked, anything flagged, what you did.

See how owners turn plays into systems →

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.