Phone858-220-9001
Login or sign up for new accountLogin / Register
Email MeEmail Me
  • Search Listings
    • Residential
    • Lease
  • Previous Sales
  •   Buyers
    • Renting vs. buying
    • How much can I afford?
    • Why work with a real estate agent
    • Finding your home
    • What do you want in a home?
    • Submitting an offer
    • After the offer is accepted
    • Moving
  •     Sellers
    • Why work with a real estate agent
    • Getting your home ready for sale
    • Pricing your home to sell
    • Negotiating the sale
    • Transaction management
    • Moving
  •     Services
    • Onepoint
    • Home Financing
    • Insurance
    • Escrow
    • Title
    • Home Warranty
    • PRESALE/STAGING
    • Relocation
  •     About
    • Leadership Team
    • About Us
    • Globally Respected
    • The Charitable Foundation
    • Diversity & Inclusion
    • Doyle
    • Agents Only
Menu
Berkshire Hathaway HomeServices California Properties Berkshire Hathaway HomeServices California Properties
Any Price
-
  • 0
  • $100,000+
  • $250,000+
  • $500,000+
  • $750,000+
  • $1,000,000+
0+ Beds
  • 0+
  • 1+
  • 2+
  • 3+
  • 4+
  • 5+
0+ Baths
  • 0+
  • 1+
  • 2+
  • 3+
  • 4+
  • 5+
Property Type
Other
  • Home
  • 459 Flood

459 Flood, San Francisco, CA 94112

$1,180,000 Approx. USD 4 beds, 4 baths
2,039 sqft
Save My Notes
Share
  • Copy Link
  • Facebook
  • Twitter
  • Pinterest
Source MLS Verified
MORE INFO
BrochureBrochure

Photo of Patrick Ahern

Patrick Ahern REALTORĀ® - Sales Associate 858-220-9001 m
858-459-0501 o
Lic#: 00610408
NRDS ID: 196548265
aherngroup@gmail.com
Text Me
Call My Cell
Call My Office
Lic#: 00610408
NRDS ID: 196548265
aherngroup@gmail.com
La Jolla Prospect Office
1299 Prospect St, Ste. 100-101, 200-203 & 301-302
La Jolla, CA 92037
Phone: 858-459-0501
Fax: 858-459-3275
La Jolla Prospect 1299 Prospect St, Ste. 100-101, 200-203 & 301-302
La Jolla, CA 92037
Call Branch Office
Fax: 858-459-3275
Mortgage Calculator
GET PRE-APPROVED
Interested in This Property? Your message will be sent to Patrick.
By submitting your information, you consent to be contacted by email, SMS message, and/or phone call. You may opt out at any time per our Privacy Policy.
  • Save
  • My Notes

Listing Agent


JOANNA CHEUNG | joannacheung9779@yahoo.com
Lic#: 01133502
Broker: Courtesy of APEX REALTY & MANAGEMENT INC.
Phone: 626-818-3478

Agent Remarks

Rarely available: a 100% detached, 4-bedroom, 4-bathroom single-family home on a generous 3,371 sq ft lot in the heart of Sunnyside, one of San Francisco's most consistent seller's markets. The main level lives as a 2-bedroom, 2-bath home (per Assessor's records), with two additional bedrooms and bathrooms across two lower-level units (buyer and buyer's agent to verify square footage and permitted use with the City). The main level is anchored by a striking bay-window room filling the space with soft, even natural light, warm hardwood floors, and an ornate carved fireplace mantle.The room offers flexible use as a formal living/dining space or an additional bedroom - currently configured as a fifth bedroom with its own private door and walls. The primary en-suite bedroom is sun-splashed and overlooks a peaceful backyard. Out back, mature bushes, an apple tree, and a lemon tree frame a sun-drenched, south-facing yard, perfect for lounging or al fresco dining. Both upstairs bathrooms have been beautifully renovated with sleek floating vanities in warm wood tones, white quartz countertops, modern fixtures, and a tiled shower wrapped in marble-look tile with a hexagon mosaic floor. One bath adds crystal sconce lighting for a soft, boutique-hotel feel. Downstairs, two separate units offer real flexibility: live in the main level and use the lower-level units to help offset your mortgage, house extended family, or simply enjoy the extra space. The real prize is the lot itself: wide, usable, and detached on all sides, with genuine room for an ADU or a major addition, increasingly rare this close to the city center. It sits on a good, quiet street half a block to Sunnyside Elementary, minutes to Glen Park BART, Balboa Park BART, Monterey Blvd shops and restaurants, West Portal, City College of San Francisco, and the trails of Mount Davidson, with easy freeway access. Delivered 100% vacant. Move fast, this one won't last. Seller, listing broker and agents do not represent or guarantee the accuracy of the square footage, number of bedrooms & bathrooms, lot size, or any other information herein. Buyer and buyer's agent to independently verify all information through personal inspection and with appropriate professionals.

Listing Details

Property type: Single Family Residence (Single Family)
Status: Pending
MLS# WS26193201
Price: $1,180,000
HOA Fee is $0.00
Beds: 4
Baths: 4 (4 full)
Living Room fireplaces
Built in 1922
2,039 sqft
2 stories
0.08 acres
Lot size: 0.0774
County: San Francisco
Interior features: Separate/Formal Dining Room,Eat-in Kitchen,Primary Suite
Appliances: Freezer,Disposal,Gas Oven,Gas Range,Gas Water Heater,Refrigerator,Self Cleaning Oven,Water Heater,Dryer,Washer
Parking description: Driveway Level
Lot description: ZeroToOneUnitAcre
Heating/cooling: Central Air
Heating description: Central
MLS area: SFO - San Francisco

Last Updated: 10/8/2026

 Days On Market (DOM): 34

 Find more San Francisco homes and real estate

 Find more homes in 94112 zip code

This listing belongs to the SFO - San Francisco MLS area

Lat/Long: 37.729625, -122.450236.
Find nearby listings

DISCLAIMER: There is NO WARRANTY, expressed or implied, for the accuracy of this information or its applicability to your financial situation. Please consult your financial and/or tax advisor. GET PRE-APPROVED The loan's interest rate will depend upon the specific characteristics of the loan transaction and credit profile up to the time of closing.

94112 Area Map

Demographics

Schools

CLICK TO VIEW MAP

Similar Listings

Next Listing
237 Gennessee Street VIRTUAL TOUR
237 Gennessee Street ,
$1,095,000 Approx. USD 2 beds, 2 baths

List Date: 10/16/2026
Status: Active
MLS #: ML82064813

My Notes Save
Listing courtesy of
750 Joost Ave VIRTUAL TOUR
750 Joost Ave ,
$1,295,000 Approx. USD 3 beds, 2 baths

List Date: 10/15/2026
Status: Active
MLS #: 41151371

My Notes Save
Listing courtesy of
63 Minerva St. VIRTUAL TOUR
63 Minerva St. ,
$1,099,900 Approx. USD 4 beds, 3 baths

List Date: 12/4/2020
Status: Pending
MLS #: 200053282

My Notes Save
Listing courtesy of
531 Head Street VIRTUAL TOUR
531 Head Street ,
$1,299,000 Approx. USD 4 beds, 2 baths

List Date: 10/13/2026
Status: Active
MLS #: ML82063756

My Notes Save
Listing courtesy of
688 Morse Street VIRTUAL TOUR
688 Morse Street ,
$1,299,000 Approx. USD 4 beds, 2 baths

List Date: 6/24/2026
Status: Active
MLS #: ML82052112

My Notes Save
Listing courtesy of
518 Athens Street VIRTUAL TOUR
518 Athens Street ,
$1,288,000 Approx. USD 3 beds, 3 baths

List Date: 7/15/2026
Status: Pending
MLS #: ML82052718

My Notes Save
Listing courtesy of
286 Sagamore St VIRTUAL TOUR
286 Sagamore St ,
$1,300,000 Approx. USD 4 beds, 3 baths

List Date: 2/16/2026
Status: Active
MLS #: 41124187

My Notes Save
Listing courtesy of
844 Brunswick Street VIRTUAL TOUR
844 Brunswick Street ,
$1,099,000 Approx. USD 4 beds, 3 baths

List Date: 7/30/2026
Status: Active Under Contract
MLS #: ML82056071

My Notes Save
Listing courtesy of
150 Cambridge St VIRTUAL TOUR
150 Cambridge St ,
$1,165,000 Approx. USD 3 beds, 2 baths

List Date: 6/8/2026
Status: Active
MLS #: 41137622

My Notes Save
Listing courtesy of
253 Baltimore Way VIRTUAL TOUR
253 Baltimore Way ,
$1,050,000 Approx. USD 3 beds, 1 baths

List Date: 10/8/2026
Status: Active
MLS #: ML82063949

My Notes Save
Listing courtesy of
Previous Listing
  • Search
    • My Previous Sales
    • Residential
    • Lease
    • Open Houses
    • Commercial
    • New Homes
    • Luxury
  • Buyers
    • Renting vs. buying
    • How much can I afford?
    • Why work with a real estate agent
    • Finding your home
    • What do you want in a home?
    • Submitting an offer
    • After the offer is accepted
    • Moving
  • Sellers
    • Why work with a real estate agent
    • Getting your home ready for sale
    • Pricing your home to sell
    • Negotiating the sale
    • Transaction management
    • Moving
  • Services
    • Prosperity Home Mortgage
    • HomeServices Relocation
    • HomeServices Insurance Agency
    • Pickford Escrow
    • California Title Company
    • American Home Shield
    • PINNACLE
    • myNHD
  • About
    • Leadership Team
    • About Us
    • Globally Respected
    • The Charitable Foundation
    • Diversity & Inclusion
    • Doyle
    • Agents Only

Photo of Patrick Ahern

Patrick Ahern REALTORĀ® - Sales Associate 858-220-9001 m
858-459-0501 o
Lic#: 00610408
NRDS ID: 196548265
aherngroup@gmail.com
Text Me
Call My Cell
Call My Office
Lic#: 00610408
NRDS ID: 196548265
aherngroup@gmail.com

La Jolla Prospect Office
1299 Prospect St, Ste. 100-101, 200-203 & 301-302
La Jolla, CA 92037
hsoa-logo

© 2026 BHH Affiliates, LLC. An independently operated subsidiary of HomeServices of America, Inc., a Berkshire Hathaway affiliate, and a franchisee of BHH Affiliates, LLC. Berkshire Hathaway HomeServices and the Berkshire Hathaway HomeServices symbol are registered service marks of Columbia Insurance Company, a Berkshire Hathaway affiliate. Equal Housing Opportunity.
Lic#: 01317331

Photo of Equal Housing Opportunity Privacy Policy - California Privacy Notice - Terms of Use - Accessibility
Do Not Sell My Personal Information DMCA.com Protection Status