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

Bobby And Michelle Schaffer

sold@legacyhouserealty.com +1(951) 533-7744

$ 2,399,000

Est. payment | -/mo

5 Beds

4 Baths

2,665 SqFt

Save

$ 2,399,000

Est. payment | -/mo

Save

5 Beds

4 Baths

2,665 SqFt

Key Details

Property Type Single Family Home

Sub Type Single Family Residence

Listing Status Active

Purchase Type For Sale

Square Footage 2,665 sqft

Price per Sqft $900

Subdivision Niles

MLS Listing ID 41146881

Bedrooms 5

Full Baths 4

HOA Y/N No

Year Built 1959

Lot Size 0.259 Acres

Property Sub-Type Single Family Residence

Property Description

A rare and exceptional Niles estate offering - blending timeless architectural with true multi-generational living. Stunning Cape Cod with elegant Carriage-house influence, offers classic charm and refined craftsmanship. throughout. The main home features 1,750 sq. ft., 3 bedrooms, 2 baths (1 bed & full bath downstairs) and a 2-car garage, Classic vintage charm with beautiful built-in cabinetry in formal dining room, all set on a white-picket fenced ¼-acre lot. Complementing is a fully permitted 900 sq. ft. gorgeous 2-bedroom, 2-bath (1 bed & full bath downstairs) apartment built in 2009, complete with vaulted ceilings and privately situated above its own single-car garage. The ADU offers its own address, separate utilities, and exceptional flexibility—ideal for extended family, guests, or premium income potential. A short 1 block stroll will find you in the heart of historic downtown Niles, known for its antique shops, restaurants, cozy cafés, farmers market, and year-round events including car shows, parades, and the beloved Niles Antique Faire. Outdoor enthusiasts will appreciate easy access to Alameda Creek's hiking and biking trails, or you can hop aboard the local train for a breathtaking scenic round-trip ride through Niles Canyon. A truly special property combining elegance, versatility, and an unbeatable Niles setting.

Location

State CA

County Alameda

Rooms

Other Rooms Guest House

Interior

Cooling Wall/Window Unit(s)

Flooring Tile, Wood

Fireplaces Type Family Room

Fireplace Yes

Exterior

Parking Features Garage, Garage Door Opener

Garage Spaces 3.0

Garage Description 3.0

Pool None

Roof Type Shingle

Porch Patio

Total Parking Spaces 3

Private Pool No

Building

Lot Description Back Yard, Corner Lot, Front Yard, Yard

Story Two

Entry Level Two

Architectural Style Cape Cod, Craftsman

Level or Stories Two

Additional Building Guest House

New Construction No

Others

Tax ID 50724017

Acceptable Financing Cash, Conventional

Listing Terms Cash, Conventional

CRMLS Full IDX Feed (MAIN Website Search)

Listed by Kathy Bartle Legacy Real Estate & Assoc. #00820845

Nearby Locations

"My job is to find and attract mastery-based agents to the office, protect the culture, and make sure everyone is happy! "

+1(951) 533-7744

sold@legacyhouserealty.com

Temecula , California 92592, USA

210 D St Fremont, CA 94536

Bobby And Michelle Schaffer

Key Details

Location

Rooms

Interior

Exterior

Building

Others

Nearby Locations

GET MORE INFORMATION

Go tour this home

210 D St