Seller's Agent in 2025
Aimee Ran Song
Coldwell Banker Realty
(510) 990-9999
9 in this area
197 Total Sales
581 Lambert Terrace Fremont, CA 94536
Cherry-Guardino NeighborhoodEstimated Value: $1,138,582 - $1,273,000
3
Beds
2.5
Baths
1,591
Sq Ft
$774/Sq Ft
Est. Value
Highlights
- Updated Kitchen
- Contemporary Architecture
- Corner Lot
- Vallejo Mill Elementary School Rated A-
- End Unit
- Stone Countertops
About This Home
As of February 2025This bright 3-bedroom, 2.5-bathroom townhome sits on a prime corner lot with a northwest-facing entrance. Step into a radiant living room with vaulted ceilings, creating a welcoming ambiance. A gas fireplace adds warmth. The home offers central heating & AC with a smart system and direct access to a two-car garage for convenience. The updated kitchen boasts sleek granite countertops and stainless steel appliances, including a gas range, dishwasher, and brand-new refrigerator. A spacious family room is perfect for entertaining. A rare find, this home features a private yard, patio, and balcony—ideal for outdoor gatherings. The master suite includes a walk-in closet and double-sink vanity. An upstairs laundry room and storage solutions enhance organization. Low HOA – $195. Fresh paint, recessed lighting & double-pane windows. Minutes from Apple, Google, Meta shuttles, BART, Elizabeth Park, hospital & major freeways (680, 880, 84). Don’t miss out!
Last Agent to Sell the Property
Coldwell Banker Realty License #01951402 Listed on: 01/29/2025
Townhouse Details
Home Type
- Townhome
Year Built
- Built in 2008
Lot Details
- 1,880 Sq Ft Lot
- End Unit
- Fenced
- Back Yard
HOA Fees
- $195 Monthly HOA Fees
Parking
- 2 Car Attached Garage
- Garage Door Opener
- Guest Parking
Home Design
- Contemporary Architecture
- Entry on the 1st floor
- Shingle Roof
- Stucco
Interior Spaces
- 2-Story Property
- Gas Fireplace
- Double Pane Windows
- Window Screens
- Family Room Off Kitchen
Kitchen
- Updated Kitchen
- Gas Range
- Free-Standing Range
- Plumbed For Ice Maker
- Kitchen Island
- Stone Countertops
- Disposal
Flooring
- Carpet
- Laminate
- Tile
Bedrooms and Bathrooms
- 3 Bedrooms
Laundry
- Laundry on upper level
- Dryer
- Washer
Home Security
Utilities
- Forced Air Heating and Cooling System
- Gas Water Heater
Listing and Financial Details
- Assessor Parcel Number 507798230
Community Details
Overview
- Association fees include exterior maintenance, management fee, reserves, ground maintenance
- 13 Units
- Association Phone (530) 562-4430
- Cherry Guardino Subdivision
- Greenbelt
Security
- Carbon Monoxide Detectors
- Fire and Smoke Detector
- Fire Sprinkler System
Matterport 3D Tour
Ownership History
Date
Name
Owned For
Owner Type
Purchase Details
Listed on
Jan 29, 2025
Closed on
Feb 11, 2025
Sold by
Shah Vivek S and Tamhane Dhara Kishore
Bought by
Kolhapur Siri Raju and Bharadwaj Rohit
Seller's Agent
Aimee Ran Song
Coldwell Banker Realty
Buyer's Agent
Aliya Mody
Intero Real Estate Services
List Price
$1,148,000
Sold Price
$1,261,000
Premium/Discount to List
$113,000
9.84%
Views
26
Current Estimated Value
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
-$28,854
Avg. Annual Appreciation
-2.48%
Original Mortgage
$1,008,800
Outstanding Balance
$1,000,111
Interest Rate
6.88%
Mortgage Type
New Conventional
Estimated Equity
$232,035
Purchase Details
Closed on
Jun 13, 2019
Sold by
Bai Mo
Bought by
Shah Vivek Sunilbhai and Tamhane Dhara Kishore
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$716,800
Interest Rate
2.87%
Mortgage Type
Adjustable Rate Mortgage/ARM
Purchase Details
Closed on
Oct 19, 2015
Sold by
Zhao Anna
Bought by
Bai Mo
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$420,000
Interest Rate
5.37%
Mortgage Type
Adjustable Rate Mortgage/ARM
Purchase Details
Closed on
Sep 23, 2015
Sold by
Cheuk Antonio S H and Cheuk Judy S
Bought by
Bai Mo
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$420,000
Interest Rate
5.37%
Mortgage Type
Adjustable Rate Mortgage/ARM
Purchase Details
Closed on
Jul 18, 2013
Sold by
Antonio S H Cheuk Llc
Bought by
Cheuk Antonio S H and Cheuk Judy S
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$319,100
Interest Rate
3.87%
Mortgage Type
Adjustable Rate Mortgage/ARM
Purchase Details
Closed on
Apr 22, 2008
Sold by
Green Cherry Commons Llc
Bought by
Antonio S H Cheuk Llc
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$420,000
Interest Rate
5.88%
Mortgage Type
Negative Amortization
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
| Date | Buyer | Sale Price | Title Company |
|---|---|---|---|
| Kolhapur Siri Raju | $1,261,000 | Chicago Title | |
| Shah Vivek Sunilbhai | $896,000 | Fidelity National Title Co | |
| Bai Mo | -- | First American Title Company | |
| Bai Mo | $720,000 | First American Title Company | |
| Cheuk Antonio S H | $319,500 | First American Title Company | |
| Antonio S H Cheuk Llc | $560,000 | Chicago Title Company |
Source: Public Records
Mortgage History
| Date | Status | Borrower | Loan Amount |
|---|---|---|---|
| Open | Kolhapur Siri Raju | $1,008,800 | |
| Previous Owner | Shah Vivek Sunilbhai | $716,800 | |
| Previous Owner | Bai Mo | $420,000 | |
| Previous Owner | Cheuk Antonio S H | $319,100 | |
| Previous Owner | Antonio S H Cheuk Llc | $420,000 |
Source: Public Records
Property History
| Date | Event | Price | List to Sale | Price per Sq Ft |
|---|---|---|---|---|
| 02/24/2025 02/24/25 | Sold | $1,261,000 | +9.8% | $793 / Sq Ft |
| 02/05/2025 02/05/25 | Pending | -- | -- | -- |
| 01/29/2025 01/29/25 | For Sale | $1,148,000 | -- | $722 / Sq Ft |
Source: Bay East Association of REALTORS®
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 |
|---|---|---|---|---|
| 2025 | $11,816 | $996,752 | $299,846 | $703,906 |
| 2024 | $11,816 | $977,073 | $293,967 | $690,106 |
| 2023 | $11,506 | $964,781 | $288,204 | $676,577 |
| 2022 | $11,367 | $938,867 | $282,554 | $663,313 |
| 2021 | $11,091 | $920,321 | $277,014 | $650,307 |
| 2020 | $11,141 | $917,820 | $274,176 | $643,644 |
| 2019 | $9,424 | $764,063 | $229,219 | $534,844 |
| 2018 | $9,240 | $749,087 | $224,726 | $524,361 |
| 2017 | $9,009 | $734,400 | $220,320 | $514,080 |
| 2016 | $8,856 | $720,000 | $216,000 | $504,000 |
| 2015 | $7,378 | $586,487 | $176,456 | $410,031 |
| 2014 | $7,259 | $575,000 | $173,000 | $402,000 |
Source: Public Records
Agents Affiliated with this Home
-
Aimee Ran Song
-
Bob Lewis
Seller Co-Listing Agent in 2025
Bob Lewis
Coldwell Banker Realty
(510) 502-8893
3 in this area
56 Total Sales
-
Aliya Mody
Buyer's Agent in 2025
Aliya Mody
Intero Real Estate Services
(408) 781-6103
2 in this area
115 Total Sales
-
Sergio Quintero
Buyer Co-Listing Agent in 2025
Sergio Quintero
Realty Masters & Associates
(909) 562-9488
1 in this area
8 Total Sales
-
P
Buyer Co-Listing Agent in 2025
Pauline Nguyen
IRA
Map
Source: Bay East Association of REALTORS®
MLS Number: 41082259
APN: 507-0798-230-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.
Bay East ©2026. CCAR ©2026. bridgeMLS ©2026. Information Deemed Reliable But Not Guaranteed. This information is being provided by the Bay East MLS, or CCAR MLS, or bridgeMLS. The listings presented here may or may not be listed by the Broker/Agent operating this website. This information is intended for the personal use of consumers and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.
Nearby Homes
- 38623 Cherry Ln Unit 201
- 38623 Cherry Ln Unit 203
- 38614 Royal Ann Common
- 976 Huntington Terrace
- 952 Cherry Glen Terrace
- 111 Overacker Terrace
- 38555 Overacker Ave
- 39034 Guardino Dr Unit 206
- 38581 Aventura Terrace
- 38751 Litchfield Cir
- 18 Gazania Terrace
- 39059 Guardino Dr Unit 206
- 2 Morrison Canyon Rd
- 4 Morrison Canyon Rd
- 3 Morrison Canyon Rd
- 39149 Guardino Dr Unit 247
- 39199 Guardino Dr Unit 179
- 39199 Guardino Dr Unit 371
- 38524 Burdette Common
- 159 Quiancy Terrance
- 575 Lambert Terrace
- 561 Lambert Terrace
- 38686 Stonington Terrace
- 38698 Stonington Terrace
- 553 Lambert Terrace
- 580 Lambert Terrace
- 38708 Stonington Terrace
- 570 Lambert Terrace
- 562 Lambert Terrace
- 38723 Cherry Ln
- 38714 Stonington Terrace
- 527 Bing
- 38720 Stonington Terrace
- 38725 Cherry Ln
- 665 Ridgeview Terrace
- 38733 Cherry Ln
- 615 Saddleback Terrace
- 33840 Stonington Terrace
- 38737 Cherry Ln
- 605 Saddleback Terrace