Movoto Real Estate
Sold on 11/22/2023

174 Madrid St, San Francisco, CA 94112

$1,250,000

Last sold 11/22/2023 after 41 Days

  • 5

    bed

  • 2

    bath

  • 2,025

    Sqft ($617/Sqft)

Multi-family not for sale

About 174 Madrid St

Property type Multi-family
Neighborhood
Year built 1904
HOA fee $0/month
Lot size 2,500 Sqft
Property description
$100,000 price reduction! Discover the epitome of San Francisco charm in this stunning two-unit duplex in Inner Excelsior. A vacant 3 bedroom 1 bath upper unit provides flexible options with the lower 2 bedroom unit rented at $3,179. Perfect for owner user to offset mortgage or as a turnkey investment. Both units have been remodeled w/great care to preserve the period details. The upper flat offers a spacious layout with 3 inviting bedrooms & a generously sized living room. The kitchen is a chef's dream, flowing seamlessly into the dining area, featuring custom maple cabinetry, stainless steel appliances & a Bosch dishwasher. An elegant bathroom graces this level, complete with a 5.5' deep clawfoot tub & bead board walls, adding a touch of classic luxury. The lower level boasts a thoughtfully remodeled 2 bedroom flat, showcasing exquisite details w/ direct access to a large vu deck. Wonderful views from the windows & decks. Large garage w/rm for storage + In-unit laundry. Beautiful yard perfect for entertaining & relaxing. New roof. A+ location, walking distance to Glen Park, BART, tech shuttles & J Church. Stroll to Mission St, restaurants, stores & cafs. Quick access to 280/101. Nearby McLaren Park offer 313 acres of fun!
Listed by
Listing Agent - Wendy Tam
Listing Office - W Real Estate
Source: SFARMLS mls logo
MLS#423916391 • last updated 2 years ago
Movoto checked SFARMLS for data 18 minutes ago
Overview
Levels/Style 0, 0
Virtual Tour N/A
SqFt 2025
SubType Duplex, Flats
Type Residential Income
MLS # 423916391
Status Closed
Lot Size (Acres) 0.0574
Lot Size (SqFt) 2500
Year Built 1904
Condition Updated/Remodeled
Interior
Laundry In Each Unit, Washer/Dryer Owned
Total # of Rooms 10
Flooring Wood
Appliances Dishwasher, Free Standing Gas Range
Exterior
Foundation Concrete
Roof Shingle
# Parking Spaces 2
Parking Desc Attached, Garage, Off Street
Lot Desc Garden
Patio/ Porch Balcony/Deck
Amenities / Utilities
Water Source Public
Sewer/ Septic Public Sewer
Location
View City, Downtown, Garden/Greenbelt, San Francisco, Twin Peaks
County San Francisco
Subdistrict Excelsior
APN 5955-006
Multifamily Details
Unit 2: # Bedrooms 2
Unit 2: # Full Baths 1
Unit 2: SqFt 1000
Unit 2 Sqft Source Not Measured
Unit 1 3 Bedroom + 1 Bath Vacant
Unit 1: # Bedrooms 3
Unit 2: Rent 3179
Unit 1: # Full Baths 1
Separate Meters Electricity, Gas, Water
Unit 1: SqFt 1025
Unit 2 2 Bedroom + 1 Bath
# Units Furnished None
# Of Units Total 2
# Of 3 Bedroom Units 1
# Of 2 Bedroom Units 1
# Of Units Vacant 1
# Of Units Leased 1
Gross Rent Multiplier 10.16
Cap Rate 8.45
We are not permitted to show value estimates for this property.
  • Dec 2023
    mls logo MLS # 423916391
  • Dec 6, 2023 Sold
    $1,250,000 (-3.5%)
  • Nov 22, 2023 Pending
    —
  • Nov 11, 2023 Contingent - Show
    —
  • Oct 18, 2023 Price Change
    $1,295,000 (-7.2%)
  • Oct 12, 2023 Listed
    $1,395,000
  • 174 Madrid St
    $1.25M
  • Excelsior
    $1.1M +12% y/y
  • 94112
    $1.09M +9% y/y
  • San Francisco
    $1.19M 0% y/y
No chart available
Statistics calculated by Movoto

Thinking of selling? Get a Cash Offer.

  • A smooth, fast sale
  • Skip staging and repairs
  • No strings attached
Source: GreatSchools.org © 2026. All rights reserved.

Around Excelsior

Explore everything this neighborhood has to offer. Learn more about Excelsior.
By entering my info and clicking Ask a Question below, I am providing my e-signature and express written consent to receive marketing emails, calls, and texts (including via automatic telephone dialing systems, AI generative, artificial or pre-recorded voice technology) relating to my inquiry from Movoto (and parties calling/messaging on their behalf) even if my number appears on the company, state, or national Do Not Call Registry. You also agree to ourTerms and Conditions and Privacy Policy. Consent not required to receive services (call 1-844-420-1270 to be connected without providing consent).

Nearby recently sold homes in San Francisco, CA

Nearby homes for sale in San Francisco, CA

Newest listings in 94112

  • Real Estate
  • CA
  • San Francisco County
  • San Francisco
  • 94112
  • Excelsior
  • 174 Madrid St
Meet with a real estate agent today (844) 430-0869
The multiple listing information is provided by San Francisco Association of REALTORS®. IDX information is provided exclusively for consumers’ personal, non-commercial use and that it may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information deemed reliable but not guaranteed to be accurate. Buyer to verify all information. The information provided is for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Listing information updated every 15 minutes. Terms of use & Privacy Policy, California Privacy Info. Copyright © 2005 - 2026 Movoto, Inc. All rights reserved. Equal Housing Opportunity CalDRE CalDRE #01517281
Movoto Real Estate is committed to ensuring accessibility for individuals with disabilities. We are continuously working to improve the accessibility of our web experience for everyone. We welcome feedback and accommodation requests, please submit them here.
SFAR Multiple Listing Service™ system
Listings on this page identified as belonging to another listing firm are based upon data obtained from the SFAR MLS, which data is copyrighted by the San Francisco Association of REALTORS(R), but it not warranted. IDX information is provided exclusively for consumers’ personal, non-commercial use and that it may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.
Requests for information regarding mortgage products will be directed to Movoto.com affiliate, Lower, LLC - a licensed Mortgage Lender (NMLS #1124061), or, based on your location, may be redirected to a participating mortgage marketing partner that may pay Lower, LLC for any consumer contact information provided through this site.