Scrubbing Absentee Owner List

[John Mucilli]

Hey everyone, quick question that I haven't been able to easily search and find the answer for.

When pulling an absentee owner list, especially in my area, I run into a lot of houses that have two addresses (usually due to being a double lot). For example, "100 Main Street" may have a mailing address of "102 Main Street" and not be vacant or distressed at all.

What techniques do you use to scrub a list like this? Keep in mind I use Propstream. Would I just have to visually scan it and delete the ones that are obviously no good, prior to running a campaign or export it to Excel, run some script that takes care of this and import it back in?

Thanks !