Saved query 0cae66d69b8029c8

Data Explorer

Query the US Nationwide Parcel Dataset

$1.75 / 1,000 records$100 minimum

42/80

Live SQL

SELECT * 
FROM "lr_parcel_us" 
WHERE statefp = '53' 
  AND countyfp = '021'

34,531 matching parcels

Data Preview

parcelid	statefp	countyfp	parceladdr	parcelcity	parcelstate	parcelzip	ownername	owneraddr	ownercity	ownerstate	ownerzip	countyname	cousubfp	cousubname	tractce	tractname	calcarea	imprvalue	landvalue	numbldgs	numunits	fldzone	elevmin	elevmax	elevavg	usecode	ownertype	parceltype	accesstype	iucnclass	placename	placetype	lrversion
021-113150109	53	021		PASCO	WA	99301	WORSHAM FAMILY LAND LLC		PASCO	WA	99301	FRANKLIN	91424	KAHLOTUS	020700	207	15905.9683	1128500	44600	1	1	—	154.7357	157.2148	156.0405	82	BUSINESS				SIMPLOT GROWER SOLUTIONS	B2B_SERVICE	2026.2
021-117380022	53	021		PASCO	WA	99301	FRANKLIN COUNTY		PASCO	WA	99301	FRANKLIN	92528	PASCO NORTH	020605	206.0500	111609.6895	37691300	6011600	1	1	—	153.4623	158.5087	155.6162	74	PERSON				DESERT ICE - PASCO	MEDIA_SERVICE	2026.2
021-117500116	53	021		PASCO	WA	99301	DEPARTMENT OF NATURAL RESOURCES	STATE LANDS DIVISIONS	OLYMPIA	WA	98504	FRANKLIN	92512	PASCO	020606	206.0600	10133.5942					—	151.2908	154.1749	152.1713	67	GOVERNMENT	GOVT STATE	RESTRICTED	OTHER	ROASTERS	CAFE	2026.2
021-109380010	53	021	701 MUSE RD	CONNELL	WA	99326	O'NEAL LAND INC	% ZOEE DERUWE	CONNELL	WA	99326	FRANKLIN	90752	CONNELL	020802	208.0200	645053.1077	419000	124200	1	1	—				83	BUSINESS						2026.2
021-124600013	53	021		PASCO	WA	99301	ROUNDY FARMS EAST LLC		PASCO	WA	99301	FRANKLIN	91424	KAHLOTUS	020700	207	12811.7308	11900	154400	1	1	—	186.7348	193.7931	190.0883	83	BUSINESS						2026.2
021-112037135	53	021		PASCO	WA	99301	LANDRAM ANDREW & SUSAN (TR)		KENNEWICK	WA	99336	FRANKLIN	92512	PASCO	020101	201.0100	650.4431	4700	53100	1	1	—	114.1029	114.9103	114.7229	63	PERSON						2026.2
021-126190151	53	021		PASCO	WA	99301	ANDERSEN STEVEN & LORI		PASCO	WA	99301	FRANKLIN	92528	PASCO NORTH	020608	206.0800	121077.7089	900	847600	1	1	—	149.7108	155.7360	152.8094	83	PERSON						2026.2
021-124430037	53	021		PASCO	WA	99301	TSCHIRKY TED S & MEREDITH K		PASCO	WA	99301	FRANKLIN	92528	PASCO NORTH	020608	206.0800	4977.8738	14500	81600	1	1	—	164.0515	166.3835	164.9077	83	PERSON						2026.2
021-126390049	53	021		MESA	WA	99343	JACKASS MOUNTAIN HOLDINGS LLC		PASCO	WA	99301	FRANKLIN	92528	PASCO NORTH	020608	206.0800	171275.0476	17300	414600	1	1	—	108.8315	144.6501	127.5276	83	BUSINESS						2026.2
021-109370012	53	021	700 MUSE RD	CONNELL	WA	99326	O'NEAL LAND INC		CONNELL	WA	99326	FRANKLIN	90752	CONNELL	020802	208.0200	1665905.5495	1286800	154200	1	1	—				83	BUSINESS						2026.2
021-120010023	53	021	1305 MAIL RD	OTHELLO	WA	99344	BOOKER LAND LLC		OTHELLO	WA	99344	FRANKLIN	90752	CONNELL	020801	208.0100	725683.3480	137100	2058000	1	1	—				83	BUSINESS						2026.2
021-122380012	53	021		MESA	WA	99343	HAILEY COMPANY		MESA	WA	99343	FRANKLIN	90752	CONNELL	020801	208.0100	900086.0510	11500	1252100	1	1	—				83	BUSINESS				THE RAISIN'H ARENA	RODEO	2026.2
021-101540021	53	021		KAHLOTUS	WA	99335	HARDER FARMS INC	ATTN: COREY F BROCK, PRESIDENT	SPOKANE	WA	99201	FRANKLIN	91424	KAHLOTUS	020700	207	123350.4236		62900			—	290.0585	294.4042	292.3761	83	BUSINESS						2026.2
021-113140075	53	021			WA		GAMACHE ENTERPRISES LLC		PASCO	WA	99301	FRANKLIN	92512	PASCO	020102	201.0200	20444.3251	804000	83300	1	1	—	127.4580	130.0439	128.7217	81	BUSINESS						2026.2
021-123190136	53	021		PASCO	WA	99301	WHITE BRAVO II LLC	C/O HOMESTEAD CAPITAL USA LLC	SAN FRANCISCO	CA	94111	FRANKLIN	92528	PASCO NORTH	020608	206.0800	594144.1973	22100	1485200	1	1	—				83	BUSINESS						2026.2
021-123290076	53	021		PASCO	WA	99301	ROUNDABOUT FARM LLC	C/O JAMES & LINDA PERRY	PASCO	WA	99301	FRANKLIN	92528	PASCO NORTH	020608	206.0800	333982.3360		1316300			—	231.4992	267.9503	251.8558	83	BUSINESS						2026.2
021-119101178	53	021		PASCO	WA	99301	RIVERVIEW BAPTIST CHURCH		PASCO	WA	99301	FRANKLIN	92512	PASCO	020504	205.0400	2071.1651					—	116.4494	118.7165	117.6713	72	NONPROFIT				RIVERVIEW BAPTIST CHRISTIAN SCH…	ELEMENTARY_SCHOOL	2026.2
021-112028010	53	021		PASCO	WA	99301	CITY OF PASCO		PASCO	WA	99301	FRANKLIN	92512	PASCO	020202	202.0200	13899.0611					—	117.1375	118.7262	117.9376	91	GOVERNMENT				AMTRAK PASCO STATION	TRAIN_STATION	2026.2
001-2536310440002	53	021			WA		HARDER FARMS INC	C/O HARDER, TERRI	KAHLOTUS	WA	99335	FRANKLIN	91424	KAHLOTUS	020700	207	16152.3572		3400			—	297.9395	298.8583	298.1247	83	BUSINESS						2026.2
021-102400019	53	021			WA		RICE FAMILY LAND LLC	C/O ANDREW RICE, MANAGER	REDMOND	WA	98052	FRANKLIN	91424	KAHLOTUS	020700	207	2617943.8250	3200	552800	1	1	—				83	BUSINESS						2026.2
021-103050048	53	021			WA		PALANIO (ETAL) BARBARA	WOODY, STANLEY A	DEER PARK	WA	99006	FRANKLIN	90752	CONNELL	020802	208.0200	293311.3665		49700			—	395.8975	434.7435	420.8389	83	PERSON						2026.2
021-117642045	53	021		PASCO	WA	99301	RAHIMLOU ANA		RICHLAND	WA	99352	FRANKLIN	92512	PASCO	020501	205.0100	1408.6409		144200			—	122.0492	123.1231	122.3302	91	PERSON						2026.2
021-113130484	53	021		PASCO	WA	99301	LANOLIN HOLDINGS 3 LLC		NEW TOWN	MA	02456	FRANKLIN	92512	PASCO	020102	201.0200	22264.5318		1010500			—	130.9391	133.7155	132.6385	91	BUSINESS						2026.2
021-126150077	53	021		PASCO	WA	99301	ZARO JEFF & BRANDY		PASCO	WA	99301	FRANKLIN	92528	PASCO NORTH	020608	206.0800	3335.3716		169300			—	111.5882	119.6233	114.5457	91	PERSON						2026.2
021-119121032	53	021		PASCO	WA	99301	BROWN CHARLES & CHERYL		PASCO	WA	99301	FRANKLIN	92512	PASCO	020504	205.0400	4794.3213		262100			—	108.4041	110.6212	109.5838	91	PERSON						2026.2