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

Thu

Oct

Fri

Oct

Sat

Oct

Debbi DiMaggio Betta

debbi.dimaggio@corcoranicon.com +1(510) 414-6777

$ 1,850,000

Est. payment | -/mo

5 Beds

5 Baths

3,415 SqFt

Save Virtual Tour

$ 1,850,000

Est. payment | -/mo

Save Virtual Tour

5 Beds

5 Baths

3,415 SqFt

Open House

Sat Oct 18, 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 3,415 sqft

Price per Sqft $541

Subdivision Cherryland

MLS Listing ID 41114841

Bedrooms 5

Full Baths 4

Half Baths 2

HOA Y/N No

Year Built 2025

Lot Size 5,000 Sqft

Acres 0.12

Property Sub-Type Single Family Residence

Property Description

Dual-Unit New Construction Masterpiece Welcome to a newly complete home offering an impressive 3,415 sq ft of refined living space. Located in the "Heart of the Bay," it provides access to the entire San Francisco Bay Area via freeways, and BART. This rare offering combines luxurious living with built-in income potential, multi-generational flexibility, and the efficiency of owned solar panels. The Main Residence - 3 Bed 3.5 Bath 2,510 Sq Ft Elegance defines this two-story home. The open-concept design is anchored by a formal living space and a spectacular Dining/Family Room with a sleek LED fireplace. The gourmet kitchen boasts an oversized island and top-tier finishes. A convenient ground-floor primary suite with a full bath, plus a chic half bath, completes the main level. Upstairs, the landing is a flexible space for an gym, office or den. The luxurious Master Suite is a true sanctuary, complete with a gigantic walk-in closet and a spa-like ensuite featuring a magnificent soaking tub. The Income/Flex ADU - 2 Bed 1.5 Bath 905 Sqft The attached, two-story with a separate exterior entrance, asset offers potent potential for passive rental income or private quarters for extended family. This is where modern luxury meets savvy investment and sustainable living.

Location

State CA

County Alameda

Interior

Interior Features Den, Dining Area, Family Room, In-Law Floorplan, Counter - Solid Surface, Pantry, Updated Kitchen

Heating Zoned

Cooling Central Air, Wall/Window Unit(s), Multi Units, ENERGY STAR Qualified Equipment

Flooring Tile, Engineered Wood

Fireplaces Number 1

Fireplaces Type Family Room, See Remarks

Fireplace Yes

Appliance Dishwasher, Electric Range, Refrigerator, Electric Water Heater, ENERGY STAR Qualified Appliances

Laundry 220 Volt Outlet, Hookups Only, Laundry Room

Exterior

Exterior Feature Back Yard, Front Yard

Garage Spaces 2.0

Pool None

View Y/N true

View Other

Handicap Access None

Total Parking Spaces 4

Private Pool false

Building

Lot Description Back Yard, Front Yard, Landscaped, Paved

Story 2

Foundation Slab

Architectural Style Contemporary

Level or Stories Two Story, Two

New Construction Yes

Others

Tax ID 429558

Virtual Tour https://www.492-494sunsetblvd.com/unbranded

© 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 Remy Fortier • eXp Realty of California

GET MORE INFORMATION

Debbi DiMaggio Betta

REALTOR | Partner | Lic# 01047447

debbi.dimaggio@corcoranicon.com

+1(510) 414-6777

342 Highland Ave, Piedmont, CA, 94611, USA

492 Sunset Blvd Hayward, CA 94541

Debbi DiMaggio Betta

Open House

Key Details

Location

Interior

Exterior

Building

Others

492 Sunset Blvd