Saved query bf67aa875528d9a1

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

21,403 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	saleamt	saledate	numbldgs	numunits	yearbuilt	numfloors	bldgsqft	firmid	firmdate	fldzone	zonesubty	elevmin	elevmax	elevavg	usecode	usedesc	zoningcode	taxacres	ownertype	naicscode	legaldesc	book	page	parceltype	accesstype	iucnclass	placename	placetype	taxyear
166934	26	001	21805 OXFORD DR		MI	48728	DILILLO PETER T	1610 POSSUM TRL	HARKER HEIGHTS	TX	76548	Alcona	54740	MITCHELL	970500	9705	158653.7193	44360	44360	44360	0	0		0	1	0	0	0	26001C	2025-12-18	X	AREA OF MINIMAL FLOOD HAZARD	279.9465	287.2248	285.2515	8400	FOREST		0.2170	GOVERNMENT	3211	LOT 0	10260	00315	GOVT FEDERAL	RESTRICTED	OTHER	HURON NATIONAL FOREST	NATIONAL FOREST	2015
169504	26	001	4005 CROCKETT AVE		MI		MEYERS WILLIAM C LISA K	4005 CROCKETT AVE	LAGO VISTA	TX	78645	Alcona	53880	MIKADO	970500	9705	160864.9416	276828	276828	276828	0	76500	1996-10-30	1	1	1974	1	3252	26001C	2025-12-18	X	AREA OF MINIMAL FLOOD HAZARD	248.1840	253.9402	252.5222		RES	A	0.2193	GOVERNMENT	1153	LOT 0	12807	00929	GOVT FEDERAL	RESTRICTED	OTHER	HURON NATIONAL FOREST	NATIONAL FOREST	2015
166741	26	001	21704 O HENRY AVE		MI	48728	GUEVARA SERGIO I	9616 SW 35TH ST	OKLAHOMA CITY	OK	73179	Alcona	54740	MITCHELL	970500	9705	162461.0264	42959	42959	42959	0	0		0	2	0	0	0	26001C	2025-12-18	X	AREA OF MINIMAL FLOOD HAZARD	287.1998	294.8987	292.1113		RES	A	0.2063	GOVERNMENT	1132	LOT 0			GOVT FEDERAL	RESTRICTED	OTHER	HURON NATIONAL FOREST	NATIONAL FOREST	2015
168355	26	001	11138 CALLANISH PARK DR		MI	48740	RAYMOR JACOB J RONNEE S EXTON	11138 CALLANISH PARK DR	AUSTIN	TX	78750	Alcona	37380	HAYNES	970100	9701	163702.2407	885035	885035	885035	0	320000	2001-03-19	1	1	1992	1	6596	26001C	2025-12-18	X	AREA OF MINIMAL FLOOD HAZARD	180.1688	185.2690	181.9949		RES	SF2	0.2309	PERSON		LOT 0								2015
167577	26	001	11809 KNIGHTS BRG		MI	48740	COX MARKWELL	11809 KNIGHTS BRG	AUSTIN	TX	78759	Alcona	36880	HARRISVILLE	970100	9701	160029.4543	561074	561074	561074	0	119500	1999-07-26	3	1	1975	1	4373	26001C	2025-12-18	X	AREA OF MINIMAL FLOOD HAZARD	210.6348	234.5001	223.4043		RES	SF2	0.2258	PERSON		LOT 0								2015
166542	26	001	3100 NOBEL CIR		MI	48745	DAVIS RUFUS	1703 GLENGREEN DR	MISSOURI CITY	TX	77489	Alcona	34820	GREENBUSH	970600	9706	159145.6544	48379	48379	48379	0	0		0	0	0	0	0	26001C	2025-12-18	X	AREA OF MINIMAL FLOOD HAZARD	193.7074	208.1784	195.6392		RES		0.2432	PERSON		LOT 32108 HIGHLAND LAKE ESTATES…	00000	00000						2009
169674	26	001	20802 HIGH DR		MI	48745	ENGLAND JOYCE A	PO BOX 4212	LAGO VISTA	TX	78645	Alcona	53880	MIKADO	970400	9704	159373.8337	328610	328610	328610	0	154900	2004-09-17	1	1	1998	1	4047	26001C	2025-12-18	X	AREA OF MINIMAL FLOOD HAZARD	207.4685	223.0962	218.8918		RES		0.3096	PERSON		LOT 0								2015
169088	26	001			MI	48721	STATE OF MICHIGAN					Alcona	01040	ALCONA	970100	9701	160374.5543							0	1				26001C	2025-12-18	X	AREA OF MINIMAL FLOOD HAZARD	179.8920	182.8587	181.2663	7240	STATE_PARK			GOVERNMENT	7212	LOT 0			GOVT STATE	OPEN		NEGWEGON STATE PARK	STATE PARK	2015
169044	26	001			MI	48721	STATE OF MICHIGAN					Alcona	01040	ALCONA	970100	9701	159916.4258							0	1				26001C	2025-12-18	X	AREA OF MINIMAL FLOOD HAZARD	182.8398	188.9779	184.2175					GOVERNMENT	7212	LOT 0			GOVT STATE	OPEN		NEGWEGON STATE PARK	STATE PARK	2015
167331	26	001			MI	48737						Alcona	54060	MILLEN	970400	9704	156899.1342							0	1				26001C	2025-12-18	X	AREA OF MINIMAL FLOOD HAZARD	250.1438	257.5305	252.3273						1132	LOT 0			GOVT FEDERAL	RESTRICTED	OTHER	HURON NATIONAL FOREST	NATIONAL FOREST	2015
170222	26	001			MI	48728						Alcona	54740	MITCHELL	970500	9705	149055.4952							0	1				26001C	2025-12-18	X	AREA OF MINIMAL FLOOD HAZARD	319.9716	344.5383	333.8707						1132	LOT 0			GOVT FEDERAL	RESTRICTED	OTHER	HURON NATIONAL FOREST	NATIONAL FOREST	2015
070-033-300-030-05	26	001	BARTON CITY POST OFFICE	BARTON CITY	MI	48705						Alcona	37220	Hawes	970400	9704	1637.8154												26001C	2025-12-18	X	AREA OF MINIMAL FLOOD HAZARD	252.0770	256.9824	254.1979				0.4000
113-027-400-168-00	26	001	COMSTOCK CREEK	MITCHELL	MI	48705						Alcona	54740	Mitchell	970500	9705	34225.5958												26001C	2025-12-18	X	AREA OF MINIMAL FLOOD HAZARD	259.6499	270.4963	266.4089				8.4600
032-270-001-004-00	26	001	CURTIS TOWNSHIP HALL	CURTIS	MI	48737						Alcona	19320	Curtis	970500	9705	1108.5384												26001C	2025-12-18	X	AREA OF MINIMAL FLOOD HAZARD	305.9981	308.3139	307.5886				0.2800
061-201-000-006-00	26	001	308 US 23	HARRISVILLE	MI	48740						Alcona	36880	Harrisville	970100	9701	2466.7774												26001C	2025-12-18	X	AREA OF MINIMAL FLOOD HAZARD	194.6829	195.7216	195.1374				0.6100
070-012-200-005-00	26	001	377 WEST MOUNT MARIA ROAD	SPRUCE	MI	48762						Alcona	37220	Hawes	970500	9705	18181.2438												26001C	2025-12-18	X	AREA OF MINIMAL FLOOD HAZARD	270.1630	286.8928	278.8124				5.9100
061-170-000-014-00	26	001	SPRINGPORT CEMETERY	HARRISVILLE	MI	48740						Alcona	36880	Harrisville	970100	9701	1989.6369												26001C	2025-12-18	X	AREA OF MINIMAL FLOOD HAZARD	178.2077	194.1044	186.0882				0.4900
111-001-300-005-00	26	001	LITTLE WOLF CREEK	MITCHELL	MI	48728						Alcona	54740	Mitchell	970500	9705	156685.7802												26001C	2025-12-18	X	AREA OF MINIMAL FLOOD HAZARD	241.7650	252.5388	247.4679				38.7100
071-030-300-009-00	26	001	WBKB-TV (ALPENA)	HAWES	MI	48742						Alcona	37220	Hawes	970400	9704	214159.4170												26001C	2025-12-18	X	AREA OF MINIMAL FLOOD HAZARD	289.5344	315.9712	301.7884				52.9400
120-150-035-002-01	26	001	ALCONA COUNTY LIBRARY	HARRISVILLE	MI	48740						Alcona	36860	Harrisville	970100	9701	1115.7325												26001C	2025-12-18	X	AREA OF MINIMAL FLOOD HAZARD	197.0314	198.4252	197.6750				0.2700
041-146-000-411-00	26	001	STEFAN'S R & R RESORT		MI	48738						Alcona	34820	Greenbush	970600	9706	6289.7943												26001C	2025-12-18	X	AREA OF MINIMAL FLOOD HAZARD	176.8358	180.4238	178.6452				1.5700
072-140-001-030-00	26	001			MI	48762						Alcona	37220	Hawes	970500	9705	4618.5933												26001C	2025-12-18	X	AREA OF MINIMAL FLOOD HAZARD	244.4341	253.9066	247.8606				1.1399
070-020-300-005-00	26	001			MI	48705						Alcona	37220	Hawes	970500	9705	321345.8574												26001C	2025-12-18	X	AREA OF MINIMAL FLOOD HAZARD	236.4920	257.2643	243.1859				79.4700
070-032-400-075-00	26	001			MI	48705						Alcona	37220	Hawes	970500	9705	18127.9977												26001C	2025-12-18	X	AREA OF MINIMAL FLOOD HAZARD	251.9620	256.7608	253.6911				4.4900
013-420-053-017-00	26	001			MI	48742						Alcona	01040	Alcona	000100	1	659.7213												26001C	2025-12-18	X	AREA OF MINIMAL FLOOD HAZARD	244.4785	245.5691	245.0636				0.1700