Seller's Agent in 2016
Aimee Ran Song
Coldwell Banker Realty
(510) 990-9999
5 in this area
191 Total Sales
574 Calistoga Cir Fremont, CA 94536
Niles NeighborhoodEstimated Value: $1,728,000 - $2,071,000
4
Beds
3
Baths
2,083
Sq Ft
$912/Sq Ft
Est. Value
Highlights
- Mountain View
- Contemporary Architecture
- Wood Flooring
- Niles Elementary School Rated A
- Vaulted Ceiling
- Solid Surface Bathroom Countertops
About This Home
As of December 2016Gorgeous upscale newer SFH in Fremont's exclusive NILES neighborhood within a secluded loop and NO HOA! This rare GREYSTONE home sports 4 beds,3 full baths,2 car garage,2,083 sqft of living space,4,989 sqft corner lot. It offers one bedroom and a full bath downstairs. Bright formal living and dining rooms have dramatic vaulted ceilings to indulge you in massive natural light. Quality Brazilian Cherry hardwood floors through out entire downstairs. Cozy family room next to kitchen for your intimate social gatherings. Exquisite kitchen with granite counter tops and abundant cabinets plus large pantry. Big master bedroom with beautiful view of the hills. Many quality fine features:double pane windows, new light fixtures,updated kitchen and baths. Beautiful curb appeal! Quiet private backyard provides relaxation from the everyday demands of the Bay Area life.Award Winning Niles Elementary School.This stunning home features beautiful architecture with elegant layout and excellent condition.
Last Agent to Sell the Property
Coldwell Banker Realty License #01951402 Listed on: 11/08/2016
Home Details
Home Type
- Single Family
Year Built
- Built in 1993
Lot Details
- 5,009 Sq Ft Lot
- Fenced
- Sprinklers on Timer
- Grass Covered Lot
- Back Yard
- Zoning described as PD
Parking
- 2 Car Attached Garage
- Garage Door Opener
Home Design
- Contemporary Architecture
- Slab Foundation
- Wood Frame Construction
- Tile Roof
Interior Spaces
- 2,083 Sq Ft Home
- 2-Story Property
- Vaulted Ceiling
- Gas Fireplace
- Formal Dining Room
- Mountain Views
Kitchen
- Open to Family Room
- Eat-In Kitchen
- Oven or Range
- Gas Cooktop
- Dishwasher
- Granite Countertops
- Disposal
Flooring
- Wood
- Carpet
- Tile
- Vinyl
Bedrooms and Bathrooms
- 4 Bedrooms
- Walk-In Closet
- Remodeled Bathroom
- 3 Full Bathrooms
- Solid Surface Bathroom Countertops
- Granite Bathroom Countertops
- Dual Sinks
- Bathtub with Shower
- Bathtub Includes Tile Surround
- Walk-in Shower
Laundry
- Laundry Room
- Washer and Dryer Hookup
Outdoor Features
- Shed
Utilities
- Forced Air Heating and Cooling System
- Vented Exhaust Fan
Listing and Financial Details
- Assessor Parcel Number 507-0805-009
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
Dec 21, 2025
Sold by
Bought by
Current Estimated Value
Purchase Details
Closed on
Aug 13, 2021
Sold by
Bought by
Purchase Details
Listed on
Nov 8, 2016
Closed on
Dec 13, 2016
Sold by
Bought by
Seller's Agent
Aimee Ran Song
Coldwell Banker Realty
Buyer's Agent
Stephanie Zhou
Keller Williams Tri-Valley
List Price
$1,068,888
Sold Price
$1,128,888
Premium/Discount to List
$60,000
5.61%
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
5.64%
Original Mortgage
$903,000
Interest Rate
3.5%
Mortgage Type
Adjustable Rate Mortgage/ARM
Purchase Details
Closed on
Nov 21, 2014
Sold by
Bought by
Purchase Details
Closed on
May 20, 2013
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
$335,000
Interest Rate
3.92%
Mortgage Type
New Conventional
Purchase Details
Closed on
Apr 29, 2013
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
$335,000
Interest Rate
3.92%
Mortgage Type
New Conventional
Purchase Details
Closed on
May 8, 2012
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
$347,000
Interest Rate
3.98%
Mortgage Type
New Conventional
Purchase Details
Closed on
Aug 16, 2011
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
$358,000
Interest Rate
4.48%
Mortgage Type
New Conventional
Purchase Details
Closed on
Nov 4, 2010
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
$368,000
Interest Rate
4.27%
Mortgage Type
New Conventional
Purchase Details
Closed on
Sep 15, 2009
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
$386,000
Interest Rate
5.3%
Mortgage Type
New Conventional
Purchase Details
Closed on
Aug 4, 2009
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
$386,000
Interest Rate
5.3%
Mortgage Type
New Conventional
Purchase Details
Closed on
Oct 6, 2006
Sold by
Bought by
Purchase Details
Closed on
Apr 5, 2006
Sold by
Bought by
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
Average Home Value in this Area
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 Listed On Document | ||
| -- | None Listed On Document | ||
| -- | None Listed On Document | ||
| $1,129,000 | Fidelity National Title Co | ||
| -- | None Available | ||
| -- | Chicago Title Company | ||
| -- | Chicago Title Company | ||
| -- | Old Republic Title Company | ||
| -- | Fidelity National Title Co | ||
| -- | None Available | ||
| -- | Old Republic Title Company | ||
| -- | None Available | ||
| -- | Stewart Title Of California | ||
| $795,000 | Fidelity National Title Co | ||
| -- | None Available |
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 |
|---|---|---|---|
| Previous Owner | $903,000 | ||
| Previous Owner | $335,000 | ||
| Previous Owner | $347,000 | ||
| Previous Owner | $358,000 | ||
| Previous Owner | $368,000 | ||
| Previous Owner | $386,000 |
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 |
|---|---|---|---|---|
| 12/20/2016 12/20/16 | Sold | $1,128,888 | +5.6% | $542 / Sq Ft |
| 11/18/2016 11/18/16 | Pending | -- | -- | -- |
| 11/08/2016 11/08/16 | For Sale | $1,068,888 | -- | $513 / 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 | $15,447 | $1,310,040 | $580,280 | $729,760 |
| 2024 | $15,447 | $1,284,359 | $568,905 | $715,454 |
| 2023 | $15,048 | $1,259,176 | $557,750 | $701,426 |
| 2022 | $14,874 | $1,234,489 | $546,815 | $687,674 |
| 2021 | $14,507 | $1,210,288 | $536,095 | $674,193 |
| 2020 | $14,607 | $1,197,882 | $530,600 | $667,282 |
| 2019 | $14,439 | $1,174,403 | $520,200 | $654,203 |
| 2018 | $14,162 | $1,151,376 | $510,000 | $641,376 |
| 2017 | $13,811 | $1,128,800 | $500,000 | $628,800 |
| 2016 | $11,080 | $899,271 | $269,781 | $629,490 |
| 2015 | $10,938 | $885,771 | $265,731 | $620,040 |
| 2014 | $9,771 | $785,000 | $235,500 | $549,500 |
Source: Public Records
Agents Affiliated with this Home
-
Aimee Ran Song
-
Bob Lewis
Seller Co-Listing Agent in 2016
Bob Lewis
Coldwell Banker Realty
(510) 502-8893
4 in this area
55 Total Sales
-
Stephanie Zhou
S
Buyer's Agent in 2016
Stephanie Zhou
Keller Williams Tri-Valley
(925) 963-1468
57 Total Sales
Map
Source: MLSListings
MLS Number: ML81630564
APN: 507-0805-009-00
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.
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
- 395 Sandstone Dr
- 263 Sandstone Dr
- 366 Sunnyslope Dr
- 34777 Klondike Ct
- 34761 Klondike Dr
- 34341 Sandburg Dr
- 165 Aurora Plaza
- 150 Aurora Plaza
- 310 Grau Dr
- 35520 Monterra Terrace Unit 302
- 35510 Monterra Terrace Unit 201
- 1055 Green St Unit 314
- 237 Galano Plaza Unit 106
- 35530 Monterra Terrace Unit 303
- 35540 Monterra Terrace Unit 101
- 35509 Monterra Terrace Unit 201
- 272 Galano Plaza Unit 115
- 263 Famoso Plaza
- 267 Famoso Plaza
- 439 Niles Common
Your Personal Tour Guide
Ask me questions while you tour the home.