Saved query 0e34eab1a7031d63

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 = '18' 
  AND countyfp = '047'

17,374 matching parcels

Data Preview

parcelid	taxacctnum	statefp	countyfp	parceladdr	parcelcity	parcelstate	parcelzip	countyname	cousubfp	cousubname	tractce	tractname	calcarea	fldzone	elevmin	elevmax	elevavg	usecode	naicscode	township	placename	placetype	lrversion
241201400004000022		18	047		VOTE	IN	25051	FRANKLIN	63126	RAY	960100	9601	20968.1057	—	284.5547	293.2155	287.3642	101		RAY TOWNSHIP			2026.2
241735300002000021		18	047	1028 JOHNSON FORK RD		IN		FRANKLIN			969600	9696	532700.5512	—	188.5302	245.5957	217.3765	101	6216	WHITEWATER TOWNSHIP	ORSCHELL EXCAVATING	HOME_SERVICE	2026.2
240101100001000013	240101100001000013	18	047	25124 KOKOMO HILL RD		IN		FRANKLIN	61326	POSEY	969900	9699	556227.0864	—	270.1549	315.3245	292.8458	101		POSEY TOWNSHIP	WOODLAND RETREAT LODGE	PRIVATE_LODGING	2026.2
240112200001001013		18	047			IN	14182	FRANKLIN	61326	POSEY	969900	9699	20260.9617	—	305.0420	310.4015	305.9922	101		POSEY TOWNSHIP			2026.2
241633300003000008		18	047	10121 COUNTY LINE RD		IN		FRANKLIN			969600	9696	47358.5039	—	302.0529	304.2035	303.4665	101		HIGHLAND TOWNSHIP	ZELDA JEAN'S 2.0	FLOWERS_AND_GIFTS_STORE	2026.2
240124400001000013		18	047	CHAPEL RD		IN		FRANKLIN	61326	POSEY	969900	9699	3978.0277	—	270.9007	300.7210	278.9230	501		POSEY TOWNSHIP			2026.2
240832200005000005		18	047	17198 ST MARYS RD		IN		FRANKLIN	09568	BUTLER	969800	9698	633.9875	—	294.3395	298.3795	295.5489	501		BUTLER TOWNSHIP			2026.2
240820200002000005		18	047	TREE RD		IN		FRANKLIN	09568	BUTLER	969800	9698	163041.2967	—	275.3214	298.3812	290.7554	100		BUTLER TOWNSHIP			2026.2
241317240023000015		18	047	363 WOODSIDE CT		IN		FRANKLIN	63126	RAY	960100	9601	1400.5746	—	296.7922	297.8166	297.2780	510		RAY TOWNSHIP			2026.2
240113441016000013		18	047	LAKE ST		IN		FRANKLIN	61326	POSEY	969900	9699	513.1077	—	303.5713	305.9843	304.5624	500		POSEY TOWNSHIP			2026.2
241304466007000016		18	047	22067 ST MARYS RD		IN		FRANKLIN	63126	RAY	960100	9601	2026.7579	—	286.5131	289.3513	288.5358	510		RAY TOWNSHIP			2026.2
240304400007006002		18	047		BROOKVILLE	IN	47012	FRANKLIN	05824	BLOOMING GROVE	969800	9698	2007.1647	—	265.9675	275.0203	270.6907			BLOOMING GROVE TOWNSHIP			2026.2
241008400001008003		18	047		BROOKVILLE	IN	47012	FRANKLIN	08200	BROOKVILLE	969800	9698	192084.2615	—	301.7596	310.3613	308.2716			BROOKVILLE TOWNSHIP			2026.2
241318301020000015		18	047		BATESVILLE	IN	47006	FRANKLIN	63126	RAY	960100	9601	1486.0849	—	290.1091	292.5928	291.7021			RAY TOWNSHIP			2026.2
241029254007000004		18	047	219 E 4TH ST		IN		FRANKLIN	08200	BROOKVILLE	969700	9697	711.2248	—	190.4660	191.2738	190.7738	510		BROOKVILLE TOWNSHIP			2026.2
240735400001002024		18	047	HEPPNER RD		IN		FRANKLIN	09568	BUTLER	969800	9698	6011.7387	—	285.6119	294.4353	290.5958	501		BUTLER TOWNSHIP			2026.2
240209461011000011		18	047	155 MAIN ST		IN		FRANKLIN	42390	LAUREL	969900	9699	1650.6790	—	218.4707	219.1784	218.6973	510		LAUREL TOWNSHIP			2026.2
240425101129000007		18	047	WILDERNESS WAY LOT 129		IN		FRANKLIN	22306	FAIRFIELD	969600	9696	312.3138	—	303.0206	303.6131	303.3514	599		FAIRFIELD TOWNSHIP			2026.2
241725200008000021		18	047	2138 STATE LINE RD		IN		FRANKLIN	84068	WHITEWATER	969600	9696	3888.5523	—	266.6194	268.7566	267.9770	511		WHITEWATER TOWNSHIP			2026.2
241317280025000015		18	047	215 LILLY LN		IN		FRANKLIN	63126	RAY	960100	9601	1115.4818	—	292.8055	295.5587	293.8288	500		RAY TOWNSHIP			2026.2
241623300004001008		18	047	2201 WEWE HILL RD		IN		FRANKLIN	33448	HIGHLAND	969600	9696	8155.6093	—	281.5805	301.4426	296.7883	511		HIGHLAND TOWNSHIP			2026.2
241021154001000004		18	047	9091 LEW WALLACE DR		IN		FRANKLIN	08200	BROOKVILLE	969700	9697	812.0542	—	208.7361	211.1299	209.9935	510		BROOKVILLE TOWNSHIP			2026.2
241319152004000015		18	047	89 WOODLAWN DR		IN		FRANKLIN	63126	RAY	960100	9601	3057.0891	—	289.1149	292.1110	291.4814	510		RAY TOWNSHIP			2026.2
240203200001007010		18	047	15184 OTT RD		IN		FRANKLIN	42390	LAUREL	969900	9699	17673.1295	—	220.5719	225.4590	222.6842	501		LAUREL TOWNSHIP			2026.2
241317478008000015		18	047	378 PHEASANT RUN		IN		FRANKLIN	63126	RAY	960100	9601	760.8543	—	296.2779	297.1969	297.0088	510		RAY TOWNSHIP			2026.2