Saved query 725d66b08330ed2a

Data Explorer

Query the US Nationwide Parcel Dataset

$1.75 / 1,000 records$100 minimum

0/80

Live SQL

SELECT * 
FROM "parcel_layer" 
WHERE statefp = '17' 
  AND countyfp = '009'

5,608 matching parcels

Data Preview

parcelid	taxacctnum	statefp	countyfp	parceladdr	parcelcity	parcelstate	parcelzip	ownername	owneraddr	ownercity	countyname	cousubfp	cousubname	tractce	tractname	calcarea	imprvalue	landvalue	agvalue	saledate	numbldgs	numunits	firmid	firmdate	fldzone	zonesubty	elevmin	elevmax	elevavg	usecode	taxacres	ownertype	taxdistrict
05-10-300-800	0517232009	17	009	201 NE CROSS	MOUNT STERLING IL 62353	IL	62353	GAIN JEAN R	201 NE CROSS	MT STERLING IL 62353	BROWN	51167	MOUNT STERLING	970500	9705	674.0785	51473	2443			1	1	17009C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	219.4173	220.1109	219.8799	0040	0	PERSON	MT STERLING
08-02-300-200	UNKNOWN	17	009	1828 400N AVE	MOUNT STERLING IL 62353	IL	62353	STARNER MICHAEL L	2835 HUNTERSTOWN HAMPTON RD	NEW OXFORD PA 17350	BROWN	51167	MOUNT STERLING	970500	9705	1513.0854	46492	2633	4605		1	1	17009C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	212.2438	215.7751	214.6268	0011	83.9900	PERSON	ELKHORN
05-10-200-900	0517201003	17	009	211 W COURT	MOUNT STERLING IL 62353	IL	62353	ZIMMERMAN ROGER	393 775E ST	MT STERLING IL 62353	BROWN	51167	MOUNT STERLING	970500	9705	679.4273	20147	3310			1	1	17009C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	223.0842	224.1081	223.6631	0040	0	PERSON	MT STERLING
05-12-800-500	0517133011	17	009	215 W CHESTNUT	MOUNT STERLING IL 62353	IL	62353	SCHMULT ANTHONY D & LAURA M	215 W CHESTNUT	MT STERLING IL 62353	BROWN	51167	MOUNT STERLING	970500	9705	679.8492	8249	2443			1	1	17009C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	218.4761	219.0933	218.8094	0040	0	PERSON	MT STERLING
06-04-600-300	0409300002	17	009	210 1050N AVE	TIMEWELL IL 62375	IL	62375	SHEPHERD TODD M	210 1050N AVE	TIMEWELL IL 62375	BROWN	42561	LEE	970400	9704	8087.0819	36212	3522		2003-11-25	1	1	17009C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	223.1815	227.1489	225.8919	0040	2	PERSON	LEE
05-17-800-300	0508406008	17	009	707 N MAPLE	MOUNT STERLING IL 62353	IL	62353	SUHLING JENNIFER	707 N MAPLE	MT STERLING IL 62353	BROWN	51167	MOUNT STERLING	970500	9705	668.4302	29634	2443			1	1	17009C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	214.7937	216.4426	215.8608	0040	0	PERSON	MT STERLING
05-18-300-300	0517428003	17	009	205 SPRINGDALE	MOUNT STERLING IL 62353	IL	62353	WORT GREGORY R	205 SPRINGDALE	MOUNT STERLING IL 62353	BROWN	51167	MOUNT STERLING	970500	9705	1597.1734	47127	5267			1	1	17009C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	215.4659	215.9492	215.6800	0040	0	PERSON	MT STERLING
05-17-300-700	0516101003	17	009	332 FAIRGROUND	MOUNT STERLING IL 62353	IL	62353	SCHNEIDER THOMAS J ETUX	332 FAIRGROUND	MOUNT STERLING IL 62353	BROWN	51167	MOUNT STERLING	970500	9705	747.1627	31421	3744			1	1	17009C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	219.0792	219.9651	219.5648	0040	0.2200	PERSON	MT STERLING
07-07-200-900	1017386005	17	009	112 S MAIN	VERSAILLES IL 62378	IL	62378	ANDERSON CHARLES & JOHNSON PATR…	112 S MAIN ST	VERSAILLES IL 62378	BROWN	77733	VERSAILLES	970400	9704	680.1194	15177	1766			1	1	17009C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	192.3427	193.7964	193.0526	0040	0	PERSON	VERSAILLES
05-15-801-400	0517284004	17	009	412 E UN	MOUNT STERLING IL 62353	IL	62353	KELLY ROSS E & JANICE L	412 E UNION	MT STERLING IL 62353	BROWN	51167	MOUNT STERLING	970500	9705	1111.7037	23003	4029			1	1	17009C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	216.1480	216.4602	216.2872	0040	0.3600	PERSON	MT STERLING
05-07-600-200	0513200001	17	009	1173 1025N AVE	MT STERLING IL 62353	IL	62353	GARRETT WILLIAM & DIANE	1156 1025N AVE	MT STERLING IL 62353	BROWN	51167	MOUNT STERLING	970400	9704	36724.9606	22791	2507	440		1	1	17009C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	182.6586	198.5683	194.8749	0029	9	PERSON	MT STERLING
03-00-700-400	0107100003	17	009	1697 085E ST	CLAYTON IL 62324	IL	62324	IHNEN LEWIS M & CATHY J	BOX 159	GOLDEN IL 62339	BROWN	58330	PEA RIDGE	970400	9704	314960.9013	17810	2633	11136		1	1	17009C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	170.9663	200.2200	183.8846	0011	80	PERSON	PEA RIDGE
05-14-300-900	0517128004	17	009	226 W MAIN	MOUNT STERLING IL 62353	IL	62353	CLARK MARTHA J	226 W MAIN	MOUNT STERLING IL 62353	BROWN	51167	MOUNT STERLING	970500	9705	475.9313	23436	1861			1	1	17009C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	221.4502	222.5486	222.1434	0040	0	PERSON	MT STERLING
05-21-100-200	0517130006	17	009	221 W FRANKLIN	MOUNT STERLING IL 62353	IL	62353	GARTHAUS OUTFITTERS LLC	863 700N AVE	MT STERLING IL 62353	BROWN	51167	MOUNT STERLING	970500	9705	1365.4567	35599	4854			1	1	17009C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	219.2878	220.7489	220.1966	0060	0	BUSINESS	MT STERLING
05-17-800-200	0508406009	17	009	705 N MAPLE	MOUNT STERLING IL 62353	IL	62353	LOGSDON RODNEY & KATHY	111 FOREST AVE	MT STERLING IL 62353	BROWN	51167	MOUNT STERLING	970500	9705	668.4575	14902	2443			1	1	17009C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	214.8185	216.5973	215.8771	0040	0	PERSON	MT STERLING
05-13-300-300	0517257004	17	009	106 W COLINE	MOUNT STERLING IL 62353	IL	62353	HERALD LANE	106 W COLINE	MOUNT STERLING IL 62353	BROWN	51167	MOUNT STERLING	970500	9705	679.6846	32616	2274			1	1	17009C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	220.1479	221.1443	220.8222	0040	0	PERSON	MT STERLING
05-10-100-300	0517205022	17	009	107 W SOUTH	MOUNT STERLING IL 62353	IL	62353	ZIMMERMAN ROGER	393 775E ST	MT STERLING IL 62353	BROWN	51167	MOUNT STERLING	970500	9705	697.7385	20962	2443			1	1	17009C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	223.9293	224.9171	224.3365	0040	0	PERSON	MT STERLING
05-11-200-400	0517237014	17	009	211 E SOUTH	MOUNT STERLING IL 62353	IL	62353	GILSDORF JESSE R	111 S CAPITOL	MT STERLING IL 62353	BROWN	51167	MOUNT STERLING	970500	9705	681.9371	9254	2443			1	1	17009C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	219.0912	219.8737	219.4928	0040	0	PERSON	MT STERLING
05-12-901-200	0517252012	17	009	109 W CHESTNUT	MOUNT STERLING IL 62353	IL	62353	WAGNER CHRISTOPHER	109 W CHESTNUT	MT STERLING IL 62353	BROWN	51167	MOUNT STERLING	970500	9705	699.0571	22495	2443			1	1	17009C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	220.4727	221.0591	220.7685	0040	0	PERSON	MT STERLING
04-05-600-800	0605400004	17	009	1149 1400E ST	MT STERLING IL 62353	IL	62353	VOLK CHRISTOPHER C	1149 1400E ST	MT STERLING IL 62353	BROWN	16262	COOPERSTOWN	970400	9704	22817.9391	63636	2083			1	1	17009C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	163.4313	178.2641	173.1078	0040	5.5300	PERSON	COOPERSTOWN
05-09-300-600	0528277003	17	009	877 775N AVE	MOUNT STERLING IL 62353	IL	62353	BEHYMER HENRY STEVEN ETUX	877 775N AVE	MT STERLING IL 62353	BROWN	51167	MOUNT STERLING	970500	9705	12908.0084	29126	2073			1	1	17009C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	210.7633	214.1079	213.0618	0040	4.5000	PERSON	MT STERLING
07-06-800-600	1017381010	17	009	N WALNUT	VERSAILLES IL 62378	IL	62378	HALL JEREMY L & KARA R	301 E SECOND ST	VERSAILLES IL 62378	BROWN	77733	VERSAILLES	970400	9704	230.9292	3850	444			1	1	17009C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	193.1988	194.1214	193.5892	0040	0	PERSON	VERSAILLES
01-01-100-500	0333303001	17	009	212 S HIGH ST	RIPLEY IL 62353	IL	62353	HAMMACK DANIELLE	%HAMMACK MARVIN	CAMDEN IL 62319	BROWN	64187	RIPLEY	970400	9704	3906.7306	984	338			1	1	17009C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	168.7776	172.4227	170.8277	0040	0.1300	PERSON	RIPLEY
04-05-200-400	0719100003	17	009	884 1835E ST	MT STERLING IL 62353	IL	62353	HAM MEGAN L	884 1835E ST	MT STERLING IL 62353	BROWN	16262	COOPERSTOWN	970400	9704	1877.4707	16795	2633			1	1	17009C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	142.1632	147.3331	144.3671	0040	1	PERSON	COOPERSTOWN
07-07-600-600	1017327019	17	009	420 N MAIN ST LOT 4	VERSAILLES IL 62378	IL	62378	THOMAS RANDY SETH	25476 CO RD CR 408	MEMPHIS MO 63555	BROWN	77733	VERSAILLES	970400	9704	2006.8323	34139	4315			1	1	17009C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	181.5836	183.7150	182.5054	0040	0	PERSON	VERSAILLES