Here's an interesting site for anyone in the New York City real estate market right now. IntoTheBox.tv has lots of videos, pictures and information to help you find that dream deluxe apartment in the sky. I recently had an all-around good experience finding a new place in Manhattan, but I was lucky. I definitely would have wanted to check out this site had I known about it then.
The site seems pretty new, but has a nice design and a few cool features, like a spot to upload pics of your neighborhood for others to get a feel for the area. There is a collection of daily video casts that cover much of what you need to know when looking for a place in the city. They also have lots of links to relevant NYC real estate sites.