Land Records Logo

Land Records

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

88,520 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
74-29-021-4001-00126147MIRUSHING PROPERTIES LLCST. CLAIR68620RILEY6585006585703598.3610311—225.0651238.4547232.31937160GOLF_COURSEBUSINESSBEG N 0D 21M 50S W 1060.66 FROM…6N2114ES21 T6N R14EPRIVATERESTRICTEDBELLE RIVERPRIVATE PARK2026.22024
74-16-020-1002-00026147MISCCST. CLAIR17520COLUMBUS65160065161245601.0483211—198.0186214.6829206.02217240NATURE_RESERVEBUSINESSBEG AT SE COR OF SECTION 19 TH …5N2015ES20 T5N R15EP 00249/255THE FARM2026.22024
74-10-023-4001-70026147MIFONES ARTHUR/JANEST. CLAIR10820BROCKWAY6551006551150387.3411111—229.9333242.9390234.4650PERSONW 1/2 OF SW 1/4 LYING N E OF MI…8N2314ES23 T8N R14ED 00309C2026.22024
74-13-006-3004-05126147MIFIELD SUSAN LST. CLAIR15540CHINA6410006410120701.41702—183.0688191.6117187.5012PERSONBEG S 88D 27M 28S W 318 FROM SE…4N616ES6 T4N R16ES 00073A42026.22024
74-14-937-0023-00026147MISTATE OF MICHIGANST. CLAIR16180CLAY6480006480655604.2864—175.1106176.7467175.3917GOVERNMENTLOT 66 TO 146 INC SNI BORA CHAN…GOVT STATERESTRICTEDVST. CLAIR FLATS STATE WILDLIFE …STATE CONSERVATION AREA2026.22024
74-13-008-1005-10126147MIKING ROY KING CATHERINEST. CLAIR15540CHINA6410006410110905.3545—182.0741188.7095184.4419PERSONBEG S 0D 8M 16S E 1345.66 FROM …4N816ES8 T4N R16ES 00097B2026.22024
74-16-027-4016-00026147MIWILCZYNSKI THOMAS/SUSANST. CLAIR17520COLUMBUS651600651645727.0431212—190.4615203.6198196.0525PERSONBEG S 2D W 1673.5 FROM NE COR O…P 00368F2026.22024
74-23-360-0000-99926147MIST. CLAIR40920IRA6502006502236.6976—176.4464176.8493176.7065DESCRIPTION UNDER REVIEW3N1515ES15 T3N R15EU 005062026.22024
74-16-034-1003-00026147MIWINKLE WP/WK/EMILYST. CLAIR17520COLUMBUS6516006516260569.5661—189.9599202.4655194.6186PERSONTHAT PART OF W 1/2 OF SEC 34 LY…P 004842026.22024
74-14-618-0031-00026147MIWW MICHIGAN PROPERTY VENTURES L…ST. CLAIR16180CLAY6480006480231465.9872—175.2097177.6396175.8781BUSINESSBEG ON SE LINE OF LOT 3 S 44D 1…W 003342026.22024
74-08-535-0005-00026147MIDELONG KELLYST. CLAIR89000YALE65510065511428.3834—242.6897243.2799242.8590PERSONLOT 5 MOODY SUBDY 00388I2026.22024
74-14-406-0070-00026147MIWOODS CHRISTIANST. CLAIR16180CLAY6460006460614.0371—176.6839177.0072176.7922PERSONLOT 184 SHORE ACRES PC 190 T2N …W 045922026.22024
74-14-406-0047-20026147MIGOERKE TRICIA GOERKE ALANST. CLAIR16180CLAY6460006460487.9997—176.7554177.0579176.8766PERSONLOT 187 SHORE ACRESW 045452026.22024
26147MIUNITED STATES FISH AND WILDLIF…ST. CLAIR10820BROCKWAY655100655196144.4256—238.7627244.0650241.6437GOVERNMENTGOVT FEDERALCLOSEDVFARM SERVICE AGENCY INTEREST OF…CONSERVATION EASEMENT2026.2
26147MISTATE OF MICHIGANST. CLAIR16180CLAY648000648010482.6364—175.5647175.8918175.5670GOVERNMENTGOVT STATEOPENVST. CLAIR FLATS STATE WILDLIFE …STATE CONSERVATION AREA2026.2
26147MINON-GOVERNMENTAL ORGANIZATIONST. CLAIR16760CLYDE63320063321528.3660—194.9718196.2612195.8062PERSONNGOCLOSEDVNORTH STREET STATIONPRIVATE CONSERVATION2026.2
26147MISTATE OF MICHIGANST. CLAIR43160KIMBALL634600634646046.6757—205.1284207.1045205.9367GOVERNMENTGOVT STATEOPENVPORT HURON STATE GAME AREASTATE CONSERVATION AREA2026.2
26147MISTATE OF MICHIGANST. CLAIR43160KIMBALL6346006346102561.5666—204.4048207.4390205.5405GOVERNMENTGOVT STATEOPENVPORT HURON STATE GAME AREASTATE CONSERVATION AREA2026.2
26147MIUNITED STATES FISH AND WILDLIF…ST. CLAIR10820BROCKWAY655100655133560.7678—244.1908247.8622246.6610GOVERNMENTGOVT FEDERALCLOSEDVFARM SERVICE AGENCY INTEREST OF…CONSERVATION EASEMENT2026.2
26147MISTATE OF MICHIGANST. CLAIR65840PORT HURON6360006360204.7162—186.7481187.4123187.1512GOVERNMENTGOVT STATECLOSED08-74-0046CONSERVATION EASEMENT2026.2
26147MISTATE OF MICHIGANST. CLAIR70680ST. CLAIR64200064207957.4667—183.3526186.2916184.7098GOVERNMENTGOVT STATECLOSED03-74-0020CONSERVATION EASEMENT2026.2
26147MISTATE OF MICHIGANST. CLAIR70700ST. CLAIR64060064061372.9792—194.5748195.1211194.7929GOVERNMENTGOVT STATECLOSED01-74-0168-PCONSERVATION EASEMENT2026.2
26147MISTATE OF MICHIGANST. CLAIR70700ST. CLAIR6406006406334.1138—193.9970194.7419194.2210GOVERNMENTGOVT STATECLOSED01-74-0168-PCONSERVATION EASEMENT2026.2
26147MISTATE OF MICHIGANST. CLAIR70700ST. CLAIR6406006406367.7462—194.3735194.9739194.6846GOVERNMENTGOVT STATECLOSED01-74-0168-PCONSERVATION EASEMENT2026.2
26147MISTATE OF MICHIGANST. CLAIR42740KENOCKEE652100652110123.1735—218.9955219.5082219.2028GOVERNMENTGOVT STATECLOSED03-74-0008-PCONSERVATION EASEMENT2026.2