Home | Alameda County | Fremont | 94538 | 4738 Bret Harte Ct
MLS: CC41142983 | Status: Active | Price: $1,699,000
Beds/Baths: 5 / 4
Property Type: Residential
| Beds | Baths | Sq Ft | Sq Ft Lot | Yr Built |
|---|---|---|---|---|
| 5 | 4 | 1,796 | 7,918 | 1959 |
Welcome to your ideal sanctuary in the heart of Fremont! Tucked away at the end of a peaceful, low-traffic cul-de-sac, this expansive 5-bedroom, 4-bathroom, home offers a rare and versatile layout featuring two true primary suites—perfect for multi-generational living, long-term guests, or a private home office setup—plus 3 additional spacious bedrooms. At the center of the home sits an upgraded kitchen built for cooking and entertaining, outfitted with sleek stone countertops, a double oven, generous cabinet space, and a seamless flow into the main living areas. Step outside to discover a massive, private pie-shaped lot with endless potential. The grounds feature a large maintenance/storage shed—ideal for a workshop or extra equipment—and a dedicated dog run area for your four-legged family members. Unbeatable location: Enjoy everyday convenience with swift access to I-880/Fremont BART and premier shopping, dining, and daily amenities along Mowry Avenue. A rare combination of size, privacy, and accessibility—this one won't last!
| Field | Value |
|---|---|
| MLS # | CC41142983 |
| MLS Source | Contra Costa Association of Realtors |
| Days on Site | 1 |
| Feature | Details |
|---|---|
| Bathrooms | Primary - Shower(s) over Tub(s), Primary - Solid Surface, Primary - Sunken Tub, Primary - Tub w/ Jets, Primary - Updated Bath(s), Updated Bath(s) |
| Kitchen | 220 Volt Outlet, Breakfast Bar, Breakfast Nook, Countertop - Solid Surface / Corian, Countertop - Stone, Eat In Kitchen, Updated |
| Appliances | Dishwasher, Microwave, Oven - Double, Oven Range - Built-In, Oven Range - Gas, Refrigerator, Dryer, Washer |
| Dining Room | Dining "L" |
| Fireplace | None |
| Flooring | Carpet - Wall to Wall, Laminate, Tile |
| Laundry | In Garage |
| Cooling | Central -1 Zone |
| Heating | Forced Air |
| Feature | Details |
|---|---|
| Roof | Composition |
| Foundation | Raised, Crawl Space |
| Pool | None, Pool - No |
| Style | Traditional |
| Feature | Details |
|---|---|
| Garage/Parking | Access - Interior, Access - Side Yard, Attached Garage, Covered Parking, Garage, Off-Street Parking, Garage: 2 Car(s) |
Jonathan Kurniadi
Kurniadi Realty
License #: 01871163
Phone: (510) 467-0610
School data provided by GreatSchools.org
| School | Type | Grades | Distance | Rating |
|---|---|---|---|---|
| Young Adult Program | public | 9-12 | 0.23 mi | N/A |
| Fremont Adult | public | UG | 0.23 mi | N/A |
| Tom Maloney Elementary School | public | TK,KG,1,2,3,4,5 | 0.52 mi | 7 |
| Glankler Early Learning Center | public | KG | 0.52 mi | N/A |
| Joseph Azevada Elementary School | public | TK,KG,1,2,3,4,5 | 0.53 mi | 7 |
| Brier Elementary School | public | TK,KG,1,2,3,4,5 | 0.56 mi | 5 |
| G. M. Walters Middle School | public | 6-8 | 0.63 mi | 8 |
| Glenmoor Elementary School | public | K-5 | 0.69 mi | 8 |
| John F. Kennedy High School | public | 9-12 | 0.81 mi | 7 |
| John G. Mattos Elementary School | public | K-5 | 0.91 mi | 8 |
| Washington High School | public | 9-12 | 0.95 mi | 9 |
| Mission Valley Rocp School | public | 9-12 | 0.95 mi | N/A |
| Centerville Middle School | public | 6-8 | 1.26 mi | 8 |
| Newark Memorial High School | public | 9-12 | 1.29 mi | 6 |
| Birch Grove Primary | public | KG,1,2 | 1.33 mi | N/A |
| John Blacow Elementary School | public | TK,KG,1,2,3,4,5 | 1.33 mi | 7 |
| Birch Grove Intermediate | public | 3,4,5 | 1.52 mi | 7 |
| Parkmont Elementary School | public | TK,KG,1,2,3,4,5 | 1.64 mi | 9 |
| J. Haley Durham Elementary School | public | TK,KG,1,2,3,4,5 | 1.65 mi | 9 |
| Thornton Middle School | public | 6-8 | 1.73 mi | 9 |
| Address | Price | Beds | Baths | Sq Ft | Status |
|---|---|---|---|---|---|
| 5352 Selma Ave | $1,678,888 | 3 | 2 | 1,882 | PendingDoNotShow |
| 3879 James Ave | $1,399,990 | 4 | 2/1 | 1,392 | Active |
| 4444 Gibraltar Dr | $1,598,000 | 3 | 2 | 1,256 | Active |
| 4333 Brookwood Ave. | $1,400,000 | 3 | 2 | 1,118 | Active |
| 3764 Howe Ct | $1,598,000 | 4 | 2 | 1,616 | Active |
©2026 Contra Costa Association of Realtors. 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 Contra Costa Association of Realtors.
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 July 28, 2026. For the most current information, please contact Jonathan Kurniadi, (510) 467-0610.