Saved query ce5c74d0659f6d9b

Data Explorer

Query the US Nationwide Parcel Dataset

$1.75 / 1,000 records$100 minimum

38/80

Live SQL

SELECT * 
FROM "lr_parcel_us" 
WHERE statefp = '26' 
  AND countyfp = '009'

37,551 matching parcels

Data Preview

parcelid	statefp	countyfp	parceladdr	parcelcity	parcelstate	parcelzip	ownername	owneraddr	ownercity	ownerstate	ownerzip	countyname	cousubfp	cousubname	tractce	tractname	calcarea	imprvalue	landvalue	agvalue	totalvalue	fldzone	elevmin	elevmax	elevavg	usecode	ownertype	naicscode	legaldesc	parceltype	accesstype	iucnclass	placename	placetype	lrversion	taxdistrict
05-41-030-011-00	26	009	109 S DIVISION	BELLAIRE	MI	49615	BENT DAVID - CLOVIS SUSAN J	109 S DIVISION	BELLAIRE	MI	49615	ANTRIM	42400	KEARNEY	960401	9604.0100	8714.1339	128063	128063	128063	0	—	189.5109	191.2401	190.0970	201	PERSON	721	0				ALL SEASONS MOTEL	HOTEL	2026.2	05040
05-45-020-088-00	26	009	112 E STATE ST	MANCELONA	MI	49659	MECOLLI EVIS	36791 CANYON DR	WESTLAND	MI	48186	ANTRIM	50640	MANCELONA	960702	9607.0200	2316.4296	85549	85549	85549	0	—	341.7037	342.5799	342.1911	401	PERSON	721	0				MANCELONA TRAIN DEPOT	HOTEL	2026.2	05070
05-02-029-025-10	26	009	1590 N EAST TORCH LAKE DR	CENTRAL LAKE	MI	49622	NORTHERN MICHIGAN DOCKS INC	1590 N EAST TORCH LAKE DR	CENTRAL LAKE	MI	49622	ANTRIM	14420	CENTRAL LAKE	960300	9603	5911.5690	90728	90728	90728	0	—	194.4578	198.2279	195.6352	201	BUSINESS	713930	1.5000				POSEIDON MARINE	MARINA	2026.2	05035
05-11-108-030-10	26	009	1901 SCHOLL RD	MANCELONA	MI	49659	MANCELONA SELF STORAGE LLC	10305 ELK LAKE TRAIL	WILLIAMSBURG	MI	49690	ANTRIM	50640	MANCELONA	960701	9607.0100	9762.2451	181774	181774	181774	0	—	340.6124	342.1968	341.1533	201	BUSINESS	531130	2.4100				MANCELONA SELF STORAGE - SCHOLL…	SELF-STORAGE FACILITY	2026.2	05070
05-43-021-010-01	26	009	211 LOOMIS DR	ELK RAPIDS	MI	49629	SBC MANAGEMENT OF NORTHERN MI L…	211 INDUSTRIAL DR	ELK RAPIDS	MI	49629	ANTRIM	25340	ELK RAPIDS	960600	9606	13905.0949	638727	638727	638727	0	—	181.2375	184.1054	183.0994	301	BUSINESS	531130	3.4700				CRAM-IT STORAGE	SELF-STORAGE FACILITY	2026.2	05060
05-10-395-009-00	26	009	5820 SHANTY CREEK RD	BELLAIRE	MI	49615	THE TIMBERLINE SHOPS LLC	12705 N ADRIAN HWY	CLINTON	MI	49236	ANTRIM	42400	KEARNEY	960401	9604.0100	57.1718	6777	6777	6777	0	—	298.9966	299.1636	299.0776	201	BUSINESS	721	0				HAWK'S EYE GOLF CLUB	HOTEL	2026.2	05040
05-06-009-001-30	26	009			MI	0	G T REGIONAL LAND CONSERVANCY	3860 N LONG LAKE RD STE D	TRAVERSE CITY	MI	49684	ANTRIM	25340	ELK RAPIDS	960600	9606	78709.8724					—	176.7879	187.6444	179.7883	402	PERSON	712190	15	NGO	OPEN	V	WILCOX-PALMER-SHAH PRESERVE	NATURE_RESERVE	2026.2	05060
05-12-655-003-00	26	009			MI	0	NOGALSKI DAVID	6585 GULLEY	DEARBORN HEIGHTS	MI	48127	ANTRIM	54440	MILTON	960501	9605.0100	1060.9666	3334	3334	3334	0	—	185.0550	186.1190	185.7586	402	PERSON		0						2026.2	05060
05-12-670-010-00	26	009	4672 JUNIPER DR	KEWADIN	MI	49648	HILLIARD JOHN R & JANE B	1443 GLEN CANNON DR	PISGAH FOREST	NC	28768	ANTRIM	54440	MILTON	960600	9606	2856.7807	197064	197064	197064	0	—	178.5028	183.5023	181.4624	401	PERSON		0						2026.2	05060
05-08-026-005-00	26	009			MI	0	LOGEE ROBERT J	P O BOX 193	ALDEN	MI	49612	ANTRIM	37500	HELENA	960502	9605.0200	8538.4254	11269	11269	11269	0	—	240.7457	256.1893	246.9339	402	PERSON		2.2320						2026.2	05070
05-10-029-024-00	26	009			MI	0	CENTRAL LAKE PROPERTIES LLC	3645 S DERENZY RD	BELLAIRE	MI	49615	ANTRIM	42400	KEARNEY	960401	9604.0100	5290.9964	1662	1662	1662	0	—	278.6119	289.2086	283.7404	402	BUSINESS		0						2026.2	05040
05-13-450-389-00	26	009			MI	0	STEWART DAVID SHANE	3700 LANSING RD	ROSCOMMON	MI	48653	ANTRIM	76260	STAR	960701	9607.0100	1857.5414	528	528	528	0	—	410.1958	410.6656	410.3560	402	PERSON		0						2026.2	05010
05-14-313-071-00	26	009			MI	0	RUPP FREDERICK C	705 GULICK RD	HASLETT	MI	48840	ANTRIM	80100	TORCH LAKE	960100	9601	254.1057	100	100	100	0	—	183.5385	184.0532	183.7487	402	PERSON		0.0600						2026.2	05035
05-45-090-007-00	26	009			MI	0	CLARK JON M	313 FOREST ST.	MANCELONA	MI	49659	ANTRIM	50640	MANCELONA	960702	9607.0200	670.6554	1044	1044	1044	0	—	338.9851	339.6032	339.1738	402	PERSON		0						2026.2	05070
05-08-270-013-00	26	009			MI	0	O'MEARA DEVIN	4151 CLAM LAKE DR	BELLAIRE	MI	49615	ANTRIM	37500	HELENA	960402	9604.0200	1336.8880	3294	3294	3294	0	—	179.6549	180.4382	180.0678	402	PERSON		0						2026.2	05070
05-45-017-057-00	26	009			MI	0	WILKS DANIEL E	32 LAFAYETTE ST	MOUNT CLEMENS	MI	48043	ANTRIM	50640	MANCELONA	960702	9607.0200	808.9693	1440	1440	1440	0	—	339.1660	340.0381	339.4185	402	PERSON		0						2026.2	05070
05-05-008-008-00	26	009	4521 DINGMAN SCHOOL RD	EAST JORDAN	MI	49727	RIES BRYON & TINA	4521 DINGMAN SCHOOL RD	EAST JORDAN	MI	49727	ANTRIM	24640	ECHO	960200	9602	4383.5456	92819	92819	92819	0	—	194.1357	198.3162	196.4029	401	PERSON		0						2026.2	05035
05-11-116-033-00	26	009	8625 N EAST LIMITS ST	MANCELONA	MI	49659	WARDELL JOSEPH & OSTAFIN WALTER…	PO BOX 782	MANCELONA	MI	49659	ANTRIM	50640	MANCELONA	960702	9607.0200	1858.4328	33256	33256	33256	0	—	339.0363	339.7412	339.3859	401	PERSON		0						2026.2	05070
05-14-211-014-11	26	009	1976 S US 31	KEWADIN	MI	49648	SANMIGUEL CHASE	1976 S US 31	KEWADIN	MI	49648	ANTRIM	80100	TORCH LAKE	960600	9606	5041.6998	123323	123323	123323	0	—	228.6182	229.6045	229.0289	401	PERSON		0						2026.2	05060
05-44-125-036-00	26	009			MI	0	FERGUSON JOHN E	6930 FOREST HILL DR	ELLSWORTH	MI	49729	ANTRIM	05240	BANKS	960100	9601	3683.8454	6000	6000	6000	0	—	225.6691	239.9925	233.0493	402	PERSON		0						2026.2	05065
05-02-575-006-00	26	009			MI	0	BENNETT GAYLE E	PO BOX 241	RICHMOND	MI	48062	ANTRIM	14420	CENTRAL LAKE	960300	9603	1053.5064	32024	32024	32024	0	—	180.3865	184.8007	183.3795	402	PERSON		0						2026.2	05035
05-04-400-070-00	26	009	6733 TANNE VALDEN STRASSE E	BELLAIRE	MI	49615	BLACKPORT KENNETH D & JOANNE C	6733 TANNE VALDEN STRASSE EAST	BELLAIRE	MI	49615	ANTRIM	19400	CUSTER	960401	9604.0100	1402.3359	94962	94962	94962	0	—	263.6866	265.7257	264.8191	401	PERSON		0						2026.2	05070
05-46-200-012-00	26	009	709 N BRIDGE	BELLAIRE	MI	49615	BARRY LUKE & KAITLYN	709 N BRIDGE	BELLAIRE	MI	49615	ANTRIM	29600	FOREST HOME	960402	9604.0200	1617.9993	103024	103024	103024	0	—	195.3885	195.9800	195.6681	401	PERSON		0						2026.2	05040
05-12-101-008-40	26	009			MI	0	DONTJE JASON	2240 RALEIGH AVE	COSTA MESA	CA	92627	ANTRIM	54440	MILTON	960501	9605.0100	8708.9124	23518	23518	23518	0	—	210.9508	216.5397	212.8731	402	PERSON		2.1500						2026.2	05060
05-13-300-098-00	26	009			MI	0	MALCOMSON JENNIFER	5898 FORESTGROVE DRIVE	ELMIRA	MI	49730	ANTRIM	76260	STAR	960701	9607.0100	2344.5649	555	555	555	0	—	402.4207	405.2924	403.7831	402	PERSON		0						2026.2	05010