Skip to content
×
PRO
Pro Members Get Full Access!
Get off the sidelines and take action in real estate investing with BiggerPockets Pro. Our comprehensive suite of tools and resources minimize mistakes, support informed decisions, and propel you to success.
Advanced networking features
Market and Deal Finder tools
Property analysis calculators
Landlord Command Center
$0
TODAY
$69.00/month when billed monthly.
$32.50/month when billed annually.
7 day free trial. Cancel anytime
Already a Pro Member? Sign in here

Join Over 3 Million Real Estate Investors

Create a free BiggerPockets account to comment, participate, and connect with over 3 million real estate investors.
Use your real name
By signing up, you indicate that you agree to the BiggerPockets Terms & Conditions.
The community here is like my own little personal real estate army that I can depend upon to help me through ANY problems I come across.
Wholesaling
All Forum Categories
Followed Discussions
Followed Categories
Followed People
Followed Locations
Market News & Data
General Info
Real Estate Strategies
Landlording & Rental Properties
Real Estate Professionals
Financial, Tax, & Legal
Real Estate Classifieds
Reviews & Feedback

Updated about 4 years ago, 10/04/2020

User Stats

101
Posts
44
Votes
John Mucilli
  • Investor
  • Yonkers, NY
44
Votes |
101
Posts

Scrubbing Absentee Owner List

John Mucilli
  • Investor
  • Yonkers, NY
Posted

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 !

User Stats

101
Posts
44
Votes
John Mucilli
  • Investor
  • Yonkers, NY
44
Votes |
101
Posts
John Mucilli
  • Investor
  • Yonkers, NY
Replied

bump

User Stats

264
Posts
211
Votes
Joe Gonzalez
  • Wholesaler
  • Houston, TX
211
Votes |
264
Posts
Joe Gonzalez
  • Wholesaler
  • Houston, TX
Replied

Hey John,

I would just have a virtual assistant go in and find all of these types of fields and then highlighting them for you.

This would take the tediousness of you doing that yourself and you can just focus on reviewing the highlighted rows.

CV3 Financial logo
CV3 Financial
|
Sponsored
Fix & Flip | DSCR | Construction Loans Up to 90% LTV - Up to 80% Cash Out - No Income Verification - No Seasoning Requirements

User Stats

101
Posts
44
Votes
John Mucilli
  • Investor
  • Yonkers, NY
44
Votes |
101
Posts
John Mucilli
  • Investor
  • Yonkers, NY
Replied

Thanks for the tip @Joe Gonzalez .. Do you use VA's for most of your work? What are your marketing methods?