Back in September (2006) I went out to the south fishing pier off the Skyway bridge, crossing from St Pete to Bradenton FL. I wanted to get a nice night photo of the skyway and it looked like the S. fishing pier would give the best angle. For those not familiar, the fishing piers were once the bridge (it's like 10 miles long or so) but a tanker crashed into it many years ago in bad weather. It caused major damage, and some people were killed. Afterwards, they built a new bridge and left the two pieces as fishing piers, which still go out from shore a couple miles each.
While I was there, I turned around and saw the moon setting over the Gulf and took a few pictures of that as well. I don't remember for sure, think the bridge shots were probably like 4 second exposures, don't think the moon was nearly that long.