Home | Alameda County | Fremont | 94536 | 38240 Garrett St
MLS: BE41063388 | Status: Sold | Price: $1,860,113
Beds/Baths: 3 / 2
Property Type: Residential
| Beds | Baths | Sq Ft | Sq Ft Lot | Yr Built |
|---|---|---|---|---|
| 3 | 2 | 1,665 | 9,960 | 1957 |
Introducing a gorgeous home tucked into the highly sought-after Glenmoor neighborhood! This single-story home has an ideal layout designed to entertain one day and find solace the next. This rare Glenmoor floor plan includes a formal living room overlooking the idyllic yard, spacious bedrooms and a large open concept space that opens the formal dining area to the kitchen and family room! This home is filled with quality details throughout including freshly painted interiors, newly installed LVP flooring, plush carpeting, copper plumbing, dual-pane Milgard windows and strategically placed skylights that allow the natural light to flood in. Luxurious primary suite has a perfect view of the yard and a private updated bathroom. Versatile mud room equipped with a washer, dryer, sink & storage. Beautifully landscaped yards! Escape to the huge picturesque backyard with a durable Trex deck, lush lawn and various delicious fruit trees! This home is in an excellent location, close to Glenmoor’s community parks, playgrounds, tennis court/pickleball courts and pools. Perfect for commuters, nearby 880, Dumbarton Bridge, BART and Centerville Station. Walking distance to great schools, shopping and local eateries! You’re sure to love all this well-loved home has to offer!
| Field | Value |
|---|---|
| MLS # | BE41063388 |
| MLS Source | Bay East |
| Feature | Details |
|---|---|
| Kitchen | Breakfast Bar, Countertop - Tile |
| Appliances | Cooktop - Electric, Dishwasher, Garbage Disposal, Oven - Built-In, Refrigerator, Dryer, Washer |
| Dining Room | Dining Area |
| Family Room | Separate Family Room |
| Fireplace | Family Room, Gas Burning |
| Flooring | Carpet - Wall to Wall, Tile, Vinyl |
| Laundry | In Laundry Room |
| Cooling | Ceiling Fan |
| Heating | Forced Air |
| Feature | Details |
|---|---|
| Roof | Composition |
| Pool | Community Facility, Membership Fee |
| Style | Ranch |
| Feature | Details |
|---|---|
| Garage/Parking | Attached Garage, Garage, Garage: 2 Car(s) |
| Sewer | Public Sewer |
| Water | Public |
| HOA Fee | $36 |
| HOA Fee Frequency | Monthly |
| Complex Amenities | Community Pool, Garden / Greenbelt/ Trails, Playground |
Lester Belliveau
Coldwell Banker Realty
License #: 00997558
Phone: (510) 608-7620
School data provided by GreatSchools.org
| School | Type | Grades | Distance | Rating |
|---|---|---|---|---|
| Tom Maloney Elementary School | public | TK,KG,1,2,3,4,5 | 0.27 mi | 7 |
| Glenmoor Elementary School | public | K-6 | 0.31 mi | 8 |
| Washington High School | public | 9-12 | 0.47 mi | 9 |
| Centerville Middle School | public | 6-8 | 0.55 mi | 8 |
| John G. Mattos Elementary School | public | K-5 | 0.85 mi | 8 |
| Young Adult Program | public | 9-12 | 0.92 mi | N/A |
| Thornton Middle School | public | 6-8 | 0.94 mi | 9 |
| Fremont Adult | public | UG | 0.95 mi | N/A |
| Glankler Early Learning Center | public | KG | 1.08 mi | N/A |
| Brier Elementary School | public | TK,KG,1,2,3,4,5 | 1.09 mi | 5 |
| Oliveira Elementary School | public | TK,KG,1,2,3,4,5 | 1.16 mi | 8 |
| Cabrillo Elementary School | public | K-5 | 1.20 mi | 4 |
| G. M. Walters Middle School | public | 6-8 | 1.28 mi | 8 |
| Joseph Azevada Elementary School | public | TK,KG,1,2,3,4,5 | 1.28 mi | 7 |
| Parkmont Elementary School | public | TK,KG,1,2,3,4,5 | 1.35 mi | 9 |
| American High School | public | 9-12 | 1.40 mi | 10 |
| Birch Grove Intermediate | public | 3,4,5 | 1.47 mi | 7 |
| Brookvale Elementary School | public | TK,KG,1,2,3,4,5 | 1.56 mi | 7 |
| John F. Kennedy High School | public | 9-12 | 1.58 mi | 7 |
| Birch Grove Primary | public | KG,1,2 | 1.58 mi | N/A |
©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 April 23, 2025. For the most current information, please contact Lester Belliveau, (510) 608-7620.