Coldwell Banker Home Page

Local Realty Service Provided By: Coldwell Banker Solano Pacific

Property view
Listing view 2
Listing view 3

210 D St, 
Fremont, CA 94536

$2,399,000


5

Beds


4

Baths


2,665

Sq Ft


Single Family

Coming Soon

Listed by

Kathy Bartle, Off: 510-744-3500

Legacy Real Estate & Assoc.

BartleRealtyGroup@gmail.com

Last updated:

September 19, 2026, 07:34 AM

MLS#

41146881

Source:

Bay East CCAR bridgeMLS

About This Home

210 D St

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.

Home Facts

Single Family

4 Baths

5 Bedrooms

Built in 1959

Subdivision & Development:

Niles

Price Summary

2,399,000

$900 per Sq. Ft.

MLS #:

41146881

Last Updated:

September 19, 2026, 07:34 AM


Rooms & Interior

Bedrooms

Total Bedrooms:

5

Bathrooms

Total Bathrooms:

4

Full Bathrooms:

4

Interior

Living Area:

2,665 Sq. Ft.


Structure

Structure

Architectural Style:

Cape Cod, Craftsman

Building Area:

2,665 Sq. Ft.

Year Built:

1959


Lot

Lot Size (Sq. Ft):

11,275


Finances & Disclosures

Finances

Price:

$2,399,000

Price per Sq. Ft:

$900 per Sq. Ft.

MLS Logo
Bay East 2026. CCAR 2026 bridgeMLS 2026. Information Deemed Reliable But Not Guaranteed. This information is being provided by the Bay East MLS, or CCAR MLS, or bridgeMLS. The listings presented here may or may not be listed by the Broker/Agent operating this website. This information is intended for the personal use of consumers and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Data last updated at September 19, 2026

Contact an Agent

Yes, I would like more information. Please use and/or share my information with a Coldwell Banker ® affiliated agent to contact me about my real estate needs. By clicking Contact, I request to be contacted by phone or text message and consent to being contacted by automated means. I understand that my consent to receive calls or texts is not a condition of purchasing any property, goods, or services. Alternatively, I understand that I can access real estate services by email or I can contact the agent myself.

If a Coldwell Banker affiliated agent is not available in the area where I need assistance, I agree to be contacted by a real estate agent affiliated with another brand owned or licensed by Anywhere Real Estate (BHGRE®, CENTURY 21®, Corcoran®, ERA®, or Sotheby's International Realty®). I acknowledge that I have read and agree to the terms of use and privacy notice.

Contact an Agent

Yes, I would like more information. Please use and/or share my information with a Coldwell Banker ® affiliated agent to contact me about my real estate needs. By clicking Contact, I request to be contacted by phone or text message and consent to being contacted by automated means. I understand that my consent to receive calls or texts is not a condition of purchasing any property, goods, or services. Alternatively, I understand that I can access real estate services by email or I can contact the agent myself.

If a Coldwell Banker affiliated agent is not available in the area where I need assistance, I agree to be contacted by a real estate agent affiliated with another brand owned or licensed by Anywhere Real Estate (BHGRE®, CENTURY 21®, Corcoran®, ERA®, or Sotheby's International Realty®). I acknowledge that I have read and agree to the terms of use and privacy notice.