$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!
Sold for $1,250,000
$1,250,000
174-176 Madrid St, San Francisco, CA 94112
5beds
2,025sqft
Duplex
Built in 1904
-- sqft lot
$1,310,500 Zestimate®
$617/sqft
$3,218 Estimated rent
Home value
$1,310,500
$1.18M - $1.44M
$3,218/mo
Zestimate® history
Owner options
List your home for rent
$3,218/mo
Rent Zestimate®
Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.
$3,218/mo
Rent Zestimate®
Refinance and save
$8,076/mo
Est. payment
Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.
$8,076/mo
Est. payment
Explore your selling options
Work with a Zillow partner agent
Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.
Get startedList with your own agent
Get your home in front of millions of buyers by listing it on Zillow.
Learn how to do itSell it yourself
Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).
List your homeWhat's special
Zillow last checked:
Listing updated:
Listed by:
Wendy W. Tam DRE #01479624 415-533-1630,
W Real Estate 415-683-4980
Bought with:
David Anthony Juarez, DRE #01787750
KW Advisors
Michael Minson
KW Advisors
Source: SFAR,MLS#: 423916391
Originating MLS: San Francisco Association of REALTORS
Originating MLS: San Francisco Association of REALTORSFacts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 5
- Bathrooms: 2
- Full bathrooms: 2
Appliances
- Included: Dishwasher, Free-Standing Gas Range, Washer/Dryer
- Laundry: In Unit
Features
- Flooring: Wood
Interior area
- Total structure area: 2,025
- Total interior livable area: 2,025 sqft
Property
Parking
- Total spaces: 2
- Parking features: Attached, Garage, Off Street
- Has attached garage: Yes
Features
- Patio & porch: Balcony/Deck
- Has view: Yes
- View description: City, Downtown, Garden, San Francisco, Twin Peaks
Lot
- Size: 2,500 Square Feet
- Features: Garden
Details
- Parcel number: 5955006
- Special conditions: Standard
Construction
Type & style
- Home type: MultiFamily
- Property subtype: Duplex
Materials
- Foundation: Concrete
- Roof: Shingle
Condition
- Updated/Remodeled
- New construction: No
- Year built: 1904
Utilities & green energy
- Electric: Separate Meter
- Gas: Separate Meter
- Sewer: Public Sewer
- Water: Separate Meter, Public
Community & HOA
HOA
- Has HOA: No
Location
- Region: San Francisco
- Elevation: 0
Financial & listing details
- Price per square foot: $617/sqft
- Tax assessed value: $1,275,000
- Annual tax amount: $16,027
- Price range: $1.3M - $1.3M
- Date on market: 10/12/2023
- Cumulative days on market: 41 days
- Total actual rent: 3179
Price history
| Date | Event | Price |
|---|---|---|
| 12/6/2023 | Sold | $1,250,000-3.5%$617/sqft |
Source:  SFAR #423916391 Report a problem | ||
| 11/28/2023 | Pending sale | $1,295,000$640/sqft |
Source: SFAR #423916391 Report a problem | ||
| 11/14/2023 | Contingent | $1,295,000$640/sqft |
Source: SFAR #423916391 Report a problem | ||
| 10/19/2023 | Price change | $1,295,000-7.2%$640/sqft |
Source: SFAR #423916391 Report a problem | ||
| 10/13/2023 | Listed for sale | $1,395,000+372.9%$689/sqft |
Source: SFAR #423916391 Report a problem | ||
| 5/3/2023 | Listing removed | -- |
Source: Zillow Rentals Report a problem | ||
| 4/28/2023 | Price change | $3,450-4%$2/sqft |
Source: Zillow Rentals Report a problem | ||
| 4/21/2023 | Price change | $3,595-1.5%$2/sqft |
Source: Zillow Rentals Report a problem | ||
| 4/18/2023 | Price change | $3,650-1.2%$2/sqft |
Source: Zillow Rentals Report a problem | ||
| 4/13/2023 | Price change | $3,695-4%$2/sqft |
Source: Zillow Rentals Report a problem | ||
| 4/8/2023 | Listed for rent | $3,850+18.5%$2/sqft |
Source: Zillow Rentals Report a problem | ||
| 2/24/2021 | Listing removed | -- |
Source: Owner Report a problem | ||
| 10/10/2020 | Listing removed | $3,250$2/sqft |
Source: Owner Report a problem | ||
| 9/29/2020 | Price change | $3,250-23.5%$2/sqft |
Source: Owner Report a problem | ||
| 8/7/2020 | Listed for rent | $4,250$2/sqft |
Source: Owner Report a problem | ||
| 7/3/2020 | Listing removed | $4,250$2/sqft |
Source: Owner Report a problem | ||
| 7/1/2020 | Listed for rent | $4,250$2/sqft |
Source: Owner Report a problem | ||
| 3/10/2000 | Sold | $295,000$146/sqft |
Source: Public Record Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | $16,027 +3.1% | $1,275,000 +2% |
| 2024 | $15,539 +160.8% | $1,250,000 +186.8% |
| 2023 | $5,958 +2.3% | $435,776 +2% |
| 2022 | $5,825 +1.9% | $427,233 +2% |
| 2021 | $5,719 -2.4% | $418,857 +1% |
| 2020 | $5,861 +3.4% | $414,564 +2% |
| 2019 | $5,669 +3.5% | $406,436 +2% |
| 2018 | $5,475 +7.1% | $398,468 +2% |
| 2017 | $5,114 +2.3% | $390,656 +2% |
| 2016 | $5,000 +1.4% | $382,998 +1.5% |
| 2015 | $4,933 +2.6% | $377,246 +2% |
| 2014 | $4,805 | $369,858 +0.5% |
| 2013 | -- | $368,188 +2% |
| 2012 | -- | $360,970 +2% |
| 2011 | -- | $353,893 +0.8% |
| 2010 | -- | $351,250 -0.2% |
| 2009 | -- | $352,085 +2% |
| 2008 | -- | $345,182 +2% |
| 2007 | -- | $338,415 +2% |
| 2006 | -- | $331,780 +2% |
| 2005 | -- | $325,275 +3.9% |
| 2003 | -- | $313,055 +2% |
| 2002 | -- | $306,918 +2% |
| 2001 | -- | $300,900 +215.4% |
| 2000 | -- | $95,391 |
Find assessor info on the county website
Neighborhood: Excelsior
Nearby homes
- $--3 bd1 ba1.1k sqft174 Madrid St, San Francisco, CA 94112Off Market
- $1,106,2002 bd1 ba1.1k sqft170 Madrid St, San Francisco, CA 94112Off Market
- $1,597,5004 bd3 ba1.8k sqft178 Madrid St, San Francisco, CA 94112Off Market
- $1,462,8003 bd2 ba2.2k sqft166 Madrid St, San Francisco, CA 94112Off Market
- $1,375,9003 bd1 ba1.8k sqft182 Madrid St, San Francisco, CA 94112Off Market
- $1,100,0004 bd3 ba1.7k sqft162 Madrid St, San Francisco, CA 94112Sold
- $1,161,7002 bd1 ba1.5k sqft158 Madrid St, San Francisco, CA 94112Off Market
- $1,050,5002 bd2 ba1k sqft337 Avalon Ave, San Francisco, CA 94112Off Market
Nearby schools
GreatSchools rating
- 3/10Hillcrest Elementary SchoolGrades: K-5Distance: 0.6 mi
- 3/10King Jr. (Martin Luther) Academic Middle SchoolGrades: 6-8Distance: 1.3 mi
- 3/10Jordan (June) School For EquityGrades: 9-12Distance: 0.6 mi
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$1,310,500
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$1,310,500
- California
- San Francisco County
- San Francisco
- 94112
- Excelsior
- 174-176 Madrid St
Nearby cities
Nearby neighborhoods
Nearby zip codes
Other San Francisco Topics
