NOT LISTED FOR SALE

38854 Stillwater Common Fremont, CA 94536

Cherry-Guardino Neighborhood

Estimated Value: $1,509,737 - $1,647,000

3 Beds
2.5 Baths
1,474 Sq Ft
$1,086/Sq Ft Est. Value

Last Sold May 20, 2015

Last sale price $828,888 $562 Per Sq Ft

Est. 93% increase in value since last sale

Current estimated payment $9,827/month

12 Days on Market

Highlights

  • Cabana
  • View of Hills
  • Vaulted Ceiling
  • Vallejo Mill Elementary School Rated A-
  • Deck
  • Traditional Architecture

About This Home

As of May 2015

Zero lot line home *New carpet *open floor plan *roomy kitchen *custom cherry wood cabinets *recessed lighting *quartz kitchen counters *stainless dishwasher *electric ceramic cook top *double oven *microwave *mounted coffee maker w/ filtration system *central heat and air *brick fireplace *custom oak mantle *private back yard with lawn, deck, gazebo. Trees: lemon, lime, orange, pomegranate & decorative cherry *$70 HOA *2 pools. Schools: Vallejo Mill, Centerville, Washington. Open House:4/11, 4/12 1:30-4:30

Last Agent to Sell the Property

Lisa Blaylock

Coldwell Banker Residential Brokerage License #00920723 Listed on: 04/06/2015

Coldwell Banker Residential Brokerage

Last Buyer's Agent

Byron Loughridge

Byron Loughridge, Broker License #01442247

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $11,883

Year Built

  • Built in 1987

Lot Details

  • 3,485 Sq Ft Lot
  • Gated Home
  • Wood Fence
  • Level Lot
  • Back Yard Fenced
  • Zero Lot Line

Parking

  • 2 Car Garage
  • Garage Door Opener

Home Design

  • Traditional Architecture
  • Slab Foundation
  • Wood Frame Construction
  • Shingle Roof
  • Composition Roof

Interior Spaces

  • 1,474 Sq Ft Home
  • 2-Story Property
  • Beamed Ceilings
  • Vaulted Ceiling
  • Ceiling Fan
  • Wood Burning Fireplace
  • Double Pane Windows
  • Dining Area
  • Views of Hills

Kitchen

  • Eat-In Kitchen
  • Breakfast Bar
  • Double Self-Cleaning Oven
  • Electric Oven
  • Electric Cooktop
  • Range Hood
  • <<microwave>>
  • Plumbed For Ice Maker
  • Dishwasher
  • ENERGY STAR Qualified Appliances
  • Granite Countertops
  • Disposal

Flooring

  • Carpet
  • Tile
  • Vinyl

Bedrooms and Bathrooms

  • 3 Bedrooms
  • Granite Bathroom Countertops
  • Dual Sinks
  • Low Flow Shower

Laundry

  • Dryer
  • Washer

Pool

  • Cabana
  • Pool and Spa
  • In Ground Pool
  • Fence Around Pool

Outdoor Features

  • Deck
  • Gazebo
  • Shed
  • Barbecue Area

Utilities

  • Forced Air Heating and Cooling System
  • Vented Exhaust Fan
  • Heating System Uses Gas
  • Separate Meters
  • 220 Volts
  • Individual Gas Meter
  • Cable TV Available

Listing and Financial Details

  • Assessor Parcel Number 507-0797-051

Community Details

Overview

  • Property has a Home Owners Association
  • Association fees include common area electricity, common area gas, fencing, insurance - common area, maintenance - common area, maintenance - road, management fee, pool spa or tennis, reserves
  • Orchards Consolidated Homeowners Assn Association
  • Built by Orchards (single family condos)
  • The community has rules related to parking rules
  • Rental Restrictions

Amenities

  • Sauna

Recreation

  • Community Pool

Home Details

Home Type

Single Family

Est. Annual Taxes

$11,883

Year Built

Built in 1987

Lot Details

0

Parking

2

Listing Details

  • Subclass: Single Family Home
  • Style: Traditional
  • Restrictions: Park Rental Restrictions, Parking Restrictions
  • Age: 28
  • Listing Class: Residential
  • Min Numberof Unitsin Complex: 175
  • Structure Sq Ft: 1474
  • Complex Name: Orchards (single family condos)
  • Incorporated: Yes
  • Year Built: 1987
  • Zoning Description: P
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Family Room: No Family Room
  • Fireplace: Wood Burning
  • Dining Room: Breakfast Bar, Dining Area, Dining Bar, Eat in Kitchen
  • Kitchen: 220 Volt Outlet, Cooktop - Electric, Countertop - Granite, Dishwasher, Exhaust Fan, Garbage Disposal, Hood Over Range, Hookups - Ice Maker, Microwave, Oven - Double, Oven - Self Cleaning, Oven Range - Electric, Pantry, Pantry Cabinet
  • Living Sq Ft: 1474
  • Stories: 2
  • Laundry: Dryer, Hookup - Electric, Hookup - Washer/Dryer, Washer
  • Flooring: Carpet, Tile, Vinyl / Linoleum
  • Fireplaces Min: 1
  • Maximum Numberof Bedrooms: 3
  • Minimum Numberof Bedrooms: 3
  • Full Bathrooms: 2
  • Half Bathrooms: 1
  • Total Bedrooms: 3
  • Bathroom: Double Sinks, Granite
  • Fireplace: Yes

Exterior Features

  • Foundation: Concrete Slab, Wood Frame
  • Pool Description: Cabana / Dressing Room, Community Facility, Pool - Fenced, Pool - In Ground, Pool / Spa Combo, Spa / Hot Tub
  • Roof: Composition, Shingle
  • View: Hills
  • Yard/Grounds: Back Yard, BBQ Area, Deck, Fenced, Gazebo, Storage Shed / Structure
  • Pool: Yes
  • Fencing: Fenced, Fenced Back, Gate, Wood
  • Construction Type: Wood Frame

Garage/Parking

  • Garage Spaces: 2
  • Garage Max: 2
  • Garage Min: 2
  • Garage Parking Features: Attached Garage, Gate / Door Opener, Parking Restrictions

Utilities

  • Cooling System: Ceiling Fan, Central Forced Air - Gas
  • Heating System: Central Forced Air, Gas
  • Sewer/Septic System: Sewer - Public, Sewer Connected

Condo/Co-op/Association

  • HOA Fees: 70
  • HOA Amenities: Community Pool, Sauna / Spa / Hot Tub
  • Association Fees Include: Common Area Electricity, Common Area Gas, Fencing, Insurance - Common Area, Maintenance - Common Area, Maintenance - Road, Management Fee, Pool, Spa, or Tennis, Reserves
  • H O A Name Text: Orchards Consolidated Homeowners Assn
  • H O A Exist: Yes

Association/Amenities

  • Amenities Miscellaneous: High Ceiling, Open Beam Ceiling, Vaulted Ceiling

Schools

  • School District: Fremont Unified
  • Elementary School: Vallejo Mill Elementary
  • Middle School: Centerville Junior High
  • High School: Washington High
  • High School: 26875
  • Elementary School: 26900
  • Middle School: 26902

Lot Info

  • Lot Description: Grade - Level, Zero Lot Line
  • Parcel Number: 507-0797-051
  • Lot Acres: 0.0800
  • Lot Size Area Minimum Units: Square Feet
  • Minimum Lot Size: 3500.00
  • Lot Size Area Maximum Units: Square Feet
  • Maximum Lot Size: 3500.00

Green Features

  • Energy Features: Double Pane Windows, Energy Star Appliances, Low Flow Shower

Multi Family

  • Utilities: Individual Electric Meters, Individual Gas Meters, Public Utilities

MLS Schools

  • High School District Text: Fremont Unified
  • Elementary School Text: Vallejo Mill Elementary
  • High School Text: Washington High
  • Middle School Text: Centerville Junior High

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Apr 6, 2015
Closed on
May 12, 2015
Sold by
Lachance Ely Gary A and Lachance Ely Therese
Bought by
Ley Roman and Tsui Denise W
Seller's Agent
Lisa Blaylock
Coldwell Banker Residential Brokerage
Buyer's Agent
Byron Loughridge
Byron Loughridge, Broker
List Price
$785,888
Sold Price
$828,888
Premium/Discount to List
$43,000
5.47%
Current Estimated Value
$1,600,184

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$771,296
Avg. Annual Appreciation
6.70%
Original Mortgage
$663,110
Outstanding Balance
$517,980
Interest Rate
3.67%
Mortgage Type
New Conventional
Estimated Equity
$1,082,204
Source: Public Records

Range of Values:

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

Date Buyer Sale Price Title Company
Ley Roman $829,000 Cornerstone Title Company
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Ley Roman $663,110
Previous Owner Ely Gary A $60,000
Previous Owner Ely Gary A $30,000
Previous Owner Ely Gary A $10,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
05/20/2015 05/20/15 Sold $828,888 +5.5% $562 / Sq Ft
04/18/2015 04/18/15 Pending -- -- --
04/07/2015 04/07/15 For Sale $785,888 -5.2% $533 / Sq Ft
04/07/2015 04/07/15 Off Market $828,888 -- --
04/06/2015 04/06/15 For Sale $785,888 -- $533 / Sq Ft
Source: MLSListings

Tax History Compared to Growth

Source: Public Records

Tax History

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
2024 $11,883 $976,533 $329,910 $646,623
2023 $11,570 $957,388 $323,442 $633,946
2022 $11,427 $938,616 $317,100 $621,516
2021 $11,146 $920,216 $310,884 $609,332
2020 $11,197 $910,784 $307,697 $603,087
2019 $11,069 $892,932 $301,666 $591,266
2018 $10,855 $875,427 $295,752 $579,675
2017 $10,584 $858,263 $289,954 $568,309
2016 $10,409 $841,439 $284,270 $557,169
2015 $3,035 $219,139 $53,282 $165,857
2014 $2,973 $214,846 $52,238 $162,608
Source: Public Records

Agents Affiliated with this Home

  • L

    Seller's Agent in 2015

    Lisa Blaylock

    Coldwell Banker Residential Brokerage

    Section Image

  • B

    Buyer's Agent in 2015

    Byron Loughridge

    Byron Loughridge, Broker

See All Agents

Map

Source: MLSListings

MLS Number: ML81458562

MLSListings

APN: 507-0797-051-00

California Alameda County Fremont 94536 Cherry-Guardino

38854 Stillwater Common, Fremont, CA

This home is located at 38854 Stillwater Common, Fremont, CA 94536 since 06 April 2015 and is currently estimated at $1,600,184, approximately $1,085 per square foot. This property was built in 1987. 38854 Stillwater Common is a home located in Alameda County with nearby schools including Vallejo Mill Elementary School, Centerville Junior High School, and Washington High School.

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 © 2025 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