---
listing_id: SF426173459
status: Active
price: 1990000
beds: 4
baths_full: 4
baths_half: 1
sqft_living: 3366
sqft_lot: 2975
lot_acres: 
year_built: 2023
property_type: Residential
property_subtype: Single Family Residence
address: "511 Lakeview Ave"
city: San Francisco
state: CA
zip: 94112
county: "San Francisco County"
lat: 37.7180866
lng: -122.4545848
days_on_market: 0
hoa_fee: 
hoa_frequency: 
garage_spaces: 0
list_agent: "Eric Yee"
list_office: "Norcal Realty"
list_agent_phone: "(415) 420-5011"
list_agent_license: 01934880
mls_source: RESFAR
modified: 2026-10-29
transaction_type: buy
---

Home | San Francisco County | San Francisco | 94112 | 511 Lakeview Ave

511 Lakeview Ave, San Francisco, CA 94112

MLS: SF426173459 | Status: Active | Price: $1,990,000
Beds/Baths: 4 / 4 /1
Property Type: Residential

Quick Facts

Beds Baths Sq Ft Sq Ft Lot Yr Built
4 4 /1 3,366 2,975 2023

Upcoming Open Houses

Date Time Hosted By
Saturday, October 31 1:00 pm - 4:00 pm
Sunday, November 1 1:00 pm - 4:00 pm

Remarks

Stunning Modern Luxury Home with Spectacular Bay and City Views! Welcome to 511 Lakeview Avenue, an exceptional modern residence built in 2023, offering approximately 3,366 square feet of luxurious living space in San Francisco's desirable Oceanview neighborhood. This impressive four-bedroom, four-and-a-half-bathroom home showcases contemporary architecture, elegant finishes, and breathtaking panoramic Bay and city views. Designed with comfort and sophistication in mind, the home features a spacious open living environment, beautiful engineered hardwood flooring, recessed lighting, elegant chandeliers, and electric fireplaces on multiple levels. The gourmet chef's kitchen is equipped with premium Viking stainless-steel appliances, including a gas range, oven, refrigerator, dishwasher, microwave, and wine refrigerator. Stylish cabinetry, quartz countertops, and thoughtfully designed spaces make this kitchen ideal for everyday living and entertaining. The generously sized bedrooms offer comfort and privacy, while the beautifully appointed bathrooms feature modern finishes and illuminated mirrors. A radiant floor heating system provides customized comfort throughout the home. Additional highlights include custom window shutters, tankless water heater, an attached garage with a 220V

MLS Listing Information

Field Value
MLS # SF426173459
MLS Source San Francisco Association of Realtors® MLS
Days on Site 0

Features

Parking, School, and Other Information

Feature Details
Garage/Parking Attached Garage, Facing Front, Other, Parking - Independent, Garage: 0 Car(s)

Contact Information

Listing Agent Co-Listing Agent
Eric Yee Spencer Luo
Norcal Realty Norcal Realty
License #: 01934880 License #: 01213322
Phone: (415) 420-5011 Phone: (415) 312-3388

Property Units

# Buildings # Leased Units # Total Units
0 – –

School Ratings

School data provided by GreatSchools.org

Nearby Schools

School Type Grades Distance Rating
Sheridan Elementary School public K-5 0.37 mi 3
San Miguel Children Center public UG 0.60 mi N/A
Ortega (Jose) Elementary School public K-5 0.65 mi 7
Denman (James) Middle School public 6-8 0.67 mi 4
Longfellow Elementary School public K-5 0.70 mi 4
Balboa High School public 9-12 0.75 mi 8
George Washington Elementary School public K-5 0.90 mi 4
Sunnyside Elementary School public K-5 0.90 mi 8
Aptos Middle School public 6-8 1.01 mi 7
Woodrow Wilson Elementary School public K-5 1.13 mi 7
Panorama Elementary School public K-5 1.19 mi 6
Guadalupe Elementary School public K-5 1.24 mi 5
Sloat (Commodore) Elementary School public K-5 1.30 mi 6
San Francisco Community Alternative School public K-8 1.34 mi 5
Monroe Elementary School public K-5 1.42 mi 8
Cleveland Elementary School public K-5 1.42 mi 3
Miraloma Elementary School public K-5 1.45 mi 6
Glen Park Elementary School public K-5 1.47 mi 6
John F. Kennedy Elementary School public K-5 1.58 mi 7
Westlake Elementary School public K-5 1.64 mi 5

Nearby Homes

Address Price Beds Baths Sq Ft Status
158 Edinburgh St $1,680,000 6 4 2,774 Active
554 Mangels Ave $1,700,000 4 3 1,600 Active
26 Farnum St $1,598,000 3 2 1,518 Active
2555 25th Ave $1,595,000 3 2 2,077 Active

Disclosures

©2026 San Francisco Association of Realtors® MLS. All rights reserved. All data, including all measurements and calculations of area, is obtained from various sources and has not been, and will not be, verified by broker or MLS. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information. Information provided is for personal, non-commercial use by the viewer and may not be redistributed without explicit authorization from San Francisco Association of Realtors® MLS.

Presently MLSListings.com displays Active, Contingent, Pending, and Recently Sold listings. Recently Sold listings are properties which were sold within the last three years. After that period listings are no longer displayed in MLSListings.com. Pending listings are properties under contract and no longer available for sale. Contingent listings are properties where there is an accepted offer, and seller may be seeking back-up offers. Active listings are available for sale.

This listing information is up-to-date as of October 29, 2026. For the most current information, please contact Eric Yee, (415) 420-5011.