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 = '21' AND countyfp = '151'
39,099 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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| R003-0003-0001-A | 21 | 151 | KY | MADISON | 92912 | RICHMOND | 010903 | 109.0300 | 1596.7426 | 21151C | 2025-12-23 | X | AREA OF MINIMAL FLOOD HAZARD | -9999 | 292.6246 | 293.9942 | 293.3864 | B-3 | 0.3945 | 7225 | HOKKAIDO RAMEN AND SUSHI HOUSE | RESTAURANT | 2026.2 | 02-RICHMOND ANNEX | |||||||||||||||||||||||||||||||||||||||||||||||
| B001-0001-0029-B | 21 | 151 | KY | MADISON | 90224 | BEREA | 011201 | 112.0100 | 9154.4263 | 21151C | 2025-12-23 | X | AREA OF MINIMAL FLOOD HAZARD | -9999 | 294.4703 | 302.0720 | 297.1036 | B-4 | 2.2618 | 7225 | DR.KAIRA | RESTAURANT | 2026.2 | 03-BEREA ANNEX | |||||||||||||||||||||||||||||||||||||||||||||||
| 0060-0000-0057-1 | 21 | 151 | KY | MADISON | 90224 | BEREA | 011201 | 112.0100 | 3177.7703 | 21151C | 2025-12-23 | X | AREA OF MINIMAL FLOOD HAZARD | -9999 | 292.3424 | 293.3818 | 292.9733 | B-2 | 0.7851 | CHIROPRACTIC HEALTH SOLUTIONS | COMPLEMENTARY_AND_ALTERNATIVE_M… | 2026.2 | 03-BEREA ANNEX | ||||||||||||||||||||||||||||||||||||||||||||||||
| 0059-0000-0026-D | 21 | 151 | KY | MADISON | 90224 | BEREA | 011202 | 112.0200 | 22887.4223 | 21151C | 2025-12-23 | X | AREA OF MINIMAL FLOOD HAZARD | -9999 | 298.4606 | 301.0120 | 299.7293 | I-2 | 5.6550 | L & C TRUCKING | B2B_TRANSPORTATION_AND_STORAGE_… | 2026.2 | 05-CITY OF BEREA | ||||||||||||||||||||||||||||||||||||||||||||||||
| R002-0012-0001 | 21 | 151 | KY | MADISON | 92912 | RICHMOND | 010903 | 109.0300 | 3650.1049 | 21151C | 2025-12-23 | X | AREA OF MINIMAL FLOOD HAZARD | -9999 | 293.5661 | 298.2685 | 296.1222 | B-3 | 0.9019 | CIELITO LINDO TACO TRUCK | FOOD_TRUCK_STAND | 2026.2 | 02-RICHMOND ANNEX | ||||||||||||||||||||||||||||||||||||||||||||||||
| 0007-0000-0002 | 21 | 151 | KY | MADISON | 90856 | COTTONBURG-VALLEY VIEW | 010801 | 108.0100 | 270353.4002 | 21151C | 2025-12-23 | X | AREA OF MINIMAL FLOOD HAZARD | -9999 | 193.9487 | 281.0514 | 220.8376 | R-7 | 66.8013 | K.M.W KENNY'S CARROSSERIE | AUTOMOTIVE_SERVICE | 2026.2 | 01-COUNTY | ||||||||||||||||||||||||||||||||||||||||||||||||
| 0030-0000-0027-B | 21 | 151 | KY | MADISON | 91940 | KIRKSVILLE | 010802 | 108.0200 | 61527.3988 | 21151C | 2025-12-23 | X | AREA OF MINIMAL FLOOD HAZARD | -9999 | 267.8127 | 296.3639 | 283.7092 | R-7 | 15.2027 | LONG AUCTION COMPANY | SPECIALTY_STORE | 2026.2 | 01-COUNTY | ||||||||||||||||||||||||||||||||||||||||||||||||
| R008-0008-0002 | 21 | 151 | KY | MADISON | 92912 | RICHMOND | 010400 | 104 | 326.1348 | 21151C | 2025-12-23 | X | AREA OF MINIMAL FLOOD HAZARD | -9999 | 290.1233 | 293.2724 | 291.6548 | B-2 | 0.0805 | 7225 | EL PAISA | RESTAURANT | 2026.2 | 02-RICHMOND ANNEX | |||||||||||||||||||||||||||||||||||||||||||||||
| 0086-0000-0009 | 21 | 151 | KY | MADISON | 90224 | BEREA | 011101 | 111.0100 | 5667.0056 | 21151C | 2025-12-23 | X | AREA OF MINIMAL FLOOD HAZARD | -9999 | 316.9416 | 321.1081 | 318.8973 | UC-1 | 1.4003 | NEW LIBERTY BAPTIST CHURCH | CHRISTIAN_PLACE_OF_WORSHIP | 2026.2 | 01-COUNTY | ||||||||||||||||||||||||||||||||||||||||||||||||
| 0023-0000-0024 | 21 | 151 | KY | MADISON | 91940 | KIRKSVILLE | 010801 | 108.0100 | 3380.4880 | 21151C | 2025-12-23 | X | AREA OF MINIMAL FLOOD HAZARD | -9999 | 304.5331 | 307.5597 | 306.4665 | C-7 | 0.8352 | KIRKSVILLE CHRISTIAN CHURCH | CHRISTIAN_PLACE_OF_WORSHIP | 2026.2 | 01-COUNTY | ||||||||||||||||||||||||||||||||||||||||||||||||
| B009-0004-0006 | 21 | 151 | KY | MADISON | 90224 | BEREA | 011201 | 112.0100 | 2036.2867 | 21151C | 2025-12-23 | X | AREA OF MINIMAL FLOOD HAZARD | -9999 | 288.9939 | 289.9870 | 289.6361 | B-2 | 0.5031 | THE TWINS CLOSET | FASHION_AND_APPAREL_STORE | 2026.2 | 03-BEREA ANNEX | ||||||||||||||||||||||||||||||||||||||||||||||||
| 0027-0001-0012 | 21 | 151 | KY | MADISON | 90290 | BOONESBOROUGH-WHITE HALL | 010103 | 101.0300 | 3753.7468 | 21151C | 2025-12-23 | X | AREA OF MINIMAL FLOOD HAZARD | -9999 | 291.9486 | 296.4041 | 294.2285 | UC-7 | 0.9274 | 1/2 FAST CUSTOMS LLC | AUTOMOTIVE_SERVICE | 2026.2 | 01-COUNTY | ||||||||||||||||||||||||||||||||||||||||||||||||
| R006-0012-0004 | 21 | 151 | KY | MADISON | 92912 | RICHMOND | 010400 | 104 | 4840.2272 | 21151C | 2025-12-23 | X | AREA OF MINIMAL FLOOD HAZARD | -9999 | 279.1383 | 287.9416 | 281.1580 | B-2 | 1.1959 | UNITED STATES POST OFFICE | SHIPPING_OR_DELIVERY_SERVICE | 2026.2 | 02-RICHMOND ANNEX | ||||||||||||||||||||||||||||||||||||||||||||||||
| 0061-0000-0019 | 21 | 151 | KY | MADISON | 90224 | BEREA | 011303 | 113.0300 | 252292.5788 | 21151C | 2025-12-23 | X | AREA OF MINIMAL FLOOD HAZARD | -9999 | 289.7564 | 313.6040 | 302.7041 | INS | 62.3368 | THE SEABURY CENTER AT BEREA COL… | CAMPUS_BUILDING | 2026.2 | 03-BEREA ANNEX | ||||||||||||||||||||||||||||||||||||||||||||||||
| 0041-0001-0066 | 21 | 151 | KY | MADISON | 92912 | RICHMOND | 010701 | 107.0100 | 9990.7263 | 21151C | 2025-12-23 | X | AREA OF MINIMAL FLOOD HAZARD | -9999 | 285.1106 | 293.5733 | 289.0443 | B-3 | 2.4686 | MADISON COUNTY UTILITIES | WATER_UTILITY_PROVIDER | 2026.2 | 02-RICHMOND ANNEX | ||||||||||||||||||||||||||||||||||||||||||||||||
| 054C-0004-0033 | 21 | 151 | KY | MADISON | 92912 | RICHMOND | 010701 | 107.0100 | 19656.4371 | 21151C | 2025-12-23 | X | AREA OF MINIMAL FLOOD HAZARD | -9999 | 277.1695 | 286.3089 | 281.4665 | R-3 | 4.8569 | NORTHRIDGE APARTMENTS | HISTORIC_SITE | 2026.2 | 02-RICHMOND ANNEX | ||||||||||||||||||||||||||||||||||||||||||||||||
| 0073-0000-0018-F | 21 | 151 | KY | MADISON | 90224 | BEREA | 011101 | 111.0100 | 1247.1921 | 21151C | 2025-12-23 | X | AREA OF MINIMAL FLOOD HAZARD | -9999 | 294.0376 | 294.9957 | 294.5931 | UC-7 | 0.3081 | BOBBIE'S OLD TIME KITCHEN | CASUAL_EATERY | 2026.2 | 01-COUNTY | ||||||||||||||||||||||||||||||||||||||||||||||||
| R008-0012-0003 | 21 | 151 | KY | MADISON | 92912 | RICHMOND | 010400 | 104 | 859.1045 | 21151C | 2025-12-23 | X | AREA OF MINIMAL FLOOD HAZARD | -9999 | 281.0624 | 289.5292 | 285.7421 | B-2 | 0.2122 | GALLERY ON MAIN RICHMOND | SOCIAL_OR_COMMUNITY_SERVICE | 2026.2 | 02-RICHMOND ANNEX | ||||||||||||||||||||||||||||||||||||||||||||||||
| R006-0003-0026 | 21 | 151 | KY | MADISON | 92912 | RICHMOND | 010601 | 106.0100 | 40508.8582 | 21151C | 2025-12-23 | X | AREA OF MINIMAL FLOOD HAZARD | -9999 | 294.6583 | 306.2224 | 303.2559 | R-3 | 10.0094 | EPSILON SIGMA PI - EKU GAMMA CH… | SOCIAL_OR_COMMUNITY_SERVICE | 2026.2 | 02-RICHMOND ANNEX | ||||||||||||||||||||||||||||||||||||||||||||||||
| R009-0030-0014 | 21 | 151 | KY | MADISON | 92912 | RICHMOND | 010303 | 103.0300 | 572.2141 | 21151C | 2025-12-23 | X | AREA OF MINIMAL FLOOD HAZARD | -9999 | 288.5152 | 289.4888 | 289.1433 | B-2 | 0.1413 | BEAUTY GARDEN | PERSONAL_OR_BEAUTY_SERVICE | 2026.2 | 02-RICHMOND ANNEX | ||||||||||||||||||||||||||||||||||||||||||||||||
| 0060-0000-0048-C | 21 | 151 | KY | MADISON | 90224 | BEREA | 011202 | 112.0200 | 15388.5286 | 21151C | 2025-12-23 | X | AREA OF MINIMAL FLOOD HAZARD | -9999 | 294.4444 | 296.4028 | 295.4359 | B-2 | 3.8021 | BEREA ANIMAL HOSPITAL | ANIMAL_OR_PET_SERVICE | 2026.2 | 05-CITY OF BEREA | ||||||||||||||||||||||||||||||||||||||||||||||||
| 0060-0000-0051-A | 21 | 151 | KY | MADISON | 90224 | BEREA | 011201 | 112.0100 | 8074.2488 | 21151C | 2025-12-23 | X | AREA OF MINIMAL FLOOD HAZARD | -9999 | 292.5942 | 294.1597 | 293.5540 | B-2 | 1.9951 | MADISON COUNTY EMS STATION 2 | EMERGENCY_OR_URGENT_CARE_FACILI… | 2026.2 | 03-BEREA ANNEX | ||||||||||||||||||||||||||||||||||||||||||||||||
| R006-0012-0003 | 21 | 151 | KY | MADISON | 92912 | RICHMOND | 010400 | 104 | 3590.5898 | 21151C | 2025-12-23 | X | AREA OF MINIMAL FLOOD HAZARD | -9999 | 279.4079 | 289.0124 | 281.2392 | B-2 | 0.8872 | SUBWAY | CASUAL_EATERY | 2026.2 | 02-RICHMOND ANNEX | ||||||||||||||||||||||||||||||||||||||||||||||||
| R009-0027-0001 | 21 | 151 | KY | MADISON | 92912 | RICHMOND | 010301 | 103.0100 | 1248.0652 | 21151C | 2025-12-23 | X | AREA OF MINIMAL FLOOD HAZARD | -9999 | 282.2767 | 283.8241 | 282.5499 | I-2 | 0.3084 | RICH CITY TIRES AND AUTO CARE C… | AUTOMOTIVE_SERVICE | 2026.2 | 02-RICHMOND ANNEX | ||||||||||||||||||||||||||||||||||||||||||||||||
| R002-0010-0011-H4 | 21 | 151 | KY | MADISON | 92912 | RICHMOND | 010601 | 106.0100 | 1600.7670 | 21151C | 2025-12-23 | X | AREA OF MINIMAL FLOOD HAZARD | -9999 | 295.5438 | 299.0618 | 297.3886 | B-3 | 0.3955 | MADISON INSURANCE AGENCY | FINANCIAL_SERVICE | 2026.2 | 02-RICHMOND ANNEX |