CA > Fremont
Fremont, CA 94536,38007 Stenhammer Drive
Fremont, CA 94536,38007 Stenhammer Drive
Fremont, CA 94536,38007 Stenhammer Drive
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
Sun
23
Feb
Mon
24
Feb
Tue
25
Feb
Maya Hiersoux

Maya Hiersoux

+1(415) 971-3559
$1,499,000
Est. payment /mo
3 Beds
2.5 Baths
2,002 SqFt
Save Virtual Tour

UPDATED:

02/21/2025 07:07 PM

Key Details

Property Type Single Family Home

Sub Type Single Family Residence

Listing Status Pending

Purchase Type For Sale

Square Footage 2,002 sqft

Price per Sqft $748

MLS Listing ID ML81992307

Bedrooms 3

Full Baths 2

Half Baths 1

HOA Y/N No

Year Built 1982

Lot Size 6,189 Sqft

Acres 0.1421

Property Sub-Type Single Family Residence

Property Description

Open the door and be greeted with spectacular views of the canyon, oak trees & greenbelt! This is the perfect place for entertaining, with the living room opening to the great room, open kitchen, and large Trex deck (the best location for relaxing and enjoying the peaceful views.) The kitchen backsplash tile above the gas stove is a custom glasswork piece by artist Saundra Snyder. The doors throughout the house are custom-designed shoji crafted by Pacific Shoji Works. The half bath has a custom glasswork lighted sink and mirror. Downstairs, you will find the primary ensuite, two additional bedrooms, and a bathroom w/ Toto toilets. The middle bedroom closet bifold shoji has an antique rama with an eagle framed above. The end bedroom closet has a fusuma-style door with cranes. The well-lit bonus room downstairs provides outdoor access and can be used as an office, storage, hobbies, etc. Backyard & garden by the front deck has a prolific avocado tree & lemon, lime & plum trees. Near downtown Niles, Alameda Creek Trail, hiking, parks, restaurants, stores (Target, Trader Joe's, Safeway.) Easy access to Hwy 680, 880, 84 & Fremont BART. Amenities include owned solar panels, Tesla Powerwall, Blink EV charger in the 2-car garage, Nest thermostat, tankless water heater, & water softener.

Location

State CA

County Alameda

Zoning R-1

Rooms

Basement Crawl Space

Interior

Interior Features Dining Area, Storage, Stone Counters, Smart Thermostat

Heating Forced Air, Solar

Flooring Hardwood, Laminate, Tile

Fireplaces Number 1

Fireplaces Type Family Room, Wood Burning

Fireplace Yes

Window Features Double Pane Windows

Appliance Double Oven, Gas Range, Water Softener, Tankless Water Heater

Exterior

Exterior Feature Back Yard

Garage Spaces 2.0

View Y/N true

View Canyon, Greenbelt, Hills, Park

Private Pool false

Building

Story 2

Sewer Public Sewer

Water Public

Level or Stories Two Story

New Construction No

Schools

School District Fremont (510) 657-2350

Others

Tax ID 5070698044

Virtual Tour https://vimeo.com/1051887553

Read Less Info
Bridge MLS
© 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 Althea Kippes • BRG Realty

GET MORE INFORMATION

agent

Maya Hiersoux

+1(415) 971-3559

Agent | License ID: 01450016

Agent License ID: 01450016

Name

Phone*

Message

By checking this box, I agree by electronic signature to (1) the Electronic Disclosure Consent; (2) receive recurring marketing communication from or on behalf of Maya Hiersoux, including auto-dialed calls, texts, and prerecorded messages (consent not required to make a purchase; data rates may apply; reply "STOP" to opt-out of texts or "HELP" for help); and (3) the Terms of Service and Privacy Policy of this website. I understand that I can call +1(415) 971-3559 to obtain direct assistance.