Mario Sharvini
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
Listing Shown by:
Farrell Smyth, Inc.
Associate Name: Mario Sharvini
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.
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
Shown By
Agent Name: Mario Sharvini
Agent Phone: (805) 439-2547 ext. 26
Agency Title: Farrell Smyth, Inc.
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 InsuranceChange Payment Information
Privacy Policy / DMCA Notice / ADA Accessibility
This site is hosted, designed and copyright
© 1994 - 2026 by
Delta Media Group, Inc. -- Patent Pending --
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 msharvini.farrellsmyth.com today.