AUTOPROP makes it easy to identify expired and terminated listings that have not been relisted or sold, helping you build highly targeted prospecting lists.
This workflow uses Paragon Residential Comparables, Excel, and AUTOPROP's property selection tools to create a database of potential leads.
Don't have Excel? Follow our Google Sheets version of this workflow instead.
Step 1: Select a Search Area
Start by navigating to the area you would like to prospect.
Right-click on a centrally located property.
Click Property Report.
Step 2: Load Comparable Listings
To speed up the search, configure the report to load only comparable listing data.
Click Adjust Report Contents.
Deselect all data sources except Paragon Residential Comparables.
Within the Paragon Residential Comparables section:
Include the following listing statuses:
Expired
Terminated
Active
Closed
Select an appropriate:
Search radius (typically 2–10 km)
Property type
List date range
Sold date range
For example:
List Date: Last 9 months
Sold Date: Last 3 months
Click Update.
Once the search completes, the listings will be displayed on the map.
Step 4: Export the Listings
Click Export Table to CSV and save the spreadsheet to your computer.
Open the exported file in Excel.
Step 5: Identify Duplicate PIDs
The goal is to find expired or terminated listings that have not subsequently sold or been relisted.
Highlight Duplicate PIDs
Select the PID column.
Click Home → Conditional Formatting → Highlight Cell Rules → Duplicate Values.
Click OK.
Duplicate PIDs will now be highlighted.
Step 6: Enable Filtering
Select the entire spreadsheet.
Click Data → Filter.
Filter controls will appear in the column headers.
Step 7: Isolate Expired and Terminated Listings
Using the Status filter:
Deselect:
Active
Sold
Leave selected:
Expired
Terminated
You will now be viewing only expired and terminated listings.
Step 8: Remove Relisted Properties
To remove properties that appear multiple times due to relisting activity:
Select the PID column.
Click Data → Remove Duplicates.
Click Deselect All.
Select only PID.
Click OK.
This leaves a list of unique expired and terminated listings.
Step 9: Load the Properties Back into AUTOPROP
Copy the remaining PIDs from Excel.
Open AUTOPROP.
Click Manual PID Entry.
Paste the PIDs.
Click Search.
The properties will now be highlighted on the map.
Step 10: Load Additional Property Data
Open the Properties Table and click Load Data to load in any additional information you would like to analyze, such as:
Sales History
Assessment Values
Property Characteristics
Ownership Information
Lot Size
This data can help you prioritize your prospecting efforts.
Step 11: Export Your Prospecting Database
Once you've loaded the desired data:
Export the selected properties to Excel.
Save the spreadsheet as your prospecting database.
You now have a targeted list of expired and terminated listings that have not been relisted or sold.
Common Uses
This workflow can be used to:
Build prospecting lists
Generate mailing campaigns
Create cold-calling databases
Identify potential listing opportunities
Deliver branded Property Reports to prospective clients
Quick Recap
Search comparable listings.
Export results to Excel.
Filter for expired and terminated listings.
Remove duplicate PIDs.
Import the remaining PIDs into AUTOPROP.
Load additional property data.
Export your final prospecting database.
Still Need Help?
Feel free to reach out to us via our blue Live Chat button located on the bottom right hand of your screen. Support Hours are Monday-Friday 8:30am-5:00pm PST.