Saved query b49657eebc9a7e27

Data Explorer

Query the US Nationwide Parcel Dataset

$1.75 / 1,000 records$100 minimum

45/80

Live SQL

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

253,286 matching parcels

Data Preview

parcelid	taxacctnum	statefp	countyfp	parceladdr	parcelcity	parcelstate	parcelzip	ownername	owneraddr	ownercity	ownerstate	ownerzip	countyname	cousubfp	cousubname	tractce	tractname	calcarea	numbldgs	firmid	firmdate	fldzone	zonesubty	staticbfe	elevmin	elevmax	elevavg	usecode	zoningcode	taxacres	ownertype	book	page	lrversion	taxdistrict
99A-2620-5-21		06	077	MINES RD	LIVERMORE	CA	94550		1618 FRANKFURT WAY LIVERMORE CA…	LIVERMORE CA		94550	SAN JOAQUIN	93400	TRACY	005502	55.0200	804.7570		06077C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD		831.1352	843.8047	836.5952	5500				99A	2620	2026.2
25156003	251560030000	06	077			CA		DRP SOLARIS MULTISTATE LLC	2603 CAMINO RAMON STE 525 SAN R…	SAN RAMON	CA	94583	SAN JOAQUIN	93400	TRACY	005502	55.0200	580.6603		06077C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD					6A		0.1400	BUSINESS	251	56	2026.2	004088
21327030	213270300000	06	077			CA		SBS FARMS LLC	4480 COVE CT TRACY CA 95377	TRACY	CA	95377	SAN JOAQUIN	93400	TRACY	005214	52.1400	76144.7786		06077C	2026-01-20	AE		24				400		17.4300	BUSINESS	213	27	2026.2	055001
08910034	089100340000	06	077			CA		SOLARI FAMILY 2002 LLC	PO BOX 788 LINDEN CA 95236	LINDEN	CA	95236	SAN JOAQUIN	93240	STOCKTON	003602	36.0200	15902.1911		06077C	2026-01-20	X	0.2 PCT ANNUAL CHANCE FLOOD HAZ…					400		3.9300	BUSINESS	089	10	2026.2	096059
00712030	007120300000	06	077			CA		CONNER TEDDY REX & ERMA TR	27550 N SOWLES RD GALT CA 95632	GALT	CA	95632	SAN JOAQUIN	91690	LOCKEFORD	004703	47.0300	8092.8600		06077C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD					51		2	TRUST	007	12	2026.2	109004
17130008	171300080000	06	077			CA		BPJ LLC	4931 CORA POST RD LODI CA 95240	LODI	CA	95240	SAN JOAQUIN	93240	STOCKTON	002100	21	10368.0567		06077C	2026-01-20	X	0.2 PCT ANNUAL CHANCE FLOOD HAZ…					302		2.4800	BUSINESS	171	30	2026.2	118061
21208015	212080150000	06	077			CA		JAUREGUI ANTONIO JR & JAUREGUI …	19814 W GRANT LINE RD TRACY CA …	TRACY	CA	95391	SAN JOAQUIN	93400	TRACY	005225	52.2500	38429.0553		06077C	2026-01-20	AE		13				451		9.4600	PERSON	212	08	2026.2	122004
24086008	240860080000	06	077			CA		ELLIS STORAGE LLC	1024 CENTRAL AVE TRACY CA 95376	TRACY	CA	95376	SAN JOAQUIN	93400	TRACY	005213	52.1300	4198.4787		06077C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD					6A		1.0400	BUSINESS	240	86	2026.2	004072
25403015	254030150000	06	077			CA		DRP SOLARIS CA 2 LLC	2603 CAMINO RAMON STE #525 SAN …	SAN RAMON	CA	94583	SAN JOAQUIN	93400	TRACY	005222	52.2200	7290.4784		06077C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD					101		1.8000	BUSINESS	254	03	2026.2	008005
05518026	055180260000	06	077			CA		BATTH KANWARJIT SINGH	PO BOX 28427 FRESNO CA 93729	FRESNO	CA	93729	SAN JOAQUIN	91700	LODI	004106	41.0600	40453.4896		06077C	2026-01-20	X	0.2 PCT ANNUAL CHANCE FLOOD HAZ…					450		10	PERSON	055	18	2026.2	099021
19131072	191310720000	06	077			CA		CALCAGNO ROBERT ETAL	226 HIGHLAND CT SANTA CRUZ CA 9…	SANTA CRUZ	CA	95060	SAN JOAQUIN	93240	STOCKTON	003803	38.0300	7623.6206		06077C	2026-01-20	X	AREA WITH REDUCED FLOOD RISK DU…					400		1.8900	PERSON	191	31	2026.2	102067
17518013	175180130000	06	077			CA		BOEGE MILTON G	P O BOX 28 FRENCH CAMP CA 95231	FRENCH CAMP	CA	95231	SAN JOAQUIN	93240	STOCKTON	003807	38.0700	17.9923		06077C	2026-01-20	AH		14				590		0.0100	PERSON	175	18	2026.2	003458
17746025	177460250000	06	077			CA		PREMIER TRAILERS LLC	5201 TENNYSON PKWY STE #250 PLA…	PLANO	TX	75024	SAN JOAQUIN	93240	STOCKTON	003803	38.0300	7627.2807		06077C	2026-01-20	AO						101		1.9300	BUSINESS	177	46	2026.2	003462
10101022	101010220000	06	077			CA		STOCKTON EAST WATER DISTRICT	6767 E MAIN ST STOCKTON CA 9521…	STOCKTON	CA	95215	SAN JOAQUIN	93240	STOCKTON	003601	36.0100	2972.2070		06077C	2026-01-20	A						810		0.3900	PERSON	101	01	2026.2	096096
18924010	189240100000	06	077			CA		BIANCHI DONALD L TR	1850 CHESTER DR TRACY CA 95376-…	TRACY	CA	95376	SAN JOAQUIN	93240	STOCKTON	003900	39	221.3314		06077C	2026-01-20	AE						590		0.6000	TRUST	189	24	2026.2	122024
21048052	210480520000	06	077			CA		LATHROP CITY OF	390 TOWNE CENTRE DR LATHROPO CA…	LATHROPO	CA	95330	SAN JOAQUIN	93400	TRACY	005214	52.1400	157.8703		06077C	2026-01-20	X	AREA WITH REDUCED FLOOD RISK DU…					6A		0.0400	GOVERNMENT	210	48	2026.2	007091
05139017	051390170000	06	077			CA		R LAWSON ENTERPRISES LLC	PO BOX 298 VICTOR CA 95253	VICTOR	CA	95253	SAN JOAQUIN	91700	LODI	004600	46	488.1560		06077C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD					323		0.1000	BUSINESS	051	39	2026.2	099001
21310054	213100540000	06	077			CA		JENSEN KERI ANN TR	5923 W DELTA AVE TRACY CA 95304	TRACY	CA	95304	SAN JOAQUIN	93400	TRACY	005214	52.1400	21.6474		06077C	2026-01-20	AE		22				451		0.0100	TRUST	213	10	2026.2	055001
16302037	163020370000	06	077			CA		STOCKTON CITY OF	CITY HALL STOCKTON CA 95202	STOCKTON	CA	95202	SAN JOAQUIN	93240	STOCKTON	000803	8.0300	88.2009		06077C	2026-01-20	X	AREA WITH REDUCED FLOOD RISK DU…					937		0.0200	GOVERNMENT	163	02	2026.2	003300
99A-2680-18		06	077	MINES RD	LIVERMORE	CA	94550		270 MONTEGO DR DANVILLE CA 94526	DANVILLE CA		94526	SAN JOAQUIN	93400	TRACY			36706.4393		06077C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD		946.3784	1005.9946	982.6863	5500				99A	2680	2026.2
10226065	102260650000	06	077			CA		STOCKTON CITY OF	CITY HALL STOCKTON CA 95202	STOCKTON	CA	95202	SAN JOAQUIN	93240	STOCKTON	003305	33.0500	43.5424		06077C	2026-01-20	X	0.2 PCT ANNUAL CHANCE FLOOD HAZ…					937			GOVERNMENT	102	26	2026.2	003458
21934419		06	077	251 WAWONA ST	MANTECA	CA	95337						SAN JOAQUIN	91870	MANTECA	005133	51.3300	548.9696	0	06077C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD		11.0636	11.6883	11.4870	0010	R1	0.1400		BK219	219-34	2026.2
21933706		06	077	505 PARK AVE	MANTECA	CA	95337						SAN JOAQUIN	91870	MANTECA	005133	51.3300	526.2506	0	06077C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD		9.5198	9.8354	9.6948	0010	R1	0.1300		BK219	219-33	2026.2
21726041		06	077	550 POPLAR AVE	MANTECA	CA	95336						SAN JOAQUIN	91870	MANTECA	005108	51.0800	689.6991	0	06077C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD		11.2652	11.5363	11.4368	0010	R1	0.1700		BK217	217-26	2026.2
21724020		06	077	329 POPLAR AVE	MANTECA	CA	95336						SAN JOAQUIN	91870	MANTECA	005108	51.0800	688.4235	0	06077C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD		11.0318	11.4080	11.2117	0022	R1	0.1400		BK217	217-24	2026.2