Saved query bc2c3989637ae5cf

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

28,642 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	iucnclass	placename	placetype
39019-150005217000	39	019	BACON NW RD	CARROLLTON	OH	44615	2045 MORSE RD D-2	COLUMBUS	OH	43229-6605	Carroll	33782	Harrison	720400	7204	667.2402	0	39019C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	323.3587	330.8214	327.0804	400: Com-Vacant Land	400: Com-Vacant Land	302.1300	7212	GOVT STATE	RESTRICTED	V	VALLEY RUN WILDLIFE AREA	STATE CONSERVATION AREA
39019-240000008000	39	019	24 N SMITH ST	DELLROY	OH	44620	4221 ANTIGUA RD SW	CARROLLTON	OH	44615-9284	Carroll	51324	Monroe	720400	7204	668.7742	0	39019C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	285.6057	289.4190	287.6576	500: Res-Vacant Land	500: Res-Vacant Land	0	8141	NGO	CLOSED	V	ATWOOD LAKE	PRIVATE CONSERVATION
39019-220000464000	39	019	7108 MENLO DR 332 LOT	SHERRODSVILLE	OH	44675	7108 MENLO DR SW	SHERRODSVILLE	OH	44675-9723	Carroll	51324	Monroe	720400	7204	1579.7628	0	39019C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	291.3414	296.6143	293.9400	510: Res-Single Family	510: Res-Single Family	0	4871	NGO	CLOSED		ATWOOD LAKE	STATE RECREATION AREA
39019-220000740000	39	019	1261 ARROWHEAD DR 410 LOT	DELLROY	OH	44620	12730 DRAKE RD	NORTH ROYALTON	OH	44133-5434	Carroll	51324	Monroe	720400	7204	934.2358	1	39019C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	287.1029	289.3714	288.6222	510: Res-Single Family	510: Res-Single Family	0	4871	NGO	CLOSED		ATWOOD LAKE	STATE RECREATION AREA
39019-270000216000	39	019	CUMBERLAND RD	SHERRODSVILLE	OH	44675	PO BOX 191 SHERRODSVILLE 44615	SHERRODSVILLE	OH	44615	Carroll	58576	Orange	720700	7207	764.6275	0	39019C	2025-12-11	A		277.0047	278.0066	277.3386	500: Res-Vacant Land	500: Res-Vacant Land	0	7212	GOVT FEDERAL	RESTRICTED		DOVER LAKE	RECREATION MANAGEMENT AREA
39019-310003273000	39	019	IMPERIAL RD		OH	44643	11189 IMPERIAL RD NW MAGNOLIA	MAGNOLIA	OH	44643	Carroll	68420	Rose	720400	7204	15476.7083	0	39019C	2025-12-11	X	0.2 PCT ANNUAL CHANCE FLOOD HAZ…	284.3285	295.1720	291.3713	501: Res-Custom Code	501: Res-Custom Code	4.0100	7212	GOVT FEDERAL	RESTRICTED		BOLIVAR LAKE	RECREATION MANAGEMENT AREA
39019-340000511007	39	019	1130 COBBLER NE RD CARROLLTON 4…	CARROLLTON	OH	44615	1130 COBBLER RD NE	CARROLLTON	OH	44615-9709	Carroll	81116	Washington	720500	7205	10311.0802	1	39019C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	369.6011	380.7002	373.0593	499: Com-Other	499: Com-Other	3	921110				CCH SOLID WASTE DISTRICT	GOVERNMENT_OFFICE
39019-150000483000	39	019	5017 WAYNESBURG RD	CARROLLTON	OH	44615	5017 WAYNESBURG RD NW	CARROLLTON	OH	44615	Carroll	33782	Harrison	720300	7203	9327.0124	2	39019C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	363.5469	369.1119	366.4683	511: Res-Custom Code	511: Res-Custom Code	2.3000	33791				BUILT BY POTTSY LLC	MANUFACTURER
39019-110000134002	39	019	8265 MARK RD	EAST	OH	44427	8265 MARK RD NE	KENSINGTON	OH	44427-9610	Carroll	23226	East	720100	7201	6069.6009	2	39019C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	359.4208	377.7634	371.5004	511: Res-Custom Code	511: Res-Custom Code	1.5000
39019-120000011000	39	019	6130 NORCO RD	CARROLLTON	OH	44615	1114 MONTERO RD NE	CARROLLTON	OH	44615-9131	Carroll	28126	Fox	720600	7206	348665.6367	8	39019C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	336.1060	380.7865	359.6495	111: Agr-CAUV-Cash-Grain Farm	111: Agr-CAUV-Cash-Grain Farm	85.6800
39019-150005110001	39	019	1213 THATCH NW RD CARROLLTON 44…	CARROLLTON	OH	44615	1220 TRUMP RD NW	CARROLLTON	OH	44615-9465	Carroll	33782	Harrison	720500	7205	72874.4114	0	39019C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	316.1324	356.0170	334.9156	110: Agr-CAUV-Vacant Land	110: Agr-CAUV-Vacant Land	18
39019-030000217000	39	019	214 W MOHAWK DR 1267 LOT	MALVERN	OH	44644	214 W MOHAWK DR	MALVERN	OH	44644	Carroll	09400	Brown	720300	7203	1389.7658	1	39019C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	316.1528	327.4122	320.7484	510: Res-Single Family	510: Res-Single Family	0
39019-040000302000	39	019	1978 LEISURE NW RD	MINERVA	OH	44657	1978 LEISURE RD NW MINERVA	MINERVA	OH	44657	Carroll	09400	Brown	720200	7202	1047.4381	1	39019C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	313.6726	316.0469	314.6652	599: Res-Other	599: Res-Other	0.2600
39019-070000277002	39	019	S BRIDGE ST	MALVERN	OH	44644	8050 AVALON RD NW	MALVERN	OH	44644	Carroll	09400	Brown	720300	7203	12026.6011	2	39019C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	304.2484	306.9174	305.1834	499: Com-Other	499: Com-Other	3
39019-010000270000	39	019	8141 KENSINGTON RD 57 LOT	AUGUSTA	OH	44625	PO BOX 54 AUGUSTA 44607	AUGUSTA	OH	44607	Carroll	03030	Augusta	720100	7201	891.8332	2	39019C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	370.0505	371.6162	370.9495	510: Res-Single Family	510: Res-Single Family	0
39019-150004880000	39	019	4360 ARROW RD	CARROLLTON	OH	44615	4362 ARROW RD APT B	CARROLLTON	OH	44615	Carroll	33782	Harrison	720100	7201	22231.1731	2	39019C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	326.0555	358.6751	341.5972	401: Com-Apartment- 4 to 19	401: Com-Apartment- 4 to 19	5.5000
39019-030002800000	39	019	6038 6040 AVALON RD	MALVERN	OH	44644	3634 RUBY AVE	ST JAMES CITY	FL	33956-2299	Carroll	09400	Brown	720300	7203	22112.1257	2	39019C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	369.8351	382.7198	377.3243	499: Com-Other	499: Com-Other	5.4800
39019-030000545002	39	019	TOWER RD	MALVERN	OH	44644	8289 OLD CANAL LANE NW	MALVERN	OH	44644	Carroll	09400	Brown	720300	7203	22836.1077	0	39019C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	302.7748	332.8535	322.9706	110: Agr-CAUV-Vacant Land	110: Agr-CAUV-Vacant Land	5.6400
39019-230000428000	39	019	3240 PARKLAND DR CARROLLTON 446…	CARROLLTON	OH	44615	3209 PARKLAND DR SW	CARROLLTON	OH	44615-0211	Carroll	51324	Monroe	720700	7207	697.3715	0	39019C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	341.6150	348.3268	344.6459	500: Res-Vacant Land	500: Res-Vacant Land	0
39019-190000242001	39	019	GERMANO RD	CARROLLTON	OH	44615	6144 GERMANO RD SE	CARROLLTON	OH	44615	Carroll	45038	Loudon	720600	7206	6019.1878	1	39019C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	368.4093	382.9644	376.1815	599: Res-Other	599: Res-Other	1.5000
39019-230000216000	39	019	3667 ROCKWOOD SW DR	CARROLLTON	OH	44615	288 E HEATHERWOOD DR	BARBERTON	OH	44203	Carroll	51324	Monroe	720700	7207	664.4642	0	39019C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	302.3149	314.1677	307.3422	510: Res-Single Family	510: Res-Single Family	0
39019-190000526000	39	019	7214 AMSTERDAM RD	AMSTERDAM	OH	43903	7214 AMSTERDAM RD SE	AMSTERDAM	OH	43903	Carroll	45038	Loudon	720600	7206	32787.0797	1	39019C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	294.8371	304.9654	298.4407	101: Agr-Cash-Grain Farm	101: Agr-Cash-Grain Farm	8
39019-280000867000	39	019	6583 OVERLOOK ST 19 LOT	CARROLLTON	OH	44615	6499 WELLS ST SW	CARROLLTON	OH	44615	Carroll	61784	Perry	720700	7207	514.0562	0	39019C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	321.2618	329.7650	326.7314	599: Res-Other	599: Res-Other	0
39019-270000225000	39	019	60 ROSWELL RD	SHERRODSVILLE	OH	44675	PO BOX 150 SHERRODSVILLE 44675-…	SHERRODSVILLE	OH	44675-0150	Carroll	58576	Orange	720700	7207	760.5350	1	39019C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	283.3858	286.3436	285.2494	510: Res-Single Family	510: Res-Single Family	0
39019-100000436000	39	019	307 GARFIELD AVE CARROLLTON 446…	CARROLLTON	OH	44615	307 GARFIELD AVE NW	CARROLLTON	OH	44615-1013	Carroll	12896	Center	720500	7205	592.3484	2	39019C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	358.6844	359.5156	359.2183	510: Res-Single Family	510: Res-Single Family	0