38007 Stenhammer Drive

$1,499,000 2,002 SQ FT
$749 SQ/FT

38007 Stenhammer Drive

@ Old Canyon Road - 3700 - Fremont, Fremont

Map direct
  • 3 Bed
  • 3 (2/1) Bath
  • 2 Park
  • 2,002 sqft
  • FREMONT
  • Payment calculator
DOM
1
SFH
  • Favorite
  • Hide
Message John L. Woodruff III
  • Sat Feb 1, 1:00 pm - 4:00 pm

    Spectacular views from a beautifully updated home.

  • Sun Feb 2, 1:00 pm - 4:00 pm

    Spectacular views from a beautifully updated home.

  • Sat Feb 8, 1:00 pm - 4:00 pm

    Spectacular views from a beautifully updated home.

As soon as you open the front door of this home, you are greeted with spectacular views of the canyon, hills, and treetops! This is the perfect place for entertaining, with the living room opening to the great room, large deck, and open kitchen. The deck provides the best location for relaxing and enjoying the peaceful views. The unique features of this home include a custom art glass sink and mirror in the half-bath, an art glass backsplash behind the gas cooktop, and custom-built shoji pocket and closet doors. Downstairs, you will find the primary ensuite, two additional bedrooms and a bathroom, and a large, well-lit room that can be used for storage, hobbies, an office, playroom, etc. Amenities include an electric vehicle hookup in the 2-car garage, a tankless water heater, owned solar panels, and a Tesla Powerwall (which provides power in case of outages).

Days on Market
1 day
Current Status
Active
Original Price
$1,499,000
List Price
$1,499,000
On Market Date
Jan 30, 2025
Property Type
Single Family Home
Area
3700 - Fremont
Zip Code
94536
MLS ID
ML81992307
APN
507-0698-044
Year Built
1982
Stories in Building
2
Possession
COE
Data Source
MLSL
Origin MLS System
MLSListings, Inc.
Bed
3
Bath
3 (2/1)
Dual Flush Toilet, Half on Ground Floor, Showers over Tubs - 2+, Solid Surface, Stone, Tile, Updated Bath
Parking
2
Attached Garage
SQ FT
2,002
SQ FT Source
Unavailable
Lot SQ FT
6,189.0
Lot Acres
0.14208 Acres
Kitchen
Cooktop - Gas, Countertop - Granite, Countertop - Stone, Oven - Electric, Refrigerator
Cooling
Central AC
Dining Room
Dining Area
Disclosures
NHDS Report
Family Room
Kitchen / Family Room Combo, Separate Family Room
Flooring
Carpet, Hardwood, Tile
Foundation
Crawl Space
Fire Place
Family Room, Wood Burning
Heating
Forced Air
Laundry
In Utility Room, Washer / Dryer
Views
Canyon, Forest / Woods, Hills, River / Stream
Possession
COE
Fee
Unavailable

MLS and other Information regarding properties for sale as shown in Theo have been obtained from various sources such as sellers, public records, agents and other third parties. This information may relate to the condition of the property, permitted or unpermitted uses, zoning, square footage, lot size/acreage or other matters affecting value or desirability. Unless otherwise indicated in writing, neither brokers, agents nor Theo have verified, or will verify, such information. If any such information is important to buyer in determining whether to buy, the price to pay or intended use of the property, buyer is urged to conduct their own investigation with qualified professionals, satisfy themselves with respect to that information, and to rely solely on the results of that investigation.

School data provided by GreatSchools. School service boundaries are intended to be used as reference only. To verify enrollment eligibility for a property, contact the school directly.

Listings © 2025 MLSListings Inc

Copyright © 2025 Theo Inc. All Rights Reserved