Drive up the private driveway to a quiet mid-century Piedmont oasis. This spacious 3 bedroom, 2.5 bath home combines classic architectural design with mid-century aesthetics. Contemporary living room with soaring ceilings, separate dining room both have french doors out to a generous patio and rear garden. Cozy library with fireplace and half bath, updated eat-in kitchen with cozy fireplace round out the first floor. All three bedrooms are half-level up including spacious primary suite overlooking the rear garden and southern views. Lower bonus level gym/workshop/art studio offers plenty of space for work or play. Located in a highly desirable neighborhood in Piedmont, yet convenient to Piedmont’s award-winning schools, sports fields, Mulberry’s and public transportation.
Single-familyProperty Type
1951Year Built
8,700 sq ftLot Size
$994Est. Price/Sq.Ft.
2 car garageParking
Listed by Matthew Heafey•DRE #01723973• Compass
Listed by Teresa Baum•DRE #01731096• Compass
Bought with Jill Carrigan•DRE #01272525• The GRUBB Company
bridgeMLS, Bay East AOR, or Contra Costa AOR #41009321
Oct 26, 2022
Sold
$2,530,000
$957/sq ft
Oct 5, 2022
Pending
—
Sep 22, 2022
Listed
$2,495,000
$944/sq ft
Public Records
Mar 27, 1992
Sold
$615,000
$233/sq ft
Year
Property tax
Land + Additions
Assessment*
2025
$37,586 (+3.3%)
$780,000 + $1,820,000
$2,600,000
2024
$36,402 (+1.5%)
$789,663 + $1,842,548
$2,632,211
2023
$35,862 (+354.3%)
$774,180 + $1,806,420
$2,580,600
2022
$7,894 (+3.3%)
$65,502 + $153,068
$218,570
2021
$7,643 (+1.0%)
$65,502 + $153,068
$218,570
2020
$7,565 (+9.9%)
$64,218 + $150,067
$214,285
2019
$6,885 (+3.1%)
$63,559 + $148,528
$212,087
2018
$6,677 (+1.2%)
$62,313 + $145,616
$207,929
2017
$6,600 (+6.4%)
$59,894 + $139,962
$199,856
2016
$6,204 (+1.2%)
$59,894 + $139,962
$199,856
2015
$6,129 (+2.4%)
$58,720 + $137,218
$195,938
2014
$5,986 (+1.2%)
$56,705 + $132,511
$189,216
2013
$5,916 (+4.0%)
$56,705 + $132,511
$189,216
2012
$5,687 (−0.4%)
$56,449 + $131,912
$188,361
2011
$5,708 (+3.2%)
$55,342 + $129,326
$184,668
2010
$5,533 (−0.2%)
$54,257 + $126,791
$181,048
2009
$5,543 (+11.2%)
$53,852 + $125,843
$179,695
2008
$4,984
$53,980 + $126,143
$180,123
Tax history for 174 Indian Rd
Year
Property tax
Land + Additions
Assessment*
2025
$37,586 (+3.3%)
$780,000 + $1,820,000
$2,600,000
2024
$36,402 (+1.5%)
$789,663 + $1,842,548
$2,632,211
2023
$35,862 (+354.3%)
$774,180 + $1,806,420
$2,580,600
2022
$7,894 (+3.3%)
$65,502 + $153,068
$218,570
2021
$7,643 (+1.0%)
$65,502 + $153,068
$218,570
2020
$7,565 (+9.9%)
$64,218 + $150,067
$214,285
2019
$6,885 (+3.1%)
$63,559 + $148,528
$212,087
2018
$6,677 (+1.2%)
$62,313 + $145,616
$207,929
2017
$6,600 (+6.4%)
$59,894 + $139,962
$199,856
2016
$6,204 (+1.2%)
$59,894 + $139,962
$199,856
2015
$6,129 (+2.4%)
$58,720 + $137,218
$195,938
2014
$5,986 (+1.2%)
$56,705 + $132,511
$189,216
2013
$5,916 (+4.0%)
$56,705 + $132,511
$189,216
2012
$5,687 (−0.4%)
$56,449 + $131,912
$188,361
2011
$5,708 (+3.2%)
$55,342 + $129,326
$184,668
2010
$5,533 (−0.2%)
$54,257 + $126,791
$181,048
2009
$5,543 (+11.2%)
$53,852 + $125,843
$179,695
2008
$4,984
$53,980 + $126,143
$180,123
*Taxable value of land and structures on it ("additions") is determined regularly by local assessors and does not affect market price.
Public record
Public record
Zoning
Permits
Beds
3
Baths
3
Stories
1
Lot width
—
Lot depth
—
Lot size
8,700 Sq. Ft.
Year renovated
1956
Sq. Ft.
2,643
Year built
1951
Style
Single Family Residential
County
Alameda County
APN
051 479001002
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Sep 16, 2026.
SFR
Single Family Residential
The intent is to: Preserve, protect and enhance Piedmont's residential character, protecting the quiet, family atmosphere of neighborhoods.; Protect residents from the harmful effects of excessive noise, light deprivation, intrusions on privacy, overcrowding, excessive traffic, insufficient parking, blockage of significant views, and other adverse environmental impacts.; Maintain openness and areas of vegetation between residences to enhance a healthy environment.; Achieve design compatibility between additions, remodeling and other new construction by establishing development standards.; Minimize the out-of-scale appearance of large homes, parking areas, and other development relative to the lot size and to other homes in a neighborhood.
Sep 30, 2025 • Final
Seismic strctr upgrd
Perform a voluntary seismic upgrade on the building.
Remodel
Mar 22, 2024 • Final
Water heater
Replace an existing gas water heater with a new heat pump.
Heat pump
HVAC
Plumbing
Water heater
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.
Property details
Parking
Parking Information
Has Attached Garage
Garage Spaces: 2
Covered Spaces: 2
Parking Features: Attached, Off Street
Interior
Virtual Tour
Bathroom Information
# of Bathrooms Total: 3
# of Bathrooms Full: 2
# of Bathrooms Partial: 1
Other Bathrooms Included Features: Stall Shower, Tile, Jack & Jill, Window
Property information provided by bridgeMLS, Bay East AOR, or Contra Costa AOR when last listed in 2022. This data may not match public records. Learn more.