A 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.
Sold for $1,680,000
$1,680,000
5154 Waller Ave, Fremont, CA 94536
3beds
1,594sqft
Residential, Single Family Residence
Built in 1962
7,575 Square Feet Lot
$1,729,300 Zestimate®
$1,054/sqft
$4,181 Estimated rent
Home value
$1,729,300
$1.64M - $1.83M
$4,181/mo
Zestimate® history
Owner options
List your home for rent
$4,181/mo
Rent Zestimate®
Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.
$4,181/mo
Rent Zestimate®
Refinance and save
$10,711/mo
Est. payment
Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.
$10,711/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
Zillow last checked:
Listing updated:
Listed by:
Aimee Ran Song DRE #01951402 510-990-9999,
Coldwell Banker Realty
Bought with:
Anna Marie Adams, DRE #02106032
Compass
Source: Bay East AOR,MLS#: 41040809
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 3
- Bathrooms: 2
- Full bathrooms: 2
Rooms
- Room types: 3 Bedrooms, 2 Baths, Primary Bedrm Suite - 1, Main Entry, Dining Room, Family Room, Dining Area, Kitchen, Living Room, Primary Bathroom, Primary Bedroom
Bathroom
- Features: Shower Over Tub, Updated Baths, Stall Shower, Tile, Double Vanity, Window
Kitchen
- Features: Counter - Stone, Dishwasher, Eat In Kitchen, Garbage Disposal, Gas Range/Cooktop, Ice Maker Hookup, Range/Oven Free Standing, Updated Kitchen
Heating
- Forced Air
Cooling
- None
Appliances
- Included: Dishwasher, Gas Range, Plumbed For Ice Maker, Free-Standing Range
- Laundry: Hookups Only, In Garage, Common Area
Features
- Updated Kitchen
- Flooring: Vinyl
- Basement: Crawl Space
- Number of fireplaces: 1
- Fireplace features: Family Room, Wood Burning
Interior area
- Total structure area: 1,594
- Total interior livable area: 1,594 sqft
Property
Parking
- Total spaces: 2
- Parking features: Garage Door Opener
- Attached garage spaces: 2
Features
- Levels: One
- Stories: 1
- Patio & porch: Patio
- Exterior features: Garden/Play
- Pool features: None, Community
- Fencing: Fenced
Lot
- Size: 7,575 Square Feet
- Features: Back Yard, Front Yard, Side Yard
Details
- Parcel number: 5312129
- Zoning: R1
- Special conditions: Standard
- Other equipment: Irrigation Equipment
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Contemporary
- Property subtype: Residential, Single Family Residence
Materials
- Stucco
- Roof: Composition
Condition
- Existing
- New construction: No
- Year built: 1962
Utilities & green energy
- Utilities for property: Natural Gas Available, Individual Electric Meter, Individual Gas Meter
Green energy
- Energy efficient items: Thermostat
Community & HOA
Community
- Security: Carbon Monoxide Detector(s), Double Strapped Water Heater
- Subdivision: Glenmoor Gardens
HOA
- Has HOA: Yes
- Amenities included: Greenbelt, Pool, Tennis Court(s), BBQ Area
- Services included: Common Area Maint, Management Fee
- HOA fee: $30 monthly
- HOA name: GLENMOOR GARDENS HOA
- HOA phone: 510-797-7600
Location
- Region: Fremont
Financial & listing details
- Price per square foot: $1,054/sqft
- Tax assessed value: $1,713,600
- Price range: $1.7M - $1.7M
- Date on market: 10/17/2023
- Listing agreement: Excl Right
- Listing terms: Cash,Conventional
Price history
| Date | Event | Price |
|---|---|---|
| 11/2/2023 | Sold | $1,680,000+5.7%$1,054/sqft |
Source:  Bay East AOR #41040809 Report a problem | ||
| 10/25/2023 | Pending sale | $1,590,000$997/sqft |
Source:  bridgeMLS/CCAR/Bay East AOR #41040809 Report a problem | ||
| 10/17/2023 | Listed for sale | $1,590,000+156.5%$997/sqft |
Source: bridgeMLS/CCAR/Bay East AOR #41040809 Report a problem | ||
| 5/11/2010 | Sold | $620,000+3.5%$389/sqft |
Source: Bay East AOR #40460377 Report a problem | ||
| 4/11/2010 | Listed for sale | $598,800-0.2%$376/sqft |
Source: NRT California #81017232 Report a problem | ||
| 3/28/2005 | Sold | $600,000$376/sqft |
Source: Public Record Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | -- | $1,713,600 +2% |
| 2024 | $19,851 +111.9% | $1,680,000 +118.4% |
| 2023 | $9,369 +1.3% | $769,184 +2% |
| 2022 | $9,245 +2.5% | $754,105 +2% |
| 2021 | $9,018 -0.2% | $739,324 +1% |
| 2020 | $9,037 +1.2% | $731,748 +2% |
| 2019 | $8,934 +4.6% | $717,401 +2% |
| 2018 | $8,539 | $703,340 +2% |
| 2017 | $8,539 +1.7% | $689,551 +2% |
| 2016 | $8,392 +3.1% | $676,034 +1.5% |
| 2015 | $8,136 | $665,885 +2% |
| 2014 | $8,136 | $652,847 +10.7% |
| 2013 | -- | $590,000 +5.4% |
| 2012 | -- | $560,000 -3.4% |
| 2011 | -- | $580,000 +6.4% |
| 2010 | -- | $545,000 +4% |
| 2009 | -- | $524,000 -17.7% |
| 2008 | -- | $636,720 +2% |
| 2007 | -- | $624,240 +2% |
| 2006 | -- | $612,000 +822.9% |
| 2005 | -- | $66,313 +2% |
| 2004 | -- | $65,014 +1.9% |
| 2003 | -- | $63,823 +2% |
| 2002 | -- | $62,570 +2% |
| 2001 | $906 | $61,344 |
Find assessor info on the county website
Neighborhood: Glenmoor
Nearby homes
- $1,784,6004 bd2 ba1.6k sqft5146 Waller Ave, Fremont, CA 94536Off Market
- $1,674,9003 bd2 ba1.6k sqft5162 Waller Ave, Fremont, CA 94536Off Market
- $1,624,9003 bd2 ba1.7k sqft5155 Selma Ave, Fremont, CA 94536Off Market
- $1,554,8003 bd2 ba1.3k sqft5163 Selma Ave, Fremont, CA 94536Off Market
- $1,662,2003 bd2 ba1.7k sqft5147 Selma Ave, Fremont, CA 94536Off Market
- $1,679,4003 bd2 ba1.7k sqft5170 Waller Ave, Fremont, CA 94536Off Market
- $1,629,2003 bd2 ba1.5k sqft5138 Waller Ave, Fremont, CA 94536Off Market
- $1,655,0003 bd2 ba1.3k sqft5157 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.1 mi
- 7/10John F. Kennedy High SchoolGrades: 9-12Distance: 1.1 mi
Schools provided by the listing agent
- District: Fremont (510) 657-2350
Source: Bay East AOR. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.
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,729,300
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,729,300
- California
- Alameda County
- Fremont
- 94536
- Glenmoor
- 5154 Waller Ave
Nearby cities
Nearby neighborhoods
Nearby zip codes
Other Fremont Topics
