Saved query 558cd35cab71e116

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

52,727 matching parcels

Data Preview

parcelid	statefp	countyfp	parceladdr	parcelcity	parcelstate	parcelzip	owneraddr	ownercity	ownerstate	ownerzip	countyname	cousubfp	cousubname	tractce	tractname	calcarea	numbldgs	firmid	firmdate	fldzone	zonesubty	elevmin	elevmax	elevavg	usecode	usedesc	taxacres	naicscode	parceltype	accesstype	placename	placetype
39003-38060002004002	39	003	N DIXIE HWY LIMA 45807	JACKSON	OH	45801	N DIXIE HWY LIMA	LIMA	OH	45807	Allen	37646	Jackson	011400	114	8208.0873	0	39003C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	265.8775	267.5559	266.7841	999	999	1.7500	71391	GOVT LOCAL	OPEN	GOLF AT SUGAR CREEK	LOCAL RECREATION AREA
39003-37301106014000	39	003	447-459 N ELIZABETH ST LIMA 458…	LIMA	OH	45801	447-459 N ELIZABETH ST LIMA	LIMA	OH	45801	Allen	43554	Lima	012400	124	3038.5432	1	39003C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	268.7601	271.1557	270.3069	350: Ind-Warehouse	350: Ind-Warehouse	0.7100	56174			MID-AMERICAN CLEANING CONTRACTO…	PROFESSIONAL_SERVICE
39003-37320709019000	39	003	1321 E ELM ST LIMA 45804	LIMA	OH	45804	1321 E ELM ST LIMA	LIMA	OH	45804	Allen	43554	Lima	012600	126	3040.3138	1	39003C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	266.5522	268.1398	267.4521	685: Exm-Public Woship	685: Exm-Public Woship	0.7500	8141			NORTH PARK COMMUNITY CHURCH	CHRISTIAN_PLACE_OF_WORSHIP
39003-25300704002002	39	003	202 S MAIN ST DELPHOS 45833	DELPHOS	OH	45833	202 S MAIN ST	DELPHOS	OH	45833	Allen	47656	Marion	013900	139	1799.7237	2	39003C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	236.7951	237.7934	237.3088	452: Com-Auto Service	452: Com-Auto Service	0.4500	457110			SPEEDWAY	GAS_STATION
39003-25191203003000	39	003	903 E 5TH ST DELPHOS 45833	DELPHOS	OH	45833	903 E 5TH ST	DELPHOS	OH	45833	Allen	47656	Marion	014000	140	926.4655	1	39003C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	234.3294	234.9734	234.6742	420: Com-Retail-Small	420: Com-Retail-Small	0.3000	8123			ADVANTAGE CLEANERS	LAUNDRY_SERVICE
39003-36360517004501	39	003	750 W HIGH ST LIMA 45801	LIMA	OH	45801	750 W HIGH ST LIMA	LIMA	OH	45801	Allen	43554	Lima	012900	129	3571.3283	2	39003C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	269.3480	271.2143	270.3291	450: Com-Condo	450: Com-Condo	0	6223			WEST OHIO DERMATOLOGY	SPECIALIZED_HEALTH_CARE
39003-38240002002000	39	003	2330 BENTLEY RD ADA 45810	JACKSON	OH	45810	2330 BENTLEY RD ADA	ADA	OH	45810	Allen	37646	Jackson	011400	114	107889.2190	1	39003C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	283.5012	288.8998	285.9849	199: Agr-CAUV-Other	199: Agr-CAUV-Other	26.7300	6216			BIERLY G H WELL DRILLING INC	HOME_SERVICE
39003-37270201015000	39	003	1411 FETTER RD LIMA 45801	BATH	OH	45801	1411 FETTER RD LIMA	LIMA	OH	45801	Allen	04206	Bath	011301	113.0100	1832.1907	1	39003C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	263.7724	266.7677	265.5409	510: Res-Single Family	510: Res-Single Family	0.4600
39003-37311206035000	39	003	660 HARRISON AVE LIMA 45805	LIMA	OH	45804	660 HARRISON AVE LIMA	LIMA	OH	45805	Allen	43554	Lima	012700	127	326.2834	1	39003C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	266.8035	267.2672	267.0193	510: Res-Single Family	510: Res-Single Family	0.0700
39003-36070905011000	39	003	206 ORIOLE TRL LIMA 45807	ELIDA	OH	45807	206 ORIOLE TRL LIMA	LIMA	OH	45807	Allen	01756	American	010801	108.0100	1276.1666	1	39003C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	240.0087	241.2003	240.7923	510: Res-Single Family	510: Res-Single Family	0.3200
39003-47070506005000	39	003	626 E 5TH ST LIMA 45804	LIMA	OH	45804	626 E 5TH ST LIMA	LIMA	OH	45804	Allen	43554	Lima	013800	138	630.7537	1	39003C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	269.9372	270.7746	270.5150	510: Res-Single Family	510: Res-Single Family	0.1500
39003-46010801001001	39	003	319 W VINE ST LIMA 45804	LIMA	OH	45804	319 W VINE ST LIMA	LIMA	OH	45804	Allen	43554	Lima	013400	134	346.3878	0	39003C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	267.2116	267.9772	267.7523	500: Res-Vacant Land	500: Res-Vacant Land	0.0900
39003-36200205002000	39	003	5027 LOBO ST LIMA 45807	AMERICAN	OH	45807	5027 LOBO ST LIMA	LIMA	OH	45807	Allen	01756	American	010801	108.0100	803.0789	1	39003C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	246.7147	247.8617	247.5565	510: Res-Single Family	510: Res-Single Family	0.2000
39003-28280003005000	39	003	E LINCOLN HWY BLUFFTON 45817	RICHLAND	OH	45817	E LINCOLN HWY	BLUFFTON	OH	45817	Allen	66614	Richland	010200	102	154095.3529	0	39003C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	258.9450	269.4997	264.3114	110: Agr-CAUV-Vacant Land	110: Agr-CAUV-Vacant Land	38.5700
39003-36210003010013	39	003	3915 CHEROKEE DR LIMA 45807	AMERICAN	OH	45807	3915 CHEROKEE DR LIMA	LIMA	OH	45807	Allen	01756	American	010801	108.0100	10239.4218	2	39003C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	249.4791	253.0914	251.9077	680: Exm-Charitable	680: Exm-Charitable	2.5700
39003-36070002009000	39	003	4144 N KEMP RD LIMA 45807	AMERICAN	OH	45807	4144 N KEMP RD LIMA	LIMA	OH	45807	Allen	01756	American	010300	103	2139.5017	2	39003C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	240.8485	241.5552	241.1513	511: Res-Custom Code	511: Res-Custom Code	0.4600
39003-47340001003001	39	003	3410 AMHERST RD LIMA 45806	PERRY	OH	45806	3410 AMHERST RD LIMA	LIMA	OH	45806	Allen	61742	Perry	011600	116	9518.1353	2	39003C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	281.3157	283.1675	282.1216	511: Res-Custom Code	511: Res-Custom Code	2.5000
39003-28110001001005	39	003	303 PARKVIEW DR BLUFFTON 45817	BLUFFTON	OH	45817	303 PARKVIEW DR	BLUFFTON	OH	45817	Allen	66614	Richland	010100	101	1338.4088	0	39003C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	251.5471	254.1190	252.9176	500: Res-Vacant Land	500: Res-Vacant Land	0.3300
39003-36170502004000	39	003	706 SUNNYDALE ST LIMA 45807	ELIDA	OH	45807	706 SUNNYDALE ST LIMA	LIMA	OH	45807	Allen	01756	American	010801	108.0100	6047.9438	2	39003C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	245.3126	246.9503	246.0237	510: Res-Single Family	510: Res-Single Family	2.3000
39003-25300605012000	39	003	235 N PIERCE ST DELPHOS 45833	DELPHOS	OH	45833	235 N PIERCE ST	DELPHOS	OH	45833	Allen	47656	Marion	013900	139	687.2661	2	39003C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	235.3566	236.0480	235.8366	510: Res-Single Family	510: Res-Single Family	0.1700
39003-37311208005000	39	003	415 MCPHERON AVE LIMA 45804	LIMA	OH	45804	415 MCPHERON AVE LIMA	LIMA	OH	45804	Allen	43554	Lima	012700	127	856.1058	2	39003C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	262.8468	264.2015	263.2652	510: Res-Single Family	510: Res-Single Family	0.2200
39003-36360608041000	39	003	213 N COLLETT ST LIMA 45805	LIMA	OH	45801	213 N COLLETT ST LIMA	LIMA	OH	45805	Allen	43554	Lima	012900	129	641.7673	0	39003C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	264.2770	265.2590	264.8261	680: Exm-Charitable	680: Exm-Charitable	0.1700
39003-46020702002000	39	003	884 BERRYMAN BLVD LIMA 45805	SHAWNEE	OH	45805	884 BERRYMAN BLVD LIMA	LIMA	OH	45805	Allen	71955	Shawnee	011800	118	619.7696	1	39003C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	268.9543	269.7368	269.4357	510: Res-Single Family	510: Res-Single Family	0.1600
39003-48180003001000	39	003	6358 MCPHERON RD LIMA 45804	VALLEY CITY	OH	45804	6358 MCPHERON RD LIMA	LIMA	OH	45804	Allen	02988	Auglaize	011500	115	1759.0125	0	39003C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	286.8311	289.0351	288.0177	510: Res-Single Family	510: Res-Single Family	0.4400
39003-47071120004000	39	003	W 17TH ST LIMA 45804	PERRY	OH	45804	W 17TH ST LIMA	LIMA	OH	45804	Allen	61742	Perry	013800	138	420.5558	1	39003C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	268.9066	269.2594	269.0340	599: Res-Other	599: Res-Other	0.1200