All Forum Posts by: Nettles Mason

I started a thread on Tarrant County TX.  You should check it out. I'd love to get your feedback or any ideas on list stacking or custom list building

Looking into how to pull and compile all public records are scrub for property ownership daily so they are straight from the source

I added vacant status and tax records to each property also.

A couple of things we have done to narrow down the eviction list (where available) is to find out how many properties they own, total tax value, and keep track of their evictions. 

If they own 100 units 10 evictions a year does not create motivation. If they own 2 units and have 10 evictions that might.

Adding all motivations to an owner is a goal of mine. If you could add tax delinquent, divorce, probate and liens it would really give a better picture of the owner and motivations. 

Data is King. I know it is possible to gather all this data from county court records in  Prince George's and all counties in Maryland

Tarrant County TX 

Santa Carla CA - not evictions but everything else mentioned

Forsyth GA

because I looked at all of them today.

I started a post about using public records to create a prospecting list  

What is your end goal? 

Are you trying to build an equity list by manually opening individual files?

The best program I found is LINQPad5. If you are like me and DON'T know SQL.  It allows access your DB with C# and writes SQL that actually works. This lets you manipulate all data inside the database for output on a website/portal 

@Jon Crosby I'm curious what tool you use also

I started a new thread on a beta project in Tarrant County TX  Im working on and would like some feedback.  It is county specific and collects all data in the county.  All owners are linked to their properties no matter what county they are in. 

I realize it is a different approach but county data seems to be the best source of data I could find. ex. grab everything and and filter.

My focus is on homeowners but all commercial and multifamily properties are collected also.

I have 4 counties built and they are all linked together.

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? 

@Andrew Briggs We collect all court records 2 times a day and store historical records

Scrub all data against property ownership.

Run vacancy status on all houses in county

Pull all delinquent taxes in county

relate all property ownership - who owns what properties and how many

Pull Corporate structure on all LLC's - Get contact name for company

...And output this file daily with our sell score. 

In short, we build every list type with data available from public information daily, combine it into one list "list stacking" and keep a history to see who has the most problems overtime. This gives us a dynamic prospect list of who is having problems.

@Andrew Briggs. Yes, we are pulling all data for Tarrant County. It wasn't easy. You have to open every court case in all eight courts... 2 times a day.  

We built a program to do it.

Melisa data has an api that you can send your address and they will append data.