Piero's place fit perfectly what my boyfriend and I were looking for for our trip! It so happened to be right around the corner from the friend we were visiting - but the location is recommendable in it's own right. It's much more peaceful than Manhattan and still has some fun things to do close by. (for example eating at the Mexican restaurant Fajita Sunrise, recommended by Piero!, Benny's Cuban Cafe or at the charming authentic Glendale diner). It's also a 10 minute walk away from multiple Subway stops that take you straight into Manhattan (Fresh Pond Rd, Forrest Av, Halsey St).
Piero was a very friendly host, always open for a chat and generously offered us some drinks :)