Here is the process I am trying to achieve:Tag an address in SpotioZapier saves all location data to a row in a google sheetThis triggers a data query of the property database (through zapier hopefully)The database then updates the google sheet with owner information in an usable format (through zapier hopefully)I use this list for mailers/follow upI have the first two steps fully automated and would love to be able to automate the rest.Any suggestions in property records look-ups from third parties?

@Oren K.It's relatively friendly down East ... and here in NB, I can query the registry on-line (for a small fee).  

Either way, talking to an RE attorney seems like a smart strategy.Here's another question, which I should have asked as part of my first query (and maybe should post it as a new forum entry): Can we get conventional financing with this "investment trust" and put down 20-25%?

But if you can find them, and suffer through their ancient query interfaces you can find what you want. 

But maybe I'm misunderstanding part of your query?

One responded quickly and offered to query their database and let me know what numbers they would use.

They were not responsive to the property manager’s requests for showings and when queried the tenants said they are refusing to allow showings.

I went through 3 different PMs during my time in Detroit and they all ended in disaster of one kind or another.A few comments/queries on your figures-1.

1) agentpro247 and REBO Gatweay do not have NY tax information (as per email i received from John Harcar(jharcar)   from  benutech.com> of Rebo Gatweay in response to my query) 2) I called the  County Treasurer  (number on http://www.co.sullivan.ny.us/Tabs/Departments/tabid/3390/Default.aspx) In October 2017, they published the tax delinquent list from 2016 in local papers.

Maybe these search queries could help:https://www.google.com/search?