Saved query 1cb1b211150ad352

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

136,665 matching parcels

Data Preview

parcelid	statefp	countyfp	parceladdr	parcelcity	parcelstate	parcelzip	ownername	owneraddr	ownercity	ownerstate	ownerzip	countyname	cousubfp	cousubname	tractce	tractname	calcarea	fldzone	elevmin	elevmax	elevavg	taxacres	ownertype	naicscode	parceltype	accesstype	iucnclass	placename	placetype	lrversion	taxdistrict
13-1-21-15-00-000-019	17	119	PLEASANT RIDGE RD	COLLINSVILLE	IL	62234	MADISON COUNTY MASS TRANSIT DIS…	ONE TRANSIT WAY PO BOX 7500	GRANITE CITY	IL	62040	MADISON	15612	COLLINSVILLE	403533	4035.3300	122643.1621	—	145.5555	171.7428	156.2163	30.3000	PERSON		GOVT LOCAL	OPEN		MCT SCHOOLHOUSE TRAIL SPUR	LOCAL RECREATION AREA	2026.2	COLLINSVILLE
22-2-20-17-06-102-022 001	17	119	3020 MADISON AVE	GRANITE CITY	IL	62040	GBR	GIBRALTAR MANAGEMENT CO INC 150…	TARRYTOWN	NY	10591	MADISON	30939	GRANITE CITY	400101	4001.0100	998.2898	—	127.5228	128.1826	127.9171	0.2500	BUSINESS					SHERWIN-WILLIAMS	HARDWARE_HOME_AND_GARDEN_STORE	2026.2	GRANITE CITY
10-1-16-01-00-000-004 003	17	119			IL		KING HILL CONSERVATION LLC	9370 FRUIT RD	ALHAMBRA	IL	62001	MADISON	60014	PIN OAK	403701	4037.0100	315962.7926	—	145.2419	149.8075	147.7692	78.0699	BUSINESS		NGO	CLOSED	V	777-048	CONSERVATION EASEMENT	2026.2
14-2-15-15-03-301-012	17	119	6181 BENNETT DR		IL	62025	PARKWAY PLAZA LLC	2808 THOLE PLOCHER RD	HIGHLAND	IL	62249	MADISON	22710	EDWARDSVILLE	403001	4030.0100	5441.9509	—	178.0859	180.0598	179.2237	1.3400	BUSINESS					EDWARDSVILLE BANK	BANK_OR_CREDIT_UNION	2026.2	EDWARDSVILLE
22-2-20-17-05-103-023	17	119	2817 MADISON AVE	GRANITE CITY	IL	62040	2817 PRESIDENT LAND TRUST	PO BOX 255	GRANITE CITY	IL	62040	MADISON	30939	GRANITE CITY	400101	4001.0100	431.7329	—	127.8115	128.3460	128.0262	0.1100	TRUST							2026.2	GRANITE CITY
13-2-21-33-09-102-031	17	119	1121 W MAIN ST	COLLINSVILLE	IL	62234	MEHMET E DINCEROGLU JR	4 GINGER WOOD EST	GLEN CARBON	IL	62034	MADISON	15612	COLLINSVILLE	403403	4034.0300	832.9744	—	170.4848	171.1847	170.9175	0.2100	PERSON							2026.2	COLLINSVILLE
19-2-08-13-03-303-010	17	119	W AIRLINE DR	EAST ALTON	IL	62024	ST LOUIS REGIONAL AIRPORT AUTHO…	8 TERMINAL DR STE 1	EAST ALTON	IL	62024	MADISON	83284	WOOD RIVER	401901	4019.0100	6051.2335	—	161.9200	164.8023	164.2814	1.5000	GOVERNMENT							2026.2	EAST ALTON
23-2-07-12-13-305-023	17	119	1213 LIBERTY ST	ALTON	IL	62002	BRAM D AND DREW T PONIVAS	1213 LIBERTY ST	ALTON	IL	62002	MADISON	01127	ALTON	402500	4025	563.4487	—	167.2424	167.8708	167.4976	0.1400	PERSON							2026.2	ALTON
24-2-01-34-01-111-014	17	119	1805 BISCAY DR	GODFREY	IL	62035	WALTER R MCDONALD	1805 BISCAY DR	GODFREY	IL	62035	MADISON	30094	GODFREY	402721	4027.2100	1914.0618	—	177.4464	182.3885	179.1113	0.4700	PERSON							2026.2	GODFREY
23-1-08-03-00-000-006 004	17	119	1 STOREY LN	ALTON	IL	62002	ERWIN R MILLER	6916 MELODY LN	EAST SAINT LOUIS	IL	62203	MADISON	01127	ALTON	401701	4017.0100	71395.0555	—	142.8392	150.4219	146.1459	17.6400	PERSON							2026.2	ALTON
24-2-01-35-01-103-022	17	119	2910 DORAL DR	GODFREY	IL	62035	MARK S AND DEBRA E POHLMAN	2910 DORAL DR	GODFREY	IL	62035	MADISON	30094	GODFREY	402721	4027.2100	2425.1586	—	173.6940	180.8923	177.6716	0.6000	PERSON							2026.2	GODFREY
02-2-18-32-19-403-025	17	119			IL		REHBERGER HOLDINGS LLC	3945 N NEENAH AVE	CHICAGO	IL	60634	MADISON	67275	SALINE	403604	4036.0400	1742.8505	—	161.9129	163.0909	162.3846	0.4300	BUSINESS	7225				MOLLY'S MOCHAS	CAFE	2026.2
19-2-08-26-05-102-001	17	119	E EDWARDSVILLE RD	WOOD RIVER	IL	62095	STEPHEN K SWEET	6990 STATE ROUTE 111	SOUTH ROXANA	IL	62087	MADISON	83284	WOOD RIVER	401102	4011.0200	271.4336	—	132.7846	133.2679	133.0810	0.0700	PERSON							2026.2	WOOD RIVER
05-1-23-25-00-000-006 001	17	119	403 BLUEMOUND RD	TRENTON	IL	62293	BRAD AND GWEN KUNZ	403 BLUEMOUND RD	TRENTON	IL	62293	MADISON	66872	ST. JACOB	403702	4037.0200	159394.7015	—	161.7879	176.9183	166.5422	39.3800	PERSON							2026.2	TRENTON
14-2-15-01-13-303-015	17	119	631 VOGE ST	EDWARDSVILLE	IL	62025	SCOTT K STAHLHUT	631 VOGE ST	EDWARDSVILLE	IL	62025	MADISON	22710	EDWARDSVILLE	402900	4029	672.1707	—	165.5852	166.7895	166.2026	0.1700	PERSON							2026.2	EDWARDSVILLE
10-2-16-18-06-101-035	17	119	124 SUGAR OAK CT	EDWARDSVILLE	IL	62025	RAMON J JR AND JANE M VOLTZ	124 SUGAR OAK CT	EDWARDSVILLE	IL	62025	MADISON	60014	PIN OAK	403701	4037.0100	949.7565	—	163.7428	164.7363	164.3371	0.2300	PERSON							2026.2	EDWARDSVILLE
22-2-20-05-18-302-028	17	119	4023 BRADEN AVE	GRANITE CITY	IL	62040	JEFFERY J AND META A FRY	RR2 BOX 65A	SORENTO	IL	62086	MADISON	51583	NAMEOKI	400904	4009.0400	654.5333	—	128.3182	128.9109	128.5149	0.1600	PERSON							2026.2	GRANITE CITY
23-1-07-11-13-302-022	17	119	440 BLUFF ST	ALTON	IL	62002	JAMES F JR AND CHERYL D HORN	440 BLUFF ST	ALTON	IL	62002	MADISON	01127	ALTON	402300	4023	715.1143	—	169.9143	180.4749	178.9295	0.1800	PERSON							2026.2	ALTON
24-1-01-05-00-000-001 002	17	119	AIRPORT RD	GODFREY	IL	62035	TWIN RIVERS STONE LLC	202 W MAIN ST	SALEM	IL	62881	MADISON	30094	GODFREY	402721	4027.2100	143823.4088	—	133.6818	162.7759	144.3313	35.5400	BUSINESS							2026.2	GODFREY
23-2-07-12-17-304-012	17	119	727 HUMBOLDT CT	ALTON	IL	62002	SYLVESTER JENNINGS JR	2880 WATALEE ST	ALTON	IL	62002	MADISON	01127	ALTON	402400	4024	314.0129	—	154.6968	155.9911	155.4416	0.0800	PERSON							2026.2	ALTON
14-2-15-27-02-201-017	17	119	3 GINGER WOOD EST	GLEN CARBON	IL	62034	ROBERT W JR AND NATALIE HAMM	3 GINGER WOOD EST	GLEN CARBON	IL	62034	MADISON	22710	EDWARDSVILLE	403121	4031.2100	10987.2950	—	158.5070	172.7671	165.5424	2.7100	PERSON							2026.2	GLEN CARBON
16-1-03-25-04-403-038	17	119	LAKE BED ST	WORDEN	IL	62097	HOLISHOR ASSN INC	1 HOLIDAY POINT PKWY	EDWARDSVILLE	IL	62025	MADISON	50465	MORO	402805	4028.0500	51382.8263	—	159.5113	161.5377	159.5582	12.7000	BUSINESS							2026.2	WORDEN
09-2-22-04-00-000-019 A00	17	119	407 EDWARDSVILLE RD		IL		TROY METHODIST CHURCH	407 EDWARDSVILLE RD	TROY	IL	62294	MADISON	38245	JARVIS	403531	4035.3100	81431.2625	—	167.0928	173.5709	171.0811	20.1200	NONPROFIT					TROY METHODIST CHURCH	CHRISTIAN_PLACE_OF_WORSHIP	2026.2	TROY
24-2-01-25-04-401-046	17	119	5205 RICHLAND WOODS DR	ALTON	IL	62002	AYSE GURSEL STROMSDORFER	5205 RICHLAND WOODS DR	ALTON	IL	62002	MADISON	30094	GODFREY	402801	4028.0100	7099.0050	—	161.4554	175.6038	169.0063	1.7500	PERSON							2026.2	ALTON
11-1-10-05-00-000-010	17	119	7240 QUERCUS GROVE RD	HAMEL	IL	62046	JOSHUA CADENBACH	520 E FERGUSON AVE	WOOD RIVER	IL	62095	MADISON	32421	HAMEL	403801	4038.0100	98836.3293	—	140.4283	145.5965	144.4770	24.4200	PERSON							2026.2	HAMEL