The Quest for Dynamic Data For Prospecting In Real-Time
I follow a lot of post on this forum about gathering information on motivated sellers and using it for prospecting. The big sites are mentioned (List Source, Zillow, Attom Data API) for sourcing house data. It seems OP starts out with good ideas and then a couple years pass and nothing more is mentioned. So, I decided to start my own thread.
The most common response for prospecting list "why not just buy a list and mail to them... or buy 2 list and stack them and then phone/mail." My problem with that is list lose value, houses sell, vacants aren't vacant, people pay delinquent taxes, landlords replace tenants, ect.
I want data that is evergreen: when the house sells the new owners mailing address is updated, Somehow gather all "list" combined, stacked, updated and output daily. That way you don't need to source new list.
I started a beta project in Tarrant County TX to see how much of my quest could be completed.
Step 1 Collect every Parcel ID in the county.
Step 2 Standardize every address and owner name
Step 3 Crack LLC's to find rep/owner/manager
Step 4 Create relationships between owners and properties (how many properties they own)
Step 5 Gather Delinquent Tax roll filter and apply to owner
Step 6 Run Vacancy status on every valid parcel address
Step 7 Collect all "pain causing" court cases daily and scrub for owners address
Step 8 House all court records that match owners.
Step 9 Create a SellScore that displays current and historical court cases
Step 10 Make filters for all data to be sorted in cloud and downloaded if needed
Step 11 Data append phone,email and daily update of owners that have court cases
I think this covers the most common list.
- Vacant
- Absentee
- Tax Delinquent
- Liens
- Eviction
- Divorce
- Probate
The end result will output 2 csv files daily
ownername,owneraddress,propertyaddress,caseType,TotalProperties,#Vacants,TotalTaxDel,SellScore,DivorceY/N,ProbateY/N,#Evictions,phone1,phone2,phone3,email
2nd file- Just phone formated for RVM or Text upload
What other information would you add to create your perfect prospecting?