40207 40207 Condon St, Fremont, CA 94538

Local realty services provided by:ERA North Orange County Real Estate
40207 40207 Condon St,Fremont, CA 94538
$1,599,000
Virtual Tour
  • 3 Beds
  • 2 Baths
  • 1,570 sq. ft.
  • Single family
  • Active
Upcoming open houses
  • Sun, Feb 22
    12:00 pm - 06:00 pm
  • Fri, Feb 27
    02:00 pm - 06:00 pm
Listed by: shilpa venka rao
Office: compass
MLS#:41123245
Source:CRMLS

Price summary

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

About this home

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

Contact an agent

contact an agent

Yes, I would like more information. Please use and/or share my information with an ERA®  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 an ERA®  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 (BHGRE® , CENTURY 21® , Coldwell Banker® , Corcoran® , 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:1 day(s) ago
  • Updated:February 21, 2026 at 02:34 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.14 Acres

Utilities

  • Sewer:Public Sewer

Finances and disclosures

  • Price:$1,599,000
  • Price per sq. ft.:$1,018.47
Based on information from California Regional Multiple Listing Service, Inc. as of February 21, 2026 . This information is for your personal, non-commercial use and may not be used for any purpose other than to identify prospective properties you may be interested in purchasing. Display of MLS data is usually deemed reliable but is NOT guaranteed accurate by the MLS. Buyers are responsible for verifying the accuracy of all information and should investigate the data themselves or retain appropriate professionals. Information from sources other than the Listing Agent may have been included in the MLS data. Unless otherwise specified in writing, Broker/Agent has not and will not verify any information obtained from other sources. The Broker/Agent providing the information contained herein may or may not have been the Listing and/or Selling Agent. The information 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. All properties are subject to prior sale or withdrawal. All information provided is deemed reliable but is not guaranteed accurate, and should be independently verified.

New listings near 40207 40207 Condon St