210 D St, Fremont, CA 94536

$2,199,000
5
BD
4
BA
2,665
SqFt

Show Photos

Verify your account to unlock exclusive photos, mortgage tools, and more.

Listed by Kathy Bartle, (510) 589-3509 from Legacy Real Estate & Assoc.
(If provided) CoList: from

List Price
$2,199,000
MLS#
BE41153087
Status
ACTIVE
Levels
Two Story
Bedrooms
5
Total Bathrooms
4
Full Bathrooms
4
Sqft. of Residence
2,665
Lot Size
11,275
Listing Area
Fremont
Year Built
1959

Property Description

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

Additional Information

Acres
0.26
Cooling System
Window / Wall Unit
Exterior Features
Siding - Wood
Fireplace Description
Family Room
Floor Covering
Tile, Wood
Garage Parking
Detached Garage, Garage, Gate / Door Opener
Laundry Facilities
In Garage
Levels
Two Story
Living Area
2,665
Lot Size
11,275
Neighborhood
Fremont
Other Rooms
Guest House
Pool Description
Pool - No, None
Roof
Composition
Style
Craftsman, Cape Cod
Unincorporated Yn
Yes

How much is your home worth?

...get instant property value now!

Mortgage Calculator

Amount of Loan
Annual Interest Rate
%
Term of Loan
Years

Does not include any taxes or fees.
Please consult a financial professional.
Calculator source: Real Geeks

board logoThe data relating to real estate for sale on this display comes in part from the Internet Data Exchange program of the MLSListingsTM MLS system. Real estate listings held by brokerage firms other than JABEZ REALTY are marked with the Internet Data Exchange and detailed information about them includes the names of the listing brokers and listing agents.
Based on information from MLSListings MLS as of . All data, including all measurements and calculations of area, is obtained from various sources and has not been, and will not be, verified by broker or MLS. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information.


Copyright 2026 MLSListings Inc. All rights reserved