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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1902303324 | 26 | 125 | 448 FOX HILLS DR S APT 1 | BLOOMFIELD HILLS | MI | 48304 | 538 CHASE LN | OAKLAND | 09110 | BLOOMFIELD | 150000 | 1500 | 164612.3477 | 78730 | 78730 | 78730 | 0 | 1 | 1 | 1089 | 2 | 2 | 26125C | 2025-12-18 | X | AREA OF MINIMAL FLOOD HAZARD | 276.0380 | 286.0555 | 280.4845 | 407 | 5313 | FOX HILLS APARTMENTS CONDOS | REAL_ESTATE_SERVICE | 2026.2 | CHARTER TOWNSHIP OF BLOOMFIELD | ||||||||||||||||||||||||||||||||||||
| 1516381003 | 26 | 125 | 814 TEN POINT DR | ROCHESTER HILLS | MI | 48309 | 814 TEN POINT DR | OAKLAND | 69035 | ROCHESTER HILLS | 193100 | 1931 | 847.4181 | 222550 | 222550 | 222550 | 0 | 1 | 1 | 1848 | 3 | 2 | 26125C | 2025-12-18 | X | AREA OF MINIMAL FLOOD HAZARD | 244.5285 | 246.3616 | 245.3983 | 401 | 2026.2 | CITY OF ROCHESTER HILLS | |||||||||||||||||||||||||||||||||||||||
| 0223401004 | 26 | 125 | MI | 10938 TERRACE RD | OAKLAND | 35640 | GROVELAND | 123100 | 1231 | 6037.6549 | 28060 | 28060 | 28060 | 0 | 0 | 0 | 0 | 26125C | 2025-12-18 | X | AREA OF MINIMAL FLOOD HAZARD | 318.0864 | 333.2336 | 325.6903 | 402 | PRIVATE | RESTRICTED | SOUTHERN OAKLAND GIRL SCOUTS CA… | PRIVATE RECREATION OR EDUCATION | 2026.2 | TOWNSHIP OF GROVELAND | ||||||||||||||||||||||||||||||||||||||||
| 0612176004 | 26 | 125 | MI | 11455 STALLION LN | OAKLAND | 69580 | ROSE | 125000 | 1250 | 19754.7996 | 35520 | 35520 | 35520 | 0 | 0 | 0 | 0 | 26125C | 2025-12-18 | X | AREA OF MINIMAL FLOOD HAZARD | 297.0030 | 302.5747 | 298.6571 | 402 | 2026.2 | TOWNSHIP OF ROSE | ||||||||||||||||||||||||||||||||||||||||||||
| 2336185008 | 26 | 125 | MI | 21530 WALDRON ST | OAKLAND | 27440 | FARMINGTON HILLS | 167400 | 1674 | 568.5557 | 18560 | 18560 | 18560 | 0 | 0 | 0 | 0 | 26125C | 2025-12-18 | X | AREA OF MINIMAL FLOOD HAZARD | 201.9008 | 202.7489 | 202.3606 | 402 | 2026.2 | CITY OF FARMINGTON HILLS | ||||||||||||||||||||||||||||||||||||||||||||
| 0428152002 | 26 | 125 | MI | 1667 JOHN PAUL CT | OAKLAND | 62040 | OXFORD | 121700 | 1217 | 64023.9598 | 19700 | 19700 | 19700 | 0 | 0 | 0 | 0 | 26125C | 2025-12-18 | X | AREA OF MINIMAL FLOOD HAZARD | 309.7895 | 313.5980 | 310.3711 | 402 | 2026.2 | CHARTER TOWNSHIP OF OXFORD | ||||||||||||||||||||||||||||||||||||||||||||
| 1028477007 | 26 | 125 | MI | 4800 MILL CREEK CT | OAKLAND | 59820 | OAKLAND | 190700 | 1907 | 6984.5100 | 42360 | 42360 | 42360 | 0 | 0 | 0 | 0 | 26125C | 2025-12-18 | X | AREA OF MINIMAL FLOOD HAZARD | 249.1249 | 259.3890 | 253.4861 | 402 | 2026.2 | CHARTER TOWNSHIP OF OAKLAND | ||||||||||||||||||||||||||||||||||||||||||||
| 1226105027 | 26 | 125 | MI | 10007 CRAYVIEW DR | OAKLAND | 86860 | WHITE LAKE | 130600 | 1306 | 14411.8298 | 49410 | 49410 | 49410 | 0 | 0 | 0 | 0 | 26125C | 2025-12-18 | AE | FLOODWAY | 284.7284 | 290.3789 | 286.9770 | 402 | 2026.2 | CHARTER TOWNSHIP OF WHITE LAKE | ||||||||||||||||||||||||||||||||||||||||||||
| 1820201001 | 26 | 125 | MI | 6540 LAKESHORE ST | OAKLAND | 85480 | WEST BLOOMFIELD | 156200 | 1562 | 3464.9696 | 25940 | 25940 | 25940 | 0 | 0 | 0 | 0 | 26125C | 2025-12-18 | X | AREA OF MINIMAL FLOOD HAZARD | 289.9812 | 298.9982 | 293.5979 | 402 | 2026.2 | CHARTER TOWNSHIP OF WEST BLOOMF… | ||||||||||||||||||||||||||||||||||||||||||||
| 0632427014 | 26 | 125 | MI | 6807 BIG TRAIL RD | OAKLAND | 69580 | ROSE | 125600 | 1256 | 10186.6586 | 30100 | 30100 | 30100 | 0 | 0 | 0 | 0 | 26125C | 2025-12-18 | X | AREA OF MINIMAL FLOOD HAZARD | 320.5343 | 326.0544 | 322.1163 | 402 | 2026.2 | TOWNSHIP OF ROSE | ||||||||||||||||||||||||||||||||||||||||||||
| 0330104008 | 26 | 125 | MI | 1140 RIVER FOREST DR | OAKLAND | 10040 | BRANDON | 122700 | 1227 | 1138.5211 | 3750 | 3750 | 3750 | 0 | 0 | 0 | 0 | 26125C | 2025-12-18 | X | AREA OF MINIMAL FLOOD HAZARD | 295.6438 | 298.2690 | 296.6843 | 402 | 2026.2 | CHARTER TOWNSHIP OF BRANDON | ||||||||||||||||||||||||||||||||||||||||||||
| 0332200022 | 26 | 125 | MI | 3821 CREST LAKE DR | OAKLAND | 10040 | BRANDON | 122700 | 1227 | 16111.1866 | 34250 | 34250 | 34250 | 0 | 0 | 0 | 0 | 26125C | 2025-12-18 | X | AREA OF MINIMAL FLOOD HAZARD | 304.4877 | 319.5944 | 311.9317 | 402 | 2026.2 | CHARTER TOWNSHIP OF BRANDON | ||||||||||||||||||||||||||||||||||||||||||||
| 0802476006 | 26 | 125 | MI | 9719 COLUMBIA AVE | OAKLAND | 40400 | INDEPENDENCE | 127000 | 1270 | 557.6167 | 5400 | 5400 | 5400 | 0 | 0 | 0 | 0 | 26125C | 2025-12-18 | X | AREA OF MINIMAL FLOOD HAZARD | 318.4278 | 320.4250 | 319.6467 | 402 | 2026.2 | CHARTER TOWNSHIP OF INDEPENDENCE | ||||||||||||||||||||||||||||||||||||||||||||
| 0215200002 | 26 | 125 | MI | 121 W LONG LAKE RD | OAKLAND | 35640 | GROVELAND | 123100 | 1231 | 75799.7720 | 0 | 0 | 0 | 26125C | 2025-12-18 | X | AREA OF MINIMAL FLOOD HAZARD | 298.8588 | 315.8471 | 308.7090 | 402 | PRIVATE | RESTRICTED | FRESH AIR SOCIETY CAMPGROUND | PRIVATE RECREATION OR EDUCATION | 2026.2 | TOWNSHIP OF GROVELAND | ||||||||||||||||||||||||||||||||||||||||||||
| 2436478020 | 26 | 125 | MI | 40950 WOODWARD AVE STE 300 | OAKLAND | 74900 | SOUTHFIELD | 162200 | 1622 | 23655.0542 | 4524860 | 4524860 | 4524860 | 0 | 0 | 0 | 0 | 26125C | 2025-12-18 | X | AREA OF MINIMAL FLOOD HAZARD | 204.1234 | 205.4860 | 204.7932 | 207 | 2026.2 | CITY OF SOUTHFIELD | ||||||||||||||||||||||||||||||||||||||||||||
| 0333100066 | 26 | 125 | MI | 3205 S HADLEY RD | OAKLAND | 10040 | BRANDON | 122400 | 1224 | 10171.0905 | 30580 | 30580 | 30580 | 0 | 0 | 0 | 1 | 26125C | 2025-12-18 | X | AREA OF MINIMAL FLOOD HAZARD | 322.2081 | 326.1848 | 324.5437 | 402 | 2026.2 | CHARTER TOWNSHIP OF BRANDON | ||||||||||||||||||||||||||||||||||||||||||||
| 1532228109 | 26 | 125 | MI | 13751 VICTORIA ST | OAKLAND | 69035 | ROCHESTER HILLS | 194400 | 1944 | 1016.8647 | 11500 | 11500 | 11500 | 0 | 0 | 0 | 0 | 26125C | 2025-12-18 | X | AREA OF MINIMAL FLOOD HAZARD | 245.2943 | 245.8669 | 245.5838 | 402 | 2026.2 | CITY OF ROCHESTER HILLS | ||||||||||||||||||||||||||||||||||||||||||||
| 1116200006 | 26 | 125 | MI | 1617 E MOORE RD | OAKLAND | 38080 | HIGHLAND | 131800 | 1318 | 83724.4435 | 90150 | 90150 | 90150 | 0 | 0 | 0 | 0 | 26125C | 2025-12-18 | X | AREA OF MINIMAL FLOOD HAZARD | 325.3068 | 338.7722 | 333.8732 | 402 | 2026.2 | CHARTER TOWNSHIP OF HIGHLAND | ||||||||||||||||||||||||||||||||||||||||||||
| 0215200003 | 26 | 125 | MI | 121 W LONG LAKE RD | OAKLAND | 35640 | GROVELAND | 123100 | 1231 | 88800.6459 | 0 | 0 | 0 | 26125C | 2025-12-18 | X | AREA OF MINIMAL FLOOD HAZARD | 290.2976 | 314.7075 | 299.0047 | 402 | PRIVATE | RESTRICTED | FRESH AIR SOCIETY CAMPGROUND | PRIVATE RECREATION OR EDUCATION | 2026.2 | TOWNSHIP OF GROVELAND | ||||||||||||||||||||||||||||||||||||||||||||
| 0104100019 | 26 | 125 | MI | 2882 RAY RD | OAKLAND | 38720 | HOLLY | 124000 | 1240 | 33104.6627 | 47910 | 47910 | 47910 | 0 | 0 | 0 | 0 | 26125C | 2025-12-18 | X | AREA OF MINIMAL FLOOD HAZARD | 275.3261 | 279.5405 | 276.5211 | 402 | 2026.2 | TOWNSHIP OF HOLLY | ||||||||||||||||||||||||||||||||||||||||||||
| 0320301014 | 26 | 125 | MI | 4850 OAK PARK DR | OAKLAND | 10040 | BRANDON | 122700 | 1227 | 2683.1951 | 8750 | 8750 | 8750 | 0 | 0 | 0 | 0 | 26125C | 2025-12-18 | X | AREA OF MINIMAL FLOOD HAZARD | 292.7110 | 295.3987 | 293.1350 | 402 | 2026.2 | CHARTER TOWNSHIP OF BRANDON | ||||||||||||||||||||||||||||||||||||||||||||
| 0606326003 | 26 | 125 | MI | 1 ENERGY PLAZA DR | OAKLAND | 69580 | ROSE | 125000 | 1250 | 84284.3418 | 41990 | 41990 | 41990 | 0 | 0 | 0 | 0 | 26125C | 2025-12-18 | X | AREA OF MINIMAL FLOOD HAZARD | 274.1767 | 314.6924 | 282.8527 | 302 | 2026.2 | TOWNSHIP OF ROSE | ||||||||||||||||||||||||||||||||||||||||||||
| 1121351005 | 26 | 125 | MI | 2150 B FRANKLIN RD STE B | OAKLAND | 38080 | HIGHLAND | 131800 | 1318 | 2597.5343 | 23560 | 23560 | 23560 | 0 | 0 | 0 | 0 | 26125C | 2025-12-18 | X | AREA OF MINIMAL FLOOD HAZARD | 315.8681 | 316.6208 | 316.1889 | 402 | 2026.2 | CHARTER TOWNSHIP OF HIGHLAND | ||||||||||||||||||||||||||||||||||||||||||||
| 2125401181 | 26 | 125 | MI | 52277 FERNDALE DR | OAKLAND | 49820 | LYON | 138100 | 1381 | 231.2865 | 4530 | 4530 | 4530 | 0 | 0 | 0 | 0 | 26125C | 2025-12-18 | X | AREA OF MINIMAL FLOOD HAZARD | 304.6676 | 306.2129 | 305.4299 | 402 | 2026.2 | CHARTER TOWNSHIP OF LYON | ||||||||||||||||||||||||||||||||||||||||||||
| 1305103058 | 26 | 125 | MI | 4209 LAFOREST DR | OAKLAND | 84240 | WATERFORD | 144200 | 1442 | 756.7147 | 16260 | 16260 | 16260 | 0 | 0 | 0 | 0 | 26125C | 2025-12-18 | X | AREA OF MINIMAL FLOOD HAZARD | 299.2373 | 299.9823 | 299.5564 | 402 | 2026.2 | CHARTER TOWNSHIP OF WATERFORD |