---
listing_id: ML82050837
status: Active
price: 998000
beds: 3
baths_full: 2
baths_half: 1
sqft_living: 1596
sqft_lot: 5600
lot_acres: 
year_built: 1950
property_type: Residential
property_subtype: Single Family Residence
address: "5004 Pierpoint Ave"
city: Oakland
state: CA
zip: 94602
county: "Alameda County"
lat: 37.811188
lng: -122.196257
days_on_market: 1
hoa_fee: 
hoa_frequency: 
garage_spaces: 1
list_agent: "Nick Roe"
list_office: "Real Brokerage Technologies"
list_agent_phone: "(650) 719-1881"
list_agent_license: 02127065
mls_source: MLSL
modified: 2026-06-13
transaction_type: buy
---

Home | Alameda County | Oakland | 94602 | 5004 Pierpoint Ave

5004 Pierpoint Ave, Oakland, CA 94602

MLS: ML82050837 | Status: Active | Price: $998,000
Beds/Baths: 3 / 2 /1
Property Type: Residential

Quick Facts

Beds Baths Sq Ft Sq Ft Lot Yr Built
3 2 /1 1,596 5,600 1950

Upcoming Open Houses

Date Time Hosted By
Saturday, June 13 1:30 pm - 4:30 pm Nick Roe
Sunday, June 14 1:30 pm - 4:30 pm Nick Roe

Remarks

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 continues throughout: 3 bedrooms and 2.5 baths wrapped in storybook charm, where brick details and a fresh designer vision create a home with genuine soul. An updated kitchen anchors the main level, a stylish bar keeps entertaining effortless, and new flooring, fixtures, and finishes flow through light-filled rooms that feel as good as they look. Then the home opens up seamless indoor-outdoor living spills into a beautifully landscaped backyard built for the Oakland hills lifestyle: sunny mornings with coffee, long dinners with friends, evenings under the stars. All of it minutes from Joaquin Miller Park trails, Montclair Village, and Hwy 13. Cookie-cutter homes are everywhere. Character like this charm you can feel, a backyard you'll live in, and a secret room your guests will never stop talking about comes along once in a market. Don't just see this home. Discover it.

MLS Listing Information

Field Value
MLS # ML82050837
MLS Source MLSListings, Inc.
Days on Site 1

Features

Interior Features

Feature Details
Dining Room Dining Area
Family Room Separate Family Room
Fireplace Family Room
Laundry Hookup - Gas Dryer, In Garage
Cooling Central Forced Air
Heating Central Forced Air

Exterior Features

Feature Details
Roof Shingle
Foundation Concrete Perimeter and Slab

Parking, School, and Other Information

Feature Details
Garage/Parking Attached Garage, Garage: 1 Car(s)
Elementary District Oakland Unified
High School District Oakland Unified
Sewer Public Sewer
Water Public
Zoning RD

Contact Information

Listing Agent Co-Listing Agent
Nick Roe Gabriel Garcia
Real Brokerage Technologies Real Brokerage Technologies
License #: 02127065 License #: 01981651
Phone: (650) 719-1881 Phone: (408) 973-3944

School Ratings

School data provided by GreatSchools.org

Nearby Schools

School Type Grades Distance Rating
Montera Middle School public 6-8 0.66 mi 7
Joaquin Miller Elementary School public K-5 0.66 mi 6
Bret Harte Middle School public 6,7,8,9 0.99 mi 3
Sequoia Elementary School public K-5 1.00 mi 7
Redwood Heights Elementary School public K-5 1.10 mi 9
Laurel Elementary School public K-5 1.26 mi 4
Glenview Elementary School public K-5 1.31 mi 8
Fruitvale Elementary School public K-5 1.41 mi 2
Montclair Elementary School public K-5 1.61 mi 7
Carl B. Munck Elementary School public K-5 1.63 mi 5
Allendale Elementary School public K-5 1.63 mi 1
Crocker Highlands Elementary School public K-5 1.71 mi 9
Edna Brewer Middle School public 6-8 1.86 mi 8
Thornhill Elementary School public K-5 1.88 mi 8
Manzanita SEED public K-5 2.07 mi 4
Manzanita Community public K-5 2.07 mi 1
Skyline High School public 9-12 2.12 mi 6
Canyon Elementary School public K-8 2.12 mi 8
Melrose Leadership Academy public K-8 2.13 mi 7
Life Academy public 6-12 2.15 mi 5

Nearby Homes

Address Price Beds Baths Sq Ft Status
1515 Hampel St $999,000 2 1 1,099 Active
1 Woodcrest Cir $995,000 2 2 1,827 Active
4507 Tulip Ave $995,000 4 3 2,066 Active
1917 Tiffin Rd $1,078,000 3 2 1,781 Active

Disclosures

©2026 MLSListings Inc. All rights reserved. All data, including all measurements and calculations of area, is obtained from various sources and has not been, and will not be, verified by broker or MLS. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information. Information provided is for personal, non-commercial use by the viewer and may not be redistributed without explicit authorization from MLSListings Inc.

Presently MLSListings.com displays Active, Contingent, Pending, and Recently Sold listings. Recently Sold listings are properties which were sold within the last three years. After that period listings are no longer displayed in MLSListings.com. Pending listings are properties under contract and no longer available for sale. Contingent listings are properties where there is an accepted offer, and seller may be seeking back-up offers. Active listings are available for sale.

This listing information is up-to-date as of June 13, 2026. For the most current information, please contact Nick Roe, (650) 719-1881.