How to Pull & Clean County Assessor Data for a Mailing List

Every mailable landowner you'd ever want is sitting in public county records. The catch is that a county assessment roll is 300,000+ rows of coded government data, and turning it into a clean list of the few thousand owners actually worth a postcard is a full day of decoding, filtering, and deduping. This guide walks the entire process end to end, so you can either do it yourself or understand exactly what you're paying to skip.

Step 1 — Find the authoritative source

Property records are maintained at the county level, but many states publish them in bulk. Sources fall into three buckets:

• Easy — one statewide file covering every county in a standard format, free. Florida's Department of Revenue NAL (Name-Address-Legal) roll is the classic example: one download, all 67 counties.
• Medium — each county posts its own parcel data, formats differ. Much of the country works this way; you onboard one county at a time.
• Hard / restricted — no free bulk data, or legal limits on commercial use. A few states and counties fall here.

Start at the state's Department of Revenue, comptroller, or GIS clearinghouse. Confirm the file includes owner mailing address (distinct from the parcel's location), a land-use or property-class code, and acreage — without those three, you can't filter to absentee, vacant, and acreage band.

Step 2 — Verify the fields against real data

This is the step that separates a clean list from a confidently wrong one. Published field documentation lies by omission. A column labeled LANDUSE might be an activity code, not the land-use model code you need. Documented vacant codes might not match what's actually in the delivered file. Before you write a single filter, open a real county's data and spot-check owner records against the county's public parcel lookup. Trust the delivered rows, not the data dictionary.

Step 3 — Decode the land-use codes to isolate vacant parcels

You only want dirt — vacant, unimproved parcels — not houses. Every county encodes land use differently: exact numeric codes in some states, free-text descriptions ("VACANT," "V," or blank) in others. Map each code or description to a disposition: vacant, not vacant, or unclassified. Two honesty rules matter here:

• A parcel counts as vacant only when the county's own data says so. "Probably vacant" is not good enough to mail as vacant.
• Exclude government, church, and other exempt parcels — an improvement-less state forest can look "vacant" by a naive filter but must never end up in a list.

If a county's codes are too messy to classify confidently, the right move is to set it aside, not guess.

Step 4 — Isolate absentee owners

Compare each owner's mailing address to the parcel's situs (physical) address. Mailing city or state different from the parcel's = absentee owner, the strongest direct-mail signal. Compare on normalized city and state, not raw street strings — reconstructed situs addresses and freeform mailing addresses will produce false positives if you compare them literally. If a county's address formats make the comparison unreliable (absentee shares implausibly above ~60% are the tell), omit the absentee flag rather than ship a bad one.

Step 5 — Band by acreage

Filter to the acreage range that matches your offer — most land flippers work somewhere in the 1–20 acre range and set the band so the parcels are big enough to matter and small enough that the owner hasn't easily sold them already. Acreage often lives in more than one field with different reliability; pick the county's most trustworthy source and note it.

Step 6 — Dedupe by owner

One person can own many parcels. Collapse the list to one row per owner + mailing address so you mail each person once. Skipping this wastes postage and makes your mail look like spam. Deduped counts are mailing records, not parcel counts — an important distinction when you're sizing a campaign.

Step 7 — Clean the mailing addresses

Drop rows with no owner name or no deliverable address — they're not mailable and shouldn't inflate your count. Standardize the remaining addresses so your mail house can actually deliver them.

What you're left with — and what it cost you

Start with ~300,000 raw rows; end with a few thousand absentee owners of vacant, acreage-banded parcels, deduped and mail-ready. That's the list. The work is roughly a full day per county the first time, faster once you've built the pipeline — and it has to be redone whenever the roll updates.

That day of work is exactly what a finished list sells for. The names are free; the filtering is the value. If your time is worth more than the tedium, browse ready-made lead lists that are already pulled, decoded, filtered, and deduped — or compare counties side by side to decide which market to build first. If you'd rather build it yourself, now you have the whole process.