Seller's Agent in 2023
Aimee Ran Song
Coldwell Banker Realty
(510) 990-9999
5 in this area
188 Total Sales
5154 Waller Ave Fremont, CA 94536
Glenmoor NeighborhoodEstimated Value: $1,672,000 - $1,840,198
3
Beds
2
Baths
1,594
Sq Ft
$1,101/Sq Ft
Est. Value
Highlights
- Updated Kitchen
- Contemporary Architecture
- Community Pool
- John G. Mattos Elementary School Rated A
- Stone Countertops
- Tennis Courts
About This Home
As of November 2023A stunning single family nestled in the highly sought-after, well-established, family-friendly and tree-lined streets Glenmoor neighborhood of Fremont. This charming single-story home boasts 3 beds 2 baths, 1594 sqft, 7575 sqft lot. offering a wonderful backyard space for outdoor activities, gardening, or simply soaking up the California sunshine. It is a perfect blend of comfort, style, and functionality. As you step inside, you'll be greeted by a spacious and inviting floor plan. This home has a separate living room and family room, providing ample space for relaxation and entertainment. The newly updated kitchen is a true standout, featuring modern quartz countertops, white maple cabinets, and brand-new stainless-steel appliances. Whether you're a seasoned chef or just love to cook, this kitchen is sure to inspire your culinary adventures. Other fine features include a newly painted interior and exterior, new light fixtures, paid off /owned solar system, and new flooring throughout. Glenmoor Garden offers 2 swimming pools, parks, tennis courts, a basketball court & and more (membership optional). Easy commute location close to HWY 880 Dumbarton Bridge. This property offers a perfect opportunity to experience the ideal Fremont lifestyle. Don't miss out on this beautiful home.
Last Agent to Sell the Property
Coldwell Banker Realty License #01951402 Listed on: 10/17/2023
Home Details
Home Type
- Single Family
Year Built
- Built in 1962
Lot Details
- 7,575 Sq Ft Lot
- Rectangular Lot
- Front Yard Sprinklers
- Garden
- Back Yard Fenced and Front Yard
- Property is zoned R1
HOA Fees
- $30 Monthly HOA Fees
Parking
- 2 Car Attached Garage
- Garage Door Opener
Home Design
- Contemporary Architecture
- Shingle Roof
- Stucco
Interior Spaces
- 1-Story Property
- Wood Burning Fireplace
- Double Pane Windows
- Family Room with Fireplace
- Dining Area
- Vinyl Flooring
Kitchen
- Updated Kitchen
- Eat-In Kitchen
- Gas Range
- Free-Standing Range
- Plumbed For Ice Maker
- Dishwasher
- Stone Countertops
- Disposal
Bedrooms and Bathrooms
- 3 Bedrooms
- 2 Full Bathrooms
Laundry
- Laundry in Garage
- Washer and Dryer Hookup
Home Security
- Carbon Monoxide Detectors
- Fire and Smoke Detector
Utilities
- No Cooling
- Forced Air Heating System
- Thermostat
- Gas Water Heater
Listing and Financial Details
- Assessor Parcel Number 5312129
Community Details
Overview
- Association fees include common area maintenance, management fee
- Glenmoor Gardens HOA, Phone Number (510) 797-7600
- Glenmoor Gardens Subdivision
- Greenbelt
Amenities
- Community Barbecue Grill
Recreation
- Tennis Courts
- Community Pool
- Community Spa
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
Oct 17, 2025
Sold by
Bought by
Current Estimated Value
Purchase Details
Listed on
Oct 17, 2023
Closed on
Oct 26, 2023
Sold by
Bought by
Seller's Agent
Aimee Ran Song
Coldwell Banker Realty
Buyer's Agent
Anna Marie Adams
Keller Williams Realty
List Price
$1,590,000
Sold Price
$1,680,000
Premium/Discount to List
$90,000
5.66%
Views
315
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
1.67%
Purchase Details
Closed on
Jun 23, 2020
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
$388,000
Interest Rate
3.1%
Mortgage Type
New Conventional
Purchase Details
Closed on
May 6, 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
$480,000
Interest Rate
4.94%
Mortgage Type
New Conventional
Purchase Details
Closed on
Mar 23, 2005
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
$410,000
Interest Rate
5.62%
Mortgage Type
Purchase Money Mortgage
Purchase Details
Closed on
Aug 3, 1998
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 | ||
| $1,680,000 | Chicago Title | ||
| -- | Chicago Title Company | ||
| $630,000 | Chicago Title Company | ||
| $600,000 | Ticor Title Company Of Ca | ||
| -- | -- |
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 | $388,000 | ||
| Previous Owner | $480,000 | ||
| Previous Owner | $410,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 |
|---|---|---|---|---|
| 02/04/2025 02/04/25 | Off Market | $1,680,000 | -- | -- |
| 11/02/2023 11/02/23 | Sold | $1,680,000 | +5.7% | $1,054 / Sq Ft |
| 10/25/2023 10/25/23 | Pending | -- | -- | -- |
| 10/02/2023 10/02/23 | For Sale | $1,590,000 | -- | $997 / Sq Ft |
Source: Bay East Association of REALTORS®
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 | $19,851 | $1,713,600 | $685,440 | $1,028,160 |
| 2024 | $19,851 | $1,680,000 | $672,000 | $1,008,000 |
| 2023 | $9,369 | $762,184 | $230,755 | $538,429 |
| 2022 | $9,245 | $747,105 | $226,231 | $527,874 |
| 2021 | $9,018 | $732,324 | $221,797 | $517,527 |
| 2020 | $9,037 | $731,748 | $219,524 | $512,224 |
| 2019 | $8,934 | $717,401 | $215,220 | $502,181 |
| 2018 | $8,759 | $703,340 | $211,002 | $492,338 |
| 2017 | $8,539 | $689,551 | $206,865 | $482,686 |
| 2016 | $8,392 | $676,034 | $202,810 | $473,224 |
| 2015 | $8,279 | $665,885 | $199,765 | $466,120 |
| 2014 | $8,136 | $652,847 | $195,854 | $456,993 |
Source: Public Records
Agents Affiliated with this Home
-
Aimee Ran Song
-
Anna Marie Adams
Buyer's Agent in 2023
Anna Marie Adams
Compass
(925) 642-9994
4 in this area
33 Total Sales
Map
Source: Bay East Association of REALTORS®
MLS Number: 41040809
APN: 531-0002-129-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
- 5216 Selma Ave
- 5133 Waller Ave
- 5266 Troy Ave
- 5157 Eggers Dr
- 5352 Selma Ave
- 5346 Brophy Dr
- 4943 Whitfield Ave
- 38811 Bonnie Way
- 38509 Amaranto St
- 5513 Higo Way
- 38539 Amaranto St
- 38515 Amaranto St
- 38533 Amaranto St
- 38521 Amaranto St
- 38475 Amaranto St
- 38451 Amaranto St
- 38439 Amaranto St
- 38463 Amaranto St
- 38373 Amaranto St
- 38409 Amaranto St
Your Personal Tour Guide
Ask me questions while you tour the home.