Greenpoint, Brooklyn has changed from a sleepy Polish "hamlet" into a vibrant and trendy neighborhood, taking after its big sister Williamsburg. The neighborhood has great restaurants, bars but is also nice for families. Lots of supermarkets and cafes as well. The only drawback is that the commute can be brutal depending on where you are headed (i.e. commuting to the UES required 3 trains and sometimes a bus...) and I imagine will only get worse once the L train shuts down. If you want to live in a fun neighborhood that still has quiet pockets to live, you found it.