Pending
$998,000
3beds
1,596sqft
5004 Pierpoint Ave, Oakland, CA 94602
3beds
1,596sqft
Single family residence, residential
Built in 1950
5,600 sqft
1 Attached garage space
$625 price/sqft
What's special
Straight out of a storybook, this one-of-a-kind Oakland hills residence offers something almost no home can: a secret. Tucked above the garage, a concealed library awaits a hidden retreat for reading, working from home, or escaping the everyday. It's the kind of space buyers dream about and never find. The fairytale ...
- 53 days |
- 313 |
- 8 |
Source: MLSListings Inc,MLS#: ML82050837
Travel times
Living Room
Secret Library
Kitchen
Primary Bedroom
Primary Bathroom
Backyard
Bar
Bedroom 2
Bathroom
Bedroom 3
Dining Room
Bay Views
Zillow last checked:
Listing updated:
Listed by:
Nick Roe 02127065 650-719-1881,
Real Brokerage Technologies 619-663-8680,
Gabriel Garcia 01981651 408-973-3944,
Real Brokerage Technologies
Source: MLSListings Inc,MLS#: ML82050837
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 3
- Bathrooms: 3
- Full bathrooms: 2
- 1/2 bathrooms: 1
Dining room
- Features: DiningArea
Family room
- Features: SeparateFamilyRoom
Heating
- Central Forced Air
Cooling
- Central Air
Appliances
- Laundry: Gas Dryer Hookup, In Garage
Features
- Number of fireplaces: 1
- Fireplace features: Family Room
Interior area
- Total structure area: 1,596
- Total interior livable area: 1,596 sqft
Video & virtual tour
Property
Parking
- Total spaces: 1
- Parking features: Attached
- Attached garage spaces: 1
Features
- Stories: 2
Lot
- Size: 5,600 Square Feet
Details
- Parcel number: 0291255004
- Zoning: RD
- Special conditions: Standard
Construction
Type & style
- Home type: SingleFamily
- Property subtype: Single Family Residence, Residential
Materials
- Foundation: Concrete Perimeter and Slab
- Roof: Shingle
Condition
- New construction: No
- Year built: 1950
Utilities & green energy
- Gas: PublicUtilities
- Sewer: Public Sewer
- Water: Public
- Utilities for property: Public Utilities, Water Public
Community & HOA
Location
- Region: Oakland
Financial & listing details
- Price per square foot: $625/sqft
- Tax assessed value: $516,522
- Date on market: 6/12/2026
- Listing agreement: ExclusiveRightToSell
Price history
| Date | Event | Price |
|---|---|---|
| 6/29/2026 | Pending sale | $998,000$625/sqft |
Source:  MLSListings Inc #ML82050837 Report a problem | ||
| 6/12/2026 | Listed for sale | $998,000+34%$625/sqft |
Source: MLSListings Inc #ML82050837 Report a problem | ||
| 12/12/2025 | Sold | $745,000+130.3%$467/sqft |
Source: Public Record Report a problem | ||
| 12/31/1997 | Sold | $323,500$203/sqft |
Source: Public Record Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | -- | $516,522 +2% |
| 2024 | $8,240 -4.4% | $506,396 +2% |
| 2023 | $8,619 +2.9% | $496,468 +2% |
| 2022 | $8,379 +5% | $486,734 +2% |
| 2021 | $7,982 +1.1% | $477,191 +1% |
| 2020 | $7,895 +4.1% | $472,300 +2% |
| 2019 | $7,580 +6.2% | $463,041 +2% |
| 2018 | $7,136 | $453,963 +2% |
| 2017 | $7,136 +3.7% | $445,064 +2% |
| 2016 | $6,883 -0.4% | $436,339 +1.5% |
| 2015 | $6,912 | $429,785 +2% |
| 2014 | $6,912 | $421,367 +0.5% |
| 2013 | -- | $419,465 +2% |
| 2012 | -- | $411,242 +2% |
| 2011 | -- | $403,180 +0.8% |
| 2010 | -- | $400,168 -0.2% |
| 2009 | -- | $401,120 +2% |
| 2008 | -- | $393,255 +2% |
| 2007 | -- | $385,546 +2% |
| 2006 | -- | $377,989 +2% |
| 2005 | -- | $370,577 +2% |
| 2004 | -- | $363,313 +1.9% |
| 2003 | -- | $356,656 +2% |
| 2002 | -- | $349,661 +2% |
| 2001 | $4,806 | $342,807 |
Find assessor info on the county website
Monthly payment
Est. payment
$6,044/mo
Principal & interest
$5029
Property taxes
$1015
Estimated market value
Not available
Estimated sales range
Not available
Not available
Climate risks
Explore flood, wildfire, and other predictive climate risk information for this property on First Street®️.
Neighborhood: Piedmont Pines
Nearby schools
Joaquin Miller Elementary School
Grades K-5 • 0.7 miles6/10
GreatSchools® Rating
Test Score Rating
8/10Student Progress Rating
4/10Montera Middle School
Grades 6-8 • 0.7 miles7/10
GreatSchools® Rating
Test Score Rating
7/10Student Progress Rating
6/10Skyline High School
Grades 9-12 • 2.1 miles6/10
GreatSchools® Rating
Test Score Rating
6/10College Readiness Rating
5/10