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

Maya Hiersoux

mayaca@mayahiersoux.com +1(415) 971-3559

$1,999,999

Est. payment - /mo

5 Beds

3 Baths

1,992 SqFt

Save Virtual Tour

Open House

Sat Jun 20, 12:00pm - 4:15pm

Sun Jun 21, 12:00pm - 4:15pm

UPDATED:

Key Details

Property Type Single Family Home

Sub Type Single Family Residence

Listing Status Active

Purchase Type For Sale

Square Footage 1,992 sqft

Price per Sqft $1,004

Subdivision Sundale

MLS Listing ID 41138001

Bedrooms 5

Full Baths 3

HOA Y/N No

Year Built 1960

Lot Size 0.270 Acres

Acres 0.27

Property Sub-Type Single Family Residence

Property Description

Anthropic or OpenAI stock will be considered as payment. Freshly built and thoughtfully reimagined with meticulous attention to detail, this stunning rare northeast-facing 5-bedroom, 3-full-bath modern home is tucked away at the end of a private cul-de-sac with breathtaking views and showcases exceptional craftsmanship, thoughtful design, and high-end finishes throughout. Featuring two en-suite bedrooms, Taj Mahal quartzite countertops, sleek European-style cabinetry, engineered hardwood flooring, premium stainless steel appliances, and designer finishes, every detail has been carefully curated. The sun-filled open-concept floor plan offers seamless flow for entertaining and everyday living. Large windows flood the home with natural light, creating a warm and inviting atmosphere. Major improvements include a brand-new Bosch HVAC system, new roof, and fully permitted construction, providing lasting value and peace of mind. Situated on an oversized lot with convenient side access, this property offers incredible ADU potential and future expansion opportunities. Whether you envision a guest house, rental unit, home office, gym, or multigenerational living space, the possibilities are endless. Ideally located near top-rated Fremont schools, parks, shopping, dining, BART, and major commuter routes, this move-in-ready home combines privacy, views, modern design, and investment potential. A rare opportunity to own a beautifully designed property with high-end finishes, an oversized lot, ADU potential, and flexible living options in one of Fremont's most desirable locations. This exceptional property delivers the perfect blend of luxury, functionality, and long-term value for today's discerning buyer.

Location

State CA

County Alameda

Rooms

Basement Crawl Space

Interior

Interior Features Family Room, Breakfast Nook, Updated Kitchen

Heating Forced Air

Cooling Central Air, Other

Flooring Other

Fireplaces Type None

Fireplace No

Appliance Dishwasher, Refrigerator

Laundry 220 Volt Outlet, Hookups Only

Exterior

Exterior Feature Back Yard, Front Yard

Garage Spaces 2.0

Pool None

View Y/N true

View Hills, Other

Handicap Access Other

Private Pool false

Building

Lot Description Cul-De-Sac, Back Yard

Story 1

Sewer Public Sewer

Water Public

Architectural Style Ranch

Level or Stories One Story

New Construction Yes

Others

Virtual Tour https://my.matterport.com/show/?m=v8W5A1d9ctg&brand=0&mls=1&

Read Less Info

© 2026 BEAR, CCAR, bridgeMLS. This information is deemed reliable but not verified or guaranteed. This information is being provided by the Bay East MLS or Contra Costa MLS or bridgeMLS. The listings presented here may or may not be listed by the Broker/Agent operating this website.

Listed by JohnNick Porcuna • Intero Real Estate Services

NEARBY SCHOOL & BUSINESS

GET MORE INFORMATION

Maya Hiersoux

+1(415) 971-3559

Agent | License ID: 01450016

Agent License ID: 01450016

4683 De Silva St. Fremont, CA 94538

Maya Hiersoux

Open House

Key Details

Location

Rooms

Interior

Exterior

Building

Others

NEARBY SCHOOL & BUSINESS

GET MORE INFORMATION