Back to Search
40207 40207 Condon St
For Sale $1,599,000 ($1,018.47 per Sq Ft)
$1,599,000 ($1,018.47 per Sq Ft)
- 3 Bedrooms
- 2 Bathrooms
- 1,570 Sq Ft
- 6,308 Sq Ft
Description
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!
Amenities
Garage
Pool
Garden
Security System
Internet
Telephone
Heating
Fireplace
Balcony & Patio
TV / Cable
Laundry
Hardwood Floors
Spa
Air Conditioning
Solar Power
Floor Plan
Great Views
Natural Light
Quiet
Water View
Elevator
Guest Unit(s)
Furnished
220 Volt
Upcoming Open House
Saturday February 21st, 2026
from 12:00 pm - 6:00 pm
Sunday February 22nd, 2026
from 12:00 pm - 6:00 pm
Friday February 27th, 2026
from 2:00 pm - 6:00 pm
Saturday February 28th, 2026
from 12:00 pm - 6:00 pm
Sunday March 1st, 2026
from 12:00 pm - 6:00 pm
Property Details
| List Price | $1,599,000 |
| Property Type | Single Family Homes |
| Usable Sqft | 1,570 |
| Number of Stories | 0 stories |
| Parking Spots | 2 spots |
| Year Built | 1970 |
| Last Sold | Unknown |
| Sold Price | Unknown |
| APN # | 52580217 |
| MLS # | 41123245 |
| Property ID | 322612458 |
| Lot Sqft | 6,308 |
| Zoning | Unknown |
| Days on Market | 1 |
| Original List Price | $1,599,000 |
| Applicances | Dryer,Washer% |
| Date Updated | February 20, 2026 |
| Date Created | February 20, 2026 |
Listing Provided By
Shilpa Venka Rao an agent of . Lic #01849921
© 2026 CRMLS. All rights reserved. Some listings on this website are from CRMLS as of February 20, 2026 The information being provided is for consumers personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.
Contact Agent
Schedule Appointment
Showing Agent
Loading agent...
- 30 mins
- America/Phoenix
Sun
Mon
Tue
Wed
Thu
Fri
Sat
Robert Crawford
REAL ESTATE AGENT