CMBS.com's Leads application is an invaluable resource for CRE sales and mortgage brokers, as well as investors.
This web-based tool allows users to search for securitized loans which are maturing, watch listed, specially serviced, in foreclosure or REO.

From their product description:

An affordable, web-based way to find and manage leads for CRE refinancing and distressed asset purchases.

Search the entire CMBS universe for loans that fit specific criteria including property location, servicer status, property type and various financial measures.

CMBS Leads enables you to:

Search for loans that are in default or foreclosure for distressed asset purchases.
Find loans that are maturing for refinance leads.
Create different Lead Lists where you can manage different types of opportunities.
Manage and report on contact history at the loan level.
Map all of your leads.
Access your Leads anywhere you have an Internet connection.
Report on all your leads in Excel and PDF.

Here are a couple examples of their reports:

In addition to the securization details, this information rich system provides individual loan-level data such as the original loan amount, current loan amount, remaining loan term and maturity date, interest rate and type, loan status and even the names of the Master Servicer and Special Servicer.

Some property records even have the top tenant names, a rent roll summary, operating statement detail and the percentage of leases expiring in the next 0-12, 13-24, 25-36, 37-48 and 40+ months!

This system even has a simple CRM tool which allows users to create lead lists and track your communication with prospects and deal progress.

One thing to note, the system only tracks securitized collateral and not whole loans held by banks or life companies. If you are looking for leads related to these types of loans, Corelogic's Real Estate Analytics service maybe a good alternative, but is certainly more expensive.