NOT LISTED FOR SALE

Estimated Value: $6,289,000 - $7,978,032

5 Beds
5.5 Baths
1,760 Sq Ft
$4,147/Sq Ft Est. Value

Last Sold February 05, 2024

Last sale price $7,200,000 $4,091 Per Sq Ft

Est. 2% decrease in value since last sale

Current estimated payment $41,209/month

12 Days on Market

Highlights

  • Views of Twin Peaks
  • Wine Cellar
  • Rooftop Deck
  • Alvarado Elementary Rated A-
  • Home Theater
  • 4-minute walk to Noe Valley Courts

About This Home

As of February 2024

This meticulously renovated modern Edwardian-style residence has been thoughtfully expanded and enhanced over 5 years, resulting in a contemporary floorplan that integrates seamlessly with sophisticated architectural details. A high-level attention to detail is evident in the meticulous duplication of many of the original architectural details harking back to the property's 1900 history. The finishes throughout the home surpass the standard typically seen in development properties, showcasing a level of quality and craftsmanship that sets this property apart. This home offers a size that exceeds the norm in Noe Valley, providing a sense of spaciousness and luxury rarely found in the area. Furthermore, the residence features three decks with over 500 sq ft, offering captivating outdoor spaces to enjoy indoor/outdoor living. Completing the allure of this exceptional property is a beautifully landscaped yard, providing a serene retreat and the perfect complement to the sophisticated interior. With its panoramic views of Noe Valley, downtown, and a slice of the Bay, this four-level residence presents an unparalleled opportunity to experience modern luxury living in one of San Francisco's most sought-after neighborhoods.

Last Agent to Sell the Property

Ana T. Dierkhising

Compass License #01466124 Listed on: 01/16/2024

Compass

Last Buyer's Agent

Lamisse Droubi

City Real Estate License #01257759

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $30,154

Year Built

  • Built in 1900 | Remodeled

Lot Details

  • 2,848 Sq Ft Lot
  • Wood Fence
  • Back Yard Fenced
  • Landscaped
  • Sprinkler System

Property Views

  • Bay
  • Twin Peaks
  • Downtown

Home Design

  • Edwardian Architecture
  • Concrete Foundation

Interior Spaces

  • Skylights
  • Double Pane Windows
  • Wine Cellar
  • Family Room Off Kitchen
  • Living Room with Attached Deck
  • Formal Dining Room
  • Home Theater
  • Home Office

Kitchen

  • Breakfast Area or Nook
  • Kitchen Island
  • Marble Countertops

Flooring

  • Wood
  • Radiant Floor
  • Stone
  • Marble
  • Tile

Bedrooms and Bathrooms

  • Walk-In Closet
  • Dual Vanity Sinks in Primary Bathroom
  • Soaking Tub in Primary Bathroom
  • Bathtub with Shower
  • Multiple Shower Heads

Laundry

  • Laundry Room
  • Laundry on upper level
  • Dryer
  • Washer
  • Sink Near Laundry

Home Security

  • Carbon Monoxide Detectors
  • Fire and Smoke Detector
  • Fire Suppression System

Parking

  • 2 Car Garage
  • Enclosed Parking
  • Garage Door Opener
  • Open Parking

Eco-Friendly Details

  • Energy-Efficient Appliances
  • Energy-Efficient Windows

Additional Features

  • Rooftop Deck
  • Zoned Heating System

Listing and Financial Details

  • Assessor Parcel Number 2801-011

Home Details

Home Type

Single Family

Est. Annual Taxes

$30,154

Year Built

Built in 1900 | Remodeled

Lot Details

0

Listing Details

  • Property Type: Residential
  • Property Sub Type: Single Family Residence
  • Subtype Description: Luxury
  • Architectural Style: Edwardian
  • Property Condition: Updated/Remodeled
  • Remodeled/Updated: Yes
  • Remodeled Updated Desc: Bath 0-5YR, Bed 0-5YR, Kitchen 0-5YR, Other-Rmks 0-5YR
  • Year Built: 1900
  • Special Features: None
  • Stories: 0

Interior Features

  • Bedrooms: 5
  • Master Bathroom Features: Double Sinks, Multiple Shower Heads, Radiant Heat, Soaking Tub, Stone
  • Master Bedroom Features: Walk-In Closet
  • Bathrooms: 6
  • Half Bathrooms: 1
  • Full Bathrooms: 5
  • Dining Room Features: Formal Area
  • Bathroom Features: Shower Stall(s), Steam, Tub w/Shower Over
  • Family Room Features: Deck Attached
  • Flooring: Marble, Stone, Tile, Wood
  • Interior Amenities: Skylight(s)
  • Kitchen Features: Breakfast Area, Island, Island w/Sink, Kitchen/Family Combo, Marble Counter, Pantry Cabinet, Pantry Closet, Stone Counter
  • Laundry Features: Cabinets, Dryer Included, Sink, Upper Floor, Washer Included
  • Lower Level: Bedroom(s), Family Room, Full Bath(s), Garage, Street Entrance
  • Main Level: Dining Room, Family Room, Kitchen, Living Room, Partial Bath(s)
  • Room Type: Dining Room, Family Room, Kitchen, Laundry, Living Room, Primary Bathroom, Primary Bedroom, Media Room, Office, Wine Cellar
  • Window Features: Dual Pane Full

Exterior Features

  • Fencing: Back Yard, Wood
  • Foundation: Concrete
  • Patio And Porch Features: Uncovered Deck
  • View: Bay, City Lights, Downtown, Twin Peaks

Garage/Parking

  • Parking Access: Independent
  • Parking Features: Covered, Enclosed, Garage Door Opener, Uncovered Parking Space
  • Parking Fees: No
  • Parking Type: On Site (Single Family Only)
  • Total Parking Spaces: 2.00

Utilities

  • Cooling: Other
  • Heating: Central, MultiZone, Radiant Floor
  • Security Features: Carbon Mon Detector, Fire Alarm, Fire Suppression System, Smoke Detector
  • Sewer: Public Sewer
  • Utilities: Public
  • Water Source: Public

Lot Info

  • Assessor Parcel Number: 2801-011
  • Irrigation: Irrigation Connected
  • Lot Features: Auto Sprinkler F&R, Garden, Landscape Back, Landscape Front
  • Lot Size Acres: 0.0654
  • Lot Size Sq Ft: 2848.00
  • Lot Size Units: SqFt
  • Price Per Acre: 110091743.12

Green Features

  • Energy Efficient: Appliances, Water Heater, Windows

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Jan 16, 2024
Closed on
Jan 30, 2024
Sold by
4428 23Rd Street Llc
Bought by
Rosenberg-Connelly Revocable Trust and Rosenberg
Seller's Agent
Ana T. Dierkhising
Compass
Buyer's Agent
Lamisse Droubi
City Real Estate
List Price
$7,200,000
Sold Price
$7,200,000
Views
56
Current Estimated Value
$7,067,501

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
-$132,499
Avg. Annual Appreciation
1.46%
Original Mortgage
$4,320,000
Outstanding Balance
$4,234,768
Interest Rate
5.38%
Mortgage Type
New Conventional
Estimated Equity
$3,124,339

Purchase Details

Closed on
May 31, 2018
Sold by
Doherty Mary Jane and The Richard L Merritt 2013 Tru
Bought by
4428 23Rd Street Llc

Purchase Details

Closed on
Nov 5, 2013
Sold by
Merritt Richard L
Bought by
Merritt Richard L
Source: Public Records

Range of Values:

Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Purchase History

Date Buyer Sale Price Title Company
Rosenberg-Connelly Revocable Trust $7,200,000 First American Title
4428 23Rd Street Llc $1,950,000 Fidelity National Title Co C
Merritt Richard L -- None Available
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Rosenberg-Connelly Revocable Trust $4,320,000
Previous Owner 4428 23Rd Street Llc $4,300,000
Previous Owner 4428 23Rd Street Llc $1,267,500
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
02/05/2024 02/05/24 Sold $7,200,000 0.0% $4,091 / Sq Ft
01/28/2024 01/28/24 Pending -- -- --
01/16/2024 01/16/24 For Sale $7,200,000 -- $4,091 / Sq Ft
Source: San Francisco Association of REALTORS® MLS

Tax History Compared to Growth

Source: Public Records

Tax History

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2025 $30,154 $2,556,891 $1,664,072 $892,819
2024 $30,154 $2,506,757 $1,631,444 $875,313
2023 $29,709 $2,457,605 $1,599,455 $858,150
2022 $25,634 $2,110,791 $1,568,094 $542,697
2021 $24,952 $2,049,797 $1,537,348 $512,449
2020 $25,054 $2,028,780 $1,521,585 $507,195
2019 $24,193 $1,989,000 $1,491,750 $497,250
2018 $650 $53,348 $28,404 $24,944
2017 $642 $52,303 $27,848 $24,455
2016 $601 $51,278 $27,302 $23,976
2015 $594 $50,508 $26,892 $23,616
2014 $578 $49,520 $26,366 $23,154
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: San Francisco Association of REALTORS® MLS

MLS Number: 423923721

San Francisco Association of REALTORS® MLS

APN: 2801-011