Let me offer two suggestions to help with finding out about property in or about to be in foreclosure.
One source is Realtytrac.com, which has a nationwide search capability for such properties.
If you are interested in Connecticut, I would use Judicial Branch - jud.ct.gov. When you click on that site, a list of more refined searches appears on right side of the next page. Click on Foreclosure Sales, and you can see what is available in various Connecticut town and cities.
If I can help with any other information, please let me know.
Prudential Connecticut Realty