This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
1/1
$1,655,000
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
1/1
Property Description
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.
Full Property Details
Full Property Details for 5157 Waller Ave
General
- Sold For: $1,655,000
- HOA FEE: $45/month
- HOA FEE FREQ.: Annually
- Status: Closed
- Type: Single Family
- Source: MAX
- MLS ID: 41135707
- Added to Site: 47 day(s) ago
Interior
- Number of Rooms: 6
- Interior Features: Family Room, Formal Dining Room
- Number of Fireplaces: 1
- Fireplace(s): Family Room, Wood Burning
- Appliances: Dishwasher, Gas Range, Microwave, Refrigerator, Gas Water Heater
- Flooring: Laminate, Tile, Carpet
Rooms
Bathrooms
- Total Bathrooms: 2
- Full Bathrooms: 2
Bedrooms
- Total Bedrooms: 3
Other Rooms
- Kitchen: 220-Volt Outlet, Stone Counters, Tile Counters, Dishwasher, Eat-in Kitchen, Gas Range/Cooktop, Microwave, Refrigerator, Skylight(s)
- Laundry: Hookups Only, In Garage
Additional Information
- Shared Amenities: Greenbelt, Playground, Pool, Tennis Court(s)
- Pool: Yes
- Pool Description: None, Community
Exterior
- Exterior Features: Back Yard, Front Yard, Side Yard, Sprinklers Automatic, Sprinklers Front
Parking
- Attached garage: Yes
- Garage Spaces: 2
- Parking Features: Attached, Garage Door Opener
Location
- Area: Listing
- County: Alameda
- Subdivision: Glenmoor Area
- Driving Directions: Farwell- Waller.
Community
- Association: Yes
- Assoc. Name: GLENMOOR GARDENS HOA
Heating & Cooling
- Central air: Yes
- Cooling Type: Ceiling Fan(s), Central Air
- Heating Type: Forced Air
Utilities
- Sewer: Public Sewer
- Water: Public
Structural Information
- Architectural Style: Ranch
- Exterior Const.: Composition Shingles, Stone, Stucco
- Roof: Composition Shingles
- Windows: Double Pane Windows, Skylight(s)
- Stories/Levels: One Story
- Living Area: 1,384 Sq. Ft.
- Year Built: 1962
Lot Features
- Lot Size (Acres): 0.16
- Lot Dimensions: 7000
- Lot Features: Level, Sprinklers In Rear
Financial Considerations
- For Sale: Yes
- Price Per Sq. Ft.: $1,156
- Association Fee: $540
- Assoc Fee Freq.: Annually
Disclosures and Reports
- Property ID: 531280
Listed by Legacy Real Estate & Assoc., Kurshed Deen
Sold by Kiru Real Estate Inc, Atma Dayal
Get Pre-Approved Today
Schools
Schools serving 5157 Waller Ave
School District:Fremont Unified School District
| Name | Grades | Distance |
|---|---|---|
John G. Mattos Elementary School 37944 Farwell Drive, Fremont, CA 94536 | K-6 | 0.4 mi |
G. M. Walters Middle School 39600 Logan Drive, Fremont, CA 94538 | 7-8 | 1.1 mi |
John F. Kennedy High School, Fremont, CA 39999 Blacow Road, Fremont, CA 94538 | 9-12 | 1.1 mi |
Disclaimer:
School attendance boundaries provided by ATTOM Data Solutions and are for reference only. Contact the school directly to verify enrollment eligibility.
Price & Sales History for 5157 Waller Ave
Date
Details
Price
Change
Source
6/28/2026
Sold
$1,655,000
3.44%
MLS
5/26/2026
Listed
$1,599,888
—
MLS
Disclaimer: Historical sales information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.
5157 Waller Ave, Fremont, CA 94536 (MLS# 41135707) is a Single Family property that was sold at $1,655,000 on June 28, 2026. Want to learn more about 5157 Waller Ave? Do you have questions about finding other Single Family real estate for sale in Fremont? You can browse all Fremont real estate or contact a Coldwell Banker agent to request more information.

