Saved query b50abd8255b211e4

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

74,770 matching parcels

Data Preview

parcelid	statefp	countyfp	parceladdr	parcelcity	parcelstate	parcelzip	owneraddr	ownerzip	countyname	cousubfp	cousubname	tractce	tractname	calcarea	numbldgs	firmid	firmdate	fldzone	zonesubty	elevmin	elevmax	elevavg	usecode	usedesc	taxacres	naicscode	parceltype	accesstype	placename	placetype
39007-16-007-10-024-00	39	007	0 JUNIPER DR	DORSET	OH	44032	144217 N 0000		Ashtabula	22344	Dorset	001303	13.0300	587.4431	0	39007C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	308.4673	311.2808	310.4779	500: Res-Vacant Land	500: Res-Vacant Land	0.1200	7212	GOVT LOCAL	OPEN	GRAND LAKES	LOCAL PARK
39007-12-326-00-046-00	39	007	235 PARRISH RD	CONNEAUT	OH	44030	N 0000	142954	Ashtabula	18350	Conneaut	000101	1.0100	2895.4693	1	39007C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	207.3522	209.3138	208.3645	442: Com-Medical Clinic	442: Com-Medical Clinic	0.8700	6214			SINGH PARMINDER MD	OUTPATIENT_CARE_FACILITY
39007-16-007-10-079-00	39	007	0 EUCALYPTUS RD		OH	44032	157351 N 0000		Ashtabula	22344	Dorset	001303	13.0300	916.4038	0	39007C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	310.8840	312.1098	311.4417	620: Exm-County	620: Exm-County	0.2400	7212	GOVT LOCAL	OPEN	GRAND LAKES	LOCAL PARK
39007-03-036-00-001-00	39	007	3104 STATE RD	EDGEWOOD	OH	44004	114465 N 0000		Ashtabula	02652	Ashtabula	000500	5	3750.5049	1	39007C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	200.4368	201.4744	200.9209	480: Com-Warehouse	480: Com-Warehouse	0.9600	6216			EASTDALE OVERHEAD DOOR INC.	HOME_SERVICE
39007-02-013-20-091-00	39	007	188 MAIN SR 7 ST	ANDOVER	OH	44003	106726 N 0000		Ashtabula	02064	Andover	001304	13.0399	2940.9716	2	39007C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	328.7625	330.3328	329.4987	518: Res-Custom Code	518: Res-Custom Code	0.9100	81291			MAX'S BLACK CAT COVEN	ANIMAL_OR_PET_SERVICE
39007-68-319-00-008-01	39	007	2401 WEST AVE	ASHTABULA	OH	44004	0 N 0000		Ashtabula	02652	Ashtabula	000601	6.0100	2586.5806	1	39007C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	194.9352	195.9341	195.5217	420: Com-Retail-Small	420: Com-Retail-Small	0.6600	45941			DASCO PAPER & JANITORIAL SUPPLY	MANUFACTURER
39007-05-209-00-003-00	39	007	4536 MAIN AVE	ASHTABULA	OH	44004	0 N 0000		Ashtabula	02652	Ashtabula	000704	7.0400	810.4281	1	39007C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	212.9389	213.2359	213.0933	447: Com-Office	447: Com-Office	0.2000	45831			GREATER ASHTABULA CHAMBER OF CO…	PROFESSIONAL_SERVICE
39007-12-229-00-210-00	39	007	876 MILLARD AVE	CONNEAUT	OH	44030	N 0000	117133	Ashtabula	18350	Conneaut	000102	1.0200	636.1317	1	39007C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	191.6198	192.6353	192.0293	510: Res-Single Family	510: Res-Single Family	0.1600
39007-20-010-00-089-00	39	007	1437 SHERMAN ST	GENEVA	OH	44041	0000 N	35220	Ashtabula	29624	Geneva	000802	8.0200	1803.0378	1	39007C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	230.9451	232.3904	231.7785	510: Res-Single Family	510: Res-Single Family	0.4600
39007-05-218-00-004-00	39	007	616 W 36TH ST	ASHTABULA	OH	44004	N 0000	141923	Ashtabula	02652	Ashtabula	000701	7.0100	246.7606	0	39007C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	198.7267	199.3020	198.9206	685: Exm-Public Woship	685: Exm-Public Woship	0.0500
39007-26-020-00-112-00	39	007	58 W SATIN ST	JEFFERSON	OH	44047	0000 N	98297	Ashtabula	38514	Jefferson	001102	11.0200	2083.5132	1	39007C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	289.6066	291.0087	290.2371	510: Res-Single Family	510: Res-Single Family	0.5300
39007-48-024-10-058-00	39	007	5722 KETCHUM AVE	ASHTABULA	OH	44004	0000 N	69044	Ashtabula	70646	Saybrook	000701	7.0100	709.7163	0	39007C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	198.4169	199.4717	198.7803	510: Res-Single Family	510: Res-Single Family	0.1800
39007-01-714-20-024-00	39	007	914 CAMPLANDS BLVD	ANDOVER	OH	44003	N 0000	136600	Ashtabula	02064	Andover	001304	13.0399	257.0443	1	39007C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	328.6260	329.6228	329.2883	599: Res-Other	599: Res-Other	0
39007-26-037-00-095-00	39	007	355 BEVERLY DR	JEFFERSON	OH	44047	0000 N	46982	Ashtabula	38514	Jefferson	001102	11.0200	1930.6218	1	39007C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	280.7207	282.3669	281.8633	510: Res-Single Family	510: Res-Single Family	0.4800
39007-31-008-00-020-10	39	007	0 WEAVER RD	MONROE	OH	44030	0000 N	53177	Ashtabula	51296	Monroe	001202	12.0200	20382.2479	0	39007C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	265.2023	274.3466	270.4215	501: Res-Custom Code	501: Res-Custom Code	5.0599
39007-03-039-00-055-00	39	007	3520 FARGO DR	EDGEWOOD	OH	44004	N 0000	140186	Ashtabula	02652	Ashtabula	000500	5	476.0880	1	39007C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	211.6103	212.7073	212.3809	510: Res-Single Family	510: Res-Single Family	0.1300
39007-48-002-00-079-00	39	007	2301 TRYON RD	ASHTABULA	OH	44004	0000 N	64582	Ashtabula	70646	Saybrook	000603	6.0300	2522.7993	1	39007C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	192.2698	193.3861	192.9526	511: Res-Custom Code	511: Res-Custom Code	0.6000
39007-12-127-00-049-00	39	007	261 BLOOR ST	CONNEAUT	OH	44030	0000 N	22891	Ashtabula	18350	Conneaut	000103	1.0300	796.2868	1	39007C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	208.1272	208.9806	208.5807	510: Res-Single Family	510: Res-Single Family	0.1900
39007-22-034-00-021-00	39	007	1923 BERINGER PL	GENEVA	OH	44041	0000 N	42673	Ashtabula	33642	Harpersfield	000802	8.0200	5300.1896	1	39007C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	237.5507	242.4682	240.0214	510: Res-Single Family	510: Res-Single Family	1.3300
39007-31-007-00-034-02	39	007	0 WEAVER RD	MONROE	OH	44030	0000 N	53106	Ashtabula	51296	Monroe	001202	12.0200	4157.3911	1	39007C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	268.4666	271.0323	270.0350	599: Res-Other	599: Res-Other	1
39007-09-027-00-026-02	39	007	2983 SENTINEL RD	CHERRY VALLEY	OH	44032	0000 N	19425	Ashtabula	13890	Cherry Valley	001303	13.0300	18898.9545	1	39007C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	308.1089	310.7701	310.0129	685: Exm-Public Woship	685: Exm-Public Woship	9.9700
39007-05-510-00-060-00	39	007	1241 E 16TH ST	ASHTABULA	OH	44004	N 0000	127191	Ashtabula	02652	Ashtabula	000400	4	1299.9611	1	39007C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	194.0051	194.6225	194.2320	510: Res-Single Family	510: Res-Single Family	0.3300
39007-05-501-00-028-00	39	007	2225 COLUMBUS AVE	ASHTABULA	OH	44004	N 0000	124519	Ashtabula	02652	Ashtabula	000400	4	968.2299	2	39007C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	193.5396	194.8947	194.5780	518: Res-Custom Code	518: Res-Custom Code	0.2300
39007-20-037-00-009-00	39	007	1006 E MAIN USR 20 ST	GENEVA	OH	44041	0000 N	37568	Ashtabula	29624	Geneva	000802	8.0200	9296.5515	2	39007C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	204.9655	206.6083	205.8090	521: Res-Custom Code	521: Res-Custom Code	2.5000
39007-66-014-40-017-00	39	007	0 MORNING STAR DR	ROAMING SHORES	OH	44084	0000 N	96368	Ashtabula	68224	Rome	001001	10.0100	1842.3963	0	39007C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	267.6333	268.6867	268.0292	500: Res-Vacant Land	500: Res-Vacant Land	0.4600