Saved query 0762e810cfe8977f

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

31,361 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	placename	placetype
39037-C15221322020210100	39	037	112 MAIN N	ANSONIA	OH	45303	161 S HANOVER ST	MINSTER	OH	45865	Darke	09414	Brown	520100	5201	1011.9018	1	39037C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	304.7830	305.6264	305.1644	447: Com-Office	447: Com-Office	0	491110	UNITED STATES POSTAL SERVICE	POST_OFFICE
39037-F27221226020411600	39	037	200 WAGNER AVE	GREENVILLE	OH	45331	6587 HELLER RD	GREENVILLE	OH	45331	Darke	32354	Greenville	555001	5550.0100	564.4818	1	39037C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	313.0790	313.5727	313.2712	470: Com-Custom Code	470: Com-Custom Code	0	523999	MARSHALL COMBS	FINANCIAL_SERVICE
39037-C15221322020810200	39	037	300 MAIN S	ANSONIA	OH	45303	300 S MAIN ST	ANSONIA	OH	45303	Darke	09414	Brown	520100	5201	2321.7309	1	39037C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	306.0752	306.6775	306.3701	429: Com-Other	429: Com-Other	2.3700	444	ANSONIA LUMBER CO	HARDWARE_HOME_AND_GARDEN_STORE
39037-A02031028000022300	39	037	6594 ARCANUM-BEARS MILL	GREENVILLE	OH	45331	6594 ARCANUM-BEARS MILL RD	GREENVILLE	OH	45331	Darke	00254	Adams	540100	5401	7811.4467	3	39037C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	300.9967	305.9403	303.1967	560: Res-Mobile Home	560: Res-Mobile Home	2.1300	4921	THE HIDDEN GEM	EVENT_OR_PARTY_SERVICE
39037-C15221323040211100	39	037	600 CANAL		OH	45303	600 CANAL ST	ANSONIA	OH	45303	Darke	09414	Brown	520100	5201	116277.6078	11	39037C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	303.7257	307.6911	305.2246	650: Exm-Board of Education	650: Exm-Board of Education	31.3200	611110	ANSONIA HIGH SCHOOL	HIGH_SCHOOL
39037-T76241018030312700	39	037	445 WAYNE ST	VERSAILLES	OH	45380	445 WAYNE ST	VERSAILLES	OH	45380	Darke	82152	Wayne	530100	5301	464.3810	2	39037C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	298.3971	298.8832	298.6776	510: Res-Single Family	510: Res-Single Family	0
39037-F27221102040413600	39	037	1001 WASHINGTON AVE	GREENVILLE	OH	45331	1001 WASHINGTON AVE	GREENVILLE	OH	45331	Darke	32354	Greenville	555102	5551.0200	773.6858	1	39037C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	317.8486	318.5270	318.1247	510: Res-Single Family	510: Res-Single Family	0
39037-F27221226030211800	39	037	620 WATER E	GREENVILLE	OH	45331	403 MEMORIAL DR	GREENVILLE	OH	45331	Darke	32354	Greenville	555102	5551.0200	826.7254	2	39037C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	310.8027	312.8629	311.8017	510: Res-Single Family	510: Res-Single Family	0
39037-G28011009000010400	39	037	HARRISON	NEW MADISON	OH	45346	2468 HARRISON RD	NEW MADISON	OH	45346	Darke	33810	Harrison	560101	5601.0100	40426.8235	0	39037C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	346.8580	359.0555	355.7295	100: Agr-Vacant Land	100: Agr-Vacant Land	11
39037-B12621427020115700	39	037	400 ROSS N	ROSSBURG	OH	45362	400 N ROSS ST	ROSSBURG	OH	45362	Darke	01294	Allen	500100	5001	676.5669	1	39037C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	315.1518	315.5290	315.3604	510: Res-Single Family	510: Res-Single Family	0
39037-P56030805000020900	39	037	6278 HOLLANSBRG-ARCANUM	ARCANUM	OH	45304	6278 HOLLANSBURG-ARCANUM RD	ARCANUM	OH	45304	Darke	77980	Twin	570102	5701.0200	2234.5764	1	39037C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	321.5975	322.1931	321.8416	511: Res-Custom Code	511: Res-Custom Code	0.6000
39037-C13021309000020200	39	037	11036 MICHAEL	ANSONIA	OH	45303	4213 WASHINGTON RD	ANSONIA	OH	45303	Darke	09414	Brown	520100	5201	237017.8309	0	39037C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	309.1527	315.5330	312.6169	100: Agr-Vacant Land	100: Agr-Vacant Land	60.7000
39037-I34011135000030200	39	037	3045 RICHMND-PALESTINE	NEW MADISON	OH	45346	3045 RICHMOND-PALESTINE RD	NEW MADISON	OH	45346	Darke	43092	Liberty	560102	5601.0200	307054.9592	4	39037C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	327.0701	350.3879	335.2452	101: Agr-Cash-Grain Farm	101: Agr-Cash-Grain Farm	76
39037-F27221102041112800	39	037	734 CENTRAL	GREENVILLE	OH	45331	734 CENTRAL AVE	GREENVILLE	OH	45331	Darke	32354	Greenville	555101	5551.0100	557.0368	1	39037C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	316.3624	317.0126	316.6745	510: Res-Single Family	510: Res-Single Family	0
39037-F24021225000023500	39	037	6708 JAYSVILLE-ST JOHNS	GREENVILLE	OH	45331	6407 COUNTRY CLUB DR	GREENVILLE	OH	45331	Darke	32354	Greenville	550100	5501	4132.8219	1	39037C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	318.0111	319.7665	319.2040	510: Res-Single Family	510: Res-Single Family	1.0300
39037-G31411013020111900	39	037	346 JEFFERSON	NEW MADISON	OH	45346	346 JEFFERSON ST	NEW MADISON	OH	45346	Darke	33810	Harrison	560101	5601.0100	3434.8646	1	39037C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	333.7532	337.0037	334.6969	510: Res-Single Family	510: Res-Single Family	0.4700
39037-T73031136000020200	39	037	9066 MCCREA	BRADFORD	OH	45308	9066 MCCREA RD	BRADFORD	OH	45308	Darke	82152	Wayne	530100	5301	217371.6259	2	39037C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	299.6631	302.5776	301.2119	101: Agr-Cash-Grain Farm	101: Agr-Cash-Grain Farm	55
39037-N54331009030110100	39	037	ARCANUM-BEARS MILL	GREENVILLE	OH	45331	8152 ARCANUM-BEARS MILL RD	GREENVILLE	OH	45331	Darke	66656	Richland	520100	5201	1353.4423	1	39037C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	306.3179	308.3553	307.4155	500: Res-Vacant Land	500: Res-Vacant Land	0.5000
39037-F24021218000010100	39	037	2843 FOX	GREENVILLE	OH	45331	2892 FOX RD	GREENVILLE	OH	45331	Darke	32354	Greenville	550100	5501	119687.7128	2	39037C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	318.2503	321.8934	320.2837	101: Agr-Cash-Grain Farm	101: Agr-Cash-Grain Farm	29.5000
39037-L45321129020110600	39	037	3383 WEAVER-FT JEFFERSN	GREENVILLE	OH	45331	3379 WEAVER-FT JEFFERSON RD	GREENVILLE	OH	45331	Darke	53732	Neave	560102	5601.0200	1954.9614	1	39037C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	324.7857	327.9003	326.1066	510: Res-Single Family	510: Res-Single Family	0.5000
39037-F27221227010112800	39	037	686 BUR-OAK	GREENVILLE	OH	45331	686 BUR-OAK DR	GREENVILLE	OH	45331	Darke	32354	Greenville	555002	5550.0200	1646.4943	1	39037C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	317.1628	319.3888	318.3428	510: Res-Single Family	510: Res-Single Family	0.4200
39037-D81021034000030101	39	037	129 EMRICK	NEW MADISON	OH	45346	129 EMRICK RD	NEW MADISON	OH	45346	Darke	10576	Butler	560101	5601.0100	19033.8369	2	39037C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	335.0760	339.2247	336.9020	101: Agr-Cash-Grain Farm	101: Agr-Cash-Grain Farm	5.0100
39037-F24021217000030300	39	037	7558 MCMECHAM	GREENVILLE	OH	45331	7558 MC MECHAM RD	GREENVILLE	OH	45331	Darke	32354	Greenville	550100	5501	4794.7476	2	39037C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	322.0461	323.2853	322.6974	511: Res-Custom Code	511: Res-Custom Code	1.4000
39037-A05431025010111600	39	037	105 MARY AVE	GETTYSBURG	OH	45328	105 MARY AVE GETTYSBURG	GETTYSBURG	OH	45328	Darke	00254	Adams	540100	5401	1533.2847	1	39037C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	310.2831	311.5133	311.1519	510: Res-Single Family	510: Res-Single Family	0
39037-Q63030928000032000	39	037	3618 ST RT 49	ARCANUM	OH	45304	3618 ST RT 49 ARCANUM	ARCANUM	OH	45304	Darke	79380	Van Buren	570101	5701.0100	1572.2963	1	39037C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	317.0211	317.7050	317.3285	511: Res-Custom Code	511: Res-Custom Code	0