Phone619-726-9832
Login or sign up for new accountLogin / Register
Email MeEmail Me
  • Search Listings
    • Residential
    • Lease
  • Previous Sales
  •   Buyers
    • Renting vs. buying
    • How much can I afford?
    • Why work with a real estate agent
    • Finding your home
    • What do you want in a home?
    • Submitting an offer
    • After the offer is accepted
    • Moving
  •     Sellers
    • Why work with a real estate agent
    • Getting your home ready for sale
    • Pricing your home to sell
    • Negotiating the sale
    • Transaction management
    • Moving
  •     Services
    • Onepoint
    • Home Financing
    • Insurance
    • Escrow
    • Title
    • Home Warranty
    • PRESALE/STAGING
    • Relocation
  •     About
    • Leadership Team
    • About Us
    • Globally Respected
    • The Charitable Foundation
    • Diversity & Inclusion
    • Doyle
    • Agents Only
Menu
Berkshire Hathaway HomeServices California Properties Berkshire Hathaway HomeServices California Properties
Any Price
-
  • 0
  • $100,000+
  • $250,000+
  • $500,000+
  • $750,000+
  • $1,000,000+
0+ Beds
  • 0+
  • 1+
  • 2+
  • 3+
  • 4+
  • 5+
0+ Baths
  • 0+
  • 1+
  • 2+
  • 3+
  • 4+
  • 5+
Property Type
Other
  • Home
  • 210 D St

210 D St, Fremont, CA 94536

$2,399,000 Approx. USD 5 beds, 4 baths
2,665 sqft

New Listing
Save My Notes
Share
  • Copy Link
  • Facebook
  • Twitter
  • Pinterest
Source MLS Verified
MORE INFO
BrochureBrochure

Photo of Thomas Van

Thomas Van REALTOR® - Sales Associate 619-726-9832 m
Lic#: 02077006
NRDS ID: 196577555
ThomasVan@bhhscal.com Text Me
Call My Cell
Lic#: 02077006
NRDS ID: 196577555
ThomasVan@bhhscal.com San Diego Central Office
2355 Northside Drive, Suite 180
San Diego, CA 92108
Phone: 619-294-3113
Fax: 619-521-0100
 San Diego Central 2355 Northside Drive, Suite 180
San Diego, CA 92108
Call Branch Office
Fax: 619-521-0100
Mortgage Calculator
GET PRE-APPROVED
Interested in This Property? Your message will be sent to Thomas.
By submitting your information, you consent to be contacted by email, SMS message, and/or phone call. You may opt out at any time per our Privacy Policy.
  • Save
  • My Notes

Listing Agent


Kathy Bartle | BartleRealtyGroup@gmail.com
Lic#: 00820845
Broker: Courtesy of Legacy Real Estate & Assoc.
Phone: 510-589-3509

Agent Remarks

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.

Listing Details

Property type: Single Family Residence (Single Family)
Status: Active
MLS# 41146881
Price: $2,399,000
Beds: 5
Baths: 4 (4 full)
Family Room fireplaces
Built in 1959
2,665 sqft
2 stories
0.26 acres
Lot size: 0.2588
Subdivision: NILES
County: Alameda
Property style: Cape Cod,Craftsman
Construction: Wood Siding
Parking description: Garage,Garage Door Opener
Lot description: Back Yard,Corner Lot,Front Yard,Yard
Heating/cooling: Wall/Window Unit(s)

Last Updated: 9/25/2026

 Days On Market (DOM): 5

 Find more Fremont homes and real estate

 Find more homes in 94536 zip code

 Find more homes in the NILES subdivision

The style of this listing is Cape Cod,Craftsman.
Find more Cape Cod,Craftsman style homes for sale

Lat/Long: 37.577140, -121.986134.
Find nearby listings

DISCLAIMER: There is NO WARRANTY, expressed or implied, for the accuracy of this information or its applicability to your financial situation. Please consult your financial and/or tax advisor. GET PRE-APPROVED The loan's interest rate will depend upon the specific characteristics of the loan transaction and credit profile up to the time of closing.

94536 Area Map

Demographics

Schools

CLICK TO VIEW MAP

Similar Listings

Next Listing
337 I St VIRTUAL TOUR
337 I St ,
$2,350,000 Approx. USD 6 beds, 3 baths

List Date: 6/23/2026
 Status: Active
 MLS #: 41139354

My Notes Save
Listing courtesy of
35390 Terra Cotta Cir VIRTUAL TOUR
35390 Terra Cotta Cir ,
$2,300,000 Approx. USD 4 beds, 3 baths

List Date: 9/8/2026
 Status: Pending
 MLS #: 41147527

My Notes Save
Listing courtesy of
35317 Terra Cotta Cir VIRTUAL TOUR
35317 Terra Cotta Cir ,
$2,099,000 Approx. USD 5 beds, 3 baths

List Date: 9/10/2026
 Status: Active
 MLS #: 41147922

My Notes Save
Listing courtesy of
791 Saltillo Pl VIRTUAL TOUR
791 Saltillo Pl ,
$2,374,999 Approx. USD 5 beds, 3 baths

List Date: 9/5/2026
 Status: Active
 MLS #: 41146796

My Notes Save
Listing courtesy of
3249 Greenwood Dr VIRTUAL TOUR
3249 Greenwood Dr ,
$2,599,000 Approx. USD 4 beds, 3 baths

List Date: 6/4/2026
 Status: Active
 MLS #: 41135958

My Notes Save
Listing courtesy of
36500 Alder Court VIRTUAL TOUR
36500 Alder Court ,
$2,299,999 Approx. USD 5 beds, 4 baths

List Date: 9/10/2026
 Status: Active
 MLS #: ML82060854

My Notes Save
Listing courtesy of
38660 Kimbro St VIRTUAL TOUR
38660 Kimbro St ,
$2,069,950 Approx. USD 5 beds, 3 baths

List Date: 8/27/2026
 Status: Pending
 MLS #: 41146336

My Notes Save
Listing courtesy of
39827 San Moreno Ct VIRTUAL TOUR
39827 San Moreno Ct ,
$2,290,000 Approx. USD 3 beds, 2 baths

List Date: 5/21/2026
 Status: Active
 MLS #: 41134459

My Notes Save
Listing courtesy of
34914 Moina Shaiq VIRTUAL TOUR
34914 Moina Shaiq ,
$2,250,000 Approx. USD 4 beds, 4 baths

List Date: 9/2/2026
 Status: Active
 MLS #: ML82059915

My Notes Save
Listing courtesy of
40249 San Sebastian Place VIRTUAL TOUR
40249 San Sebastian Place ,
$2,399,800 Approx. USD 4 beds, 3 baths

List Date: 9/16/2026
 Status: Pending
 MLS #: ML82061142

My Notes Save
Listing courtesy of
Previous Listing
  • Search
    • My Previous Sales
    • Residential
    • Lease
    • Open Houses
    • Commercial
    • New Homes
    • Luxury
  • Buyers
    • Renting vs. buying
    • How much can I afford?
    • Why work with a real estate agent
    • Finding your home
    • What do you want in a home?
    • Submitting an offer
    • After the offer is accepted
    • Moving
  • Sellers
    • Why work with a real estate agent
    • Getting your home ready for sale
    • Pricing your home to sell
    • Negotiating the sale
    • Transaction management
    • Moving
  • Services
    • Prosperity Home Mortgage
    • HomeServices Relocation
    • HomeServices Insurance Agency
    • Pickford Escrow
    • California Title Company
    • American Home Shield
    • PINNACLE
    • myNHD
  • About
    • Leadership Team
    • About Us
    • Globally Respected
    • The Charitable Foundation
    • Diversity & Inclusion
    • Doyle
    • Agents Only

Photo of Thomas Van

Thomas Van REALTOR® - Sales Associate 619-726-9832 m
Lic#: 02077006
NRDS ID: 196577555
ThomasVan@bhhscal.com Text Me
Call My Cell
Lic#: 02077006
NRDS ID: 196577555
ThomasVan@bhhscal.com
San Diego Central Office
2355 Northside Drive, Suite 180
San Diego, CA 92108
hsoa-logo

© 2026 BHH Affiliates, LLC. An independently operated subsidiary of HomeServices of America, Inc., a Berkshire Hathaway affiliate, and a franchisee of BHH Affiliates, LLC. Berkshire Hathaway HomeServices and the Berkshire Hathaway HomeServices symbol are registered service marks of Columbia Insurance Company, a Berkshire Hathaway affiliate. Equal Housing Opportunity.
Lic#: 01317331

Photo of Equal Housing Opportunity Privacy Policy - California Privacy Notice - Terms of Use - Accessibility
Do Not Sell My Personal Information DMCA.com Protection Status