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.
Listed by Matt Yusufzai
·
License #01452922
·
Alliance Bay Realty
·
510-990-2181
Last updated September 08, 2025
·
Source: MLSListings #ML82015708
Listing Facts
TypeSingle-family
NeighborhoodMission Valley
Bedrooms6
Days on Prevu5
HOA/Maint. Fees$257/month
Size4,740 sqft
Price per sqft$1,200
Amenities
Pets Allowed
Parking
Location
Mortgage Calculator
Listing History
09/04/2025
Listed by Alliance Bay Realty
$5,688,000
Property Details for 231/233 Cavalo Court
Association
Fees
Association Fee: $257.00 Monthly
General
Association Name: Orchard Heights Homeowners Association
Exterior
Construction
New Construction: Yes
Roof: Metal
Stories: 2
Year Built: 2025
Year Built Details: 6
Measurements
Building Area Total: 4,740
Lot Size Acres: 0.30
Lot Size Area: 13,306
Lot Size Source: Assessor
Lot Size Square Feet: 13,306
Lot Size Units: Square Feet
Financial
Taxes
Parcel Number: 513-0756-071
Interior
Features
Appliances: Garbage Disposal, Hood Over Range, Microwave, Oven Range - Built-In, Oven Range - Electric, Refrigerator, Wine Refrigerator
Fireplace Features: Family Room, Insert, Living Room
Fireplaces Total: 2
Flooring: Hardwood, Tile
Measurements
Living Area: 4,740
Rooms
Bathrooms Full: 5
Bathrooms Half: 1
Bedrooms Total: 6
Parking
Parking
Garage Spaces: 2
Garage: Yes
Parking Features: Detached
Schools
Elementary School
Elementary School District: Fremont Unified
High School
High School District: Fremont Unified
Utilities
Equipment
Cooling: Ceiling Fan, Central Forced Air, Multi-Zone
Heating: Central Forced Air, Solar
Laundry Features: Inside
Sewer: Public Sewer
Utilities: Public Utilities, Water - Public, Solar
Water Source: Public
Based on information from MLSListings™️ and/or other sources. All data, including all measurements and calculations of area, is obtained from various sources and has not been, and will not be, verified by Prevu or the MLS. Information is provided exclusively for consumer's personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumer may be interested in purchasing.
Rebate estimate is indicative only and based on listing price and estimated buyer's agent commission paid by owner, if applicable. Final rebates are subject to Terms of Use and may vary due to final negotiated transaction terms.