FOR NEW HOMES:
If you're most important thing is schools, go with Cypress Village. At 800K, Marigold is definitely in your range. They are far away from the freeway, but they are detached condominiums. Cypress Village is walking distance to Jeffrey Trail Middle School and the future Cypress Village Elementary School. Yards are small, but still...
If you care mostly about appreciation, go with Corte Bella at Orchard Hills. Has a "premium" and high elevation with views for some. Only 1800 sf, though, with virtually no yard. It is a detached condominium. Terrazza is almost 200 sf bigger with no motor courts and is closer to the shopping center and sports park, but it is zoned to TUSD so it might not appreciate as much.
If you are patient, consider Northwood Paseo. There may be a Terrazza-like home at a $50K less price or so. It has a nice location too.
I DON'T RECOMMEND GREAT PARK NEIGHBORHOODS. They are isolated from everything, close to the active dump, and mello-roos will double every 30 years!!!