Greenport, Long Island, New York.
If you're headed here, Kdunk can point you to the hot spots.

The NYT had an article yesterday on the aesthetic virtues of the mangled Hudson River piers seen here on 6.9.2002.