Sterling Homes
  • Home
  • Search
  • Buy
    1. Our Listings
    2. Mortgage Calculator
    3. Pre-Sale Renovations
  • Sell
    1. Sell My Home
    2. Market Snapshot
  • Home Valuation
  • Explore
    1. Pacific Heights Overview
    2. Inner Richmond Overview
    3. Presidio Heights Overview
    4. Jordan Park/Laurel H Listings
    5. Lower Pacific Height Listings
  • Blogs
  • About
    1. About Us
    2. Contact Us
  • MORE
    1. My Homes
    2. My Tours
    3. My Favorites
    4. My Searches
  • Sign In
  • Register
Filters Reset
Save Search (1)
Save your search to get Alerts
4 Properties

4 Properties Available

  • Default
  • Price-High To Low
  • Price-Low To High
  • Newest Listings
  • Beds (Most)
  • Baths (Most)
  • Year Built (Newest)
  • Square Feet (Biggest)
  • 38002 Stenhammer DR, Fremont, CA 94536
    1/57 57
    Price Dropped by $80K

    $ 1,358,800

    6 Beds3 Baths1,947 SqFt

    38002 Stenhammer DR, Fremont, CA 94536

    Single Family Home

    Listed by Leo Cheung of eXp Realty of California, Inc

    San Francisco MLS - SFAR
  • 3685 Nutwood TER #313, Fremont, CA 94536
    1/26 26
    Active

    $ 618,888

    2 Beds2 Baths990 SqFt

    3685 Nutwood TER #313, Fremont, CA 94536

    Condo

    Listed by David K Dai of CMM Global Realty

    San Francisco MLS - SFAR
  • 37847 Niles BLVD, Fremont, CA 94536
    1/16 16
    Active

    $ 5,005,000

    24 Beds11,814 SqFt

    37847 Niles BLVD, Fremont, CA 94536

    Multi-Family

    Listed by Louis C Kwok of Kidder Mathews

    San Francisco MLS - SFAR
  • 2890 Barrington TER, Fremont, CA 94536
    1/48 48
    Active

    $ 4,250

    3 Beds3 Baths1,600 SqFt

    2890 Barrington TER, Fremont, CA 94536

    Single Family Home

    Listed by Lynette Douangvongsa of Skybox Realty

    San Francisco MLS - SFAR
  • 1

explore listings

  • Open House
  • Price Reduced
  • Virtual Tour
  • 3D Tour
default
      Home
      Search
      Buy
      1. Our Listings
      2. Mortgage Calculator
      3. Pre-Sale Renovations
      Sell
      1. Sell My Home
      2. Market Snapshot
      Home Valuation
      Explore
      1. Pacific Heights Overview
      2. Inner Richmond Overview
      3. Presidio Heights Overview
      4. Jordan Park/Laurel H Listings
      5. Lower Pacific Height Listings
      Blogs
      About
      1. About Us
      2. Contact Us
Sterling Homes

Anna Spathis & Dennis Stavropoulos License ID: 01416042

+1(415) 810-5291 info@sterlinghomesre.com

2181 GREENWICH ST 2ND FL SAN FRANCISCO, CA 94123

Get My App

Terms of Service & Privacy Policy | Cookie Policy | Cookie Preferences | Property Listings | Sitemap | Accessibility

Powered by Lofty Inc. Copyright 2025. All Rights Reserved.

IDX information is provided exclusively for consumers’ personal, non-commercial use and that it may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information deemed reliable but not guaranteed to be accurate. Listing information updated daily.
default
      Home
      Search
      Buy
      1. Our Listings
      2. Mortgage Calculator
      3. Pre-Sale Renovations
      Sell
      1. Sell My Home
      2. Market Snapshot
      Home Valuation
      Explore
      1. Pacific Heights Overview
      2. Inner Richmond Overview
      3. Presidio Heights Overview
      4. Jordan Park/Laurel H Listings
      5. Lower Pacific Height Listings
      Blogs
      About
      1. About Us
      2. Contact Us
Sterling Homes

Anna Spathis & Dennis Stavropoulos License ID: 01416042

+1(415) 810-5291 info@sterlinghomesre.com

2181 GREENWICH ST 2ND FL SAN FRANCISCO, CA 94123

Get My App

Terms of Service & Privacy Policy | Cookie Policy | Cookie Preferences | Property Listings | Sitemap | Accessibility

Powered by Lofty Inc. Copyright 2025. All Rights Reserved.

IDX information is provided exclusively for consumers’ personal, non-commercial use and that it may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information deemed reliable but not guaranteed to be accurate. Listing information updated daily.