We had a great time in New York and this apartment was a fantastic base to travel into the city from. If you're looking to spend time in and around Williamsburg (and you should) it is located a couple of minutes walk from the main roads so it's pretty quiet at night but not a trek to a subway or bigger size grocery store. It's only a 10-15min walk to the most popular/trendy clubs and restaurants with plenty of great stuff in between.
The subway will get you into manhatten with 15 mins and is a pretty straight shot all the way there when all the trains are running. It only took us about an hour to go from the baggage claim to the front door.
Would recommend and would book again.