IMPORTANT Question About Direct Letters - Can't Find the Answer

[Jay Wynn]

Hey guys, so I'm an aspiring investor and am about to do my first direct mail campaign. Let's say I am only interested in  properties that are within 2 miles of a Subway in 5 different counties. I now have the assessor's roll of all of the parcels in these counties in Excel. What is the best and most efficient way for me to filter out other parcels that don't meet this criteria using Google Maps, certain functions in Excel, or other online tools? I don't have a team, so I can't outsource this to someone else and I have thousands of MBs worth of data to sift through, so I really need help. Thanks in advance. 

[Pat G.]

Jay:

First get the addresses of each subway that you want to use as a starting point. Then search Google for "maps for plotting locations" or "maps for plotting several locations" and the following listing will appear - 

How to pin point multiple locations on Google maps

The 2 miles may be a guess, but you can be close enough. Compare the addresses on the tax roll and delete the rest. 

When you do it for one location write out each step on a sheet of paper so that when you are done you have step-by-step instructions that you are going to use to go over to Fiverr.com and hire somebody to do it or all the other locations. 

Hope that helps. Without GIS mapping software it is going to be labor intensive. 

Pat Gage