Saved query 9caaf19822c135af

Data Explorer

Query the US Nationwide Parcel Dataset

$1.75 / 1,000 records$100 minimum

37/80

Live SQL

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

20,979 matching parcels

Data Preview

parcelid	statefp	countyfp	parcelcity	parcelstate	ownername	owneraddr	ownercity	countyname	cousubfp	cousubname	tractce	tractname	calcarea	imprvalue	landvalue	agvalue	numbldgs	numunits	firmid	firmdate	fldzone	zonesubty	elevmin	elevmax	elevavg	usecode	usedesc	taxacres	ownertype	legaldesc	parceltype	accesstype	iucnclass	placename	placetype	lrversion
1721478019	17	193		IL	HALL TERRY & MARGO DEON	115 WADE ST	NORRIS CITY IL 62869	WHITE	37231	INDIAN CREEK	958400	9584	1013.4241	7597	756	0	1	1	17193C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	138.7067	140.5217	139.5332	0040	NCTF1	0	PERSON	LOT 016 BLK 000 PLT 000 OZIE JE…						2026.2
0219161005	17	193		IL	SMOTHERS DAVID R	410 MAIN ST	BURNT PRAIRIE IL 62820	WHITE	09902	BURNT PRAIRIE	958300	9583	1120.8279	1009	593	0	1	1	17193C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	136.8934	138.8480	137.9222	0040	BPBF6	0	PERSON	LOT 119 BLK 000 PLT 000 HUTCHIN…						2026.2
1313161007	17	193		IL	WINKLEMAN KREGG R	820 S CHURCH ST	CARMI IL 62821	WHITE	11306	CARMI	958000	9580	525.7486	1436	2885	0	1	1	17193C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	119.9722	121.4208	120.4187	0060	CACH5	0	PERSON	LOT 012 BLK 010 PLT 180 FACKNEY…						2026.2
1835127012	17	193		IL	KANADY CLIFFORD C & GAYLA R	591 CO RD 1040 E	NORRIS CITY IL 62869	WHITE	34228	HERALDS PRAIRIE	958400	9584	2712.2683	526	929	0	1	1	17193C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	129.1013	131.8122	130.7740	0040	HP005	0	PERSON	LOT 002 BLK 000 PLT 000 W/2 L2 …						2026.2
1216103003	17	193		IL	HART LARRY L II	1341 CO RD 25 E	ENFIELD IL 62835	WHITE	24192	ENFIELD	958300	9583	7282.1368	3206	1298	0	1	1	17193C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	143.4927	150.6239	148.4157	0040	ENEF3	2.2400	PERSON	NW SEC 16 TWP 05 RNG 08 SUB L1 …						2026.2
1901227009	17	193		IL	AUD CURTIS & JESSICA	P O BOX 85	MAUNIE IL 62861	WHITE	24088	EMMA	958400	9584	3314.9789	7434	1492	0	1	1	17193C	2026-01-22	AE		112.6245	113.4623	113.0299	0040	EMMA5	0	PERSON	LOT 001 BLK 000 PLT 000 PUMPHRE…						2026.2
1311300002	17	193	IL	IL	CITY OF CARMI	225 E MAIN ST	CARMI IL 62821	WHITE	11306	CARMI	958300	9583	207.2911	0	0	0			17193C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	116.8080	120.3352	119.4181	0090	CAH05	0.1000	GOVERNMENT	SW SEC 11 TWP 05 RNG 09 PT L2 S…						2026.2
1024400001	17	193		IL	BLACK RIVER PROPERTIES LLC	3601 N ST. JOSEPH AVE	EVANSVILLE IN 47720	WHITE	59507	PHILLIPS	958200	9582	694797.4710	0	0	8876			17193C	2026-01-22	AE					0021	PH002	168.8000	BUSINESS	NE SEC 24 TWP 04 RNG 14 FRAC E/…	GOVT FEDERAL	CLOSED	V	EMERGENCY WATERSHED PROTECTION …	CONSERVATION EASEMENT	2026.2
0520240007	17	193		IL	SMITH GREGORY V	213 E SOUTH ST	GRAYVILLE IL 62844	WHITE	31069	GRAY	958200	9582	209.0269	0	1225	0			17193C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	131.9581	133.0337	132.6218	0030	GRGR1	0	PERSON	LOT 011 BLK 006 PLT 000 ORIGINA…						2026.2
1018200006	17	193		IL	KINGERY MICHAEL & DELEE	659 N 500 E	FLORA IN 46929	WHITE	59507	PHILLIPS	958200	9582	161692.3180	0	0	4027			17193C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	116.2142	135.9899	126.8374	0021	PH002	40	PERSON	NE SEC 18 TWP 04 RNG 14 NE NE 2…						2026.2
1231400002	17	193		IL	CUNEO SHERRELL & MICHAEL	2330 N EDGEMONT	LOS ANGELES CA 90027	WHITE	24192	ENFIELD	958400	9584	164639.9601	0	0	1592			17193C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	136.1459	144.6057	141.2412	0021	EN003	40	PERSON	SE SEC 31 TWP 05 RNG 08 NE SE 3…						2026.2
1311476020	17	193		IL	HOLLAND HAROLD D & PRICILLA	913 9TH ST	CARMI IL 62821	WHITE	11306	CARMI	958000	9580	937.4031	0	1041	0			17193C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	126.3797	133.6112	131.6608	0030	CAH05	0	PERSON	LOT 049 BLK 000 PLT 340 MICK SU…						2026.2
1331477001	17	193		IL	INBODEN CHARLES & NIKKI	1133 CO RD 700 E	CARMI IL 62821	WHITE	11306	CARMI	958300	9583	668.3090	0	450	0			17193C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	128.1968	129.1427	128.5357	0030	CAH05	0	PERSON	LOT 006 BLK 000 PLT 085 VILLAGE…						2026.2
2118300003	17	193		IL	HARPER JOYCE ANN REV TRUST	207 N INDIAN CREEK TRAIL	NORRIS CITY IL 62869	WHITE	37231	INDIAN CREEK	958400	9584	155887.9868	0	0	7387			17193C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	118.1124	131.3972	125.5463	0021	ICFV3	40	TRUST	SW SEC 18 TWP 07 RNG 08 SW SW 3…						2026.2
1313331008	17	193		IL	FIRST BAPTIST CHURCH	PO BOX 245	CARMI IL 62821	WHITE	11306	CARMI	958100	9581	650.8745	0	0	0			17193C	2026-01-22	X	0.2 PCT ANNUAL CHANCE FLOOD HAZ…	115.5978	115.9364	115.7350	0090	CACH5	0	NONPROFIT	LOT 009 BLK 005 PLT 470 STEWART…						2026.2
1728227018	17	193		IL	MCGUIRE LYNDA	P.O. BOX 405	NORRIS CITY IL 62869	WHITE	37231	INDIAN CREEK	958400	9584	452.9798	0	756	0			17193C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	137.2513	138.2498	137.7519	0030	NCTF1	0	PERSON	LOT 044 BLK 000 PLT 000 HILL-CR…						2026.2
1309400013	17	193		IL	HUBELE JOHN D & RACHELLE	875 CO RD 1500 N	CARMI IL 62821	WHITE	11306	CARMI	958300	9583	116266.7898	0	0	6283			17193C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	127.9034	142.1232	136.6863	0021	CAH05	28.7300	PERSON	SE SEC 09 TWP 05 RNG 09 SE SE E…						2026.2
2115326004	17	193		IL	BLAIR CARLOS T & FAITH	228 CO RD 300 E	NORRIS CITY IL 62869	WHITE	37231	INDIAN CREEK	958400	9584	4856.5324	0	0	74			17193C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	117.4901	120.0880	118.9841	0021	ICFV3	1.2000	PERSON	SW SEC 15 TWP 07 RNG 08 NE SW L…						2026.2
1707300003	17	193		IL	WPB FARMS LLC	PO BOX 276	NORRIS CITY IL 62869	WHITE	37231	INDIAN CREEK	958400	9584	82441.0579	0	0	4797			17193C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	123.4750	134.5724	127.9614	0021	IC003	18.8000	BUSINESS	SW SEC 07 TWP 06 RNG 08 W/2 SW …						2026.2
1801400006	17	193		IL	ZIEREN WILLIAM C	526 WEDGEWOOD DR	OXFORD MS 38655	WHITE	34228	HERALDS PRAIRIE	958400	9584	121814.0648	0	0	9035			17193C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	121.0323	131.3312	125.7422	0021	HP005	30	PERSON	SE SEC 01 TWP 06 RNG 09 SW SE E…						2026.2
1208493009	17	193		IL	HOGUE CONNIE S	PO BOX 14	ENFIELD IL 62835	WHITE	24192	ENFIELD	958300	9583	558.1297	0	533	0			17193C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	139.0648	140.3464	139.6610	0030	ENEF3	0	PERSON	LOT 009 BLK 009 PLT 000 SOUTHER…						2026.2
1417300003	17	193		IL	BINGMAN LOUIS A & VONDA SUE TR…	1326 CO RD 1400 N	CARMI IL 62821	WHITE	33591	HAWTHORNE	958200	9582	20407.8106	0	0	804			17193C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	116.5630	121.0080	117.9429	0021	HA005	4.1000	TRUST	SW SEC 17 TWP 05 RNG 10 L2 SW S…						2026.2
1931100003	17	193		IL	KINMAC INC	PO BOX 428	CARMI IL 62821	WHITE	24088	EMMA	958400	9584	147128.9135	0	0	2649			17193C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	112.0507	138.0304	130.1687	0021	EM005	36	BUSINESS	NW SEC 31 TWP 06 RNG 10 W 9/10 …						2026.2
1228200003	17	193		IL	THOMAS KENNETH JR & SR	1076 US HWY 45	ENFIELD IL 62835	WHITE	24192	ENFIELD	958300	9583	159474.7890	0	0	8619			17193C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	127.1658	144.9520	136.9753	0011	ENF03	39.4000	PERSON	NE SEC 28 TWP 05 RNG 08 L2 SE N…						2026.2
0521302001	17	193		IL	WHITE COUNTY HOUSING AUTHORITY	PO BOX 277	CROSSVILLE IL 62827	WHITE	31069	GRAY	958200	9582	1494.4023	0	0	0			17193C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	125.5206	133.4405	130.9461	0090	GRGR1	0	GOVERNMENT	LOT 002 BLK 00V PLT 000 BISHOP'…						2026.2