Saved query c9cf332272e709cf

Data Explorer

Query the US Nationwide Parcel Dataset

$1.75 / 1,000 records$100 minimum

39/80

Live SQL

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

58,359 matching parcels

Data Preview

parcelid	statefp	countyfp	parceladdr	parcelcity	parcelstate	ownername	owneraddr	countyname	cousubfp	cousubname	tractce	tractname	calcarea	imprvalue	landvalue	agvalue	totalvalue	numbldgs	numunits	firmid	firmdate	fldzone	zonesubty	elevmin	elevmax	elevavg	usecode	zoningcode	taxacres	ownertype	legaldesc	parceltype	accesstype	iucnclass	placename	placetype	lrversion
09-14-100-009	17	093		UNINCORPORATED	IL	ROBERT D BALTZ	1925 RTE 52	KENDALL	68757	SEWARD	890703	8907.0300	16202.9862	203182	97402	85322	132940	1	1	17093C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	176.5342	180.6145	177.5505	0011	A-1	4	PERSON	S 544.5 W 480 NW SEC 14-35-8 EX…						2026.2
01-16-455-005	17	093	2012 COUNTRY DR	CITY OF PLANO	IL	ARLENA JUAREZ	2012 COUNTRY DR	KENDALL	44043	LITTLE ROCK	890502	8905.0200	851.2525	72526	13703		86229	1	1	17093C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	202.3274	203.0233	202.6378	0040			PERSON	LT 33 WOODWIND SUBD UNIT 1 CITY…						2026.2
03-10-200-034	17	093		UNINCORPORATED	IL	COMMONWEALTH EDISON	THREE LINCOLN CENTRE 4TH FL	KENDALL	56900	OSWEGO	890103	8901.0300	15583.3540							17093C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	200.4078	204.2767	201.7409	0090	A-1	3.8498	PERSON	SEC 10-37-8 LEASED LAND TO OSWE…	GOVT SPECIAL DISTRICT	RESTRICTED		OSWEGO PRAIRIE TRAIL	LOCAL PARK	2026.2
02-31-300-017	17	093		CITY OF YORKVILLE	IL	KENDALL COUNTY FOREST PRESERVE	110 W MADISON ST	KENDALL	39454	KENDALL	890601	8906.0100	6854.0980							17093C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	195.0910	196.5020	196.0766	0090		1.3000	GOVERNMENT	1.30 AC TR LYG W W SEC 31-37-7 …	GOVT SPECIAL DISTRICT	RESTRICTED	V	HOOVER FOREST PRESERVE	LOCAL CONSERVATION AREA	2026.2
01-31-100-005	17	093		UNINCORPORATED	IL	FRIEDERS FAMILY FARM LLC	MARY LOU SHELDON	KENDALL	44043	LITTLE ROCK	890501	8905.0100	123351.5854	200	200	20330	20130			17093C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	195.3575	201.8345	198.7074	0011	A-1	30.2996	BUSINESS	SEC 31-37-6 30.24 AC DOC 89-115…						2026.2
02-35-382-004	17	093		UNINCORPORATED	IL	FIELDS FARM COLONY OWNERS ASSO	PO BOX 601	KENDALL	56900	OSWEGO	890108	8901.0800	2109.8990		1		1			17093C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	206.4404	210.3517	207.9461	0030	R-3 PUD		PERSON	OUTLOT E FIELDS OF FARM COLONY …						2026.2
02-35-426-001	17	093		UNINCORPORATED	IL	FARM COLONY HOMEOWNERS ASSN	ASSOCIA CHICAGOLAND	KENDALL	56900	OSWEGO	890108	8901.0800	3481.0287		1		1			17093C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	200.0779	202.9544	201.1775	0030	R-3		PERSON	LT 44 FARM COLONY UNIT 2 PHASE 3						2026.2
02-32-278-002	17	093		CITY OF YORKVILLE	IL	UNITED CITY OF YORKVILLE	651 PRAIRIE POINTE DR	KENDALL	39454	KENDALL	890601	8906.0100	261.2269							17093C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	173.1084	179.0251	177.2056	0090			GOVERNMENT	LT 1-2 BLK 10 BLACKS ADDN CITY …	GOVT LOCAL	OPEN		WEST HYDRAULIC PARK	LOCAL PARK	2026.2
02-35-127-010	17	093		UNINCORPORATED	IL	MOE HOLDINGS LLC	7720 RT 71	KENDALL	56900	OSWEGO	890108	8901.0800	3927.0088		15000		15000			17093C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	190.9971	196.7976	195.1538	0030	R-3		BUSINESS	LOT 8 FARM COLONY EXC ROW TAKIN…						2026.2
06-26-346-001	17	093		CITY OF JOLIET	IL	VISTA RIDGE INVESTMENT LLC	MCNAUGHTON DEVELOPMENT INC	KENDALL	51531	NA-AU-SAY	890702	8907.0200	46565.0805			23450	23450			17093C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	188.8429	193.8021	191.1746	0021		29.4000	BUSINESS	SOUTHWEST QUARTER SEC 26 OF LOT…						2026.2
02-33-109-010	17	093		CITY OF YORKVILLE	IL	DEPARTMENT OF NATURAL RESOURCES	ONE NATURAL RESOURCES WAY	KENDALL	08368	BRISTOL	890402	8904.0200	12788.5623							17093C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	173.7231	187.8158	180.7017	0090		4.4600	GOVERNMENT	SEC 33-37-7 CITY OF YORKVILLE	GOVT STATE	RESTRICTED		BLACKBERRY CREEK DAM (DISMANTLE…	UNKNOWN	2026.2
02-32-427-017	17	093		CITY OF YORKVILLE	IL	NATALIE WHITNEY KAREN BRUN	401 W FOX RD	KENDALL	39454	KENDALL	890601	8906.0100	206.4538		2806		2806			17093C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	195.8065	196.4099	196.1975	0030			PERSON	SEC 32-37-7 CITY OF YORKVILLE						2026.2
09-21-200-006	17	093		UNINCORPORATED	IL	MICHELLE HARRIS	6700 E RT 6	KENDALL	68757	SEWARD	890703	8907.0300	316170.9115			40050	40050			17093C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	174.0164	176.9626	175.3861	0021	A-1	77.6999	PERSON	S 116.47 AC EXC W 38.73 ACS S 1…						2026.2
07-35-300-009	17	093		UNINCORPORATED	IL	PAUL F NANCY L ZABEL	1247 BRENDAN DR	KENDALL	05872	BIG GROVE	890703	8907.0300	130013.2858			24020	24020			17093C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	189.6318	197.6780	193.3482	0021	A-1	32.1399	PERSON	32.53 AC OF SW 1/4 SEC.35-35-6 …						2026.2
05-16-100-024	17	093		UNINCORPORATED	IL	ALBERT JR CARYN COLLINS	9555 AMENT ROAD	KENDALL	39454	KENDALL	890602	8906.0200	72956.0160			13260	13260			17093C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	217.1940	221.7928	219.6746	0021	A-1	18.2600	PERSON	PT NW SEC 16-36-7 COM SE COR NW…						2026.2
02-12-350-074	17	093		VILLAGE OF OSWEGO	IL	EDWARD J KARI A RANKINS	204 CLUBHOUSE LN	KENDALL	08368	BRISTOL	890403	8904.0300	712.5609	1134	379		1513	1	1	17093C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	199.4893	199.9355	199.6570	0040			PERSON	UNIT 31-18 PINE RIDGE CLUB VILL…						2026.2
01-20-100-009	17	093		UNINCORPORATED	IL	JOHN PIERCE TR	2041 SUYDAM RD	KENDALL	44043	LITTLE ROCK	890502	8905.0200	39145.3453			6670	6670			17093C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	202.3571	204.4805	202.8587	0021	A-1	9.6600	TRUST	SEC 20-37-6						2026.2
02-04-100-014	17	093		CITY OF YORKVILLE	IL	EDWARD A BARBARA SCHRAMM	N5119 HWY H	KENDALL	08368	BRISTOL	890401	8904.0100	5100.2266			130	130			17093C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	196.6544	199.2840	197.7619	0021		1.3284	PERSON	106.23 AC TR LYG N SEC 4-37-7 L…						2026.2
02-21-151-018	17	093		UNINCORPORATED	IL	RAYMOND V III KRISTINE D WILLIA…	3337 RTE 47	KENDALL	08368	BRISTOL	890401	8904.0100	2641.3061		50		50			17093C	2026-01-22	AE	FLOODWAY	187.4324	188.4992	187.9468	0030	A-1		PERSON	SEC 21-37-7						2026.2
03-27-100-006	17	093		UNINCORPORATED	IL	MKM OIL INC	P O BOX 317	KENDALL	56900	OSWEGO	890107	8901.0700	20626.8810			4450	4450			17093C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	203.3705	205.3538	204.1989	0021	A-1	5.0100	BUSINESS	N 5 AC W1/2 NW 1/4 SEC 27-37-8						2026.2
01-20-100-015	17	093		UNINCORPORATED	IL	JAMES R SWANSON DEC LIV TR	2370 N 4070TH RD	KENDALL	44043	LITTLE ROCK	890502	8905.0200	11991.7805			2650	2650			17093C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	202.8943	204.6591	203.8139	0021		2.9600	TRUST	2.96 AC TR LYG NW NW SEC 20-37-…						2026.2
03-12-300-004	17	093		UNINCORPORATED	IL	RONALD TAMMY BRIGEL	909 WOLF RD	KENDALL	56900	OSWEGO	890105	8901.0500	8093.8300		19142		19142			17093C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	222.5625	226.7186	223.9932	0030	A-1	2	PERSON	SEC 12-37-8						2026.2
01-23-177-006	17	093		CITY OF PLANO	IL	CITY OF PLANO	17 E MAIN ST	KENDALL	44043	LITTLE ROCK	890501	8905.0100	948.0847							17093C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	197.0052	198.0900	197.7096	0090			GOVERNMENT	LT 49 CHURCHILL FARMS UNIT 1 PA…	GOVT LOCAL	OPEN		UNKNOWN PARK	LOCAL PARK	2026.2
01-35-100-011	17	093		UNINCORPORATED	IL	JOHN MARGARET KEOUGH TRUST	13524 B HALE ST	KENDALL	44043	LITTLE ROCK	890501	8905.0100	12564.6946		1957		1957			17093C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	177.6225	193.1054	184.5311	0030	A-1	3.1100	TRUST	SEC 35-37-6 3.11 AC TR PT NW 1/4						2026.2
09-25-100-005	17	093		VILLAGE OF MINOOKA	IL	RENEWA I LLC	2200 POST OAK BLVD STE 1525	KENDALL	68757	SEWARD	890703	8907.0300	185563.0418			24770	24770			17093C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	187.9118	199.0127	192.5035	0021		45.5700	BUSINESS	PT W NW SEC 25-35-8 COM SW COR …						2026.2