fantasycurse42 said:
Alpine, NJ... Tenafly and the surrounding area is almost as nice. Livingston & Montclair and that area should be up on this list too. Also Brooklyn Heights & The Upper West Side.
For warm weather I've heard San Diego is amazing, never been but I'd rather stay out of Florida. Been to Newport Beach and wouldn't mind living there.
A lot of this is dependant on your budget. San Francisco has a lot of great things, but the median home price for the entire city is over $1MM (that includes hovels in crap areas). Their school busing systems also means that if you don't hit the charter school lottery you have to be able to afford private schools. You can get by with elementary school if you buy in a nice area, but that's probably going to be renting one or two bedroom apartment unless you can afford upwards of $1.5M for a small house. Even by FBG standards that's a pretty high bar. It's a fantastic city to visit or live in sans children though.
This probably goes for a lot of the prime areas of California (although not to the same extent). I've lived in Encinitas, Dana Point, San Luis Obispo, Shell Beach, San Francisco, San Rafael, Mill Valley, Redwood City, Sacramento, and Walnut Creek. Outside of Sacramento those are all prime areas and you definitely give up a lot to live there. If money and career opportunities weren't constraints I would go back to San Luis Obispo in a heartbeat. There isn't a city in California that can beat it.