Having the experience of owning and running a coral reef aquarium (and frequenting this particular shop about once a week) - I was sad to hear it closed it's doors. Their reef display tank was always amazing. These pictures were taken from PetCo at Union Square (I also used to go there for my saltwater needs).
An awesome, and sometimes free, ferry that links Manhattan at the Financial District to Ikea in Brooklyn via Red Hook. Very great views of the city and if you end up having to pay it's redeemable for a monetary discount towards an Ikea purchase. I think of it as a treat and an investment.