Matt's place is in a great location on the Williamsburg/Greenpoint border, just down the road from the G train and around a 10 minute walk to the L train which will throw you straight into Manhattan...
The apartment itself is really cool, with all the amenities you would want and a few "buy one get one free" beer tokens for his bar downstairs and a money off voucher for his tattoo parlour, which is where you'll pick up and drop off your keys from...
One word of warning - the apartment is very noisy, (its above a bar playing loud music until 4am every night, which Matt himself lays out in his description). No problem if your'e in town for a few beers and can just pass out at the end of the night, but not so good if you're sensitive to noise in any way...
In a nutshell, highly recommended!