---
listing_id: ML82017083
status: Closed
price: 1498000
beds: 4
baths_full: 3
baths_half: 0
sqft_living: 1624
sqft_lot: 5300
lot_acres: 
year_built: 1958
property_type: Residential
property_subtype: Single Family Residence
address: "42758 Charleston Way"
city: Fremont
state: CA
zip: 94538
county: "Alameda County"
lat: 37.521482
lng: -121.953557
days_on_market: 238
hoa_fee: 
hoa_frequency: 
garage_spaces: 0
list_agent: "Ashley Shi"
list_office: "E3 Realty & Loans"
list_agent_phone: "(650) 600-1668"
list_agent_license: 02067736
mls_source: MLSL
modified: 2026-01-30
transaction_type: recentlySold
---

Home | Alameda County | Fremont | 94538 | 42758 Charleston Way

42758 Charleston Way, Fremont, CA 94538

MLS: ML82017083 | Status: Sold | Price: $1,498,000
Beds/Baths: 4 / 3
Property Type: Residential

Quick Facts

Beds Baths Sq Ft Sq Ft Lot Yr Built
4 3 1,624 5,300 1958

Remarks

Move-in ready single-story home with a Junior ADU, located in the highly sought-after Irvington school district! The bright and airy main house features 3 bedrooms and 2 bathrooms with a thoughtfully designed layout. The well-appointed Junior ADU offers flexible living options that is perfect for guests, extended family, or rental income. Modern upgrades throughout enhance both comfort and functionality, including quartz countertops, stainless steel appliances, waterproof LVP flooring, dual-pane windows, fresh interior paint, and ductless mini-split AC and heat pump systems in both the main house and Junior ADU, each with independent controls for year-round comfort. The expansive front and back yards feature low-maintenance, drought-tolerant landscaping, a spacious patio ideal for entertaining, and ample space for garden beds or a storage shed. Conveniently located near top-rated Irvington high schools, parks, shopping, and major commute routes. Beautifully renovated and full of possibilities!

MLS Listing Information

Field Value
MLS # ML82017083
MLS Source MLSListings, Inc.

Features

Interior Features

Feature Details
Bathrooms Primary - Stall Shower(s), Stall Shower - 2+
Kitchen Island
Appliances Dishwasher, Garbage Disposal, Microwave, Oven Range - Electric, Refrigerator, Washer/Dryer
Dining Room Dining Area, Eat in Kitchen
Family Room No Family Room
Flooring Other, Tile
Laundry Inside
Cooling Multi-Zone, Other
Heating Heat Pump, Individual Room Controls, Other

Exterior Features

Feature Details
Roof Other
Foundation Slab

Parking, School, and Other Information

Feature Details
Garage/Parking Attached Garage, Other, Garage: 0 Car(s)
Elementary District Fremont Unified
High School District Fremont Unified
Sewer Public Sewer
Water Public
Zoning R

Contact Information

Ashley Shi
E3 Realty & Loans
License #: 02067736
Phone: (650) 600-1668

School Ratings

School data provided by GreatSchools.org

Nearby Schools

School Type Grades Distance Rating
E. M. Grimmer Elementary School public TK,KG,1,2,3,4,5 0.16 mi 6
Harvey Green Elementary School public TK,KG,1,2,3,4,5 0.38 mi 8
Robertson High (Continuation) School public 9-12 0.63 mi 3
Vista Alternative School public 6-12 0.63 mi 10
O. N. Hirsch Elementary School public K-5 0.76 mi 9
Irvington High School public 9-12 0.81 mi 10
John M. Horner Middle School public 6-8 0.88 mi 9
Mission Valley Elementary School public K-5 1.11 mi 8
Steven Millard Elementary School public TK,KG,1,2,3,4,5 1.18 mi 7
John Blacow Elementary School public TK,KG,1,2,3,4,5 1.27 mi 7
Lila Bringhurst Elementary public TK,KG,1,2,3,4,5,6 1.49 mi 10
J. Haley Durham Elementary School public TK,KG,1,2,3,4,5 1.63 mi 9
Joshua Chadbourne Elementary School public TK,KG,1,2,3,4,5 1.67 mi 9
Mission Valley Rocp School public 9-12 1.73 mi N/A
Mission San Jose Elementary School public TK,KG,1,2,3,4,5 1.75 mi 9
Fred E. Weibel Elementary School public K-5 1.84 mi 10
William Hopkins Middle School public 6-8 1.87 mi 9
John F. Kennedy High School public 9-12 1.89 mi 7
Mission San Jose High School public 9-12 1.90 mi 10
G. M. Walters Middle School public 6-8 1.97 mi 7

Disclosures

©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 January 30, 2026. For the most current information, please contact Ashley Shi, (650) 600-1668.