
San Francisco, CA 94118
Analysis of 3842-3854 Geary Boulevard, San Francisco, CA 94118 is currently available with a list price of $6,550,000. The property maintains a Fair Condition Rating (50/100), suggesting the property is in acceptable condition with potential for value enhancement through selective updates and improvements. 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 moderate renovation needed.
Built in 1909, this mixed-use property is functional and fully occupied, but the age (>20 years) and lack of mentioned recent renovations to kitchens, bathrooms, or major systems indicate a dated condition that will likely require minor repairs or modernization.
Elementary School: Chinese Immersion School At Deavila (9/10). Middle School: Lilienthal (Claire) Elementary School (9/10). High School: Lowell High School (10/10).
The property is 100% occupied with a well-established ground-floor restaurant and high-density residential units, providing immediate cash flow and a diversified revenue stream in a supply-constrained market.
Situated on the high-visibility Geary Boulevard corridor in the Richmond District, the building benefits from excellent public transit access and significant foot traffic, ensuring long-term commercial viability.
Built in 1909, the building's age may require significant ongoing capital expenditures for seismic retrofitting, system upgrades, and general maintenance associated with century-old structures.
With 16 bedrooms but only 4 bathrooms across the residential units, the high density may lead to increased wear and tear and could limit the property's appeal to higher-end tenant profiles.
3842-3854 Geary Boulevard presents a rare mixed-use investment opportunity in San Francisco's central Richmond District. Built in 1909, this approximately 10,716-square-foot building is situated on a 6,608-square-foot lot along a high-visibility, transit-served commercial corridor. The ground floor is occupied by Bella Trattoria, a well‑known neighborhood restaurant and bar, providing stable commercial income in a proven location. The second floor comprises five residential rental units: three 3-bedroom, 1-bath units and one 4-bedroom, 2-bath unit. The property is currently 100% occupied, offering immediate in‑place cash flow. The building's scale, frontage on Geary Boulevard, and established tenancy make it suitable for investors seeking long‑term income in a supply‑constrained market. Proximity to local retail, services, public transportation, and major thoroughfares supports both the commercial and residential components. This is a straightforward, income‑producing asset with mixed‑use zoning and historic character, positioned in a stable San Francisco neighborhood with consistent rental demand.
No exterior & parking available.
Grades K-5 • 0.3 mi
Grades K-5 • 0.4 mi
Grades K-5 • 0.6 mi
No sensitive facilities data found.
| Feature | Subject | Average Home |
|---|---|---|
| Beds | 16.0 | 5.5 |
| Baths | 5.0 | 4.0 |
| Square foot | 10,716 | 4,754.5 |
| Lot Size | 6,608 | 1,647.5 |
| Price | $6.55M | $2.60M |
| Price per sq ft | $611 | $541 |
| Built year | 1909 | 1917 |
| HOA | $0 | $0 |
| Days on market | 48 | 116 |
Jul 23, 2026
$6,550,000
Initial Listing
Apr 15, 2008
$3,900,000
Public Record
Aug 17, 2000
$1,950,000
Public Record