Share this with your friends
(408) 425-9359
Real Estate Company
38007 Stenhammer DR, Fremont, CA 94536
- $1,500,000
- 3
- BD
- 3
- BA
- 2,002
- SqFt
Listed by Althea Kippes, 415.305.9934 from BRG Realty
(If provided) CoList: from
Sold listing courtesy of Stephanie Lee from SCRR02
- Sold Price
- $1,500,000
- List Price
- $1,499,000
- Closing Date
- Mar 21, 2025
- MLS#
- ML81992307
- Status
- SOLD
- Bedrooms
- 3
- Total Bathrooms
- 3
- Full Bathrooms
- 2
- Partial Bathrooms
- 1
- Sqft. of Residence
- 2,002
- Lot Size
- 6,189
- Listing Area
- Fremont
- Year Built
- 1982
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.
/u.realgeeks.media/sanjoserealestatepro/Header_Logo-min.png){kind=logo}
Additional Information
- Acres
- 0.14
- Age
- 43
- Amenities
- Inverted Floor Plan, Skylight, Walk-in Closet
- Bathroom Features
- Dual Flush Toilet, Half on Ground Floor, Showers over Tubs - 2+, Solid Surface, Stone, Tile, Updated Bath
- Bedroom Description
- Inverted Floor Plan, Reverse Floor Plan
- Cooling System
- Central AC
- Days On Market
- Unknown
- Energy Features
- Ceiling Insulation, Double Pane Windows, Low Flow Toilet, Skylight, Solar Power, Solar Power Battery Backup, Tankless Water Heater, Thermostat Controller, Walls Insulated, Other
- Family Room
- Kitchen / Family Room Combo
- Fireplace Description
- Family Room, Wood Burning
- Floor Covering
- Carpet, Hardwood, Laminate, Tile
- Foundation
- Crawl Space
- Garage Parking
- Attached Garage, Electric Car Hookup, Gate / Door Opener
- Heating System
- Forced Air, Solar, Solar with Back-up
- Laundry Facilities
- In Utility Room, Washer / Dryer
- Living Area
- 2,002
- Lot Description
- Views
- Lot Size
- 6,189
- Neighborhood
- Fremont
- Other Rooms
- Attic, Bonus / Hobby Room, Great Room, Laundry Room, Storage
- Other Utilities
- Public Utilities, Solar Panels - Owned
- Roof
- Composition
- Sewer
- Sewer - Public
- View
- Canyon View, Garden / Greenbelt, Greenbelt, Hills, Park, River / Stream
- Zoning
- R-1
How much is your home worth?
...get instant property value now!
Mortgage Calculator
The data relating to real estate for sale on this display comes in part from the Internet Data Exchange program of the MLSListingsTM MLS system. Real estate listings held by brokerage firms other than Real Estate Company are marked with the Internet Data Exchange and detailed information about them includes the names of the listing brokers and listing agents.
Based on information from MLSListings MLS as of . 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.
Copyright 2026 MLSListings Inc. All rights reserved