470 29th Street

Rare opportunity to own a historic multi-family property with incredible investment potential! First time on the market in 21 years, this meticulously maintained 3-unit residence blends 1929 architectural charm with modern upgrades. Original period details—curved wood and glass doors, built-ins, and hardwood floors—exude character, while updated kitchens, bathrooms, electrical, sewer lateral (2022), and a newer roof ensure long-term value. Strategically located on Barrett Avenue, this property offers seamless access to local amenities, BART, and public transit—making it highly desirable for tenants and owner-users alike. The large basement, 2-car garage, and expansive attic offer potential for ADU expansion.* Parking for four vehicles completes this rare offering. Whether you're seeking a trophy investment or a historic home with income potential, 2900 Barrett Ave is a must-see. Schedule a private showing today!

Current Status

Canceled

Original Price

$878,000

List Price

$878,000

On Market Date

Mar 19, 2025

Property Type

Detached

D/N/S

North And East

Zip Code

94804

MLS ID

41089941

APN

5161600233

Year Built

1929

Stories in Building

3

Possession

COE

Data Source

MAXEBRDI

Origin MLS System

Bridge AOR

Bed

4

Bath

3

Parking

2

Attached, Garage, Int Access From Garage, Off Street, Parking Spaces, Other, Enclosed, See Remarks

SQ FT

4,170

SQ FT Source

Public Records

Lot SQ FT

5,500.0

Lot Acres

0.13 Acres

Pool Info

None

Kitchen

Gas Range, Free-Standing Range, Refrigerator, Dryer, Washer, Gas Water Heater, Counter - Tile, Eat In Kitchen, Gas Range/Cooktop, Range/Oven Free Standing

Cooling

None

Disclosures

Other - Call/See Agent

Entry Level

Exterior Details

Backyard, Back Yard, Front Yard, Garden/Play, Sprinklers Automatic, Sprinklers Front

Flooring

Hardwood, Carpet, Other

Foundation

Fire Place

Living Room, Master Bedroom, See Remarks

Heating

Forced Air, Natural Gas, Wall Furnace

Laundry

Dryer, In Garage, Washer, In Unit, See Remarks, Sink

Upper Level

2 Bedrooms, 1 Bath, Laundry Facility

Main Level

1 Bedroom, 1 Bath, Main Entry

Views

City Lights, Partial

Possession

COE

Basement

Crawl Space

Architectural Style

Mediterranean, Spanish

Non-Master Bathroom Includes

Shower Over Tub, Solid Surface, Tile, Tub, See Remarks

Construction Status

Existing

Additional Miscellaneous Features

Backyard, Back Yard, Front Yard, Garden/Play, Sprinklers Automatic, Sprinklers Front

Location

Corner Lot, Level, Front Yard, Landscape Front, See Remarks

Pets

Unknown

Roof

Tile

Water and Sewer

Public, Meter Avail (Irrigation)

Fee

Unavailable

MLS and other Information regarding properties for sale as shown in Theo have been obtained from various sources such as sellers, public records, agents and other third parties. This information may relate to the condition of the property, permitted or unpermitted uses, zoning, square footage, lot size/acreage or other matters affecting value or desirability. Unless otherwise indicated in writing, neither brokers, agents nor Theo have verified, or will verify, such information. If any such information is important to buyer in determining whether to buy, the price to pay or intended use of the property, buyer is urged to conduct their own investigation with qualified professionals, satisfy themselves with respect to that information, and to rely solely on the results of that investigation.

School data provided by GreatSchools. School service boundaries are intended to be used as reference only. To verify enrollment eligibility for a property, contact the school directly.