5157 Waller Ave

$1,599,888 1,384 SQ FT
$1,156 SQ/FT

5157 Waller Ave

@ Farwell - Glenmoor Area, Fremont

Map direct
  • 3 Bed
  • 2 Bath
  • 2 Park
  • 1,384 sqft
  • Fremont
  • Payment calculator
DTCH
  • Favorite
  • Hide
Message Samantha Bohlke

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
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.

Listings © 2026 Paragon MLS

Copyright © 2026 Theo Inc. All Rights Reserved