Saved query 025380075de635a7

Data Explorer

Query the US Nationwide Parcel Dataset

$1.75 / 1,000 records$100 minimum

36/80

Live SQL

SELECT * 
FROM "lr_parcel_us" 
WHERE statefp = '39' 
  AND countyfp = '143'

33,467 matching parcels

Data Preview

parcelid	statefp	countyfp	parceladdr	parcelstate	ownername	owneraddr	countyname	cousubfp	cousubname	tractce	tractname	calcarea	numbldgs	numunits	numfloors	fldzone	elevmin	elevmax	elevavg	ownertype	township	section	range	plssdesc	placename	placetype	lrversion	taxyear
39143-300000000000	39	143	572 PARKLANE DR	OH			SANDUSKY	86506	WOODVILLE	961000	9610	566907.4712	2	299	1	—	188.0619	198.3084	193.6810						TJS	ELEMENTARY_SCHOOL	2026.2	2024
39143-326000002508	39	143	271 OTT ST	OH	PULIZZI STEPHEN V	271 OTT ST CLYDE 43410	SANDUSKY	16308	CLYDE	962000	9620	715.7548				—	202.6446	205.1492	204.0038	PERSON	4N	14	16E	S14 T4N R16E			2026.2	2023
39143-325000138200	39	143	328 ARCH ST	OH	MAYES BONNIE L	328 ARCH ST CLYDE 43410	SANDUSKY	16308	CLYDE	962000	9620	1514.0007				—	213.2044	213.6959	213.4042	PERSON	4N	13	16E	S13 T4N R16E			2026.2	2023
39143-325000220400	39	143	720 AMES ST	OH	ROSE BARBARA J	720 AMES ST CLYDE 43410	SANDUSKY	16308	CLYDE	962000	9620	508.1219				—	213.9901	214.4401	214.1956	PERSON	4N	13	16E	S13 T4N R16E			2026.2	2023
39143-233400000801	39	143	5834 CRK 1	OH	BENDER CHAD F	5834 CR 1 KANSAS 44841	SANDUSKY	71087	SCOTT	961200	9612	2277.9937				—	215.9100	217.1388	216.1371	PERSON	4N	34	13E	S34 T4N R13E			2026.2	2023
39143-345000386100	39	143	1021 NORTH ST	OH	WURGESS BETH A	1019 NORTH ST FREMONT 43420	SANDUSKY	28826	FREMONT	961500	9615	731.8105	1	2	1	—	189.4399	190.0689	189.6630	PERSON							2026.2	2023
39143-325000061901	39	143	104 S MAIN ST	OH	SCHOOL CLYDE BOARD OF ED	CLYDE 43410	SANDUSKY	16308	CLYDE	962000	9620	127.2323				—	212.6589	212.8951	212.8063	PERSON	4N	13	16E	S13 T4N R16E			2026.2	2023
39143-345000347200	39	143	533 CLOVER ST	OH	ESPINOZA GALE	533 CLOVER ST FREMONT 43420	SANDUSKY	28826	FREMONT	961400	9614	604.1843	2	1	1	—	181.4039	186.4197	184.0126	PERSON							2026.2	2023
39143-325000080300	39	143		OH	SMITH JAMES A	PO BOX 134 CLYDE 43410	SANDUSKY	16308	CLYDE	962000	9620	1008.7053				—	211.7762	212.5525	212.0557	PERSON	4N	23	16E	S23 T4N R16E			2026.2	2023
39143-082300002400	39	143		OH	C W M HOLDINGS INC	PO BOX 1450 CHICAGO 60690	SANDUSKY	67188	RILEY	960800	9608	23630.7590				—	183.5530	190.7582	186.0422	BUSINESS	5N	23	16E	S23 T5N R16E			2026.2	2023
39143-305000025900	39	143		OH	VILLAGE OF WOODVILLE	WOODVILLE 43469	SANDUSKY	86506	WOODVILLE	961000	9610	613.2628				—	190.8104	191.3389	191.0713	GOVERNMENT	6N	28	13E	S28 T6N R13E			2026.2	2023
39143-305000001600	39	143		OH	CHURCH UNITED METHODIST	WOODVILLE 43469	SANDUSKY	86506	WOODVILLE	961000	9610	832.2454				—	193.5035	194.0521	193.6910	NONPROFIT	6N	28	13E	S28 T6N R13E			2026.2	2023
39143-325000114000	39	143		OH	CITY OF CLYDE	CLYDE 43410	SANDUSKY	16308	CLYDE	962000	9620	994.7482				—	211.2961	212.0524	211.6073	GOVERNMENT	4N	23	16E	S23 T4N R16E			2026.2	2023
39143-325000010100	39	143		OH	CITY OF CLYDE	P O BOX 180 CLYDE 43410	SANDUSKY	16308	CLYDE	962000	9620	481.4713				—	211.8221	212.3387	212.0418	GOVERNMENT	4N	13	16E	S13 T4N R16E			2026.2	2023
39143-325000065300	39	143		OH	W & L E RR CO	CLYDE 43410	SANDUSKY	16308	CLYDE	962000	9620	792.5577				—	208.5581	209.4495	208.9333	BUSINESS	4N	14	16E	S14 T4N R16E			2026.2	2023
39143-325000114100	39	143		OH	CITY OF CLYDE	CLYDE 43410	SANDUSKY	16308	CLYDE	962000	9620	995.6683				—	211.5058	212.2970	211.8952	GOVERNMENT	4N	23	16E	S23 T4N R16E			2026.2	2023
39143-325000037400	39	143		OH	CHURCH ST PAULS EVAN LUT	P O BOX 296 CLYDE 43410	SANDUSKY	16308	CLYDE	962000	9620	1002.7185				—	211.9898	212.3487	212.1888	NONPROFIT	4N	14	16E	S14 T4N R16E			2026.2	2023
39143-275000079900	39	143		OH	ANDERSON`S INC THE	PO BOX 119 MAUMEE 43537	SANDUSKY	46592	MADISON	961100	9611	709.9604				—	206.9407	207.5988	207.1768	BUSINESS	5N	14	13E	S14 T5N R13E			2026.2	2023
39143-132600000204	39	143		OH	CROWN BATTERY MANUFACTURI	P O BOX 990 FREMONT 43420	SANDUSKY	28826	FREMONT	961700	9617	898.5385				—	174.4984	188.6310	182.8707	PERSON	5N	26	15E	S26 T5N R15E			2026.2	2023
39143-345000406800	39	143	711 RAWSON AVE	OH	LEWIS THOMAS E	1023 NORTH ST FREMONT 43420	SANDUSKY	28826	FREMONT	961700	9617	698.8885	1	1	1	—	188.5819	190.0330	189.5504	PERSON							2026.2	2023
39143-345000462900	39	143	711 HARMON ST	OH	HENSON MARK	711 HARMON ST FREMONT 43420	SANDUSKY	28826	FREMONT	961800	9618	440.7646	1	1	1	—	191.4466	191.7535	191.6153	PERSON							2026.2	2023
39143-345000018600	39	143	217 N WOOD ST	OH	TAYLOR ANGELA L	217 N WOOD ST FREMONT 43420	SANDUSKY	28826	FREMONT	961400	9614	452.7548	1	1	2	—	191.3725	191.7700	191.5731	PERSON							2026.2	2023
39143-345000551700	39	143	906 SOUTH ST	OH	MUSSER BROOKE L	906 SOUTH ST FREMONT 43420	SANDUSKY	28826	FREMONT	961400	9614	1080.1285	1	1	1	—	181.1259	181.9027	181.4558	PERSON							2026.2	2023
39143-345000366200	39	143	261 NORTH ST	OH	CLOUSER CLAUDETTE	261 NORTH ST FREMONT 43420	SANDUSKY	28826	FREMONT	961700	9617	1742.5850	2	1	1	—	180.1407	189.6131	187.3247	PERSON							2026.2	2023
39143-345000041400	39	143		OH	MILLER STEVEN J & CRAIG A	PO BOX 104 FREMONT 43420	SANDUSKY	28826	FREMONT	961400	9614	518.3596	1	1	1	—	179.4621	180.3428	180.0235	PERSON							2026.2	2023