Saved query 4edecf67d2ee8f09

Data Explorer

Query the US Nationwide Parcel Dataset

$1.75 / 1,000 records$100 minimum

43/80

Live SQL

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

62,049 matching parcels

Data Preview

parcelid	statefp	countyfp	parceladdr	parcelcity	parcelstate	parcelzip	ownername	owneraddr	ownercity	ownerstate	ownerzip	countyname	cousubfp	cousubname	tractce	tractname	calcarea	saledate	numbldgs	firmid	firmdate	fldzone	zonesubty	staticbfe	elevmin	elevmax	elevavg	usecode	usedesc	zoningcode	taxacres	ownertype	naicscode	legaldesc	book	page	parceltype	accesstype	iucnclass	placename	placetype	lrversion	taxdistrict
21523106	06	045			CA	95542	UNITED STATES OF AMERICA	1695 HEINDON RD	ARCATA	CA	95521	MENDOCINO	91580	LAYTONVILLE-LEGGETT	010200	102	23760.6012	2025-05-01	0	06045C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	-9999				80	PUBLIC LAND, SCHOOLS, NON TAXAB…	U	5.8700	GOVERNMENT		T 5S R 2E SEC 22	215	23	GOVT FEDERAL	RESTRICTED	OTHER			2026.2	2
03327108	06	045	779 ST HWY 101	GARBERVILLE	CA	95542	BOWMAN CONRAD K TRUDY L	779 HWY 101	PIERCY	CA	95587	MENDOCINO	91580	LAYTONVILLE-LEGGETT	010200	102	1617.9913	2025-05-01	0	06045C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	-9999				99	RURAL - VACANT	U	0.4000	PERSON			033	27						2026.2	2
03251010	06	045		NONE	CA							MENDOCINO	90610	COVELO	010100	101	40389.1970			06045C	2026-01-20	D		-9999	442.2086	469.2668	447.4109	06		UR	10			BOOK 032, PAGE 51, BLOCK 0, PAR…	032	51						2026.2	131014
03224029	06	045		NONE	CA							MENDOCINO	90610	COVELO	010100	101	34547.7936			06045C	2026-01-20	D		-9999	562.6710	649.2435	594.2740	00		PF	10			BOOK 032, PAGE 24, BLOCK 0, PAR…	032	24						2026.2	131003
03256004	06	045		NONE	CA							MENDOCINO	90610	COVELO	010100	101	123004.5114			06045C	2026-01-20	D		-9999	559.6587	632.5593	599.8751	54		RL	30			BOOK 032, PAGE 56, BLOCK 0, PAR…	032	56						2026.2	131013
03401049	06	045	75525 DOBIE LN	COVELO	CA							MENDOCINO	90610	COVELO	010100	101	87874.4078			06045C	2026-01-20	A		-9999	404.3726	409.3030	407.1884	43		AG	20			BOOK 034, PAGE 01, BLOCK 0, PAR…	034	01						2026.2	131012
03203033	06	045		NONE	CA							MENDOCINO	90610	COVELO	010100	101	265287.0531			06045C	2026-01-20	D		-9999	1003.6889	1073.6864	1038.4349	64		TP	60.2900			BOOK 032, PAGE 03, BLOCK 0, PAR…	032	03						2026.2	131013
04711014	06	045	2200 MCNAB RANCH RD		CA							MENDOCINO	93490	UKIAH	011300	113	3054.8757			06045C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	-9999	203.6777	207.3337	205.4417	00		UR	0			BOOK 047, PAGE 11, BLOCK 0, PAR…	047	11						2026.2	154144
03540003	06	045		NONE	CA							MENDOCINO	90610	COVELO	010100	101	146703.8486			06045C	2026-01-20	D		-9999	1051.6110	1234.4294	1141.6692	65		TP	40			BOOK 035, PAGE 40, BLOCK 0, PAR…	035	40						2026.2	131003
03221002	06	045		NONE	CA							MENDOCINO	90610	COVELO	010100	101	172481.8333			06045C	2026-01-20	D		-9999	1735.0915	1842.7825	1793.8723	64		TP	40			BOOK 032, PAGE 21, BLOCK 0, PAR…	032	21						2026.2	131013
03231043	06	045		NONE	CA							MENDOCINO	90610	COVELO	010100	101	168285.5608			06045C	2026-01-20	D		-9999	1126.7817	1282.1944	1207.4666	54		RL	40			BOOK 032, PAGE 31, BLOCK 0, PAR…	032	31						2026.2	131003
05057012	06	045		NONE	CA							MENDOCINO	91330	HOPLAND	011800	118	22718.4314			06045C	2026-01-20	D		-9999	254.3726	341.8098	283.9379	06		RL	5.7000			BOOK 050, PAGE 57, BLOCK 0, PAR…	050	57						2026.2	154148
03114022	06	045		NONE	CA							MENDOCINO	90610	COVELO	010100	101	328621.2165			06045C	2026-01-20	D		-9999	679.6573	911.3343	796.6051	54		RL	80			BOOK 031, PAGE 14, BLOCK 0, PAR…	031	14						2026.2	131003
02639231	06	045		NONE	CA							MENDOCINO	91938	MENDOCINO	011200	112	3663.4612			06045C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	-9999				65		TP	0.8400			BOOK 026, PAGE 39, BLOCK 2, PAR…	026	39						2026.2	053002
00340021	06	045	205 TEDFORD AVE	UKIAH	CA							MENDOCINO	93490	UKIAH	011300	113	562.5743			06045C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	-9999				01		R1	0			BOOK 003, PAGE 40, BLOCK 0, PAR…	003	40						2026.2	154154
04902101	06	045		NONE	CA							MENDOCINO	92510	POINT ARENA	011102	111.0200	158447.6111			06045C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	-9999				64		TP	40			BOOK 049, PAGE 02, BLOCK 1, PAR…	049	02						2026.2	053003
13315020	06	045		NONE	CA							MENDOCINO	92510	POINT ARENA	011102	111.0200	39785.3119			06045C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	-9999				65		TP	10			BOOK 133, PAGE 15, BLOCK 0, PAR…	133	15						2026.2	052011
180030RW	06	045			CA							MENDOCINO	93490	UKIAH	011400	114	2775594.9804			06045C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	-9999	169.0867	280.6031	183.9583				0		7225	BOOK 180, PAGE 03, BLOCK 0, PAR…	180	03				EL AZTECA MEXICAN RESTAURANT	RESTAURANT	2026.2
02602010	06	045		NONE	CA							MENDOCINO	91938	MENDOCINO	011200	112	146022.2512			06045C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	-9999				64		TP	40			BOOK 026, PAGE 02, BLOCK 0, PAR…	026	02						2026.2	053003
01438009	06	045		NONE	CA							MENDOCINO	91580	LAYTONVILLE-LEGGETT	010200	102	156528.8410			06045C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	-9999				64		FL	40			BOOK 014, PAGE 38, BLOCK 0, PAR…	014	38						2026.2	155003
12311030	06	045		NONE	CA							MENDOCINO	91938	MENDOCINO	011001	110.0100	142703.2411			06045C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	-9999				65		RL	40			BOOK 123, PAGE 11, BLOCK 0, PAR…	123	11						2026.2	104011
02629213	06	045		NONE	CA							MENDOCINO	91938	MENDOCINO	011200	112	1847.5068			06045C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	-9999				81		FL	5			BOOK 026, PAGE 29, BLOCK 2, PAR…	026	29						2026.2	053002
11835003	06	045		NONE	CA							MENDOCINO	91938	MENDOCINO	011004	110.0400	2441.5965			06045C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	-9999				01		RR	0			BOOK 118, PAGE 35, BLOCK 0, PAR…	118	35						2026.2	104004
02660015	06	045		NONE	CA							MENDOCINO	91938	MENDOCINO	011200	112	102151.2246			06045C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	-9999				65		TP	25.1200			BOOK 026, PAGE 60, BLOCK 0, PAR…	026	60						2026.2	053002
02615023	06	045	510 HWY 128	NAVARRO	CA							MENDOCINO	91938	MENDOCINO	011200	112	773.6084			06045C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	-9999				01		RR	0			BOOK 026, PAGE 15, BLOCK 0, PAR…	026	15						2026.2	053008