Saved query a527ccbc63ab5c39

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 = '17' 
  AND countyfp = '157'

25,748 matching parcels

Data Preview

parcelid	statefp	countyfp	parceladdr	parcelcity	parcelstate	ownername	owneraddr	ownercity	countyname	cousubfp	cousubname	tractce	tractname	calcarea	imprvalue	landvalue	agvalue	saledate	numbldgs	numunits	firmid	firmdate	fldzone	zonesubty	elevmin	elevmax	elevavg	usecode	usedesc	taxacres	ownertype	legaldesc	lrversion
04 19 400 007	17	157	9819 HUNTER FIELD RD	SPARTA IL 62286	IL	HALL BRADLY C & KARI R	12085 WINE HILL RD	STEELEVILLE IL 62288	RANDOLPH	93438	TILDEN	950700	9507	21341.2698	27155	1774483200000			1	1	17157C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	153.1839	156.1592	154.4734	010	0040	5.2699	PERSON	448/222 463/384 2021R02533 PT…	2026.2
01 04 358 007	17	157			IL	HORRELL PROPERTY MANAGEMENT LLC…	124 LOCUST	RED BUD IL 62278	RANDOLPH	92970	RED BUD	950800	9508	589.9092	53415	1774483200000			1	1	17157C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	143.6658	145.2515	144.6070	053	0060	0	BUSINESS	246/338 544/181 2009R00109 LOT …	2026.2
06 26 181 008	17	157			IL	SAUER WILLIAM J & JEAN M TRUSTE…	7153 ROSCOW HOLLOW RD	PRAIRIE DU ROCHER IL 62277	RANDOLPH	92520	PRAIRIE DU ROCHER	950900	9509	2696.7409		1774483200000	90	2005-06-08			17157C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	124.0963	127.5082	125.4117	050	0021	0.6600	PERSON	793/600 2020R03059 PT LOT 137 P…	2026.2
14 23 300 003	17	157			IL	TROUE RANDY L TRUSTEE	3624 TROUE LN	PERCY IL 62272	RANDOLPH	90504	BREMEN	951000	9510	167546.2529		1774483200000	12085				17157C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	132.3878	146.8015	140.8684	101	0021	40	TRUST	377/359 2021R03995 SE SW	2026.2
19 04 100 003	17	157			IL	HELMERS JOHN EDGAR	11536 WINE HILL RD	STEELEVILLE IL 62288	RANDOLPH	93834	WINE HILL	951000	9510	20574.2969		1774483200000	1885				17157C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	158.6399	164.0796	161.5793	030	0021	5	PERSON	253/35 2013R01909 2013R01910 S…	2026.2
04 25 200 001	17	157			IL	MOORE ANDREW PAUL	7648 HARDSCRABBLE RD	DU QUOIN IL 62832	RANDOLPH	90864	COULTERVILLE	950500	9505	160821.2936		1774483200000	14650				17157C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	155.2800	162.1151	158.6731	005	0021	40	PERSON	461/211 634/640 2016R00434 2018…	2026.2
07 05 400 004	17	157			IL	OHARA WILLIAM	4689 HARVEST LN	RUMA IL 62278	RANDOLPH	93060	RUMA	950900	9509	24231.6072		1774483200000	1015				17157C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	149.3254	158.9540	154.8011	050	0021	5.8500	PERSON	332/798 2014R04028 2020R00119 …	2026.2
04 25 200 002	17	157			IL	BLAIR WILLIAM R & KATHLEEN M CO…	13536 MARYS CREEK RD	SPARTA IL 62286	RANDOLPH	90864	COULTERVILLE	950500	9505	163752.9411		1774483200000	13620				17157C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	152.7696	159.4804	156.9228	005	0021	40	PERSON	285/195 2021R04892 SW NE	2026.2
13 14 400 004	17	157			IL	EGGEMEYER NELSON I	8201 OAKDALE RD	ELLIS GROVE IL 62241	RANDOLPH	92358	PALESTINE	951000	9510	29258.9679		1774483200000	2100				17157C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	162.2229	181.3358	174.9040	087	0011	7.4300	PERSON	419/411 2007R03767 PT SW SE	2026.2
01 09 400 005	17	157			IL	OHLWINE FARM INC	GUEBERT WILLARD E	RED BUD IL 622780000	RANDOLPH	92970	RED BUD	950800	9508	32683.7422		1774483200000	3600				17157C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	127.3118	130.9712	129.4126	050	0021	8	BUSINESS	292/384 PT NE SE	2026.2
09 29 300 001	17	157			IL	KEAGLE DOROTHY L TRUSTEE	PO BOX 6	CHESTER IL 62233	RANDOLPH	90702	CENTRAL	950900	9509	167466.3696		1774483200000	11630				17157C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	153.8745	163.7267	159.7529	073	0021	40	TRUST	437/775 438/230-231 NW SW	2026.2
10 33 200 001	17	157			IL	STORK GARY L TRUSTEE	7032 EDEN RD	SPARTA IL 62286	RANDOLPH	93240	STEELEVILLE	950500	9505	168908.0746		1774483200000	3530				17157C	2026-01-22	A		128.1348	136.9878	128.9777	107	0021	40	TRUST	579/901 2011R03574 NW NE	2026.2
09 36 400 001	17	157			IL	HILL PATRICIA G & ROBERT E SR …	5404 VIA VERDE	NORTH MYRTLE BEACH SC 29582	RANDOLPH	90702	CENTRAL	951000	9510	164624.3028		1774483200000	10235				17157C	2026-01-22	A		136.5255	144.2246	140.9579	009	0021	40	PERSON	441/88 455/758 NE SE	2026.2
15 14 300 010	17	157			IL	RANDOLPH COUNTY HIGHWAY DEPT	PO BOX 243	SPARTA IL 622860000	RANDOLPH	92394	PERCY	951100	9511	6254.7263		1774483200000					17157C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	145.1694	154.6593	147.9716	105	0090	0	PERSON	650/846 PT SW SEC 14 T6-R5	2026.2
16 24 400 001	17	157			IL	JANE'S SEEDS & WEEDS LLC	3875 E VILLA WAY	SPRINGFIELD MO 65809	RANDOLPH	91818	KASKASKIA	951202	9512.0200	161560.7247		1774483200000	17095				17157C	2026-01-22	AE		111.6149	115.5640	113.6684	065	0021	40	BUSINESS	383/152 93-MR-6 2012R04383 2022…	2026.2
08 32 300 001	17	157			IL	KUEKER RUTH ANN TR	7150 DEW DROP RD	ELLIS GROVE IL 622410000	RANDOLPH	90702	CENTRAL	950900	9509	230920.9741		1774483200000	10560				17157C	2026-01-22	AE		113.2473	124.0971	116.8225	003	0021	49	TRUST	275/888 2015R01377 FRL E 1/2 SW	2026.2
01 33 353 002	17	157			IL	VILLAGE OF RUMA	VILLAGE CLERK	RUMA IL 622780000	RANDOLPH	93060	RUMA	950900	9509	568.2335		1774483200000					17157C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	134.5614	135.2980	135.0965	052	0090	0	GOVERNMENT	219/300 91-79-7 LOT 2 BLK 1 HEN…	2026.2
07 16 200 003	17	157			IL	SCHERLE MARK	8464 1ST RD	EVANSVILLE IL 62242	RANDOLPH	93060	RUMA	950900	9509	162923.1396		1774483200000	8145				17157C	2026-01-22	A		118.4214	142.3535	128.1328	050	0021	40	PERSON	446/899-901 2021R03819 SW NE (L…	2026.2
03 36 227 031	17	157			IL	STUART TRAVIS W ETAL	UNKNOWN	MARION IL 62959	RANDOLPH	93222	SPARTA	950600	9506	133.5575		1774483200000		2006-05-24			17157C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	156.2369	156.9526	156.6536	024	0030	0.0300	PERSON	225/947 828/868 2023R01445 N 8'…	2026.2
18 07 453 020	17	157			IL	MOORE ALEXANDER	2323 CABIN ACCESS RD	CHESTER IL 62233	RANDOLPH	90738	CHESTER	951201	9512.0100	4163.2891		1774483200000					17157C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	152.9628	164.3574	159.6034	041	0030	1.0300	PERSON	132/218 774/545 2022R00588 PT S…	2026.2
13 12 400 007	17	157			IL	KRANTZ KENNETH E	8591 BODEKER LN	WALSH IL 62297	RANDOLPH	92358	PALESTINE	951000	9510	117613.7612		1774483200000	5090				17157C	2026-01-22	A		145.6582	159.4145	152.3598	088	0021	28.8100	PERSON	273/756 581/440 655/209 691/825…	2026.2
10 33 200 003	17	157			IL	RHEINECKER RALPH L & KAREN S …	1350 N SPARTA ST	STEELEVILLE IL 62288	RANDOLPH	93240	STEELEVILLE	950500	9505	332136.9018		1774483200000	29365				17157C	2026-01-22	A		127.1739	146.0295	132.7940	107	0021	82.0500	PERSON	257/199 279/471 518/670 S 1/2 NE	2026.2
15 26 300 002	17	157			IL	WOLTERS DALE	WOLTERS DONALD R	PERCY IL 622720000	RANDOLPH	92394	PERCY	951100	9511	82294.6425		1774483200000	9965				17157C	2026-01-22	A		125.7312	136.7266	129.1514	030	0021	20	PERSON	456/303 478/177 S 1/2 NW SW	2026.2
09 34 476 012	17	157			IL	RANDOLPH COUNTY HIGHWAY DEPT	PO BOX 243	SPARTA IL 622860000	RANDOLPH	90702	CENTRAL	951000	9510	436.8355		1774483200000					17157C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	150.4900	151.9762	151.2052	009	0090	0.1100	PERSON	751/408 PT SE SE SEC 34 T5 R6	2026.2
21 07 383 003	17	157			IL	KEYTON HENRY	414 MOORE ST	FESTUS MO 630280000	RANDOLPH	93042	ROCKWOOD	951000	9510	910.0868		1774483200000	20				17157C	2026-01-22	AE		112.6668	114.0873	113.0301	036	0021	0.2200	PERSON	205/592 STRIP IN SE COR SW	2026.2