Jennifer Hamilton, DRE#01800791, Owner/Broker
REALTOR®, CRP, GRP, Director of Relocation
(805) 543-2172 ext. 30
BEDS4
BATHS3 full
SQUARE FEET1,990
MLS#ML82061142
STATUSActive
PROPERTY TYPEResidential - Single Family
SCHOOLFremont Unified
Listing Courtesy of:
Coldwell Banker Realty
Agency Phone: (408) 252-1133
Associate Name: Mindy Ni
Listing Shown by:
Farrell Smyth, Inc.
Associate Name: Jennifer Hamilton, DRE#01800791, Owner/Broker
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.
Property Features
Property Type: Residential - Single Family
Cooling: CentralAir
Garage: 2 car attached
Heating: Central
Lot Size: 0.16 Acres
Roof Type: Clay, Tile
Stories: 2.0
Year Built: 1968
Feature Descriptions
Fireplace: FamilyRoom
Parcel#: 5250003095
Sewer: PublicSewer
Water: Public
Local Schools
School District: Fremont Unified
Listed By / Shown By
Listed By
Agency Name: Coldwell Banker Realty
Agent Name: Mindy Ni
Agency Phone: (408) 252-1133
Shown By
Agent Name: Jennifer Hamilton, DRE#01800791, Owner/Broker
Agent Phone: (805) 543-2172 ext. 30
Agency Title: Farrell Smyth, Inc.
Estimate Your Payment
Estimated Payment
$ 6,040.86 per month $5,340.91 Principal & Interest $0.00 Property Tax (data not provided by mls) $699.94 Homeowner's InsuranceChange Payment Information
Jennifer Hamilton, DRE#01800791, Owner/Broker
Office: (805) 543-2172 ext. 30
Email Me
Privacy Policy / DMCA Notice / ADA Accessibility
This site is hosted, designed and copyright
© 1994 - 2026 by
Delta Media Group, Inc. -- Patent Pending --
40249 San Sebastian Place | MLS# ML82061142
This single family home located at 40249 San Sebastian Place , Fremont, CA 94539 is currently listed for sale with an asking price of $2,399,800. This property was built in 1968 and has 4 bedrooms and 3 full baths with 1990 sq. ft. San Sebastian Place is located within the Fremont Unified school district. Search Fremont real estate on jenniferhamilton.farrellsmyth.com today.