Every guru course ends with "then mail your list," and none of them tell you what the list is. A spreadsheet of addresses? Names? Which addresses, deduped how, with what removed? I built one badly three times before I built one that worked, and the difference was treating the list as an object with a spec rather than a pile of rows.
A motivated seller list is a deduplicated set of properties, one row per parcel, whose public records show a distress signal, with the owner's mailing address and posture attached and the recently sold and owner-improving properties removed. It is the thing you mail and call from. The leads are the rows that answer.
Two neighboring pages cover the parts this one skips. Distressed property list for free is where the free sources live and picks up if you have not pulled a record yet. Signal stacking covers layering a second record type, a fire, a 311 complaint, a divorce filing, onto a parcel already on the list. The full method sits in the distressed property playbook. This page is the seven steps between a raw export and a list with your name on it, with our own numbers from seven Puget Sound markets at every cut.
1. Size the list to your outreach budget
Decide the number before you pull anything. The list has to be small enough to reach every owner on it three times, because one postcard is noise and the third one is the one that gets a call. Count the stamps or the dialer minutes you will pay for over ninety days, divide by three, and that is your list size. The cuts below get deeper or shallower to hit it.
For scale, here is the pool. Across our seven markets there are 19,145 open code cases on 14,281 properties. The tight cut described below ends at 1,522. A looser one, any open case plus an absentee owner plus no recent sale, ends at 6,201. Nobody mails 6,201 owners three times on a first budget, which is why the size comes first.
2. Pull the primary source and dedupe to parcels
Export the open cases from your city's feed. Seattle's is an open dataset; cities without a feed answer a request under Washington's Public Records Act, and code violation lead list has the wording. The same steps work with a tax-delinquent roll, notices of default, or a vacant property list as the primary source; code cases are my pick because they refresh daily.
Then collapse the file to one row per property. This is the step people skip, and it is why their lists are wrong. A case is an event. A property with six cases shows up six times in a raw export and should show up once on your list with a count of six. Dedupe on the parcel number where you have it, because "1234 Main St" and "1234 MAIN ST UNIT A" are the same lot to the county and two rows to a spreadsheet. Our 19,145 open cases collapse to 14,281 properties.
3. Keep the repeat properties
Sort by case count and draw a line. In our data, 2,826 properties carry two or more open cases, 972 carry three or more, and 238 carry five or more. Two is the line I use for a first list. One open case is a bad month. Two open cases at once is an owner who has stopped answering the city, and among open-case properties where we know the owner's posture, the absentee share climbs from 53.9% at one case to 68.0% at two, 79.8% at three or four, and 83.4% at five or more. That is co-occurrence, and it is why cuts three and four agree.
4. Attach the owner and flag posture
Join each parcel to the assessor roll. King County's parcel viewer does it one address at a time, the Pierce County Assessor-Treasurer has its own search, and bulk property owner data covers pulling the whole roll so you can join it in one pass. Read two fields off the record: the owner name and the mailing address.
Then compare the mailing address to the situs address and write down one of four values: owner-occupied, absentee, PO Box, or unknown. That flag is the strongest single filter on the list. Of our 2,826 repeat properties, 2,283 had a readable posture, and 1,653 of those (72.4%) were absentee or PO Box. If the owner is an LLC, how to find an LLC property owner is the extra lookup. How to find absentee owners across a whole county, with no distress signal first, is a different job and a worse one, because the plain absentee roll is a landlord list.
5. Apply the drop rules
Three rules, applied in order, each removing rows that would waste a stamp.
- Sold in the last twelve months. A recent buyer is not selling. 754 of the 14,281 open-case properties (5.3%) had a sale in the prior year; on the repeat-and-absentee list, the rule takes 1,653 down to 1,522.
- Owner-occupied with a single case. Someone living in their own house with one open weeds ticket is a neighbor, and that row belongs to the loose list, if anywhere.
- Construction-only. A property whose only open cases are construction or permit-scope is an owner spending money. Construction is the largest typed category in our file, 4,507 open cases, and it points the wrong way. Which violation types signal a motivated seller has the full sort.
The list after step five is the spec below, one row per parcel, sorted by signal count and then by newest signal date.
| Field | What goes in it | Where it comes from | Why it is on the list |
|---|---|---|---|
| Situs address | The property's street address, normalized | The case record | The join key to everything else |
| Parcel / APN | The county parcel number | Assessor | The true dedupe key; addresses have variants, parcels do not |
| Owner name | As it appears on the roll | Assessor | The name on the envelope; LLCs need a second lookup |
| Mailing address | Where the tax bill goes | Assessor | Where the letter goes |
| Posture flag | Owner-occupied, absentee, PO Box, or unknown | Mailing versus situs | The strongest single filter |
| Signal count | Open cases on the parcel | Case record, deduped | The sort order |
| Newest signal date | Open date of the most recent case | Case record | Freshness; a 2019 case still marked open is a data artifact |
| Last sale date | Most recent recorded sale | Recorder or assessor sales file | Drives the recent-sale drop rule |
| Phone | Traced numbers, added last | Skip trace | Outreach, once the list is final |
| Status / notes | Mailed, called, answered, dead | You | So no owner gets the same letter twice |
Source for all counts: FlaggedLeads data, 7 Puget Sound markets (Seattle, Tacoma, Bellevue, Burien, Shoreline, Mountlake Terrace, unincorporated Pierce County), 2026-09-04.
6. Skip trace the survivors
Trace last, because you pay per row. In our own tracing, 691 lookups returned an owner match 653 times (94.5%) and a phone number 646 times (93.5%), at $0.10 per hit and $65.30 in total. Traced at step two, the same job would have cost the whole raw file. Real estate skip tracing covers the vendors and the match logic, and skip trace by address is the version for a list with no owner names yet. Before the first call, scrub the numbers against the National Do Not Call Registry and read the TCPA, which puts the liability for an unwanted call on the caller.
7. Set a refresh cadence
The pool moves faster than a static list can. In the 30 days before this was written, 2,173 new cases opened on 1,779 properties in our seven markets; over 90 days, 6,961 cases on 5,322 properties; over the full year, 20,168 cases on 14,090 properties. And of those 14,090, 10,047 (71.3%) had never had a case before. A list built in September is missing most of what will be on it by March.
Re-pull the source monthly at minimum, re-run steps two through five, and diff against the previous version. New rows are the freshest leads you own. Rows that fell off, because the case closed or the property sold, get marked dead in the status column so nobody mails them again. Newest signal date is the field that makes the diff cheap, and the loop is why a list stacking spreadsheet gets unwieldy by the third refresh. If you would rather have the loop run for you, FlaggedLeads does steps two through five nightly for the seven markets we cover, and the free map shows the raw cases without an account.
Why the list is never finished
The first mailing is a test of the drop rules. Every response, every "already sold," every "I live here" is a row that tells you which cut was wrong, and the fix goes into the rules rather than into the notes. The list you mail in October is the September list plus 1,779 properties' worth of new cases, minus the rows that answered, with rules that are one round smarter. That is the object. Sorting the types of motivated sellers behind each row comes after the list exists, and the next page, where wholesale leads come from, ranks the sources you add to it.
Frequently asked questions
What is the best way to find motivated sellers?
Start from a public record that says an owner has stopped keeping up, then confirm it against ownership. An open code enforcement case with a second case behind it and a mailing address somewhere else is the strongest cheap combination I know of, and it is the one this list is built on. If you have not chosen between buying leads and building them, motivated seller leads: buy or build is the decision page.
How do I get a list of motivated sellers for free?
Pull the records yourself. City code enforcement feeds, the county treasurer's delinquent-tax roll, and the recorder's notices of default are free or close to it, and the assessor roll supplies the owner and mailing address. The seven steps above turn that into a list; your cost is the hours and about $0.10 per skip-trace hit at the end.
Is there a motivated seller list template?
The field table on this page is the template: ten columns, one row per parcel. Build it in whatever spreadsheet you already use. The columns that matter most are the parcel number, because it is the only reliable dedupe key, and the posture flag, because it is the strongest filter. Everything else is bookkeeping so the same owner never gets the same letter twice.