Home | Alameda County | Fremont | 94536 | 5172 Selma Ave
MLS: ML82039298 | Status: Active | Price: $2,288,000
Beds/Baths: 4 / 4
Property Type: Residential
| Beds | Baths | Sq Ft | Sq Ft Lot | Yr Built |
|---|---|---|---|---|
| 4 | 4 | 2,609 | 8,025 | 1962 |
Architectural Masterpiece with Expansive Living in Glenmoor. This beautifully upgraded home blends space, functionality, and timeless design. Fully remodeled in 2013, it offers quality improvements throughout and a flexible, highly desirable layout. Featuring 4 bedrooms, 4 bathrooms, and two spacious living areas, the home offers approx. 2,600+ sq ft of living space on an expansive 8,025 sq ft lot. Soaring ceilings, including a 10-ft front living room and 12-ft rear family room, create a bright, open atmosphere. The well-appointed kitchen features GE 36" appliances and flows seamlessly into the dining and living areas, ideal for everyday living and entertaining. Three en-suite bedrooms provide flexibility for multi-generational living or guests. The oversized primary suite includes a spacious bathroom and walk-in closet, designed for comfort and privacy. Additional upgrades include updated electrical and plumbing systems, an EV charger, and a water filtration system. The backyard offers a private, garden-like setting with abundant fruit trees on a generous lot. Don't miss this thoughtfully designed and meticulously built home!
| Field | Value |
|---|---|
| MLS # | ML82039298 |
| MLS Source | MLSListings, Inc. |
| Days on Site | 5 |
| Feature | Details |
|---|---|
| Dining Room | Formal Dining Room |
| Family Room | Kitchen/Family Room Combo, Separate Family Room |
| Fireplace | Family Room |
| Cooling | Central Forced Air |
| Heating | Central Forced Air |
| Feature | Details |
|---|---|
| Roof | Composition |
| Foundation | Crawl Space |
| Feature | Details |
|---|---|
| Garage/Parking | Attached Garage, Garage: 2 Car(s) |
| Elementary District | Fremont Unified |
| High School District | Fremont Unified |
| Sewer | Public Sewer |
| Water | Public |
| HOA Fee | $44 |
| HOA Fee Frequency | Monthly |
| Zoning | R11 |
Celine Song
Coldwell Banker Realty
License #: 01914600
Phone: (415) 613-5099
School data provided by GreatSchools.org
| School | Type | Grades | Distance | Rating |
|---|---|---|---|---|
| John G. Mattos Elementary School | public | K-5 | 0.49 mi | 8 |
| Glenmoor Elementary School | public | K-6 | 0.58 mi | 7 |
| Joseph Azevada Elementary School | public | TK,KG,1,2,3,4,5 | 0.66 mi | 7 |
| Tom Maloney Elementary School | public | TK,KG,1,2,3,4,5 | 0.70 mi | 7 |
| Young Adult Program | public | 9-12 | 0.71 mi | N/A |
| Fremont Adult | public | UG | 0.72 mi | N/A |
| Birch Grove Primary | public | KG,1,2 | 0.86 mi | N/A |
| Birch Grove Intermediate | public | 3,4,5 | 1.02 mi | 7 |
| Glankler Early Learning Center | public | KG | 1.02 mi | N/A |
| John F. Kennedy High School | public | 9-12 | 1.07 mi | 7 |
| Brier Elementary School | public | TK,KG,1,2,3,4,5 | 1.07 mi | 4 |
| Newark Memorial High School | public | 9-12 | 1.09 mi | 6 |
| G. M. Walters Middle School | public | 6-8 | 1.10 mi | 7 |
| Washington High School | public | 9-12 | 1.22 mi | 9 |
| Mission Valley Rocp School | public | 9-12 | 1.23 mi | N/A |
| Centerville Middle School | public | 6-8 | 1.40 mi | 8 |
| Cabrillo Elementary School | public | K-5 | 1.48 mi | 4 |
| Thornton Middle School | public | 6-8 | 1.52 mi | 9 |
| John Blacow Elementary School | public | TK,KG,1,2,3,4,5 | 1.68 mi | 7 |
| Oliveira Elementary School | public | TK,KG,1,2,3,4,5 | 1.79 mi | 7 |
| Address | Price | Beds | Baths | Sq Ft | Status |
|---|---|---|---|---|---|
| 4347 San Juan Ave | $1,899,000 | 5 | 2 | 1,872 | Active |
| 38236 Kimbro St | $2,499,000 | 5 | 3 | 2,527 | Active |
| 38048 Palmer Dr | $2,389,950 | 4 | 2/1 | 2,006 | Active |
| 4759 Valpey Park Ave | $2,699,888 | 4 | 4 | 2,369 | Active |
| 38393 Amaryllis Pl | $2,230,000 | 5 | 3 | 2,708 | Active |
©2026 MLSListings Inc. 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 MLSListings Inc.
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 March 30, 2026. For the most current information, please contact Celine Song, (415) 613-5099.