Saved query 6d50a73b96341062

Data Explorer

Query the US Nationwide Parcel Dataset

$1.75 / 1,000 records$100 minimum

36/80

Live SQL

SELECT * 
FROM "parcel_layer" 
WHERE statefp = '39' 
  AND countyfp = '049'

448,873 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	naicscode	parceltype	accesstype	placename	placetype
39049-010-035554	39	049	49 E HUBBARD AV	COLUMBUS	OH	43215	90 W BROAD ST	COLUMBUS	OH	43215	Franklin	18000	Columbus	002200	22	3377.0879	0		39049C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	231.2410	232.6230	231.9604	640: Exm-Municipality	640: Exm-Municipality	712190	GOVT LOCAL	OPEN	ITALIAN VILLAGE PARK	PARK
39049-010-297472	39	049	250 W SPRING ST 1025	COLUMBUS	OH	43215	250 W SPRING ST UNIT 250-1025	COLUMBUS	OH	43215	Franklin	18000	Columbus	003000	30	1692.5410	1	10	39049C	2025-12-11	X	0.2 PCT ANNUAL CHANCE FLOOD HAZ…	219.1763	221.3480	220.3578	550: Res-Condo	550: Res-Condo	71212			PARKS EDGE CONDOMINIUMS	HISTORIC_SITE
39049-026-190710	39	049	1130 MORRISON RD	GAHANNA	OH	43230	1480 DUBLIN RD	COLUMBUS	OH	43215	Franklin	50064	Mifflin	007427	74.2700	9974.2052	1		39049C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	245.0747	248.2442	246.7892	353: Ind-Custom Code	353: Ind-Custom Code	33612			MCNEILUS TRUCK AND MANUFACTURING	MANUFACTURER
39049-030-002638	39	049	1000 URLIN AV		OH	43212	1000 URLIN AVE 517	COLUMBUS	OH	43212	Franklin	31304	Grandview Heights	008400	84	1903.8892	1	23	39049C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	233.5733	239.5163	238.1990	550: Res-Condo	550: Res-Condo	52315			ACE INVESTIGATIONS	FINANCIAL_SERVICE
39049-510-160258	39	049	795 BREATHITT AV	COLUMBUS	OH	43207	795 BREATHITT AVE	COLUMBUS	OH	43207	Franklin	18000	Columbus	008825	88.2500	651.8383	2		39049C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	224.1011	225.2190	224.8128	510: Res-Single Family	510: Res-Single Family	6216			A BETTER DRAIN	HOME_SERVICE
39049-240-001801	39	049	0 W BROAD ST	COLUMBUS	OH	43228	5065 DELRAY AVE SOLON	SOLON	OH	44139	Franklin	64570	Prairie	008120	81.2000	693.7258	0		39049C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	277.3294	278.1793	277.8042	429: Com-Other	429: Com-Other	4581			RED WING	FASHION_AND_APPAREL_STORE
39049-120-000008	39	049	3064 AMITY RD	HILLIARD	OH	43026	3064 AMITY RD	HILLIARD	OH	43026	Franklin	09442	Brown	008001	80.0100	27185.1711	4		39049C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	273.8443	280.4591	278.8161	511: Res-Custom Code	511: Res-Custom Code	4442			DAYLILIES ON THE PRAIRIE	HARDWARE_HOME_AND_GARDEN_STORE
39049-010-067372	39	049	113 E WOODRUFF AV	COLUMBUS	OH	43201	222 E 11TH AVE	COLUMBUS	OH	43209	Franklin	18000	Columbus	001200	12	301.1724	1	2	39049C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	238.1540	239.3925	238.9588	520: Res-Two Family	520: Res-Two Family
39049-010-050939	39	049	294 FOURTEENTH AV	COLUMBUS	OH	43201	3815 PATRICIA DR	COLUMBUS	OH	43220	Franklin	18000	Columbus	001302	13.0200	609.9001	2	2	39049C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	242.2489	243.9887	243.4685	510: Res-Single Family	510: Res-Single Family
39049-070-007763	39	049	1707 MCCOY RD	COLUMBUS	OH	43220	1707 MCCOY RD	COLUMBUS	OH	43220	Franklin	79002	Upper Arlington	006321	63.2100	2385.4625	2		39049C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	266.9387	268.2991	267.7393	510: Res-Single Family	510: Res-Single Family
39049-545-260162	39	049	6380 ROSE GARDEN DR	NEW ALBANY	OH	43054	6380 ROSE GARDEN DR	NEW ALBANY	OH	43054	Franklin	18000	Columbus	007209	72.0900	828.3665	1		39049C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	288.8292	291.3866	290.2341	510: Res-Single Family	510: Res-Single Family
39049-570-234887	39	049	2026 QUEENS MEADOW LN	GROVE CITY	OH	43123	2026 QUEENS MEADOW LN	GROVE CITY	OH	43123	Franklin	18000	Columbus	008380	83.8000	638.4167	1		39049C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	225.2421	226.8664	226.0375	510: Res-Single Family	510: Res-Single Family
39049-025-011006	39	049	307 MARJORAM DR	GAHANNA	OH	43230	307 MARJORAM DR	COLUMBUS	OH	43230	Franklin	50064	Mifflin	007492	74.9200	1030.0163	1		39049C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	249.5928	251.6897	250.8995	510: Res-Single Family	510: Res-Single Family
39049-185-001483	39	049	4860 APPLE GROVE CT	GROVEPORT	OH	43125	2639 DIANE PL	COLUMBUS	OH	43207	Franklin	46410	Madison	009495	94.9500	1575.4749	1		39049C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	227.6067	229.0139	228.1562	510: Res-Single Family	510: Res-Single Family
39049-180-004220	39	049	5178 S RUTLEDGE DR	COLUMBUS	OH	43232	5178 RUTLEDGE DR S COLUMBUS	COLUMBUS	OH	43232	Franklin	46410	Madison	009410	94.1000	841.3861	3		39049C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	231.0001	231.7775	231.3767	510: Res-Single Family	510: Res-Single Family
39049-010-020426	39	049	179 ORCHARD LN	COLUMBUS	OH	43214	179 ORCHARD LN	COLUMBUS	OH	43214	Franklin	18000	Columbus	000410	4.1000	544.8157	2		39049C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	231.4071	232.8453	232.2582	510: Res-Single Family	510: Res-Single Family
39049-610-173322	39	049	7847 SUTCLIFF CT	DUBLIN	OH	43016	7847 SUTCLIFF CT	DUBLIN	OH	43016	Franklin	18000	Columbus	006393	63.9300	954.1773	1		39049C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	273.2508	274.4462	273.9336	510: Res-Single Family	510: Res-Single Family
39049-010-025121	39	049	1907 FAIRMONT AV	COLUMBUS	OH	43223	1907 FAIRMONT AVE	COKLUMBUS	OH	43223	Franklin	18000	Columbus	004900	49	648.8631	1		39049C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	235.8230	237.3110	236.6716	510: Res-Single Family	510: Res-Single Family
39049-060-001618	39	049	650 GILMORE DR	REYNOLDSBURG	OH	43068	650 GILMORE DR	REYNOLDSBURG	OH	43068	Franklin	77714	Truro	009382	93.8199	683.9703	2		39049C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	270.6947	271.7034	271.2904	510: Res-Single Family	510: Res-Single Family
39049-010-127088	39	049	1054 OBERLIN DR	COLUMBUS	OH	43221	1054 OBERLIN DR	COLUMBUS	OH	43221-1630	Franklin	18000	Columbus	007811	78.1100	771.4478	2		39049C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	243.1808	244.5776	244.1333	510: Res-Single Family	510: Res-Single Family
39049-140-002821	39	049	36 FLORENCE AV	COLUMBUS	OH	43228	36 FLORENCE AVE	COLUMBUS	OH	43228	Franklin	28280	Franklin	008210	82.1000	526.1615	1		39049C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	257.2861	257.8711	257.5942	510: Res-Single Family	510: Res-Single Family
39049-010-073123	39	049	1082 NINETEENTH AV	COLUMBUS	OH	43211	3000 NORTH STAR RD	WORTHINGTON	OH	43085	Franklin	18000	Columbus	000730	7.3000	415.6912	1		39049C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	258.9659	259.6452	259.3230	510: Res-Single Family	510: Res-Single Family
39049-010-276805	39	049	6119 RACKLEY WY	COLUMBUS	OH	43081	6119 RACKLEY WAY	WESTERVILLE	OH	43081	Franklin	18000	Columbus	007215	72.1500	919.6374	1		39049C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	300.1883	301.2575	300.7740	510: Res-Single Family	510: Res-Single Family
39049-060-002953	39	049	1620 SHIVELY RD	REYNOLDSBURG	OH	43068	1620 SHIVELY RD	REYNOLDSBURG	OH	43068	Franklin	77714	Truro	009384	93.8400	685.5448	1		39049C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	266.9849	268.6183	268.0731	510: Res-Single Family	510: Res-Single Family
39049-010-133647	39	049	3336 QUAKER RD	COLUMBUS	OH	43207	3336 QUAKER RD	COLUMBUS	OH	43207	Franklin	18000	Columbus	008813	88.1300	544.8563	2		39049C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	231.1613	232.3139	231.7308	510: Res-Single Family	510: Res-Single Family