Home | Alameda County | Fremont | 94538 | 40161 Kelly St
MLS: ML82039429 | Status: Active | Price: $1,549,000
Beds/Baths: 4 / 2 /1
Property Type: Residential
| Beds | Baths | Sq Ft | Sq Ft Lot | Yr Built |
|---|---|---|---|---|
| 4 | 2 /1 | 1,556 | 6,000 | 1957 |
| Date | Time | Hosted By |
|---|---|---|
| Saturday, April 4 | 1:30 pm - 4:30 pm | Yating Zhou |
| Sunday, April 5 | 1:30 pm - 4:30 pm | Yating Zhou |
Beautifully Maintained Home in the Heart of Fremont! Nestled in a well-established and peaceful neighborhood, this home stands out for its exceptional care and quality. With excellent insulation, you'll enjoy year-round comfort and energy efficiency. Prime Location: Short walk to Durham Elementary School, Central Park, the library, and restaurants. Perfect for families and those who love an active lifestyle. Spacious & Practical Layout: Featuring 4 bedrooms and 2.5 bathrooms, the home is filled with natural light and enhanced by skylights, creating a warm and inviting atmosphere throughout. Ample Parking: Enjoy plenty of parking space, making gatherings and visits easy and stress-free. Family-Friendly & Multi-Generational Living: Ideal for raising a family, and perfectly suited for parents or grandparents to visit or live comfortably. Outdoor Oasis: The backyard offers space for outdoor enjoyment, gardening, and future possibilities. Mature fruit trees add beauty and charm. Convenience: Close to parks, schools, shopping, and dining, with easy access to major commuter routes and BART. This is more than just a house, it's a welcoming home ready for your next chapter. Whether you're looking to move right in, personalize to your taste, or invest, this home offers a rare opportunity.
| Field | Value |
|---|---|
| MLS # | ML82039429 |
| MLS Source | MLSListings, Inc. |
| Days on Site | 15 |
| Feature | Details |
|---|---|
| Kitchen | Countertop - Solid Surface / Corian, Skylight(s) |
| Appliances | Cooktop - Electric, Dishwasher, Garbage Disposal, Refrigerator |
| Dining Room | Dining Area |
| Family Room | Other |
| Flooring | Laminate, Tile |
| Laundry | Inside |
| Cooling | None |
| Heating | Wall Furnace |
| Feature | Details |
|---|---|
| Roof | Composition |
| Foundation | Slab |
| Feature | Details |
|---|---|
| Garage/Parking | Carport, Covered Parking, Garage: 0 Car(s) |
| Elementary District | Fremont Unified |
| High School District | Fremont Unified |
| Sewer | Public Sewer |
| Water | Public |
| Zoning | R-1 |
Yating Zhou
Grand Realty Group
License #: 02080855
Phone: (510) 660-4235
School data provided by GreatSchools.org
| School | Type | Grades | Distance | Rating |
|---|---|---|---|---|
| J. Haley Durham Elementary School | public | TK,KG,1,2,3,4,5 | 0.09 mi | 9 |
| John M. Horner Middle School | public | 6-8 | 0.83 mi | 9 |
| Brier Elementary School | public | TK,KG,1,2,3,4,5 | 0.88 mi | 4 |
| G. M. Walters Middle School | public | 6-8 | 0.89 mi | 7 |
| Glankler Early Learning Center | public | KG | 0.93 mi | N/A |
| O. N. Hirsch Elementary School | public | K-5 | 0.95 mi | 9 |
| John Blacow Elementary School | public | TK,KG,1,2,3,4,5 | 1.07 mi | 7 |
| Irvington High School | public | 9-12 | 1.23 mi | 10 |
| Fremont Adult | public | UG | 1.23 mi | N/A |
| Young Adult Program | public | 9-12 | 1.24 mi | N/A |
| Mission Valley Rocp School | public | 9-12 | 1.26 mi | N/A |
| John Gomes Elementary School | public | TK,KG,1,2,3,4,5 | 1.26 mi | 8 |
| Mission Valley Elementary School | public | K-5 | 1.26 mi | 8 |
| John F. Kennedy High School | public | 9-12 | 1.32 mi | 7 |
| California School For The Deaf-Fremont | public | K-12 | 1.35 mi | N/A |
| California School For The Blind | public | KG,1,2,3,4,5,6,7,8,9,10,11,12,AE | 1.39 mi | N/A |
| William Hopkins Middle School | public | 6-8 | 1.52 mi | 9 |
| Joshua Chadbourne Elementary School | public | TK,KG,1,2,3,4,5 | 1.53 mi | 9 |
| Robertson High (Continuation) School | public | 9-12 | 1.53 mi | 3 |
| Vista Alternative School | public | 6-12 | 1.53 mi | 10 |
| Address | Price | Beds | Baths | Sq Ft | Status |
|---|---|---|---|---|---|
| 40242 Crockett St | $1,425,000 | 4 | 2 | 1,321 | Active |
| 38590 Canyon Heights Dr | $1,748,000 | 3 | 2 | 1,762 | Active |
| 38465 Blacow Rd | $1,498,000 | 5 | 3 | 1,771 | Active |
| 4572 Theresa Ave | $1,699,999 | 3 | 2 | 1,318 | Active |
| 38333 Corrigan Ct | $1,498,000 | 3 | 2 | 1,251 | 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 April 03, 2026. For the most current information, please contact Yating Zhou, (510) 660-4235.