Prevu by reAlpha
BuySellBlogBrowse Listings

256 Waterville StreetSan Francisco, CA 94124

For Sale

$2,650,000

Smart Buyer Rebate $26,500

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.

Listed by Jaime Rodriguez

·

eXp Realty of California, Inc

Last updated May 21, 2026

·

Source: SFAR #426121225

Listing Facts

  • TypeSingle-family
  • NeighborhoodSilver Terrace
  • Bedrooms6
  • Bathrooms6
  • Days on Prevu108
  • Size3,467 sqft
  • Price per sqft$764

Amenities

  • Washer/Dryer
  • Parking

Location

Mortgage Calculator

Listing History

07/22/2026
Status changed to Active
$2,650,000
05/29/2026
Status changed to Canceled
$2,650,000
05/21/2026
Price Decreased
$2,650,000
04/15/2026
Listed by eXp Realty of California, Inc
$2,700,000

Property Details for 256 Waterville Street

Exterior

Construction

  • Property Condition: Updated/Remodeled
  • Year Built: 1922

Features

  • Fencing: Fenced, Back Yard, Gate, Front Yard

Measurements

  • Building Area Total: 3,467
  • Building Area Units: Square Feet
  • Lot Size Acres: 0.17
  • Lot Size Area: 7,501
  • Lot Size Square Feet: 7,501
  • Lot Size Units: Square Feet

Financial

Taxes

  • Parcel Number: 5400042

Interior

Features

  • Appliances: Dryer, Washer

Measurements

  • Living Area: 3,467
  • Living Area Units: Square Feet

Rooms

  • Bathrooms Full: 6
  • Bathrooms Total Integer: 6
  • Bedrooms Total: 6
  • Rooms Total: 11

Parking

Parking

  • Attached Garage: Yes
  • Covered Spaces: 2
  • Garage Spaces: 2
  • Garage: Yes
  • Open Parking Spaces: 4
  • Open Parking: Yes
  • Parking Features: Driveway, Attached, Side By Side
  • Parking Total: 6

Schools

Elementary School

  • Elementary School District: San Francisco

High School

  • High School District: San Francisco

Middle or Junior School

  • Middle Or Junior School District: San Francisco

Utilities

Equipment

  • Heating: Central
  • Has Heating: Yes
  • Sewer: Public Sewer
  • Water Source: Public

Frequently Asked Questions

How many bedrooms and bathrooms does this single-family home have?

There are 6 bedrooms and 6 bathrooms in this single-family home at 256 Waterville Street.

Does this single-family home have parking?

Yes, there are 2 parking spaces available for 256 Waterville Street.

How does 256 Waterville Street compare to other single-family homes in Silver Terrace?

This single-family home is listed 98% above the average price for single-family homes in Silver Terrace and has been on the market for 24 more days than the typical home in this area.

What is the square footage on this single-family home?

According to the MLS, this listing is 3,467 sqft.

256 Waterville Street is a 6-bedroom, 6-bath single-family home for sale in San Francisco CA 94124. Listed on Prevu for 108 days at $2,650,000. This includes a recent price decrease of $50,000. This residence features 3,467 square feet of living space, located in Silver Terrace. The median listing price for single-family homes in this area is $1,088,000. Additional amenities include parking and washer/dryer. View other single-family home listings in San Francisco.

Based on information from San Francisco Association of REALTORS® and/or other sources. All data, including all measurements and calculations of area, is obtained from various sources and has not been, and will not be, verified by Prevu or the MLS. Information is provided exclusively for consumer's personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumer may be interested in purchasing.

Full MLS Disclaimers

Rebate estimate is indicative only and based on listing price and estimated buyer's agent commission paid by owner, if applicable. Final rebates are subject to Terms of Use and may vary due to final negotiated transaction terms.