4738 Bret Harte Ct

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!

Current Status

New

Original Price

$1,699,000

List Price

$1,699,000

On Market Date

Jul 27, 2026

Property Type

Detached

D/N/S

Fremont

Zip Code

94538

MLS ID

41142983

APN

5311111

Year Built

1959

Stories in Building

1

Possession

Close Of Escrow

Data Source

MAXEBRDI

Origin MLS System

CONTRA COSTA

Bed

5

Bath

4

Parking

2

Attached, Covered, Int Access From Garage, Off Street, Side Yard Access

SQ FT

1,796

SQ FT Source

Public Records

Lot SQ FT

7,918.0

Lot Acres

0.18 Acres

Pool Info

None

Kitchen

Dishwasher, Double Oven, Gas Range, Microwave, Range, Refrigerator, Dryer, Tankless Water Heater, 220 Volt Outlet, Breakfast Bar, Breakfast Nook, Counter - Solid Surface, Stone Counters, Eat-in Kitchen, Gas Range/Cooktop, Range/Oven Built-in, Updated Kitchen

Cooling

Central Air

Disclosures

Probate/Independent Adm

Entry Level

Exterior Details

Garden, Back Yard, Dog Run, Front Yard, Garden/Play, Side Yard

Flooring

Laminate, Tile, Carpet

Foundation

Fire Place

None

Heating

Forced Air

Laundry

Dryer, In Garage, Washer

Main Level

5 Bedrooms, 4 Baths, Primary Bedrm Suites - 2, Main Entry

Possession

Close Of Escrow

Basement

Crawl Space

Architectural Style

Traditional

Non-Master Bathroom Includes

Shower Over Tub, Updated Baths, Jack & Jill, Stone

Construction Status

Existing

Additional Miscellaneous Features

Garden, Back Yard, Dog Run, Front Yard, Garden/Play, Side Yard

Location

Cul-De-Sac, Premium Lot, Back Yard, Front Yard

Roof

Composition Shingles

Water and Sewer

Public

Fee

Unavailable

MLS and other Information regarding properties for sale as shown in Theo have been obtained from various sources such as sellers, public records, agents and other third parties. This information may relate to the condition of the property, permitted or unpermitted uses, zoning, square footage, lot size/acreage or other matters affecting value or desirability. Unless otherwise indicated in writing, neither brokers, agents nor Theo have verified, or will verify, such information. If any such information is important to buyer in determining whether to buy, the price to pay or intended use of the property, buyer is urged to conduct their own investigation with qualified professionals, satisfy themselves with respect to that information, and to rely solely on the results of that investigation.

School data provided by GreatSchools. School service boundaries are intended to be used as reference only. To verify enrollment eligibility for a property, contact the school directly.