• Facebook
  • Instagram
Phone310-890-6928
Login or sign up for new accountLogin / Register
Email MeEmail Me
  • Search Listings
    • Residential
    • Lease
  • My Listings
  • Previous Sales
  •   Buyers
    • Renting vs. buying
    • How much can I afford?
    • Why work with a real estate agent
    • Finding your home
    • What do you want in a home?
    • Submitting an offer
    • After the offer is accepted
    • Moving
  •     Sellers
    • Why work with a real estate agent
    • Getting your home ready for sale
    • Pricing your home to sell
    • Negotiating the sale
    • Transaction management
    • Moving
  •     Services
    • Onepoint
    • Home Financing
    • Insurance
    • Escrow
    • Title
    • Home Warranty
    • PRESALE/STAGING
    • Relocation
  •     About
    • Leadership Team
    • About Us
    • Globally Respected
    • The Charitable Foundation
    • Diversity & Inclusion
    • Agents Only
Menu
Berkshire Hathaway HomeServices California Properties Berkshire Hathaway HomeServices California Properties
Any Price
-
  • 0
  • $100,000+
  • $250,000+
  • $500,000+
  • $750,000+
  • $1,000,000+
0+ Beds
  • 0+
  • 1+
  • 2+
  • 3+
  • 4+
  • 5+
0+ Baths
  • 0+
  • 1+
  • 2+
  • 3+
  • 4+
  • 5+
Property Type
Other
VIRTUAL TOUR
  • Home
  • 40249 San Sebastian Place

40249 San Sebastian Place, Fremont, CA 94539

$2,399,800 Approx. USD 4 beds, 3 baths
1,990 sqft

  VIRTUAL TOUR
Save My Notes
Share
  • Copy Link
  • Facebook
  • Twitter
  • Pinterest
Source MLS Verified
MORE INFO
BrochureBrochure Virtual Tour

Photo of Jesse Hlubik

Jesse Hlubik REALTOR® - Sales Associate 310-890-6928 m
310-890-6928 o
Lic#: 01801928
NRDS ID: 207054480
Jesse@HomeSearchLA.com Text Me
Call My Cell
Call My Office
Lic#: 01801928
NRDS ID: 207054480
Jesse@HomeSearchLA.com Sherman Oaks Office
14141 Ventura Blvd., Ste. 8
Sherman Oaks, CA 91423
Phone: 818-528-3200
Fax: 818-386-9007
 Sherman Oaks 14141 Ventura Blvd., Ste. 8
Sherman Oaks, CA 91423
Call Branch Office
Fax: 818-386-9007
Mortgage Calculator
GET PRE-APPROVED
Interested in This Property? Your message will be sent to Jesse.
By submitting your information, you consent to be contacted by email, SMS message, and/or phone call. You may opt out at any time per our Privacy Policy.
  • Save
  • My Notes

Listing Agent


Mindy Ni | mindynirealtor@gmail.com
Lic#: 02050762
Broker: Courtesy of Coldwell Banker Realty
Phone: 650-772-0268

Co Listing Agent


Magic Li | magickey718@gmail.com
Lic#: 02094579
Broker: Courtesy of Coldwell Banker Realty
Phone: 408-886-1624

Agent Remarks

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.

Listing Details

Property type: Single Family Residence (Single Family)
Status: Pending
MLS# ML82061142
Price: $2,399,800
Beds: 4
Baths: 3 (3 full)
Family Room fireplaces
Built in 1968
1,990 sqft
0.16 acres
Lot size: 0.1607
County: Alameda
Zoning: R-1
Heating/cooling: Central Air
Heating description: Central
MLS area: 699 - Not Defined

Last Updated: 9/28/2026

 Days On Market (DOM): 9

 Find more Fremont homes and real estate

 Find more homes in 94539 zip code

This listing belongs to the 699 - Not Defined MLS area

Lat/Long: 37.554627, -121.951306.
Find nearby listings

DISCLAIMER: There is NO WARRANTY, expressed or implied, for the accuracy of this information or its applicability to your financial situation. Please consult your financial and/or tax advisor. GET PRE-APPROVED The loan's interest rate will depend upon the specific characteristics of the loan transaction and credit profile up to the time of closing.

94539 Area Map

Demographics

Schools

CLICK TO VIEW MAP

Similar Listings

Next Listing
40361 Loro Pl VIRTUAL TOUR
40361 Loro Pl ,
$2,400,000 Approx. USD 3 beds, 2 baths

List Date: 9/24/2026
 Status: Pending
 MLS #: 41149078

My Notes Save
Listing courtesy of
40929 Canto Place VIRTUAL TOUR
40929 Canto Place ,
$2,288,000 Approx. USD 5 beds, 3 baths

List Date: 7/17/2026
 Status: Pending
 MLS #: ML82054570

My Notes Save
Listing courtesy of
1061 Whitmer Ct VIRTUAL TOUR
1061 Whitmer Ct ,
$2,288,000 Approx. USD 3 beds, 3 baths

List Date: 10/1/2026
 Status: Pending
 MLS #: 41149200

My Notes Save
Listing courtesy of
41551 Denise Street VIRTUAL TOUR
41551 Denise Street ,
$2,198,000 Approx. USD 4 beds, 3 baths

List Date: 9/16/2026
 Status: Active
 MLS #: ML82061452

My Notes Save
Listing courtesy of
42635 Sully St VIRTUAL TOUR
42635 Sully St ,
$2,480,000 Approx. USD 4 beds, 2 baths

List Date: 9/30/2026
 Status: Active
 MLS #: 41147862

My Notes Save
Listing courtesy of
1513 Shinn Court VIRTUAL TOUR
1513 Shinn Court ,
$2,049,000 Approx. USD 4 beds, 3 baths

List Date: 10/1/2026
 Status: Active
 MLS #: ML82062242

My Notes Save
Listing courtesy of
337 I St VIRTUAL TOUR
337 I St ,
$2,350,000 Approx. USD 6 beds, 3 baths

List Date: 6/23/2026
 Status: Active
 MLS #: 41139354

My Notes Save
Listing courtesy of
41717 Gifford Street VIRTUAL TOUR
41717 Gifford Street ,
$2,298,000 Approx. USD 4 beds, 3 baths

List Date: 9/4/2026
 Status: Pending
 MLS #: ML82057982

My Notes Save
Listing courtesy of
210 D St VIRTUAL TOUR
210 D St ,
$2,199,000 Approx. USD 5 beds, 4 baths

List Date: 9/24/2026
 Status: Active
 MLS #: 41146881

My Notes Save
Listing courtesy of
38660 Kimbro St VIRTUAL TOUR
38660 Kimbro St ,
$2,069,950 Approx. USD 5 beds, 3 baths

List Date: 8/27/2026
 Status: Pending
 MLS #: 41146336

My Notes Save
Listing courtesy of
Previous Listing
  • Search
    • My Active Listings
    • My Previous Sales
    • Residential
    • Lease
    • Open Houses
    • Commercial
    • New Homes
    • Luxury
  • Buyers
    • Renting vs. buying
    • How much can I afford?
    • Why work with a real estate agent
    • Finding your home
    • What do you want in a home?
    • Submitting an offer
    • After the offer is accepted
    • Moving
  • Sellers
    • Why work with a real estate agent
    • Getting your home ready for sale
    • Pricing your home to sell
    • Negotiating the sale
    • Transaction management
    • Moving
  • Services
    • Prosperity Home Mortgage
    • HomeServices Relocation
    • HomeServices Insurance Agency
    • Pickford Escrow
    • California Title Company
    • American Home Shield
    • PINNACLE
    • myNHD
  • About
    • Leadership Team
    • About Us
    • Globally Respected
    • The Charitable Foundation
    • Diversity & Inclusion
    • Agents Only

Photo of Jesse Hlubik

Jesse Hlubik REALTOR® - Sales Associate 310-890-6928 m
310-890-6928 o
Lic#: 01801928
NRDS ID: 207054480
Jesse@HomeSearchLA.com Text Me
Call My Cell
Call My Office
Lic#: 01801928
NRDS ID: 207054480
Jesse@HomeSearchLA.com
Sherman Oaks Office
14141 Ventura Blvd., Ste. 8
Sherman Oaks, CA 91423
hsoa-logo
  • Facebook
  • Instagram

© 2026 BHH Affiliates, LLC. An independently operated subsidiary of HomeServices of America, Inc., a Berkshire Hathaway affiliate, and a franchisee of BHH Affiliates, LLC. Berkshire Hathaway HomeServices and the Berkshire Hathaway HomeServices symbol are registered service marks of Columbia Insurance Company, a Berkshire Hathaway affiliate. Equal Housing Opportunity.
Lic#: 01317331

Photo of Equal Housing Opportunity Privacy Policy - California Privacy Notice - Terms of Use - Accessibility
Do Not Sell My Personal Information DMCA.com Protection Status