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

Sat

Sep

Sun

Sep

Mon

Sep

Basak Cakici

basakcakici@gmail.com +1(510) 684-3939

$ 5,688,000

Est. payment | -/mo

6 Beds

5.5 Baths

4,740 SqFt

Save

$ 5,688,000

Est. payment | -/mo

Save

6 Beds

5.5 Baths

4,740 SqFt

Open House

Sat Sep 06, 1:00pm - 4:00pm

Sun Sep 07, 1:00pm - 4:00pm

Key Details

Property Type Single Family Home

Sub Type Single Family Residence

Listing Status Active

Purchase Type For Sale

Square Footage 4,740 sqft

Price per Sqft $1,200

MLS Listing ID ML82015708

Bedrooms 6

Full Baths 5

Half Baths 1

HOA Fees $257/mo

HOA Y/N Yes

Year Built 2025

Lot Size 0.305 Acres

Acres 0.3055

Property Sub-Type Single Family Residence

Property Description

Stunning New Custom Home with Bay & Hills Views in Fremonts Orchard Heights. Welcome to this extraordinary brand-new home located in the prestigious Orchard Heights subdivision of Fremont. Perched at the top of a quiet cul-de-sac, this home offers sweeping panoramic views of the lower San Francisco Bay from the front and backs directly onto the scenic Mission Hills. The main residence spans a 4,341 square feet of thoughtfully designed living space with 4 bedrooms each with its own en-suite bathroom. Also, an expansive upstairs loft provides a flexible space thats perfect for a media room, home office, or recreational area. The heart of the home is the open concept living area, filled with natural light from numerous large windows that frame the stunning views. The large chefs kitchen featuring a generous island, top-tier appliances, and a charming breakfast nook. A standout feature of the property is the fully permitted 400-square-foot Accessory Dwelling Unit (ADU), located above the detached garage and complete with its own address. This private unit includes a full kitchen, a walk-in closet, and a bathroom. The ADU offers an unobstructed view of the bay to the front and the rolling hills behind, making it ideal for extended family, guests, or potential rental income.

Location

State CA

County Alameda

Zoning R

Interior

Interior Features Pantry

Heating Forced Air, Solar

Cooling Ceiling Fan(s), Central Air

Flooring Hardwood, Tile

Fireplaces Number 2

Fireplaces Type Family Room, Insert, Living Room

Fireplace Yes

Appliance Microwave

Exterior

Garage Spaces 2.0

Private Pool false

Building

Story 2

Level or Stories Two Story

New Construction No

Schools

School District Fremont (510) 657-2350

Others

Tax ID 5130756071

© 2025 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 Matt Yusufzai • Alliance Bay Realty

GET MORE INFORMATION

Basak Cakici

Realtor & Architect | License ID: DRE# 02035715

+1(510) 684-3939

231/233 Cavalo Court Fremont, CA 94539

Basak Cakici

Open House

Key Details

Location

Interior

Exterior

Building

Schools

Others

GET MORE INFORMATION

Go tour this home

231/233 Cavalo Court