Saved query a869c3d101ec2cf1

Data Explorer

Query the US Nationwide Parcel Dataset

$1.75 / 1,000 records$100 minimum

0/80

Live SQL

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

489,609 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	saledate	numbldgs	numunits	yearbuilt	numfloors	bldgsqft	bedrooms	halfbaths	fullbaths	firmid	firmdate	fldzone	zonesubty	elevmin	elevmax	elevavg	usecode	usedesc	zoningcode	zoningdesc	taxacres	ownertype	naicscode	book	page	parceltype	accesstype	iucnclass	placename	placetype	fireplaces	taxyear	taxdistrict
20907042	209070420000	06	001	20124 W GRANT LINE RD MOUNTAIN …	MOUNTAIN HOUSE	CA	95391	SALEH HAROON & KOCHY	20124 WEST GRANTLINE RD TRACY C…	TRACY	CA	95391	Alameda	91660	Livermore-Pleasanton	451104	4511.0400	23656.2086	221791	1528139				1	1	2007	1	2596	4	0	2	06077C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	47.5679	59.1842	51.9929	51				5.7000	PERSON		209	07						1	2026	092002
20907036	209070360000	06	001	20098 W GRANT LINE RD MOUNTAIN …	MOUNTAIN HOUSE	CA	95391	RAMIREZ, JOSE J & MARIA E	20098 W GRANT LINE RD TRACY CA …	TRACY	CA	95391-8842	Alameda	91660	Livermore-Pleasanton	451104	4511.0400	2374.6587	165729	94699				1	1	2006	1	1620	3	0	2	06077C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	46.7890	48.7095	47.5187	51				0.5900	PERSON		209	07						0	2026	092002
20907037	209070370000	06	001	20080 W GRANT LINE RD MOUNTAIN …	MOUNTAIN HOUSE	CA	95391	HERNANDEZ, DAVID R TR	20058 W GRANT LINE RD MOUNTAIN …	MOUNTAIN HOUSE	CA	95391-8842	Alameda	91660	Livermore-Pleasanton	451104	4511.0400	1557.2034	80381	111502				1	1	1994	1	1317	3	0	2	06077C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	46.7781	48.8685	47.5269	51				0.3800	TRUST		209	07						0	2026	092002
20907053	209070530000	06	001	20088 W GRANT LINE RD MOUNTAIN …	MOUNTAIN HOUSE	CA	95391	BABEL, KEN	20088 W GRANT LINE RD TRACY CA …	TRACY	CA	95391-8842	Alameda	91660	Livermore-Pleasanton	451104	4511.0400	3985.2655	369189	147972				1	1	1977	1	2625	4	1	2	06077C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	46.8503	49.6780	48.0548	51				0.9800	PERSON		209	07						1	2026	092002
20907041	209070410000	06	001	20112 W GRANT LINE RD MOUNTAIN …	MOUNTAIN HOUSE	CA	95391	GORDON GREER SHARON TR ETAL	6430 HAZEL AVE RICHMOND CA 94805	RICHMOND	CA	94805	Alameda	91660	Livermore-Pleasanton	451104	4511.0400	1551.9170	36328	3411				1	1	1988	1	1040	2	0	2	06077C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	47.8233	50.5073	49.2660	10				0.3700	PERSON		209	07						0	2026	092002
20907040	209070400000	06	001	20100 W GRANT LINE RD MOUNTAIN …	MOUNTAIN HOUSE	CA	95391	CASTRO ISMAEL & NORMA	20100 W GRANT LINE RD TRACY CA …	TRACY	CA	95391	Alameda	91660	Livermore-Pleasanton	451104	4511.0400	3648.6247	467120	223101				1	1	1977	1	1848	4	0	2	06077C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	48.1832	51.8315	50.1177	10				0.8500	PERSON		209	07						1	2026	092002
504226019		06	001	POMONA AVE	EL CERRITO	CA	94530	MCQUISTON RYAN FRANCES	500 POMONA AVE	ALBANY	CA	94706-1427	Alameda	90200	Berkeley	420100	4201	10.4585	-49	49	-49	147	2016-04-22	1	0			0			0	06001C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	27.5125	27.7702	27.6534	89	Other; Split parcels in differe…	R-1	Residential Single Family		PERSON										2024
26313006	263130060000	06	001	15880 W CORRAL HOLLOW RD TRACY	TRACY	CA	95377	LESICO, DAVID M	124 ARROYO DR DANVILLE CA 94526	DANVILLE	CA	94526	Alameda	91660	Livermore-Pleasanton			262141.0581		16616									0	0	0	06001C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	810.4030	938.6817	894.0891	510				66.8600	PERSON		263	13							2026	088001
273220003		06	001	2215 0 MANZANITA DR	ORINDA	CA	94563	SMITH GERALD J TRE	2215 MANZANITA DR	OAKLAND	CA	94611-1135	Alameda	92230	Oakland			238.7655	-71751	71751	-71751	231825	2019-07-25	1	0			0			0	06013C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD				89	Other; Split parcels in differe…	A-2	General Agricultural		PERSON										2024
265190011		06	001	5200 GRIZZLY PEAK BOULEVARD	ORNDA	CA	94563		21C ORINDA WAY 272	ORINDA CA		94563	Alameda	92230	Oakland	404400	4044	204.1468		1075				0	0			0			0	06013C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	405.9407	410.3909	408.3932	10						7212			GOVT LOCAL	OPEN		GRIZZLY PEAK OPEN SPACE	LOCAL PARK
265190009		06	001	5190 GRIZZLY PEAK BOULEVARD	ORNDA	CA	94563		GRIZZLY PEAK	ORINDA CA		94563	Alameda	92230	Oakland	404400	4044	21.2484		5384				0	0			0			0	06013C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	406.9501	408.9292	408.0025	10						7212			GOVT LOCAL	OPEN		GRIZZLY PEAK OPEN SPACE	LOCAL PARK
273212023		06	001	76 VILLANOVA DRIVE	ORNDA	CA	94563		PO BOX 933	LOTUS CA		95651	Alameda	92230	Oakland	404502	4045.0200	544.3475		2048				1	0			0			0	06001C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD				10						3211			GOVT SPECIAL DISTRICT	RESTRICTED	V	HUCKLEBERRY BOTANIC REGIONAL PR…	LOCAL CONSERVATION AREA
273171037		06	001	1 OBSERVATION PLACE	ORNDA	CA	94563		PO BOX 5381	OAKLAND CA		94605	Alameda	92230	Oakland			7488.3080		3518011				1	0			0			0	06013C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD				79						712190			GOVT SPECIAL DISTRICT	RESTRICTED	V	SIBLEY VOLCANIC REGIONAL PRESER…	LOCAL CONSERVATION AREA
504182034		06	001	CERRITO CREEK	ELCER	CA	94530		TALBOT	ALBANY CA		94706	Alameda	90200	Berkeley	420100	4201	395.1586		29515				1	0			0			0	06001C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	17.7286	19.5768	18.4375	79
504274011		06	001	501 POMONA AVENUE	ELCER	CA	94530		SEA VIEW	EL CERRITO CA		94530	Alameda	90200	Berkeley	420100	4201	6.0342		39				1	0			0			0	06001C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	28.6787	29.0998	28.8074	89
273220002		06	001	2211	ORNDA	CA	94563		MANZANITA	ORINDA CA		94563	Alameda	92230	Oakland	404502	4045.0200	117.4416		1123				1	0	0		0			0	06001C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD				89
001081028		06	001		BYRON	CA	94514		PO BOX 23440	OAKLAND CA		94623	Alameda	91660	Livermore-Pleasanton	451104	4511.0400	148.9745		1518103				0	0			0			0	06013C	2026-01-20	A		0.4090	2.2707	1.8342	79
001081028		06	001		BYRON	CA	94514		PO BOX 23440	OAKLAND CA		94623	Alameda	91660	Livermore-Pleasanton	451104	4511.0400	1579.7640		1518103				0	0			0			0	06013C	2026-01-20	A		0.3956	5.8703	2.0209	79
901-196-286		06	001	39821 CEDAR BLVD 107 NEWARK 94…	NEWARK	CA	94560						Alameda	91070	Fremont	444602	4446.0200	16603.2091	136061	54312	-7000	204373		1	1							06001C	2026-01-20	X	0.2 PCT ANNUAL CHANCE FLOOD HAZ…				7300						8134	901	191				MURIETA CLUBHOUSE	SOCIAL_OR_COMMUNITY_SERVICE
901-196-215		06	001	39887 CEDAR BLVD 148 NEWARK 94…	NEWARK	CA	94560						Alameda	91070	Fremont	444602	4446.0200	16603.2091	416858	174653	-7000	605511		1	1							06001C	2026-01-20	X	0.2 PCT ANNUAL CHANCE FLOOD HAZ…				7300						8134	901	191				MURIETA CLUBHOUSE	SOCIAL_OR_COMMUNITY_SERVICE
901-196-267		06	001	39843 CEDAR BLVD 326 NEWARK 94…	NEWARK	CA	94560						Alameda	91070	Fremont	444602	4446.0200	16603.2091	292053	121165	-7000	427218		1	1							06001C	2026-01-20	X	0.2 PCT ANNUAL CHANCE FLOOD HAZ…				7300						8134	901	191				MURIETA CLUBHOUSE	SOCIAL_OR_COMMUNITY_SERVICE
901-196-55		06	001	39997 CEDAR BLVD 150 NEWARK 94…	NEWARK	CA	94560						Alameda	91070	Fremont	444602	4446.0200	13308.8267	412007	171281	-7000	597288		1	1							06001C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD				7300						8114	901	191				OVERHEAD GARAGE DOOR AND GATES …	HOME_SERVICE
525-1651-91		06	001	3909 STEVENSON BLVD 8D FREMONT…	FREMONT	CA	94538						Alameda	91070	Fremont	441927	4419.2700	2910.0483	486123	204338	-7000	704461		1	1							06001C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD				7300						8121	525	1651				BARBER RICK GONZALEZ	PERSONAL_OR_BEAUTY_SERVICE
48H-7585-11		06	001	43 SPY GLASS HL OAKLAND 94618	OAKLAND	CA	94618						Alameda	92230	Oakland	400100	4001	16051.4017	291619	120979	-7000	426598		1	1							06001C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	253.1244	276.2198	259.7330	7300							48H	7585
519-1244-126		06	001	134 MOHAVE TER 9 FREMONT 94539	FREMONT	CA	94539						Alameda	91070	Fremont	443321	4433.2100	5432.9938	270998	112142	-7000	397140		1	1							06001C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	27.5496	30.8987	29.5799	7300							519	1244