Hi,
Parts of the Northshore are lovely but be aware that getting over the bridge in the mornings (into the CBD) can take some time, unless traveling outside of rush hour (before 7am). I am sure that other's on here will give you some more info on times etc..
Remuera is a very popular location with access to arguably the best schools in the area and its very central, although this is generally reflected in the price of property.
As others have also said, the Eastern Bays are very nice and local to the CBD, with good transport links.
Agreed about the book ' Where to live in Auckland' as a good pointer, but take it at face value, as you will have to spend some time looking around and exploring places before it becomes 'real'!
Well, good luck on your search. There are plenty of people on here who are/have done just what you are about to do, including us!