Refine Search
Sort by
$3,998,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

Listing courtesy of Joseph Sabeh Jr from Golden Gate Sotheby's Int'l. 510-673-2083

$1,198,000
4 Beds 4 Baths 41142088 MLS
Welcome to this Northeast facing 3021 Gettysburg Common, in a brand new Lincoln townhome community located near the Fremont Irvington Five Corners, the commercial heart of the Irvington District. Fremont Central Park, Kaiser and Washington Hospital, Safeway, Apni Mandi, and the future Irvington BART station, are all nearby. It's the most convenient location you can find, and yet it's on a quiet street. Excellent Durham elementary. Pre-installed high voltage electric car charging outlet. The natural lighting of these East and Northeast facing townhomes is excellent. Each unit has a first level bedroom. Very spacious 2nd level great room boasts a large kitchen and a central island. 3 additional bedrooms overlook the community on the third level. Solar system is already pre-installed with an additional cost to purchase. High end finishes found only in model homes from other bigger builders: smooth wall finish, not orange peel, stairs with hard surface, not carpet, kitchen cabinets with hardwood, backsplash, shower wall slabs, and pavers in yard. The official address is 3721 Gettysburg Common, 94538, but this new address is not searchable on most maps, hence the use of 40857 Lincoln Ave. Pictures from 3701, same floor plan. Some rooms are of irregular shapes.

3721 Gettysburg Common, Fremont

Listing courtesy of Charles Liu from Compass. 510-938-6668

Bay East © 2026. CCAR © 2026. BridgeMLS © 2026. Information Deemed Reliable But Not Guaranteed. This information is being provided by the Bay East MLS, or CCAR MLS, or bridgeMLS. The listings presented here may or may not be listed by the Broker/Agent operating this website. This information is intended for the personal use of consumers and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Data last updated on: