Home | Alameda County | Fremont | 94538 | 40123 Crockett St
MLS: BE41063821 | Status: Sold | Price: $1,330,000
Beds/Baths: 3 / 2
Property Type: Residential
| Beds | Baths | Sq Ft | Sq Ft Lot | Yr Built |
|---|---|---|---|---|
| 3 | 2 | 1,151 | 6,000 | 1959 |
This charming upgraded home in the heart of Fremont features 3 bedrooms and 2 full baths on a spacious 6000 square foot lot. Recently enhanced with new interior paint, this residence offers modernized bathrooms, central heating with an attic unit, and new laminate flooring throughout. The kitchen shines with new appliances, and both the electrical panel and subpanel have been updated for your peace of mind. Additional conveniences include washer and dryer hookups in the garage, complete with a wash basin, and an electric garage door opener with a roll-up insulated garage door. The property also boasts side access with double gates, and the back windows have been replaced with double-pane windows for improved energy efficiency. Located close to the Fremont Hub, Central Park, and Lake Elizabeth, this home offers easy access to major highways 880 and 680, as well as BART stations, making it a perfect blend of comfort and convenience.
| Field | Value |
|---|---|
| MLS # | BE41063821 |
| MLS Source | Bay East |
| Feature | Details |
|---|---|
| Kitchen | Countertop - Solid Surface / Corian, Eat In Kitchen |
| Appliances | Cooktop - Electric, Dishwasher, Garbage Disposal, Oven - Built-In |
| Fireplace | None |
| Flooring | Laminate |
| Laundry | 220 Volt Outlet, Hookup - Gas Dryer, Hookups Only, In Garage |
| Cooling | Ceiling Fan |
| Heating | Forced Air, Gas |
| Feature | Details |
|---|---|
| Roof | Composition |
| Pool | None, Pool - No |
| Style | Contemporary |
| Feature | Details |
|---|---|
| Garage/Parking | Attached Garage, Garage, Gate/Door Opener, Parking Space(s), Garage: 2 Car(s) |
| Elementary District | Fremont Unified |
| High School District | Fremont Unified |
| Sewer | Public Sewer |
| Water | Public |
| Listing Agent | Co-Listing Agent |
|---|---|
| Robert Lewis | Aimee Ran Song |
| Coldwell Banker Realty | Coldwell Banker Realty |
| License #: 00633105 | License #: 01951402 |
| Phone: (510) 502-8893 | Phone: (510) 990-9999 |
School data provided by GreatSchools.org
| School | Type | Grades | Distance | Rating |
|---|---|---|---|---|
| John Blacow Elementary School | public | TK,KG,1,2,3,4,5 | 0.40 mi | 7 |
| G. M. Walters Middle School | public | 6-8 | 0.45 mi | 7 |
| Mission Valley Rocp School | public | 9-12 | 0.50 mi | N/A |
| John F. Kennedy High School | public | 9-12 | 0.59 mi | 7 |
| Glankler Early Learning Center | public | KG | 0.65 mi | N/A |
| Brier Elementary School | public | TK,KG,1,2,3,4,5 | 0.66 mi | 4 |
| John M. Horner Middle School | public | 6-8 | 0.70 mi | 9 |
| O. N. Hirsch Elementary School | public | K-5 | 0.79 mi | 9 |
| Irvington High School | public | 9-12 | 0.80 mi | 10 |
| Fremont Adult | public | UG | 0.82 mi | N/A |
| J. Haley Durham Elementary School | public | TK,KG,1,2,3,4,5 | 0.84 mi | 9 |
| Young Adult Program | public | 9-12 | 0.84 mi | N/A |
| Joseph Azevada Elementary School | public | TK,KG,1,2,3,4,5 | 0.92 mi | 7 |
| Steven Millard Elementary School | public | TK,KG,1,2,3,4,5 | 0.98 mi | 7 |
| Robertson High (Continuation) School | public | 9-12 | 1.13 mi | 3 |
| Vista Alternative School | public | 6-12 | 1.13 mi | 10 |
| Harvey Green Elementary School | public | TK,KG,1,2,3,4,5 | 1.36 mi | 8 |
| Tom Maloney Elementary School | public | TK,KG,1,2,3,4,5 | 1.46 mi | 7 |
| Newark Memorial High School | public | 9-12 | 1.58 mi | 6 |
| Washington High School | public | 9-12 | 1.67 mi | 9 |
©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 Robert Lewis, (510) 502-8893.