Additional details

Alexis Halikas

alexis@reneewhite.com +1(925) 378-5443

Listed by Joe Schembri • Coldwell Banker Realty

$3,988,000

Est. payment - /mo

5 Beds

5 Baths

4,037 SqFt

Save

UPDATED:

Key Details

Property Type Single Family Home

Sub Type Detached

Listing Status Pending

Purchase Type For Sale

Square Footage 4,037 sqft

Price per Sqft $987

Subdivision Vineyards

MLS Listing ID 41135552

Bedrooms 5

Full Baths 4

HOA Y/N No

Year Built 1997

Lot Size 0.461 Acres

Property Sub-Type Detached

Source BAY EAST

Property Description

Welcome to an estate of undeniable prestige in one of Fremont's most coveted Weibel neighborhoods. This masterfully designed Mediterranean style residence was built by John Clawson, a custom home builder known for construction of high-end custom homes & estates. Perched on a premium 20,070 sq ft lot with beautiful hill views this property offers the privacy of a true sanctuary. The double entry door opens to a grand foyer with chandelier and an elegant staircase. The grand living room with soaring ceilings and an elegant fireplace flows into a formal dining room with recessed ceiling and chandelier. A generous family room with fireplace offers direct access to the spacious backyard and large patio. A private mother-in-law suite with private entrance and en-suite full bathroom adds rare flexibility for multigenerational living or guest accommodations. A versatile downstairs den offers the perfect bonus space to work from home. At the heart of the home, the chef's kitchen boasts custom Maple wood cabinetry, granite slab countertops, a center island, breakfast room with Bay window, and a walk-in pantry. The upper floor features 4 bedrooms, 3 of which have en-suite bathrooms. The serene primary suite features a private view balcony, a fireplace and a large walk-in closet. The en-suite bathroom boasts marble shower, counters and flooring. Thoughtful details elevate every corner: rich hardwood flooring throughout, oversized dual-pane picture windows that flood the home with natural light, 3 elegant fireplaces, 2 internal staircases, all bathrooms with marble flooring and showers, dual-zone HVAC, a large laundry room, fresh exterior paint, tile roof, and a 3-car finished garage. Step outside to a private oasis: a generous backyard with a large patio and a diverse collection of fruit trees, offering a tranquil escape just steps from your door and plenty of space for an ADU with views. The property is secured by an artisan stacked-stone wall for privacy. Located within the highly sought-after Weibel top-tier schools attendance boundary and minutes from I-680/880, this exceptional residence delivers both top-tier schooling and effortless access to Silicon Valley.

Location

State CA

County Alameda

Interior

Heating Zoned

Cooling Central Air

Flooring Hardwood, Hardwood Flrs Throughout, Carpet

Fireplaces Type Family Room, Gas Starter, Living Room, Master Bedroom, Gas Piped

Fireplace Yes

Window Features Double Pane Windows,Skylight(s)

Appliance Dishwasher, Double Oven, Microwave, Oven, Range, Refrigerator

Laundry 220 Volt Outlet, Laundry Room

Exterior

Garage Spaces 3.0

Pool None

View Hills

Private Pool false

Building

Lot Description Premium Lot, Back Yard, Front Yard, Landscaped

Story 2

Foundation Raised

Water Public

Architectural Style Custom, Mediterranean, Spanish

Schools

School District Fremont (510) 657-2350, Fremont (510) 657-2350

Others

Special Listing Condition Standard

Read Less Info

© 2026 BEAR, CCAR, bridgeMLS. This information is deemed reliable but not verified or guaranteed. This information is being provided by the Bay East MLS or Contra Costa MLS or bridgeMLS. The listings presented here may or may not be listed by the Broker/Agent operating this website.

Get More Information

Alexis Halikas

+1(925) 378-5443

Agent | License ID: 01462315

Agent License ID: 01462315

925 Curtner Rd Fremont, CA 94539

Alexis Halikas

Key Details

Location

Interior

Exterior

Building

Schools

Others

Get More Information

Quick Search