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

490,544 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
190230332426125448 FOX HILLS DR S APT 1BLOOMFIELD HILLSMI48304538 CHASE LNOAKLAND09110BLOOMFIELD1500001500164612.347778730787307873001110892226125C2025-12-18XAREA OF MINIMAL FLOOD HAZARD276.0380286.0555280.48454075313FOX HILLS APARTMENTS CONDOSREAL_ESTATE_SERVICE2026.2CHARTER TOWNSHIP OF BLOOMFIELD
151638100326125814 TEN POINT DRROCHESTER HILLSMI48309814 TEN POINT DROAKLAND69035ROCHESTER HILLS1931001931847.418122255022255022255001118483226125C2025-12-18XAREA OF MINIMAL FLOOD HAZARD244.5285246.3616245.39834012026.2CITY OF ROCHESTER HILLS
022340100426125MI10938 TERRACE RDOAKLAND35640GROVELAND12310012316037.6549280602806028060000026125C2025-12-18XAREA OF MINIMAL FLOOD HAZARD318.0864333.2336325.6903402PRIVATERESTRICTEDSOUTHERN OAKLAND GIRL SCOUTS CA…PRIVATE RECREATION OR EDUCATION2026.2TOWNSHIP OF GROVELAND
061217600426125MI11455 STALLION LNOAKLAND69580ROSE125000125019754.7996355203552035520000026125C2025-12-18XAREA OF MINIMAL FLOOD HAZARD297.0030302.5747298.65714022026.2TOWNSHIP OF ROSE
233618500826125MI21530 WALDRON STOAKLAND27440FARMINGTON HILLS1674001674568.5557185601856018560000026125C2025-12-18XAREA OF MINIMAL FLOOD HAZARD201.9008202.7489202.36064022026.2CITY OF FARMINGTON HILLS
042815200226125MI1667 JOHN PAUL CTOAKLAND62040OXFORD121700121764023.9598197001970019700000026125C2025-12-18XAREA OF MINIMAL FLOOD HAZARD309.7895313.5980310.37114022026.2CHARTER TOWNSHIP OF OXFORD
102847700726125MI4800 MILL CREEK CTOAKLAND59820OAKLAND19070019076984.5100423604236042360000026125C2025-12-18XAREA OF MINIMAL FLOOD HAZARD249.1249259.3890253.48614022026.2CHARTER TOWNSHIP OF OAKLAND
122610502726125MI10007 CRAYVIEW DROAKLAND86860WHITE LAKE130600130614411.8298494104941049410000026125C2025-12-18AEFLOODWAY284.7284290.3789286.97704022026.2CHARTER TOWNSHIP OF WHITE LAKE
182020100126125MI6540 LAKESHORE STOAKLAND85480WEST BLOOMFIELD15620015623464.9696259402594025940000026125C2025-12-18XAREA OF MINIMAL FLOOD HAZARD289.9812298.9982293.59794022026.2CHARTER TOWNSHIP OF WEST BLOOMF…
063242701426125MI6807 BIG TRAIL RDOAKLAND69580ROSE125600125610186.6586301003010030100000026125C2025-12-18XAREA OF MINIMAL FLOOD HAZARD320.5343326.0544322.11634022026.2TOWNSHIP OF ROSE
033010400826125MI1140 RIVER FOREST DROAKLAND10040BRANDON12270012271138.5211375037503750000026125C2025-12-18XAREA OF MINIMAL FLOOD HAZARD295.6438298.2690296.68434022026.2CHARTER TOWNSHIP OF BRANDON
033220002226125MI3821 CREST LAKE DROAKLAND10040BRANDON122700122716111.1866342503425034250000026125C2025-12-18XAREA OF MINIMAL FLOOD HAZARD304.4877319.5944311.93174022026.2CHARTER TOWNSHIP OF BRANDON
080247600626125MI9719 COLUMBIA AVEOAKLAND40400INDEPENDENCE1270001270557.6167540054005400000026125C2025-12-18XAREA OF MINIMAL FLOOD HAZARD318.4278320.4250319.64674022026.2CHARTER TOWNSHIP OF INDEPENDENCE
021520000226125MI121 W LONG LAKE RDOAKLAND35640GROVELAND123100123175799.772000026125C2025-12-18XAREA OF MINIMAL FLOOD HAZARD298.8588315.8471308.7090402PRIVATERESTRICTEDFRESH AIR SOCIETY CAMPGROUNDPRIVATE RECREATION OR EDUCATION2026.2TOWNSHIP OF GROVELAND
243647802026125MI40950 WOODWARD AVE STE 300OAKLAND74900SOUTHFIELD162200162223655.0542452486045248604524860000026125C2025-12-18XAREA OF MINIMAL FLOOD HAZARD204.1234205.4860204.79322072026.2CITY OF SOUTHFIELD
033310006626125MI3205 S HADLEY RDOAKLAND10040BRANDON122400122410171.0905305803058030580000126125C2025-12-18XAREA OF MINIMAL FLOOD HAZARD322.2081326.1848324.54374022026.2CHARTER TOWNSHIP OF BRANDON
153222810926125MI13751 VICTORIA STOAKLAND69035ROCHESTER HILLS19440019441016.8647115001150011500000026125C2025-12-18XAREA OF MINIMAL FLOOD HAZARD245.2943245.8669245.58384022026.2CITY OF ROCHESTER HILLS
111620000626125MI1617 E MOORE RDOAKLAND38080HIGHLAND131800131883724.4435901509015090150000026125C2025-12-18XAREA OF MINIMAL FLOOD HAZARD325.3068338.7722333.87324022026.2CHARTER TOWNSHIP OF HIGHLAND
021520000326125MI121 W LONG LAKE RDOAKLAND35640GROVELAND123100123188800.645900026125C2025-12-18XAREA OF MINIMAL FLOOD HAZARD290.2976314.7075299.0047402PRIVATERESTRICTEDFRESH AIR SOCIETY CAMPGROUNDPRIVATE RECREATION OR EDUCATION2026.2TOWNSHIP OF GROVELAND
010410001926125MI2882 RAY RDOAKLAND38720HOLLY124000124033104.6627479104791047910000026125C2025-12-18XAREA OF MINIMAL FLOOD HAZARD275.3261279.5405276.52114022026.2TOWNSHIP OF HOLLY
032030101426125MI4850 OAK PARK DROAKLAND10040BRANDON12270012272683.1951875087508750000026125C2025-12-18XAREA OF MINIMAL FLOOD HAZARD292.7110295.3987293.13504022026.2CHARTER TOWNSHIP OF BRANDON
060632600326125MI1 ENERGY PLAZA DROAKLAND69580ROSE125000125084284.3418419904199041990000026125C2025-12-18XAREA OF MINIMAL FLOOD HAZARD274.1767314.6924282.85273022026.2TOWNSHIP OF ROSE
112135100526125MI2150 B FRANKLIN RD STE BOAKLAND38080HIGHLAND13180013182597.5343235602356023560000026125C2025-12-18XAREA OF MINIMAL FLOOD HAZARD315.8681316.6208316.18894022026.2CHARTER TOWNSHIP OF HIGHLAND
212540118126125MI52277 FERNDALE DROAKLAND49820LYON1381001381231.2865453045304530000026125C2025-12-18XAREA OF MINIMAL FLOOD HAZARD304.6676306.2129305.42994022026.2CHARTER TOWNSHIP OF LYON
130510305826125MI4209 LAFOREST DROAKLAND84240WATERFORD1442001442756.7147162601626016260000026125C2025-12-18XAREA OF MINIMAL FLOOD HAZARD299.2373299.9823299.55644022026.2CHARTER TOWNSHIP OF WATERFORD