Saved query 92b4dd63709bdccd

Data Explorer

Query the US Nationwide Parcel Dataset

$1.75 / 1,000 records$100 minimum

0/80

Live SQL

SELECT * 
FROM "parcel_layer" 
WHERE statefp = '26' 
  AND countyfp = '143'

34,430 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	firmid	firmdate	fldzone	zonesubty	elevmin	elevmax	elevavg	usecode	taxacres	ownertype	naicscode	legaldesc	parceltype	accesstype	placename	placetype
010-366-029-0000	26	143	7745 AMBLE AVE	SAINT HELEN	MI	48656	GILES DONALD &COVERT GAYLE TRUS…	31738 SEVENTH STREET	WARREN	MI	48092	Roscommon	68200	Richfield	970100	9701	2098.3675	49500	49500	49500	26143C	2025-12-18	X	AREA OF MINIMAL FLOOD HAZARD	352.3379	353.9903	352.9603	401	1	TRUST	7212	231 LOT 29 BLK 6 AU SABLE RIVER…	PRIVATE	RESTRICTED	AU SABLE RIVER PARK	PRIVATE RECREATION OR EDUCATION
009-105-009-0160	26	143	OAK RD		MI		GODEK DONNEL J	43908 PINOT NOIR	STERLING HEIGHTS	MI	48314	Roscommon	56980	Nester	971100	9711	43679.5210	41100	41100	41100	26143C	2025-12-18	X	AREA OF MINIMAL FLOOD HAZARD	370.2844	381.4604	376.6179	401	11	PERSON	1125	L-1023 P-932 (L-959 P-1047) 211…	PRIVATE	RESTRICTED	TWENTY-FIVE HUNDRED CORP	PRIVATE RECREATION OR EDUCATION
011-226-001-0141	26	143	4230 TOWER HILL RD	HOUGHTON LK	MI	48629	CHURCHILL THOMAS J & LAURA L	4230 TOWER HILL RD	HOUGHTON LAKE	MI	48629	Roscommon	69560	Roscommon	971001	9710.0100	4049.3997	110900	110900	110900	26143C	2025-12-18	X	AREA OF MINIMAL FLOOD HAZARD	355.9125	357.0324	356.4835	401	1	PERSON	6216	L-723 P-14 224 4230 TOWERHILL R…			C.L.C LAWN SERVICES LLC	HOME_SERVICE
006-140-012-0000	26	143	13097 WEST SHORE DR	HOUGHTON LAKE	MI	48629	BEARDSLEY JESSIE J & JUDY R	13097 W SHORE DR	HOUGHTON LAKE	MI	48629	Roscommon	44400	Lake	970600	9706	1634.8506	45100	45100	45100	26143C	2025-12-18	X	AREA OF MINIMAL FLOOD HAZARD	347.5239	348.1123	347.8588	401	0	PERSON	7211	L-826 P-460 (L-704 P-199) 234 L…			J. & J. RESORT NORTH	LODGING
011-330-010-0000	26	143	TERRACE	HOUGHTON LAKE	MI	48629	FEKETE KNAGGS INVESTMENTS LLC	9147 WINDSONG LN	CADILLAC	MI	49601	Roscommon	69560	Roscommon	971200	9712	874.5827	9000	9000	9000	26143C	2025-12-18	X	AREA OF MINIMAL FLOOD HAZARD	355.7461	356.3231	355.9396	202	0	BUSINESS	52591	L-650 P-534 224 SE'LY 75 FT OF …
011-450-231-0000	26	143	CHAMPLAIN	HOUGHTON LAKE	MI	48629	ECOLOGICAL REHAB OF AMERICA INC	34044 GLENNDALE ST	LIVONIA	MI	48150	Roscommon	69560	Roscommon	971200	9712	1009.8357	5000	5000	5000	26143C	2025-12-18	X	AREA OF MINIMAL FLOOD HAZARD	367.8832	371.5785	369.9757	402	0	BUSINESS	6239	224 L-989 P-1160 LOTS 231 & 232…
011-202-009-0630	26	143	317 BROWN	HOUGHTON LAKE	MI	48629	VICIOUS INVESTMENT PROPERTIES L…	PO BOX 899	PRUDENVILLE	MI	48651	Roscommon	69560	Roscommon	971200	9712	835.5530	36300	36300	36300	26143C	2025-12-18	X	AREA OF MINIMAL FLOOD HAZARD	351.6549	352.2810	352.0080	401	0	BUSINESS	53119	224 L-1049P-1432-1433 (L-1015P-…
004-018-013-0322	26	143	4439 W HIGGINS LAKE DRIVE	ROSCOMMON	MI	48653	TLCC INVESTMENTS LLC	10605 EASTRIDGE CT	ROSCOMMON	MI	48653-8983	Roscommon	31960	Gerrish	970402	9704.0200	2774.4953	67800	67800	67800	26143C	2025-12-18	X	AREA OF MINIMAL FLOOD HAZARD	352.8664	354.6219	353.1738	201	1	BUSINESS	3341	L-983 P-483 L-964 P-479 (L-817 …
011-213-003-0600	26	143	5014 W HOUGHTON LAKE DR	HOUGHTON LAKE	MI	48629	BEACHFRONT HOTEL LLC	7215 ORCHARD LAKE RD SUITE 301	WEST BLOOMFIELD	MI	48322	Roscommon	69560	Roscommon	971200	9712	2493.3786	135600	135600	135600	26143C	2025-12-18	X	AREA OF MINIMAL FLOOD HAZARD	346.6304	356.4058	353.0181	401	1	BUSINESS	72111	L-486 P-528 224 COM AT PT OF IN…
055-725-018-0000	26	143	217 S FOURTH ST	ROSCOMMON	MI	48653	TWB ROSCOMMON INVESTMENTS LLC	PO BOX 175	ROSCOMMON	MI	48653	Roscommon	38020	Higgins	970300	9703	1853.7773	123700	123700	123700	26143C	2025-12-18	X	AREA OF MINIMAL FLOOD HAZARD	342.3129	343.5700	343.2551	201	0	BUSINESS	52591	L-804 P-2 242 217 S FOURTH ST L…
006-200-012-0000	26	143	3361 LONG POINT	HOUGHTON LAKE	MI	48629	JOHNSON TODD A & ANDREA J	9283 LA SPEZIA DR	DAVISON	MI	48423	Roscommon	44400	Lake	970600	9706	678.7002	144300	144300	144300	26143C	2025-12-18	X	AREA OF MINIMAL FLOOD HAZARD	347.5082	348.4059	347.9680	401	0	PERSON		L-419 P-452 234 LOT 12 EVERGREE…
005-105-006-0020	26	143	11697 LANCEWOOD DR	ROSCOMMON	MI	48653	DOUGHERTY DAVID C & MARLENE K T…	PO BOX 627	ROSCOMMON	MI	48653	Roscommon	38020	Higgins	970300	9703	2188.7178	125200	125200	125200	26143C	2025-12-18	X	AREA OF MINIMAL FLOOD HAZARD	341.7580	347.9888	347.0066	401	1	TRUST		L-814 P-664 242 COM AT SE COR O…
010-434-022-0000	26	143	1734 OMER DR	SAINT HELEN	MI	48656	KELLER RAYMOND M	PO BOX 936	LAKE CITY	MI	49651	Roscommon	68200	Richfield	970200	9702	742.2638	40900	40900	40900	26143C	2025-12-18	X	AREA OF MINIMAL FLOOD HAZARD	366.2498	366.8645	366.4738	401	0	PERSON		(L-1037P-2509&L-998P-2563&L-311…
003-235-196-0000	26	143	THUNDERBIRD TRL VACANT		MI		STOLARCZYK DANIEL	8719 COOLEY BEACH DR	WHITE LAKE	MI	48386	Roscommon	21640	Denton	971100	9711	1155.0502	2800	2800	2800	26143C	2025-12-18	X	AREA OF MINIMAL FLOOD HAZARD	358.9830	359.8576	359.4132	402	0	PERSON		L-1008P-2215 (L-962P-2061&L-687…
003-662-169-0000	26	143	SANDY OAK CONDO	HOUGHTON LAKE	MI	48629	SCHMIDT HENRY G & CYNTHIA M	2075 CEDAR ST	HOLT	MI	48842	Roscommon	21640	Denton	971002	9710.0200	223.1566	8800	8800	8800	26143C	2025-12-18	X	AREA OF MINIMAL FLOOD HAZARD	355.0360	355.3404	355.1810	407	0	PERSON		L-891 P-38 (L-688 P-40-54) 223 …
008-865-041-0000	26	143	E HOUGHTON LAKE DR		MI		BOGGS FAMILY TRUST	PO BOX 20	PRUDENVILLE	MI	48651	Roscommon	51780	Markey	970700	9707	5713.0645	58600	58600	58600	26143C	2025-12-18	X	AREA OF MINIMAL FLOOD HAZARD	350.9858	352.0242	351.5030	402	1	TRUST		L-577 P-497 233 LOTS 41 TO 44 I…
004-800-237-0000	26	143	W HIGGINS LAKE DRIVE	ROSCOMMON	MI	48653	DAWSON JULIE A	8411 SHARI DR	WESTLAND	MI	48185-7063	Roscommon	31960	Gerrish	970402	9704.0200	1015.2168	7600	7600	7600	26143C	2025-12-18	X	AREA OF MINIMAL FLOOD HAZARD	367.5664	375.4609	371.9886	402	0	PERSON		L-583 P-28 243 LOT 237 ASSESSOR…
011-214-011-0110	26	143	2835 S LOXLEY	HOUGHTON LAKE	MI	48629	KOMPERDA ANDREW J	2835 S LOXLEY	HOUGHTON LAKE	MI	48629	Roscommon	69560	Roscommon	971200	9712	2368.7973	72000	72000	72000	26143C	2025-12-18	X	AREA OF MINIMAL FLOOD HAZARD	353.4960	355.4045	354.1322	401	1	PERSON		L-1024 P-1483 (L-991P-1994&L-10…
007-024-013-1110	26	143	8343 DEVINS TRAIL	ROSCOMMON	MI	48653	HARRISON ROBIN	8343 DEVINS TRL	ROSCOMMON	MI	48653-8473	Roscommon	49840	Lyon	970402	9704.0200	30177.0605	117400	117400	117400	26143C	2025-12-18	X	AREA OF MINIMAL FLOOD HAZARD	364.8273	385.4267	373.5898	401	7	PERSON		1160/357 1160/356 1160/354 1160…
003-675-062-1000	26	143	227 RIDGEWOOD DR	PRUDENVILLE	MI	48651	WASCHER BRIAN F & JUDY A	769 W BROWN ST	MUNGER	MI	48747	Roscommon	21640	Denton	971100	9711	1034.1087	204400	204400	204400	26143C	2025-12-18	X	AREA OF MINIMAL FLOOD HAZARD	352.1642	352.9421	352.7149	401	0	PERSON		L-948 P-1673 L-1016 P-353 223 S…
003-235-177-0000	26	143	208 DEER RUN BLVD	PRUDENVILLE	MI	48651	ODOWD ROBERT & MELISSA	22893 BORDMAN RD	BERLIN	MI	48002	Roscommon	21640	Denton	971100	9711	1174.0810	24500	24500	24500	26143C	2025-12-18	X	AREA OF MINIMAL FLOOD HAZARD	358.8966	360.3005	359.6357	401	0	PERSON		L-1036 P-116-118 (L-431 P-488) …
011-225-004-0040	26	143	4404 S TOWNLINE	HOUGHTON LAKE	MI	48629	WRIGHT GERALD H TRUST & MASKELL…	5040 E SHERIDAN	CROSWELL	MI	48422	Roscommon	69560	Roscommon	971001	9710.0100	1853.4400	32700	32700	32700	26143C	2025-12-18	X	AREA OF MINIMAL FLOOD HAZARD	365.0184	367.4693	365.8309	401	0	TRUST		(L-703 P-317 &FILE) 224 L-840 P…
004-464-009-0000	26	143	318 CARDINAL AVE	ROSCOMMON	MI	48653	SABLE CRAIG M	3851 HONORS WAY	HOWELL	MI	48843-7494	Roscommon	31960	Gerrish	970500	9705	3456.3946	715500	715500	715500	26143C	2025-12-18	X	AREA OF MINIMAL FLOOD HAZARD	351.2376	353.2337	352.8522	401	1	PERSON		(L-841 P-151&L-840 P-170&L-609 …
007-653-030-0000	26	143	104 TAYLOR AVENUE	ROSCOMMON	MI	48653	KEESAER JOSEPH A & STARR L	104 TAYLOR AVE	ROSCOMMON	MI	48653-9528	Roscommon	49840	Lyon	970500	9705	776.4454	83900	83900	83900	26143C	2025-12-18	X	AREA OF MINIMAL FLOOD HAZARD	355.1447	356.2047	355.4430	401	0	PERSON		L-1045 P-2327 (L-687 P-15) 244 …
011-228-007-0013	26	143	9992 SNOWBOWL RD	HOUGHTON LAKE	MI	48629	ARNST WALTER J	9992 SNOW BOWL RD	HOUGHTON LAKE	MI	48629	Roscommon	69560	Roscommon	971001	9710.0100	8699.9772	69600	69600	69600	26143C	2025-12-18	X	AREA OF MINIMAL FLOOD HAZARD	339.7278	345.2580	342.1950	401	2	PERSON		L-999 P-2652 (L-960 P-1647) 224…