210 D St

Rare & Exceptional Niles Estate with Fully Permitted ADU. An incredible value in the heart of Niles, this rare estate offers the perfect blend of timeless architecture, refined craftsmanship, and true multi-generational living. The stunning Cape Cod residence with elegant carriage-house influences showcases enduring character and quality throughout. The main home offers approximately 1,750 sq. ft. with 3 bedrooms and 2 baths, including a bedroom and full bath on the main level. Vintage charm abounds, highlighted by beautiful built-in cabinetry in the formal dining room. The property is situated on a picturesque 1/4 lot surrounded by classic white picket fencing and includes a 2-car garage. Complementing the property is a fully permitted 900 sq. ft. accessory dwelling unit, built in 2009. This beautifully designed 2-bedroom, 2-bath apartment features vaulted ceilings, a bedroom and full bath on the main level, and enjoys a private setting above its own attached single-car garage. With a separate address and individually metered utilities, the ADU offers exceptional flexibility for extended family, guests, or valuable rental income potential. Just one block away, enjoy all that historic downtown Niles has to offer, including antique shops, restaurants, cozy cafés, a weekly farmers market, and popular community events such as classic car shows, parades, and the renowned Niles Antique Faire. Outdoor enthusiasts will appreciate nearby access to Alameda Creek hiking and biking trails, while the scenic Niles Canyon Railway provides memorable excursions through one of the Bay Area's most beautiful landscapes. A truly special opportunity to own a distinctive property offering charm, versatility, and an unbeatable location in one of Fremont's most cherished historic neighborhoods.

Current Status

New

Original Price

$2,199,000

List Price

$2,199,000

On Market Date

Nov 5, 2026

Property Type

Detached

D/N/S

Niles

Zip Code

94536

MLS ID

41153087

APN

50724017

Year Built

1959

Stories in Building

2

Possession

Negotiable

Data Source

MAXEBRDI

Origin MLS System

BAY EAST

Bed

5

Bath

4

Parking

3

Detached, Garage Door Opener

SQ FT

2,665

SQ FT Source

Public Records

Lot SQ FT

11,275.0

Lot Acres

0.26 Acres

Pool Info

None

Kitchen

Dishwasher, Electric Range, Tankless Water Heater, Tile Counters, Electric Range/Cooktop, Disposal

Cooling

Wall/Window Unit(s)

Disclosures

Disclosure Package Avail

Entry Level

Exterior Details

Back Yard, Front Yard, Side Yard

Flooring

Tile, Wood

Foundation

Fire Place

Family Room

Heating

Central

Laundry

In Garage

Upper Level

2 Bedrooms, 1 Bath

Main Level

1 Bedroom, 1 Bath

Possession

Negotiable

Architectural Style

Cape Cod, Craftsman

Construction Status

Existing

Additional Miscellaneous Features

Back Yard, Front Yard, Side Yard

Location

Corner Lot

Roof

Composition Shingles

Water and Sewer

Public

Fee

Unavailable

MLS and other Information regarding properties for sale as shown in Theo have been obtained from various sources such as sellers, public records, agents and other third parties. This information may relate to the condition of the property, permitted or unpermitted uses, zoning, square footage, lot size/acreage or other matters affecting value or desirability. Unless otherwise indicated in writing, neither brokers, agents nor Theo have verified, or will verify, such information. If any such information is important to buyer in determining whether to buy, the price to pay or intended use of the property, buyer is urged to conduct their own investigation with qualified professionals, satisfy themselves with respect to that information, and to rely solely on the results of that investigation.

School data provided by GreatSchools. School service boundaries are intended to be used as reference only. To verify enrollment eligibility for a property, contact the school directly.