$3,998,000

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… Read More 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. Read Less

Courtesy of Joseph Sabeh Jr, Golden Gate Sotheby's Int'l 510-542-2600

Listing Snapshot

Days Online

Last Updated

Aug 23, 2026

Property Type

Single Family Residence

Beds

Full Baths

Square Ft.

5,540

Lot Size

0.48 Acres

Year Built

1979

MLS Number

41143157

30 Days Snapshot Of 94539

$2.83M

+31%

(avg) sold price

-50%

homes sold

+8%

(avg) days on market

Snapshot

Area Map

Additional Details

Appliances & Equipment

Appliances: Dishwasher, Double Oven, Gas Range, Plumbed For Ice Maker, Microwave, Refrigerator, Gas Water Heater

Building

Construction Materials: Stucco, Living Area: 5540, Year Built: 1979, Level - Street: 3 Bedrooms, 3 Baths, Primary Bedrm Suite - 1, Laundry Facility, Other, Main Entry, Level - Upper: 4 Bedrooms, 3 Baths, Primary Bedrm Suite - 1

Cooling

Cooling: Central Air, Cooling Included

Fireplaces

Fireplace Included

Floors

Flooring: Tile, Vinyl, Carpet

Garage

3 garage spaces, Garage Included

Heating

Heating: Zoned, Heating Included

Laundry

Features: Hookups Only, Laundry Room

Lot

Lot Features: Court, Level, Premium Lot, Landscaped, Lot Size Acres: 0.48, Lot Size Area: 21078, Lot Size Square Feet: 21078, Parcel Number: 519167734

Parking

Parking Features: Attached, Garage Door Opener

Pool

Pool Features: Gunite, In Ground, Outdoor Pool, Pool Private YN: t

Property

Property Condition: Existing, Property Sub Type: Single Family Residence, View: Hills

Roof

Roof: Composition Shingles

Utilities

Electric: Photovoltaics Seller Owned, Water Source: Public

Windows

Window Features: Window Coverings

Find The Perfect Home

'VIP' Listing Search

Whenever a listing hits the market that matches your criteria you will be immediately notified.

Join The List

Mortgage Calculator

Selling price

Down payment

Term (years)

Interest rate (%)

Monthly Payment

Asif Kazi | CA DRE #02205196
Brokered by
eXp Realty of California Inc.
CA DRE #01878277

1288 Tolteca Ct

'VIP' Listing Search

Schools In The Area

Similar Listings

Find My Dream Home

1. Neighborhoods

2. Home Type

3. Send

Asif Kazi | CA DRE #02205196 Brokered by eXp Realty of California Inc. CA DRE #01878277

1288 Tolteca Ct

'VIP' Listing Search

Schools In The Area

Similar Listings

1. Neighborhoods

2. Home Type

3. Send

Asif Kazi | CA DRE #02205196
Brokered by
eXp Realty of California Inc.
CA DRE #01878277