Refine Search
Map
Sort by
$4,410,000
7 Beds ⋅ 6 Baths ⋅ 41143157 MLS
Nestled on a quiet court in Fremont's prestigious Weibel neighborhood, this exceptional custom estate is situated on nearly one-half acre across two parcels, where a tranquil creek flows gently through the rear portion of the park-like grounds, creating a serene natural setting. Offering 5,540 square feet of refined living space with seven bedrooms and six beautifully appointed bathrooms, the residence has been thoughtfully refreshed, blending timeless architecture with sophisticated modern upgrades. A dramatic foyer opens to expansive living spaces with soaring ceilings, abundant natural light, fresh interior and exterior paint, designer lighting, and luxury wide plank flooring throughout the main level. A striking curved staircase creates an elegant impression, while a secondary staircase provides access from the main living areas. Designed for grand-scale entertaining and comfortable everyday living, the floor plan offers elegant formal living and dining rooms, a spacious family room with a beautifully appointed wet bar, and an expansive upstairs bonus room, providing exceptional flexibility for entertaining, recreation, and multi-generational living. At the heart of the home is a recently remodeled gourmet kitchen featuring an oversized center island with quartz countertops, premium stainless steel appliances including a brand-new Thermador refrigerator, ample prep and gathering space, and an open layout overlooking the family room. The luxurious primary suite features a remodeled spa-inspired bathroom with a freestanding soaking tub, oversized walk-in shower, dual-sink vanity, porcelain tile flooring, and designer finishes. Updated secondary bathrooms, new carpet upstairs, a new roof, and improvements create a truly move-in-ready experience. Step outside to your private resort where freshly landscaped, park-like grounds surround a sparkling pool, expansive patios, lush lawns, mature trees, stately palm trees, and new low-voltage landscape lighting enhancing both front and rear yards, with rear access to Sage Court. Owned solar further enhances the home's energy efficiency. Ideally located near award-winning Weibel Elementary and other highly rated schools, neighborhood parks, shopping, BART, and major tech companies, this exceptional residence presents a rare opportunity to own one of Weibel's most exceptional custom residences.

1288 Tolteca Ct, Fremont
$3,686,000
4 Beds ⋅ 4 Baths ⋅ 41144376 MLS
Welcome to a stunning, East-facing luxury retreat nestled on a prime view lot spanning nearly 3/4 of an acre in the prestigious Weibel neighborhood of the Fremont hills at 46935 Aloe Ct, Fremont, CA 94539. Epitomizing modern elegance with panoramic bay views and a tranquil ambiance, this meticulously remodeled home seamlessly blends sophisticated indoor living with resort-style outdoor entertaining. Step inside to find fresh interior paint, modern doors with lever-style handles, and new luxury waterproof flooring throughout the main areas. Dramatic vaulted beam ceilings with custom hanging LED light fixtures anchor the family room, formal living room, and primary suite, while bright skylights and LED recessed lighting highlight every detail. Gather around two distinct fireplaces, including a family room feature wall tiled to the ceiling with an electric insert. The gourmet chef’s kitchen boasts new shaker golden oak and white soft-close cabinets, elegant quartz countertops, new stainless steel appliances, a huge pantry, and recessed lighting, flowing effortlessly into the formal dining room. The spacious primary bedroom serves as a private sanctuary, featuring a private deck with breathtaking views and a fully remodeled spa-like bath with double floating vanities, LED-lighted mirrors, custom tile, a sleek stall shower, and a separate freestanding acrylic tub. All three guest bedrooms offer new upgraded carpet, modern closet doors, and recessed lighting, while every bathroom in the home has been completely transformed with high-end finishes. Additional interior features include a large dedicated laundry room with cabinets, a sink, and new lighting. Outside, enjoy an expansive deck, shimmering swimming pool, spa, and incredible room to expand or consider adding an ADU. Complete with a fresh modern stucco exterior, composition shingle roof, fully owned solar, dual-zone A/C and heating, and a two-car attached garage with a new door and automatic opener, no detail has been overlooked in this extraordinary estate.

46935 Aloe Ct, Fremont
$2,590,000
4 Beds ⋅ 3 Baths ⋅ 41142577 MLS
Tucked at the end of a quiet court in the Weibel school district, this north-facing 4-bedroom, 2.5-bath home offers 2,163 square feet in crisp white canvas on a 7,600 sq ft lot. Vaulted ceilings anchor the formal living and dining rooms, and new luxury vinyl plank flooring, recessed lighting, and fresh paint carry through the home ready for its next chapter. The kitchen, finished in quartz with a stainless sink and new appliances, opens directly to the family room and rear yard. A standout sunroom, tiled floor, ceiling fans, and brick patio, extends the living space outdoors and offers a rare bonus room that is not included in the square footage. Every bathroom has been updated with quartz vanities and clean, current finishes. The lot is unlandscaped front and back, a true opportunity for a buyer to design outdoor space on their own terms. Minutes to Warm Springs BART, Mission Peak trails, 680/880, and Fremont's major employers, with Weibel Elementary an easy walk away. Live Well!

866 Hidatsa Ct, Fremont