Saved query 3f097d7b83056006

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 = '31' 
  AND countyfp = '059'

6,924 matching parcels

Data Preview

parcelid	statefp	countyfp	parceladdr	parcelcity	parcelzip	countyname	cousubfp	cousubname	tractce	tractname	calcarea	imprvalue	landvalue	totalvalue	saleamt	saledate	numbldgs	numunits	yearbuilt	firmid	firmdate	fldzone	zonesubty	elevmin	elevmax	elevavg	usecode	zoningcode	taxacres	naicscode	legaldesc	placename	placetype	taxdistrict
300004683	31	059	640 9TH AVE	FAIRMONT	68354	Fillmore	16395	Exeter-Fairmont Consolidated	091600	916	880.5961	97380	6335	103715	15500	2005-11-16	1	1	1895	31059C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	499.9930	500.8430	500.4863	010101010701	01	0.2175		ORIGINAL TOWN LOT 550 & S 1/2 L…			20
300038823	31	059	1910 ROAD P	GENEVA	68361	Fillmore	18965	Glengary	091600	916	15581.4036	121520	30710	152230	100000	2019-09-06	1	1	1925	31059C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	482.1361	486.7060	484.6324	010101030905	01	3.8486		TR IN SW SLUKA SUBDIVISION			164
300035782	31	059	1707 F ST	GENEVA	68361	Fillmore	08955	Chelsea	091700	917	6093.7249	1157770	22500	1180270	1372340	2020-08-18	1	1	2020	31059C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD				010303010604	03	1.5051	4552	TR IN ENW SHAW SUBDIVISION	DOLLAR GENERAL	DISCOUNT_STORE	120
300006227	31	059	1116 G ST	FAIRMONT	68354	Fillmore	16395	Exeter-Fairmont Consolidated	091600	916	2034.8659	174960	8275	183235	310000	2025-05-02	1	1	2015	31059C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	498.7070	499.3330	499.0933	010303010702	03	0.5026		EAST ADD W 84' OF LOTS 11-16 BL…			20
300003136	31	059	304 S E BOUNDARY AVE	EXETER	68351	Fillmore	16395	Exeter-Fairmont Consolidated	091600	916	2770.1762	155745	18245	173990	205000	2024-06-03	1	1	1968	31059C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	489.4540	490.4370	489.9799	010101010703	01	0.6842		H G SMITH'S ADD W 71' OF LOT 3 …			1
300021154	31	059	202 S MAIN ST	OHIOWA	68416	Fillmore	17495	Franklin	091600	916	8536.0500	2500	3970	6470	18000	2013-03-10	1	1		31059C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD				010303010705	03	2.1086	6111	FIRST ADD SCHOOL BLOCK (300 X 3…	OHIOWA PUBLIC SCHOOL	PLACE_OF_LEARNING	301
300014021	31	059	514 H ST	GENEVA	68361	Fillmore	18440	Geneva	091700	917	2623.1191	182500	12610	195110		2023-12-12	1	1	1955	31059C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD				010303010603	03	0.6478	441	BIGELOWS FOURTH ADD LOTS 70-72 …	MIDWEST MOTORSPORTS	VEHICLE_SERVICE	100
300043834	31	059	602 ROAD O	SHICKLEY	68436	Fillmore	32515	Momence	091700	917	323576.5450	124410	543885	668295		2014-11-11	1	1	1983	31059C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	503.2980	509.3930	506.9249	010505030909	05	79.9277		SSW			224
300002093	31	059	322 S BURLINGTON AVE	EXETER	68351	Fillmore	16395	Exeter-Fairmont Consolidated	091600	916	1122.4585	2000	10470	12470		2021-04-15	1	1	1910	31059C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	489.7520	490.2910	489.9915	010101010702	01	0.2772		ORIGINAL TOWN LOTS 509-510 EXET…			1
300000126	31	059	409 N UNION AVE	EXETER	68351	Fillmore	16395	Exeter-Fairmont Consolidated	091600	916	736.4482	65685	6545	72230		2003-08-07	1	1	1977	31059C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	490.4040	491.1830	490.8728	010101010701	01	0.1818		ORIGINAL TOWN E 70' OF THE E 14…			1
300016919	31	059	701 P ST	MILLIGAN	68406	Fillmore	18965	Glengary	091600	916	796.9303	29320	1490	30810		2014-10-27	1	1	1915	31059C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	487.1520	487.5630	487.3793	010101010701	01	0.1968		PLACEK'S SECOND ADD S 1/4 LOT 7…			160
300049763	31	059	1812 ROAD V	OHIOWA	68416	Fillmore	03915	Belle Prairie	091600	916	323569.4999	28320	579585	607905		2018-04-18	1	1	1890	31059C	2026-01-08	A		479.6070	485.5700	481.7439	010505030909	05	79.9309		WSE			285
300039179	31	059	806 ROAD 25	TOBIAS	68453	Fillmore	18965	Glengary	091600	916	323772.4380	29275	271690	300965			1	1	1925	31059C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	491.3030	494.3710	493.1455	010505030909	05	79.9779		ESE			163
300037632	31	059	1305 ROAD 20	MILLIGAN	68406	Fillmore	26945	Liberty	091600	916	310115.6862	50485	370800	421285		2019-12-09	1	1	1920	31059C	2026-01-08	A		466.6490	480.2510	472.3375	010505030909	05	76.6010		WSW LESS ST & CO ROW			142
300000049	31	059	307 E OSAGE ST	EXETER	68351	Fillmore	16395	Exeter-Fairmont Consolidated	091600	916	3642.8594	182505	19360	201865			1	1	1963	31059C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	490.1100	490.9550	490.4426	010101010703	01	0.8997		ORIGINAL TOWN W 1/2 LOT 2 EXETE…			1
300000693	31	059	405 E OSCEOLA ST	EXETER	68351	Fillmore	16395	Exeter-Fairmont Consolidated	091600	916	1189.0543	29700	10470	40170			1	1	1886	31059C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	489.5000	490.2380	489.8074	010101010702	01	0.2936		ORIGINAL TOWN LOTS 100-101 EXET…			1
300024003	31	059	2004 HWY 6	EXETER	68351	Fillmore	16395	Exeter-Fairmont Consolidated	091600	916	12363.8975	6000	11465	17465		2019-03-20	1	1		31059C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	490.8190	494.3949	491.4586	010505020907	05	3.0539		TR WSW HALL ACRES SUB			2
300021063	31	059	301 S LUKE ST	OHIOWA	68416	Fillmore	17495	Franklin	091600	916	1993.2083	8365	2800	11165	200	2006-06-08	1	1	1906	31059C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD				010101010703	01	0.4923		FIRST ADD LOTS 7-9 BLK 9 OHIOWA…			308
300008365	31	059	1035 H ST	GENEVA	68361	Fillmore	18440	Geneva	091700	917	1619.9746	71170	15900	87070	14000	2016-07-18	1	1	1920	31059C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD				010101010602	01	0.4001		ORIGINAL TOWN LOTS 51-52 BLK 6 …			100
300022253	31	059	424 N 16TH ST	GENEVA	68361	Fillmore	30205	Madison	091700	917	3312.1619	174495	35725	210220	157000	2011-06-03	1	1	1906	31059C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD				010101010603	01	0.8181		GRANDVIEW ADD LOTS 5-6 & LOTS 2…			120
300007070	31	059		GRAFTON	68365	Fillmore	19490	Grafton	091700	917	614.7670	18520	925	19445			1	1	1976	31059C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD				010303010701	03	0.1518	4911	ORIGINAL TOWN LOT 162 GRAFTON N…	UNITED STATES POSTAL SERVICE	SHIPPING_CENTER	65
300004907	31	059	455 F ST	FAIRMONT	68354	Fillmore	16395	Exeter-Fairmont Consolidated	091600	916	991.7999	65090	6785	71875	72000	2021-12-29	1	1	1935	31059C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD				010101010702	01	0.2450		ORIGINAL TOWN LOT 604 & N 30' O…			20
300022001	31	059	331 N 14TH ST	GENEVA	68361	Fillmore	30205	Madison	091700	917	862.7571	133695	11480	145175	110000	2021-03-30	1	1	2003	31059C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD				010101010601	01	0.2130		GRANDVIEW ADD LOT 1 BLK 13 GENE…			120
300017696	31	059	301 N MARKET ST	SHICKLEY	68436	Fillmore	06925	Bryant	091700	917	671.8074	57975	5040	63015	280000	2022-12-19	1	1	1962	31059C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD				010303010702	03	0.1659		ORIGINAL TOWN LOT 11-12 BLK 3 S…			240
300009485	31	059	436 N 12TH ST	GENEVA	68361	Fillmore	18440	Geneva	091700	917	962.0950	69310	9775	79085	22000	2002-09-23	1	1	1948	31059C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD				010101010602	01	0.2376		HEIDERSTADTS SUB OUTLOT 11 S 12…			100