Sheriff Auction Vs Mortgage Lender Auction

[Alexander Timberlake]

Hello,

Can someone clarify some information for me? I am a little confused on the difference between a Sheriff Auction and Mortgage lender Auction. 

My understanding is that Sheriff auctions are for tax liens on property tax and Lender Auctions are for mortgage liens the banks have on the properties. I have also been told that the County Tax offices are required to publish the list of properties with tax liens but you typically have to purchase the list of properties going into a Mortgage Lender auction? (Bonus question: what is the best way to get any of these lists in excel format?)

Some things I am confused on:

Trustee Auction (Is this the same as Mortgage Lender Auction?)

Judicial vs Non-Judicial Foreclosures (How are these related to Sheriff and Lender Auctions?)