Oh I'm so . It's such a great place to live. Why did I leave??? Oh yes, Dh.....
As others have said, Fulford Comp is supposed to be very good - competition to get in can be steep. I have friends with kids at Huntingdon primary, which they like a lot. If it were me, I'd probably concentrate on those two areas. If I were childfree and not needing schools I might look elsewhere - I like the area around the Knavesmire, but it's probably not great for families as lots of tiny terraces.
Don't know what the housing market is like there now, but at one point if you found somewhere in Fulfords catchment you had to move fast.
Tang Hall isn't as bad as it's cracked up to be, but not somewhere I would chose if there were alternatives. Heworth is very nice and I believe the primary school is fine but moving on to a comp might be tricky. I know kids who went from there to Huntingdon comp, but that was some years ago. The other school would be Burnholme CC which as someone has said, has it's challenges, but I believe rises to them! Burnholme is OK - half way between Tang Hall and Heworth, both literally (in terms of location) and in terms of 'niceness'. Clifton is not great, and personally I find the new estates a bit souless.
I used to know some people who lived in Poppleton. They have 4 kids, so there must be some life there! Nice village and v. close to town, but doesn't have much beyond shop, pub etc.
Areas around Acomb are a real mixed bag. Some fine, some not. For some reason Tang Hall has the reputation, but personally I find some of the areas around Acomb (though not so much 'old' Acomb) quite dismal. Foxwood, for example...
I think villages south and east of York are cheaper than those to the north or certainly used to be.
You will love`it! Lots going on in town, and it may be small, but perfectly formed (if you ask me). Oh except for the traffic. Ring road is hellish (bear it in mind if the commute involves it) but for getting into town the park and rides are very good.
I'll shut up now, shall I and go and be in a corner somewhere....?