Looking into hotels near the venue I found:
1) Red Roof Inn; 10 Rowe Ave. Milford, CT = $60 2.2 miles from D street
This looks like the best one; closest and cheap, near the water with presumably nice views.
2) Shoreline Hotel (203) 876-8556
3) Hojo\'s (looks nice) $60 (as of 10/23/09)
I don\'t know anything else about these hotels, but Red Roof looks pretty good. I\'d be down to split the room with some people to save money.