My Most Favorite Consoles in the WORLD! at least for now!
#10 The Grove Console Table $1799.00
Room and Board

Anything with a mid-century modern twist is a good look in my book.
#9 Bulstrode Console $179.00
Wisteria

http://www.wisteria.com/Handpainted-Balustrade-Console/productinfo/W3937/
This mid-1800s French styled piece has a very garden,
but industrial feel to what is normally a delicate, feminine lined style.
#8 Durham Console Table $329.00
Ballard Designs

http://www.ballarddesigns.com/durham-console-table/furniture/consoles/194307
Simple. Rustic. And that is why I love it. Especially when teams with feminine French upholstered pieces.
#7 Printmakers Sideboard $1695.00
Restoration Hardware

I love this piece. It offers tons of storage! I have used it in a couple of my own design projects; the most recent, as a media solution. Coupled with this, the flat panel TV no longer was the focal point of the room!
#6 The Ludlow Console $1650.00
Jayson Home and Garden