List stacking: combine lists, dedupe, then trace
Prices read · How we price
List stacking means combining several lists of distressed properties, such as tax delinquent, absentee, vacant and pre-foreclosure, and finding the properties that appear on more than one. The same property often shows up on two or three lists. Remove the repeats before you trace, or you pay for the same owner more than once.
How to stack in a spreadsheet
- Use the parcel number as the key. Addresses are spelled many ways; the parcel number (APN) is the same on every list. If a list lacks it, add it by matching the address to the county record.
- Tag each list. Add a column called Source to each file, such as "tax delinquent" or "absentee".
- Paste all lists into one sheet with the same column order.
- Count how often each parcel appears. In a new column: =COUNTIF(A:A,A2), where A holds the parcel number. A 2 or 3 means the property is on more than one list.
- Keep one row per parcel. Use Data, then Remove duplicates on the parcel column, after you copy the Source tags of the repeats into one cell. Keep the count: it is your priority score.
- Check for the same owner on many parcels. Sort by owner name. One owner with six parcels needs one trace, not six.
What deduping saves
Take 5,000 records with 20% duplicates. That is 1,000 repeats; 4,000 are unique. Here is the month's cost at the cheapest per-record service and the cheapest per-match service at 5,000 records, before and after dedupe (80% of records assumed to match):
| Billing | Cost at 5,000 | Cost at 4,000 | Saved |
|---|---|---|---|
| Per record: Best Skip Tracer | $497 | $417 | $80.00 |
| Per match: PennySkips | $80.00 | $64.00 | $16.00 |
A per-record service charges for every row, so every repeat is billed. A per-match service may bill a repeat too, if both copies match. In both cases, dedupe first. Some services say they remove duplicates themselves; check the price page, as many do not.
Which lists stack well
- Tax delinquent plus absentee. Owners who owe back taxes and live elsewhere are often tired of the property.
- Vacant plus code violation. A property that sits empty and draws fines costs its owner money every month.
- Pre-foreclosure plus high equity. The owner has room to sell for less than market and still walk away with cash.
- Long ownership plus absentee. Owners who have held for decades have the most equity and the least attachment.
Keep the Source column through the trace. When an owner picks up, you know which problem to ask about first.
Then trace the stacked list
Trace the unique list once. The parcels that sit on several lists are your best leads, so call or mail them first. Price the stacked file in the calculator, or see the 5,000-record price table.
Next: find absentee owners, per record vs per match, or the cheapest at every size.