Waterfront has been getting buzz for being a promising new Warner Brothers series, however, even critics have yet to see the pilot. With 13 episodes ordered, very little is known or said about this series, except for some promotion pieces that Rhode Island has released, in their bid to entice more movies and television shows to the area.
The Rhode Island Film and TV Office released this press release, although it is sketchy on details and definitely more promo on RI. It does have some studio-released promo shots though. Here is one for the Baldwin fans:

Monty Brinton/CBS ©2006 CBS Broadcasting Inc.
Fortunately for wannabe fans, the Providence Journal got an inside look:
Actors Joe Pantoliano and William Baldwin must have been naughty.
If not, why were they moping in undersized chairs outside the principal’s office of the Henry Barnard School?
Turns out Pantoliano and Baldwin are among the cast and crew of the new TV series Waterfront, which was filming scenes yesterday at the school, on the campus of Rhode Island College.
Waterfront stars Pantoliano as Jimmy Centrella, the flamboyant mayor of Providence; Baldwin plays Paul Brennan, the state’s ambitious attorney general. The show was picked up by CBS as a midseason replacement and should air early next year.
There is no known airdate yet… in fact, CBS hasn’t even created a page for the series yet on CBS.com. So best we can tell, it will be sometime in early 2007.