Data Explorer
Query the US Nationwide Parcel Dataset
$1.75 / 1,000 records$100 minimum
34/80
Live SQL
SELECT * FROM "lr_parcel_us" WHERE statefp = '39' AND countyfp = '107'
25,270 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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 39107-0828401001 | 39 | 107 | 610 W SYCAMORE ST | OH | CITY GOVERNMENT | 610 W SYCAMORE ST COLDWATER 45… | MERCER | 10604 | BUTLER | 967700 | 9677 | 83937.2004 | 6 | 1 | 1 | — | 275.2804 | 278.8812 | 277.0696 | PERSON | 6S | 28 | 2E | S28 T6S R2E | GOVT LOCAL | RESTRICTED | COLDWATER MEMORIAL PARK | LOCAL PARK | 2026.2 | 2023 | |||||||||||||||||||||||||||||||||||||||||
| 39107-0520100003 | 39 | 107 | 3567 SCHLEUCHER RD | OH | FUSON DARRELL L & TERESA E | 3567 SCHLEUCHER RD CELINA 458… | MERCER | 36344 | HOPEWELL | 967300 | 9673 | 5573.9085 | 2 | 1 | 1 | — | 262.6945 | 263.8323 | 263.1897 | PERSON | 5S | 20 | 2E | S20 T5S R2E | 2026.2 | 2023 | |||||||||||||||||||||||||||||||||||||||||||||
| 39107-0828426008 | 39 | 107 | 501 N ELM ST | OH | BRUNSWICK ANN | 501 ELM ST COLDWATER 45828 | MERCER | 10604 | BUTLER | 967700 | 9677 | 923.2574 | 1 | 1 | 1 | — | 274.3491 | 274.9143 | 274.6534 | PERSON | 6S | 28 | 2E | S28 T6S R2E | 2026.2 | 2023 | |||||||||||||||||||||||||||||||||||||||||||||
| 39107-0828453021 | 39 | 107 | 622 W MAIN ST | OH | HOGAN MICHAEL P | 622 MAIN ST COLDWATER 45828 | MERCER | 10604 | BUTLER | 967700 | 9677 | 679.3837 | 1 | 1 | 1 | — | 277.5087 | 278.2040 | 277.9218 | PERSON | 6S | 28 | 2E | S28 T6S R2E | 2026.2 | 2023 | |||||||||||||||||||||||||||||||||||||||||||||
| 39107-0833239012 | 39 | 107 | 318 S SECOND ST | OH | ROUDEBUSH TERESA | 318 S SECOND ST COLDWATER 4582… | MERCER | 10604 | BUTLER | 967700 | 9677 | 481.5255 | 1 | 1 | 1 | — | 277.3105 | 278.6171 | 277.8763 | PERSON | 6S | 33 | 2E | S33 T6S R2E | 2026.2 | 2023 | |||||||||||||||||||||||||||||||||||||||||||||
| 39107-0835300006 | 39 | 107 | 4170 FLEETFOOT RD | OH | MCVETY MITCHELL & PUTHOFF ARIEL | 4170 FLEETFOOT RD COLDWATER 4… | MERCER | 10604 | BUTLER | 967700 | 9677 | 2454.4364 | 1 | 1 | 1 | — | 275.9119 | 277.5499 | 276.8770 | PERSON | 6S | 35 | 2E | S35 T6S R2E | 2026.2 | 2023 | |||||||||||||||||||||||||||||||||||||||||||||
| 39107-0906303006 | 39 | 107 | OH | CITY GOVERNMENT | CELINA 45822- | MERCER | 38724 | JEFFERSON | 967600 | 9676 | 1278.2590 | — | 265.7771 | 266.2995 | 266.1167 | PERSON | 6S | 6 | 3E | S6 T6S R3E | GOVT LOCAL | RESTRICTED | NORTH SHORE PARK | LOCAL PARK | 2026.2 | 2023 | |||||||||||||||||||||||||||||||||||||||||||||
| 39107-0321456001 | 39 | 107 | OH | BELL NORMA J | MENDON 45862 | MERCER | 78442 | UNION | 967200 | 9672 | 813.0931 | 1 | 1 | 1 | — | 250.0005 | 250.8708 | 250.5356 | PERSON | 4S | 21 | 3E | S21 T4S R3E | 2026.2 | 2023 | ||||||||||||||||||||||||||||||||||||||||||||||
| 39107-0631277002 | 39 | 107 | OH | MIDWEST OHIO RENTALS LLC | MONTEZUMA 45866 | MERCER | 38724 | JEFFERSON | 967500 | 9675 | 966.3132 | 1 | 1 | 1 | — | 265.5664 | 266.5284 | 266.2053 | BUSINESS | 5S | 31 | 3E | S31 T5S R3E | 2026.2 | 2023 | ||||||||||||||||||||||||||||||||||||||||||||||
| 39107-0720100005 | 39 | 107 | OH | KC ENTERPRISES OF OHIO LLC | 5942 ST RTE 119 SAINT HENRY … | MERCER | 81452 | WASHINGTON | 968000 | 9680 | 2029.8485 | 1 | 1 | 1 | — | 272.3984 | 273.3646 | 272.8363 | BUSINESS | 6S | 20 | 1E | S20 T6S R1E | 2026.2 | 2023 | ||||||||||||||||||||||||||||||||||||||||||||||
| 39107-0801326007 | 39 | 107 | OH | B & R PEELS LLC | ROCKFORD 45882- | MERCER | 38724 | JEFFERSON | 967400 | 9674 | 799.9719 | 1 | 1 | 1 | — | 267.7753 | 268.3160 | 268.0378 | BUSINESS | 6S | 1 | 2E | S1 T6S R2E | 2026.2 | 2023 | ||||||||||||||||||||||||||||||||||||||||||||||
| 39107-1309456008 | 39 | 107 | OH | SCHUH HENRY BERNARD JR & KAREN … | FT RECOVERY 45846- | MERCER | 30058 | GIBSON | 968000 | 9680 | 918.9765 | 1 | 1 | 1 | — | 287.0080 | 288.4873 | 287.6846 | PERSON | 15N | 9 | 1E | S9 T15N R1E | 2026.2 | 2023 | ||||||||||||||||||||||||||||||||||||||||||||||
| 39107-0808200003 | 39 | 107 | OH | STONECO INC | 0 MAUMEE 43537- | MERCER | 38724 | JEFFERSON | 967300 | 9673 | 40165.4895 | 2 | — | 242.1061 | 271.0299 | 260.5942 | BUSINESS | 6S | 8 | 2E | S8 T6S R2E | 2026.2 | 2023 | ||||||||||||||||||||||||||||||||||||||||||||||||
| 39107-1017426002 | 39 | 107 | OH | STEINBRUNNER EDWARD L & JANET L | 892 ST JOE RD FORT RECOVERY 4… | MERCER | 65781 | RECOVERY | 968000 | 9680 | 6504.2152 | 2 | — | 293.2460 | 298.9797 | 296.7212 | PERSON | 7S | 17 | 1E | S17 T7S R1E | 2026.2 | 2023 | ||||||||||||||||||||||||||||||||||||||||||||||||
| 39107-0923128009 | 39 | 107 | OH | RIPLEY MARCIA N | 0 ROCKFORD 45882- | MERCER | 28350 | FRANKLIN | 967800 | 9678 | 557.3075 | — | 265.6818 | 266.0107 | 265.7980 | PERSON | 6S | 23 | 3E | S23 T6S R3E | 2026.2 | 2023 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 39107-0902127020 | 39 | 107 | 6830 ANDERSON | OH | NORTHWOOD HOMEOWNERS ASSOCIATIO… | 120 NORTHWOOD DR CELINA 45822- | MERCER | 38724 | JEFFERSON | 967600 | 9676 | 7873.4512 | — | 265.6939 | 272.5953 | 269.1389 | NONPROFIT | 6S | 2 | 3E | S2 T6S R3E | 2026.2 | 2023 | ||||||||||||||||||||||||||||||||||||||||||||||||
| 39107-1103400001 | 39 | 107 | 4378 PHILOTHEA RD | OH | KMC2 LLC | 4378 PHILOTHEA RD COLDWATER 4… | MERCER | 10604 | BUTLER | 967700 | 9677 | 159701.9832 | — | 274.5376 | 283.9595 | 279.7933 | BUSINESS | 7S | 3 | 2E | S3 T7S R2E | 2026.2 | 2023 | ||||||||||||||||||||||||||||||||||||||||||||||||
| 39107-0920333002 | 39 | 107 | 5240 GROVE RD | OH | HOLLIMAN DAWN R | 5240 GROVE DR CELINA 45822- | MERCER | 28350 | FRANKLIN | 967800 | 9678 | 696.8385 | — | 265.7925 | 266.5987 | 266.0322 | PERSON | 6S | 20 | 3E | S20 T6S R3E | 2026.2 | 2023 | ||||||||||||||||||||||||||||||||||||||||||||||||
| 39107-0904252002 | 39 | 107 | 105 GREEN AVE | OH | WILCUTT DUSTY T & JUDITH A | 1472 DELYNN DR CENTERVILLE 45… | MERCER | 38724 | JEFFERSON | 967600 | 9676 | 573.2429 | — | 270.9338 | 272.1722 | 271.4855 | PERSON | 6S | 4 | 3E | S4 T6S R3E | 2026.2 | 2023 | ||||||||||||||||||||||||||||||||||||||||||||||||
| 39107-0110400002 | 39 | 107 | 1960 LEE RD | OH | HARNER ANGELA M | 1960 LEE RD ROCKFORD 45882- | MERCER | 06586 | BLACK CREEK | 967200 | 9672 | 4194.8181 | — | 246.5190 | 248.3052 | 247.7300 | PERSON | 4S | 10 | 1E | S10 T4S R1E | 2026.2 | 2023 | ||||||||||||||||||||||||||||||||||||||||||||||||
| 39107-0512100003 | 39 | 107 | 5647 FAST RD | OH | REGEDANZ JOSH A | 5647 FAST RD CELINA 45822 | MERCER | 36344 | HOPEWELL | 967300 | 9673 | 2191.0850 | — | 257.1616 | 257.9664 | 257.5376 | PERSON | 5S | 12 | 2E | S12 T5S R2E | 2026.2 | 2023 | ||||||||||||||||||||||||||||||||||||||||||||||||
| 39107-0904327012 | 39 | 107 | 125 SANDY BEACH WAY | OH | CRAFT EDWARD C | 709 KYLE DR TIPP CITY 45371- | MERCER | 38724 | JEFFERSON | 967600 | 9676 | 594.5461 | — | 269.6540 | 270.0205 | 269.8189 | PERSON | 6S | 4 | 3E | S4 T6S R3E | 2026.2 | 2023 | ||||||||||||||||||||||||||||||||||||||||||||||||
| 39107-1020252028 | 39 | 107 | OH | WOOD JUDITH | FORT RECOVERY 45846 | MERCER | 65781 | RECOVERY | 968000 | 9680 | 1362.5183 | — | 281.0190 | 287.0832 | 285.0736 | PERSON | 7S | 20 | 1E | S20 T7S R1E | 2026.2 | 2023 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 39107-0904254002 | 39 | 107 | OH | MILLHOUSE JULIE E | PIQUA 45356- | MERCER | 38724 | JEFFERSON | 967600 | 9676 | 282.0359 | — | 272.0959 | 273.0314 | 272.6390 | PERSON | 6S | 4 | 3E | S4 T6S R3E | 2026.2 | 2023 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 39107-1426100004 | 39 | 107 | OH | DIPPOLD ELIZABETH L | 0 ST HENRY 45883- | MERCER | 31430 | GRANVILLE | 967900 | 9679 | 183786.9815 | — | 289.5935 | 291.4594 | 290.2405 | PERSON | 15N | 26 | 2E | S26 T15N R2E | 2026.2 | 2023 |