Nestling in serene sought-after Northgate neighborhood w/ magnificent views truly define this executive home-A rare beauty w/ 3800 SF of living space on a massive 14,000+ SF lot! Picturesque curb appeal marked w/ wide & deep driveway, stone masonry exterior & stunning pivot door. Bright & inviting living room, high vaulted ceiling, tall glass windows, fresh carpet & an open floorplan throughout create an ideal ambiance for a modern lifestyle. Gourmet kitchen highlights an island w/ sink & breakfast bar, a spacious nook, oak cabinets, built-in subzero fridge, 6-burner gas stove & granite countertops. Retreat daily in upstairs primary suite by the fireplace & relaxing lounge, complete w/ a jetted tub & a walk-in closet. Resort-like backyard offers heated pool & hot tub, a basketball court, golf putting green & a cabana full bath. That, and a downstairs junior suite, such a perfect place to entertain guests! Top Fremont schools. Within minutes to freeway access & the Silicon Valley!