Data Explorer

Query the US Nationwide Parcel Dataset

$1.75 / 1,000 records$100 minimum

39/80

Live SQL
SELECT * 
FROM "lr_parcel_us" 
WHERE statefp = '26' 
  AND countyfp = '005'

71,784 matching parcels

Data Preview

parcelid
taxacctnum
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
bedrooms
halfbaths
fullbaths
firmid
firmdate
fldzone
zonesubty
staticbfe
elevmin
elevmax
elevavg
usecode
usedesc
zoningcode
zoningdesc
taxacres
ownertype
naicscode
legaldesc
township
section
qtrsection
range
plssdesc
book
page
parceltype
accesstype
iucnclass
placename
placetype
fireplaces
heating
heatfuel
cooling
foundation
roofcover
siding
lrversion
taxyear
taxdistrict
24-025-015-2226005129 126TH AVEWAYLANDMI49348WHIP DOUGLAS J & KIMBERLY M129 126TH AVEWAYLANDMI49348ALLEGAN84900WAYLAND030501305.010054993.652626005C2025-12-18XAREA OF MINIMAL FLOOD HAZARD230.0724235.9474232.826713.5872PERSONGUN LAKE PET LODGEANIMAL_OR_PET_SERVICE2026.2
56-650-012-0026005624 PINE STWAYLANDMI49348RABIDEAU JANICE624 PINE STWAYLANDMI49348ALLEGAN84880WAYLAND030502305.02001324.904426005C2025-12-18XAREA OF MINIMAL FLOOD HAZARD228.9138231.5984229.76270.3273PERSON2026.2
02-033-004-0026005 PENNY LANE SOUTH HAVENMI49090MERRY THOMAS J & SUSAN E TRUST17928 ASHMONT PLSOUTH BENDIN46635ALLEGAN13700CASCO030901309.010055636.589926005C2025-12-18XAREA OF MINIMAL FLOOD HAZARD188.8498194.8894190.396513.7466TRUST2026.2
02-226-016-00260051011 ORCHARD AVESOUTH HAVENMI49090LANG CHRISTOPHER H1011 ORCHARD AVESOUTH HAVENMI49090ALLEGAN13700CASCO030901309.01002347.165626005C2025-12-18XAREA OF MINIMAL FLOOD HAZARD203.5086208.3038206.10340.5798PERSON2026.2
17-007-001-0126005 MI ALLEGAN61640OTSEGO03180031825656.663026005C2025-12-18XAREA OF MINIMAL FLOOD HAZARD201.4673216.4181210.77076.3389GOVT STATERESTRICTEDVALLEGAN STATE GAME AREASTATE CONSERVATION AREA2026.2
09-001-010-10260053493 38TH STHAMILTONMI49419MARSH JOHN F & MARILYN J3493 38TH STHAMILTONMI49419ALLEGAN37460HEATH030702307.02008083.014326005C2025-12-18XAREA OF MINIMAL FLOOD HAZARD203.4734205.8103204.79661.9971PERSON2026.2
14-033-037-10260052433 55TH STFENNVILLEMI49408BATEY HOWARD & DORLA2433 55TH STFENNVILLEMI49408ALLEGAN50840MANLIUS030704307.04005406.657326005C2025-12-18XAREA OF MINIMAL FLOOD HAZARD195.7727201.7297198.22281.3356PERSON2026.2
07-008-031-00260052178 70TH STFENNVILLEMI49408HAMILTON FAMILY TRUST16328 HALLAUER RDOBERLINOH44074ALLEGAN31360GANGES030902309.02006556.261426005C2025-12-18XAREA OF MINIMAL FLOOD HAZARD176.5096195.1677188.98621.6197TRUST2026.2
07-012-012-00260056013 122ND AVEFENNVILLEMI49408FREYMARK NEICE K TRUST20 TUTTLE AVECLARENDON HILLSIL60514ALLEGAN31360GANGES030902309.02001090.950826005C2025-12-18XAREA OF MINIMAL FLOOD HAZARD193.6486199.5117195.24210.2695TRUST2026.2
11-009-023-00260056665 AUDUBON RDHOLLANDMI49423FULLER MARK A III & CYNTHIA G1015 DINSMORE RDWINNETKAIL60093ALLEGAN45180LAKETOWN0302003027445.400226005C2025-12-18XAREA OF MINIMAL FLOOD HAZARD188.4503203.1091197.19491.8392PERSON2026.2
20-027-024-0026005127TH AVE V/LFENNVILLEMI49408BELL LARRY D & STASZSOW KALEO1818 W FARRAGUT AVECHICAGOIL60640ALLEGAN71720SAUGATUCK030802308.020039719.081426005C2025-12-18XAREA OF MINIMAL FLOOD HAZARD200.6523203.1468201.89159.8132PERSON2026.2
01-010-005-0226005 120TH AVE ALLEGANMI49010CARNS TROY3077 EAST BASELINE RDGOBLESMI49055ALLEGAN01280ALLEGAN031102311.0200173126.730326005C2025-12-18XAREA OF MINIMAL FLOOD HAZARD225.4853257.3149234.542142.7730PERSON2026.2
55-190-050-0026005353 PRINCE STPLAINWELLMI49080GURITZ PAUL & JODY LIVING TRUST353 PRINCE STPLAINWELLMI49080ALLEGAN64740PLAINWELL0320003201186.065026005C2025-12-18XAREA OF MINIMAL FLOOD HAZARD222.1979223.0615222.71810.2930TRUST2026.2
22-034-018-10260054105 112TH AVEALLEGANMI49010GERMAIN KELLY J4105 112TH AVEALLEGANMI49010ALLEGAN81580VALLEY030702307.02008078.986126005C2025-12-18XAREA OF MINIMAL FLOOD HAZARD210.8061213.8858211.58421.9961PERSON2026.2
24-245-019-002600539 BROWNING DRSHELBYVILLEMI49344FLANNERY RYAN & JENNA39 BROWNING DRSHELBYVILLEMI49344ALLEGAN84900WAYLAND030501305.01003647.385426005C2025-12-18XAREA OF MINIMAL FLOOD HAZARD229.7924232.8522230.85230.9010PERSON2026.2
12-355-013-0026005 MILARAWAY DOUGLAS5583 LARAWAY DRPULLMANMI49450ALLEGAN46600LEE031001310.0100527.717526005C2025-12-18XAREA OF MINIMAL FLOOD HAZARD207.9262210.6622208.50450.1303PERSON2026.2
11-320-COMMON26005 MI ALLEGAN45180LAKETOWN030200302102.573726005C2025-12-18XAREA OF MINIMAL FLOOD HAZARD178.1630180.2851179.06950.0253GOVT LOCALOPENLAKETOWN TOWNSHIP PARKLOCAL PARK2026.2
21-WATER26005 MI ALLEGAN80620TROWBRIDGE031102311.0200143160.318526005C2025-12-18A196.6881204.6333200.129535.3706GOVT STATERESTRICTEDVALLEGAN STATE GAME AREASTATE CONSERVATION AREA2026.2
08-415-016-0026005496 E STONERIDGE DR MISTAMM CAROL LYNN REV LVG TRUST &496 STONERIDGE DRPLAINWELLMI49080ALLEGAN35720GUN PLAIN0320003201913.276626005C2025-12-18XAREA OF MINIMAL FLOOD HAZARD221.3467222.5793221.93170.4726TRUST2026.2
12-383-016-0026005 MILEE TOWNSHIPPO BOX 427PULLMANMI49450ALLEGAN46600LEE031001310.0100277.804126005C2025-12-18XAREA OF MINIMAL FLOOD HAZARD210.5670217.3985213.62700.0686PERSON2026.2
02-780-006-0026005 WINDCLIFF DR MISPIECH FAMILY TRUST8685 W H AVEKALAMAZOOMI49009ALLEGAN13700CASCO030901309.01001542.874926005C2025-12-18XAREA OF MINIMAL FLOOD HAZARD203.8416205.3839204.45500.3812TRUST2026.2
59-GAP26005 MI ALLEGAN22740DOUGLAS030801308.010040.331826005C2025-12-18XAREA OF MINIMAL FLOOD HAZARD181.5898186.4389184.04300.0099PRIVATERESTRICTEDWEST SHORE GOLF CLUBPRIVATE PARK2026.2
53-02-03-300-02726005 MI ALLEGAN38640HOLLAND032401324.0100114411.991226139C2025-12-18XAREA OF MINIMAL FLOOD HAZARD203.6379212.7482207.377128.2671LG ENERGY SOLUTION MICHIGAN, INCMANUFACTURER2026.2
44-150-ROW26005 MI ALLEGAN39200HOPKINS03060030610451.496526005C2025-12-18X0.2 PCT ANNUAL CHANCE FLOOD HAZ…212.7556215.4481214.17582.5820UNITED BANK OF MICHIGANFINANCIAL_SERVICE2026.2
05-280-ROW26005 MI ALLEGAN22680DORR030404304.040023893.899126005C2025-12-18XAREA OF MINIMAL FLOOD HAZARD210.7592213.5220212.04225.9031DORR TOWNSHIP CLERKGOVERNMENT_OFFICE2026.2