I grew up in Astoria and came back for several years post 9/11. Lived and worked in the D.C. Area for several years in the 90s. The District and surrounding areas are much more expensive now and are not really conducive to family living. High rents and schools suck. For singles, the hot areas are Georgetown,
DuPont Circle, Capitol Hill and Kalorama. There has been much gentrification in northeast D.C. ( the city is laid out in quadrants), but still some rough sections. Much less crime than the old days. Like Manhattan, a really good place to live if you're wealthy. Most families live in suburban Maryland and Virginia. Public transit (Metro) is pretty good. I lived in Alexandria, in the Old Town section. Had an apartment one block from the River. Plenty of restaurants and pubs, shopping, etc. loved it; probably five time more expensive now than when I lived there. Finally, the climate is terrible, built on a swamp. May through October, unbelievable humidity!! Good luck.