Home | Alameda County | Fremont | 94538 | 40234 Crockett St
MLS: ML81954782 | Status: Sold | Price: $1,770,000
Beds/Baths: 4 / 3
Property Type: Residential
| Beds | Baths | Sq Ft | Sq Ft Lot | Yr Built |
|---|---|---|---|---|
| 4 | 3 | 2,058 | 7,721 | 1959 |
Welcome to this remodeled (2017) single story home with open floor plan, nestled on a spacious 7,721 sq.ft. lot. Total 2058 sq.ft. includes main house with 3 bed / 2 bath and approx. 496 sf. ft. of guest house with private entry, full kitchen and 1 bed and 1 full bath an amazing opportunity for a large family or an investor. Addition of 496 sq.ft was done in 2019. This seamless open floor plan flows from the living room to the kitchen and dining area leading to the family room and separate office area. Gourmet kitchen with large island, cherry cabinets, granite counters, stainless steel appliances, brand new light fixtures. Remodeled bathrooms with granite counters, new light fixtures, tile flooring and shower, Wood flooring, double pane windows and recessed lights. Brand new interior paint. 2 car garage with extra storage. Low maintenance backyard with fruit fress and veggie boxes. This established neighborhood with great schools, community parks, plenty of shopping nearby, Fremont Bart and library. Commuters dream location with easy access to I-880, 680 and 237 to Tesla, Facebook, Googlle, Amazon and many Tech companies. Dont miss the opportunity.
| Field | Value |
|---|---|
| MLS # | ML81954782 |
| MLS Source | MLSListings, Inc. |
| Feature | Details |
|---|---|
| Bathrooms | Granite, Shower and Tub, Shower over Tub - 1, Tile, Updated Bath(s) |
| Kitchen | Countertop - Granite, Exhaust Fan, Island, Skylight(s) |
| Appliances | Cooktop - Electric, Dishwasher, Exhaust Fan, Garbage Disposal, Oven - Self Cleaning, Oven Range - Electric, Refrigerator, Washer/Dryer |
| Dining Room | Dining Area |
| Family Room | Separate Family Room |
| Flooring | Tile, Wood |
| Laundry | In Garage |
| Cooling | None |
| Heating | Central Forced Air |
| Feature | Details |
|---|---|
| Roof | Composition, Shingle |
| Foundation | Pillar/Post/Pier, Concrete Perimeter and Slab |
| Feature | Details |
|---|---|
| Garage/Parking | Attached Garage, Garage: 2 Car(s) |
| Elementary District | Fremont Unified |
| High School District | Fremont Unified |
| Sewer | Public Sewer |
| Water | Public |
| Zoning | resid |
Radha Rustagi
Keller Williams Thrive
License #: 01402429
Phone: (408) 340-0558
School data provided by GreatSchools.org
| School | Type | Grades | Distance | Rating |
|---|---|---|---|---|
| John Blacow Elementary School | public | TK,KG,1,2,3,4,5 | 0.37 mi | 7 |
| G. M. Walters Middle School | public | 6-8 | 0.52 mi | 7 |
| Mission Valley Rocp School | public | 9-12 | 0.55 mi | N/A |
| John M. Horner Middle School | public | 6-8 | 0.62 mi | 9 |
| John F. Kennedy High School | public | 9-12 | 0.65 mi | 7 |
| O. N. Hirsch Elementary School | public | K-5 | 0.71 mi | 9 |
| Glankler Early Learning Center | public | KG | 0.72 mi | N/A |
| Brier Elementary School | public | TK,KG,1,2,3,4,5 | 0.72 mi | 4 |
| Irvington High School | public | 9-12 | 0.74 mi | 10 |
| J. Haley Durham Elementary School | public | TK,KG,1,2,3,4,5 | 0.81 mi | 9 |
| Fremont Adult | public | UG | 0.90 mi | N/A |
| Young Adult Program | public | 9-12 | 0.92 mi | N/A |
| Steven Millard Elementary School | public | TK,KG,1,2,3,4,5 | 0.95 mi | 7 |
| Joseph Azevada Elementary School | public | TK,KG,1,2,3,4,5 | 1.00 mi | 7 |
| Robertson High (Continuation) School | public | 9-12 | 1.07 mi | 3 |
| Vista Alternative School | public | 6-12 | 1.07 mi | 10 |
| Harvey Green Elementary School | public | TK,KG,1,2,3,4,5 | 1.29 mi | 8 |
| Tom Maloney Elementary School | public | TK,KG,1,2,3,4,5 | 1.53 mi | 7 |
| E. M. Grimmer Elementary School | public | TK,KG,1,2,3,4,5 | 1.61 mi | 6 |
| Mission Valley Elementary School | public | K-5 | 1.61 mi | 8 |
©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 February 01, 2026. For the most current information, please contact Radha Rustagi, (408) 340-0558.