REQUEST A TOUR If you would like to see this home without being there in person, select the "Virtual Tour" option and your agent will contact you to discuss available opportunities.

In-PersonVirtual Tour

Fri

May

Sat

May

Sun

May

Debbi DiMaggio Betta

debbi.dimaggio@corcoranicon.com +1(510) 414-6777

$ 3,899,000

Est. payment | -/mo

5 Beds

3.5 Baths

4,048 SqFt

Save Virtual Tour

$ 3,899,000

Est. payment | -/mo

Save Virtual Tour

5 Beds

3.5 Baths

4,048 SqFt

OPEN HOUSE

Sat May 10, 1:00pm - 4:00pm

Sun May 11, 1:00pm - 4:00pm

Key Details

Property Type Single Family Home

Sub Type Single Family Residence

Listing Status Active

Purchase Type For Sale

Square Footage 4,048 sqft

Price per Sqft $963

MLS Listing ID ML82005168

Bedrooms 5

Full Baths 3

Half Baths 1

HOA Fees $66/mo

HOA Y/N Yes

Year Built 1993

Lot Size 0.267 Acres

Acres 0.2671

Property Sub-Type Single Family Residence

Property Description

Welcome to this beautifully appointed single-family residence nestled in the highly sought-after Mission Heights neighborhood in Fremont. Boasting 4 bedrooms, 3.5 baths, plus a loft-style bedroom, this exceptional home offers the perfect blend of elegance, comfort, and modern functionality. Soaring vaulted ceilings, a striking spiral staircase, and an abundance of oversized windows that flood the formal living and dining areas with natural lights. The kitchen features an extended chefs counter, ample cabinets and a walk-in pantry perfect for all your gourmet needs. Rich wood flooring flows throughout the kitchen and family living areas. Full bedroom and bath on the ground level. Upstairs, the primary suite boasts a sitting area, cozy fireplace, and a spa-like ensuite bath featuring a soaking tub, oversized stall shower, dual vanities with make-up station, private water closet and a walk-in closet. The versatile loft bedroom upstairs can serve as an additional bedroom, home office, study lounge, workout studio, or creative retreat - tailored to fit your lifestyle. Step outside into a custom-designed Zen garden, your private oasis for relaxation and reflection. Enjoy tranquil moments under the elegant pavilion, overlooking a waterfall-fed pond - a rare and beautiful escape.

Location

State CA

County Alameda

Zoning R1

Rooms

Basement Crawl Space

Interior

Interior Features Family Room, Formal Dining Room, Breakfast Bar, Pantry

Heating Forced Air

Flooring Tile, Wood

Fireplaces Number 3

Fireplaces Type Family Room, Living Room

Fireplace Yes

Window Features Double Pane Windows

Appliance Dishwasher, Double Oven, Disposal, Gas Range, Microwave, Trash Compactor

Exterior

Garage Spaces 3.0

Private Pool false

Building

Lot Description Level

Story 2

Water Public

Level or Stories Two Story

New Construction No

Schools

School District Fremont (510) 657-2350

Others

Tax ID 5130736007

Virtual Tour https://www.tourfactory.com/idxr3203618

© 2025 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.

Listed by Cindy Hung • Intero Real Estate Services

GET MORE INFORMATION

Debbi DiMaggio Betta

REALTOR | Partner | Lic# 01047447

debbi.dimaggio@corcoranicon.com

+1(510) 414-6777

342 Highland Ave, Piedmont, CA, 94611, USA

187 Freedom Court Fremont, CA 94539

Debbi DiMaggio Betta

OPEN HOUSE

Key Details

Location

Rooms

Interior

Exterior

Building

Schools

Others

187 Freedom Court