40207 Condon st

• Sun Feb 22, 12:00 pm - 6:00 pm

  Gorgeous, turnkey, Light, bright and spacious!!!!

• Fri Feb 27, 2:00 pm - 6:00 pm

  Welcome to a charming, Light, bright, turnkey and spacious single Family home in Central Fremont!!!Location, Location, Location!!!!

• Sat Feb 28, 12:00 pm - 6:00 pm

  Welcome to a charming, Light, bright, turnkey and spacious single Family home in Central Fremont!!!Location, Location, Location!!!!

• Sun Mar 1, 12:00 pm - 6:00 pm

  Welcome to a charming, Light, bright, turnkey and spacious single Family home in Central Fremont!!!Location, Location, Location!!!!

Your search for the Perfect Neighborhood and lifestyle is finally over! Perched on a corner lot, this home has a CURB APPEAL like none other. Located on a quiet, charming and tree lined street, this spacious home is highly functional and upgraded over the years with great taste! Treat yourself and kick back with family and friends in the RESORT STYLE BACKYARD oasis that has been meticulously landscaped for entertainment and relaxation. The backyard boasts of a gas firepit, high end pavers , manicured vegetable gardens with drip irrigation, water fountain and multiple flowering plants. A stunning, bright, airy and warm SUN LOUNGE/RHOMBUS ROOM(not included in living sq.ft built with permits) makes for an ideal entertainment, living space, office/library or an excercise retreat overlooking the backyard! Spacious, updated and well lit, this offers a FUNCTIONAL AND OPEN FLOORPLAN with 1570 sq.ft of living space, 3 bedrooms with custom closets, 2 updated bathrooms and 2 living spaces! A HOME THEATER SYSTEM with surround sound speakers and a projector screen completes your total living experience! Perfect suburbian "Utopia" with all amenities including schools, LAKE ELIZABETH, CENTRAL PARK, Fremont Bart, within A STONE'S THROW! A TRUE TREASURE TO HOLD LONG TERM or retire in Fremont!

Current Status

New

Original Price

$1,599,000

List Price

$1,599,000

On Market Date

Feb 6, 2026

Property Type

Detached

D/N/S

Central Park

Zip Code

94538

MLS ID

41123245

APN

Year Built

1970

Stories in Building

1

Possession

Close Of Escrow

Data Source

MAXEBRDI

Origin MLS System

BAY EAST

Bed

3

Bath

2

Parking

2

Attached, Garage Door Opener

SQ FT

1,570

SQ FT Source

Public Records

Lot SQ FT

6,308.0

Lot Acres

0.15 Acres

Pool Info

None

Kitchen

Dishwasher, Electric Range, Microwave, Refrigerator, Self Cleaning Oven, Dryer, Washer, 220 Volt Outlet, Breakfast Bar, Breakfast Nook, Counter - Solid Surface, Stone Counters, Eat-in Kitchen, Electric Range/Cooktop, Disposal, Kitchen Island, Self-Cleaning Oven, Updated Kitchen

Cooling

Central Air

Disclosures

Nat Hazard Disclosure, None, Disclosure Package Avail

Entry Level

Exterior Details

Back Yard, Front Yard, Garden/Play, Side Yard, Sprinklers Automatic, Sprinklers Front, Sprinklers Side

Flooring

Hardwood

Foundation

Fire Place

Gas Starter

Heating

Forced Air

Laundry

Dryer, In Garage, Washer

Main Level

1 Bedroom, 2 Bedrooms, 3 Bedrooms, 2 Baths, Laundry Facility, Main Entry

Possession

Close Of Escrow

Architectural Style

None

Construction Status

Existing

Additional Miscellaneous Features

Back Yard, Front Yard, Garden/Play, Side Yard, Sprinklers Automatic, Sprinklers Front, Sprinklers Side

Location

Corner Lot, Level, Sprinklers In Rear

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.