40207 Condon st, Fremont, CA 94538

Local realty services provided by:Better Homes and Gardens Real Estate Reliance Partners
40207 Condon st,Fremont, CA 94538
$1,599,000
  • 3 Beds
  • 2 Baths
  • 1,570 sq. ft.
  • Single family
  • Active
Upcoming open houses
  • Fri, Feb 27
    02:00 pm - 06:00 pm
  • Sat, Feb 28
    12:00 pm - 06:00 pm
Listed by: shilpa venka rao(408) 835-4120
Office: compass
MLS#:41123245
Source:CAREIL

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 a BHGRE®  affiliated agent 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 a BHGRE®  affiliated agent 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 (CENTURY 21® , 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 07:40 PM

Rooms and interior

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

Heating and cooling

  • Cooling:Central -1 Zone
  • Heating:Central Forced Air

Structure and exterior

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

Utilities

  • Water:City/Public
  • Sewer:Sewer - Public

Finances and disclosures

  • Price:$1,599,000
  • Price per sq. ft.:$1,018.47
MLS LogoThe information being provided by Mlslistings Inc is for the consumer's personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumer may be interested in purchasing. Any information relating to real estate for sale referenced on this web site comes from the Internet Data Exchange (IDX) program of the Mlslistings Inc. Better Homes and Gardens Real Estate Reliance Partners is not a Multiple Listing Service (MLS), nor does it offer MLS access. This website is a service of Better Homes and Gardens Real Estate Reliance Partners, a broker participant of Mlslistings Inc. This web site may reference real estate listing(s) held by a brokerage firm other than the broker and/or agent who owns this web site. The accuracy of all information, regardless of source, including but not limited to open house information, square footages and lot sizes, is deemed reliable but not guaranteed and should be personally verified through personal inspection by and/or with the appropriate professionals. The data contained herein is copyrighted by Mlslistings Inc and is protected by all applicable copyright laws. Any unauthorized dissemination of this information is in violation of copyright laws and is strictly prohibited. Properties in listings may have been sold or may no longer be available. Copyright 2026 Mlslistings Inc. All rights reserved.

New listings near 40207 Condon st