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 = '149'
31,156 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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 500427254001 | 39 | 149 | 14055 SR 29 | VAN BUREN | OH | 45302 | ALBERS VERNON J | Shelby | 79464 | Van Buren | 971500 | 9715 | 46705.8954 | 0 | 39149C | 2025-12-11 | AE | FLOODWAY | 290.6321 | 293.5745 | 291.6956 | 10 | GOVERNMENT | 7212 | GOVT STATE | RESTRICTED | LAKE LORAMIE STATE PARK | STATE PARK | ||||||||||||||||||||||||||||||||||||||||||
| 350806104001 | 39 | 149 | 12548 MAPLE GROVE ROAD | MCLEAN | OH | 45865 | HOHLBEIN PAUL A LISA M | Shelby | 46172 | McLean | 971600 | 9716 | 1088.7033 | 1 | 39149C | 2025-12-11 | AE | 957 | 290.6178 | 292.4834 | 291.8778 | 0.5260 | GOVERNMENT | 7212 | GOVT STATE | RESTRICTED | LAKE LORAMIE STATE PARK | STATE PARK | ||||||||||||||||||||||||||||||||||||||||||
| 161918426034 | 39 | 149 | 1285 WINTER RIDGE DRIVE | SIDNEY | OH | 45365 | CITY OF SIDNEY | Shelby | 28434 | Franklin | 972100 | 9721 | 11324.0387 | 0 | 39149C | 2025-12-11 | X | AREA OF MINIMAL FLOOD HAZARD | 293.0674 | 300.5411 | 294.9500 | 2.7970 | GOVERNMENT | 7212 | GOVT LOCAL | OPEN | ROBERT O NEW PARK | LOCAL PARK | ||||||||||||||||||||||||||||||||||||||||||
| 011835103025 | 39 | 149 | 1951 MICHIGAN STREET | SIDNEY | OH | 45365 | EIGHT KS ENTERPRISES INC | Shelby | 16168 | Clinton | 971900 | 9719 | 5683.7827 | 2 | 39149C | 2025-12-11 | X | AREA OF MINIMAL FLOOD HAZARD | 317.1471 | 319.0718 | 318.2268 | 1.3890 | BUSINESS | 722511 | SMOK'N JO'S BBQ | RESTAURANT | ||||||||||||||||||||||||||||||||||||||||||||
| 100235200005 | 39 | 149 | 19107 REINEKE SCHIPPER ROAD | DINSMORE | OH | 45306 | SCHAUB CONSTANCE M | Shelby | 22050 | Dinsmore | 971400 | 9714 | 151239.7606 | 5 | 39149C | 2025-12-11 | X | AREA OF MINIMAL FLOOD HAZARD | 301.5982 | 306.8674 | 304.9677 | 40 | PERSON | 444 | B & D LIGHTING, LLC | HARDWARE_HOME_AND_GARDEN_STORE | ||||||||||||||||||||||||||||||||||||||||||||
| 011824330004 | 39 | 149 | 232 SANDPIPER PLACE | SIDNEY | OH | 45365 | FIRST CHURCH OF THE NAZARENE | Shelby | 16168 | Clinton | 971800 | 9718 | 35888.5562 | 3 | 39149C | 2025-12-11 | X | AREA OF MINIMAL FLOOD HAZARD | 316.9353 | 320.7125 | 318.6978 | 8.8160 | NONPROFIT | 8131 | SIDNEY FIRST CHURCH OF THE NAZA… | CHRISTIAN_PLACE_OF_WORSHIP | ||||||||||||||||||||||||||||||||||||||||||||
| 011824251002 | 39 | 149 | 2360 WAPAKONETA AVENUE | SIDNEY | OH | 45365 | KIN STAR PROPERTIES 2 LLC | Shelby | 16168 | Clinton | 972100 | 9721 | 9384.7681 | 4 | 39149C | 2025-12-11 | X | AREA OF MINIMAL FLOOD HAZARD | 319.5727 | 322.4216 | 320.5705 | 0 | BUSINESS | 712120 | CARRIAGE HILL CONDOMINIUMS | HISTORIC_SITE | ||||||||||||||||||||||||||||||||||||||||||||
| 011824328005 | 39 | 149 | 483 WEST PARKWOOD STREET | SIDNEY | OH | 45365 | D LYTE LLC | Shelby | 16168 | Clinton | 971800 | 9718 | 1530.3045 | 1 | 39149C | 2025-12-11 | X | AREA OF MINIMAL FLOOD HAZARD | 315.8627 | 317.8641 | 317.3645 | 0 | BUSINESS | 3391 | ||||||||||||||||||||||||||||||||||||||||||||||
| 011836279007 | 39 | 149 | 315 E COURT STREET | SIDNEY | OH | 45365 | NIEMI INVESTMENTS LTD | Shelby | 16168 | Clinton | 972000 | 9720 | 1419.0172 | 1 | 39149C | 2025-12-11 | AE | 285.2907 | 286.0318 | 285.6369 | 0 | BUSINESS | 3122 | YE OLD WASH HOUSE | ||||||||||||||||||||||||||||||||||||||||||||||
| 110504202002 | 39 | 149 | 105 SHERWOOD DRIVE | BOTKINS | OH | 45306 | HOLT HOMESTEAD PROPERTIES LLC | Shelby | 22050 | Dinsmore | 971500 | 9715 | 1756.7778 | 1 | 39149C | 2025-12-11 | X | AREA OF MINIMAL FLOOD HAZARD | 299.8838 | 300.5239 | 300.3005 | 0 | BUSINESS | 2361 | ||||||||||||||||||||||||||||||||||||||||||||||
| 012204306001 | 39 | 149 | 101 FOSTER AVENUE | SIDNEY | OH | 45365 | GILLESPIE BROS PROPERTIES LLC | Shelby | 16168 | Clinton | 972200 | 9722 | 779.1366 | 1 | 39149C | 2025-12-11 | X | AREA OF MINIMAL FLOOD HAZARD | 315.5620 | 316.9681 | 316.5604 | 0.2000 | BUSINESS | 5312 | ||||||||||||||||||||||||||||||||||||||||||||||
| 011825352001 | 39 | 149 | 832 GROVE STREET | SIDNEY | OH | 45365 | T B MARTIN PROPERTIES LLC | Shelby | 16168 | Clinton | 971800 | 9718 | 641.8816 | 1 | 39149C | 2025-12-11 | X | AREA OF MINIMAL FLOOD HAZARD | 317.3933 | 318.0610 | 317.6700 | 0 | BUSINESS | 5312 | ||||||||||||||||||||||||||||||||||||||||||||||
| 090528481019 | 39 | 149 | SUBWAY | ANNA | OH | 45302 | QUAKERDALE FARMS LIMITED PARTNE | Shelby | 22050 | Dinsmore | 971500 | 9715 | 11748.8082 | 0 | 39149C | 2025-12-11 | X | AREA OF MINIMAL FLOOD HAZARD | 319.9591 | 323.5783 | 322.4656 | 2.9000 | BUSINESS | 1112 | ||||||||||||||||||||||||||||||||||||||||||||||
| 311707176013 | 39 | 149 | 600 ENTERPRISE DRIVE | FORT LORAMIE | OH | 45845 | STORE MASTER FUNDING XI LLC | Shelby | 46172 | McLean | 971600 | 9716 | 7256.6127 | 0 | 39149C | 2025-12-11 | X | AREA OF MINIMAL FLOOD HAZARD | 290.8801 | 291.9815 | 291.3689 | 1.7930 | BUSINESS | 23811 | ||||||||||||||||||||||||||||||||||||||||||||||
| 582616400007 | 39 | 149 | 2180 KUTHER ROAD | WASHINGTON | OH | 45365 | BROWN CHRIS | Shelby | 81620 | Washington | 972300 | 9723 | 11951.0156 | 2 | 39149C | 2025-12-11 | X | AREA OF MINIMAL FLOOD HAZARD | 281.8715 | 301.3148 | 287.6976 | 3 | PERSON | |||||||||||||||||||||||||||||||||||||||||||||||
| 520136200006 | 39 | 149 | 19419 HARDIN WAPAKONETA ROAD | DINSMORE | OH | 45306 | KING ADAM R | Shelby | 79464 | Van Buren | 971500 | 9715 | 22906.2698 | 2 | 39149C | 2025-12-11 | X | AREA OF MINIMAL FLOOD HAZARD | 291.0879 | 296.6791 | 294.5506 | 5.8000 | PERSON | |||||||||||||||||||||||||||||||||||||||||||||||
| 340432278015 | 39 | 149 | 12804 LUTHMAN ROAD | MCLEAN | OH | 45865 | DAVIS JOE E LISA M | Shelby | 46172 | McLean | 971600 | 9716 | 450.4134 | 1 | 39149C | 2025-12-11 | X | AREA OF MINIMAL FLOOD HAZARD | 290.6487 | 293.1808 | 292.4565 | 0.1030 | PERSON | |||||||||||||||||||||||||||||||||||||||||||||||
| 011836379018 | 39 | 149 | 867 SOUTH WALNUT AVENUE | SIDNEY | OH | 45365 | SPEARMAN PROPERTIES LLC | Shelby | 16168 | Clinton | 972000 | 9720 | 282.4575 | 0 | 39149C | 2025-12-11 | X | AREA OF MINIMAL FLOOD HAZARD | 310.9169 | 311.7447 | 311.2643 | 0 | BUSINESS | 5312 | ||||||||||||||||||||||||||||||||||||||||||||||
| 011825430025 | 39 | 149 | 733 BROADWAY AVENUE | SIDNEY | OH | 45365 | GONZALES FRANKLIN A | Shelby | 16168 | Clinton | 972000 | 9720 | 903.7846 | 1 | 39149C | 2025-12-11 | X | AREA OF MINIMAL FLOOD HAZARD | 291.5829 | 293.3021 | 292.0360 | 0 | PERSON | |||||||||||||||||||||||||||||||||||||||||||||||
| 012602327002 | 39 | 149 | 1670 CUMBERLAND AVENUE | SIDNEY | OH | 45365 | DEAM NANCY L | Shelby | 16168 | Clinton | 971900 | 9719 | 705.3766 | 1 | 39149C | 2025-12-11 | X | AREA OF MINIMAL FLOOD HAZARD | 313.0705 | 315.4536 | 314.9666 | 0.1739 | PERSON | |||||||||||||||||||||||||||||||||||||||||||||||
| 022204451006 | 39 | 149 | 590 DOORLEY ROAD | CLINTON | OH | 45365 | GUSCHING GREGORY J TRUSTEE | Shelby | 16168 | Clinton | 972200 | 9722 | 6923.0098 | 1 | 39149C | 2025-12-11 | X | AREA OF MINIMAL FLOOD HAZARD | 307.3030 | 315.9549 | 312.9236 | 1.7000 | TRUST | |||||||||||||||||||||||||||||||||||||||||||||||
| 012601102005 | 39 | 149 | 901 EVERGREEN DRIVE | SIDNEY | OH | 45365 | FLANAGAN MICHAEL S | Shelby | 16168 | Clinton | 971900 | 9719 | 1086.6556 | 1 | 39149C | 2025-12-11 | X | AREA OF MINIMAL FLOOD HAZARD | 315.6036 | 316.4454 | 316.0755 | 0 | PERSON | |||||||||||||||||||||||||||||||||||||||||||||||
| 130904202003 | 39 | 149 | 12444 CR 25A | FRANKLIN | OH | 45302 | WOMBOLD JORDAN R WILT LAURA D | Shelby | 28434 | Franklin | 971700 | 9717 | 2772.2263 | 1 | 39149C | 2025-12-11 | X | AREA OF MINIMAL FLOOD HAZARD | 318.0011 | 320.2361 | 318.9104 | 0.6899 | PERSON | |||||||||||||||||||||||||||||||||||||||||||||||
| 011824478030 | 39 | 149 | 430 EAST LYNDHURST STREET | SIDNEY | OH | 45365 | KAHLE GINA M | Shelby | 16168 | Clinton | 972100 | 9721 | 1118.0748 | 1 | 39149C | 2025-12-11 | X | AREA OF MINIMAL FLOOD HAZARD | 309.9224 | 311.0357 | 310.5675 | 0 | PERSON | |||||||||||||||||||||||||||||||||||||||||||||||
| 011825406012 | 39 | 149 | 662 NORTH OHIO AVENUE | SIDNEY | OH | 45365 | SPEARMAN INVESTMENTS LLC | Shelby | 16168 | Clinton | 972000 | 9720 | 396.2076 | 1 | 39149C | 2025-12-11 | X | AREA OF MINIMAL FLOOD HAZARD | 302.0286 | 307.7404 | 306.7527 | 0 | BUSINESS | 52591 |