Realty Solution
Powered by 
- 0
- 17
- Overview
- Description
- Property Details
- Location
- Facts & Features
- Getting Around
- Nearby Homes
Listed by: Mindy Ni (650) 772-0268 DRE #02050762, Magic Li DRE #02094579 | Coldwell Banker Realty (408) 252-1133
$2,399,800
Monthly Est:$11,945
4 Beds
3 Baths3 full baths
1,990sqft
40249 San Sebastian Pl, Fremont, CA 94539
$2,399,800
$11,945/moEst:
Get Pre-Approved
Single Family Residence
Built in 1968
$-- HOA
7,000 sqft lot
$1,206/sq.ft
Description
Fully reimagined in 2026 and finished to a level rarely seen in Mission San Jose. Custom wood double doors open to a dramatic arched entry soaring ceilings and a sculptural chandelier cascading over LED-lit stairs set the tone for the entire home. The layout is what buyers look for and seldom find: a light-filled living room flowing into a separate formal dining room, a built-in wet bar, and a designer kitchen with custom oak cabinetry, quartz counters, full-height slab backsplash and stainless appliances. Wide-plank floors and recessed lighting throughout. The serene primary suite is anchored with enlarged shower, artisan tile and elegant nickel fixtures. All work completed with permits brand-new HVAC, new dual-pane windows & doors, electrical subpanel, all-new kitchen and baths. Both yards are fully finished: level lawn, wide entertaining patio, stone pathways, drought-tolerant landscaping. Nothing left to do but move in. Top-rated Gomes Elementary, Hopkins Middle and Mission San Jose High. Minutes to I-680/880, BART and Mission San Jose shopping.
- Houzeo last checked: 6 minutes ago
- Listing updated: September 28, 2026 at 8:21 pm
- Source: California Regional MLS-CA | MLS#: ML82061142
Property Details
Status
Pending
Type
Single Family Residence
No. of Stories
2
County
City
Neighborhood
Year Built
1968
HOA Fees
-
Finished Area
1,990 sqft
Lot Size
7,000 sqft lot
Basement Area
- sqft
MLS Name
California Regional MLS
MLS Number
ML82061142
MLS Status
Pending
Days on Market
21
Continue Your Journey in App
Find your dream home, receive real-time updates, and many more!
Download App
Continue Your Journey in App
Find your dream home, receive real-time updates, and many more!
Location
Facts & Features
Rooms
Bedrooms & bathrooms
Bedrooms: 4
Bathrooms: 3
Interior
Heating
Central
Cooling
Central Air
Sewer
Public Sewer
Construction
Year Built
Year Built: 1968
Home type
Single Family Residence
Foundation Details
Slab
Roof
Clay, Tile
Utilities & Energy
Water Source
Public
Fireplace Features
Family Room
Price History
| Date | Event | Price |
|---|---|---|
09/27/2026 Source: | Pending | $2,399,800 $1,206/sqft |
09/13/2026 Source: | Listed for Sale | $2,399,800 +33.40% $1,206/sqft |
05/27/2026 Source: | Sold | $1,799,000 -13.51% $904/sqft |
05/27/2026 Source: | Price Increased | $2,080,000 +15.62% $1,045/sqft |
04/28/2026 Source: | Pending | $1,799,000 $904/sqft |
Show more
Nearby Homes
Find Homes by Property Features in Fremont, CA
Based on information from California Regional Multiple Listing Service, Inc. as of Oct 08, 2026, 10:45PM and /or other sources. All data, including all measurements and calculations of area, is obtained from various sources and has not been, and will not be, verified by broker or MLS. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information. Information being 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. This website may not include listings or property addresses of sellers who have directed their listing brokers to withhold their listing or their property address from display on the Internet. © 2026 California Regional Multiple Listing Service. All Rights Reserved.
Advertising Broker: William Johnson DRE #01463271 | William Johnson Brokerage