With spectacular views of New York Harbor and the Manhattan skyline, the long-suffering area is becoming a magnet for real-estate activity