Saved query be78888145c14c4a

Data Explorer

Query the US Nationwide Parcel Dataset

$1.75 / 1,000 records$100 minimum

40/80

Live SQL

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

104,944 matching parcels

Data Preview

parcelid	statefp	countyfp	parceladdr	parcelcity	parcelstate	parcelzip	ownername	countyname	cousubfp	cousubname	tractce	tractname	calcarea	imprvalue	landvalue	agvalue	totalvalue	numbldgs	numunits	firmid	firmdate	fldzone	zonesubty	elevmin	elevmax	elevavg	usecode	zoningcode	ownertype	naicscode	parceltype	accesstype	iucnclass	placename	placetype	taxdistrict
077-14173633011	53	077	320 JEFFERSON RD	NACHES	WA	98937		Yakima	92240	Northwest Yakima	003003	30.0300	16065.2536	185800	87400			1	1	53077C	2025-12-23	AE		695.3207	698.4577	696.5704	11			1153	GOVT FEDERAL	RESTRICTED	OTHER	SNOQUALMIE NATIONAL FOREST	NATIONAL FOREST	77
077-18113434402	53	077	970 St Mary Rd	HARRAH	WA	98933	Wlj Investments LLC	Yakima	93472	Toppenish-Wapato	940001	9400.0100	4186.5699	284300	74300	2300	354000	1	1	53077C	2025-12-23	AREA NOT INCLUDED					83	Ag	BUSINESS	2372	GOVT TRIBAL	UNKNOWN			NATIVE AMERICAN LAND AREA	77
077-18132741552	53	077	3312 W NOB HILL BLVD	YAKIMA	WA	98902		Yakima	93904	Yakima	001100	11	1203.3394	372500	139850			1	1	53077C	2025-12-23	X	AREA OF MINIMAL FLOOD HAZARD	349.4518	350.8125	350.2320	58			722511				TASTY WOK	RESTAURANT	77
077-23090531003	53	077	750 BRADEN RD	GRANDVIEW	WA	98930		Yakima	93344	Sunnyside	001801	18.0100	11723.5534	409600	70900			1	1	53077C	2025-12-23	X	AREA OF MINIMAL FLOOD HAZARD	214.4648	222.9654	219.9438	11			8111				ROBERT'S REPAIR	AUTOMOTIVE_SERVICE	77
077-18132722004	53	077	4708 TIETON DR	YAKIMA	WA	98908		Yakima	93904	Yakima	001000	10	1693.9258	995700	284300			1	1	53077C	2025-12-23	X	AREA OF MINIMAL FLOOD HAZARD	358.8473	360.3585	359.7175	59			457110				CONOCO	GAS_STATION	77
077-22103544016	53	077	9381 EMERALD RD	SUNNYSIDE	WA	98944		Yakima	93344	Sunnyside	002006	20.0600	12661.7057	271100	210600			1	1	53077C	2025-12-23	X	AREA OF MINIMAL FLOOD HAZARD	215.2552	217.3245	216.2614	11			441330				EXCEL TRUCK PARTS LLC	VEHICLE_PARTS_STORE	77
077-18132724024	53	077	1012 S 40TH AVE	YAKIMA	WA	98908		Yakima	93904	Yakima	001000	10	1053.5823	432800	93500			1	1	53077C	2025-12-23	X	AREA OF MINIMAL FLOOD HAZARD	346.0538	349.3034	348.4822	65			6212				BRUCE P. KINNEY	DENTAL_CLINIC	77
077-18132743005	53	077	1607 CREEKSIDE LP	YAKIMA	WA	98902		Yakima	93904	Yakima	001100	11	6180.5728	1743100	538800			1	1	53077C	2025-12-23	X	AREA OF MINIMAL FLOOD HAZARD	332.8569	336.1756	335.4542	65			522292				TEAM TRUHLER - CROSSCOUNTRY MOR…	FINANCIAL_SERVICE	77
077-14130711023	53	077	FS RD 143		WA	98937		Yakima	92240	Northwest Yakima	003003	30.0300	1356.5803	107800				1	1	53077C	2025-12-23	D		898.8682	901.5999	899.8371	19			7212	GOVT FEDERAL	RESTRICTED	OTHER	RIMROCK LAKE	RESOURCE MANAGEMENT AREA	77
077-18133421906	53	077	4006 CREEKSIDE LOOP	YAKIMA	WA	98908		Yakima	93904	Yakima	001100	11	951.9536							53077C	2025-12-23	X	AREA OF MINIMAL FLOOD HAZARD	336.4390	336.8917	336.6547	99			51781	GOVT LOCAL	OPEN		LOTH181	LOCAL OTHER OR UNKNOWN	77
077-18142434022	53	077	191 PETERSON LANE	SELAH	WA	98942		Yakima	93904	Yakima	003100	31	10000.6223	423900	193900			1	1	53077C	2025-12-23	X	AREA OF MINIMAL FLOOD HAZARD	386.5122	398.3166	392.4428	11									77
077-19111034419	53	077	20 KAMIAKIN AVE	WAPATO	WA	98951		Yakima	93472	Toppenish-Wapato	940008	9400.0800	1219.6107	270800	86800			1	1	53077C	2025-12-23	AREA NOT INCLUDED					11			2372	GOVT TRIBAL	UNKNOWN			NATIVE AMERICAN LAND AREA	77
077-17132413429	53	077	314 MOUNTAIN SHADOWS PL	YAKIMA	WA	98908		Yakima	93904	Yakima	002804	28.0400	5785.5111	1382600	249600			1	1	53077C	2025-12-23	X	AREA OF MINIMAL FLOOD HAZARD	439.0619	449.7349	444.6799	11									77
077-18132023427	53	077	7806 W LINCOLN AVE	YAKIMA	WA	98908		Yakima	93904	Yakima	000402	4.0199	990.1709	353600	85400			1	1	53077C	2025-12-23	X	AREA OF MINIMAL FLOOD HAZARD	441.2029	448.4190	444.1088	11									77
077-18132511497	53	077	710 S 4TH AVE	YAKIMA	WA	98902		Yakima	93904	Yakima	000700	7	557.6676	146000	88600			1	1	53077C	2025-12-23	X	AREA OF MINIMAL FLOOD HAZARD	325.4585	325.7431	325.5924	11									77
077-20101012510	53	077	208 S E ST	TOPPENISH	WA	98948		Yakima	93472	Toppenish-Wapato	940006	9400.0600	602.5216	192100	49800			1	1	53077C	2025-12-23	AE					11			2372	GOVT TRIBAL	UNKNOWN			NATIVE AMERICAN LAND AREA	77
077-18132111422	53	077	5104 DOUGLAS DR	YAKIMA	WA	98908		Yakima	93904	Yakima	000401	4.0100	1026.0661	186200	109300			1	1	53077C	2025-12-23	X	AREA OF MINIMAL FLOOD HAZARD	401.0616	402.6106	402.0115	11									77
077-18130442517	53	077	10 MCALLISTER DR	YAKIMA	WA	98908		Yakima	93904	Yakima	003400	34	1132.9300	284000	56300			1	1	53077C	2025-12-23	X	AREA OF MINIMAL FLOOD HAZARD	370.1926	371.4454	370.8025	11									77
077-19120114449	53	077	506 LUNA AVE	MOXEE	WA	98936		Yakima	92192	Northeast Yakima	001702	17.0200	650.6728	308300	70400			1	1	53077C	2025-12-23	X	AREA OF MINIMAL FLOOD HAZARD	333.0303	335.1684	334.0403	11									77
077-18133624475	53	077	1805 S 11TH AVE	YAKIMA	WA	98902		Yakima	93904	Yakima	001201	12.0100	652.2017	218200	79100			1	1	53077C	2025-12-23	X	AREA OF MINIMAL FLOOD HAZARD	316.9511	317.5881	317.1989	12									77
077-20100721403	53	077	2040 FORT RD	TOPPENISH	WA	98948		Yakima	93472	Toppenish-Wapato	940002	9400.0200	3923.7859	41500	64500			1	1	53077C	2025-12-23	AREA NOT INCLUDED					91			2372	GOVT TRIBAL	UNKNOWN			NATIVE AMERICAN LAND AREA	77
077-17152534401	53	077	720 CONRAD RD	SELAH	WA	98942		Yakima	92240	Northwest Yakima	003004	30.0400	55560.4834	588800	99400			1	1	53077C	2025-12-23	X	AREA OF MINIMAL FLOOD HAZARD	526.4927	543.3501	537.5219	11									77
077-18142543501	53	077	604 JAMIE DR	SELAH	WA	98942		Yakima	93904	Yakima	003100	31	457.5006	153000	74200			1	1	53077C	2025-12-23	X	AREA OF MINIMAL FLOOD HAZARD	345.0108	345.7051	345.4467	11									77
077-19132144527	53	077	3701 GUN CLUB RD UNIT 93	YAKIMA	WA	98901		Yakima	93904	Yakima	001602	16.0200	635.5912	211100	84400			1	1	53077C	2025-12-23	X	AREA WITH REDUCED FLOOD RISK DU…	307.9907	308.7507	308.4239	11									77
077-18132633507	53	077	1417 S 27TH AVE	YAKIMA	WA	98902		Yakima	93904	Yakima	001100	11	686.6951	258000	93600			1	1	53077C	2025-12-23	X	AREA OF MINIMAL FLOOD HAZARD	338.3399	338.9843	338.6682	11									77