210 D St, Fremont, CA 94536
- $2,399,000
- 5
- BD
- 4
- BA
- 2,665
- SqFt
Listed by Kathy Bartle, (510) 589-3509 from Legacy Real Estate & Assoc.
(If provided) CoList: from
- List Price
- $2,399,000
- MLS#
- BE41146881
- 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
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
/u.realgeeks.media/sanjoserealestatepro/Header_Logo-min.png){kind=logo}
Additional Information
- Acres
- 0.26
- Cooling System
- Window / Wall Unit
- Days On Market
- Unknown
- 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
Mortgage Calculator
The 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 Real Estate Company 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