Saved query 33c4d44772bb28fc

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

36,024 matching parcels

Data Preview

parcelid	taxacctnum	statefp	countyfp	parceladdr	parcelcity	parcelstate	parcelzip	ownername	countyname	cousubfp	cousubname	tractce	tractname	calcarea	saledate	numbldgs	numunits	numfloors	firmid	firmdate	fldzone	zonesubty	elevmin	elevmax	elevavg	usecode	taxacres	ownertype	naicscode	parceltype	accesstype	iucnclass	placename	placetype	taxdistrict
39-0024042.1350	39-0024042.1350	39	159	TUSCANY DRIVE	DUBLIN	OH	DUBLIN OH 43016	CITY OF DUBLIN	Union	81242	WASHINGTON	050601	506.0100	15557.1520	2006-09-14	1			39049C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	292.5242	296.2054	293.4376	640	3.8400	GOVERNMENT	4879	GOVT LOCAL	OPEN	V	TARTAN WEST OPEN SPACE "R"	LOCAL CONSERVATION AREA	WASH.TWP/FRANKLIN CO. DUBLIN CO…
30-0015010.0000	30-0015010.0000	39	159	19817 RAYMOND RD	MARYSVILLE	OH	MARYSVILLE OH 43040	Higginbotham Fred L Lynette J	Union	76194	TAYLOR	050301	503.0100	16476.1783	2013-04-12	4			39159C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	306.0717	309.1094	307.4337	101	3.9630	PERSON	45931				MADISON HOUSE DESIGNS	FLOWERS_AND_GIFTS_STORE	MARYSVILLE EVSD
29-0016011.0000	29-0016011.0000	39	159	16450 16470 SQUARE DR	MARYSVILLE	OH	MARYSVILLE OH 43040	ROOSTERS REAL ESTATE LLC	Union	59864	PARIS	050303	503.0300	7608.9191	2025-01-15	1			39159C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	300.6070	302.4568	301.4872	430	1.8400	BUSINESS	7225				ROOSTERS	RESTAURANT	MARYSVILLE CORP
22-0001018.0000	22-0001018.0000	39	159	CODER HOLLOWAY RD	RAYMOND	OH	RAYMOND OH 43067	J D Holloway Farms LLC	Union	43358	LIBERTY	050200	502	32110.9350	2013-05-30	0			39159C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	328.3330	332.4696	330.4268	110	3.7500	BUSINESS	1122						MARYSVILLE EVSD
39-0028014.1380	39-0028014.1380	39	159	8101 S OAK TREE DR	DUBLIN	OH	DUBLIN OH 43016	KENRIC CONSTRUCTION INC	Union	81242	WASHINGTON	050601	506.0100	743.9577	2024-05-31	1			39049C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	282.7064	283.9777	283.5115	500	0	BUSINESS	2361						WASH.TWP/FRANKLIN CO. DUBLIN CO…
29-0022001.3220	29-0022001.3220	39	159	1063 TARRAGON DR	MARYSVILLE	OH	MARYSVILLE OH 43040	MEDDLES CHAD E	Union	59864	PARIS	050303	503.0300	724.7629		1	1	2	39159C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	307.4634	309.5899	308.6013	510	0	PERSON							MARYSVILLE CORP
18-0002026.0000	18-0002026.0000	39	159	145 E 1ST AVE	PLAIN CITY	OH	PLAIN CITY OH 43064	RFHF REAL ESTATE LLC	Union	39046	JEROME	050601	506.0100	285.0938	2020-04-10	0			39097C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	284.7013	285.0738	284.9167	500	0	BUSINESS	2372						PLAIN CITY CORP
39-0029013.1180	39-0029013.1180	39	159	WOOLEY DR	DUBLIN	OH	DUBLIN OH 43016	Paragon Building Group Ltd	Union	81242	WASHINGTON	050601	506.0100	817.3678	2023-11-09	0			39159C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	283.6752	284.0985	283.8971	500	0	BUSINESS	2361						WASH.TWP/FRANKLIN CO. DUBLIN CO…
13-0016018.0000	13-0016018.0000	39	159	ST RT 37	RICHWOOD	OH	RICHWOOD OH 43344	PARISH ELMA J	Union	38108	JACKSON	050100	501	104813.8626	2023-06-16	1			39159C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	288.3364	292.5031	290.5130	199	25.5340	NONPROFIT	6111						NORTH UNION LSD
28-0017046.0000	28-0017046.0000	39	159	14821 WATKINS RD	MARYSVILLE	OH	MARYSVILLE OH 43040	THE MARYSVILLE LAND COMPANY II …	Union	59864	PARIS	050602	506.0200	4624.8401	2025-06-09	3			39159C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	297.7448	298.7381	298.1094	511	1.1399	BUSINESS	2372						MARYSVILLE EVSD
05-0009030.0000	05-0009030.0000	39	159	ST RT 47	RICHWOOD	OH	RICHWOOD OH 43344	4J SWARTZ FARMS LLC	Union	15112	CLAIBOURNE	050200	502	61963.8525	2025-01-16	0			39159C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	288.7087	291.4067	290.0571	110	15.5900	BUSINESS	1122						NORTH UNION LSD
17-0011012.0400	17-0011012.0400	39	159	10719 PEARL CREEK DRIVE	PLAIN CITY	OH	PLAIN CITY OH 43064	Jerome Village Company LLC	Union	39046	JEROME	050601	506.0100	13788.7987	2020-02-19	0			39159C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	296.2709	298.8530	297.5073	500	3.4060	BUSINESS	3212						DUBLIN CSD
29-0009034.0000	29-0009034.0000	39	159	121 S MAIN ST	MARYSVILLE	OH	MARYSVILLE OH 43040	Marysville Uptown Theatre LLC	Union	59864	PARIS	050402	504.0200	532.1678	2017-07-19	0			39159C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	301.6838	302.1394	301.9141	460	0	BUSINESS	71111						MARYSVILLE CORP
15-0033037.0000	15-0033037.0000	39	159	INDUSTRIAL PKWY	PLAIN CITY	OH	PLAIN CITY OH 43064	CP NEW CALIFORNIA LLC	Union	39046	JEROME	050601	506.0100	535.8545	2021-08-13	0			39159C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	304.8910	305.3069	305.1632	500	0	BUSINESS	23891						JONATHAN ALDER LSD
17-0010018.0970	17-0010018.0970	39	159	8236 WOODSTAR DR	PLAIN CITY	OH	PLAIN CITY OH 43064	ROCKFORD HOMES INC	Union	39046	JEROME	050601	506.0100	1179.7210	2024-06-07	0			39159C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	293.7336	294.4396	293.8602	500	0	BUSINESS	2361						DUBLIN CSD
29-0018049.0770	29-0018049.0770	39	159	SKYVIEW DR	MARYSVILLE	OH	MARYSVILLE OH 43040	Grand Communities LLC	Union	59864	PARIS	050702	507.0200	679.9976	2023-11-02	0			39159C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	311.3045	312.5627	311.9017	500	0	BUSINESS	6233						MARYSVILLE CORP
29-0019082.0000	29-0019082.0000	39	159	1305 W 5TH ST	MARYSVILLE	OH	MARYSVILLE OH 43040	McDonald s USA LLC	Union	59864	PARIS	050401	504.0100	5455.4189	2023-02-10	1			39159C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	306.6475	309.4245	307.2500	435	1.3490	BUSINESS	512132						MARYSVILLE CORP
03-0003027.0020	03-0003027.0020	39	159	19466 SMOKEY RD	MARYSVILLE	OH	MARYSVILLE OH 43040	Duff Brothers LLC	Union	01336	ALLEN	050301	503.0100	15537.1042	2015-12-09	0			39159C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	332.9331	335.6684	334.5282	110	3.7900	BUSINESS	3325						MARYSVILLE EVSD
29-0025004.3160	29-0025004.3160	39	159	1913 SADDLEHORN WAY	MARYSVILLE	OH	MARYSVILLE OH 43040	MEYERS ADAM JARED MEYERS RACHEL…	Union	59864	PARIS	050303	503.0300	720.0597	2020-07-10	1			39159C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	305.7952	306.8979	306.5561	510	0	PERSON							MARYSVILLE CORP
03-0006002.7000	03-0006002.7000	39	159	24610 DARBY POTTERSBURG RD	MARYSVILLE	OH	MARYSVILLE OH 43040	Basinger Robert M Leslie M Basi…	Union	01336	ALLEN	050301	503.0100	24889.0882	2018-12-12	2			39159C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	325.9330	330.7013	327.6983	511	6.1500	PERSON							MARYSVILLE EVSD
29-0019032.1490	29-0019032.1490	39	159	625 TIMBERVIEW LN	MARYSVILLE	OH	MARYSVILLE OH 43040	Tipple Loran M	Union	59864	PARIS	050501	505.0100	1110.6738	2013-08-13	1			39159C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	317.7675	318.9338	318.5009	510	0	PERSON							MARYSVILLE CORP
35-0018022.0000	35-0018022.0000	39	159	31378 ST RT 31	RICHWOOD	OH	RICHWOOD OH 43344	YOUNG NATALIE P	Union	81662	WASHINGTON	050100	501	6229.3604	2024-05-23	2			39159C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	309.0471	312.0750	310.6561	511	1.5200	PERSON							NORTH UNION LSD
32-0004045.0010	32-0004045.0010	39	159	MAPLE RIDGE RD	MILFORD CENTER	OH	MILFORD CENTER OH 43045	Gregory Daniel J	Union	78582	UNION	050702	507.0200	25797.2296	2019-01-22	0			39159C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	305.2412	318.9058	309.7613	110	6.3789	PERSON							FAIRBANKS LSD
29-0030058.0150	29-0030058.0150	39	159	1599 ADENA POINTE DR	MARYSVILLE	OH	MARYSVILLE OH 43040	Sebastian Abigail L	Union	59864	PARIS	050501	505.0100	845.1430	2016-06-20	1			39159C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	305.9164	308.2243	307.0446	510	0	PERSON							MARYSVILLE CORP
11-0002002.0010	11-0002002.0010	39	159	DELAWARE CO LINE RD	MARYSVILLE	OH	MARYSVILLE OH 43040	MCDOWELL GARY J	Union	22484	DOVER	050304	503.0400	246663.9655	2020-10-13	0			39159C	2025-12-11	X	AREA OF MINIMAL FLOOD HAZARD	287.8335	289.8232	288.3069	110	58.4100	PERSON							MARYSVILLE EVSD