Saved query 0719aa2ee90c66e9

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

6,110 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	usecode	zoningcode	taxacres	naicscode	legaldesc	placename	placetype	taxdistrict
470995811	31	093	*611 HOWARD AVE	ST PAUL	68873	Howard	92833	St. Paul	970600	9706	474.5377	67049	4338	71387	74000	2017-05-16	1	1	1921	31093C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	010303010601	03	0.1171	4595	LOTS 6 & 7 BLOCK 20 OT ST PAUL …	BRICK STREET MALL	SECOND_HAND_STORE	1
470997601	31	093	*219 HOWARD AVE	ST PAUL	68873	Howard	92833	St. Paul	970600	9706	1035.4255	201372	32840	234212			1	1	1996	31093C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	010303010602	03	0.2556	52599	LOTS 9 10 11 & 12 BLOCK 82 OT S…	CHRISTENSEN INSURANCE	FINANCIAL_SERVICE	1
471008520	31	093	303 LANDER AVE	FARWELL	68838	Howard	92460	Posen	970600	9706	1952.5654	58067	2730	60797	25000	2018-10-19	1	1	1967	31093C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	010303010701	03	0.4821		LOTS 6-11 BLOCK 6 VILLAGE OF FA…			80
470849106	31	093	1212 17TH AVE	ELBA	68835	Howard	90945	Fairdale-Logan	970500	9705	643129.1027	131534	571487	703021	200000	2023-08-07	1	1	1981	31093C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	010505030909	05	158.8138		(FL TWP) SE1/4 7-15-10 (160 ACR…			42
470855238	31	093	1932 15TH AVE	FARWELL	68838	Howard	92460	Posen	970600	9706	613877.4564	269042	569963	839005	233650	2004-01-16	1	1	2011	31093C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	010505030909	05	151.5911		(POS TWP) E1/2 SW1/4 & S1/2 SE1…			86
471005736	31	093	*108 TAYLOR ST	ST PAUL	68873	Howard	92833	St. Paul	970600	9706	805.9511	342670	22427	365097	340000	2023-07-20	1	1	2013	31093C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	010101010601	01	0.1989		(#811-2) LOT 2 TAYLOR SUB ST PA…			1
470866450	31	093	1036 YUTAN RD	BOELUS	68820	Howard	91565	Kelso	970600	9706	1229299.0284	58317	984932	1043249	450000	2021-05-12	1	1	1915	31093C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	010505030910	05	303.5689		(KEL TWP) W1/2 EXC 10 AC TRACT …			35
470854169	31	093	716 12TH ST	ELBA	68835	Howard	90855	Elba	970600	9706	624.0917	30199	887	31086	30634	2021-08-24	1	1	1935	31093C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	010303010701	03	0.1541		LOT 5 EXC N 22' OF E 62' BLOCK …			46
470998624	31	093	*910 INDIAN ST	ST PAUL	68873	Howard	92833	St. Paul	970600	9706	1619.9051	126824	36136	162960	69000	2010-02-24	1	1	1905	31093C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	010101010602	01	0.4000		LOTS 10 11 & 12 BLOCK 6 BARTLET…			1
471009098	31	093	*924 WALLACE ST	ST PAUL	68873	Howard	92833	St. Paul	970600	9706	805.0213	173598	21780	195378	185000	2023-03-02	1	1	1963	31093C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	010101010601	01	0.1987		LOT 6 & W1/2 OF LOT 5 BLOCK 1 K…			1
471026448	31	093	*758 9TH AVE	SAINT PAUL	68873	Howard	92835	St. Paul	970500	9705	45694.1393	154323	118683	273006	124900	2007-10-29	1	1	2006	31093C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	010101030907	01	11.2841		(SP TWP)(#311-2) TRACT IN SW1/4…			18
471007745	31	093	*908 PAUL ST	ST PAUL	68873	Howard	92833	St. Paul	970600	9706	5712.1814	71966	65415	137381	123000	2023-11-16	1	1	1910	31093C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	010101010603	01	1.4105		LOTS 1 & 21 EXC W 30' ALESHIRES…			1
471007990	31	093	1115 CUSTER ST	ST PAUL	68873	Howard	92833	St. Paul	970600	9706	1110.1839	135346	27915	163261	90000	2010-08-12	1	1	1945	31093C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	010101010602	01	0.2741		E 85' OF LOTS 2 & 3 EXC S 123.5…			1
471002743	31	093	*160 HWY 11	CAIRO	68824	Howard	90535	Cleveland	970500	9705	40518.1732	12025	117500	129525	45000	2007-06-15	1	1	1969	31093C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	010105030907	05	10.0063		(CLE TWP) LOT 3 CENTURA HEIGHTS…			39
471024764	31	093	1508 9TH AVE	DANNEBROG	68831	Howard	93345	Warsaw	970600	9706	12371.5403	220539	60800	281339	165000	2018-11-20	1	1	1915	31093C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	010101030909	01	3.0548		(WAR TWP)(#113-2) LOT 1 TURKEY …			31
471005386	31	093	1323 CUSTER ST	ST PAUL	68873	Howard	92833	St. Paul	970600	9706	1123.0077	228176	28090	256266	141000	2007-08-20	1	1	1981	31093C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	010101010602	01	0.2773		LOT 1 VERLEY'S ADD ST PAUL			1
470864636	31	093	*430 13TH AVE	SAINT PAUL	68873	Howard	91050	Gage Valley	970500	9705	279267.4792	151556	187406	338962	130000	2010-12-24	1	1	2002	31093C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	010505030909	05	68.9623		(GV TWP) S1/2 SE1/4 EXC 5 AC TR…			68
470875271	31	093	*169 HWY 281	SAINT LIBORY	68872	Howard	92830	St. Libory	970500	9705	46255.5193	117323	132800	250123	58500	2017-02-16	1	1	1963	31093C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	010105030908	05	11.4228		(SL TWP) LOT 1 LEANIN' TREE RAN…			53
470947760	31	093	117 W ROGER WELSCH AVE	DANNEBROG	68831	Howard	90650	Dannebrog	970600	9706	499.7110	29577	7754	37331	10000	2022-07-19	1	1	1905	31093C	2026-01-08	AE		010101010703	01	0.1233		PART LOTS 5 6 & 7 BLOCK 17 DANN…			33
474770636	31	093	1075 INMAN RD	SAINT PAUL	68873	Howard	92835	St. Paul	970600	9706	12216.2225	265598	65225	330823	15000	2008-04-04	1	1	2009	31093C	2026-01-08	AE		010101030905	01	3.0167		(SP TWP)(#268-6) LOT 2 DEER RUN…			2
470847375	31	093	*889 23RD AVE	WOLBACH	68882	Howard	90945	Fairdale-Logan	970500	9705	588882.7210	106168	297329	403497		2015-08-24	1	1	1914	31093C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	010505030909	05	145.4164		(FL TWP) PART NW1/4 14-16-10 (1…			59
470864806	31	093	1262 HWY 11	SAINT PAUL	68873	Howard	93345	Warsaw	970600	9706	261882.2004	147839	303619	451458		2010-12-01	1	1	1910	31093C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	010505030909	05	64.6692		(WAR TWP) NW1/4 LYING S OF CENT…			2
470500014	31	093	1470 8TH AVE	DANNEBROG	68831	Howard	90650	Dannebrog	970600	9706	910494.5250	266967	867075	1134042		2014-12-05	1	1	1915	31093C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	010505030909	05	224.8426		(DBG TWP) SE1/4 & S1/2 SW1/4 EX…			31
471005122	31	093	1493 ALEXANDER AVE	ELBA	68835	Howard	90945	Fairdale-Logan	970500	9705	14856.2098	189335	70025	259360	240000	2025-01-03	1	1	1980	31093C	2026-01-08	A		010105030905	05	3.6684		(FL TWP)(#258-1) CATALPA COVE S…			41
470996486	31	093	*715 HOWARD AVE	ST PAUL	68873	Howard	92833	St. Paul	970600	9706	196.0882	131818	1775	133593	229900	2023-09-25	1	1	1915	31093C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	010303010601	03	0.0483		LOT 9 EXC E 3'10 BLOCK 83 OT ST…			1