SkipCheap

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

  1. Open the file in a spreadsheet. Find the columns for property address and owner mailing address.
  2. Clean both: trim spaces, make everything upper case, and strip punctuation. "123 Main St." and "123 MAIN ST" must match.
  3. 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.
  4. Filter for "absentee".
  5. 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

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.