Saved query f44fe4ebadf20fcf

Data Explorer

Query the US Nationwide Parcel Dataset

$1.75 / 1,000 records$100 minimum

43/80

Live SQL

SELECT * 
FROM "lr_parcel_us" 
WHERE statefp = '46' 
  AND countyfp = '117'

10,393 matching parcels

Data Preview

parcelid	taxacctnum	statefp	countyfp	parceladdr	parcelcity	parcelstate	parcelzip	ownername	owneraddr	ownercity	ownerstate	ownerzip	countyname	cousubfp	cousubname	tractce	tractname	calcarea	imprvalue	landvalue	agvalue	totalvalue	saleamt	saledate	numbldgs	numunits	yearbuilt	firmid	firmdate	fldzone	zonesubty	staticbfe	elevmin	elevmax	elevavg	taxacres	ownertype	legaldesc	book	page	parceltype	accesstype	placename	placetype	heating	heatfuel	cooling	roofcover	siding	lrversion	taxyear	taxdistrict
57-0000-022-0117-000-0-0-00000	6882	46	117	102 W WANDEL AVE	VERMILLION	SD	57069	ADAVENTURES LLC	PO BOX 55	VERMILLION	SD	57069	STANLEY	22260	FORT PIERRE	960100	9601	949.4330	130364	163614	130364	33250	510000	2023-06-12	1	1	1977	46117C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD		439.3822	442.9003	442.1358	0	BUSINESS	BLK 117 LOTS 22-24; CITY OF FOR…	356	815					UNDETERMINED	UNDETERMINED	OTHER			2026.2	2023	57-1
57-0000-025-0014-000-0-0-00000	6520	46	117	111 W MAIN AVE	CUSTER	SD	57730	JAYME SEVERYN	12689 US HIGHWAY 16A	CUSTER	SD	57730	STANLEY	22260	FORT PIERRE	960100	9601	489.8124	25772	47052	25772	21280		2016-02-19	1	1	1900	46117C	2026-01-20	AE			437.6778	439.0953	438.5152	0	PERSON	BLK 14 N 105' LOTS 25-26; CITY …	338	992					UNDETERMINED	UNDETERMINED	OTHER	YEAR BUILT	FAIR	2026.2	2023	57-1
57-0000-001-0153-000-0-0-00000	6957	46	117	212 E ASH AVE	FORT PIERRE	SD	57532	TETON RIVER SOUTH LLC	PO BOX 264	FORT PIERRE	SD	57532	STANLEY	22260	FORT PIERRE	960100	9601	1087.3047	131999	153279	131999	21280					0	46117C	2026-01-20	AE	FLOODWAY		433.6799	436.9100	435.5679	0	BUSINESS	BLK 153 LOTS 1-3; CITY OF FORT …	347	453	GOVT FEDERAL	RESTRICTED	SHARPE RECREATION AREA	RECREATION MANAGEMENT AREA	UNDETERMINED	UNDETERMINED	OTHER			2026.2	2023	57-1
57-0000-005-0060-000-0-0-00000	6740	46	117	606 N DEADWOOD ST	PIERRE	SD	57501	JACQUELYN C BARTLETT-MANDIL	333 S PIERRE ST	PIERRE	SD	57501	STANLEY	22260	FORT PIERRE	960100	9601	975.6057	51530	83450	51530	31920		2016-03-18	1	1	1910	46117C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD		436.2215	436.8858	436.4227	0	PERSON	BLK 60 LOTS 5-7; CITY OF FORT P…	347	41					UNDETERMINED	UNDETERMINED	OTHER			2026.2	2023	57-1
57-0135-000-0000-000-0-0-00113	7412	46	117	311 JAMIESON	FORT PIERRE	SD	57532-	CHRISTOPHER SMITH	311 JAMIESON DR	FORT PIERRE	SD	57532-	STANLEY	22260	FORT PIERRE	960100	9601	1021.7251	434529	47880		482409		2014-03-13	1	1	0	46117C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD		436.2948	437.1817	436.8327	0.2500	PERSON	MARION'S GARDEN SUBDIVISION, LO…	331	46					UNDETERMINED	UNDETERMINED	OTHER			2026.2	2023	57-1
57-0140-000-0000-000-0-0-00008	8495	46	117	1912 TIREE DR	FORT PIERRE	SD	57532	KRYSTAL SIMONS	1912 TIREE DRIVE	FORT PIERRE	SD	57532	STANLEY	22260	FORT PIERRE	960100	9601	886.5234	131988	37240		169228		2016-07-15	1	1	1979	46117C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD		437.3238	438.4441	438.0744	0.2300	PERSON	MARION'S PASTURE ADDITION, LOT …	338	111					UNDETERMINED	UNDETERMINED	OTHER			2026.2	2023	57-1
57-0115-000-0000-000-0-0-00000	7164	46	117	910 N MARION ST	FORT PIERRE	SD	57532-	ANDREW HEISS	910 N MARION	FORT PIERRE	SD	57532-	STANLEY	22260	FORT PIERRE	960100	9601	5220.3899	300467	133000		433467		2013-01-07	1	1	1968	46117C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD		436.0982	437.4696	436.6847	1.1800	PERSON	LOT M.C.-1, PART OF GOVT LOT 7:…	321	622					UNDETERMINED	UNDETERMINED	OTHER			2026.2	2023	57-1
57-0130-000-0000-000-0-0-00032	9236	46	117	2010 MULL ST	FORT PIERRE	SD	57532	JAMIE R PAHL	2010 MULL ST	FORT PIERRE	SD	57532	STANLEY	22260	FORT PIERRE	960100	9601	1003.0526	219143	37240		256383		2015-07-30	1	1	0	46117C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD		436.1958	437.0340	436.7040	0.2500	PERSON	MARION'S ACRES ADDITION LOT 32;…	347	544					UNDETERMINED	UNDETERMINED	OTHER			2026.2	2023	57-1
57-0032-000-0000-000-0-0-00002	9409	46	117	2006 BEACH DR	FORT PIERRE	SD	57532-	PAUL KARST	2006 BEACH DR	FORT PIERRE	SD	57532-	STANLEY	22260	FORT PIERRE	960100	9601	1571.0308	678466	170240		848706		2011-05-02	1	1	0	46117C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD		433.7399	437.7418	436.5566	0.3900	PERSON	COMPTON'S COVE ADDITION, LOT 2;…	310	897					UNDETERMINED	UNDETERMINED	OTHER			2026.2	2023	57-1
57-0020-007-0005-000-0-0-00000	6989	46	117	711 S TWO RIVERS ST	FORT PIERRE	SD	57532	JARED RASMUSSEN	711 TWO RIVERS ST	FORT PIERRE	SD	57532	STANLEY	22260	FORT PIERRE	960100	9601	721.6278	134627	31920		166547		2016-09-14	1	1	1976	46117C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD		450.6489	453.2126	452.5043	0	PERSON	CHATEAU SUB BLK 5 LOT 7; CITY O…	338	168					UNDETERMINED	UNDETERMINED	OTHER			2026.2	2023	57-1
16-0000-014-0004-033-3-0-00001	2340	46	117	21400 ARROWHEAD RD	FORT PIERRE	SD	57532	LOWER BRULE FARM CORPORATION	PO BOX 208	FORT PIERRE	SD	57532	STANLEY	59945	SOUTH STANLEY	960100	9601	326777.0516	88498	103090	88498	14592		2005-05-18			0	46117C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD		447.3883	544.3424	506.1575	80	BUSINESS	E2SW4:SEC 14-T4N-R33E	290	98					UNDETERMINED	UNDETERMINED	OTHER			2026.2	2023	57-1
57-0000-013-0146-000-0-0-00000	6943	46	117	202 E CEDAR AVE	FORT PIERRE	SD	57532-	RAND D NEWLAND	202 E CEDAR AVE	FORT PIERRE	SD	57532-	STANLEY	22260	FORT PIERRE	960100	9601	1024.3969	38776	26600		65376		2006-02-03	1	1	1900	46117C	2026-01-20	AE			436.6139	437.0026	436.8024	0	PERSON	BLK 146 LOTS 13-15; CITY OF FOR…	290	387					UNDETERMINED	UNDETERMINED	OTHER			2026.2	2023	57-1
57-0276-000-0000-000-0-0-00014	10561	46	117	906 PHEBA AVE	FORT PIERRE	SD	57532	MIDWEST STORAGE LLC	914 VERENDRYE DRIVE	FORT PIERRE	SD	57532	STANLEY	22260	FORT PIERRE	960100	9601	3228.2751		2660		2660	285000	2025-01-14			0	46117C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD		443.0706	445.8812	443.8849	0.7900	BUSINESS	LOOKOUT RIDGE COMMERCIAL DEVELO…	364	350					UNDETERMINED	UNDETERMINED	OTHER			2026.2	2023	57-1
57-0175-000-0000-000-0-0-00015	8764	46	117	213 STANLEY RD	FORT PIERRE	SD	57532	FORT PIERRE LIVESTOCK	PO BOX 400	FORT PIERRE	SD	57532	STANLEY	22260	FORT PIERRE	960100	9601	4105.9331	81505	344048	81505	262543					0	46117C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD		438.6557	440.5759	439.6456	0	PERSON	O'DAYS 2ND SUBDIVISION LOT 15 &…	347	451					UNDETERMINED	UNDETERMINED	OTHER			2026.2	2023	57-1
29-0000-027-0006-029-1-0-00001	9696	46	117		FORT PIERRE	SD	57532	GUNSMOKE FARMS LLC	26903 SANSARC RD	FORT PIERRE	SD	57532	STANLEY	45727	NORTH STANLEY	960100	9601	42304.3636		2370		2370		2016-12-08			0	46117C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD		575.7381	587.2541	580.8617	10	BUSINESS	THAT PORTION OF THE SW4NE4 LYIN…	338	252					UNDETERMINED	UNDETERMINED	OTHER			2026.2	2023	57-1
26-0000-022-0006-026-2-0-00003	8006	46	117	22-6-26 STR	PEACHTREE CORNERS	SD	30092	THOMAS E ORTON III REVOCABLE TR…	4591 RIVER BOTTOM DRIVE	PEACHTREE CORNERS	GA	30092	STANLEY	45727	NORTH STANLEY	960100	9601	322667.8627		65915		65915		2023-06-14			0	46117C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD		652.6189	663.5944	657.6556	79	TRUST	S2NW4 LESS-ROAD:SEC 22-T6N-R26E…	356	819					UNDETERMINED	UNDETERMINED	OTHER			2026.2	2023	57-1
57-0263-046-0001-000-0-0-00000	9250	46	117	2408 WHISPERING SHORES DR	ST LAWRENCE	SD	57373	MOROG FAMILY LIMITED PARTNERSHIP	19041 363RD AVE	ST LAWRENCE	SD	57373	STANLEY	22260	FORT PIERRE	960100	9601	7380.8456		249419		249419		2012-08-03			0	46117C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD		433.7399	437.7967	436.0835	1.8200	BUSINESS	VINTAGE SQUARE ESTATES, LOT 46 …	347	115					UNDETERMINED	UNDETERMINED	OTHER			2026.2	2023	57-1
36-0000-021-0007-029-0-0-00000	9489	46	117	21-7-29 STR	PIERRE	SD	57501	STATE OF SD-GFP	523 E CAPITOL AVE	PIERRE	SD	57501	STANLEY	45727	NORTH STANLEY	960100	9601	663533.4218		26561		26561					0	46117C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD					161.5300	GOVERNMENT	PART OF N2N2NW4NW4; S2NW4; SW4;…	302	269	GOVT FEDERAL	RESTRICTED	LAKE OAHE	RECREATION MANAGEMENT AREA	UNDETERMINED	UNDETERMINED	OTHER			2026.2	2023	57-1
57-0000-013-0120-000-0-0-00000	8735	46	117		FORT PIERRE	SD	57532	STANLEY COUNTY	PO BOX 595	FORT PIERRE	SD	57532	STANLEY	22260	FORT PIERRE	960100	9601	2994.8539				0					0	46117C	2026-01-20	AE	FLOODWAY		434.5523	436.7444	435.4998	0	PERSON	BLK 120 LOTS 13-24, BLK 121, PA…		0	GOVT FEDERAL	RESTRICTED	LAKE SHARPE	RECREATION MANAGEMENT AREA	UNDETERMINED	UNDETERMINED	OTHER			2026.2	2023	57-1
46-0000-036-0009-028-0-0-00009	6142	46	117	36-9-28 STR	SANTA FE	SD	87507	BRENDA DONELAN	5520 WELLNESS WAY	SANTA FE	NM	87507	STANLEY	45727	NORTH STANLEY	960100	9601	281610.8065		46059		46059		2022-10-12			0	46117C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD		497.7200	516.7365	511.5203	70	PERSON	SWNE; W2SENE; W2E2SENE:SEC 36-T…	310	153					UNDETERMINED	UNDETERMINED	OTHER			2026.2	2023	57-1
29-0425-000-0006-029-0-0-0001B	9387	46	117	20128 SD HWY UNIT 1806	BROOKINGS	SD	57006	RANDY BJORKLUND	2021 MORIARTY DR	BROOKINGS	SD	57006	STANLEY	45727	NORTH STANLEY	960100	9601	164602.7184		42560		42560		2013-08-19			0	46117C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD		508.8204	616.1481	568.0731	40.6800	PERSON	CHANTIER VIEW ESTATES LOT 1B A …	321	835					UNDETERMINED	UNDETERMINED	OTHER			2026.2	2023	57-1
57-0263-011-0003-000-0-0-00000	9283	46	117	2511 WHISPERING SHORES DR	PIERRE	SD	57501	BRUCE D JOHNSON	1625 GRANDVIEW	PIERRE	SD	57501	STANLEY	22260	FORT PIERRE	960100	9601	2734.3132		58520		58520		2022-01-27			0	46117C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD		435.7153	436.7716	436.2783	0.6800	PERSON	VINTAGE SQUARE ESTATES, LOT 11 …	356	362					UNDETERMINED	UNDETERMINED	OTHER			2026.2	2023	57-1
22-0000-030-0005-029-1-0-00002	3193	46	117	30-5-29 STR	FORT PIERRE	SD	57532	ROBERT STOESER	27213 US HIGHWAY 14/34	FORT PIERRE	SD	57532	STANLEY	59945	SOUTH STANLEY	960100	9601	319511.8069		23998		23998		2012-04-02			0	46117C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD		571.9792	601.0950	584.4751	80	PERSON	S2NE4:SEC 30-T5N-R29E	310	786					UNDETERMINED	UNDETERMINED	OTHER			2026.2	2023	57-1
12-0000-028-0004-029-1-0-00002	1842	46	117	28-4-29 STR	FORT PIERRE	SD	57532	BAD RIVER RANCHES LLLP	28044 BAD RIVER ROAD	FORT PIERRE	SD	57532	STANLEY	59945	SOUTH STANLEY	960100	9601	322905.6483		17477		17477		2025-03-04			0	46117C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD		517.9297	563.5239	541.9981	80	BUSINESS	S2NE4:SEC 28-T4N-R29E	364	397					UNDETERMINED	UNDETERMINED	OTHER			2026.2	2023	57-1
57-0130-000-0000-000-0-0-00016	9189	46	117	2007 IONA ST	PIERRE	SD	57501	ALLIED PROPERTIES LLC	PO BOX 1112	PIERRE	SD	57501	STANLEY	22260	FORT PIERRE	960100	9601	1011.1770		31920		31920		2021-11-02			0	46117C	2026-01-20	AE		1430	435.5414	436.4055	436.0995	0.2500	BUSINESS	MARION'S ACRES ADDITION LOT 16;…	356	248					UNDETERMINED	UNDETERMINED	OTHER			2026.2	2023	57-1