On the border of Brooklyn & Queens Richard's place is worth trying, either for a short or a long stay. I would suggest not to be a "free rider" but to actually try to learn from a very interesting New Yorker.
Recommended stay for music lovers and unbiased urban explorers.
With the L line you are quickly in Manhattan, while Bushwick is within walking distance.