I'm thinking about buying a property through an auction and want to uncover any/all leins on the property.

There is a strong Spanish speaking wholesale market that does a good job uncovering deals.

My only two tax cal sources are Zillow and Trulia, which are flawed.

I would endorse individual applications and credit/ background checks on each applicant as well as social media searches that may uncover information that is not formally listed in a criminal background check.  

Fortunately my due dilligence uncovered numerous red flags which are all discussed on this thread.

@Aristotle Kumpis thanks specifically for showing the flaw in my original logic on considering the $454 payment cashflow.

Thanks I’ve got to disagree with the start by cold calling advise.Yes, a “deal” can be uncovered by cold calling.  

The same risks that come with any rehab are true with rehabbing your own house: you uncover something major and don't have the money to fix it. 

-Real Estate Agents accept only a certain, higher down payment of X%; where X is subject to the experience and success of the Agent, therefore offers that fit this criteria are accepted.If I understood correctly, then my initial logic of a high amount of cash offers driving purchase prices up through competition and causing a Bay Area Bubble Burst is flawed due to the ability of buyers to not go into "Strategic Default" through a higher down payment or even an all cash offer.

Most problems will trace back to a flaw in the tenant screening.