Saved query 097761042b7da9e0

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

11,827 matching parcels

Data Preview

parcelid	statefp	countyfp	parceladdr	parcelstate	ownername	owneraddr	ownercity	ownerstate	ownerzip	countyname	cousubfp	cousubname	tractce	tractname	calcarea	imprvalue	landvalue	agvalue	totalvalue	saleamt	saledate	bedrooms	firmid	firmdate	fldzone	zonesubty	elevmin	elevmax	elevavg	taxacres	ownertype	naicscode	legaldesc	book	page	placename	placetype	lrversion	taxyear	taxdistrict
15520-01200-013-00	46	035	112 N MAIN ST	SD	BATES RENTALS LLC	112 N MAIN ST	MITCHELL	SD	57301	DAVISON	43100	MITCHELL	962801	9628.0100	329.9415	7610	7610	7610	0	50000	2009-02-04		46035C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	397.1915	397.9074	397.7181	0.0820	BUSINESS	7224	LT 13 BLK 12 MITCHELL ORIGINAL-…	69	41	BIG DUMMY'S	BAR	2026.2	2009	MITCHELL FIRE DISTRICT
15450-09500-009-00	46	035	514 W 2ND AVE	SD	SANCHEZ BONFILIO & HERMELINDA	514 W 2ND AVE	MITCHELL	SD	57301	DAVISON	43100	MITCHELL	962801	9628.0100	923.6522	62000	62000	62000	0	63000	2002-10-03	5	46035C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	398.0425	398.8677	398.6145	0.2280	PERSON		LT 9 & W20' LT 10 BLK 95 JOHN L…	199	521			2026.2	2002	MITCHELL FIRE DISTRICT
15060-00400-002-00	46	035	1017 W 7TH AVE	SD	ERICKSON JUSTIN & TARA	1017 W 7TH AVE	MITCHELL	SD	57301	DAVISON	43100	MITCHELL	962801	9628.0100	1393.7836	236075	236075	236075	0	208000	2024-10-08	5	46035C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	400.2825	401.4522	400.9116	0.3439	PERSON		LOT 2 BLOCK 4 E.B. BRACY'S ADD…	624	455			2026.2	2024	MITCHELL FIRE DISTRICT
15474-00100-010-00	46	035	711 W 16TH AVE	SD	SCHWALM DAVID C	323 N DUFF ST	MITCHELL	SD	57301	DAVISON	43100	MITCHELL	962700	9627	757.0226	204950	204950	204950	0	100000	2018-02-08	4	46035C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	398.9067	400.0526	399.5032	0.2000	PERSON		LT 10 EX W58.75' BLK 1 MITCHEL…	618	68			2026.2	2018	MITCHELL FIRE DISTRICT
15090-04400-010-00	46	035	308 W 9TH AVE	SD	GAULKE MARK & BECKY	25527 413TH AVE	MITCHELL	SD	57301	DAVISON	43100	MITCHELL	962700	9627	659.7578	49115	49115	49115	0	45000	2007-10-15	2	46035C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	398.6697	399.3197	399.0226	0.1630	PERSON		LT 10 BLK 44 CAPITAL ADDN-SE	607	491			2026.2	2007	MITCHELL FIRE DISTRICT
15290-00200-003-00	46	035	813 E 8TH AVE	SD	DUXBURY TODD	813 E 8TH AVE	MITCHELL	SD	57301	DAVISON	43100	MITCHELL	962802	9628.0200	655.7699	116020	116020	116020	0		2019-06-14	2	46035C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	399.6104	400.0994	399.9267	0.1630	PERSON		LT 3 BLK 2 F. M. GREENES ADDN-NE	719	50			2026.2	2019	MITCHELL FIRE DISTRICT
15610-01200-007-00	46	035	911 N MAIN ST	SD	HICKS DARLENE	909 N MAIN ST	MITCHELL	SD	57301	DAVISON	43100	MITCHELL	962700	9627	329.9412	122235	122235	122235	0	190000	2017-09-15		46035C	2026-01-20	X	0.2 PCT ANNUAL CHANCE FLOOD HAZ…	398.7573	398.9807	398.8686	0.0820	PERSON		LT 7 BLK 12 D. A. SCOTT'S 1ST A…	77	402			2026.2	2017	MITCHELL FIRE DISTRICT
15800-01500-205-00	46	035		SD	CITY OF MITCHELL	612 N MAIN ST	MITCHELL	SD	57301	DAVISON	43100	MITCHELL	962700	9627	2180.6601	1000	1000	1000	0		1993-06-03		46035C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	395.9425	396.8578	396.5607	0.5390	GOVERNMENT		LT G 3-D NW 1/4 15-103-60 PLATT…	187	33			2026.2	1993	MITCHELL FIRE DISTRICT
15760-04400-013-00	46	035	1200 W UNIVERSITY AVE	SD	DAKOTA WESLEYAN UNIVERSITY	1200 W UNIVERSITY AVE	MITCHELL	SD	57301	DAVISON	43100	MITCHELL	962900	9629	21217.0847								46035C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	408.4357	412.1077	410.3480	15.2340	PERSON	6113	DWU CAMPUS INCLUDING LTS A-C & …			DAKOTA WESLEYAN UNIVERSITY	COLLEGE_UNIVERSITY	2026.2		MITCHELL FIRE DISTRICT
15155-00000-002-00	46	035	1420 W UNIVERSITY AVE	SD	DAKOTA WESLEYAN UNIVERSITY	1200 W UNIVERSITY AVE	MITCHELL	SD	57301	DAVISON	43100	MITCHELL	962900	9629	31307.9398								46035C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	407.6468	411.5470	409.4607	7.7380	PERSON	611110	LT C-2 & LT E-1 EX THAT PORTION…			L B WILLIAMS ELEMENTARY SCHOOL	ELEMENTARY_SCHOOL	2026.2		MITCHELL FIRE DISTRICT
15270-00200-001-00	46	035	321 OAKMOND AVE	SD	LOMBARDI COURTS LTD PARTNERSHIP…	PO BOX 37	HURON	SD	57350	DAVISON	43100	MITCHELL	962700	9627	1951.2945							20	46035C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	396.5970	397.9599	397.5625	0.4820	BUSINESS		LT 1 BLK 2 GREEN ACRES SUB-NW					2026.2		MITCHELL FIRE DISTRICT
11000-10161-172-05	46	035	26442 401ST AVE	SD	GERLACH RICHARD A & EVONNE M	26442 401ST AVE	MOUNT VERNON	SD	57363	DAVISON	63660	TOBIN	962600	9626	161697.1395							4	46035C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	442.3871	448.3348	446.0054	40	PERSON		SW1/4 NW1/4 17-101-61 TOBIN TWP					2026.2		ETHAN FIRE DISTRICT
12000-10262-074-00	46	035		SD	VAN WYHE DARWYN D	24827 484TH AVE	SHERMAN	SD	57030	DAVISON	65020	UNION	962600	9626	647456.9232						1990-10-11		46035C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD				160	PERSON		SE1/4 7-102-62 UNION TWP	182	604			2026.2	1990	MT VERNON FIRE DISTRICT
15610-01000-003-00	46	035	215 E 10TH AVE	SD	RABENBERG BERTUS L & JOANNE C	215 E 10TH AVE	MITCHELL	SD	57301	DAVISON	43100	MITCHELL	962700	9627	660.6501							3	46035C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	400.7241	401.5750	401.2581	0.1630	PERSON		LT 3 BLK 10 D. A. SCOTT'S 1ST A…					2026.2		MITCHELL FIRE DISTRICT
15060-00300-002-20	46	035	1113 W 7TH AVE	SD	HALAJIAN JAMES D & NANCY C	1113 W 7TH AVE	MITCHELL	SD	57301	DAVISON	43100	MITCHELL	962801	9628.0100	659.7196							2	46035C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	401.2835	402.0657	401.7269	0.1630	PERSON		W1/2 OF LT 2 BLK 3 E.B. BRACY'…					2026.2		MITCHELL FIRE DISTRICT
10000-10160-132-20	46	035		SD	ETHAN TOWN OF	PO BOX 25	ETHAN	SD	57334	DAVISON	55740	ROME	962600	9626	72707.9196								46035C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	403.1244	406.0842	404.9179	17.8600	GOVERNMENT		LT A IN NW1/4 ROME TWP					2026.2		ETHAN FIRE DISTRICT
09000-10260-033-20	46	035		SD	EAST RIVER ELECTRIC POWER CO-OP	PO BOX 227	MADISON	SD	57042	DAVISON	52100	PROSPER	962900	9629	4180.8672								46035C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	406.0504	407.3260	406.6235	1.0300	PERSON		E150' X S300' OF SE1/4 OF SW1/4…					2026.2		MITCHELL FIRE DISTRICT
06201-10360-020-10	46	035		SD	H & R SALVAGE LLC	25351 405TH AVE	MITCHELL	SD	57301	DAVISON	43140	MITCHELL	962900	9629	1396.4715								46035C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	410.1130	410.7596	410.4004	0.3400	BUSINESS		OUTLOT 20A OUTLOTS IN SE1/4-SE …					2026.2		MITCHELL FIRE DISTRICT
15520-00100-004-10	46	035	209 E 4TH AVE	SD	TITLE PROPERTIES INC	315 S PHILLIPS AVE	SIOUX FALLS	SD	57104	DAVISON	43100	MITCHELL	962801	9628.0100	659.7859								46035C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	398.7311	399.7386	399.2343	0.1630	BUSINESS		LT 4 BLK 1 MITCHELL ORIGINAL-NE…					2026.2		MITCHELL FIRE DISTRICT
15570-00000-005-00	46	035		SD	REGAN BERT	67 S HARMON DR	MITCHELL	SD	57301	DAVISON	43100	MITCHELL	962700	9627	2090.7989								46035C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	392.4378	393.1896	392.7100	0.5370	PERSON		LT 5 BLK 1 REGAN ADDN-SE					2026.2		MITCHELL FIRE DISTRICT
07000-10362-151-15	46	035		SD	MT VERNON TOWN OF	PO BOX 52	MT VERNON	SD	57363	DAVISON	44140	MOUNT VERNON	962600	9626	16977.0829								46035C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	418.0746	422.3783	420.3904	4.2000	GOVERNMENT		IT A IN NE1/4 MT VERNON TWP					2026.2		MT VERNON FIRE DISTRICT
15666-00300-010-00	46	035		SD	CJM CONSULTING INC	375 LONDONBRIDGE RD UNIT 5	LAKE HAVASU CITY	AZ	86403	DAVISON	43100	MITCHELL	962700	9627	947.6807								46035C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	390.4839	390.8152	390.7184	0.2340	BUSINESS		LOT 10 BLK 3 15666-SOUTH LAKE…					2026.2		MITCHELL FIRE DISTRICT
15232-00400-001-01	46	035		SD	MITCHELL AREA DEVELOPMENT CORPO…	601 N MAIN ST	MITCHELL	SD	57301	DAVISON	43140	MITCHELL	962802	9628.0200	1897.0603								46035C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	392.6050	397.2714	394.5337	0.4690	BUSINESS		LT 1 BLK 4-A RIDGE VIEW ON FOST…					2026.2		MITCHELL FIRE DISTRICT
01000-10461-261-10	46	035		SD	HANSON ARBUTUS M	309 ROSE QUARTZ PL	CUSTER	SD	57730	DAVISON	03020	BADGER	962600	9626	324855.3460								46035C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	398.1152	400.8929	399.1398	80	PERSON		N1/2 NE1/4 26-104-61 BADGER TWP					2026.2		LETCHER FIRE DISTRICT
15232-00300-009-01	46	035		SD	MITCHELL AREA DEVELOPMENT CORPO…	601 N MAIN ST	MITCHELL	SD	57301	DAVISON	43100	MITCHELL	962802	9628.0200	1103.9712								46035C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	397.1087	397.6350	397.3651	0.2730	BUSINESS		LT 9 BLK 3-A RIDGE VIEW ON FOST…					2026.2		MITCHELL FIRE DISTRICT