Saved query 666930e2acfb2bbf

Data Explorer

Query the US Nationwide Parcel Dataset

$1.75 / 1,000 records$100 minimum

41/80

Live SQL

SELECT * 
FROM "lr_parcel_us" 
WHERE statefp = '06' 
  AND countyfp = '001'

488,791 matching parcels

Data Preview

parcelid	statefp	countyfp	parceladdr	parcelcity	parcelstate	parcelzip	owneraddr	ownercity	ownerzip	countyname	cousubfp	cousubname	tractce	tractname	calcarea	imprvalue	landvalue	agvalue	totalvalue	numbldgs	numunits	firmid	firmdate	fldzone	zonesubty	elevmin	elevmax	elevavg	usecode	book	page	placename	placetype	lrversion
66-2762-293	06	001	555 PIERCE ST UNIT 633	ALBANY	CA	94706	555 PIERCE ST 633 ALBANY CA 947…	ALBANY CA	94706	ALAMEDA	90200	BERKELEY	420301	4203.0100	29608.6823	331936	138258	-7000	484194	1	1	06001C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	10.7802	87.1752	35.9189	7300	66	2761	BEACON HOME CARE	MEDICAL_SERVICE	2026.2
56-1985-15	06	001	2148 CURTIS ST	BERKELEY	CA	94702	2144 CURTIS ST BERKELEY CA 94702	BERKELEY CA	94702	ALAMEDA	90200	BERKELEY	423100	4231	370.5821	1028198	440372	-7000	1482570	1	1	06001C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	20.0791	20.6401	20.4111	2200	56	1985			2026.2
52-1564-43	06	001	2730 WEBSTER ST	BERKELEY	CA	94705	P.O. BOX 1713 EL GRANADA CA 940…	EL GRANADA CA	94018	ALAMEDA	90200	BERKELEY	423800	4238	675.5503	443625	177388	-7000	635013	1	1	06001C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	75.1994	76.4159	75.7716	2300	52	1564			2026.2
48H-7654-40	06	001	1084 SILER PL	OAKLAND	CA	94705	1084 SILER PL OAKLAND CA 94705	OAKLAND CA	94705	ALAMEDA	92230	OAKLAND	400100	4001	561.6788	479760	126893	-7000	620653	1	1	06001C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	243.7542	263.1850	253.1133	1100	48H	7654			2026.2
58-2141-4	06	001	1342 FRANCISCO ST	BERKELEY	CA	94702	1342 FRANCISCO ST BERKELEY CA 9…	BERKELEY CA	94702	ALAMEDA	90200	BERKELEY	422200	4222	538.9713	24628	26834	-7000	65462	1	1	06001C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	26.7941	27.8018	27.4391	1100	58	2141			2026.2
66-2755-87	06	001	923 HILLSIDE AVE	ALBANY	CA	94706	923 HILLSIDE AVE ALBANY CA 94706	ALBANY CA	94706	ALAMEDA	90200	BERKELEY	420301	4203.0100	3281.4609	536304	225844	-7000	776148	1	1	06001C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	41.5306	63.9869	50.4402	7305	66	2755			2026.2
59-2250-18-1	06	001	1568 EUCLID AVE	BERKELEY	CA	94708	1568 EUCLID AVE BERKELEY CA 947…	BERKELEY CA	94708	ALAMEDA	90200	BERKELEY	421600	4216	189.4283	50798	198467		249265	1	1	06001C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	127.8079	131.6733	129.7703	1100	59	2250			2026.2
70-170-17-5	06	001	2501 CENTRAL AVE	ALAMEDA	CA	94501	2501 CENTRAL AVE ALAMEDA CA 945…	ALAMEDA CA	94501	ALAMEDA	90020	ALAMEDA	428100	4281	911.5555	776455	615058		1391513	1	1	06001C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD				9301	70	170	PARK CENTRE ANIMAL HOSPITAL	ANIMAL_OR_PET_SERVICE	2026.2
59-2265-23	06	001	1425 MILVIA ST	BERKELEY	CA	94709	1425 MILVIA ST BERKELEY CA 94709	BERKELEY CA	94709	ALAMEDA	90200	BERKELEY	421700	4217	398.8342	2221520	948080	-7000	3183600	1	1	06001C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	71.7508	74.6401	73.4415	1100	59	2265			2026.2
519-1246-23	06	001	46864 FERNALD CM FREMONT	FREMONT	CA	94539	1849 KILOWATT WAY 301 FREMONT C…	FREMONT CA	94539	ALAMEDA	91070	FREMONT	443321	4433.2100	3166.6815	74520	57759		132279	1	1	06001C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	25.1564	28.9194	27.1165	7300	519	1246			2026.2
48G-7433-21-2	06	001	6738 PINEHAVEN RD	OAKLAND	CA	94611	6738 PINEHAVEN RD OAKLAND CA 94…	OAKLAND CA	94611	ALAMEDA	92230	OAKLAND	404400	4044	1203.9544	1341392	148106	-7000	1503498	1	1	06001C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD				1100	48G	7433			2026.2
946-4539-70-1	06	001	6081 VIA DE LOS CERROS	PLEASANTON	CA	94566	6081 VIA DE LOS CERROS PLEASANT…	PLEASANTON CA	94566	ALAMEDA	91660	LIVERMORE-PLEASANTON	450606	4506.0600	506.2106	379160	158374	-7000	551534	1	1	06001C	2026-01-20	X	0.2 PCT ANNUAL CHANCE FLOOD HAZ…				1100	946	4539			2026.2
941-2776-60-3	06	001	11510 VISTA PL	DUBLIN	CA	94568	11510 VISTA PL DUBLIN CA 94568	DUBLIN CA	94568	ALAMEDA	91660	LIVERMORE-PLEASANTON	450502	4505.0200	1136.3659	719493	304354	-7000	1037847	1	1	06001C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD				1100	941	2776			2026.2
48F-7372-59-3	06	001	1832 GOULDIN RD	OAKLAND	CA	94611	1832 GOULDIN RD OAKLAND CA 94611	OAKLAND CA	94611	ALAMEDA	92230	OAKLAND	404502	4045.0200	1287.3555	712809	301489	-7000	1028298	1	1	06001C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD				1100	48F	7372			2026.2
8-696-7	06	001	1 LAKESIDE DR UNIT 411	OAKLAND	CA	94612	1 LAKESIDE DR 411 OAKLAND CA 94…	OAKLAND CA	94612	ALAMEDA	92230	OAKLAND	403401	4034.0100	3992.1140	374500	156500	-7000	545000	1	1	06001C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD				7300	8	693	SMART HANDS AND MINDS	TUTORING_SERVICE	2026.2
92-119-35	06	001	8278 JUNIPER AVE	NEWARK	CA	94560	8278 JUNIPER AVE NEWARK CA 94560	NEWARK CA	94560	ALAMEDA	91070	FREMONT	444304	4443.0400	615.4815	688800	291200	-7000	994000	1	1	06001C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD				1100	92	119			2026.2
30-1929-1	06	001	3733 MAYBELLE AVE	OAKLAND	CA	94619	3733 MAYBELLE AVE OAKLAND CA 94…	OAKLAND CA	94619	ALAMEDA	92230	OAKLAND	406900	4069	1303.1637	21539	118484	-7000	154023	1	1	06001C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD				1100	30	1929			2026.2
48-6431-15	06	001	270 ELYSIAN FIELDS DR	OAKLAND	CA	94605	270 ELYSIAN FIELDS DR OAKLAND C…	OAKLAND CA	94605	ALAMEDA	92230	OAKLAND	409900	4099	889.3120	452514	179732	-7000	646246	1	1	06001C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD				1100	48	6431			2026.2
80A-206-9	06	001	16557 HANNAH DR	CASTRO VALLEY	CA	94578	16557 HANNAH DR CASTRO VALLEY C…	CASTRO VALLEY CA	94578	ALAMEDA	91260	HAYWARD	430500	4305	404.6333	117603	155501	-7000	287104	1	1	06001C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD				1100	80A	206			2026.2
11-869-22	06	001	772 SANTA RAY AVE	OAKLAND	CA	94610	772 SANTA RAY AVE OAKLAND CA 94…	OAKLAND CA	94610	ALAMEDA	92230	OAKLAND	405100	4051	448.1338	28550	27570	-7000	70120	1	1	06001C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD				1100	11	869			2026.2
985-85-18	06	001	2613 DUCALE CT	DUBLIN	CA	94568	2613 DUCALE CT DUBLIN CA 94568	DUBLIN CA	94568	ALAMEDA	91660	LIVERMORE-PLEASANTON	450751	4507.5100	1207.6288	782163	331212	-7000	1127375	1	1	06001C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD				1800	985	85			2026.2
501-1535-1	06	001	38122 HOLLAND AVE FREMONT	FREMONT	CA	94536	38122 HOLLAND AVE FREMONT CA 94…	FREMONT CA	94536	ALAMEDA	91070	FREMONT	441800	4418	575.3514	196952	128968	-7000	339920	1	1	06001C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD				1100	501	1535			2026.2
83-462-39	06	001	1064 SILVER MAPLE LN	HAYWARD	CA	94544	1064 SILVER MAPLE LN HAYWARD CA…	HAYWARD CA	94544	ALAMEDA	91260	HAYWARD	435104	4351.0400	2355.2426	756430	242251	-7000	1012681	1	1	06001C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD				1100	83	462			2026.2
941-186-58	06	001	8557 BRIARWOOD LN	DUBLIN	CA	94568	8557 BRIARWOOD LN DUBLIN CA 945…	DUBLIN CA	94568	ALAMEDA	91660	LIVERMORE-PLEASANTON	450400	4504	653.7384	55030	16537	-7000	85567	1	1	06001C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD				1100	941	186			2026.2
84C-669-110	06	001	4119 VERONICA AVE	CASTRO VALLEY	CA	94546	4119 VERONICA AVE CASTRO VALLEY…	CASTRO VALLEY CA	94546	ALAMEDA	91260	HAYWARD	430800	4308	453.0741	652193	275511	-7000	941704	1	1	06001C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD				1100	84C	669			2026.2