$3,988,000
COMING SOON

Estimated payment $22,604/month

5 Beds
4.5 Baths
4,037 Sq Ft
0.46 Acres Lot

Highlights

  • Custom Home
  • View of Hills
  • Wood Flooring
  • Fred E. Weibel Elementary School Rated A
  • Fireplace in Primary Bedroom
  • Solid Surface Countertops

About This Home

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.

Listing Agent

Joe Schembri

Coldwell Banker Realty License #00890599 Listed on: 05/21/2026

Coldwell Banker Realty

Home Details

Home Type

  • Single Family

Year Built

  • Built in 1997

Lot Details

  • 20,070 Sq Ft Lot
  • Back and Front Yard

Parking

  • 3 Car Attached Garage
  • Side Facing Garage
  • Garage Door Opener

Home Design

  • Custom Home
  • Spanish Architecture
  • Mediterranean Architecture
  • Raised Foundation
  • Tile Roof
  • Stucco

Interior Spaces

  • 2-Story Property
  • Skylights
  • Gas Fireplace
  • Double Pane Windows
  • Family Room with Fireplace
  • Living Room with Fireplace
  • Views of Hills

Kitchen

  • Breakfast Area or Nook
  • Built-In Double Oven
  • Built-In Range
  • Microwave
  • Dishwasher
  • Solid Surface Countertops

Flooring

  • Wood
  • Carpet

Bedrooms and Bathrooms

  • 5 Bedrooms
  • Fireplace in Primary Bedroom

Laundry

  • Laundry Room
  • 220 Volts In Laundry

Utilities

  • Zoned Heating and Cooling System
  • Thermostat
  • High-Efficiency Water Heater

Community Details

  • No Home Owners Association
  • Vineyards Subdivision

Listing and Financial Details

  • Assessor Parcel Number 519160193

Home Details

Home Type

Single Family

Year Built

Built in 1997

Lot Details

0.46 Acres

Parking

3

Listing Details

  • Stories: 2
  • Year Built: 1997
  • Property Sub Type: Detached
  • Prop. Type: Residential
  • Subdivision Name: Vineyards
  • Directions: E Warren Ave> Curtner Rd..
  • Architectural Style: Custom, Mediterranean, Spanish
  • Garage Yn: Yes
  • Unit Levels: Two Story
  • New Construction: No
  • Efficiency: Walls Insulated, Thermostat, Water Heater
  • Special Features: ComingSoon

Interior Features

  • Flooring: Hardwood, Hardwood Flrs Throughout, Carpet
  • Appliances: Dishwasher, Double Oven, Microwave, Oven, Range, Refrigerator
  • Full Bathrooms: 4
  • Total Bedrooms: 5
  • Fireplace Features: Family Room, Gas Starter, Living Room, Master Bedroom, Gas Piped
  • Fireplace: Yes
  • Window Features: Double Pane Windows, Skylight(s)
  • Room Kitchen Features: Breakfast Nook, Counter - Solid Surface, Stone Counters, Dishwasher, Double Oven, Eat-in Kitchen, Disposal, Kitchen Island, Microwave, Oven Built-in, Pantry, Range/Oven Built-in, Refrigerator

Exterior Features

  • Roof: Tile
  • Lot Features: Premium Lot, Back Yard, Front Yard, Landscaped
  • Pool Features: None
  • Pool Private: No
  • View: Hills
  • Construction Type: Stucco
  • Foundation Details: Raised
  • Property Condition: Existing

Garage/Parking

  • Garage Spaces: 3
  • Parking Features: Attached, Side Yard Access, Garage Faces Side, Garage Door Opener

Utilities

  • Heating: Zoned
  • Cooling: Central Air
  • Laundry Features: 220 Volt Outlet, Laundry Room
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Electric: No Solar
  • Water Source: Public

Condo/Co-op/Association

  • Association: No

Schools

  • Senior High School District: Fremont (510) 657-2350

Lot Info

  • Lot Size Sq Ft: 20070
  • Parcel Number: 519160193

Map

Range of Values:

--
Value Increase
--
Percent Increase
--
Adjusted for Inflation
Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Tax History

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2025 $16,024 $1,280,716 $431,901 $855,815
2024 $15,254 $1,255,471 $423,433 $839,038
2023 $14,862 $1,237,719 $415,131 $822,588
2022 $14,689 $1,206,453 $406,993 $806,460
2021 $14,329 $1,182,662 $399,014 $790,648
2020 $14,424 $1,177,467 $394,924 $782,543
2019 $14,258 $1,154,384 $387,181 $767,203
2018 $13,985 $1,131,755 $379,592 $752,163
2017 $13,640 $1,109,569 $372,151 $737,418
2016 $13,420 $1,087,817 $364,855 $722,962
2015 $13,253 $1,071,479 $359,377 $712,102
2014 $13,035 $1,050,495 $352,339 $698,156
Source: Public Records

Purchase History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Type Sale Price Title Company
Interfamily Deed Transfer -- None Available
Interfamily Deed Transfer -- None Available
Source: Public Records

Source: Bay East Association of REALTORS®

MLS Number: 41135552

Bay East Association of REALTORS®

APN: 519-1601-093-00

Your Personal Tour Guide

Ask me questions while you tour the home.