Updated top-floor corner unit in a gated complex, 2BR/2BA single-level home with new interior paint, plush carpet, and new dual-pane windows/balcony doors. Enjoy bright rooms with added ceiling lights, a convenient inside laundry, an assigned carport, lots of guest parking spaces, and private balcony storage. Low $450 HOA includes a pool & spa. Top-rated schools: Leitch/Warm Springs, Horner, Irvington. Commuter's dream near Tesla, BART, I-680, I-880, parks, shopping, supermarkets & dining. Turn-key and ready for you!
Pending
$609,000
404 Sequim Cmn, Fremont, CA 94539
2beds
897sqft
Residential, Condominium
Built in 1985
-- sqft lot
$-- Zestimate®
$679/sqft
$450/mo HOA
What's special
Pool and spaPrivate balcony storageNew interior paintGated complexUpdated top-floor corner unitAssigned carportConvenient inside laundry
- 38 days |
- 202 |
- 6 |
Zillow last checked:
Listing updated:
Listed by:
Jason Huang DRE #01275030 510-755-6236,
Nihow Real Estate, Inc.
Source: Bay East AOR,MLS#: 41135133
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 2
- Bathrooms: 2
- Full bathrooms: 2
Rooms
- Room types: 2 Bedrooms, 2 Baths, Other
Kitchen
- Features: Electric Range/Cooktop, Other
Heating
- Forced Air
Cooling
- None
Appliances
- Included: Electric Range, Dryer, Washer
- Laundry: In Unit
Features
- Flooring: Carpet, Other
- Has fireplace: No
- Fireplace features: None
- Common walls with other units/homes: Corner Unit,End Unit
Interior area
- Total structure area: 897
- Total interior livable area: 897 sqft
Video & virtual tour
Property
Parking
- Parking features: Carport
- Has carport: Yes
Features
- Levels: Other,One
- Patio & porch: Deck
- Pool features: In Ground, Community
Lot
- Size: 0.33 Acres
- Features: Other
Details
- Parcel number: 5191246240
- Special conditions: Standard
Construction
Type & style
- Home type: Condo
- Architectural style: Contemporary
- Property subtype: Residential, Condominium
Materials
- Other
- Roof: Other
Condition
- Existing
- New construction: No
- Year built: 1985
Utilities & green energy
- Electric: No Solar
- Sewer: Public Sewer
- Water: Public
Community & HOA
Community
- Subdivision: Warm Springs
HOA
- Has HOA: Yes
- Amenities included: Greenbelt, Pool, Gated, Other
- Services included: Common Area Maint, Maintenance Structure, Management Fee, Reserve Fund, Security, Trash, Water/Sewer, Other
- HOA fee: $450 monthly
- HOA name: SILVERTREE MOHAVE
- HOA phone: 510-659-8969
Location
- Region: Fremont
Financial & listing details
- Price per square foot: $679/sqft
- Tax assessed value: $224,993
- Price range: $609K - $609K
- Date on market: 5/31/2026
- Listing agreement: Excl Right
- Listing terms: Cash,Conventional
Estimated market value
Not available
Estimated sales range
Not available
$3,166/mo
Price history
| Date | Event | Price |
|---|---|---|
| 6/15/2026 | Pending sale | $609,000$679/sqft |
Source:  Bay East AOR #41135133 Report a problem | ||
| 5/31/2026 | Listed for sale | $609,000$679/sqft |
Source: Bay East AOR #41135133 Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | -- | $224,993 +2% |
| 2024 | $3,218 +3.2% | $220,581 +2% |
| 2023 | $3,119 +2% | $216,257 +2% |
| 2022 | $3,059 +2.1% | $212,017 +2% |
| 2021 | $2,995 +2.3% | $207,860 +1% |
| 2020 | $2,927 +1% | $205,729 +2% |
| 2019 | $2,898 +4.6% | $201,696 +2% |
| 2018 | $2,769 | $197,742 +2% |
| 2017 | $2,769 +2.1% | $193,865 +2% |
| 2016 | $2,711 +3.6% | $190,065 +1.5% |
| 2015 | $2,617 | $187,210 +2% |
| 2014 | $2,617 | $183,543 +0.5% |
| 2013 | -- | $182,715 +2% |
| 2012 | -- | $179,132 +2% |
| 2011 | -- | $175,620 +0.8% |
| 2010 | -- | $174,308 -0.2% |
| 2009 | -- | $174,724 +2% |
| 2008 | -- | $171,298 +2% |
| 2007 | -- | $167,940 +2% |
| 2006 | -- | $164,647 +2% |
| 2005 | -- | $161,419 +2% |
| 2004 | -- | $158,255 +1.9% |
| 2003 | -- | $155,356 +2% |
| 2002 | -- | $152,309 +2% |
| 2001 | $1,773 | $149,322 |
Find assessor info on the county website
Monthly payment
Est. payment$--/mo
Payment breakdown
Explore the cost of this home by adjusting the details. Changes won't be saved.All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
Mortgage interest rates are dependent on a number of factors, including credit score, down payment, and repayment length. Interest rate data provided by Zillow Group Marketplace, Inc. as of 1/1/1970 from various mortgage lenders with which we have lead or other similar arrangements; the Estimated Payment is an average of those rates.
See how much you could borrow to make a competitive offer.
Climate risks
Neighborhood: Warm Springs
Nearby schools
GreatSchools rating
- NAJames Leitch Elementary SchoolGrades: K-2Distance: 0.3 mi
- 9/10John M. Horner Middle SchoolGrades: 6-8Distance: 3.5 mi
- 10/10Irvington High SchoolGrades: 9-12Distance: 3.2 mi
Schools provided by the listing agent
- District: Fremont (510) 657-2350
Source: Bay East AOR. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.
A local agent can set up tours, give advice and negotiate with sellers.
Local buyer's agents are ready to help
- California
- Alameda County
- Fremont
- 94539
- Warm Springs
- 404 Sequim Cmn
Nearby cities
Nearby neighborhoods
Nearby zip codes
Other Fremont Topics
