Saved query b3d60e56097a5ead

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 = '047'

7,558 matching parcels

Data Preview

parcelid	statefp	countyfp	parceladdr	parcelstate	ownername	owneraddr	countyname	cousubfp	cousubname	tractce	tractname	calcarea	imprvalue	landvalue	agvalue	totalvalue	saledate	numbldgs	numunits	numfloors	fldzone	elevmin	elevmax	elevavg	usecode	usedesc	ownertype	legaldesc	township	section	range	plssdesc	lrversion	taxyear
10-01-126-004	17	047	370 N 2ND ST	IL	WAMPLER EDDIE R & BONNE	336 N SECOND ST	EDWARDS	90039	ALBION NO. 1	957100	9571	4396.9962	28840	2060	0	30900		2	1		—	155.4454	158.9470	157.2161		0040 \| RESIDENTIAL WITH BUILDIN…	PERSON	AL-2,Q S T R L047,B000,P208 OUT…	2S	1	10E	S1 T2S R10E	2026.2	2024
12-04-126-006	17	047		IL	CROP PRODUCTION SERVICES INC	602 HENDERSON ST	EDWARDS	90540	BROWNS	957000	9570	14776.9340	49170	13670	0	62840		1	1	1	—	116.7459	123.0083	120.4071		0060 \| COMMERCIAL PROPERTY WITH…	BUSINESS	-1,QNW,S04,T2S,R14 L B P PT E1/…	2S	4	14W	S4 T2S R14W	2026.2	2024
06-18-227-009	17	047		IL	SMITH ALLEN E		EDWARDS	93081	SALEM NO. 1	956900	9569	4061.2069	5810	1200	0	7010		4	1	1	—	145.7421	148.6139	147.4056		0040 \| RESIDENTIAL WITH BUILDIN…	PERSON	-1,QNE,S18,T1N,R14 L B P PT E1/…	1N	18	14W	S18 T1N R14W	2026.2	2024
12-28-400-004	17	047		IL	SIEGERT CHARLES TRUST		EDWARDS	91296	FRENCH CREEK	957000	9570	9445.8040	0	0	170	170		2	1	1	—	135.6228	140.3692	139.3048		0011 \| FARM PROPERTY WITH BUILD…	TRUST	-1,QSE,S28,T2S,R14 L B P PT SW …	2S	28	14W	S28 T2S R14W	2026.2	2024
02106408	17	047		IL	HOCKING HOWARD B & LADONNA F RE…		EDWARDS	93156	SHELBY NO. 2	956900	9569	198617.2003	0	0	12030	12030		1	1	1	—	137.9159	148.1835	144.2046		0021 \| FARM PROPERTY WITHOUT BU…	TRUST	-1,QNW,S11,T1S,R10 L B P NE NW …	1S	11	10E	S11 T1S R10E	2026.2	2024
06-17-155-001	17	047		IL	CHURCH		EDWARDS	93081	SALEM NO. 1	956900	9569	1017.5882	0	0	0	0					—	155.7776	158.6734	157.2804	3110	CEMETERY	NONPROFIT	-2,Q S T R L015,B000,P046 IST E…	1N	17	14W	S17 T1N R14W	2026.2	2024
15-17-376-004	17	047		IL	GRAVEYARD		EDWARDS	91296	FRENCH CREEK	957000	9570	8512.9501	0	0	0	0					—	140.0393	148.3175	144.4287	3110	CEMETERY	NONPROFIT	-1,QSE,S17,T3S,R14 L B P PT NW …	3S	17	14W	S17 T3S R14W	2026.2	2024
03137802	17	047		IL	KENDRICK STEVEN R & MARY KAY		EDWARDS	91296	FRENCH CREEK	957000	9570	79985.4134	0	0	4470	4470		1			—	138.2865	153.6502	146.2230		0021 \| FARM PROPERTY WITHOUT BU…	PERSON	-1,QSW,S18,T3S,R11 L B P N END …	3S	18	11E	S18 T3S R11E	2026.2	2024
10-27-300-009	17	047		IL	SIMMS JOHN E & MARY M		EDWARDS	90954	DIXON	957000	9570	181277.6926	0	0	16010	16010	2019-12-23				—	115.3503	131.4092	122.6096		0021 \| FARM PROPERTY WITHOUT BU…	PERSON	-1,QSW,S27,T2S,R10 L B P PT E1/…	2S	27	10E	S27 T2S R10E	2026.2	2024
10-01-305-017	17	047		IL	FERRIS KAREN		EDWARDS	90039	ALBION NO. 1	957100	9571	1078.5461	0	2060	0	2060	2019-12-20				—	151.4414	153.8858	152.6646		0030 \| RESIDENTIAL VACANT LOTS	PERSON	-2,Q S T R L011,B00S,P200 ORIG …	2S	1	10E	S1 T2S R10E	2026.2	2024
02125703	17	047	1091 700	IL	SPEIR LAWRENCE E		EDWARDS	90039	ALBION NO. 1	957000	9570	20882.4274	0	7560	0	7560					—	125.7237	131.5395	128.6475		0030 \| RESIDENTIAL VACANT LOTS	PERSON	-1,QSE,S30,T1S,R11 L B P PT NE …	1S	30	11E	S30 T1S R11E	2026.2	2024
10-36-300-002	17	047		IL	MEDLER ADAM LEE & ALAN E MEDLER		EDWARDS	91296	FRENCH CREEK	957000	9570	160665.5103	0	0	2800	2800	2019-02-08				—	139.2840	160.8746	153.6694		0021 \| FARM PROPERTY WITHOUT BU…	PERSON	-1,QSW,S36,T2S,R10 L B P W1/2 E…	2S	36	10E	S36 T2S R10E	2026.2	2024
12-04-187-004	17	047		IL	SMITH DAVID	RAILROAD ST	EDWARDS	90540	BROWNS	957000	9570	2564.9328	0	1660	0	1660					—	121.5677	122.2656	121.9936		0030 \| RESIDENTIAL VACANT LOTS	PERSON	BR-2,Q S T R L003,B014,P106 GOO…	2S	4	14W	S4 T2S R14W	2026.2	2024
05103401	17	047		IL	KERSHAW HELEN K INHERITED TR		EDWARDS	90486	BONE GAP	956900	9569	349133.0878	0	0	25030	25030		1			—	125.9335	143.5388	134.0049		0011 \| FARM PROPERTY WITH BUILD…	TRUST	-1,QSW,S07,T1S,R14 L B P W1/2 S…	1S	7	14W	S7 T1S R14W	2026.2	2024
12-15-300-002	17	047		IL	ROTRAMEL DOUGLAS & MARGARET	DECLARATION OF TRUST	EDWARDS	90540	BROWNS	957000	9570	295991.2711	0	0	20960	20960					—	121.7104	140.3729	131.2114		0021 \| FARM PROPERTY WITHOUT BU…	PERSON	-1,QSW,S15,T2S,R14 L B P N1/2 S…	2S	15	14W	S15 T2S R14W	2026.2	2024
10-21-300-001	17	047		IL	SMITH DAN TRUST	250E	EDWARDS	90954	DIXON	957000	9570	163220.0667	0	0	10540	10540					—	113.4433	117.9195	115.7653		0021 \| FARM PROPERTY WITHOUT BU…	TRUST	-1,QSW,S21,T2S,R10 L B P NW1/4 …	2S	21	10E	S21 T2S R10E	2026.2	2024
03116501	17	047		IL	HORTIN KENT A REVOCABLE TRUST &…		EDWARDS	90954	DIXON	957000	9570	323093.4558	0	0	28740	28740	2017-07-17				—	116.3694	127.9782	120.4633		0021 \| FARM PROPERTY WITHOUT BU…	TRUST	-1,QNW,S27,T2S,R10 L B P PT NW1…	2S	27	10E	S27 T2S R10E	2026.2	2024
03209408	17	047		IL	CITY OF ALBION		EDWARDS	90039	ALBION NO. 1	957100	9571	929.1307	0	0	0	0		1			—	167.7611	169.3920	168.6739		0090	GOVERNMENT	-2,Q S T R L094,B000,P208 OUTLO…	2S	1	10E	S1 T2S R10E	2026.2	2024
09-18-200-005	17	047		IL	HARMS DONALD & JOLENE	FAMILY LIMITED PARTNERSHIP	EDWARDS	90486	BONE GAP	956900	9569	244156.9816	0	0	17160	17160					—	128.0282	139.8241	134.2992		0021 \| FARM PROPERTY WITHOUT BU…	PERSON	-1,QNE,S18,T1S,R14 L B P E1/2 N…	1S	18	14W	S18 T1S R14W	2026.2	2024
04-17-100-004	17	047		IL	HARRIS ROBERT + WF		EDWARDS	93153	SHELBY NO. 1	956900	9569	2056.9769	0	2850	0	2850					—	121.5549	129.4418	128.3115		0030 \| RESIDENTIAL VACANT LOTS	PERSON	-1,QNW,S17,T1N,R10 L B P PT NE …	1N	17	10E	S17 T1N R10E	2026.2	2024
10-35-200-010	17	047		IL	PFENDER JOHN		EDWARDS	90954	DIXON	957000	9570	81822.9282	0	0	275	275					—	135.4543	156.6814	146.8501		0029 \|	PERSON	-1,QNE,S35,T2S,R10 L B P S1/2 S…	2S	35	10E	S35 T2S R10E	2026.2	2024
05116207	17	047		IL	RURAL WABASH CO WATER DIST		EDWARDS	90540	BROWNS	957000	9570	455.1515	0	0	0	0					—	120.6997	121.6877	121.2604		0090	PERSON	-1,QSW,S33,T1S,R14 L B P PT SW …	1S	33	14W	S33 T1S R14W	2026.2	2024
13-04-200-004	17	047		IL	GRAVEYARD		EDWARDS	90954	DIXON	957000	9570	6327.6273	0	0	0	0					—	137.0164	142.0010	139.6325		0090	NONPROFIT	-1,QNE,S04,T3S,R10 L B P PT SW1…	3S	4	10E	S4 T3S R10E	2026.2	2024
09-17-400-003	17	047		IL	HARMS DANIEL CARL & BECKY		EDWARDS	90486	BONE GAP	956900	9569	168280.2754	0	0	13250	13250					—	120.6449	125.9783	122.8450		0021 \| FARM PROPERTY WITHOUT BU…	PERSON	-1,QSE,S17,T1S,R14 L B P PT SW …	1S	17	14W	S17 T1S R14W	2026.2	2024
09-32-200-001	17	047		IL	DOHERTY ROBYLEE K TRUST		EDWARDS	90540	BROWNS	957000	9570	73928.3284	0	0	5100	5100					—	129.1813	132.0365	130.8072		0021 \| FARM PROPERTY WITHOUT BU…	TRUST	SEC 32 1S 14W PT N 1/2 NW NE 16…	1S	32	14W	S32 T1S R14W	2026.2	2024