256 Waterville Street, San Francisco, CA 94124, San Francisco, 94124 - 6 bed, 6 bath
Loading property details...
San Francisco, CA 94124
Analysis of 256 Waterville Street, San Francisco, CA 94124 is currently available with a list price of $2,700,000. The property maintains a Excellent Condition Rating (95/100), indicating excellent structural integrity and modern finishes throughout. This turnkey property requires minimal updates and is ready for immediate occupancy. Located in a high-demand neighborhood within the San Francisco Unified School District, this asset is categorized as a low-risk, high-reward acquisition suitable for both Buy-and-Hold Investors and Owner-Occupants willing to undertake light renovation work.
Property is new construction or fully renovated.
Although originally built in 1922, the property has undergone an extensive, high-end renovation within the last 5 years. The interior features modern wide-plank hardwood flooring, recessed lighting, updated black-frame windows, and a contemporary designer kitchen with premium cabinetry and high-end appliances. The configuration of six en-suite bedrooms indicates a complete structural and systems overhaul, meeting the highest standards of modern quality and design with no visible deferred maintenance.
Elementary School: Chinese Immersion School At Deavila (9/10). Middle School: Lilienthal (Claire) Elementary School (9/10). High School: Lowell High School (10/10).
Featuring six en-suite bedrooms, this property offers an exceptional level of privacy and functional flexibility that is extremely rare for the San Francisco market.
The massive 7,500 sq ft lot provides significant outdoor space and rare scale for the city, offering substantial value-add and development potential.
Bedroom count discrepancy between mls listing and other public or private record. mls listing bedroom count = 6, other record bedroom count = 5.
The additional 3-bedroom unit is unwarranted, which may present challenges regarding building code compliance, future permitting, or specific financing requirements.
The immediate neighborhood public schools carry low performance ratings, which could impact the property's appeal to families prioritizing local educational options.
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.
No exterior & parking available.
Grades K-5 • 0.5 mi
Grades K-5 • 1.4 mi
Grades K-5 • 1.5 mi
No sensitive facilities data found.
| Feature | Subject | Average Home | Neighborhood Ranking (50 Listings) |
|---|---|---|---|
| Beds | 6.0 | 3.0 | 97% |
| Baths | 6.0 | 2.0 | 97% |
| Square foot | 3,467 | 1,447 | 97% |
| Lot Size | 7,501 | 2,495.99 | 97% |
| Price | $2.70M | $934.0K | 97% |
| Price per sq ft | $779 | $700 | 73% |
| Built year | 1922 | 1951 | 20% |
| HOA | $0 | $0 | 50% |
| Days on market | 37 | 186 | 3% |
Mar 16, 2026
$2,700,000
Initial Listing
Jun 7, 2019
$1,800,000
Public Record