Saved query 517acb6e8c65dc1e

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

94,558 matching parcels

Data Preview

parcelid	statefp	countyfp	parceladdr	parcelcity	parcelstate	parcelzip	owneraddr	ownercity	ownerstate	ownerzip	countyname	cousubfp	cousubname	tractce	tractname	calcarea	numbldgs	numfloors	firmid	firmdate	fldzone	zonesubty	elevmin	elevmax	elevavg	usecode	usedesc	taxacres	naicscode	parceltype	accesstype	iucnclass	placename	placetype
39041-41942001001000	39	041	OLENTANGY RIVER RD DELAWARE 430…		OH	43015	OLENTANGY RIVER RD	DELAWARE	OH	43015	Delaware	43106	Liberty	012100	121	1648.9582	0		39041C	2025-12-11	AE		250.2223	256.1790	252.3116	400: Com-Vacant Land	400: Com-Vacant Land	0.7500	4871	GOVT STATE	RESTRICTED	V	OLENTANGY SCENIC RIVER	STATE CONSERVATION AREA
39041-31942601002567	39	041	275 BEAR WOODS DR POWELL 43065	POWELL	OH	43065	275 BEAR WOODS DR	POWELL	OH	43065	Delaware	43106	Liberty	011900	119	6995.8621	3		39041C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	281.3901	283.0610	282.4183	550: Res-Condo	550: Res-Condo	0	813110				CALL TO ACTION - COLUMBUS	RELIGIOUS_ORGANIZATION
39041-31842101003002	39	041	E ORANGE RD LEWIS CENTER 43035	LEWIS CENTER	OH	43035	E ORANGE RD	LEWIS CENTER	OH	43035	Delaware	58618	Orange	011540	115.4000	152511.5724	6		39041C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	268.5296	283.7631	277.9756	400: Com-Vacant Land	400: Com-Vacant Land	37.7200	111310				OLENTANGY ORANGE STADIUM	STADIUM_ARENA
39041-31934103012504	39	041	10200 SAWMILL PKWY POWELL 43065	POWELL	OH	43065	10200 SAWMILL PKWY POWELL	POWELL	OH	43065	Delaware	43106	Liberty	011430	114.3000	24448.0653	5		39041C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	274.9481	278.9535	277.2303	450: Com-Condo	450: Com-Condo	0	6214				KINGSDALE GYNECOLOGIC ASSOCIATES	OUTPATIENT_CARE_FACILITY
39041-31844302012000	39	041	999 COUNTY LINE RD W WESTERVILL…	WESTERVILLE	OH	43082	999 COUNTY LINE RD	WESTERVILLE	OH	43082	Delaware	83349	Westerville City	012400	124	23919.6794	1		39049C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	260.2075	272.4065	268.2562	447: Com-Office	447: Com-Office	5.9200	56199				MINDWARE TECHNOLOGIES LTD.	TECHNICAL_SERVICE
39041-31734105003000	39	041	6475 MAXTOWN RD WESTERVILLE 430…	WESTERVILLE	OH	43082	6475 MAXTOWN RD	WESTERVILLE	OH	43082	Delaware	29694	Genoa	011766	117.6600	3326.6196	1		39041C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	283.3533	285.2685	283.9571	400: Com-Vacant Land	400: Com-Vacant Land	0.8300	54143				JC MANNY CO	PRINTING_SERVICE
39041-51932001015563	39	041	62 LIPPAZON WAY DELAWARE 43015	DELAWARE	OH	43015	62 LIPPAZON WAY	DELAWARE	OH	43015	Delaware	21469	Delaware City	010422	104.2200	31696.9196	11	2	39041C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	288.7041	293.8244	291.7501	550: Res-Condo	550: Res-Condo	0
39041-41843307067000	39	041	4296 EAST BAY CIR LEWIS CENTER …	LEWIS CENTER	OH	43035	4296 EAST BAY CIR	LEWIS CENTER	OH	43035	Delaware	05788	Berlin	011564	115.6400	1302.5845	1	2	39041C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	278.4989	280.0645	279.5090	510: Res-Single Family	510: Res-Single Family	0.3100
39041-51932001016537	39	041	289 SADDLEBROOK CT DELAWARE 430…	DELAWARE	OH	43015	289 SADDLEBROOK CT	DELAWARE	OH	43015	Delaware	21469	Delaware City	010422	104.2200	11976.7838	6	2	39041C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	292.3614	294.6094	293.7558	550: Res-Condo	550: Res-Condo	0
39041-51934307004000	39	041	302 HEARTHSTONE DR DELAWARE 430…	DELAWARE	OH	43015	302 HEARTHSTONE DR	DELAWARE	OH	43015	Delaware	21469	Delaware City	010520	105.2000	1367.0548	1		39041C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	287.0698	288.0223	287.6673	510: Res-Single Family	510: Res-Single Family	0
39041-31924024004000	39	041	4659 VILLAGE CLUB DR POWELL 430…	POWELL	OH	43065	4659 VILLAGE CLUB DR	POWELL	OH	43065	Delaware	43106	Liberty	012100	121	993.2334	2		39041C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	285.8102	287.2265	286.6180	510: Res-Single Family	510: Res-Single Family	0.2400
39041-31731402098000	39	041	6740 ALBERTA PL WESTERVILLE 430…	WESTERVILLE	OH	43082	6740 ALBERTA PL	WESTERVILLE	OH	43082	Delaware	29694	Genoa	011766	117.6600	1113.0279	1		39041C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	285.2756	285.9960	285.7466	510: Res-Single Family	510: Res-Single Family	0.2800
39041-41824006004000	39	041	3631 CLOVER PLAINS DR DELAWARE …	DELAWARE	OH	43015	3631 CLOVER PLAINS DR	DELAWARE	OH	43015	Delaware	05788	Berlin	011562	115.6200	6688.8188	1		39041C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	288.5736	290.6736	289.6944	510: Res-Single Family	510: Res-Single Family	1.6400
39041-41941005114000	39	041	475 INVERNESS AVE DELAWARE 43015	DELAWARE	OH	43015	475 INVERNESS AVE	DELAWARE	OH	43015	Delaware	43106	Liberty	012100	121	787.6610	1		39041C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	279.0625	280.6274	280.1297	510: Res-Single Family	510: Res-Single Family	0.2000
39041-51623001068000	39	041	6340 STATE ROUTE 61 N SUNBURY 4…	SUNBURY	OH	43074	6340 STATE ROUTE 61	SUNBURY	OH	43074	Delaware	64178	Porter	011102	111.0200	171210.2496	3		39041C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	317.1187	331.1768	323.5029	101: Agr-Cash-Grain Farm	101: Agr-Cash-Grain Farm	42.0500
39041-60034304071000	39	041	6235 INVERURIE DR W DUBLIN 43017	DUBLIN	OH	43017	6235 INVERURIE DR	DUBLIN	OH	43017	Delaware	81242	Washington	011412	114.1200	1472.4111	1		39049C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	295.4859	297.1221	296.3986	510: Res-Single Family	510: Res-Single Family	0
39041-31821302001000	39	041	1411 SHORT ST LEWIS CENTER 43035	LEWIS CENTER	OH	43035	1411 SHORT ST	LEWIS CENTER	OH	43035	Delaware	58618	Orange	011562	115.6200	2439.1904	1		39041C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	280.9066	285.8746	284.3905	511: Res-Custom Code	511: Res-Custom Code	0.5500
39041-31731102044000	39	041	6315 STEINBECK WAY WESTERVILLE …	WESTERVILLE	OH	43082	6315 STEINBECK WAY	WESTERVILLE	OH	43082	Delaware	29694	Genoa	011766	117.6600	1355.9767	1		39041C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	285.0067	286.0398	285.6408	510: Res-Single Family	510: Res-Single Family	0.3300
39041-41941021008000	39	041	219 MAPLE VISTA CT DELAWARE 430…	DELAWARE	OH	43015	219 MAPLE VISTA CT	DELAWARE	OH	43015	Delaware	43106	Liberty	012100	121	1000.0081	1		39041C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	287.9762	289.5582	288.8340	510: Res-Single Family	510: Res-Single Family	0.2500
39041-41732021009000	39	041	7318 GRAFTON LN GALENA 43021	GALENA	OH	43021	7318 GRAFTON LN GALENA	GALENA	OH	43021	Delaware	05774	Berkshire	011604	116.0400	1086.3929	1		39041C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	294.5776	295.3963	294.8821	510: Res-Single Family	510: Res-Single Family	0.2700
39041-31934405021510	39	041	4957 EMERALD LAKES BLVD POWELL …	POWELL	OH	43065	4957 EMERALD LAKES BLVD POWELL	POWELL	OH	43065	Delaware	43106	Liberty	011430	114.3000	4452.2593	1		39041C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	283.3948	285.1585	284.3218	550: Res-Condo	550: Res-Condo	0
39041-31942103023000	39	041	8509 WESTMINSTER DR POWELL 43065	POWELL	OH	43065	8509 WESTMINSTER DR	POWELL	OH	43065	Delaware	43106	Liberty	011423	114.2300	2166.6972	1		39041C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	279.1258	280.5322	279.7811	510: Res-Single Family	510: Res-Single Family	0
39041-31944201011000	39	041	185 VALLEY RUN DR POWELL 43065	POWELL	OH	43065	185 VALLEY RUN DR	POWELL	OH	43065	Delaware	43106	Liberty	011421	114.2100	3165.4270	1		39041C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	265.0660	269.5322	267.9495	510: Res-Single Family	510: Res-Single Family	0
39041-41713403006001	39	041	727 CHESHIRE RD SUNBURY 43074	SUNBURY	OH	43074	727 CHESHIRE RD	SUNBURY	OH	43074	Delaware	75620	Sunbury Village	011604	116.0400	9648.3989	2		39041C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	286.1758	289.1408	287.5572	511: Res-Custom Code	511: Res-Custom Code	2.2900
39041-32011002001531	39	041	6534 RIVERRUN LN DELAWARE 43015	DELAWARE	OH	43015	6534 RIVERRUN LN	DELAWARE	OH	43015	Delaware	18140	Concord	011432	114.3200	592.2368	1		39041C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	274.7275	278.9655	276.5277	550: Res-Condo	550: Res-Condo	0