Saved query 738dd9908b70d740

Data Explorer

Query the US Nationwide Parcel Dataset

$1.75 / 1,000 records$100 minimum

40/80

Live SQL

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

104,942 matching parcels

Data Preview

parcelid	statefp	countyfp	parceladdr	parcelcity	parcelstate	ownername	owneraddr	ownercity	ownerstate	ownerzip	countyname	cousubfp	cousubname	tractce	tractname	calcarea	imprvalue	landvalue	numbldgs	numunits	firmid	firmdate	fldzone	zonesubty	elevmin	elevmax	elevavg	usecode	ownertype	parceltype	accesstype	iucnclass	placename	placetype	lrversion
077-23092444001	53	077	1415 PLEASANT AVE	GRANDVIEW	WA	WYCKOFF FARMS INC	PO BOX 249	GRANDVIEW	WA	98930	YAKIMA	93344	SUNNYSIDE	001801	18.0100	76431.8516	3200800	195000	1	1	53077C	2025-12-23	X	AREA OF MINIMAL FLOOD HAZARD	250.7628	255.6419	252.1827	83	BUSINESS						2026.2
077-23121344401	53	077	16100 HWY 241	SUNNYSIDE	WA	JOEL TREVINO	16100 STATE ROUTE 241	SUNNYSIDE	WA	98944	YAKIMA	92192	NORTHEAST YAKIMA	001701	17.0100	14830.9448	349600	88300	1	1	53077C	2025-12-23	X	AREA OF MINIMAL FLOOD HAZARD	347.1956	358.2689	351.3067	11	PERSON						2026.2
077-23092414002	53	077	1451 HIGHLAND RD	GRANDVIEW	WA	CHRISTI DOORNINK	1451 HIGHLAND RD	GRANDVIEW	WA	98930	YAKIMA	93344	SUNNYSIDE	001801	18.0100	5120.2060	442900	144400	1	1	53077C	2025-12-23	X	AREA OF MINIMAL FLOOD HAZARD	257.9226	259.1327	258.6385	11	PERSON						2026.2
077-23102444001	53	077	7660 SHELLER RD	SUNNYSIDE	WA	SLEGERS FARMS LLC	5360 N COUNTY LINE RD	SUNNYSIDE	WA	98944	YAKIMA	93344	SUNNYSIDE	001801	18.0100	180402.5571	255900	167000	1	1	53077C	2025-12-23	X	AREA OF MINIMAL FLOOD HAZARD	342.8013	374.0560	361.5538	81	BUSINESS						2026.2
077-23121311402	53	077	17001 SR 241	SUNNYSIDE	WA	JORREY K TUTTLE	17001 SR 241	SUNNYSIDE	WA	98944	YAKIMA	92192	NORTHEAST YAKIMA	001701	17.0100	222037.5411	465600	89200	1	1	53077C	2025-12-23	X	AREA OF MINIMAL FLOOD HAZARD	348.8080	397.2412	377.1942	81	PERSON						2026.2
077-23081214405	53	077	505 BYRON RD	MABTON	WA	W TADD & NELLIE BOWLSBY RENTALS…	PO BOX 218	GRANDVIEW	WA	98930	YAKIMA	91808	MABTON	002701	27.0100	9449.5543	22200	79600	1	1	53077C	2025-12-23	X	AREA OF MINIMAL FLOOD HAZARD	198.3613	214.6633	208.8798	18	BUSINESS						2026.2
077-23073611900	53	077			WA	COVENTRY VALE WINERY INC	PO BOX 249	GRANDVIEW	WA	98930	YAKIMA	91808	MABTON	002701	27.0100	2502706.1267	1414100		1	1	53077C	2025-12-23	X	AREA OF MINIMAL FLOOD HAZARD				81	BUSINESS	GOVT STATE	RESTRICTED	OTHER	WASHINGTON STATE DEPARTMENT OF …	STATE RESOURCE MANAGEMENT AREA	2026.2
077-23081311409	53	077	415 WELLS GAP RD	PROSSER	WA	TRAVIS & KIMBERLY SWAYZE	415 WELLS GAP RD	PROSSER	WA	99350	YAKIMA	91808	MABTON	002701	27.0100	63198.4278	334500	117600	1	1	53077C	2025-12-23	X	AREA OF MINIMAL FLOOD HAZARD	210.5195	235.1236	222.7870	11	PERSON						2026.2
077-23121311401	53	077	17009 SR 241	SUNNYSIDE	WA	ERIC M ANDERSON	17009 STATE ROUTE 241	SUNNYSIDE	WA	98944	YAKIMA	92192	NORTHEAST YAKIMA	001701	17.0100	12122.7485	501100	81900	1	1	53077C	2025-12-23	X	AREA OF MINIMAL FLOOD HAZARD	388.2208	406.7338	396.7553	11	PERSON						2026.2
077-23102511001	53	077	5360 N COUNTY LINE RD	SUNNYSIDE	WA	SLEGERS FARMS LLC	5360 N COUNTY LINE RD	SUNNYSIDE	WA	98944	YAKIMA	93344	SUNNYSIDE	001801	18.0100	156854.2260	304600	171600	1	1	53077C	2025-12-23	X	AREA OF MINIMAL FLOOD HAZARD	350.0809	369.3616	360.2266	83	BUSINESS						2026.2
077-23092511007	53	077	100 S COUNTY LINE RD	GRANDVIEW	WA	SOCORRO MENDOZA	100 S COUNTY LINE RD	GRANDVIEW	WA	98930	YAKIMA	93344	SUNNYSIDE	001801	18.0100	33724.6518	177100	130800	1	1	53077C	2025-12-23	X	AREA OF MINIMAL FLOOD HAZARD	250.3818	252.3444	251.0682	11	PERSON						2026.2
077-23081241001	53	077		MABTON	WA	JEFFREY CLEAVENGER	35208 N 140 PR NW	BENTON CITY	WA	99320	YAKIMA	91808	MABTON	002701	27.0100	123229.0967	3100	200800	1	1	53077C	2025-12-23	X	AREA OF MINIMAL FLOOD HAZARD	203.6755	211.1288	205.5079	83	PERSON						2026.2
077-23091211006	53	077	2280 N COUNTY LINE RD	GRANDVIEW	WA	BETTY J TUDOR	2280 N COUNTY LINE RD	GRANDVIEW	WA	98930	YAKIMA	93344	SUNNYSIDE	001801	18.0100	42960.3441	595600	138900	1	1	53077C	2025-12-23	X	AREA OF MINIMAL FLOOD HAZARD	277.3881	287.6740	282.5597	83	PERSON						2026.2
077-23081244404	53	077	BRYON HILL RD		WA	GARY L & MARLENE E HUGHES	141 BYRON HILL RD	PROSSER	WA	99350	YAKIMA	91808	MABTON	002701	27.0100	23208.9242	12500	123800	1	1	53077C	2025-12-23	X	AREA OF MINIMAL FLOOD HAZARD	208.3190	214.7358	210.1770	83	PERSON						2026.2
077-12073611002	53	077			WA	STATE OF WASHINGTON	PO BOX 47014	OLYMPIA	WA	98504	YAKIMA	93184	SOUTH YAKIMA	940003	9400.0300	1811395.2194		1356900			53077C	2025-12-23	X	AREA OF MINIMAL FLOOD HAZARD				92	GOVERNMENT	GOVT STATE	RESTRICTED	OTHER	WASHINGTON STATE DEPARTMENT OF …	STATE RESOURCE MANAGEMENT AREA	2026.2
077-23121344402	53	077	STATE RTE 24	MOXEE	WA	ROGELIO & MARIA MEDRIGAL DE MEN…	1450 GRANITE CREEK DR	PATTERSON	CA	95363	YAKIMA	92192	NORTHEAST YAKIMA	001701	17.0100	151954.0809		42000			53077C	2025-12-23	X	AREA OF MINIMAL FLOOD HAZARD	347.6327	407.9552	370.6882	81	PERSON						2026.2
077-23092411005	53	077	270 N COUNTY LINE RD	GRANDVIEW	WA	FREEWAY FARMS	2320 N COUNTY LINE RD	GRANDVIEW	WA	98930	YAKIMA	93344	SUNNYSIDE	001801	18.0100	34817.1587		150500			53077C	2025-12-23	X	AREA OF MINIMAL FLOOD HAZARD	260.6753	264.8238	262.6284	99	PERSON						2026.2
077-23092414007	53	077	WINE COUNTRY RD	GRANDVIEW	WA	STATEWIDE DEVELOPMENT LLC	273 S COUNTY LINE RD	GRANDVIEW	WA	98930	YAKIMA	93344	SUNNYSIDE	001801	18.0100	13226.4964		71200			53077C	2025-12-23	X	AREA OF MINIMAL FLOOD HAZARD	255.9764	258.8135	257.0047	99	BUSINESS						2026.2
077-23092413008	53	077	WINE COUNTRY RD	GRANDVIEW	WA	STATEWIDE DEVELOPMENT LLC	273 S COUNTY LINE RD	GRANDVIEW	WA	98930	YAKIMA	93344	SUNNYSIDE	001801	18.0100	40445.1080		282900			53077C	2025-12-23	X	AREA OF MINIMAL FLOOD HAZARD	255.1495	259.5644	256.2712	99	BUSINESS						2026.2
077-22073611001	53	077	670 RASCHKO RD	MABTON	WA	RENAE DONALDSON	670 RASCHKO RD	MABTON	WA	98935	YAKIMA	91808	MABTON	002701	27.0100	2553490.4685	577800	202900	1	1	53077C	2025-12-23	X	AREA OF MINIMAL FLOOD HAZARD				83	PERSON						2026.2
077-23102411001	53	077	COUNTYLINE RD		WA	NATHAN & BETHANY JEAN CLEMENT	3130 PORTAGE BAY PL E APT A	SEATTLE	WA	98102	YAKIMA	93344	SUNNYSIDE	001801	18.0100	363829.5096		44700			53077C	2025-12-23	X	AREA OF MINIMAL FLOOD HAZARD	354.1022	383.0991	372.1735	81	PERSON						2026.2
077-23081241003	53	077	BYRON RD		WA	J & A PADGHAM FARMS LLC	3651 STOVER RD	SUNNYSIDE	WA	98944	YAKIMA	91808	MABTON	002701	27.0100	123539.9455		207900			53077C	2025-12-23	X	AREA OF MINIMAL FLOOD HAZARD	204.5472	211.7998	207.6686	83	BUSINESS						2026.2
077-23131241001	53	077	S OF PRIEST RAPIDS		WA	GEORGE E ETAL BRULOTTE	45 RYAN LN	ELMA	WA	98541	YAKIMA	92192	NORTHEAST YAKIMA	001701	17.0100	20959.8016		25100			53077C	2025-12-23	X	AREA OF MINIMAL FLOOD HAZARD	125.7161	139.7201	132.1189	81	PERSON						2026.2
077-23131223001	53	077			WA	MARTINEZ SIMON LIVESTOCK INC	13391 HWY 24	MOXEE	WA	98936	YAKIMA	92192	NORTHEAST YAKIMA	001701	17.0100	51543.6928		30900			53077C	2025-12-23	X	AREA OF MINIMAL FLOOD HAZARD	131.1398	162.1293	139.0595	83	BUSINESS						2026.2
077-23122444002	53	077	HANFORD/WAUTOMA		WA	J2 LAND & CATTLE LLC	PO BOX 398	OUTLOOK	WA	98938	YAKIMA	93344	SUNNYSIDE	001801	18.0100	146530.7417		35900			53077C	2025-12-23	X	AREA OF MINIMAL FLOOD HAZARD	360.8540	377.9404	369.0771	81	BUSINESS						2026.2