210 D St St, Fremont, CA 94536 (MLS # 41146881)
Request More Info
Share
Print
|
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.
| Last Updated | 9/24/2026 | Tract | NILES |
|---|---|---|---|
| Year Built | 1959 | Garage Spaces | 3.0 |
| County | Alameda |
Additional Details
| AIR | Wall/Window Unit(s) |
|---|---|
| AIR CONDITIONING | Yes |
| CONSTRUCTION | Wood Siding |
| FIREPLACE | Yes |
| GARAGE | Attached Garage, Yes |
| LOT | 0.2588 acre(s) |
| LOT DESCRIPTION | Back Yard, Corner Lot, Front Yard |
| LOT DIMENSIONS | 11275 |
| PARKING | Attached, Garage, Garage Door Opener |
| POOL DESCRIPTION | None |
| STORIES | 2 |
| STYLE | CapeCod, Craftsman |
| SUBDIVISION | NILES |
Location
Based on information from CRMLS as of 9/24/26 11:13 PM PDT. The information being provided by CRMLS is for the visitor's personal, noncommercial use and may not be used for any purpose other than to identify prospective properties visitor may be interested in purchasing. The data contained herein is copyrighted by CRMLS, CLAW, CRISNet MLS, i-Tech MLS, PSRMLS and/or VCRDS and is protected by all applicable copyright laws. Any dissemination of this information is in violation of copyright laws and is strictly prohibited.
Any property information referenced on this website comes from the Internet Data Exchange (IDX) program of CRISNet MLS and/or CRMLS. 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.
This IDX solution is (c) Diverse Solutions 2026.
Twitter
Facebook
Email