Saved query 8e1fcc1519b0b9a5

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 = '26' 
  AND countyfp = '143'

35,452 matching parcels

Data Preview

parcelid	statefp	countyfp	parceladdr	parcelcity	parcelstate	ownername	owneraddr	ownercity	ownerzip	countyname	cousubfp	cousubname	tractce	tractname	calcarea	imprvalue	landvalue	agvalue	numbldgs	numunits	numfloors	fldzone	elevmin	elevmax	elevavg	usecode	usedesc	taxacres	ownertype	legaldesc	township	section	qtrsection	range	plssdesc	lrversion	taxyear
011-460-091-0000	26	143		HOUGHTON LAKE	MI	PERRY ROBERT	1930 AUTUMN	FARWELL	48622	ROSCOMMON	69560	ROSCOMMON	971200	9712	1169.1424	61100	61100	61100	2	1	1	—	349.5508	349.9885	349.7523			0	PERSON	L-283 P-646 224 LOT 91 LINWOOD …	22N	11	SW	4W	SW 1/4S11 T22N R4W	2026.2	2024
008-865-002-0050	26	143	2816 W DOYLE TRL		MI	DAWSON BARBARA A	2816 W DOYLE TRAIL	ROSCOMMON	48653	ROSCOMMON	51780	MARKEY	970700	9707	957.5126	53200	53200	53200	1	1	1	—	350.2456	351.5739	350.8382			0	PERSON	L-782 P-134 233 2816 DOYLE TRAI…	23N	34	SE	3W	SE 1/4S34 T23N R3W	2026.2	2024
003-214-252-0000	26	143		PRUDENVILLE	MI	FRY JOHN S JENNIFER J TRUST	12732 ORIAGO ST	VENICE	34293	ROSCOMMON	21640	DENTON	970700	9707	778.1272	126300	126300	126300	1	1	1	—	346.9995	348.1162	347.8310			0	TRUST	L-804 P-80 223 LOT 252 CHEROKEE…	22N	9	SE	3W	SE 1/4S9 T22N R3W	2026.2	2024
008-835-012-0000	26	143		HOUGHTON LAKE	MI	KLENDER EUGENE L SYLVIA S TRUST	4120 GRANGER	ORTONVILLE	48462	ROSCOMMON	51780	MARKEY	970700	9707	1539.5221	167500	167500	167500	1	1	2	—	346.6304	351.1525	349.1562			0	TRUST	233 L-620 P-84 731 OLD TRAIL DR…	23N	34	SE	3W	SE 1/4S34 T23N R3W	2026.2	2024
008-550-009-0000	26	143		ROSCOMMON	MI	BARTYS JUDY A	120 BRYANT DR	ROSCOMMON	48653	ROSCOMMON	51780	MARKEY	970600	9706	3382.4490	49900	49900	49900	1	1	2	—	373.6463	376.1527	375.1642			1	PERSON	L-689 P-64 233 120 BRYANT DR LO…	23N	5	NE	3W	NE 1/4S5 T23N R3W	2026.2	2024
010-485-002-0000	26	143		SAINT HELEN	MI	EICK EDWARD TRUST 2/9/05	4177 PRATT RD	METAMORA	48455	ROSCOMMON	68200	RICHFIELD	970200	9702	1217.9058	217500	217500	217500	1	1	2	—	352.4606	353.4323	352.9571			0	TRUST	L-1041 P-1337-1340 L-310 P-183 …	23N	28	NE	1W	NE 1/4S28 T23N R1W	2026.2	2024
010-511-019-0000	26	143		SAINT HELEN	MI	GRIDER NICHOLAS A	4334 TOBOGGAN LANE	WEST BRANCH	48661	ROSCOMMON	68200	RICHFIELD	970200	9702	1111.5292	43200	43200	43200	2	1	1	—	363.3216	365.5702	364.6283			0	PERSON	L-669 P-437 231 9558 ROSE DR LO…	23N	27	NE	1W	NE 1/4S27 T23N R1W	2026.2	2024
003-690-049-0000	26	143		HOUGHTON LAKE	MI	BLACKNEY DEBRA A BLACKNEY CHARL…	935 FEDERAL AVE	HOUGHTON LAKE	48629	ROSCOMMON	21640	DENTON	971200	9712	519.0075	54600	54600	54600	1	1	1	—	353.2201	354.3243	353.7161			0	PERSON	L-951 P-1744-1745 L-488 P-488 2…	22N	18	NW	3W	NW 1/4S18 T22N R3W	2026.2	2024
010-505-022-0000	26	143		SAINT HELEN	MI	FLETCHER KATHRYN S	7643 JUNE AVE	SAINT HELEN	48656	ROSCOMMON	68200	RICHFIELD	970100	9701	675.5151	114800	114800	114800	1	1	1	—	354.3363	355.7101	355.3031			0	PERSON	L-358 P-518 231 LOT 22 MAXSON G…	23N	8	SE	1W	SE 1/4S8 T23N R1W	2026.2	2024
003-235-244-1000	26	143		PRUDENVILLE	MI	DIEHL NICKI L	4665 VANDALIA ST	COMMERCE TOWNSHIP	48382	ROSCOMMON	21640	DENTON	971100	9711	7360.2987	67200	67200	67200	3	1	1	—	358.0978	359.6166	358.9809			2	PERSON	L-1034 P-1979 L-696 P-399 LOTS …	22N	23	SW	3W	SW 1/4S23 T22N R3W	2026.2	2024
003-685-011-0000	26	143		PRUDENVILLE	MI	114 HAZELWOOD LLC	1002 E THIRD ST	ROYAL OAK	48067	ROSCOMMON	21640	DENTON	971100	9711	1209.9709	84200	84200	84200	1	1	1	—	352.1984	354.2362	353.7698			0	BUSINESS	223 114 HAZELWOOD LOT 11 SPRIN…	22N	13	SW	3W	SW 1/4S13 T22N R3W	2026.2	2024
003-310-018-0000	26	143		PRUDENVILLE	MI	TDL LLC	813 N WRIGHT RD	FOWLER	48835	ROSCOMMON	21640	DENTON	970700	9707	656.0235	121600	121600	121600	1	1	1	—	347.5358	347.8156	347.6698			0	BUSINESS	223 LOT 18 HIAWATHA VILLAGE	22N	9	SE	3W	SE 1/4S9 T22N R3W	2026.2	2024
005-250-058-0000	26	143		ROSCOMMON	MI	BAERLOCHER KATIE JANELL	1749 HIGH RD	ROSCOMMON	48653	ROSCOMMON	38020	HIGGINS	970300	9703	1106.3317	53300	53300	53300	1	1	1	—	347.2249	348.0008	347.4338			0	PERSON	242 214 CENTER DR LOT 58 BROOKS…	24N	7	NW	2W	NW 1/4S7 T24N R2W	2026.2	2024
010-434-020-0000	26	143		SAINT HELEN	MI	BROWN DEBRA L	1718 OMER DR	SAINT HELEN	48656	ROSCOMMON	68200	RICHFIELD	970200	9702	777.8381	32500	32500	32500	2	1	1	—	366.4104	367.0376	366.7332			0	PERSON	L-735 P-285 231 LOT 20 GLENWOOD…	23N	26	NW	1W	NW 1/4S26 T23N R1W	2026.2	2024
005-540-014-0000	26	143		ROSCOMMON	MI	MCCLAIN ERIK	17367 PERSHING ST	LIVONIA	48152	ROSCOMMON	38020	HIGGINS	970300	9703	2137.9562	3200	3200	3200				—	356.3470	357.2888	356.8883	7240	PARK	1	PERSON	L-857 P-333 L-386 P-249 242 LOT…	24N	3	NE	2W	NE 1/4S3 T24N R2W	2026.2	2024
008-525-031-0000	26	143		ROSCOMMON	MI	NAPOLI ACHILLE JOANN	12204 LITTLE RIVER		XXXXX	ROSCOMMON	51780	MARKEY	970600	9706	1881.7066	63700	63700	63700	1	1	1	—	364.6702	365.5838	365.0018			0	PERSON	L-768 P-291 233 LOT 31 LEISURE …	23N	6	NE	3W	NE 1/4S6 T23N R3W	2026.2	2024
004-223-153-0000	26	143		ROSCOMMON	MI	EGOLF WILLIAM	2116 WHITE AVE	LINCOLN PARK	48146	ROSCOMMON	31960	GERRISH	970402	9704.0200	804.4333	4200	4200	4200				—	369.1353	369.8653	369.3796			0	PERSON	L-952 P-2028 L-618 P-189 243 24…	24N	32	SW	3W	SW 1/4S32 T24N R3W	2026.2	2024
011-350-098-0000	26	143		HOUGHTON LAKE	MI	CHAPMAN JERRY L RHONDA K	9270 W CUTLER RD	EAGLE	48822	ROSCOMMON	69560	ROSCOMMON	971200	9712	327.4083	2500	2500	2500				—	349.7656	350.3189	350.0317			0	PERSON	L-276 P-261 224 LOT 98 HIGHLAND…	22N	11	NW	4W	NW 1/4S11 T22N R4W	2026.2	2024
011-541-605-0000	26	143		HOUGHTON LAKE	MI	SHEMANSKI JOSEPH R	227 CHIPPENDALE	HOUGHTON LAKE	48629	ROSCOMMON	69560	ROSCOMMON	971003	9710.0300	1940.6396	79700	79700	79700				—	364.7618	366.0480	365.4812			0	PERSON	L-837 P-90 L-832 P-168&L-794 P-…	22N	23	NE	4W	NE 1/4S23 T22N R4W	2026.2	2024
010-512-077-0000	26	143		SAINT HELEN	MI	GEARY ROBERT TERRY	PO BOX 99	SAINT HELEN	48656	ROSCOMMON	68200	RICHFIELD	970200	9702	1219.8273	3400	3400	3400				—	360.2499	363.4447	361.2472			0	PERSON	L-963 P-2132 L-694 P-309 231 LO…	23N	27	NW	1W	NW 1/4S27 T23N R1W	2026.2	2024
010-511-009-0000	26	143		SAINT HELEN	MI	MALIK CHARLES	PO BOX 121	SAINT HELEN	48656	ROSCOMMON	68200	RICHFIELD	970200	9702	856.7280	3000	3000	3000				—	362.4352	362.9965	362.7520			0	PERSON	231 LOT 9 OAKWOOD.	23N	27	NE	1W	NE 1/4S27 T23N R1W	2026.2	2024
011-340-033-0000	26	143		HOUGHTON LAKE	MI	RINGS WILLIAM MC	PO BOX 81	SAINT JOHNS	48879	ROSCOMMON	69560	ROSCOMMON	971001	9710.0100	5535.3412	2500	2500	2500				—	348.5916	349.5735	349.0721			1	PERSON	L-602 P-252 224 LOT 33 HIGHLAND…	22N	36	NW	4W	NW 1/4S36 T22N R4W	2026.2	2024
011-460-133-0000	26	143		HOUGHTON LAKE	MI	RISTE SCOTT	32250 CHESTER	GARDEN CITY	48135	ROSCOMMON	69560	ROSCOMMON	971200	9712	718.9373	10500	10500	10500				—	349.7660	351.2231	350.2543			0	PERSON	224 L-804 P-481 LOT 133 LINWOOD…	22N	11	SW	4W	SW 1/4S11 T22N R4W	2026.2	2024
011-496-027-0000	26	143		HOUGHTON LAKE	MI	PINEVIEW HIGHLANDS LTD LLC	PO BOX 156	HOUGHTON LAKE	48629	ROSCOMMON	69560	ROSCOMMON	971200	9712	1394.9862	6300	6300	6300				—	380.5420	383.3504	381.9375			0	BUSINESS	L-981 P-1616 L-8 P-6 224 LOT 27…	22N	13	SE	4W	SE 1/4S13 T22N R4W	2026.2	2024
011-214-009-0065	26	143		HOUGHTON LAKE	MI	BLAINE PETER C	901 CRESTLINE	HOUGHTON LAKE	48629	ROSCOMMON	69560	ROSCOMMON	971200	9712	6401.9913	9100	9100	9100				—	358.8373	363.5569	360.7983			2	PERSON	L-432 P-21-22 L-433 P-73 224 CO…	22N	14	SW	4W	SW 1/4S14 T22N R4W	2026.2	2024