Saved query ac9a4f81ff3485f5

Data Explorer

Query the US Nationwide Parcel Dataset

$1.75 / 1,000 records$100 minimum

41/80

Live SQL

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

8,909 matching parcels

Data Preview

parcelid	statefp	countyfp	parceladdr	parcelcity	parcelstate	ownername	owneraddr	ownercity	ownerstate	ownerzip	countyname	cousubfp	cousubname	tractce	tractname	calcarea	firmid	firmdate	fldzone	zonesubty	staticbfe	elevmin	elevmax	elevavg	taxacres	ownertype	naicscode	legaldesc	placename	placetype	lrversion	taxdistrict
26.20.01.02	46	051	100 W 8TH AVE		SD	BEARE MICHAEL	100 W 8TH AVE	MILBANK	SD	57252	GRANT	42260	MILBANK	953100	9531	1175.8002	46051C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	-9999	349.2127	350.7124	350.2000	0	PERSON	6216	RANDALL'S SECOND ADDN LOT 1 & W…	C&C CARPET CLEANING	HOME_SERVICE	2026.2	26-20
15.50.02.1400	46	051	16027 471ST AVE	STRANDBURG	SD	GRANQUIST BRIAN R	3115 COLORADO AVE S	ST LOUIS PARK	MN	55416	GRANT	64180	TROY	953300	9533	23132.8096	46051C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	-9999	523.5323	529.4006	527.3654	5.7200	PERSON		LOT 1 OF GRANQUIST ADDN IN THE …			2026.2	15-20
12.48.15.2000	46	051	47629 144TH ST	MILBANK	SD	BOLIN RICKY L & JULIE L	47629 144TH ST	MILBANK	SD	57252	GRANT	41940	MELROSE	953100	9531	37752.8536	46051C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	-9999	346.3322	348.8063	347.3616	11.2300	PERSON		LOT 1 R & J FARMS SUBDIV IN NE1…			2026.2	12-20
13.50.14.4100	46	051			SD	WIESE KENNETH & SHIRLEY REVO	14567 468TH AVE	TWIN BROOKS	SD	57269	GRANT	47780	OSCEOLA	953100	9531	241869.1666	46051C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	-9999	405.2817	420.7791	414.4983	60	PERSON		NE1/4SE1/4 & E1/2NW1/4SE1/4			2026.2	13-13
10.49.07.4000	46	051			SD	GRABOW TYLER L & HILARY N	14646 472ND AVE	TWIN BROOKS	SD	57269	GRANT	40180	MADISON	953300	9533	162612.1496	46051C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	-9999	394.0843	417.5775	406.4790	40	PERSON		SE1/4SE1/4			2026.2	10-20
14.50.30.2000	46	051			SD	OWEN KELLY W	15629 468TH AVE	STOCKHOLM	SD	57264	GRANT	61780	STOCKHOLM	953300	9533	161116.5524	46051C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	-9999	576.6736	588.2484	581.6789	37.0900	PERSON		GOVT LOT 1			2026.2	14-19
25.00.23.06	46	051	503 CORNELL AVE		SD	VOELTZ WILLIAM L	810 HIGH ST	BIG STONE CITY	SD	57216	GRANT	05540	BIG STONE CITY	953100	9531	592.1079	46051C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	-9999	311.1021	313.0280	312.5353	0	PERSON		CONSOLIDATED PLAT LOTS 5 & 6 BL…			2026.2	25-20
08.49.01.2110	46	051			SD	GRABOW GREGORY & WENDY	14649 473RD AVE	TWIN BROOKS	SD	57269	GRANT	33940	KILBORN	953100	9531	160672.7245	46051C	2026-01-20	X	0.2 PCT ANNUAL CHANCE FLOOD HAZ…	-9999	353.2978	356.1461	354.3309	37.2000	PERSON		SE1/4NW1/4			2026.2	08-20
17.48.02.1000	46	051			SD	AHUNT FARM LLC	PO BOX 528	MILBANK	SD	57252	GRANT	66900	VERNON	953300	9533	634943.4085	46051C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	-9999	342.8580	349.5083	345.5130	159.6900	BUSINESS		GOVT LOTS 1 & 2 & S1/2NE1/4			2026.2	17-20
10.49.33.3110	46	051			SD	ANDERSON ERIC J & ANITA K	15706 475TH AVE	MILBANK	SD	57252	GRANT	40180	MADISON	953300	9533	322647.2365	46051C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	-9999	434.1824	458.3308	446.2311	80	PERSON		S1/2SW1/4			2026.2	10-20
09.52.11.2100	46	051			SD	MOREHOUSE FAMILY TRUST	3900 AUBURN DR	MINNETONKA	MN	55305	GRANT	39500	LURA	953300	9533	413456.6899	46051C	2026-01-20	X	0.2 PCT ANNUAL CHANCE FLOOD HAZ…	-9999	552.4966	558.5975	556.3026	102.7300	TRUST		NW1/4 IN FORMER SISSETON WAHPET…			2026.2	09-09
23.00.02.06	46	051	115 N MAIN ST		SD	BRUGMAN DOUGLAS & ARLENE	PO BOX 115	STRANDBURG	SD	57265	GRANT	61980	STRANDBURG	953300	9533	580.5477	46051C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	-9999	511.1447	511.8931	511.5016	0	PERSON		ORIGINAL TOWNSITE LOTS 5 & 6 BL…			2026.2	23-20
26.01.08.04A	46	051	507 S VIOLA ST		SD	VAN LITH FRANCIS J & CHERYL	507 S VIOLA ST	MILBANK	SD	57252	GRANT	42260	MILBANK	953100	9531	1012.4809	46051C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	-9999	351.9347	352.4515	352.2620	0	PERSON		BARTLETT'S FIRST ADDN S1/2 OF L…			2026.2	26-20
03.47.22.2110	46	051	48211 145TH ST UNIT BSC		SD	GARCIA MOLINA AZAEL	48211 145TH ST	BIG STONE CITY	SD	57216	GRANT	05500	BIG STONE	953100	9531	74856.0924	46051C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	-9999	328.7712	332.3083	330.1034	18.5000	PERSON		LOT 1 MCARTHY SUBDIV IN N1/2NW1…			2026.2	03-20
01.47.29.3000	46	051			SD	KRUSE WILL & KOYLA LIVING TR	17323 486TH AVE	GARY	SD	57237	GRANT	00260	ADAMS	953300	9533	640806.8139	46051C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	-9999	350.7919	359.5277	354.4994	160	TRUST		SW1/4			2026.2	01-20
04.52.04.4000	46	051			SD	ZIRBEL BROTHERS LLC	45202 145TH ST	ORTLEY	SD	57256	GRANT	06100	BLOOMING VALLEY	953300	9533	322613.9056	46051C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	-9999	565.1182	574.4182	567.1462	80	BUSINESS		N1/2SE1/4 IN FORMER SISSETON WA…			2026.2	04-09
12.48.14.2002	46	051	14414 477TH AVE MILBAN		SD	VEEN SCOTT	14414 477TH AVE	MILBANK	SD	57252	GRANT	41940	MELROSE	953100	9531	9281.5088	46051C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	-9999	343.6961	345.9812	344.7863	2.3000	PERSON		LOT 2 SPEIDEL SUBDIV IN N1/2NW1…			2026.2	12-20
22.05.03.07	46	051	205 SE 1ST ST		SD	WIPF FELIX	302 E 3RD ST	STOCKHOLM	SD	57264	GRANT	61740	STOCKHOLM	953300	9533	1299.8943	46051C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	-9999	507.3370	508.6875	507.8718	0	PERSON		BERG'S SECOND ADDN LOTS 6 & 7 B…			2026.2	22-20
26.66.00.03	46	051	310 E 10TH AVE		SD	ZAGAMI JOSEPH & KAREN	310 E 10TH AVE	MILBANK	SD	57252	GRANT	42260	MILBANK	953100	9531	1917.7104	46051C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	-9999	349.1578	350.5564	349.8081	0	PERSON		OUTLOTS NORTH 238' OF LOT A-5			2026.2	26-20
26.20.02.08	46	051	107 RANDALL DR		SD	AMBERG DUANE E & DEBRA A	107 RANDALL DR	MILBANK	SD	57252	GRANT	42260	MILBANK	953100	9531	1597.9027	46051C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	-9999	348.0282	349.4075	348.8796	0	PERSON		RANDALL'S SECOND ADDN LOTS 7 & …			2026.2	26-20
26.27.11.16A	46	051	904.5 E 9TH AVE		SD	HENRICHSEN JERALD & VICKI	904 1/2 E 9TH AVE	MILBANK	SD	57252	GRANT	42260	MILBANK	953100	9531	680.1047	46051C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	-9999	348.6312	349.4096	348.9887	0	PERSON		HURLEY'S ADDITION E1/2 OF LOT 1…			2026.2	26-20
04.52.24.3000	46	051			SD	AMDAHL ALLEN C	PO BOX 704	SUMMIT	SD	57266	GRANT	06100	BLOOMING VALLEY	953300	9533	604688.6256	46051C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	-9999	577.3471	586.3267	581.5149	146.8899	PERSON		SW1/4 IN FORMER SISSETON WAHPET…			2026.2	04-09
02.47.18.4002	46	051			SD	SD QUARRIES LLC	3640 BAYSIDE RD	ORONO	MN	55356	GRANT	00580	ALBAN	953300	9533	2676.6646	46051C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	-9999	331.0374	334.4143	333.0001	0.6600	BUSINESS		N 133' OF OL F, A SUBDIV OF OL A			2026.2	02-20
22.01.03.09	46	051			SD	COLLINS DENNIS & LORRAINE	204 E JOHNSON AVE	STOCKHOLM	SD	57264	GRANT	61740	STOCKHOLM	953300	9533	895.8658	46051C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	-9999	502.6326	505.7375	504.2774	0	BUSINESS		BERGREN'S ADDITION LOT 9 BLOCK 3			2026.2	22-20
07.49.08.3000	46	051			SD	BOERGER GENE & JAN LIVING TR	14710 474TH AVE	MILBANK	SD	57252	GRANT	25740	GRANT CENTER	953300	9533	617842.8040	46051C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	-9999	363.7815	371.7707	368.3846	151.4900	TRUST		SW1/4 EX RTY			2026.2	07-20