Sign up to get new listings emailed daily! JOIN SIGN IN
Theresa Carroll, DRE#01890268, REALTOR®
(720) 530-5098

5157 Waller Ave, Fremont, CA 94536

$1,599,888
  • 5157 Waller Ave, Fremont, CA 94536 Main Photo

34 Total Photos [Click to View All]

Active
BEDS3 BATHS2 full SQUARE FEET1,384 MLS#41135707
STATUSActive PROPERTY TYPEResidential - Single Family SUBDIVISIONGLENMOOR AREA

Listing Courtesy of: Legacy Real Estate & Assoc.
Agency Phone: 510-744-3500
Associate Name: Kurshed Deen
IDX logo


Listing Shown by: Farrell Smyth, Inc.
Associate Name: Theresa Carroll, DRE#01890268, REALTOR®


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.

5157 Waller Ave | MLS# 41135707

This single family home located at 5157 Waller Ave, Fremont, CA 94536 is currently listed for sale with an asking price of $1,599,888. This property was built in 1962 and has 3 bedrooms and 2 full baths with 1384 sq. ft. Waller Ave is located in the GLENMOOR AREA subdivision. Search GLENMOOR AREA real estate on theresacarroll.farrellsmyth.com today.

Property Features

Property Type: Residential - Single Family
Cooling: CentralAir
Garage: 2 car attached
Heating: ForcedAir
Home Style: Ranch
Lot Size: 0.16 Acres
Roof Type: Shingle
Stories: 1.0
Year Built: 1962

Amenities

EatInKitchen

Feature Descriptions

Accessibility: Other
Appliances: GasWaterHeater
Association Amenities: Playground, Pool, TennisCourts
Days on Site: 8
Exterior: Stone, Stucco
Fireplace: FamilyRoom, WoodBurning
Flooring: Carpet, Laminate, Tile
HOA Fee: 540/ Annually
Lot: BackYard, FrontYard, SprinklersInRear, SprinklersInFront, SprinklersTimer, StreetLevel, Yard
Parcel#: 531280
Parking: Garage, GarageDoorOpener
Parking Notes: Garage, GarageDoorOpener
Pool: None, Association

Listed By / Shown By

Listed By

Agency Name: Legacy Real Estate & Assoc.
Agent Name: Kurshed Deen
Agency Phone: 510-744-3500

agent picture

Shown By

Agent Name: Theresa Carroll, DRE#01890268, REALTOR®
Agent Phone: (720) 530-5098
Agency Title: Farrell Smyth, Inc.

IDX logo

Estimate Your Payment

Estimated Payment

$ 4,027.29 per month $3,560.66 Principal & Interest $0.00 Property Tax (data not provided by mls) $466.63 Homeowner's Insurance

Change Payment Information

%
years/fixed
yearly
yearly (est.)
(Payments are an estimate and may vary by lender)
Disclaimer: All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided for consumers personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information on this site was last updated 06/03/2026. The listing information on this page last changed on 06/03/2026. The data relating to real estate for sale on this website comes in part from the Internet Data Exchange program of Delta Media Group MLS (last updated Wed 06/03/2026 12:01:35 AM EST) or CRMLS (last updated Tue 06/02/2026 12:29:10 PM EST). Real estate listings held by brokerage firms other than Farrell Smyth, Inc. may be marked with the Internet Data Exchange logo and detailed information about those properties will include the name of the listing broker(s) when required by the MLS. All rights reserved.
Privacy Policy / DMCA Notice / ADA Accessibility

Login to My Homefinder

Pixel