Data Explorer
Query the US Nationwide Parcel Dataset
Request Sample Download
$1.75 / 1,000 records$100 minimum
0/80
Live SQL
SELECT * FROM "parcel_layer" WHERE statefp = '39' AND countyfp = '107'
25,459 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 | taxyear | taxdistrict | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 091361000000 | 39 | 107 | BOTKINS CEMETERY | FRANKLIN | OH | 45822 | BOTKINS CEMETERY BOTKINS RD | Mercer | 28350 | Franklin | 967900 | 9679 | 2238.7613 | 0 | 39107C | 2025-12-11 | X | AREA OF MINIMAL FLOOD HAZARD | 269.6858 | 271.8892 | 271.0711 | 0.5500 | PERSON | 1122 | GOVT MULTIPLE | CLOSED | BOTKINS CEMETERY | AGRICULTURAL EASEMENT | MERCER | |||||||||||||||||||||||||||||||||||||||||
| 070287000102 | 39 | 107 | 5627 SHELLEY ROAD | DUBLIN | OH | 45882 | NOW PHYLLIS A | Mercer | 22708 | Dublin | 967200 | 9672 | 2052.0707 | 1 | 39107C | 2025-12-11 | X | AREA OF MINIMAL FLOOD HAZARD | 251.8330 | 253.1002 | 252.4668 | 0 | PERSON | 8141 | PRIVATE | RESTRICTED | DEERFIELD GOLF COURSE | PRIVATE PARK | MERCER | |||||||||||||||||||||||||||||||||||||||||
| 091263000000 | 39 | 107 | 6101 ST RTE 219 | FRANKLIN | OH | 45822 | FUSON SHERRY R LEHMAN KYLE J | Mercer | 28350 | Franklin | 967800 | 9678 | 7688.1187 | 2 | 39107C | 2025-12-11 | X | AREA OF MINIMAL FLOOD HAZARD | 271.6866 | 273.7064 | 272.4451 | 1.8800 | PERSON | 54184 | HEAVY METAL AUTO RECYCLING LLC | MEDIA_SERVICE | MERCER | |||||||||||||||||||||||||||||||||||||||||||
| 020146000302 | 39 | 107 | 4695 US RTE 127 | BUTLER | OH | 45822 | KLOSTERMAN OMER R TRUSTEE | Mercer | 10604 | Butler | 967700 | 9677 | 55231.2646 | 2 | 39107C | 2025-12-11 | X | AREA OF MINIMAL FLOOD HAZARD | 267.8980 | 273.8779 | 269.5574 | 13.4490 | TRUST | 811192 | WET WILLY'S TRUCK WASH | AUTOMOTIVE_SERVICE | MERCER | |||||||||||||||||||||||||||||||||||||||||||
| 160270000000 | 39 | 107 | SAINT PAULS CATHOLIC CHURCH | GIBSON | OH | 45846 | ST PAULS SHARPSBURG CEMETERY | Mercer | 30058 | Gibson | 968000 | 9680 | 9567.5434 | 2 | 39107C | 2025-12-11 | X | AREA OF MINIMAL FLOOD HAZARD | 312.5792 | 315.5340 | 314.5856 | 1.2350 | PERSON | 611110 | SHARPSBURG ELEMENTARY SCHOOL | ELEMENTARY_SCHOOL | MERCER | |||||||||||||||||||||||||||||||||||||||||||
| 380302000000 | 39 | 107 | 327 LOWRY ROAD | FORT RECOVERY | OH | 45846 | STEINBRUNNER DAVID H CYNTHIA M | Mercer | 65781 | Recovery | 968000 | 9680 | 6118.5323 | 1 | 39107C | 2025-12-11 | X | AREA OF MINIMAL FLOOD HAZARD | 288.1441 | 289.6296 | 289.1522 | 1.5069 | PERSON | 722410 | HOLE IN THE WALL RECREATION | BAR | MERCER | |||||||||||||||||||||||||||||||||||||||||||
| 271055000000 | 39 | 107 | 129 WEST LIVINGSTON STREET | CELINA | OH | 45822 | MERCER COUNTY COMMISSIONERS | Mercer | 38724 | Jefferson | 967400 | 9674 | 1038.5113 | 0 | 39107C | 2025-12-11 | X | AREA OF MINIMAL FLOOD HAZARD | 266.6853 | 267.3913 | 267.1247 | 0 | PERSON | 51921 | MERCER COUNTY SHERIFF | LIBRARY | MERCER | |||||||||||||||||||||||||||||||||||||||||||
| 050878000000 | 39 | 107 | 416 EAST PLUM STREET | COLDWATER | OH | 45828 | LEHMAN AMBER A | Mercer | 10604 | Butler | 967700 | 9677 | 899.9427 | 1 | 39107C | 2025-12-11 | X | AREA OF MINIMAL FLOOD HAZARD | 273.6789 | 274.4153 | 273.9867 | 0 | PERSON | 8121 | DYSERT FINANCIAL COACHING | PERSONAL_OR_BEAUTY_SERVICE | MERCER | |||||||||||||||||||||||||||||||||||||||||||
| 080120000000 | 39 | 107 | 303 SOUTH FRANKLIN STREET | ROCKFORD | OH | 45882 | KETCHAM REAL ESTATE LLC | Mercer | 22708 | Dublin | 967200 | 9672 | 1006.8165 | 0 | 39107C | 2025-12-11 | X | AREA OF MINIMAL FLOOD HAZARD | 247.4266 | 248.2596 | 247.9009 | 0 | BUSINESS | 53121 | MERCER | |||||||||||||||||||||||||||||||||||||||||||||
| 051286000000 | 39 | 107 | 604 NORTH CEDAR STREET | COLDWATER | OH | 45828 | LEE 3 LLC | Mercer | 10604 | Butler | 967700 | 9677 | 1196.0417 | 1 | 39107C | 2025-12-11 | X | AREA OF MINIMAL FLOOD HAZARD | 277.0593 | 277.7966 | 277.5853 | 0 | BUSINESS | 3169 | MERCER | |||||||||||||||||||||||||||||||||||||||||||||
| 400533000000 | 39 | 107 | 7966 GRIER ROAD | UNION | OH | 45862 | SCHWIET ACRES LLC | Mercer | 78442 | Union | 967300 | 9673 | 163200.6274 | 0 | 39107C | 2025-12-11 | X | AREA OF MINIMAL FLOOD HAZARD | 250.1830 | 254.2687 | 251.9803 | 40 | BUSINESS | 1122 | MERCER | |||||||||||||||||||||||||||||||||||||||||||||
| 090818000000 | 39 | 107 | 5445 BEHM ROAD | FRANKLIN | OH | 45822 | AQUA VIEW SITES INC | Mercer | 28350 | Franklin | 967800 | 9678 | 101696.4349 | 1 | 39107C | 2025-12-11 | AE | 872 | 264.3161 | 268.0631 | 265.9712 | 24.7600 | BUSINESS | 1125 | MERCER | |||||||||||||||||||||||||||||||||||||||||||||
| 380103000100 | 39 | 107 | 3041 WABASH ROAD | RECOVERY | OH | 45846 | OVERMAN FARMS LLC | Mercer | 65781 | Recovery | 968000 | 9680 | 20405.8740 | 1 | 39107C | 2025-12-11 | X | AREA OF MINIMAL FLOOD HAZARD | 292.7358 | 296.4171 | 294.1809 | 5.0430 | BUSINESS | 1122 | MERCER | |||||||||||||||||||||||||||||||||||||||||||||
| 060110000000 | 39 | 107 | 6909 US RTE 33 | CENTER | OH | 45822 | MKL FARMS LLC | Mercer | 12952 | Center | 967300 | 9673 | 182265.7714 | 0 | 39107C | 2025-12-11 | X | AREA OF MINIMAL FLOOD HAZARD | 251.9099 | 254.7359 | 253.4113 | 45.0260 | BUSINESS | 1112 | MERCER | |||||||||||||||||||||||||||||||||||||||||||||
| 273811000000 | 39 | 107 | 804 HIERHOLZER STREET | CELINA | OH | 45822 | GOLDSTEIN DEPARTMENT STORES INC | Mercer | 38724 | Jefferson | 967400 | 9674 | 1411.3243 | 1 | 39107C | 2025-12-11 | X | AREA OF MINIMAL FLOOD HAZARD | 266.9614 | 268.7694 | 267.7659 | 0 | BUSINESS | 4551 | MERCER | |||||||||||||||||||||||||||||||||||||||||||||
| 050225000106 | 39 | 107 | 420 FLORA LANE | COLDWATER | OH | 45828 | MTAE LLC | Mercer | 10604 | Butler | 967700 | 9677 | 566.5697 | 1 | 39107C | 2025-12-11 | X | AREA OF MINIMAL FLOOD HAZARD | 275.1005 | 275.7968 | 275.4616 | 0 | BUSINESS | 3369 | MERCER | |||||||||||||||||||||||||||||||||||||||||||||
| 080121000000 | 39 | 107 | 305 SOUTH FRANKLIN STREET | ROCKFORD | OH | 45882 | KETCHAM REAL ESTATE LLC | Mercer | 22708 | Dublin | 967200 | 9672 | 1006.5708 | 0 | 39107C | 2025-12-11 | X | AREA OF MINIMAL FLOOD HAZARD | 247.3032 | 248.2748 | 247.8274 | 0 | BUSINESS | 53121 | MERCER | |||||||||||||||||||||||||||||||||||||||||||||
| 310495000000 | 39 | 107 | 8646 ST RTE 119 | MARION | OH | 45860 | COMMUNITY 313 INC | Mercer | 47782 | Marion | 967900 | 9679 | 1704.4346 | 0 | 39107C | 2025-12-11 | X | AREA OF MINIMAL FLOOD HAZARD | 298.3361 | 299.7292 | 299.1007 | 0 | BUSINESS | 31213 | MERCER | |||||||||||||||||||||||||||||||||||||||||||||
| 310358007600 | 39 | 107 | 2197 VIRGINIA DRIVE | MARION | OH | 45860 | HEITKAMP DEVELOPERS INC | Mercer | 47782 | Marion | 967900 | 9679 | 1391.4897 | 0 | 39107C | 2025-12-11 | X | AREA OF MINIMAL FLOOD HAZARD | 295.9192 | 296.7394 | 296.4177 | 0 | BUSINESS | 3325 | MERCER | |||||||||||||||||||||||||||||||||||||||||||||
| 050148000000 | 39 | 107 | 210 WEST BUTLER STREET | COLDWATER | OH | 45828 | TREED LLC | Mercer | 10604 | Butler | 967700 | 9677 | 7846.9628 | 1 | 39107C | 2025-12-11 | X | AREA OF MINIMAL FLOOD HAZARD | 272.4879 | 273.4611 | 273.0839 | 1.9300 | BUSINESS | 1131 | MERCER | |||||||||||||||||||||||||||||||||||||||||||||
| 273120000000 | 39 | 107 | 640 CUMBERLAND DRIVE | CELINA | OH | 45822 | YORKSHIRE INC | Mercer | 38724 | Jefferson | 967500 | 9675 | 186.2935 | 0 | 39107C | 2025-12-11 | X | AREA OF MINIMAL FLOOD HAZARD | 272.0928 | 272.7086 | 272.3886 | 0 | BUSINESS | 42373 | MERCER | |||||||||||||||||||||||||||||||||||||||||||||
| 240013000000 | 39 | 107 | 4669 OREGON ROAD | HOPEWELL | OH | 45822 | GRIESHOP JOSEPH J BERTKE TRICIA… | Mercer | 36344 | Hopewell | 967300 | 9673 | 12812.1073 | 2 | 39107C | 2025-12-11 | X | AREA OF MINIMAL FLOOD HAZARD | 258.8160 | 261.1783 | 259.7790 | 3.1660 | PERSON | MERCER | ||||||||||||||||||||||||||||||||||||||||||||||
| 060564000100 | 39 | 107 | 8630 OLDTOWN ROAD | JEFFERSON | OH | 45822 | MSK PARTNERSHIP | Mercer | 12952 | Center | 967300 | 9673 | 80371.0127 | 0 | 39107C | 2025-12-11 | X | AREA OF MINIMAL FLOOD HAZARD | 266.2378 | 270.1857 | 267.7461 | 20 | PERSON | MERCER | ||||||||||||||||||||||||||||||||||||||||||||||
| 430100500000 | 39 | 107 | 5303 RAUH ROAD | WASHINGTON | OH | 45846 | MARATHON PIPE LINE | Mercer | 81452 | Washington | 968000 | 9680 | 24422.0601 | 0 | 39107C | 2025-12-11 | X | AREA OF MINIMAL FLOOD HAZARD | 271.6881 | 273.1658 | 272.3605 | 6 | PERSON | MERCER | ||||||||||||||||||||||||||||||||||||||||||||||
| 274456000000 | 39 | 107 | 908 KENSINGTON LANE | CELINA | OH | 45822 | FICKERT DONALD L TINA L | Mercer | 38724 | Jefferson | 967500 | 9675 | 694.9132 | 1 | 39107C | 2025-12-11 | X | AREA OF MINIMAL FLOOD HAZARD | 266.0227 | 267.0386 | 266.6389 | 0 | PERSON | MERCER |