The property is spacious & as described. There is ample space & facilities to spend a night in (but why would you do that in NY?)
Bar noise is not an issue.
Location was important for us. Access to / from LGA ($27 taxi) & JFK ( $15.50 for two pers on the metro) was easy and cheap. Metro to downtown Brooklyn (for the Nets) was very easy, plus there is quick metro access to Lower & Midtown Manhattan.
By choice I'll never stay in Manhattan again.