245 Alhambra Street, San Francisco, CA 94123, San Francisco, 94123 - 4 bed, 4 bath

245 Alhambra Street, San Francisco, CA 94123 home-pic-0
ACTIVE$4,750,000
245 Alhambra Street, San Francisco, CA 94123
4Beds
4Baths
2,895Sqft
3,454.31Lot
Year Built
1924
Close
-
List price
$4.75M
Original List price
-
Price/Sqft
$1,641
HOA
$0
Days on market
-
Sold On
-
MLS number
425092079
Home ConditionExcellent
Features
Deck
Spa
View-

About this home

Possibly Over-Priced:The estimated price is 9% below the list price. We found 4 Cons,6 Pros. Rank: price - $4.75M(46th), sqft - 2895(46th), beds - 4(50th), baths - 4(50th).

Poised prominently at an enviable corner of Alhambra and Avila, just one block from famed Chestnut Street and moments from the waterfront, 245 Alhambra St offers the perfect blend of modern luxury and iconic Marina charm. Seamlessly blending indoor-outdoor living with this oversized corner lot and expansive private yard, this 4+bedroom, 3.5-bath, 2-car garage home beckons the ultimate urban dweller. The home is bathed in natural light from windows on all four sides, showcasing stylish contemporary upgrades including a stunning chef's kitchen with custom cabinetry, Wolf range, Sub-zero refrigerator, Viking compactor. An impressive primary suite boasts a spa-like bath, deep walk-in closet and attached sunroom/office/nursery that flows harmoniously to a wrap-around deck. Continue on to your own private oasis - 1,500sqft of outdoor terrain - a rare, expansive flat yard featuring a hot tub, outdoor shower and plenty of space to entertain or unwind. There are countless upgrades throughout this magnificent home (wine storage room, separate laundry room, tankless water heater to name a few). The home is steps to Chestnut St. shopping & dining and a short stroll to the Bay - ultimate Marina living!

Nearby schools

6/10
San Francisco Public Montessori School
Public,K-50.7mi
2/10
Cobb (William L.) Elementary School
Public,K-50.9mi
/10
Chinese Education Center
Public,K-52.0mi
8/10
Sutro Elementary School
Public,K-52.1mi
9/10
Chinese Immersion School At Deavila
Public,K-52.2mi
1/10
Mission Education Center
Public,K-54.1mi
2/10
Fairmount Elementary School
Public,K-54.3mi
6/10
Marina Middle School
Public,6-80.2mi
9/10
Lilienthal (Claire) Elementary School
Public,K-80.2mi
9/10
Roosevelt Middle School
Public,6-81.7mi
3/10
Carmichael (Bessie)/Fec
Public,K-82.5mi
6/10
Rooftop Elementary School
Public,K-83.2mi
8/10
Yu (Alice Fong) Elementary School
Public,K-83.3mi
4/10
Buena Vista/ Horace Mann K-8
Public,K-83.5mi
9/10
Lawton Alternative Elementary School
Public,K-84.0mi
2/10
Revere (Paul) Elementary School
Public,K-84.7mi
3/10
San Francisco Community Alternative School
Public,K-85.2mi
8/10
Galileo High School
Public,9-120.9mi
7/10
Wallenberg (Raoul) Traditional High School
Public,9-121.5mi
2/10
Wells (Ida B.) High School
Public,9-121.8mi
3/10
Mission High School
Public,9-122.8mi
3/10
O'connell (John) High School
Public,9-123.2mi
7/10
Washington (George) High School
Public,9-123.3mi
1/10
Downtown High School
Public,9-123.4mi
2/10
S.F. International High School
Public,9-123.6mi
6/10
Academy Of Arts And Sciences
Public,9-123.9mi
9/10
Asawa (Ruth) San Francisco School Of The Arts, A Public School.
Public,9-123.9mi
7/10
Lincoln (Abraham) High School
Public,9-124.4mi
2/10
Marshall (Thurgood) High School
Public,9-125.0mi
10/10
Lowell High School
Public,9-125.4mi
7/10
Balboa High School
Public,9-125.5mi
2/10
Jordan (June) School For Equity
Public,9-125.7mi
5/10
Burton (Phillip And Sala) Academic High School
Public,9-125.9mi

Price History

Date
Event
Price
12/15/25
Price Change
$4,750,000
07/26/21
Sold
$4,700,000
02/16/18
Sold
$4,421,000
08/14/07
Sold
$2,825,000
07/28/06
Sold
$2,695,000
03/14/03
Sold
$1,900,000
Condition Rating
Excellent

Despite being built in 1924, the property has undergone extensive, high-quality modern renovations, as evidenced by the 'stunning chef's kitchen' with custom cabinetry, Wolf range, Sub-zero refrigerator, and Viking compactor. The primary suite features a 'spa-like bath' and 'countless upgrades throughout,' including a tankless water heater. The description emphasizes 'modern luxury' and 'stylish contemporary upgrades,' indicating that all major components are new or virtually new, meeting current quality standards. The property is move-in ready with no deferred maintenance.
Pros & Cons

Pros

Great Schools: Elementary School: Chinese Immersion School At Deavila (9/10). Middle School: Lilienthal (Claire) Elementary School (9/10). High School: Lowell High School (10/10).
Premier Marina Location: Strategically positioned on an enviable corner lot, just one block from famed Chestnut Street and moments from the waterfront, offering unparalleled access to dining, shopping, and recreational activities.
Exceptional Outdoor Living: Features a rare, expansive 1,500 sqft private flat yard with a hot tub and outdoor shower, providing a luxurious oasis for entertaining and relaxation in an urban setting.
Luxury Modern Renovations: Boasts stylish contemporary upgrades throughout, including a stunning chef's kitchen with custom cabinetry, Wolf range, Sub-zero refrigerator, Viking compactor, a spa-like primary bath, wine storage, and a tankless water heater.
Abundant Natural Light: The home is bathed in natural light from windows on all four sides, creating a bright and inviting living environment.
Valuable 2-Car Garage: Includes a highly sought-after 2-car garage, a significant amenity in San Francisco's dense urban landscape.

Cons

Low Available Lot Utilization: The property has a small lot size, more than 70 percent of which is taken by its living area. lot size in square feet = 3454, living area = 2895.
High Price Point: With a list price of $4.75 million, the property targets a very specific luxury market segment, potentially limiting the pool of prospective buyers.
Potential for Noise/Traffic: Its prominent corner location and proximity to bustling Chestnut Street may expose residents to increased ambient noise and vehicle traffic.
Lack of Central Air Conditioning: Despite extensive modern upgrades, the description does not mention a cooling system, which could be a drawback for some buyers, particularly during warmer periods.

Best solution for experienced home buyers!

Data-driven home buying experience with our licensed real estate agents and cutting-edge AI

Browse Properties by State Browse housing market trends by state