$1,599,888
1,384
SQ FT
$1,156
SQ/FT
5157 Waller Ave
@ Farwell - Glenmoor Area, Fremont
- 3 Bed
- 2 Bath
- 2 Park
- 1,384 sqft
- Fremont
-
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.
- Current Status
- Active - Coming Soon
- Original Price
- $1,599,888
- List Price
- $1,599,888
- On Market Date
- May 22, 2026
- Property Type
- Detached
- D/N/S
- Glenmoor Area
- Zip Code
- 94536
- MLS ID
- 41135707
- APN
- 531280
- Year Built
- 1962
- Stories in Building
- 1
- Possession
- Immediate
- Data Source
- MAXEBRDI
- Origin MLS System
- BAY EAST
John G. Mattos Elementary School
Public K-6 Elementary
Students: 607 Distance: 0.4mi
Stellar Academy For Dyslexics
Private 2-8 Special Education, Elementary, Coed
Students: 25 Distance: 0.5mi
Glenmoor Elementary School
Public K-6 Elementary
Students: 663 Distance: 0.6mi
Tom Maloney Elementary School
Public K-6 Elementary
Students: 589 Distance: 0.6mi
Circle of Independent Learning School
Charter K-12 Combined Elementary And Secondary, Home School Program
Students: 368 Distance: 0.7mi
Young Adult Program
Public 9-12
Students: 41 Distance: 0.7mi
- Bed
- 3
- Bath
- 2
- Parking
- 2
- Attached, Garage Door Opener
- SQ FT
- 1,384
- SQ FT Source
- Public Records
- Lot SQ FT
- 7,000.0
- Lot Acres
- 0.16 Acres
- Pool Info
- None, Community
- Kitchen
- Dishwasher, Gas Range, Microwave, Refrigerator, Gas Water Heater, 220 Volt Outlet, Stone Counters, Tile Counters, Eat-in Kitchen, Gas Range/Cooktop, Skylight(s)
- Cooling
- Ceiling Fan(s), Central Air
- Disclosures
- None
- Entry Level
- Exterior Details
- Back Yard, Front Yard, Side Yard, Sprinklers Automatic, Sprinklers Front
- Flooring
- Laminate, Tile, Carpet
- Foundation
- Fire Place
- Family Room, Wood Burning
- Heating
- Forced Air
- Laundry
- Hookups Only, In Garage
- Main Level
- 3 Bedrooms
- Possession
- Immediate
- Architectural Style
- Ranch
- Construction Status
- Existing
- Additional Miscellaneous Features
- Back Yard, Front Yard, Side Yard, Sprinklers Automatic, Sprinklers Front
- Location
- Level, Sprinklers In Rear
- Roof
- Composition Shingles
- Water and Sewer
- Public
- Fee
- $540
MLS and other Information regarding properties for sale as shown in Theo have been obtained from various sources such as sellers, public records, agents and other third parties. This information may relate to the condition of the property, permitted or unpermitted uses, zoning, square footage, lot size/acreage or other matters affecting value or desirability. Unless otherwise indicated in writing, neither brokers, agents nor Theo have verified, or will verify, such information. If any such information is important to buyer in determining whether to buy, the price to pay or intended use of the property, buyer is urged to conduct their own investigation with qualified professionals, satisfy themselves with respect to that information, and to rely solely on the results of that investigation.
School data provided by GreatSchools. School service boundaries are intended to be used as reference only. To verify enrollment eligibility for a property, contact the school directly.

