Plugin/Widget Name: Query Posts
Description:
This widget gives average users the ability to show off their posts in any way they'd like. Nearly 40 options are available to show posts from the widget controls. The widget can also be used an unlimited number of times.
License: GPL
Release/Download Page:
http://justintadlock.com/archives/2009/03/15/query-posts-widget-wordpress-plugin