Saved query 0c62e2da8e95e783

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 = '39' 
  AND countyfp = '011'

28,708 matching parcels

Data Preview

parcelid	statefp	countyfp	parceladdr	parcelcity	parcelstate	parcelzip	owneraddr	ownercity	ownerstate	ownerzip	countyname	cousubfp	cousubname	tractce	tractname	calcarea	numbldgs	numunits	numfloors	firmid	firmdate	fldzone	zonesubty	elevmin	elevmax	elevavg	usecode	usedesc	taxacres	naicscode	placename	placetype
39011-K3206209100	39	011	1730 CELINA RD ST MARYS 45885	ST MARYS	OH	45885	1730 CELINA RD	ST MARYS	OH	45885	Auglaize	69694	St. Marys	041202	412.0200	28118.6112	34			39011C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	268.2875	273.6108	271.5982	439: Com-Other Food	439: Com-Other Food	6.9300	722511	DAVE'S BARBEQUE & CATE	RESTAURANT
39011-B0709505101	39	011	0 S BLACKHOOF ST	WAPAKONETA	OH	45895	S PERRY ST	WAPAKONETA	OH	45895	Auglaize	22722	Duchouquet	040300	403	1468.6330	0			39011C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	273.9284	275.0425	274.4988	640: Exm-Municipality	640: Exm-Municipality	0.3700	3364	NEUMAN'S WELDING	MANUFACTURER
39011-E1534100214	39	011	351 INDUSTRIAL DR MINSTER 45865	MINSTER	OH	45865	351 INDUSTRIAL DR	MINSTER	OH	45865	Auglaize	37674	Jackson	041000	410	10138.2991	2			39011C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	290.2232	293.8305	293.2560	350: Ind-Warehouse	350: Ind-Warehouse	2.5099	8134	HARMONY FOR OHIO FOUNDATION	CIVIC_ORGANIZATION
39011-B0782205800	39	011	0 DEFIANCE ST	WAPAKONETA	OH	45895	404 HAMILTON ST	WAPAKONETA	OH	45895	Auglaize	22722	Duchouquet	040400	404	1916.5284	0			39011C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	281.9061	282.8006	282.2868	499: Com-Other	499: Com-Other	0	4242	WAPAK SMOKE SHOP	FOOD_AND_BEVERAGE_STORE
39011-C1000401700	39	011	101 S WASHINGTON ST NEW BREMEN …	NEW BREMEN	OH	45869	40-44 S WASHINGTON ST	NEW BREMEN	OH	45869	Auglaize	29848	German	040900	409	770.8051	1			39011C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	287.2702	289.3837	289.1178	447: Com-Office	447: Com-Office	0	6212	NEW BREMEN SMILES	DENTAL_CLINIC
39011-C1000305900	39	011	110 S FRANKLIN ST	NEW BREMEN	OH	45869	110 S FRANKLIN ST	NEW BREMEN	OH	45869	Auglaize	29848	German	040900	409	878.0517	1			39011C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	287.7252	289.4214	288.7970	510: Res-Single Family	510: Res-Single Family	0	71212	ADOLPH BOESEL HOUSE	HISTORIC_SITE
39011-E1501009000	39	011	181 N MAIN ST	MINSTER	OH	45865	PO BOX 99 MINSTER 45865	MINSTER	OH	45865	Auglaize	37674	Jackson	041000	410	1411.2797	1			39011C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	295.5187	296.4091	295.8641	420: Com-Retail-Small	420: Com-Retail-Small	0	4911	RUFF REVIVAL	ANIMAL_OR_PET_SERVICE
39011-E1502701500	39	011	179 OHIO ST MINSTER 45865	MINSTER	OH	45865	65 SOUTHMOOR SHORES DR	ST MARYS	OH	45885	Auglaize	37674	Jackson	041000	410	11059.4282	3			39011C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	293.0576	293.8311	293.4078	350: Ind-Warehouse	350: Ind-Warehouse	2.6600	2379	HEYNE CONSTRUCTION	HOME_SERVICE
39011-K3201501200	39	011	220 E SPRING ST ST MARYS 45885	ST MARYS	OH	45885	840 W SPRING ST	ST MARYS	OH	45885	Auglaize	69694	St. Marys	040600	406	302.7393	1	1	2	39011C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	266.0070	266.5449	266.2887	420: Com-Retail-Small	420: Com-Retail-Small	0
39011-B0704000300	39	011	610 S WILLIPIE ST	WAPAKONETA	OH	45895	610 WILLIPIE ST	WAPAKONETA	OH	45895	Auglaize	22722	Duchouquet	040300	403	694.7512	2			39011C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	272.6940	273.3694	272.9669	510: Res-Single Family	510: Res-Single Family	0
39011-K3201701300	39	011	405 N SPRUCE ST ST MARYS 45885	ST MARYS	OH	45885	405 N SPRUCE ST	ST MARYS	OH	45885	Auglaize	69694	St. Marys	040600	406	1189.8221	1			39011C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	264.9287	267.5029	266.5996	510: Res-Single Family	510: Res-Single Family	0.3000
39011-B0702702900	39	011	606 S BUCHANAN ST	WAPAKONETA	OH	45895	606 S BUCHANAN ST	WAPAKONETA	OH	45895	Auglaize	22722	Duchouquet	040400	404	1023.6275	2			39011C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	272.5682	273.2440	272.9038	510: Res-Single Family	510: Res-Single Family	0.2500
39011-E1500101500	39	011	210 OHIO ST	MINSTER	OH	45865	315 W FIRST ST	MINSTER	OH	45865	Auglaize	37674	Jackson	041000	410	1408.4093	1			39011C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	292.1966	294.6935	293.6721	480: Com-Warehouse	480: Com-Warehouse	0
39011-J2703301000	39	011	2629 MARBAUGH RD SPENCERVILLE 4…	SPENCERVILLE	OH	45887	2629 MARBAUGH RD	SPENCERVILLE	OH	45887	Auglaize	69806	Salem	040500	405	12623.2505	5			39011C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	248.1513	251.2747	250.0823	511: Res-Custom Code	511: Res-Custom Code	3.1200
39011-F2000104200	39	011	101 S MAIN ST	BUCKLAND	OH	45819	101 S MAIN ST	BUCKLAND	OH	45819	Auglaize	44618	Logan	040500	405	1257.8109	1			39011C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	260.2201	261.4976	261.1149	520: Res-Two Family	520: Res-Two Family	0.2200
39011-K3205605000	39	011	209 N DEFIANCE RD ST MARYS 45885	ST MARYS	OH	45885	209 N DEFIANCE ST	ST MARYS	OH	45885	Auglaize	69694	St. Marys	041202	412.0200	3652.7747	1			39011C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	270.5875	272.5500	271.9192	510: Res-Single Family	510: Res-Single Family	0.9000
39011-B0791200905	39	011	0 LUNAR DR	WAPAKONETA	OH	45895	1400 LUNAR DR	WAPAKONETA	OH	45895	Auglaize	22722	Duchouquet	040300	403	10002.8808	0			39011C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	276.9584	279.1712	277.5582	400: Com-Vacant Land	400: Com-Vacant Land	2.4900
39011-B0602202300	39	011	312 SHAWNEE RD	LIMA	OH	45806	312 SHAWNEE RD	CRIDERSVILLE	OH	45806	Auglaize	22722	Duchouquet	040200	402	828.5893	2			39011C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	268.5673	269.1807	268.9653	510: Res-Single Family	510: Res-Single Family	0
39011-K3201512600	39	011	502 E SPRING ST	ST MARYS	OH	45885	502 E SPRING ST	ST MARYS	OH	45885	Auglaize	69694	St. Marys	040600	406	525.2628	2			39011C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	267.8440	269.3347	268.5099	510: Res-Single Family	510: Res-Single Family	0
39011-B0700608300	39	011	409 W MECHANIC ST	WAPAKONETA	OH	45895	409 W MECHANIC ST	WAPAKONETA	OH	45895	Auglaize	22722	Duchouquet	040400	404	463.4568	2			39011C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	270.0513	271.2070	270.7740	510: Res-Single Family	510: Res-Single Family	0
39011-F1702001200	39	011	7298 DEEP CUT RD	SPENCERVILLE	OH	45887	7298 DEEP CUT RD	SPENCERVILLE	OH	45887	Auglaize	44618	Logan	040500	405	326658.4375	4			39011C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	257.8350	267.3619	262.5182	111: Agr-CAUV-Cash-Grain Farm	111: Agr-CAUV-Cash-Grain Farm	80.7200
39011-E1500601700	39	011	177 S HANOVER ST	MINSTER	OH	45865	113 S HANOVER ST	MINSTER	OH	45865	Auglaize	37674	Jackson	041000	410	1407.6893	1			39011C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	289.8290	291.3707	290.7082	510: Res-Single Family	510: Res-Single Family	0.3500
39011-J2803200302	39	011	1040 HESSE RD	SPENCERVILLE	OH	45887	3066 GLENMORE AVE	CINCINNATI	OH	45238	Auglaize	69806	Salem	040500	405	16179.9942	2			39011C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	246.1988	250.5974	248.8506	511: Res-Custom Code	511: Res-Custom Code	4
39011-E1402400100	39	011	5358 AMSTERDAM RD MINSTER 45865	MINSTER	OH	45865	5353 AMSTERDAM RD	MINSTER	OH	45865	Auglaize	37674	Jackson	041000	410	324918.5967	4			39011C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	293.7901	298.1323	296.2435	111: Agr-CAUV-Cash-Grain Farm	111: Agr-CAUV-Cash-Grain Farm	80
39011-B0601201200	39	011	323 E MAIN ST CRIDERSVILLE 45806	LIMA	OH	45806	323 E MAIN ST	CRIDERSVILLE	OH	45806	Auglaize	22722	Duchouquet	040200	402	687.7039	2			39011C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	271.4912	272.4473	271.8577	510: Res-Single Family	510: Res-Single Family	0