Saved query d145f1d7ebc01b8a

Data Explorer

Query the US Nationwide Parcel Dataset

$1.75 / 1,000 records$100 minimum

36/80

Live SQL

SELECT * 
FROM "lr_parcel_us" 
WHERE statefp = '17' 
  AND countyfp = '097'

331,799 matching parcels

Data Preview

parcelid	statefp	countyfp	parceladdr	parcelstate	ownername	countyname	cousubfp	cousubname	tractce	tractname	calcarea	fldzone	elevmin	elevmax	elevavg	ownertype	naicscode	parceltype	accesstype	iucnclass	placename	placetype
	17	097		IL	STATE OF ILLINOIS	LAKE	77668	VERNON	864522	8645.2200	115649.3876	—	198.2195	206.0971	202.1909	GOVERNMENT		GOVT STATE	CLOSED	V	EDWARD L. RYERSON NATURE PRESER…	CONSERVATION EASEMENT
	17	097		IL	NON-GOVERNMENTAL ORGANIZATION	LAKE	00000	COUNTY SUBDIVISIONS NOT DEFINED	865501	8655.0100	182.0321	—	176.5499	176.7457	176.5555	GOVERNMENT		NGO	OPEN	V	OPENLANDS OPEN SPACE	LOCAL CONSERVATION AREA
	17	097		IL	PRIVATE	LAKE	69485	SHIELDS	863500	8635	1071.7957	—	207.9096	210.2462	209.3027	PERSON		PRIVATE	CLOSED	V	SKOKIE RIVER	PRIVATE CONSERVATION
	17	097		IL	NON-GOVERNMENTAL ORGANIZATION	LAKE	69485	SHIELDS	863500	8635	26151.7220	—	200.4262	205.3100	202.6199	PERSON		NGO	CLOSED	V	LAKE FOREST OPEN LANDS ASSOCIAT…	CONSERVATION EASEMENT
	17	097		IL	REGIONAL AGENCY	LAKE	43263	LIBERTYVILLE	863801	8638.0100	7616.3404	—	200.3476	207.3576	204.0753	GOVERNMENT		GOVT SPECIAL DISTRICT	CLOSED	V	MACARTHUR WOODS NATURE PRESERVE	STATE CONSERVATION AREA
	17	097		IL	JOINT	LAKE	43263	LIBERTYVILLE	863601	8636.0100	3831.1717	—	236.3768	238.7531	237.3830	GOVERNMENT		GOVT MULTIPLE	CLOSED	V	OAK OPENINGS NATURE PRESERVE	STATE CONSERVATION AREA
	17	097		IL	REGIONAL AGENCY	LAKE	05326	BENTON	860104	8601.0400	460.9079	—	180.2731	182.1804	181.2815	GOVERNMENT		GOVT SPECIAL DISTRICT	OPEN	V	SPRING BLUFF FOREST PRESERVE	LOCAL CONSERVATION AREA
	17	097		IL	CITY GOVERNMENT	LAKE	43263	LIBERTYVILLE	866200	8662	9616.1801	—	198.5502	201.1990	199.8493	PERSON		GOVT LOCAL	CLOSED		VILLAGE OF METTAWA EASEMENT	OTHER EASEMENT
	17	097		IL	CITY GOVERNMENT	LAKE	77668	VERNON	866200	8662	2895.6651	—	207.9543	209.3566	208.5197	PERSON		GOVT LOCAL	CLOSED		VILLAGE OF METTAWA EASEMENT	OTHER EASEMENT
	17	097		IL	REGIONAL AGENCY	LAKE	50364	MORAINE	865400	8654	1117.7411	—	193.8589	196.1841	195.8286	PERSON		GOVT SPECIAL DISTRICT	OPEN		RORY DAVID DEUTSCH TOT LOT	UNKNOWN
	17	097		IL	REGIONAL AGENCY	LAKE	18004	CUBA	864303	8643.0300	2344.2485	—	223.0049	224.3474	223.4323	PERSON		GOVT SPECIAL DISTRICT	OPEN		LYONS PRAIRIE AND MARSH	LOCAL PARK
	17	097		IL	REGIONAL AGENCY	LAKE	18004	CUBA	864303	8643.0300	553.2980	—	234.6724	245.0973	240.2744	PERSON		GOVT SPECIAL DISTRICT	OPEN		LYONS PRAIRIE AND MARSH	LOCAL PARK
0417102006	17	097		IL		LAKE	84233	ZION	860105	8601.0500	5475.4802	—	207.9555	210.6809	209.6103		811121				CALIBER COLLISION	AUTO_BODY_SHOP
1131100017	17	097		IL		LAKE	43263	LIBERTYVILLE	864002	8640.0200	11422.2950	—	226.0561	231.7321	229.2237		6216				RAY & SON CARPENTRY	HOME_SERVICE
0634215019	17	097		IL		LAKE	03220	AVON	861105	8611.0500	9923.7305	—	240.3096	244.5953	243.4110						LAKEFRONT SENIOR RESIDENCES	SENIOR_LIVING_FACILITY
0527200001	17	097	362 BRIGHTON CT	IL		LAKE	30952	GRANT	860906	8609.0600	146344.7544	—	229.3930	246.8739	234.2616
1014313004	17	097	2805 KESSLER DR	IL		LAKE	27923	FREMONT	864110	8641.1000	844.4950	—	256.7624	257.5802	257.2294
0524110012	17	097		IL		LAKE	30952	GRANT	860905	8609.0500	454.0931	—	229.4554	234.6322	231.4072
0427301001	17	097		IL		LAKE	05326	BENTON	860600	8606	1387.6472	—	190.5097	193.7964	192.7150
0336112005	17	097		IL		LAKE	52753	NEWPORT	866000	8660	10529.2603	—	216.5978	220.8985	219.1056
1616305076	17	097		IL		LAKE	80112	WEST DEERFIELD	864700	8647	26378.9769	—	197.3849	206.4666	201.3874
1631300064	17	097		IL		LAKE	80112	WEST DEERFIELD	864802	8648.0200	739.1751	—	209.6089	210.6111	209.9385
1623313012	17	097		IL		LAKE	50364	MORAINE	865400	8654	882.7390	—	199.2233	202.6641	202.2247
0709202001	17	097		IL		LAKE	78877	WARREN	861604	8616.0400	36961.9207	—	220.7172	231.4101	222.9960
0431303011	17	097		IL		LAKE	05326	BENTON	860400	8604	2348.9147	—	217.8551	222.3573	218.8651