Save
Ask
Tour
Hide
Share
$3,988,000
New Listing

925 Curtner Rd
Fremont, CA 94539

Single Family Residence|Pending
5
Beds
5
Total Baths
4
Full Baths
1
Partial Bath
4,037
SqFt
$988
/SqFt
1997
Built
Subdivision:
VINEYARDS
County:
Alameda
Listed by Joe Schembri of Coldwell Banker Realty [email protected]
Save
Ask
Tour
Hide
Share

Mortgage Calculator

Monthly Payment (Est.)

$18,195
Calculator powered by Showcase IDX, a Constellation1 Company. Copyright ©2026 Information is deemed reliable but not guaranteed.

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.

Save
Ask
Tour
Hide
Share
Listing Snapshot
Price 
$3,988,000
Days On Site 
0 Days
Bedrooms 
5
Inside Area (SqFt) 
4,037 sqft
Total Baths 
5
Full Baths 
4
Partial Baths 
1
Lot Size 
0.4607 Acres
Year Built 
1997
MLS® Number 
41135552
Status 
Pending
Property Tax 
N/A
HOA/Condo/Coop Fees 
N/A
Sq Ft Source 
N/A
Friends & Family
Recent Activity
6 hours agoListing updated with changes from the MLS®
6 hours agoListing first seen on site
General Features
Acres 
0.4607
Attached Garage 
Yes
Foundation 
Raised
Garage 
Yes
Garage Spaces 
3
Levels 
Two
Parking 
AttachedGarageGarage Door Opener
Parking Spaces 
3
Property Sub Type 
Single Family Residence
Style 
CustomMediterraneanSpanish
Interior Features
Cooling 
Central Air
Fireplace 
Yes
Fireplace Features 
Family RoomGas StarterLiving RoomMaster Bedroom
Flooring 
CarpetStoneWood
Heating 
Forced Air
Interior 
Eat-in Kitchen
Bonus Room 
Den 
Family Room 
Kitchen 
Office 
Save
Ask
Tour
Hide
Share
Exterior Features
Construction Details 
StoneStucco
Exterior 
Garden
Lot Features 
Back YardFront YardGarden
Pool Features 
None
Roof 
Tile
View 
Hills
Waterview 
Hills
Community Features
Financing Terms Available 
CashConventional
School District 
Fremont Unified
Schools
School District
Fremont Unified
Elementary School
Unknown
Middle School
Unknown
High School
Unknown


This information is for your personal, non-commercial use and may not be used for any purpose other than to identify prospective properties you may be interested in purchasing. The display of MLS data is usually deemed reliable but is NOT guaranteed accurate by the MLS. Buyers are responsible for verifying the accuracy of all information and should investigate the data themselves or retain appropriate professionals. Information from sources other than the Listing Agent may have been included in the MLS data. Unless otherwise specified in writing, the Broker/Agent has not and will not verify any information obtained from other sources. The Broker/Agent providing the information contained herein may or may not have been the Listing and/or Selling Agent.

Neighborhood & Commute
Source: Walkscore
Save
Ask
Tour
Hide
Share