COMING SOON

$2,399,000

Est. $15,829/mo —

•

2,665

sq ft

210 D St, Fremont, CA 94536

About this home

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.

Single-familyProperty Type

1959Year Built

0.26 acresLot Size

$900Price/Sq.Ft.

3 car garageParking

Listed by Kathy Bartle •DRE #00820845 • Legacy Real Estate & Assoc.

Contact: Off: 510-744-3500

Listing updated: Sep 15, 2026 at 04:40pm

Redfin checked: 2 minutes ago

•Source:bridgeMLS, Bay East AOR, or Contra Costa AOR #41146881

Payment calculator

$15,829 per month

Principal and interest$12,930

Property taxes

$2,499

HOA dues

Home insurance

$400

Utilities

Add

5 minutes to get started. No credit impact.

Discover your buying power

Find out if this home is within budget

Down payment assistance

View down payment assistance programs for this home

Open houses

No upcoming open houses.

Nearby open houses (10)

OPEN FRI, 10AM TO 1PM
$999,999
2 beds2 baths1,056 sq ft
1816 Sinclair Dr, Pleasanton, CA 94588
REDFIN OPEN SAT, 11AM TO 1PM3D WALKTHROUGH
$779,000
3 beds1 bath1,068 sq ft
886 Via Manzanas, San Lorenzo, CA 94580
Redfin Corporation
REDFIN OPEN SAT, 1PM TO 4PM3D WALKTHROUGH
$1,178,250
3 beds1 bath1,050 sq ft
6239 Dairy Ave, Newark, CA 94560
REDFIN OPEN SAT, 1PM TO 4PM3D WALKTHROUGH
$1,080,000
2 beds2 baths1,335 sq ft
3418 Inspiration Way #403, Fremont, CA 94538
REDFIN OPEN SAT, 1PM TO 4PM
$1,750,000
5 beds4.5 baths2,886 sq ft
9755 Pontoon Way, Newark, CA 94560
REDFIN OPEN SAT, 1PM TO 4PM3D & VIDEO TOUR
$539,000
1 bed1.5 baths1,000 sq ft
6560 Pioneer Ln #32, Dublin, CA 94568
OPEN SAT, 1PM TO 3:30PM
$1,198,000
4 beds2 baths1,748 sq ft
5582 Jonathan Dr, Newark, CA 94560
OPEN SAT, 1PM TO 4PM3D WALKTHROUGH
$5,298,000
3 beds2 baths2,405 sq ft
563 Jefferson Dr, Palo Alto, CA 94303
OPEN SAT, 1PM TO 4PM3D WALKTHROUGH
$1,249,000
4 beds2.5 baths2,060 sq ft
28039 Dobbel Ave, Hayward, CA 94542
OPEN SAT, 1:30PM TO 4PM
$1,650,000
4 beds2.5 baths2,330 sq ft
924 Baines St, East Palo Alto, CA 94303

Around this home

Schools

K - 12
Preschool & daycare

Niles Elementary School

Public Tk-5 • Assigned • 0.1mi

9/10

Centerville Middle School

Public 6-8 • Assigned • 1.6mi

8/10

Washington High School

Public 9-12 • Assigned • 1.8mi

9/10

Provided by GreatSchools

About

Niles

Niles, located between Mission San Jose and Union City, is a historic and artsy Fremont neighborhood with a small-town main street and a foothill backdrop. The neighborhood’s character concentrates around Niles Boulevard at J Street, where antique shops, indie galleries, and old-school eateries line the sidewalks. The Niles Essanay Silent Film Museum, Niles Canyon Railway, and Bronco Billy’s Pizza Palace act as local pillars with deep roots. Early-20th-century bungalows and cottages mix with modest midcentury homes on leafy blocks. Alameda Creek and the Niles Community Park add open space for walks and weekend meetups. Niles Canyon Road frames the edge of the district with a scenic, rail-and-river corridor.

Provided by Walk Score and Local Logic

Market insights

210 D St · $2,399,000

DAYS ON MARKET

The average home goes pending in 17 days.

SALE-TO-LIST

Most homes are selling 8% above list price.

LIST PRICE

Median sale price in this area is $1,269,834. (47% lower than this home)

PRICE DROP

15% of homes in this area have had a price drop in the past month.

Property details

Interior
Exterior
Finance

Kitchen

Bathroom

Bedroom

Living

Dining

Interior features
Formal dining room
Guest house
Family room fireplace (1 fireplace total)

Bedrooms
Upper level: 2 bedrooms
Street level: 1 bedroom
Accessory dwelling unit includes bedrooms (ADU present)

Bathrooms
4 full bathrooms total
ADU has 2 full bathrooms

Kitchen
Tile counters
Dishwasher
Electric range / cooktop
Disposal
ADU has a kitchen

Laundry & utility
Laundry located in garage
Tankless water heater

Flooring
Tile flooring
Wood flooring

Heating & cooling
Central heating
Wall/window cooling units

Sale and tax history for 210 D St

Sale History
Tax History

Date

Event

Price

Public Records

Oct 17, 2022

Sold

$2,102,500

$789/sq ft

bridgeMLS, Bay East AOR, or Contra Costa AOR #41007036

Oct 17, 2022

Sold

$2,102,100

$789/sq ft

Sep 15, 2022

Pending

—

Sep 10, 2022

Listed

$2,100,000

$788/sq ft

What an amazing find! Beautiful Cape Cod home perfect for Multi-generational family (a single family home plus 2nd unit with permits) located in the heart of old town Niles. There is a charming custom 1750 sq. Ft., 3 bedroom 2 bath home PLUS a delightful separate 900 sq. ft. 2 bedroom 2 bath apartment over the garage which was built in 2009 with permits. Apartment has it’s own address, separate utilities and single car garage. Great for extended family or income property. Located just one block away from Niles Elementary school (winner of the California Distinguished school award.) Old town Niles is a special place! It offers so much in such a small area; walking trails, tennis courts, coffee shops, The Niles Plaza amphitheater and the silent film museum. Also, BART and Quarry swimming lakes are just over a mile away. Come and see!

bridgeMLS, Bay East AOR, or Contra Costa AOR #11038354

Feb 23, 2000

Sold

$468,000

$176/sq ft

Jan 24, 2000

Listing Removed

—

Dec 23, 1999

Listed

$468,000

$176/sq ft

MLSListings #ML89951926

Feb 20, 2000

Listing Removed

—

Jan 24, 2000

Sold

$468,000

$176/sq ft

Dec 23, 1999

Listed

$468,000

$176/sq ft

Year

Property tax

Land + Additions

Assessment*

2025

$27,094 (+5.3%)

$873,936 + $1,313,088

$2,187,024

2024

$25,727 (+2.7%)

$873,936 + $1,313,088

$2,187,024

2023

$25,052 (+116.7%)

$856,800 + $1,287,342

$2,144,142

2022

$11,561 (+2.4%)

$203,335 + $699,465

$902,800

2021

$11,289 (+0.5%)

$203,335 + $699,465

$902,800

2020

$11,231 (+1.9%)

$199,349 + $685,754

$885,103

2019

$11,025 (+2.0%)

$197,306 + $678,727

$876,033

2018

$10,804 (+2.6%)

$193,438 + $665,420

$858,858

2017

$10,532 (+1.8%)

$185,928 + $639,587

$825,515

2016

$10,349 (+1.3%)

$185,928 + $639,587

$825,515

2015

$10,215 (+1.8%)

$182,284 + $627,049

$809,333

2014

$10,036 (+5.3%)

$176,029 + $605,536

$781,565

2013

$9,531 (+2.4%)

$176,029 + $605,536

$781,565

2012

$9,303 (+1.6%)

$175,234 + $602,803

$778,037

2011

$9,156 (+4.2%)

$171,799 + $590,985

$762,784

2010

$8,784 (+31.1%)

$168,430 + $579,398

$747,828

2009

$6,700 (+5.3%)

$167,172 + $575,070

$742,242

2008

$6,365

$167,570 + $390,997

$558,567

Public record

Public record
Zoning

Beds

Baths

Stories

1.5

Lot width

—

Lot depth

—

Lot size

0.26 Acres

Year renovated

1978

Finished Sq. Ft.

2,665

Unfinished Sq. Ft.

—

Total Sq. Ft.

2,665

Year built

1959

Style

Single Family Residential

County

Alameda County

APN

507 024001700

Parking Spaces

—

Basement

—

Accessible

—

HOA Dues

—

Garage

—

Features

—

Last updated by owner on Jul 27, 2026.

Local insights from Redfin agents

Fremont Last 90 Days,Prices:$1.5M–$1.8M typical range,Activity Moderate; well-priced homes still move quicklyDays on market 2–4 weeks,Competition: Strong for renovated/turnkey homes; weaker for overpriced homes,Seller leverage: Slightly declining...
2 days ago • Fremont
Gagan Singh
Redfin Premier agent
654 deals
Was this helpful?
Fremont's late summer market remains highly competitive! Median prices are hovering around $1.6M, but a slight seasonal rise in inventory gives buyers room to negotiate on homes needing work. Still, pristine turnkey properties spark bidding wars, so...
2 weeks ago • Fremont
Johnny Singh
Redfin Premier agent
146 deals
Was this helpful?

Climate risks

1/10 Flood Factor

Minimal risk of a flood reaching the building in the next 30 years

4/10 Fire Factor

1% chance of being in a wildfire in next 30 years

4/10 Heat Factor

7 days above 90° expected this year, 15 days in 30 years

1/10 Wind Factor

Minimal risk of severe winds over next 30 years

8/10 Air Factor

13 unhealthy days expected this year, 16 days in 30 years

Provided by First Street

Historical weather

Fremont, CA • 94536

Average low and high temperatures (°F)

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

Sun exposure

87/ 100

Very good sunlight

Sunscore

This home receives average direct sun exposure in Fremont. There appears to be minimal shading by surrounding buildings, terrain, and vegetation.

9.3 hrs

5.8 hrs

JuneDecember

Provided by Shadowmap

Redfin Estimate for 210 D St

$2,411,286

$12K over list price of $2.40M

Nearby comparable homes

The Redfin Estimate uses 6 recent nearby sales, priced between $1.6M to $2.4M.

SOLD BY REDFIN MAY 11, 2026
$2,400,000 Last sold price
4 beds3 baths2,420 sq ft
796 Posada Way, Fremont, CA 94536
$92/sq ft
smaller lot
6 years newer
SOLD JAN 16, 2026
$2,000,000 Last sold price
4 beds2.5 baths2,357 sq ft
36963 Nichols Ave, Fremont, CA 94536
Alliance Bay Realty
$51/sq ft
smaller lot
38 years newer
SOLD APR 23, 2026
$2,030,000 Last sold price
3 beds2 baths2,133 sq ft
36017 Plumeria, Fremont, CA 94536
$52/sq ft
smaller lot
10 years newer
SOLD JUN 2, 2026
$1,550,000 Last sold price
3 beds2.5 baths1,870 sq ft
375 De Salle Ter, Fremont, CA 94536
$71/sq ft
smaller lot
33 years newer
SOLD APR 27, 2026
$1,985,000 Last sold price
4 beds3 baths2,040 sq ft
326 I St, Fremont, CA 94536
$73/sq ft
smaller lot
40 years newer
SOLD SEP 2, 2026
$2,410,000 Last sold price
4 beds3.5 baths3,141 sq ft
1315 Skelton Ave, Fremont, CA 94536
$133/sq ft
smaller lot
46 years newer

Rental earnings

Est. $5,483 per month, based on comparable rentals

This home is coming soon

This home isn't listed yet. Favorite this home to get updates once it's listed, or contact a Redfin Agent for more information.

Have questions?

Ted Chen

Fremont Redfin Agent

Ted Chen typically replies in about 3 minutes

Early Access listings

EARLY ACCESSCOMPASS COMING SOON

$1,049,000

3 beds2 baths1,700 sq ft

5701 Oak Grove Ave, Oakland, CA 94618

FLOOR PLAN

Contact for price

— beds1 bath490 sq ft

1234 Shelter Creek Ln, San Bruno, CA 94066

Contact for price

1 bed2 baths886 sq ft

1655 N California Blvd #121, Walnut Creek, CA 94596

EARLY ACCESSCOLDWELL BANKER REALTY COMING SOON

$2,150,000

1 bed2 baths1,450 sq ft

1200 California St Unit 23A, San Francisco, CA 94109

EARLY ACCESSCOMPASS COMING SOON

$7,999,000

4 beds4 baths4,490 sq ft

2 6th Ave, San Francisco, CA 94118

EARLY ACCESSCOMPASS COMING SOON

$849,000

2 beds1 bath1,164 sq ft

1262 Excelsior Ave, Oakland, CA 94610

Nearby similar homes

$1,550,000

4 beds2.5 baths1,939 sq ft

38520 Burdette St, Fremont, CA 94536

Rise Realty

$1,548,950

4 beds2 baths1,494 sq ft

2482 Archer Ave, Fremont, CA 94536

3D WALKTHROUGH

$1,727,777

3 beds2 baths1,779 sq ft

3207 Defoe Ct, Fremont, CA 94536

VIDEO TOUR

$1,648,888

3 beds2 baths1,680 sq ft

37658 Canterbury St, Fremont, CA 94536

OPEN SUN, 1:30PM TO 4:30PMVIDEO TOUR

$1,398,000

2 beds2.5 baths1,376 sq ft

2775 Barrington Ter, Fremont, CA 94536

$1,498,000

3 beds3 baths1,466 sq ft

2932 Barrington Terrance, Fremont, CA 94536

New listings for sale in 94536

OPEN FRI, 1PM TO 4PM

$1,575,000

3 beds2 baths1,762 sq ft

38785 Altura St, Fremont, CA 94536

OPEN SAT, 1:30PM TO 4:30PM

$1,390,000

3 beds2 baths1,386 sq ft

38300 Acacia St, Fremont, CA 94536

$1,288,888

3 beds2.5 baths1,416 sq ft

312 Rivercreek Dr, Fremont, CA 94536

3D & VIDEO TOUR

$1,198,000

3 beds3.5 baths1,600 sq ft

37508 Zephyr Ter, Fremont, CA 94536

3D WALKTHROUGH

$2,099,000

5 beds3 baths2,075 sq ft

35317 Terra Cotta Cir, Fremont, CA 94536

$1,488,000

3 beds2.5 baths1,722 sq ft

38940 Cherry Ct, Fremont, CA 94536

VIDEO TOUR

$2,299,999

5 beds4 baths2,552 sq ft

36500 Alder Ct, Fremont, CA 94536

3D WALKTHROUGH

$1,489,000

3 beds2 baths1,628 sq ft

36008 Plumeria, Fremont, CA 94536

$1,548,950

4 beds2 baths1,494 sq ft

2482 Archer Ave, Fremont, CA 94536

Details provided by bridgeMLS, Bay East AOR, or Contra Costa AOR and may not match the public record. Learn more.

Download the Redfin App on the Apple App Store

Download the Redfin App from the Google Play Store

Join us

Become an Agent

Get referrals

Careers

Find homes faster

About us

Find us

Subsidiaries

Affiliated Business

Countries

United States

Canada

Updated September 2025: By searching, you agree to the Terms of Use, and Privacy Policy.

Do not sell or share my personal information.

REDFIN and all REDFIN variants, WALK SCORE, and the R logos, are trademarks of Redfin Corporation, registered or pending in the USPTO.

California DRE #01521930

Redfin is licensed to do business in New York as Redfin Real Estate. NY Standard Operating Procedures

New Mexico Real Estate Licenses

TREC: Info About Brokerage Services, Consumer Protection Notice

All mortgage lending products and information are provided by Rocket Mortgage, LLC | NMLS #3030; www.NMLSConsumerAccess.org. Licensed in 50 states. This site is not authorized by the New York State Department of Financial Services for mortgage solicitation or loan applications activities related to properties located in the State of New York.

Redfin Corporation is an affiliated business of Rocket Limited Partnership. Each company, and their subsidiaries, are separate legal entities operated and managed through its own management and governance structures.

If you are using a screen reader, or having trouble reading this website, please call Redfin Customer Support for help at 1-844-759-7732.

REDFIN IS COMMITTED TO AND ABIDES BY THE FAIR HOUSING ACT AND EQUAL OPPORTUNITY ACT. READ REDFIN'S FAIR HOUSING POLICY AND THE NEW YORK STATE FAIR HOUSING NOTICE.

GreatSchools Ratings provided by GreatSchools.org.

94536 homes for sale
95035 homes for sale
94538 homes for sale
94555 homes for sale
94539 homes for sale

Houses for rent in Fremont	Agents near me	Irvine, CA homes for sale	Fremont Housing Market
Houses for sale near me	San Diego, CA homes for sale	Fremont, CA homes for sale
Land for sale near me	San Francisco, CA homes for sale	Sacramento, CA homes for sale
Open Houses near me	Los Angeles, CA homes for sale	Fremont Property Records
Condos for sale near me	San Jose, CA homes for sale	CA New Listings

Oakland homes for sale
San Jose homes for sale
San Francisco homes for sale

About this home

Payment calculator

Open houses

Nearby open houses (10)

Around this home

Schools

Market insights

Property details

Sale and tax history for 210 D St

Public record

Local insights from Redfin agents

Climate risks

Historical weather

Sun exposure

Redfin Estimate for 210 D St

This home is coming soon

Have questions?

Early Access listings

Nearby similar homes

New listings for sale in 94536

More real estate resources