Saved query 2dc20ecdeef30267

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

73,167 matching parcels

Data Preview

parcelid	statefp	countyfp	parceladdr	parcelcity	parcelstate	parcelzip	ownername	countyname	cousubfp	cousubname	tractce	tractname	calcarea	numbldgs	numfloors	firmid	firmdate	fldzone	zonesubty	elevmin	elevmax	elevavg	usecode	usedesc	taxacres	ownertype	naicscode	placename	placetype	taxdistrict
39045-0535007110	39	045	432 S EWING ST	LANCASTER	OH	43130		Fairfield	41740	Lancaster City	031300	313	3543.7313	2	1	39045C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	253.0278	258.3638	255.9515	429: Com-Other	429: Com-Other	0.8700		23815	LANCASTER GLASS	HOME_SERVICE
39045-0240232910	39	045	934 W MARKET ST BALTIMORE 43105	BALTIMORE	OH	43105		Fairfield	43120	Liberty	030300	303	708.5123	1		39045C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	259.8291	260.4902	260.2111	499: Com-Other	499: Com-Other	0		8121	THEGLOWHAVENBYMYAH	PERSONAL_OR_BEAUTY_SERVICE
39045-0532821010	39	045	0 ETY RD LANCASTER 43130	LANCASTER	OH	43130		Fairfield	41740	Lancaster City	030901	309.0100	1200.1918	0		39045C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	255.0700	256.4217	255.6801	499: Com-Other	499: Com-Other	0.3000		722511	CHICK-FIL-A LANCASTER	RESTAURANT
39045-0535006700	39	045	180 GRACELAND DR LANCASTER 43130	LANCASTER	OH	43130		Fairfield	41740	Lancaster City	031300	313	2391.5098	1		39045C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	253.8986	254.9916	254.5864	481: Com-Custom Code	481: Com-Custom Code	0.5900		49319	ARCH CITY STORAGE OF EAST LANCA…	STORAGE_FACILITY
39045-0534824000	39	045	1524 MONMOUTH ST LANCASTER 43130	LANCASTER	OH	43130		Fairfield	41740	Lancaster City	031402	314.0200	2062.7260	1		39045C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	273.8370	280.7924	276.6796	680: Exm-Charitable	680: Exm-Charitable	0.5100		6214	VANGUARD FAMILY PRACTICE	PRIMARY_CARE_OR_GENERAL_CLINIC
39045-0533022900	39	045	430 N MULBERRY ST LANCASTER 431…	LANCASTER	OH	43130		Fairfield	41740	Lancaster City	032200	322	267.3289	2		39045C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	252.5468	252.9897	252.7700	420: Com-Retail-Small	420: Com-Retail-Small	0		6216	SERVICEMASTER RESTORE	HOME_SERVICE
39045-0536813500	39	045	1500 S BROAD ST	LANCASTER	OH	43130		Fairfield	41740	Lancaster City	032300	323	65146.4351	0		39045C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	271.6816	287.1268	280.7875	690: Exm-Graveyards	690: Exm-Graveyards	25.7900		81222	LANCASTER CEMETERY
39045-0533086100	39	045	675 E WHEELING ST LANCASTER 431…	LANCASTER	OH	43130		Fairfield	41740	Lancaster City	032200	322	565.3099	1	2	39045C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	253.3792	253.7952	253.5520	510: Res-Single Family	510: Res-Single Family	0
39045-0533095900	39	045	836 N EASTWOOD AVE LANCASTER 43…	LANCASTER	OH	43130		Fairfield	41740	Lancaster City	032100	321	496.2879	1	1	39045C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	250.1384	254.3275	253.2886	510: Res-Single Family	510: Res-Single Family	0
0360126500	39	045	8962 INDIAN MOUND ROAD	VIOLET	OH	43147	BYERS KATIE	Fairfield	80206	Violet	032902	329.0200	2101.2144	1		39045C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	303.2154	305.5472	304.5854			0	PERSON				FAIRFIELD
39045-0040126320	39	045	440 MCGRERY RD LANCASTER 43130	LANCASTER	OH	43130		Fairfield	05956	Berne	031200	312	35321.6468	0		39045C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	263.5333	327.4968	285.6962	120: Agr-Timber	120: Agr-Timber	8.7300
39045-0110024823	39	045	8100 CHILLICOTHE-LANCASTER RD A…	AMANDA	OH	43102		Fairfield	15686	Clearcreek	032601	326.0100	3978.1632	1		39045C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	281.7151	284.5440	283.6019	511: Res-Custom Code	511: Res-Custom Code	0.9800
39045-0536082500	39	045	125 ELLWOOD AVE LANCASTER 43130	LANCASTER	OH	43130		Fairfield	41740	Lancaster City	031600	316	1811.5559	1		39045C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	257.1307	258.3713	257.4834	510: Res-Single Family	510: Res-Single Family	0
39045-0350168800	39	045	505 MARIETTA ST	BREMEN	OH	43107		Fairfield	69120	Rush Creek	031100	311	893.1976	4		39045C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	242.2893	242.9232	242.5884	510: Res-Single Family	510: Res-Single Family	0
39045-0100250200	39	045	330 ABBEY AVE LITHOPOLIS 43136	LITHOPOLIS	OH	43136		Fairfield	06950	Bloom	030700	307	943.9738	1		39045C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	256.3918	259.9384	258.2513	510: Res-Single Family	510: Res-Single Family	0
39045-0210083511	39	045	0 PLEASANTVILLE RD BALTIMORE 43…	BALTIMORE	OH	43105		Fairfield	43120	Liberty	030400	304	1425.2873	0		39045C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	287.5974	289.9547	288.8099	610: Exm-Ohio	610: Exm-Ohio	0.3500
39045-0350183000	39	045	317 HIGHLAND BLVD BREMEN 43107	BREMEN	OH	43107		Fairfield	69120	Rush Creek	031100	311	1454.2598	1		39045C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	243.2982	244.6250	243.9110	510: Res-Single Family	510: Res-Single Family	0.0700
39045-0080149600	39	045	432 DENNISON CT	LANCASTER	OH	43130		Fairfield	06950	Bloom	030800	308	7385.2981	1		39045C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	324.8442	331.2753	327.4373	510: Res-Single Family	510: Res-Single Family	0
39045-0360638600	39	045	8805 TERRACE RIDGE LN PICKERING…	PICKERINGTON	OH	43147		Fairfield	80206	Violet	032902	329.0200	264.0312	1		39045C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	281.4111	284.1770	283.1027	550: Res-Condo	550: Res-Condo	0.1700
39045-0536257000	39	045	1846 UNION ST LANCASTER 43130	LANCASTER	OH	43130		Fairfield	41740	Lancaster City	031600	316	1289.7465	1		39045C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	262.0061	265.0446	263.6045	510: Res-Single Family	510: Res-Single Family	0
39045-0532151600	39	045	1884 NELSON RD LANCASTER 43130	LANCASTER	OH	43130		Fairfield	41740	Lancaster City	031500	315	804.3388	1		39045C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	259.6692	260.7054	260.2156	510: Res-Single Family	510: Res-Single Family	0
39045-0360302200	39	045	9999 ALLISTON DR PICKERINGTON 4…	PICKERINGTON	OH	43147		Fairfield	80206	Violet	032800	328	1248.0720	1		39045C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	263.0584	265.6088	264.7215	510: Res-Single Family	510: Res-Single Family	0
39045-0340028720	39	045	8420 MARIETTA RD BREMEN 43107	BREMEN	OH	43107		Fairfield	69120	Rush Creek	031100	311	8745.7835	1		39045C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	268.7434	279.3973	274.5141	511: Res-Custom Code	511: Res-Custom Code	2.1600
39045-0360000200	39	045	11960 SAYLOR RD PICKERINGTON 43…	PICKERINGTON	OH	43147		Fairfield	80206	Violet	032901	329.0100	8028.9611	2		39045C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	293.5808	297.1202	295.5274	511: Res-Custom Code	511: Res-Custom Code	1.9800
39045-0040053300	39	045	5800 BORAH HILL RD LANCASTER 43…	LANCASTER	OH	43130		Fairfield	05956	Berne	031200	312	14334.3912	4		39045C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	313.1581	326.6746	321.2701	521: Res-Custom Code	521: Res-Custom Code	3.3000