One of the most desirable homes in the Glenmoor neighborhood, this well-maintained single-story residence offers a bright, open floor plan with 3 bedrooms and 2 remodeled bathrooms. Features include dual-pane windows, vaulted ceilings, recessed lighting, ceiling fans, skylights, central A/C, and a combination of laminate flooring and carpet. The open kitchen features granite countertops, stainless steel appliances, and is perfect for everyday living and entertaining. This home has been extremely well maintained and offers a spacious, inviting atmosphere. The beautiful backyard includes mature fruit trees and a covered pergola, ideal for relaxing or hosting gatherings. Conveniently located with easy access to I-880, I-680, and the Dumbarton Bridge. Close to BART, ACE Train, shopping centers, and Centerville Station—making commuting simple and efficient.
Sold for $1,655,000
$1,655,000
5157 Waller Ave, Fremont, CA 94536
3beds
1,384sqft
Residential, Single Family Residence
Built in 1962
7,000 Square Feet Lot
$1,655,600 Zestimate®
$1,196/sqft
$4,055 Estimated rent
Home value
$1,655,600
$1.51M - $1.82M
$4,055/mo
Zestimate® history
Owner options
List your home for rent
$4,055/mo
Rent Zestimate®
Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.
$4,055/mo
Rent Zestimate®
Refinance and save
$11,224/mo
Est. payment
Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.
$11,224/mo
Est. payment
Explore your selling options
Work with a Zillow partner agent
Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.
Get startedList with your own agent
Get your home in front of millions of buyers by listing it on Zillow.
Learn how to do itSell it yourself
Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).
List your homeWhat's special
Mature fruit treesOpen kitchenWell-maintained single-story residenceSpacious inviting atmosphereBeautiful backyardBright open floor planStainless steel appliances
Zillow last checked:
Listing updated:
Listed by:
Kurshed Deen DRE #01312517 Off:510-744-3500,
Legacy Real Estate & Assoc.
Bought with:
Atma Dayal, DRE #01156463
Kiru Real Estate Inc
Source: Bay East AOR,MLS#: 41135707
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 3
- Bathrooms: 2
- Full bathrooms: 2
Rooms
- Room types: 3 Bedrooms, Family Room, Dining Room
Kitchen
- Features: 220 Volt Outlet, Stone Counters, Tile Counters, Dishwasher, Eat-in Kitchen, Gas Range/Cooktop, Microwave, Refrigerator, Skylight(s)
Heating
- Forced Air
Cooling
- Ceiling Fan(s), Central Air
Appliances
- Included: Dishwasher, Gas Range, Microwave, Refrigerator, Gas Water Heater
- Laundry: Hookups Only, In Garage
Features
- Formal Dining Room
- Flooring: Laminate, Tile, Carpet
- Windows: Double Pane Windows, Skylight(s)
- Number of fireplaces: 1
- Fireplace features: Family Room, Wood Burning
Interior area
- Total structure area: 1,384
- Total interior livable area: 1,384 sqft
Property
Parking
- Total spaces: 2
- Parking features: Attached, Garage Door Opener
- Garage spaces: 2
Accessibility
- Accessibility features: Other
Features
- Levels: One
- Stories: 1
- Pool features: None, Community
Lot
- Size: 7,000 Square Feet
- Features: Level, Sprinklers In Rear, Back Yard, Front Yard, Side Yard
Details
- Parcel number: 531280
- Special conditions: Standard
- Other equipment: Irrigation Equipment
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Ranch
- Property subtype: Residential, Single Family Residence
Materials
- Composition Shingles, Stone, Stucco
- Roof: Composition
Condition
- Existing
- New construction: No
- Year built: 1962
Utilities & green energy
- Electric: No Solar, 220 Volts in Kitchen
- Sewer: Public Sewer
- Water: Public
Community & HOA
Community
- Subdivision: Glenmoor Area
HOA
- Has HOA: Yes
- Amenities included: Greenbelt, Playground, Pool, Tennis Court(s)
- Services included: None
- HOA fee: $540 annually
- HOA name: GLENMOOR GARDENS HOA
- HOA phone: 510-797-7600
Location
- Region: Fremont
Financial & listing details
- Price per square foot: $1,196/sqft
- Tax assessed value: $861,824
- Price range: $1.7M - $1.7M
- Date on market: 5/26/2026
- Listing agreement: Excl Right
- Listing terms: Cash,Conventional
- Electric utility on property: Yes
Price history
| Date | Event | Price |
|---|---|---|
| 6/28/2026 | Sold | $1,655,000+3.4%$1,196/sqft |
Source:  Bay East AOR #41135707 Report a problem | ||
| 6/4/2026 | Pending sale | $1,599,888$1,156/sqft |
Source: Bay East AOR #41135707 Report a problem | ||
| 5/26/2026 | Listed for sale | $1,599,888+6.7%$1,156/sqft |
Source: Bay East AOR #41135707 Report a problem | ||
| 9/30/2021 | Sold | $1,500,000+97.9%$1,084/sqft |
Source: Bay East AOR #40964521 Report a problem | ||
| 9/7/2007 | Sold | $758,000+33%$548/sqft |
Source: Bay East AOR #40288040 Report a problem | ||
| 9/14/2006 | Sold | $570,000$412/sqft |
Source: Public Record Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | -- | $861,824 +2% |
| 2024 | $10,313 +2.6% | $844,930 +2% |
| 2023 | $10,052 +0.7% | $828,368 +2% |
| 2022 | $9,986 -9.7% | $812,125 -11.7% |
| 2021 | $11,062 -0.4% | $919,779 +1% |
| 2020 | $11,111 +1.2% | $910,350 +2% |
| 2019 | $10,982 +4.6% | $892,507 +2% |
| 2018 | $10,498 | $875,012 +2% |
| 2017 | $10,498 +9.9% | $857,858 +10.7% |
| 2016 | $9,550 +18.6% | $775,000 +11.5% |
| 2015 | $8,055 | $695,000 +7.6% |
| 2014 | $8,055 | $646,000 +18.5% |
| 2013 | -- | $545,000 +1.9% |
| 2012 | -- | $535,000 -1.8% |
| 2011 | -- | $545,000 +15% |
| 2010 | -- | $474,000 -17.6% |
| 2009 | -- | $575,000 -24.1% |
| 2008 | -- | $758,000 +33% |
| 2007 | -- | $570,000 +381.6% |
| 2006 | -- | $118,347 +2% |
| 2005 | -- | $116,027 +2% |
| 2004 | -- | $113,752 +1.9% |
| 2003 | -- | $111,669 +2% |
| 2002 | -- | $109,479 +2% |
| 2001 | $1,383 | $107,332 |
Find assessor info on the county website
Neighborhood: Glenmoor
Nearby homes
- $1,688,2003 bd2 ba1.7k sqft5165 Waller Ave, Fremont, CA 94536Off Market
- $2,036,3004 bd3 ba1.9k sqft5149 Waller Ave, Fremont, CA 94536Off Market
- $1,592,1004 bd2 ba1.7k sqft5150 Vernon Ave, Fremont, CA 94536Off Market
- $1,743,8003 bd2 ba2k sqft5158 Vernon Ave, Fremont, CA 94536Off Market
- $1,840,5004 bd2 ba1.7k sqft5142 Vernon Ave, Fremont, CA 94536Off Market
- $1,651,7003 bd2 ba1.4k sqft5173 Waller Ave, Fremont, CA 94536Off Market
- $1,630,1003 bd2 ba1.4k sqft5141 Waller Ave, Fremont, CA 94536Off Market
- $1,680,0003 bd2 ba1.5k sqft5154 Waller Ave, Fremont, CA 94536Sold
Nearby schools
GreatSchools rating
- 8/10John G. Mattos Elementary SchoolGrades: K-5Distance: 0.4 mi
- 8/10G. M. Walters Middle SchoolGrades: 6-8Distance: 1.2 mi
- 7/10John F. Kennedy High SchoolGrades: 9-12Distance: 1.1 mi
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$1,655,600
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$1,655,600
- California
- Alameda County
- Fremont
- 94536
- Glenmoor
- 5157 Waller Ave
Nearby cities
Nearby neighborhoods
Nearby zip codes
Other Fremont Topics
