Seller's Agent in 2023
Aimee Ran Song
Coldwell Banker Realty
(510) 990-9999
5 in this area
200 Total Sales
5154 Waller Ave Fremont, CA 94536
Glenmoor NeighborhoodEstimated Value: $1,686,000 - $1,800,000
3
Beds
2
Baths
1,594
Sq Ft
$1,088/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
Date
Name
Owned For
Owner Type
Purchase Details
Closed on
Oct 17, 2025
Sold by
Lingam Chandramohan Gowri Mahendran and Lingam Arun Kumar
Bought by
Gowrisunitha Family Trust and Chandramohan
Current Estimated Value
Purchase Details
Listed on
Oct 17, 2023
Closed on
Oct 26, 2023
Sold by
Xu Shanshan
Bought by
Chandramohan Gowri Mahendran Li and Kumar Managa Sunitha
Seller's Agent
Aimee Ran Song
Coldwell Banker Realty
Buyer's Agent
Anna Marie Adams
Compass
List Price
$1,590,000
Sold Price
$1,680,000
Premium/Discount to List
$90,000
5.66%
Views
318
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.35%
Purchase Details
Closed on
Jun 23, 2020
Sold by
Fang Jin
Bought by
Xu Shanshan
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
Delvalle Neal J
Bought by
Fang Jin and Xu Shanshan
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
Reid Winifred T and Winifred T Reid Revocable Trus
Bought by
Delvalle Neal J
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
Reid Winifred T
Bought by
Reid Winifred T and Winifred T Reid Revocable Trus
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 |
|---|---|---|---|
| Gowrisunitha Family Trust | -- | None Listed On Document | |
| Chandramohan Gowri Mahendran Li | $1,680,000 | Chicago Title | |
| Xu Shanshan | -- | Chicago Title Company | |
| Fang Jin | $630,000 | Chicago Title Company | |
| Delvalle Neal J | $600,000 | Ticor Title Company Of Ca | |
| Reid Winifred T | -- | -- |
Source: Public Records
Mortgage History
| Date | Status | Borrower | Loan Amount |
|---|---|---|---|
| Previous Owner | Xu Shanshan | $388,000 | |
| Previous Owner | Fang Jin | $480,000 | |
| Previous Owner | Delvalle Neal J | $410,000 |
Source: Public Records
Property History
| 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
| 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
3 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
- 5172 Selma Ave
- 5332 Selma Ave
- 38465 Blacow Rd
- 5229 Sabin Ave
- 5502 Higo Way
- 5516 Higo Way
- 38509 Amaranto St
- 5513 Higo Way
- 38539 Amaranto St
- 38515 Amaranto St
- 5550 Higo Way
- 38445 Amaranto St
- 38463 Amaranto St
- 38809 Judie Way
- 38403 Amaranto St
- 38427 Cedar Blvd
- 5659 Daylily St
- 5604 Pandorea Terrace
- 5724 Pandorea Terrace
- 38393 Amaryllis Place
- 5162 Waller Ave
- 5146 Waller Ave
- 5155 Selma Ave
- 5163 Selma Ave
- 5147 Selma Ave
- 5170 Waller Ave
- 5138 Waller Ave
- 5157 Waller Ave
- 5165 Waller Ave
- 5171 Selma Ave
- 5149 Waller Ave
- 5139 Selma Ave
- 5173 Waller Ave
- 5178 Waller Ave
- 5130 Waller Ave
- 5141 Waller Ave
- 5179 Selma Ave
- 5131 Selma Ave
- 5150 Vernon Ave
- 5181 Waller Ave
Your Personal Tour Guide
Ask me questions while you tour the home.