Home | Alameda County | Fremont | 94536 | 210 D St
MLS: BE41153087 | Status: Active | Price: $2,199,000
Beds/Baths: 5 / 4
Property Type: Residential
| Beds | Baths | Sq Ft | Acres Lot | Yr Built |
|---|---|---|---|---|
| 5 | 4 | 2,665 | 0.26 | 1959 |
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
| Field | Value |
|---|---|
| MLS # | BE41153087 |
| MLS Source | Bay East |
| Days on Site | 4 |
| Feature | Details |
|---|---|
| Kitchen | Countertop - Tile |
| Appliances | Cooktop - Electric, Dishwasher, Garbage Disposal |
| Dining Room | Formal Dining Room |
| Fireplace | Family Room |
| Flooring | Tile, Wood |
| Laundry | In Garage |
| Cooling | Window/Wall Unit |
| Feature | Details |
|---|---|
| Roof | Composition |
| Pool | None, Pool - No |
| Style | Cape Cod, Craftsman |
| Feature | Details |
|---|---|
| Garage/Parking | Detached, Garage, Gate/Door Opener, Garage: 3 Car(s) |
Kathy Bartle
Legacy Real Estate & Assoc.
License #: 00820845
Phone: (510) 589-3509
School data provided by GreatSchools.org
| School | Type | Grades | Distance | Rating |
|---|---|---|---|---|
| Niles Elementary School | public | TK,KG,1,2,3,4,5 | 0.10 mi | 9 |
| Parkmont Elementary School | public | TK,KG,1,2,3,4,5 | 1.13 mi | 9 |
| Vallejo Mill Elementary School | public | TK,KG,1,2,3,4,5 | 1.37 mi | 6 |
| California School For The Blind | public | K-12 | 1.56 mi | N/A |
| Centerville Middle School | public | 6-8 | 1.62 mi | 8 |
| California School For The Deaf-Fremont | public | K-12 | 1.69 mi | N/A |
| Brookvale Elementary School | public | TK,KG,1,2,3,4,5 | 1.70 mi | 7 |
| Washington High School | public | 9-12 | 1.75 mi | 9 |
| American High School | public | 9-12 | 1.88 mi | 10 |
| Oliveira Elementary School | public | TK,KG,1,2,3,4,5 | 2.06 mi | 8 |
| Thornton Middle School | public | 6-8 | 2.17 mi | 9 |
| Tom Maloney Elementary School | public | TK,KG,1,2,3,4,5 | 2.24 mi | 7 |
| Guy Jr. Emanuele Elementary School | public | K-5 | 2.29 mi | 7 |
| James Logan High School | public | 9-12 | 2.40 mi | 8 |
| New Haven Adult | public | UG | 2.40 mi | N/A |
| Glenmoor Elementary School | public | K-5 | 2.45 mi | 8 |
| Warwick Elementary School | public | TK,KG,1,2,3,4,5 | 2.50 mi | 9 |
| Brier Elementary School | public | TK,KG,1,2,3,4,5 | 2.54 mi | 5 |
| Glankler Early Learning Center | public | KG | 2.59 mi | N/A |
| J. Haley Durham Elementary School | public | TK,KG,1,2,3,4,5 | 2.61 mi | 9 |
| Address | Price | Beds | Baths | Sq Ft | Status |
|---|---|---|---|---|---|
| 3249 Greenwood Dr | $2,599,000 | 4 | 3 | 2,919 | Active |
| 35924 Nicolet Ct | $1,820,000 | 4 | 3 | 2,160 | Active |
| 35924 Nicolet Ct | $1,820,000 | 4 | 3 | 2,160 | Active |
| 38011 Temple Way | $1,799,500 | 6 | 4/1 | 2,492 | PendingDoNotShow |
©2026 Bay East. All rights reserved. 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. Information provided is for personal, non-commercial use by the viewer and may not be redistributed without explicit authorization from Bay East.
Presently MLSListings.com displays Active, Contingent, Pending, and Recently Sold listings. Recently Sold listings are properties which were sold within the last three years. After that period listings are no longer displayed in MLSListings.com. Pending listings are properties under contract and no longer available for sale. Contingent listings are properties where there is an accepted offer, and seller may be seeking back-up offers. Active listings are available for sale.
This listing information is up-to-date as of November 05, 2026. For the most current information, please contact Kathy Bartle, (510) 589-3509.