256 waterville St

Introducing a rare, one-of-a-kind asset designed for discerning buyers seeking scale, flexibility, and exceptional upside. This expansive ~3,500 sq ft residence sits on an impressive 7,500 sq ft lot and features 6 en-suite bedrooms, delivering a level of privacy and functionality rarely found in the market. The property is further enhanced by a 3-bedroom, 1-bath in-law unit (unwarranted), creating a compelling opportunity for strong supplemental income or multi-generational living.From its generous footprint to its highly versatile layout, this property stands out as a premier investment and lifestyle acquisition.Key Highlights:6 en-suite bedrooms (rare configuration) Additional 3BD/1BA in-law unit (unwarranted).Expansive 7,500 sq ft lot 2-car garage + parking for additional vehicles Significant income-producing and value-add potential Opportunities of this caliber, size, and flexibility are seldom available.

Days on Market

0 days

Current Status

Active

Original Price

$2,700,000

List Price

$2,700,000

On Market Date

Apr 15, 2026

Property Type

Single Family Residence

District

10 - Silver Terrace

Zip Code

94124

MLS ID

426121225

APN

5400-042

Year Built

1922

Stories in Building

0

Possession

Close Of Escrow, See Remarks

Data Source

SFAR

Origin MLS System

Bed

6

Bath

6

Parking

6

Attached, Side-by-Side, Uncovered Parking Spaces 2+

SQ FT

3,467

SQ FT Source

Unavailable

Lot SQ FT

7,500.0

Lot Acres

0.1722 Acres

Heating

Central

Laundry

Dryer Included, Washer Included

Upper Level

Bedroom(s), Full Bath(s)

Main Level

Dining Room, Family Room, Kitchen, Living Room

Possession

Close Of Escrow, See Remarks

Special Listing Conditions

None

Fee

$0

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.