For years the majestic Hotel Margaret stood on the corner of Columbia Heights and Orange Street in the Brooklyn Heights neighborhood of Brooklyn, overlooking the New York harbor with a grand view of Manhattan.