Listing Agent: Joe Schembri Broker/Office: Coldwell Banker Realty
925 Curtner Rd Fremont CA 94539
Listing ID
#41135552
Status
Pending
Property Type
Single Family Residence
Property Style
Custom
County
Alameda
Neighborhood
VINEYARDS
Year Built
1997
Days on website
3
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.
Construction Materials:
Stucco
Flooring:
Carpet, Stone, Wood
Foundation Details:
Raised
High School District:
Fremont Unified
Levels:
Two
Lot Features:
Garden, Yard
Parking Features:
Garage
Roof:
Tile
View:
Hills
High School District:
Fremont Unified
City:
Fremont
|
Scan this QR code to see this listing online.
Direct link:
http://www.searchproperties.sdvalues.com/listings/direct/381bd5be94127cfc38f7476570f434f3
|
Listed By:
Joe Schembri
Coldwell Banker Realty
CA Lic#
Based on information from CARETS as of Friday, June 12, 2026 5:56 PM. The information being provided by CARETS is for the visitor's personal, noncommercial use and may not be used for any purpose other than to identify prospective properties visitor may be interested in purchasing. The data contained herein is copyrighted by CARETS, CLAW, CRISNet MLS, i-Tech MLS, PSRMLS and/or VCRDS and is protected by all applicable copyright laws. Any dissemination of this information is in violation of copyright laws and is strictly prohibited.
Any property information referenced on this website comes from the Internet Data Exchange (IDX) program of CRISNet MLS and/or CARETS. All data, including all measurements and calculations of area, is obtained from various sources and has not been, and will not be, verified by broker or MLS. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information.