714-745-2708

210 D St, Fremont, CA 94536

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

New Listing

Save My Notes

MORE INFO

Brochure

Marketed By The Keaty Team

View Team Members

Photo of Kevin Keaty

Marketed By The Keaty Team REALTOR® - Sales Associate 714-608-3298 m
714-745-2708 o
Lic#: 01276603
NRDS ID: 187514104
thekeatyteam@bhhscal.com Tustin Office
18302 Irvine Blvd, Suite 240
Tustin, CA 92780
Phone: 714-832-8800
Fax: 949-565-7700

Mortgage Calculator

GET PRE-APPROVED

Interested in This Property? Request Virtual Showing Your message will be sent to Kevin.
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.

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

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: 10/1/2026

Days On Market (DOM): 9

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

Mortgage Calculator

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