How to find absentee owners
Prices read · How we price
An absentee owner is one whose tax-bill mailing address is not the property address. They own it but do not live there: landlords, heirs, owners who moved. You can find them for free from a county export. Tracing 1,000 of them costs $16.00 at PennySkips, the cheapest no-subscription service at that size.
Step 1: get the data
Many county appraiser or assessor offices sell or give away a bulk file of every parcel, often as CSV or a database file. Ask for the "parcel roll" or "tax roll" with owner mailing addresses. If your county does not offer one, a list tool such as an investor platform can export the same fields by area.
Step 2: compare the two addresses
- Open the file in a spreadsheet. Find the columns for property address and owner mailing address.
- Clean both: trim spaces, make everything upper case, and strip punctuation. "123 Main St." and "123 MAIN ST" must match.
- Add a column that compares the street number and street name of each. In Excel or Google Sheets: =IF(LEFT(UPPER(TRIM(B2)),15)<>LEFT(UPPER(TRIM(D2)),15),"absentee","owner"), where B is the property address and D is the mailing address.
- Filter for "absentee".
- Spot-check 20 rows by eye. Abbreviations such as "Rd" and "Road" create false hits, so fix the common ones with find and replace and run the formula again.
Step 3: narrow the list
- Out of state. Keep rows where the mailing state differs from the property state. These owners are the least likely to visit, and the most likely to consider a sale of land or a rental.
- Long ownership. Keep rows with a sale date more than 10 years back.
- Remove the obvious. Drop banks, government bodies and large companies. They do not sell through cold outreach.
- Remove homestead. If your state flags a homestead exemption, an owner who claims it lives there. A flagged row with a different mailing address is worth a second look.
Step 4: trace the list
Before you upload, remove duplicate parcels (see list stacking). Then trace. Absentee lists often have a full mailing address but no phone, which is the case a trace is for. Compare the services on pay-per-record skip tracing, or enter your count in the calculator.
You can also mail the owners directly using the mailing address from the county record, with no trace at all.
Next: list stacking, how to find a property owner's phone number, or the cheapest at 1,000 records.