REQUEST A TOUR If you would like to see this home without being there in person, select the "Virtual Tour" option and your agent will contact you to discuss available opportunities.
In-PersonVirtual Tour
$ 2,399,800
Est. payment /mo
Pending
40249 San Sebastian PL Fremont, CA 94539
4 Beds
3 Baths
1,990 SqFt
UPDATED:
Key Details
Property Type Manufactured Home
Sub Type Single Family Home
Listing Status Pending
Purchase Type For Sale
Square Footage 1,990 sqft
Price per Sqft $1,205
Lot Size 7,000 Sqft
MLS Listing ID ML82061142
Bedrooms 4
Full Baths 3
Property 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.
Location
State CA
County Alameda
Area Fremont
Zoning R-1
Rooms
Family Room Separate Family Room
Dining Room Dining Area
Interior
Heating Central Forced Air
Cooling Central AC
Flooring Vinyl / Linoleum
Fireplaces Type Family Room, Insert
1-purchase type For Sale
Exterior
Garage Attached Garage
Garage Spaces 2
Utilities Available Public Utilities
Roof Type Clay,Tile
Building
Story 2
Foundation Concrete Slab, Crawl Space
Sewer Sewer - Public
Water Public
Story 2
Others
Tax ID 525-0003-095
Horse Property No
Special Sale Not Applicable
© 2026 MLSListings Inc. All rights reserved.-test9
Listed by Mindy Ni of Coldwell Banker Realty
Bought with Mindy Ni of Coldwell Banker Realty
Bought with Mindy Ni of Coldwell Banker Realty
