As the Rolling Stones famously sang, "You can't always get what you want." Hard for me to think of a neighborhood that meets all your criteria, but for convenience to downtown (and everywhere else for that matter), I would recommend the east side of Green Lake (around Tangletown on up to the north end of the lake). Seriously, it is the "center of the universe", so to speak, of Seattle. Easy to get downtown (via I-5, 99 and numerous side street options), and a quick jump onto I-5 to get north and 520 to get east. Green Lake Park itself is a great amenity for young and old (and a place you can fish in a pinch). And if you have little kids, you can't beat Woodland Park Zoo (right there in Green Lake) and the Seattle Center, which is 10-15 minutes away (Seattle Children's Theater, Children's Museum, Experience Museum, etc.). Good public schools is a bit more of a challenge, but in the last 10 years the area has attracted scads of young families - and young families bring more attention and commitment to the schools. There is a new elementary school opening on Latona in a year or two (an existing school building that is being remodeled; should be very nice), and I think Green Lake Elementary itself is moving up in quality (though don't know for sure as my kids are older - it was not very appealing when we were looking several years ago). I believe Eckstein Middle School is the middle school for that area and it is pretty well-regarded. High school is Roosevelt, which was recently remodeled and is a fantastic building; have heard from acquaintances with kids there that they're pretty happy with it. There are some high quality restaurants right in the area (Eva's, Mona's, Kisaku), scads of good good coffee shops (Zoka's, Cafe Lulu, Revolution), a couple decent watering holes (Lenny's for down and dirty, Tangletown Brewery and Latona Pub for something a little higher class), and lots of other good eating and drinking establishments not too far away (e.g., Red Mill Burgers, 74th Street Alehouse, Zeek's Pizza on the other side of the lake; and lots and lots of good options on 45th Street just to the south). Green Lake isn't the cheapest option for housing by any stretch, but it has (not surprisingly) become much more affordable in the last couple years.