Home | Alameda County | Fremont | 94536 | 5209 Waller Ave
MLS: BE41101893 | Status: Sold | Price: $1,390,000
Beds/Baths: 3 / 2
Property Type: Residential
| Beds | Baths | Sq Ft | Sq Ft Lot | Yr Built |
|---|---|---|---|---|
| 3 | 2 | 1,320 | 7,000 | 1962 |
The one you've been waiting for! This wonderful Glenmoor home has been owned by the same family since 1964! It rests on a quiet treelined street and has beautiful curb appeal with a newer hardscape driveway and more...Some things about this original home are still tastefully present including: gleaming hardwood floors, wood accented interior walls, doors and trim! Forced air heat, Central Air Conditioning, dual pane windows and doors. It's been beautifully maintained and now offers an opportunity for a new family to further improve it to their satisfaction! This lovely home rests on a 7000 square foot lot and is close to the Dumbarton Bridge, Highway 880, schools, shopping and more... Must see today!
| Field | Value |
|---|---|
| MLS # | BE41101893 |
| MLS Source | Bay East |
| Feature | Details |
|---|---|
| Bathrooms | Primary - Tile, Tub |
| Kitchen | Countertop - Tile, Hookups - Ice Maker |
| Appliances | Cooktop - Electric, Dishwasher, Oven Range - Built-In |
| Dining Room | Dining Area |
| Family Room | Separate Family Room |
| Fireplace | Family Room, Gas Starter, Insert, Wood Burning |
| Flooring | Carpet - Wall to Wall, Hardwood, Linoleum, Tile |
| Laundry | In Garage |
| Cooling | Central -1 Zone |
| Heating | Forced Air |
| Feature | Details |
|---|---|
| Foundation | Raised, Crawl Space |
| Pool | Community Facility, None |
| Style | Ranch |
| Feature | Details |
|---|---|
| Garage/Parking | Access - Interior, Attached Garage, Garage, Gate/Door Opener, Garage: 2 Car(s) |
| Sewer | Public Sewer |
| Water | Public |
| HOA Fee | $518 |
| HOA Fee Frequency | Annually |
| Complex Amenities | Community Pool, Garden / Greenbelt/ Trails, Playground |
| Listing Agent | Co-Listing Agent |
|---|---|
| Thomas Cree | Mikayla Cree |
| Legacy Real Estate & Assoc. | Legacy Real Estate & Assoc. |
| License #: 01001074 | License #: 02236676 |
| Phone: (510) 853-5737 | Phone: (510) 507-4988 |
School data provided by GreatSchools.org
| School | Type | Grades | Distance | Rating |
|---|---|---|---|---|
| John G. Mattos Elementary School | public | K-5 | 0.40 mi | 8 |
| Glenmoor Elementary School | public | K-6 | 0.58 mi | 7 |
| Tom Maloney Elementary School | public | TK,KG,1,2,3,4,5 | 0.74 mi | 7 |
| Joseph Azevada Elementary School | public | TK,KG,1,2,3,4,5 | 0.74 mi | 7 |
| Birch Grove Primary | public | KG,1,2 | 0.79 mi | N/A |
| Young Adult Program | public | 9-12 | 0.80 mi | N/A |
| Fremont Adult | public | UG | 0.81 mi | N/A |
| Birch Grove Intermediate | public | 3,4,5 | 0.93 mi | 7 |
| Newark Memorial High School | public | 9-12 | 1.11 mi | 6 |
| Glankler Early Learning Center | public | KG | 1.11 mi | N/A |
| John F. Kennedy High School | public | 9-12 | 1.15 mi | 7 |
| Brier Elementary School | public | TK,KG,1,2,3,4,5 | 1.16 mi | 4 |
| G. M. Walters Middle School | public | 6-8 | 1.19 mi | 7 |
| Washington High School | public | 9-12 | 1.26 mi | 9 |
| Mission Valley Rocp School | public | 9-12 | 1.32 mi | N/A |
| Centerville Middle School | public | 6-8 | 1.41 mi | 8 |
| Cabrillo Elementary School | public | K-5 | 1.41 mi | 4 |
| Thornton Middle School | public | 6-8 | 1.48 mi | 9 |
| Oliveira Elementary School | public | TK,KG,1,2,3,4,5 | 1.75 mi | 7 |
| John Blacow Elementary School | public | TK,KG,1,2,3,4,5 | 1.77 mi | 7 |
©2026 Bay East. All rights reserved. All data, including all measurements and calculations of area, is obtained from various sources and has not been, and will not be, verified by broker or MLS. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information. Information provided is for personal, non-commercial use by the viewer and may not be redistributed without explicit authorization from Bay East.
Presently MLSListings.com displays Active, Contingent, Pending, and Recently Sold listings. Recently Sold listings are properties which were sold within the last three years. After that period listings are no longer displayed in MLSListings.com. Pending listings are properties under contract and no longer available for sale. Contingent listings are properties where there is an accepted offer, and seller may be seeking back-up offers. Active listings are available for sale.
This listing information is up-to-date as of July 30, 2025. For the most current information, please contact Thomas Cree, (510) 853-5737.