Opening page…
Closed
- Listed price
- $1,387,500
- Listed Aug 14, 2017 · $426/sq ft
- Sold price
- $1,555,000
- Sold Oct 9, 2017
4 beds|4 ba|3,255 sqft|5,950 sqft lot|1984 Built|10 MLS days on market
38047 Stenhammer Dr, Fremont, CA 94536
Property Description
The reviews are in! Here are the most recent quotes from our open house , " You need to tell people the pictures do not do this house justice, it is even more beautiful in person!" " I would never move out of this home." , " I have goose bumps.", " WOW" , " Forget my clients... we want to move in." , " This is my exact taste, I love everything about this house. I would not change a thing", "When can I move in?" We have received just stellar reviews from potential buyers, agents, and neighbors. This house is best experienced in person. This home is not just beautiful looking. This home has been so thoughtfully designed, you will actually feel better in the space than you will with most other homes you will visit. No matter what area you are looking to move next, this one is well worth adding to your next tour list. The neighborhood is also an undiscovered gem w/ breathtaking views, Historic Niles, serene location, community feel, a mix of old and new, quirky, and individualistic.
Listing agent: Cynthia HolidayDRE #01147275cynthia@cynthiaholiday.com, Listing office: Holiday & Company, Inc.
MLS data updated 10/25/2026, 1:17:49 AM PT
Source: CRMLSMLS #: ML81673953
Belmont insights
Price & property history
Compare recorded home prices, same-type ZIP sales and mortgage rates.
Last recorded sale$1,555,000
Oct 9, 2017
Available records22017
From MLS recordsActual listing and closing events
Prices use the left axis; mortgage rates use the right. Hover, tap, or focus the chart and use the arrow keys. Red SOLD badges mark recorded sales.
This home · nearest recorded event
No recordNo property-price record in this range.ZIP 94536 · Oct 2026
No monthly averageAt least 3 eligible sales in this month are required.30-year fixed mortgage benchmark
No weekly rateNo published rate within 7 days of this date.This home · 0 price recordsNo records in this period
ZIP 94536 · same property typeLoading eligible closed sales…
Freddie Mac · national weekly ratesLoading mortgage-rate history…
Recorded sales in this period (0)
No recorded sales in this range. Select All available for older records; missing records do not mean the home never sold.
ZIP averages use publicly displayable closed sales from our licensed MLS feed, matched to the same ZIP and exact property type. Months with fewer than 3 sales are omitted; the current month is incomplete. Lines connect available monthly observations across gaps and do not represent measured prices in missing months. These averages are not adjusted for size, condition, or location within the ZIP, and are not an appraisal. Feed coverage may not include every sale. All available shows the available home and ZIP history, with mortgage rates over the same dates.
Mortgage benchmark: Freddie Mac Primary Mortgage Market Survey®. © Freddie Mac. Weekly national 30-year fixed rates, not APRs or a loan quote. Actual terms vary. Methodology changed in November 2022. The chart does not establish that interest-rate changes caused a home’s price changes.
Lines connect recorded asking and sale prices. They are visual guides, not estimates of the home’s value between those dates.
View listing & sale records
No earlier records were returned by our current sources. This does not mean the home has never sold.
MLS records may be incomplete. Earlier asking prices are not sale prices.