For sale

$2,199,000

Est. $14,658/mo —

•

2,665

sq ft

210 D St, Fremont, CA 94536

About this home

Unbelievable value for this 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, including Hardie board siding, offering the weather-resistant look of wood with the strength of cement. 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

$825Price/Sq.Ft.

3 car garageParking

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

Contact: Off: 510-744-3500

Listing updated: Oct 29, 2026 at 05:05pm

Redfin checked: 7 hours ago

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

Payment calculator

$14,658 per month

Principal and interest$12,001

Property taxes

$2,291

HOA dues

Home insurance

$367

Utilities

Add

5 minutes to get started. No credit impact.

Affordability tools

See this home in person

Open houses

No upcoming open houses.

Nearby open houses (10)

OPEN TODAY, 11AM TO 6PM
$899,999
3 beds1 bath1,040 sq ft
37234 Birch St, Newark, CA 94560
6,700 sq ft lot • 2 garage spots • Built 1953
OPEN TODAY, 1:30PM TO 4:30PM3D & VIDEO TOUR
$5,998,000
3 beds4 baths2,823 sq ft
515 Webster St, Palo Alto, CA 94301
2 garage spots • Built 2019
OPEN TODAY, 1:30PM TO 4:30PM
$750,000
3 beds2 baths1,137 sq ft
4362 Agena Cir, Union City, CA 94587
$370 HOA • 2 garage spots • Built 1971
OPEN TODAY, 1:30PM TO 4:30PMVIDEO TOUR
$1,499,000
4 beds2.5 baths2,244 sq ft
4866 Shelton St, Dublin, CA 94568
4,000 sq ft lot • 2 garage spots • Built 2008
OPEN TODAY, 2PM TO 6PMVIDEO TOUR
$399,000
3 beds2 baths1,478 sq ft
3466 Baumberg Ave, Hayward, CA 94545
0.25 acre lot • Garage • Built 1945
OPEN TODAY, 2PM TO 5PM
$1,330,000
5 beds2.5 baths1,867 sq ft
6763 Tory Way, Dublin, CA 94568
5,738 sq ft lot • 2 garage spots • Built 1966
OPEN TODAY, 2:30PM TO 4:30PM
$1,650,000
3 beds2 baths1,450 sq ft
3619 Dryden Rd, Fremont, CA 94555
5,621 sq ft lot • 2 garage spots • Built 1977
OPEN NOV 3, 10AM TO 1PM3D WALKTHROUGH
$879,000
2 beds1 bath875 sq ft
610 Gilbert Ave #19, Menlo Park, CA 94025
$790 HOA • Garage • Community pool
OPEN NOV 7, 11AM TO 4PM
$924,900
2 beds2.5 baths1,585 sq ft
4899 Belarmine St Unit F, Dublin, CA 94568
$475 HOA • Garage • Built 2026
REDFIN OPEN NOV 7, 1PM TO 4PM
$3,299,900
6 beds4 baths3,544 sq ft
44775 Parkmeadow Dr, Fremont, CA 94539
7,452 sq ft lot • 2 garage spots • Built 1964

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

Offer insights

210 D St · $2,199,000

Strong offer

$2.18M and above

75% chance or better to win

Why $2.18M+ is a strong offer

DAYS ON MARKET

The average home goes pending in 15 days.

SALE-TO-LIST

Most homes are selling 9% above list price.

About offer insights

Property details

Interior
Exterior
Finance

Kitchen

Bathroom

Bedroom

Living

Dining

Interior features
Formal dining room
Guest house / ADU

Bedrooms
Upper level: 2 bedrooms
Street level: 1 bedroom
ADU includes bedrooms (part of guest house)

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 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

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

Oct 8, 2026

Price Changed

$2,199,000

$825/sq ft

Sep 24, 2026

Listed

$2,399,000

$900/sq ft

Sep 1, 2026

Coming Soon

$2,399,000

$900/sq ft

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

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

Feb 20, 2000

Sold

$468,000

$176/sq ft

Feb 20, 2000

Listing Removed

—

Jan 24, 2000

Sold

$468,000

$176/sq ft

Dec 23, 1999

Listed

Dec 23, 1999

Listed

$468,000

$176/sq ft

Year

Property tax

Land + Additions

Assessment*

2025

$27,094 (+5.3%)

$891,408 + $1,339,340

$2,230,748

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
Permits

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 Sep 16, 2026.

Aug 30, 2022 • Final

Residential electrical

Replace the existing electrical subpanel with a new panel. Rewire kitchen outlets for grounding and replace under-counter light fixtures.

Electrical

Jun 30, 2017 • Final

Historical project

Construct a first floor addition and a second story addition to be used as a secondary dwelling unit.

Addition

ADU

Permit history is from public records and may be incomplete or inaccurate. Redfin and its agents make no representations about the property condition or permit status. Buyers should independently verify all information.

Local insights from Redfin agents

Fremont’s housing market is cooling, with median sale prices down 6.5% year over year to $1.37 million in Sep 2026, desirable homes attract competition. Buyers find more negotiating opportunities as inventory rises, sellers should price competitively...
1 week ago • Fremont
Gagan Singh
Redfin Premier agent
659 deals
Was this helpful?
Fremont’s median sale price is approximately $1.37M, down 6.5% year over year. Homes sell in a median of 21 days, with a 101% sale-to-list ratio. Softer prices create opportunities for buyers, while sellers should focus on strategic pricing and...
3 weeks ago • Fremont
Annu Lakhat
Redfin Premier agent
63 deals
Was this helpful?
Buyer demand in Fremont is keeping the market aggressive. Homes frequently receive multiple offers and go pending in about 20 days. With many properties closing above asking price, well-priced, move-in-ready homes offer sellers a distinct advantage...
4 weeks ago • Fremont
Karan Kandel
Redfin agent
13 deals
Was this helpful?
Fremont's fall market offers clear buyer opportunities. Median prices hold steady around $1.4M with homes averaging three weeks on market. While move-in-ready homes draw quick competitive offers, properties needing cosmetic updates give you room to...
1 month ago • Fremont
Johnny Singh
Redfin Premier agent
149 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,186,180

$13K under list price of $2.20M

Nearby comparable homes

The Redfin Estimate uses 6 recent nearby sales, priced between $1.5M 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
smaller lot
6 years newer
SOLD OCT 12, 2026
$1,470,000 Last sold price
3 beds2 baths1,824 sq ft
330 Hillview Dr, Fremont, CA 94536
$19/sq ft
smaller lot
5 years older
SOLD AUG 13, 2026
524 Hillview Dr, Fremont, CA 94536
$1,565,000 Last sold price
3 beds2 baths1,724 sq ft
524 Hillview Dr, Fremont, CA 94536
smaller lot
4 years older
SOLD OCT 14, 2026
$2,240,000 Last sold price
4 beds3 baths2,459 sq ft
35390 Terra Cotta Cir, Fremont, CA 94536
smaller lot
40 years newer
SOLD JUL 13, 2026
$1,587,000 Last sold price
4 beds2.5 baths1,785 sq ft
1170 Bennett Ct, Fremont, CA 94536
smaller lot
18 years newer
SOLD SEP 28, 2026
$1,725,000 Last sold price
4 beds2.5 baths1,785 sq ft
1426 Hardy Pl, Fremont, CA 94536
smaller lot
18 years newer

Rental earnings

Est. $6,070 per month, based on comparable rentals

Tour for free, no strings attached

Make a winning offer with the help of a local agent

Ask a question

(925) 248-4711

Early Access listings

EARLY ACCESSCOMPASS COMING SOON

$1,499,000

Studio— baths3,650 sq ft

2950-2952 25th St, San Francisco, CA 94110

EARLY ACCESSCOMPASS COMING SOON

$2,495,000

4 beds2 baths1,740 sq ft

1109 Ross St, Belmont, CA 94002

EARLY ACCESSCOMPASS COMING SOON

$1,250,000

2 beds1 bath1,114 sq ft

708 21st Ave, San Francisco, CA 94121

EARLY ACCESSSOTHEBY'S INTERNATIONAL REALTY COMING SOON

$1,298,000

3 beds3 baths2,222 sq ft

2817 California Ave, Marina, CA 93933

EARLY ACCESSCOLDWELL BANKER REALTY COMING SOON

$1,250,000

3 beds2 baths1,223 sq ft

801 Lobos St, Monterey, CA 93940

EARLY ACCESSCOMPASS COMING SOON

$515,000

2 beds2 baths1,120 sq ft

260 Caldecott Ln #113, Oakland, CA 94618

Nearby similar homes

3D WALKTHROUGH

$1,699,000

4 beds3 baths1,647 sq ft

38154 Miller Pl, Fremont, CA 94536

Cul-de-sac • Luxurious kitchen • 9-foot island

$1,548,950

4 beds2 baths1,494 sq ft

2482 Archer Ave, Fremont, CA 94536

Double-pane windows • Cherry blossom tree • Rose garden

$2,289,900

5 beds3 baths2,746 sq ft

35578 Rockland Ct, Fremont, CA 94536

8,212 sq ft lot • 2 garage spots • Built 1999

$1,698,000

3 beds2 baths1,529 sq ft

37955 2nd St, Fremont, CA 94536

Gorgeous garden • Cook's dream kitchen • Remodeled bathrooms

3D & VIDEO TOUR

$1,089,000

3 beds2 baths1,168 sq ft

246 Mowry Ave, Fremont, CA 94536

Updated windows • Dedicated ev charger • Firepit

OPEN TODAY, 1PM TO 5PMVIDEO TOUR

$1,499,888

3 beds2.5 baths1,848 sq ft

35030 Begonia St, Union City, CA 94587

Gourmet kitchen • 7,000 sq ft lot • 2 garage spots

New listings for sale in 94536

$1,574,900

4 beds2 baths1,443 sq ft

37822 Granville Dr, Fremont, CA 94536

Remodeled home • New roof • New hvac system

LISTED BY REDFIN3D WALKTHROUGH

$1,695,000

4 beds2 baths1,588 sq ft

38844 Roanoke Way, Fremont, CA 94536

Updated kitchen • New cabinetry • Quartz countertops

$1,688,000

3 beds2 baths1,456 sq ft

4785 Gertrude Dr, Fremont, CA 94536

Remodeled kitchen • Inside laundry room • Master bath

COMING SOON

$2,999,000

4 beds4.5 baths3,609 sq ft

375 Hillview Dr, Fremont, CA 94536

Chef's kitchen • Substantial island • Built-in wine fridge

$1,395,000

3 beds2 baths1,180 sq ft

38870 Hygelund Dr, Fremont, CA 94536

Updated appliances • New countertops • Bathroom upgrades

LISTED BY REDFIN3D WALKTHROUGH

$815,000

2 beds2 baths1,230 sq ft

38 Silk Oak Ter, Fremont, CA 94536

Mountain views • Remodeled kitchen • Expansive greenbelts

$325,888

Studio1 bath421 sq ft

3344 Red Cedar Ter, Fremont, CA 94536

$305 HOA • Community pool • Built 1986

$1,499,888

4 beds2 baths1,409 sq ft

225 Preston Ct, Fremont, CA 94536

5,798 sq ft lot • 2 garage spots • Built 1977

COMING SOON

$1,199,800

3 beds2.5 baths1,439 sq ft

294 Grau Dr, Fremont, CA 94536

Private backyard • Wraparound deck • Mature landscaping

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

Affordability tools

See this home in person

Nearby open houses (10)

Around this home

Schools

Offer 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

Early Access listings

Nearby similar homes

New listings for sale in 94536

More real estate resources