Home › Haight Ashbury › Frederick St
454 Frederick St
Condo, 3 bd, 1 ba, 1,628 sqft, built 1900
Today’s estimate uses 1,628 sqft and the home’s latest facts. It does not estimate the home’s value at a past sale date.
90 sales inside 0.75 mi since Apr 2025. Click a sale on the map, or untick it below, to leave it out.
Drag the circle or this strip to change the searchEstimated sale price today
Medium confidence
$2,181,000
From 90 comps at a weighted median of $1,339 per sqft.
- Block
- 1262
- Lot
- 044
- Sales
- Oct 2025 to Oct 2026
- Prices adjusted to
- 2026-10-30
- Within
- 0.75 mi
- Sold since
- Apr 2025
What other buyers offered
No one has reported a losing offer on this home yet.
Create a free account to see offers and add yours
Free, and there is no password: we email you a sign-in code. Already a member? The same button signs you in.
Interested in this home?
Answer a few quick questions and we'll show you what to do next, from getting pre-approved to making an offer.
I'm interestedSale prices versus asking
Similarity-weighted median: 23.9% above final asking.
Middle half: 12.4% above asking to 42.5% above asking.
75 of 90 selected comps have a verified final asking price.
Comparisons use the final advertised asking price from the same sale, before pending or closing.
Comparable sales (90)
Every sale inside the circle starts ticked. Untick one here, or click it on the map, to leave it out. Closer, more similar sales weigh more.
| Address | Sold | Price | Final asking | Sale vs. asking | Adj. today | $/sqft | Size | Dist. | Why | Match | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 762 Clayton St | 2026-03-30 | $2.47M | $1,695,000 | $777,000 above asking (45.8%) | $2.55M | $1,534 | 3bd 2ba 1,664sf | 0.23 mi | similar size, 3 bd | ||
| 20 Belvedere St | 2026-06-15 | $1.5M | $1,395,000 | $105,000 above asking (7.5%) | $1.56M | $1,060 | 3bd 2ba 1,474sf | 0.22 mi | similar size, 3 bd | ||
| 263 Carl St | 2026-06-05 | $2.1M | $1,695,000 | $405,000 above asking (23.9%) | $2.19M | $1,574 | 3bd 2ba 1,390sf | 0.15 mi | 3 bd | ||
| 122 Hugo St | 2026-05-26 | $2.45M | $1,795,000 | $658,000 above asking (36.7%) | $2.52M | $1,574 | 3bd 3ba 1,598sf | 0.42 mi | similar size, 3 bd | ||
| 504 Cole St | 2026-04-09 | $2.21M | $1,850,000 | $360,000 above asking (19.5%) | $2.24M | $1,242 | 3bd 3ba 1,799sf | 0.27 mi | similar size, 3 bd | ||
| 265 Carl St | 2026-10-21 | $2.19M | $1,495,000 | $691,000 above asking (46.2%) | $2.13M | $1,736 | 3bd 2ba 1,225sf | 0.15 mi | 3 bd, recent | ||
| 1410 Shrader St | 2026-02-18 | $2.1M | $1,695,000 | $405,000 above asking (23.9%) | $2.25M | $1,400 | 3bd 2ba 1,607sf | 0.32 mi | similar size, 3 bd | ||
| 507A Cole St | 2026-06-12 | $1.8M | No asking price | — | $1.88M | $1,313 | 2bd 1ba 1,428sf | 0.24 mi | |||
| 1673 Page St | 2026-07-17 | $1.77M | No asking price | — | $1.87M | $1,310 | 2bd 1.5ba 1,429sf | 0.33 mi | |||
| 31 Beulah St | 2026-10-19 | $4.2M | $2,995,000 | $1,205,000 above asking (40.2%) | $4.09M | $1,815 | 4bd 3ba 2,251sf | 0.06 mi | recent | ||
| 169 Parnassus Ave | 2026-04-10 | $2.73M | $1,850,000 | $875,000 above asking (47.3%) | $2.76M | $1,400 | 3bd 2ba 1,968sf | 0.17 mi | 3 bd | ||
| 487 Belvedere St | 2026-06-11 | $3.35M | $2,195,000 | $1,155,000 above asking (52.6%) | $3.49M | $1,803 | 3bd 3ba 1,935sf | 0.29 mi | 3 bd | ||
| 105 Belvedere St | 2026-03-05 | $2.6M | $2,350,000 | $250,000 above asking (10.6%) | $2.69M | $1,339 | 3bd 2ba 2,005sf | 0.17 mi | 3 bd | ||
| 1634 Page St | 2026-04-29 | $1.25M | No asking price | — | $1.26M | $880 | 3bd 1ba 1,437sf | 0.38 mi | 3 bd | ||
| 1010 Cole St | 2026-07-01 | $1.83M | $1,295,000 | $535,000 above asking (41.3%) | $1.93M | $1,544 | 3bd 1ba 1,250sf | 0.19 mi | 3 bd | ||
| 986 Ashbury St | 2026-07-17 | $1.75M | No asking price | — | $1.85M | $1,269 | 2bd 2ba 1,455sf | 0.38 mi | |||
| 1225 Waller St | 2026-03-30 | $1.8M | $1,498,000 | $302,000 above asking (20.2%) | $1.86M | $1,254 | 3bd 2ba 1,483sf | 0.47 mi | similar size, 3 bd | ||
| 1454 Waller St | 2026-04-24 | $1.29M | $1,250,000 | $44,000 above asking (3.5%) | $1.31M | $948 | 2bd 2ba 1,380sf | 0.29 mi | |||
| 734 Masonic Ave | 2026-09-08 | $1.85M | No asking price | — | $1.85M | $1,248 | 1ba 1,482sf | 0.62 mi | similar size, recent | ||
| 1125 Shrader St | 2026-06-15 | $2.25M | $1,395,000 | $855,000 above asking (61.3%) | $2.34M | $1,786 | 2bd 2ba 1,312sf | 0.17 mi | |||
| 138 Saturn St | 2026-07-22 | $1.8M | No asking price | — | $1.9M | $1,411 | 3bd 2ba 1,346sf | 0.53 mi | 3 bd | ||
| 745 Cole St | 2025-12-12 | $1.2M | $1,195,000 | At asking | $1.38M | $652 | 3bd 2ba 2,113sf | 0.10 mi | 3 bd | ||
| 529 Clayton St | 2025-10-31 | $1.67M | $1,295,000 | $370,000 above asking (28.6%) | $1.88M | $1,274 | 2bd 2ba 1,479sf | 0.29 mi | similar size | ||
| 1664 Grove St | 2026-05-26 | $2.05M | $2,095,000 | $45,000 below asking (2.1%) | $2.1M | $1,280 | 4bd 2ba 1,643sf | 0.73 mi | similar size | ||
| 764 Clayton St | 2026-08-28 | $3.22M | $2,695,000 | $522,500 above asking (19.4%) | $3.34M | $1,483 | 4bd 4ba 2,255sf | 0.22 mi | recent | ||
| 10 Clayton St | 2026-04-21 | $2.29M | $1,695,000 | $590,000 above asking (34.8%) | $2.31M | $1,332 | 3bd 3ba 1,735sf | 0.60 mi | similar size, 3 bd | ||
| 642 Clayton St | 2026-07-09 | $1.25M | $1,149,000 | $101,000 above asking (8.8%) | $1.32M | $874 | 3bd 2ba 1,508sf | 0.26 mi | similar size, 3 bd | ||
| 229 Ashbury St | 2026-03-17 | $1.75M | $1,349,000 | $401,229 above asking (29.7%) | $1.81M | $1,311 | 3bd 2ba 1,379sf | 0.50 mi | 3 bd | ||
| 536 Roosevelt Way | 2026-09-14 | $2.3M | $1,795,000 | $505,000 above asking (28.1%) | $2.3M | $1,336 | 3bd 3ba 1,722sf | 0.48 mi | similar size, 3 bd, recent | ||
| 2168 Grove St | 2026-05-15 | $1.88M | $1,695,000 | $181,000 above asking (10.7%) | $1.92M | $1,081 | 2bd 2ba 1,779sf | 0.52 mi | similar size | ||
| 1750 Page St | 2026-02-18 | $1.65M | $1,295,000 | $355,000 above asking (27.4%) | $1.77M | $1,362 | 2bd 1ba 1,298sf | 0.31 mi | |||
| 98 Caselli Ave | 2026-04-17 | $1.3M | $1,400,000 | $100,000 below asking (7.1%) | $1.31M | $747 | 3bd 2ba 1,760sf | 0.74 mi | similar size, 3 bd | ||
| 661 Frederick St | 2026-08-18 | $1.3M | No asking price | — | $1.35M | $918 | 4bd 3ba 1,472sf | 0.25 mi | same street, recent | ||
| 1623 Hayes St | 2026-08-31 | $1.88M | $1,295,000 | $580,000 above asking (44.8%) | $1.95M | $1,419 | 2bd 2ba 1,373sf | 0.70 mi | recent | ||
| 60 Danvers St | 2026-06-18 | $1.75M | $1,699,000 | $51,000 above asking (3.0%) | $1.82M | $1,148 | 3bd 2ba 1,588sf | 0.61 mi | similar size, 3 bd | ||
| 1751 Page St | 2026-02-20 | $1.81M | $1,550,000 | $265,000 above asking (17.1%) | $1.95M | $1,511 | 2bd 2ba 1,287sf | 0.29 mi | |||
| 1327 Cole St | 2026-04-20 | $2.05M | $1,395,000 | $655,000 above asking (47.0%) | $2.07M | $1,622 | 2bd 2ba 1,278sf | 0.35 mi | |||
| 321 Parnassus Ave | 2026-07-06 | $1.27M | $1,299,000 cut from $1.35M | $29,000 below asking (2.2%) | $1.34M | $1,196 | 2bd 1ba 1,120sf | 0.26 mi | |||
| 1860 Grove St | 2025-12-15 | $1.6M | $1,295,000 | $306,000 above asking (23.6%) | $1.85M | $1,146 | 2bd 2ba 1,611sf | 0.62 mi | similar size | ||
| 245 Central Ave | 2026-10-07 | $1.37M | $1,095,000 | $278,000 above asking (25.4%) | $1.34M | $1,151 | 3bd 2ba 1,160sf | 0.55 mi | 3 bd, recent | ||
| 2172 Fell St | 2026-06-10 | $2.7M | $1,895,000 | $805,000 above asking (42.5%) | $2.81M | $1,664 | 3bd 2ba 1,690sf | 0.39 mi | similar size, 3 bd | ||
| 238 Downey St | 2025-10-29 | $1.7M | $1,595,000 | $100,000 above asking (6.3%) | $1.92M | $1,474 | 2bd 2ba 1,301sf | 0.32 mi | |||
| 1731 Grove St | 2026-05-29 | $2.05M | $1,425,000 | $625,000 above asking (43.9%) | $2.1M | $1,512 | 2bd 2ba 1,390sf | 0.67 mi | |||
| 1740 Fell St | 2026-03-11 | $500K | No asking price | — | $516K | $383 | 2bd 1ba 1,350sf | 0.52 mi | |||
| 15 Piedmont St | 2025-10-28 | $1.85M | $1,650,000 | $205,000 above asking (12.4%) | $2.1M | $1,589 | 3bd 2ba 1,321sf | 0.40 mi | 3 bd | ||
| 527 Lincoln Way | 2026-05-29 | $1.95M | $1,200,000 | $750,000 above asking (62.5%) | $2M | $1,481 | 2bd 2ba 1,350sf | 0.65 mi | |||
| 873 Ashbury St | 2026-10-05 | $1.87M | $1,195,000 | $675,000 above asking (56.5%) | $1.82M | $1,792 | 2bd 1ba 1,015sf | 0.30 mi | recent | ||
| 222 States St | 2026-03-26 | $2.1M | $1,795,000 | $310,000 above asking (17.3%) | $2.17M | $1,554 | 2bd 2ba 1,399sf | 0.66 mi | |||
| 1588 Waller St | 2026-04-01 | $1.32M | $1,075,000 | $245,000 above asking (22.8%) | $1.34M | $1,230 | 2bd 1ba 1,085sf | 0.16 mi | |||
| 4754 17th St | 2026-06-08 | $2.77M | $2,150,000 | $625,000 above asking (29.1%) | $2.89M | $1,260 | 4bd 2ba 2,294sf | 0.38 mi | |||
| 415 Ashbury St | 2026-06-03 | $1.65M | $1,395,000 | $254,375 above asking (18.2%) | $1.72M | $1,322 | 2bd 2ba 1,300sf | 0.41 mi | |||
| 2276 Fulton St | 2025-11-26 | $1.7M | $1,699,000 | At asking | $1.92M | $972 | 3bd 3ba 1,979sf | 0.59 mi | 3 bd | ||
| 2811 Golden Gate Ave | 2026-10-05 | $1.9M | $1,595,000 | $305,000 above asking (19.1%) | $1.85M | $1,373 | 3bd 2ba 1,346sf | 0.71 mi | 3 bd, recent | ||
| 204 Grattan St | 2026-06-12 | $1.63M | $1,395,000 | $235,000 above asking (16.8%) | $1.7M | $1,637 | 2bd 1ba 1,037sf | 0.20 mi | |||
| 2062 Grove St | 2026-07-16 | $1.55M | $1,195,000 | $355,000 above asking (29.7%) | $1.63M | $1,409 | 2bd 2ba 1,160sf | 0.54 mi | |||
| 33 Ashbury St | 2026-01-06 | $1.28M | No asking price | — | $1.47M | $1,036 | 2bd 2ba 1,419sf | 0.61 mi | |||
| 1667 Grove St | 2026-05-13 | $1.8M | $1,295,000 | $505,000 above asking (39.0%) | $1.85M | $1,465 | 2bd 1ba 1,260sf | 0.72 mi | |||
| 740 Masonic Ave | 2026-06-05 | $1.4M | $1,395,000 | At asking | $1.45M | $1,191 | 2bd 2ba 1,220sf | 0.61 mi | |||
| 1727 Grove St | 2026-09-18 | $1.7M | $1,295,000 | $405,000 above asking (31.3%) | $1.7M | $1,459 | 2bd 2ba 1,165sf | 0.67 mi | recent | ||
| 3043 Market St | 2026-09-15 | $852K | No asking price | — | $852K | $759 | 2bd 1ba 1,122sf | 0.68 mi | recent | ||
| 2160 Hayes St #2 | 2026-04-27 | $3.4M | $2,349,000 | $1,051,000 above asking (44.7%) | $3.44M | $1,998 | 3bd 3ba 1,721sf | 0.45 mi | similar size, 3 bd | ||
| 227 States St | 2026-06-16 | $2.5M | $1,995,000 | $505,000 above asking (25.3%) | $2.6M | $1,583 | 2bd 3ba 1,645sf | 0.66 mi | similar size | ||
| 4901 17th St | 2026-04-23 | $1.8M | $1,395,000 | $405,000 above asking (29.0%) | $1.82M | $1,527 | 2bd 1ba 1,192sf | 0.37 mi | |||
| 40 Levant St | 2026-06-29 | $1.82M | $1,595,000 | $230,000 above asking (14.4%) | $1.9M | $1,518 | 3bd 2ba 1,252sf | 0.54 mi | 3 bd | ||
| 117 Ashbury St | 2025-12-08 | $2.65M | No asking price | — | $3.06M | $1,439 | 3bd 2ba 2,123sf | 0.56 mi | 3 bd | ||
| 4322 17th St #A | 2026-01-28 | $1.82M | $1,549,000 | $271,000 above asking (17.5%) | $2.09M | $1,313 | 3bd 3ba 1,589sf | 0.66 mi | similar size, 3 bd | ||
| 1729 Grove St | 2025-11-10 | $1.75M | No asking price | — | $1.99M | $1,390 | 3bd 2ba 1,429sf | 0.67 mi | 3 bd | ||
| 652 Parnassus Ave | 2025-11-12 | $1.43M | $1,295,000 | $130,000 above asking (10.0%) | $1.61M | $1,260 | 2bd 2ba 1,280sf | 0.55 mi | |||
| 1773 Grove St | 2026-02-27 | $1.02M | No asking price | — | $1.1M | $889 | 2bd 1ba 1,236sf | 0.65 mi | |||
| 142 Beulah St | 2025-11-12 | $1.2M | $1,095,000 | $105,000 above asking (9.6%) | $1.36M | $1,390 | 2bd 1ba 977sf | 0.07 mi | |||
| 1858 Grove St | 2025-11-12 | $2.1M | $1,495,000 | $605,000 above asking (40.5%) | $2.38M | $1,160 | 2bd 2ba 2,049sf | 0.62 mi | |||
| 2686 McAllister St #2 | 2026-06-02 | $2.2M | $1,895,000 | $305,000 above asking (16.1%) | $2.29M | $1,241 | 3bd 3ba 1,846sf | 0.67 mi | 3 bd | ||
| 1780 Hayes St | 2026-02-05 | $1.38M | No asking price | — | $1.47M | $1,158 | 1bd 1ba 1,272sf | 0.62 mi | |||
| 1260 Haight St APT 4 | 2026-09-10 | $1.52M | $1,295,000 | $230,000 above asking (17.8%) | $1.52M | $1,508 | 2bd 1ba 1,011sf | 0.56 mi | recent | ||
| 420 Stanyan St APT 8 | 2025-10-30 | $1.68M | $1,495,000 | $185,000 above asking (12.4%) | $1.9M | $1,250 | 3bd 2ba 1,520sf | 0.55 mi | similar size, 3 bd | ||
| 39 Douglass St | 2026-05-18 | $1.25M | $1,045,000 | $205,000 above asking (19.6%) | $1.28M | $1,196 | 2bd 1ba 1,072sf | 0.73 mi | |||
| 1460 Clayton Street | 2026-07-06 | $1.65M | $1,677,888 | $27,888 below asking (1.7%) | $1.74M | $768 | 3bd 3ba 2,265sf | 0.67 mi | 3 bd | ||
| 4660 18th St | 2025-12-03 | $2.4M | $2,499,000 | $99,000 below asking (4.0%) | $2.77M | $1,203 | 4bd 4ba 2,300sf | 0.66 mi | |||
| 158 Carmel St | 2026-04-22 | $1.5M | $1,299,000 | $201,000 above asking (15.5%) | $1.52M | $1,688 | 2bd 1ba 899sf | 0.41 mi | |||
| 136 Saturn St | 2026-04-13 | $1.48M | $1,175,000 | $305,000 above asking (26.0%) | $1.5M | $1,632 | 2bd 1ba 917sf | 0.53 mi | |||
| 1 Baker St APT 4B | 2025-11-12 | $1.15M | $1,149,000 | At asking | $1.3M | $973 | 2bd 2ba 1,337sf | 0.68 mi | |||
| 450 Carl St | 2026-05-13 | $1M | $1,000,000 | At asking | $1.03M | $1,077 | 2bd 2ba 952sf | 0.30 mi | |||
| 2838 Golden Gate Ave | 2025-11-10 | $1.9M | $1,795,000 | $105,000 above asking (5.8%) | $2.15M | $884 | 5bd 2ba 2,432sf | 0.74 mi | |||
| 2090 Fell St | 2026-02-06 | $1.31M | $1,199,000 | $113,000 above asking (9.4%) | $1.41M | $1,339 | 2bd 2ba 1,050sf | 0.39 mi | |||
| 468 Corbett Ave | 2026-04-13 | $1.38M | $1,095,000 | $285,000 above asking (26.0%) | $1.4M | $1,439 | 2bd 1ba 970sf | 0.72 mi | |||
| 3258 Market St APT 4 | 2026-08-11 | $1.23M | $995,000 | $230,000 above asking (23.1%) | $1.27M | $1,418 | 2bd 2ba 898sf | 0.67 mi | recent | ||
| 42 Ord St | 2026-04-17 | $4.1M | $2,795,000 | $1,305,000 above asking (46.7%) | $4.15M | $1,679 | 3bd 4ba 2,470sf | 0.67 mi | 3 bd | ||
| 847 Arguello Blvd APT 1 | 2026-09-11 | $1.41M | $998,000 | $411,000 above asking (41.2%) | $1.41M | $1,502 | 2bd 2ba 938sf | 0.68 mi | recent | ||
| 847 Arguello Blvd APT 5 | 2026-02-06 | $1.32M | $999,000 | $326,000 above asking (32.6%) | $1.42M | $1,514 | 2bd 2ba 938sf | 0.68 mi | |||
| 555 Irving St #1 | 2025-11-10 | $1.13M | No asking price | — | $1.27M | $1,213 | 2bd 2ba 1,050sf | 0.68 mi |
This home's sale history
- 2021-09-09: $2,000,000 (price inferred from public records, high confidence)