Cheyenne Celestine

5133 Waller Ave , Fremont, CA 94536

$2,275,000
  • 5133 Waller Ave , Fremont, CA 94536 Main Photo

48 Total Photos [Click to View All]

New to the Market Pending
BEDS4 BATHS3 full SQUARE FEET2,071 MLS#41136975
STATUSPending PROPERTY TYPEResidential - Single Family SUBDIVISIONGLENMOOR

Listing Courtesy of: The Agency
Agency Phone: 925-575-8000
Associate Name: Mark Kennedy
IDX logo


Listing Shown by: Farrell Smyth, Inc.
Associate Name: Cheyenne Celestine


Property Description

Beautifully expanded and updated single-story home in the highly sought-after Glenmoor neighborhood offers the perfect blend of comfort, style, and functionality. Step inside to discover a fabulous open-concept floor plan where the kitchen, dining, and family room seamlessly flow together?ideal for both everyday living and entertaining. The heart of the home features a bright white kitchen with elegant stone counters, stainless steel appliances, and an abundance of cabinetry. Tucked away for maximum privacy, the primary suite boasts vaulted ceilings and serves as a peaceful retreat, completely separate from the main living areas and other bedrooms. The three additional bedrooms include a versatile guest suite, while two bedrooms share a spacious hall bathroom. All bathrooms have been tastefully updated with stylish vanities, flooring, and modern showers. Owned Solar! Electricity bill near zero monthly. Outside, enjoy a flat, usable backyard perfect for relaxation and play. A covered pergola provides shaded outdoor living space, complemented by a large lawn area, a spacious storage shed, and generous side yards with room for additional storage or hobbies. Located in one of Fremonts most desirable pockets, this home offers unbeatable convenience with quick access to I-880, I-680, and the Dumbarton Bridge. Youre also just minutes from BART and the ACE Train, as well as top-rated schools, parks, and shopping. Meticulously updated and move-in ready, this Glenmoor gem is a rare find.

5133 Waller Ave | MLS# 41136975

This single family home located at 5133 Waller Ave , Fremont, CA 94536 is currently listed for sale with an asking price of $2,275,000. This property was built in 1970 and has 4 bedrooms and 3 full baths with 2071 sq. ft. Waller Ave is located in the GLENMOOR subdivision. Search GLENMOOR real estate on ccelestine.farrellsmyth.com today.

Property Features

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

Amenities

EatInKitchen

Feature Descriptions

Association Amenities: Playground, Pool, TennisCourts
Exterior: Stucco
Fireplace: FamilyRoom
Flooring: Carpet, Tile, Vinyl
HOA Fee: 515/ Annually
Lot: BackYard, FrontYard, Secluded, SprinklersTimer, StreetLevel
Parcel#: 531277
Parking: Garage, GarageDoorOpener
Parking Notes: Garage, GarageDoorOpener
Pool: None, Association

Listed By / Shown By

Listed By

Agency Name: The Agency
Agent Name: Mark Kennedy
Agency Phone: 925-575-8000

agent picture

Shown By

Agent Name: Cheyenne Celestine
Agent Phone: (805) 543-2636 ext. 16
Agency Title: Farrell Smyth, Inc.

IDX logo

Estimate Your Payment

Estimated Payment

$ 5,726.71 per month $5,063.16 Principal & Interest $0.00 Property Tax (data not provided by mls) $663.54 Homeowner's Insurance

Change Payment Information

%
years/fixed
yearly
yearly (est.)
(Payments are an estimate and may vary by lender)

Login to My Homefinder

Pixel