NOT LISTED FOR SALE

38007 Stenhammer Dr Fremont, CA 94536

Canyon Heights-Vallejo Mills Neighborhood

Estimated Value: $1,286,000 - $1,714,000

3 Beds
2.5 Baths
2,002 Sq Ft
$755/Sq Ft Est. Value

Sale Details

Date Sold: March 21, 2025

Last sale price $1,500,000 $749 Per Sq Ft

Est. 1% increase in value since last sale

Current estimated payment $8,745 / mo

20 Days on Market

Highlights

  • Solar Power Battery
  • River View
  • Wood Flooring
  • Vallejo Mill Elementary School Rated A-
  • Deck
  • Solid Surface Bathroom Countertops

About This Home

As of March 2025

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.

Last Agent to Sell the Property

Althea Kippes

BRG Realty License #01231100 Listed on: 01/30/2025

Last Buyer's Agent

Stephanie Lee

Coldwell Banker Realty License #02056574

Coldwell Banker Realty

Home Details

Home Type

  • Single Family

Year Built

  • Built in 1982

Lot Details

  • 6,190 Sq Ft Lot
  • Grass Covered Lot
  • Back Yard

Parking

  • 2 Car Attached Garage
  • Electric Vehicle Home Charger
  • Garage Door Opener

Property Views

  • River
  • Canyon
  • Hills
  • Garden
  • Park or Greenbelt

Home Design

  • Reverse Style Home
  • Ceiling Insulation
  • Composition Roof

Interior Spaces

  • 2,002 Sq Ft Home
  • 2-Story Property
  • Inverted Floor Plan
  • Skylights
  • Wood Burning Fireplace
  • Double Pane Windows
  • Family Room with Fireplace
  • Great Room
  • Family or Dining Combination
  • Bonus Room
  • Storage Room
  • Crawl Space
  • Alarm System
  • Attic

Kitchen

  • Open to Family Room
  • Double Oven
  • Gas Oven
  • Gas Cooktop
  • Granite Countertops

Flooring

  • Wood
  • Carpet
  • Laminate
  • Tile

Bedrooms and Bathrooms

  • 3 Bedrooms
  • Walk-In Closet
  • Remodeled Bathroom
  • Bathroom on Main Level
  • Solid Surface Bathroom Countertops
  • Stone Countertops In Bathroom
  • Dual Flush Toilets
  • Low Flow Toliet
  • Bathtub with Shower
  • Bathtub Includes Tile Surround

Laundry

  • Laundry Room
  • Washer and Dryer

Eco-Friendly Details

  • Energy-Efficient Insulation
  • Solar Power Battery
  • Solar Power System
  • Solar owned by seller
  • Solar Heating System

Outdoor Features

  • Balcony
  • Deck

Utilities

  • Forced Air Heating and Cooling System
  • Thermostat
  • Tankless Water Heater
  • Water Softener is Owned
  • Cable TV Available

Listing and Financial Details

  • Assessor Parcel Number 507-0698-044

Home Details

Home Type

Single Family

Year Built

Built in 1982

Lot Details

6,190 Sq Ft Lot

Parking

2

Listing Details

  • Subclass: Single Family Home
  • Listing Class: Residential
  • Structure Sq Ft: 2002
  • Incorporated: Yes
  • Year Built: 1982
  • Zoning Description: R-1
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Family Room: Kitchen / Family Room Combo
  • Fireplace: Family Room, Wood Burning
  • Dining Room: Dining Area, Dining Area in Family Room
  • Kitchen: Cooktop - Gas, Countertop - Granite, Countertop - Stone, Oven - Double, Oven - Gas, Refrigerator
  • Living Sq Ft: 2002
  • Stories: 2
  • Security: Security Alarm
  • Bedrooms: Inverted Floor Plan, Reverse Floor Plan
  • Laundry: In Utility Room, Washer / Dryer
  • Flooring: Carpet, Hardwood, Laminate, Tile
  • Additional Rooms: Attic, Bonus / Hobby Room, Great Room, Laundry Room, Storage
  • Fireplaces Min: 1
  • Full Bathrooms: 2
  • Half Bathrooms: 1
  • Total Bedrooms: 3
  • Bathroom: Dual Flush Toilet, Half on Ground Floor, Showers over Tubs - 2+, Solid Surface, Stone, Tile, Updated Bath
  • Fireplace: Yes

Exterior Features

  • Foundation: Crawl Space
  • Roof: Composition
  • View: Canyon, Garden / Greenbelt, Greenbelt, Hills, Park, River / Stream
  • Yard/Grounds: Back Yard, Balcony / Patio, Deck, Low Maintenance

Garage/Parking

  • Garage Spaces: 2
  • Garage Parking Features: Attached Garage, Electric Car Hookup, Gate / Door Opener
  • Electric Vehicle Hookup Type: Electric Vehicle Hookup Level 1 (120 volts), Electric Vehicle Hookup Level 2 (240 volts)

Utilities

  • Cooling System: Central AC
  • Heating System: Forced Air, Solar, Solar with Back-up
  • Sewer/Septic System: Sewer - Public

Association/Amenities

  • Amenities Miscellaneous: Inverted Floor Plan, Skylight, Walk-in Closet

Schools

  • High School: 26875

Lot Info

  • Lot Description: Views
  • Parcel Number: 507-0698-044
  • Lot Acres: 0.1421
  • Lot Size Area Minimum Units: Square Feet
  • Minimum Lot Size: 6189.00
  • Lot Size Area Maximum Units: Square Feet
  • Maximum Lot Size: 6189.00

Green Features

  • Energy Features: Ceiling Insulation, Double Pane Windows, Low Flow Toilet, Skylight, Solar Power, Solar Power Battery Backup, Tankless Water Heater, Thermostat Controller, Walls Insulated

Multi Family

  • Utilities: Public Utilities, Solar Panels - Owned

MLS Schools

  • High School District Text: Fremont Unified
  • High School Text: Washington High

Ownership 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 Name Owned For Owner Type

Purchase Details

Closed on
Aug 26, 2017
Sold by
Bought by
Current Estimated Value
$1,511,561

Purchase Details

Closed on
Feb 1, 2007
Sold by
Bought by

Purchase Details

Closed on
Aug 13, 2003
Sold by
Bought by

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$280,000
Outstanding Balance
$116,548
Interest Rate
4.87%
Mortgage Type
Purchase Money Mortgage
Estimated Equity
$1,395,013

Purchase Details

Closed on
Jan 11, 2000
Sold by
Bought by

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$292,000
Interest Rate
7.87%

Purchase Details

Closed on
Feb 24, 1998
Sold by
Bought by

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$247,200
Interest Rate
6.87%

Purchase Details

Closed on
Jun 30, 1995
Sold by
Bought by

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$251,750
Interest Rate
6.87%
Source: Public Records

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

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 Buyer Sale Price Title Company
-- None Available
-- None Available
-- None Available
$280,000 First American Title Company
$365,000 Chicago Title Co
$309,000 North American Title Co
$265,000 First American Title Guarant
Source: Public Records

Mortgage 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 Status Borrower Loan Amount
Open $280,000
Closed $292,000
Previous Owner $247,200
Previous Owner $251,750
Closed $30,900
Source: Public Records

Property 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 Event Price List to Sale Price per Sq Ft
03/21/2025 03/21/25 Sold $1,500,000 +0.1% $749 / Sq Ft
02/19/2025 02/19/25 Pending -- -- --
01/30/2025 01/30/25 For Sale $1,499,000 -- $749 / Sq Ft
Source: MLSListings

Tax 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.

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 $6,972 $553,964 $168,289 $392,675
2024 $6,972 $542,967 $164,990 $384,977
2023 $6,777 $539,184 $161,755 $377,429
2022 $6,677 $521,614 $158,584 $370,030
2021 $6,515 $511,251 $155,475 $362,776
2020 $6,497 $512,941 $153,882 $359,059
2019 $6,424 $502,885 $150,865 $352,020
2018 $6,297 $493,027 $147,908 $345,119
2017 $6,139 $483,361 $145,008 $338,353
2016 $6,028 $473,886 $142,166 $331,720
2015 $5,942 $466,768 $140,030 $326,738
2014 $5,835 $457,625 $137,287 $320,338
Source: Public Records

Agents Affiliated with this Home

  • A

    Seller's Agent in 2025

    Althea Kippes

    BRG Realty

    Section Image
  • Stephanie Lee

    Buyer's Agent in 2025

    Stephanie Lee

    Coldwell Banker Realty

    (925) 724-9053

    1 in this area

    9 Total Sales

    Stephanie Lee
    Section Image
See All Agents

Map

Source: MLSListings

MLS Number: ML81992307

MLSListings

APN: 507-0698-044-00

California Alameda County Fremont 94536 Canyon Heights-Vallejo Mills

38007 Stenhammer Dr, Fremont, CA

Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.

MLSListings Property Information © 2026 MLSListings Inc. All rights reserved. Listing information is deemed reliable but not guaranteed. Certain information contained herein is derived from information which is the licensed property of, and copyrighted by, MLSListings Inc. The viewer acknowledges ownership and validity of its copyright. Information provided is for personal, non-commercial use by a viewer with a bona fide interest in the purchase or sale of real estate of the type being offered via this website or other electronic means. The viewer is prohibited from copying, redistributing or retransmitting any of the data or information provided by MLSListing, Inc.

Nearby Homes
Your Personal Tour Guide

Ask me questions while you tour the home.