Login

40207 Condon St, Fremont, CA 94538

Local realty services provided by:CENTURY 21 Wildwood Properties, Inc.
40207 Condon St,Fremont, CA 94538
$1,599,000
Virtual Tour
  • 3 Beds
  • 2 Baths
  • 1,570 sq. ft.
  • Single family
  • Active
Listed by: shilpa venka rao
Office: compass
MLS#:41123245
Source:Bay East, CCAR, bridgeMLS

Price summary

  • Price:$1,599,000
  • Price per sq. ft.:$1,018.47

About this home

North East facing! 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

Contact an agent

contact an agent

Yes, I would like more information. Please use and/or share my information with an independent agent affiliated with the CENTURY 21®  brand to contact me about my real estate needs. By clicking Send message, I request to be contacted by phone or text message and consent to being contacted by automated means. I understand that my consent to receive calls or texts is not a condition of purchasing any property, goods, or services. Alternatively, I understand that I can access real estate services by email or I can contact the agent myself.

If an independent agent affiliated with the CENTURY 21®  brand is not available in the area where I need assistance, I agree to be contacted by a real estate agent affiliated with another brand owned or licensed by Anywhere Real Estate (BHGRE® , Coldwell Banker® , Corcoran® , ERA® , Sotheby's International Realty® ). I acknowledge that I have read and agree to theTerms of useandPrivacy notice

Home facts

  • Year built:1970
  • Listing ID #:41123245
  • Added:3 day(s) ago
  • Updated:February 23, 2026 at 05:09 PM

Rooms and interior

  • Bedrooms:3
  • Total bathrooms:2
  • Full bathrooms:2
  • Living area:1,570 sq. ft.

Heating and cooling

  • Cooling:Central Air
  • Heating:Forced Air

Structure and exterior

  • Roof:Shingle
  • Year built:1970
  • Building area:1,570 sq. ft.
  • Lot area:0.15 Acres

Finances and disclosures

  • Price:$1,599,000
  • Price per sq. ft.:$1,018.47
MLS LogoBay East 2026. CCAR 2026 bridgeMLS 2026. Information Deemed Reliable But Not Guaranteed. This information is being provided by the Bay East MLS, or CCAR MLS, or bridgeMLS. The listings presented here may or may not be listed by the Broker/Agent operating this website. This information is intended for the personal use of consumers and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Data last updated at February 23, 2026

New listings near 40207 Condon St