Data Explorer
Query the US Nationwide Parcel Dataset
Request Sample Download
$1.75 / 1,000 records$100 minimum
47/80
Live SQL
SELECT * FROM "parcel_layer" WHERE statefp = '06' AND countyfp = '075'
234,961 matching parcels
Data Preview
parcelid | taxacctnum | statefp | countyfp | parceladdr | parcelcity | parcelstate | parcelzip | ownername | owneraddr | ownercity | ownerstate | ownerzip | countyname | cousubfp | cousubname | tractce | tractname | calcarea | imprvalue | landvalue | agvalue | totalvalue | saleamt | saledate | numbldgs | numunits | yearbuilt | numfloors | bldgsqft | bedrooms | halfbaths | fullbaths | firmid | firmdate | fldzone | zonesubty | staticbfe | elevmin | elevmax | elevavg | usecode | usedesc | zoningcode | zoningdesc | taxacres | ownertype | naicscode | legaldesc | township | section | qtrsection | range | plssdesc | book | page | parceltype | accesstype | iucnclass | placename | placetype | fireplaces | heating | heatfuel | cooling | foundation | roofcover | siding | taxyear | taxdistrict | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7139003 | 06 | 075 | 2950-2998 SAN JOSE AVE | SAN FRANCISCO | CA | 94112 | PO BOX 1392 | BAKERSFIELD | CA | 93302-1392 | San Francisco | 91964 | Merced-McLaren | 031401 | 314.0100 | 771.6595 | 346503 | 346503 | 346503 | 0 | 2 | 060298 | 2026-01-20 | X | AREA OF MINIMAL FLOOD HAZARD | 91.0394 | 91.9182 | 91.5139 | NC-1-40-X | Neighborhood Commercial Cluster | BUSINESS | 445131 | EXTRAMILE | CONVENIENCE_STORE | ||||||||||||||||||||||||||||||||||||
| 5321024 | 06 | 075 | 1776 PALOU AVE | SAN FRANCISCO | CA | 94124-2333 | 1776 PALOU AVE | SAN FRANCISCO | CA | 94124-2333 | San Francisco | 90195 | Bayview | 061200 | 612 | 464.5392 | 320702 | 320702 | 320702 | 0 | 1991-07-01 | 1 | 1 | 060298 | 2026-01-20 | X | AREA OF MINIMAL FLOOD HAZARD | 22.6797 | 28.6461 | 25.4831 | RH-2-40-X | Residential House Two Family | PERSON | |||||||||||||||||||||||||||||||||||||
| 6913016 | 06 | 075 | 274 URBANO DR | SAN FRANCISCO | CA | 94127-2825 | 274 URBANO DR | SAN FRANCISCO | CA | 94127-2825 | San Francisco | 91964 | Merced-McLaren | 030900 | 309 | 559.4546 | 740361 | 740361 | 740361 | 0 | 2003-01-03 | 2 | 1 | 060298 | 2026-01-20 | X | AREA OF MINIMAL FLOOD HAZARD | 69.3200 | 73.4179 | 71.4313 | RH-1(D -40-X | Residential House One Family De… | PERSON | |||||||||||||||||||||||||||||||||||||
| 5889027 | 06 | 075 | 334 NEY ST | SAN FRANCISCO | CA | 94112-1647 | 334 NEY ST | SAN FRANCISCO | CA | 94112-1647 | San Francisco | 91964 | Merced-McLaren | 025600 | 256 | 507.8574 | 736012 | 736012 | 736012 | 0 | 2006-05-19 | 1 | 1 | 060298 | 2026-01-20 | X | AREA OF MINIMAL FLOOD HAZARD | 30.5042 | 38.1352 | 34.1179 | RH-1-40-X | Residential House One Family | TRUST | |||||||||||||||||||||||||||||||||||||
| 1511044 | 06 | 075 | 6939 GEARY BLVD | SAN FRANCISCO | CA | 94121 | 1345 25TH AVE | SAN FRANCISCO | CA | 94122-1524 | San Francisco | 92605 | Richmond-Presidio-Marina | 047802 | 478.0200 | 270.0140 | 1352520 | 1352520 | 1352520 | 0 | 2021-08-13 | 1 | 3 | 060298 | 2026-01-20 | X | AREA OF MINIMAL FLOOD HAZARD | 75.2850 | 76.2545 | 75.7374 | RM-2-40-X | Residential Mixed Moderate Dens… | TRUST | |||||||||||||||||||||||||||||||||||||
| 0130006 | 06 | 075 | 23 CARD ALY | SAN FRANCISCO | CA | 94133 | 23 CARD AL A | SAN FRANCISCO | CA | 94133 | San Francisco | 90734 | Downtown-Northeast Neighborhood… | 010702 | 107.0200 | 102.6278 | 905438 | 905438 | 905438 | 0 | 2012-08-02 | 1 | 3 | 060298 | 2026-01-20 | X | AREA OF MINIMAL FLOOD HAZARD | 30.0135 | 30.6584 | 30.2493 | NCD-NORTH-BEACH-40-X | North Beach Neighborhood Commer… | PERSON | |||||||||||||||||||||||||||||||||||||
| 5378024 | 06 | 075 | 82 WATERVILLE ST | SAN FRANCISCO | CA | 94124-1920 | 82 WATERVILLE ST | SAN FRANCISCO | CA | 94124-1920 | San Francisco | 90195 | Bayview | 023001 | 230.0100 | 226.9678 | 375357 | 375357 | 375357 | 0 | 1994-07-19 | 1 | 1 | 060298 | 2026-01-20 | X | AREA OF MINIMAL FLOOD HAZARD | 32.8526 | 33.6824 | 33.1867 | RH-1-40-X | Residential House One Family | PERSON | |||||||||||||||||||||||||||||||||||||
| 1788009A | 06 | 075 | 1351 33RD AVE | SAN FRANCISCO | CA | 94122-1304 | 1351 33RD AVE | SAN FRANCISCO | CA | 94122-1304 | San Francisco | 93267 | Sunset | 032700 | 327 | 278.7430 | 1664640 | 1664640 | 1664640 | 0 | 2021-12-06 | 1 | 1 | 060298 | 2026-01-20 | X | AREA OF MINIMAL FLOOD HAZARD | 62.6091 | 64.1119 | 63.3822 | RH-2-40-X | Residential House Two Family | PERSON | |||||||||||||||||||||||||||||||||||||
| 2188031 | 06 | 075 | 2178 30TH AVE | SAN FRANCISCO | CA | 94116-1711 | 243 19TH AVE | SAN FRANCISCO | CA | 94121-2302 | San Francisco | 93267 | Sunset | 032901 | 329.0100 | 278.5160 | 1207731 | 1207731 | 1207731 | 0 | 2014-09-22 | 1 | 1 | 060298 | 2026-01-20 | X | AREA OF MINIMAL FLOOD HAZARD | 81.1398 | 88.2027 | 83.2175 | RH-1-40-X | Residential House One Family | TRUST | |||||||||||||||||||||||||||||||||||||
| 6633019 | 06 | 075 | 1727 CHURCH ST | SAN FRANCISCO | CA | 94131-2412 | 1727 CHURCH ST | SAN FRANCISCO | CA | 94131-2412 | San Francisco | 93625 | Western Addition-Buena Vista-Eu… | 021500 | 215 | 156.0915 | 518707 | 518707 | 518707 | 0 | 1994-11-30 | 1 | 1 | 060298 | 2026-01-20 | X | AREA OF MINIMAL FLOOD HAZARD | 38.4973 | 39.7872 | 38.9326 | NC-1-40-X | Neighborhood Commercial Cluster | TRUST | |||||||||||||||||||||||||||||||||||||
| 1816010 | 06 | 075 | 1451 37TH AVE | SAN FRANCISCO | CA | 94122-3125 | 1455 37TH AVE | SAN FRANCISCO | CA | 94122-3125 | San Francisco | 93267 | Sunset | 035101 | 351.0100 | 301.0859 | 1899556 | 1899556 | 1899556 | 0 | 2021-04-19 | 1 | 1 | 060298 | 2026-01-20 | X | AREA OF MINIMAL FLOOD HAZARD | 52.0213 | 52.6037 | 52.3256 | RH-1-40-X | Residential House One Family | TRUST | |||||||||||||||||||||||||||||||||||||
| 1381004 | 06 | 075 | 127 21ST AVE | SAN FRANCISCO | CA | 94121-1205 | 129 21ST AVE | SAN FRANCISCO | CA | 94121-1205 | San Francisco | 92605 | Richmond-Presidio-Marina | 042601 | 426.0100 | 278.7942 | 306869 | 306869 | 306869 | 0 | 2024-09-26 | 1 | 1 | 060298 | 2026-01-20 | X | AREA OF MINIMAL FLOOD HAZARD | 39.7511 | 41.1959 | 40.5635 | RH-2-40-X | Residential House Two Family | TRUST | |||||||||||||||||||||||||||||||||||||
| 2203044 | 06 | 075 | 2171 14TH AVE | SAN FRANCISCO | CA | 94116-1840 | 2171 14TH AVE | SAN FRANCISCO | CA | 94116-1840 | San Francisco | 93267 | Sunset | 030400 | 304 | 296.1467 | 2922364 | 2922364 | 2922364 | 0 | 2024-10-01 | 1 | 1 | 060298 | 2026-01-20 | X | AREA OF MINIMAL FLOOD HAZARD | 158.1265 | 170.9961 | 165.5742 | RH-1-40-X | Residential House One Family | TRUST | |||||||||||||||||||||||||||||||||||||
| 0655017 | 06 | 075 | 2434 PINE ST | SAN FRANCISCO | CA | 94115-2624 | 2418 PINE ST | SAN FRANCISCO | CA | 94115-2624 | San Francisco | 93625 | Western Addition-Buena Vista-Eu… | 015300 | 153 | 182.9434 | 443796 | 443796 | 443796 | 0 | 2017-06-28 | 1 | 1 | 060298 | 2026-01-20 | X | AREA OF MINIMAL FLOOD HAZARD | 44.6618 | 47.4953 | 46.3802 | RH-2-40-X | Residential House Two Family | PERSON | |||||||||||||||||||||||||||||||||||||
| 2968A033 | 06 | 075 | 364 MARIETTA DR | SAN FRANCISCO | CA | 94127-1846 | 364 MARIETTA DR | SAN FRANCISCO | CA | 94127-1846 | San Francisco | 91964 | Merced-McLaren | 030700 | 307 | 247.1373 | 90086 | 90086 | 90086 | 0 | 1993-11-12 | 1 | 1 | 060298 | 2026-01-20 | X | AREA OF MINIMAL FLOOD HAZARD | 172.8516 | 188.2256 | 178.1345 | RH-1-40-X | Residential House One Family | TRUST | |||||||||||||||||||||||||||||||||||||
| 6284012 | 06 | 075 | 624 LA GRANDE AVE | SAN FRANCISCO | CA | 94112-2837 | 624 LA GRANDE AVE | SAN FRANCISCO | CA | 94112-2837 | San Francisco | 91964 | Merced-McLaren | 026003 | 260.0299 | 312.3854 | 496713 | 496713 | 496713 | 0 | 1989-01-19 | 0 | 1 | 060298 | 2026-01-20 | X | AREA OF MINIMAL FLOOD HAZARD | 96.6490 | 99.0416 | 97.9674 | RH-1-40-X | Residential House One Family | PERSON | |||||||||||||||||||||||||||||||||||||
| 6605026 | 06 | 075 | 755 DUNCAN ST | SAN FRANCISCO | CA | 94131-1842 | 662 28TH ST | SAN FRANCISCO | CA | 94131-2116 | San Francisco | 93625 | Western Addition-Buena Vista-Eu… | 021600 | 216 | 268.6116 | 1912500 | 1912500 | 1912500 | 0 | 2022-09-02 | 1 | 1 | 060298 | 2026-01-20 | X | AREA OF MINIMAL FLOOD HAZARD | 144.6428 | 150.7708 | 147.8660 | RH-1-40-X | Residential House One Family | BUSINESS | |||||||||||||||||||||||||||||||||||||
| 2449043 | 06 | 075 | 2626-2628 GREAT HWY | SAN FRANCISCO | CA | 94116 | 25 BLOOMFIELD RD | BURLINGAME | CA | 94010-3012 | San Francisco | 93267 | Sunset | 035400 | 354 | 259.8031 | 1065231 | 1065231 | 1065231 | 0 | 2024-11-12 | 1 | 2 | 060298 | 2026-01-20 | X | AREA OF MINIMAL FLOOD HAZARD | 7.3984 | 7.7264 | 7.5448 | RH-2-40-X | Residential House Two Family | BUSINESS | |||||||||||||||||||||||||||||||||||||
| 4335001E | 06 | 075 | 1430-1432 YORK ST | SAN FRANCISCO | CA | 94110 | 1432 YORK ST | SAN FRANCISCO | CA | 94110-4823 | San Francisco | 91976 | Mission-Bernal | 022903 | 229.0300 | 232.2517 | 1018675 | 1018675 | 1018675 | 0 | 2013-08-14 | 1 | 2 | 060298 | 2026-01-20 | X | AREA OF MINIMAL FLOOD HAZARD | 10.9509 | 11.7773 | 11.2087 | RH-2-40-X | Residential House Two Family | PERSON | |||||||||||||||||||||||||||||||||||||
| 1615003 | 06 | 075 | 727 29TH AVE | SAN FRANCISCO | CA | 94121 | 755 29TH AVE | SAN FRANCISCO | CA | 94121-3515 | San Francisco | 92605 | Richmond-Presidio-Marina | 047801 | 478.0100 | 257.6362 | 1438199 | 1438199 | 1438199 | 0 | 2010-02-12 | 1 | 1 | 060298 | 2026-01-20 | X | AREA OF MINIMAL FLOOD HAZARD | 64.6408 | 68.6443 | 65.9679 | RH-2-40-X | Residential House Two Family | BUSINESS | |||||||||||||||||||||||||||||||||||||
| 6161025 | 06 | 075 | 996 SOMERSET ST | SAN FRANCISCO | CA | 94134-2156 | 996 SOMERSET ST | SAN FRANCISCO | CA | 94134-2156 | San Francisco | 91964 | Merced-McLaren | 025900 | 259 | 146.9094 | 801483 | 801483 | 801483 | 0 | 2004-06-11 | 1 | 1 | 060298 | 2026-01-20 | X | AREA OF MINIMAL FLOOD HAZARD | 100.3914 | 101.0046 | 100.6311 | RH-1-40-X | Residential House One Family | PERSON | |||||||||||||||||||||||||||||||||||||
| 6552005 | 06 | 075 | 1376 CHURCH ST | SAN FRANCISCO | CA | 94114-3949 | 1390 MARKET ST STE 200 | SAN FRANCISCO | CA | 94102 | San Francisco | 93625 | Western Addition-Buena Vista-Eu… | 021400 | 214 | 215.3020 | 3280935 | 3280935 | 3280935 | 0 | 2019-10-25 | 1 | 6 | 060298 | 2026-01-20 | X | AREA OF MINIMAL FLOOD HAZARD | 39.6614 | 42.9808 | 40.7890 | RH-2-40-X | Residential House Two Family | NONPROFIT | |||||||||||||||||||||||||||||||||||||
| 3613012 | 06 | 075 | 2916 22ND ST | SAN FRANCISCO | CA | 94110 | 3950 23RD ST | SAN FRANCISCO | CA | 94114-3303 | San Francisco | 91976 | Mission-Bernal | 022803 | 228.0300 | 220.6632 | 997161 | 997161 | 997161 | 0 | 2000-12-13 | 1 | 2 | 060298 | 2026-01-20 | X | AREA OF MINIMAL FLOOD HAZARD | 14.4001 | 15.9288 | 14.9281 | UMU-40-X | Urban Mixed Use | PERSON | |||||||||||||||||||||||||||||||||||||
| 6256003A | 06 | 075 | 36 REY ST | SAN FRANCISCO | CA | 94134-2739 | 36 REY ST | SAN FRANCISCO | CA | 94134-2739 | San Francisco | 91964 | Merced-McLaren | 026401 | 264.0100 | 271.2580 | 567970 | 567970 | 567970 | 0 | 2001-01-23 | 1 | 1 | 060298 | 2026-01-20 | X | AREA OF MINIMAL FLOOD HAZARD | 28.4139 | 31.3448 | 30.0436 | RH-1-40-X | Residential House One Family | PERSON | |||||||||||||||||||||||||||||||||||||
| 1134023 | 06 | 075 | 8 ROSSI AVE | SAN FRANCISCO | CA | 94118-4218 | 8 ROSSI AVE | SAN FRANCISCO | CA | 94118-4218 | San Francisco | 92605 | Richmond-Presidio-Marina | 015600 | 156 | 275.8048 | 579867 | 579867 | 579867 | 0 | 1995-06-10 | 2 | 1 | 060298 | 2026-01-20 | X | AREA OF MINIMAL FLOOD HAZARD | 71.6819 | 75.0318 | 72.2686 | RH-2-40-X | Residential House Two Family | TRUST |