Andre's place is absolutely great. There were four of us (2 couples) and we had plenty room. The flat is equipped with a brand new kitchen, modern bathroom and one very comfortable bed. Andre went the extra mile to make sure the second bed was as comfortable as the second one by getting us a mattress topper which made our stay perfect.
It takes 30-45mins to get to Manhattan depending on where your going, and the choice of the train you take is large (C, Q, B, 5, ...). A this price and this distance from Manhattan, it is by far the best deal you will get.
Also, the neighbourhood is good: supermarket nearby, plenty of bars and restaurants.
The only downside might be the noise of planes when they fly over, but after you have heared two, you just forget about them. Even in the morning, we were never waken up by them.
Thanks again Andre