Saved query 96c698d773f17b12

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

24,498 matching parcels

Data Preview

parcelid	statefp	countyfp	parceladdr	parcelcity	parcelstate	parcelzip	ownername	countyname	cousubfp	cousubname	tractce	tractname	calcarea	numbldgs	firmid	firmdate	fldzone	zonesubty	elevmin	elevmax	elevavg	taxacres	ownertype	naicscode	placename	placetype	taxdistrict
31-02662 000	39	097	208 OLIVE STREET	LONDON	OH	43140	SMITH WANANER PROPERTIES LLC	Madison	44674	London	040700	407	932.2374	1	39097C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	315.3336	315.9676	315.5757	0.2300	BUSINESS	23832	RED RAIDER PRESSURE WASHING & P…	HOME_SERVICE	MADISON
31-00416 000	39	097	58 EAST HIGH STREET	LONDON	OH	43140	MAYFORD A HARRIS III NATALIE J …	Madison	44674	London	040700	407	505.6108	1	39097C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	319.5474	321.0292	320.2709	0	PERSON	7225	VALLERY FARMHOUSE BAKERY	CASUAL_EATERY	MADISON
31-03401 000	39	097	336 ELM STREET	LONDON	OH	43140	BOARD OF EDUCATION LONDON CITY …	Madison	44674	London	040600	406	200348.9940	10	39097C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	319.2460	325.0496	322.6896	50	PERSON	813110	CYPRESS CHURCH LONDON CAMPUS	RELIGIOUS_ORGANIZATION	MADISON
17-00525 000	39	097	10850 THIRD STREET SE	PLEASANT	OH	43143	GROVER RICHARD G JEAN E TRUSTEE…	Madison	63338	Pleasant	041200	412	5574.6857	1	39097C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	275.4004	277.1897	276.4687	1.3770	TRUST	4552	DOLLAR GENERAL	DISCOUNT_STORE	MADISON
02-00357 003	39	097	1591 MAREN STREET	PLAIN CITY	OH	43064	TROYER PERRY E EDNA L TRUSTEES	Madison	20142	Darby	040101	401.0100	259740.2047	0	39097C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	287.1985	290.7477	289.5483	64.3400	PERSON	62141	PLAIN CITY UNITED METHODIST CHU…	CHRISTIAN_PLACE_OF_WORSHIP	MADISON
08-00902 005	39	097	1800 US 42 NE	JEFFERSON	OH	43140	STATE ROUTE 29 LLC AN OHIO LIMI…	Madison	38696	Jefferson	040400	404	66582.4012	0	39097C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	298.1118	301.9437	299.8428	16.4500	BUSINESS	23829			MADISON
02-00029 002	39	097	10635 US 42 NE	DARBY	OH	43064	PLEASANT VALLEY OAK MEADOWS LLC	Madison	20142	Darby	040102	401.0200	90460.3643	6	39097C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	285.5243	287.5035	286.3319	132.9900	BUSINESS	1132			MADISON
28-00147 000	39	097	-9 EAST NORTH STREET SW	SOUTH SOLON	OH	43153	PITSTICK BROTHERS ENTERPRISES I…	Madison	74784	Stokes	041300	413	14974.0053	13	39097C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	338.7481	341.0581	339.6731	3.7500	BUSINESS	111910			MADISON
04-00725 000	39	097	133 BIGELOW AVENUE	PLAIN CITY	OH	43064	VILLAGE OF PLAIN CITY COUNCIL B…	Madison	20142	Darby	040102	401.0200	2541.3728	1	39097C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	284.0457	284.5281	284.3300	0	NONPROFIT	2372			MADISON
14-00120 000	39	097	6770 SR 38 SW	PAINT	OH	43140	NEWPORT CHURCH OF CHRIST IN CHR…	Madison	59528	Paint	041300	413	607.1113	0	39097C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	325.7008	326.2720	325.9687	0	NONPROFIT	6112			MADISON
13-00036 007	39	097	6825 GREGG MILL ROAD SE	OAK RUN	OH	43140	HAY DEBRA J MICHAEL S TURNER JT…	Madison	57708	Oak Run	041100	411	81291.2334	0	39097C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	285.6915	302.7881	294.7713	20.1000	PERSON				MADISON
29-00573 000	39	097	3700 WOOD LANE SE	UNION	OH	43140	DANIELS THOMAS A TONI M	Madison	78428	Union	041100	411	833.5189	0	39097C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	296.9234	304.8754	301.2682	0	PERSON				MADISON
31-03399 016	39	097	1037 BRAXTON BOULEVARD	LONDON	OH	43140	FITCH BRYCE TERRA RUNYON JT LIV…	Madison	44674	London	040600	406	897.6854	2	39097C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	314.0036	315.4037	314.6576	0	PERSON				MADISON
04-00824 250	39	097	807 NIGHTHAWK DRIVE	PLAIN CITY	OH	43064	MILLER EARL J JODIE A MILLER JT…	Madison	20142	Darby	040102	401.0200	799.9102	1	39097C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	282.6152	283.3708	283.1085	0.1970	PERSON				MADISON
10-00151 000	39	097	555 CRESCENT DRIVE	WEST JEFFERSON	OH	43162	HYMILLER ELIZABETH A	Madison	38696	Jefferson	040400	404	689.2378	2	39097C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	286.3280	287.9557	287.0187	0	PERSON				MADISON
24-00352 000	39	097	1465 CHICKASAW DRIVE NW	CHOCTAW LAKE	OH	43140	GREENLEE KURT A MICHELLE A JT L…	Madison	72960	Somerford	040201	402.0100	1904.1310	0	39097C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	321.6395	327.8065	324.9110	0	PERSON				MADISON
31-01722 000	39	097	73 LAUREL STREET	LONDON	OH	43140	HAAKMA CHARLES M	Madison	44674	London	040700	407	359.8849	0	39097C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	319.3119	319.8942	319.5538	0	PERSON				MADISON
10-00421 000	39	097	378 MAIN STREET	WEST JEFFERSON	OH	43162	PAMELA S ONEY	Madison	38696	Jefferson	040400	404	1814.9796	1	39097C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	281.6169	283.0511	282.5839	0.4500	PERSON				MADISON
18-00817 000	39	097	16 NORTH MARKET STREET	MOUNT STERLING	OH	43143	BAYNES GERALD T	Madison	63338	Pleasant	041200	412	309.5544	1	39097C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	275.1737	275.8215	275.5511	0	PERSON				MADISON
31-02241 000	39	097	130 HAWTHORNE AVENUE	LONDON	OH	43140	PUCKETT HELEN L TOD THOMAS J PU…	Madison	44674	London	040700	407	240.5234	0	39097C	2025-12-11	X	0.2 PCT ANNUAL CHANCE FLOOD HAZ…	317.7615	318.3769	317.9371	0	PERSON				MADISON
10-00869 000	39	097	35 PUTNAM AVENUE	WEST JEFFERSON	OH	43162	UNDER PAR ENTERPRISES LLC	Madison	38696	Jefferson	040400	404	298.9207	0	39097C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	285.6893	286.1794	285.9318	0	BUSINESS	3341			MADISON
31-03392 036	39	097	498 SAMANTHA CIRCLE	LONDON	OH	43140	MERRITT GREGORY T	Madison	44674	London	040600	406	168.7538	0	39097C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	314.1727	314.4688	314.2975	0	PERSON				MADISON
04-00747 000	39	097	410 CARRIAGE DRIVE	PLAIN CITY	OH	43064	JOHNSON ANGIE K TOD ZACHERY K J…	Madison	20142	Darby	040102	401.0200	931.5790	1	39097C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	284.7819	285.9155	285.3475	0	PERSON				MADISON
28-00058 000	39	097	13055 SOUTH WASHINGTON STREET SW	SOUTH SOLON	OH	43153	ROBBINS DONALD E DARLA J	Madison	74784	Stokes	041300	413	492.2649	1	39097C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	337.5491	338.1156	337.7728	0	PERSON				MADISON
31-00888 000	39	097	225 JENKINSON AVENUE	LONDON	OH	43140	JACKSON GEORGE A	Madison	44674	London	041100	411	475.1014	0	39097C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	316.2608	317.4617	316.9386	0	PERSON				MADISON