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 = '109'
52,877 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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| N44-250348 | 39 | 109 | MOTE PARK | PIQUA | OH | 45356 | CITY OF PIQUA | Miami | 62848 | Piqua | 315300 | 3153 | 6122.9403 | 0 | 39109C | 2025-12-11 | X | AREA OF MINIMAL FLOOD HAZARD | 264.6058 | 274.1921 | 268.6739 | 1.5000 | GOVERNMENT | 7212 | GOVT LOCAL | OPEN | MOTE PARK | LOCAL PARK | MIAMI | |||||||||||||||||||||||||||||||||||||||||
| G15-023026 | 39 | 109 | 4900 SOUTH COUNTY ROAD 5A | TIPP CITY | OH | 45371 | CUY INVESTMENTS LLC | Miami | 51492 | Monroe | 350102 | 3501.0200 | 17562.3628 | 4 | 39109C | 2025-12-11 | X | AREA OF MINIMAL FLOOD HAZARD | 280.1108 | 283.0582 | 281.4337 | 4.3160 | BUSINESS | 54194 | TIPP CITY VETERINARY HOSPITAL | ANIMAL_OR_PET_SERVICE | MIAMI | |||||||||||||||||||||||||||||||||||||||||||
| G15-022470 | 39 | 109 | 811 JUNIPER CT | TIPP CITY | OH | 45371 | GRIESMEYER MICHAEL G | Miami | 51492 | Monroe | 355001 | 3550.0100 | 3155.4351 | 1 | 39109C | 2025-12-11 | X | AREA OF MINIMAL FLOOD HAZARD | 264.5649 | 269.2159 | 266.9251 | 0.7800 | PERSON | 52394 | WEALTH MANAGEMENT GROUP | FINANCIAL_SERVICE | MIAMI | |||||||||||||||||||||||||||||||||||||||||||
| G15-023880 | 39 | 109 | TIPP CITY POST OFFICE | TIPP CITY | OH | 45371 | LEE PAUL D | Miami | 51492 | Monroe | 355002 | 3550.0200 | 2760.5316 | 2 | 39109C | 2025-12-11 | X | AREA OF MINIMAL FLOOD HAZARD | 251.9351 | 253.7944 | 252.9953 | 0.6820 | PERSON | 3335 | MAJESTIC METAL JOINING | MANUFACTURER | MIAMI | |||||||||||||||||||||||||||||||||||||||||||
| I26-006368 | 39 | 109 | BRETHREN IN CHRIST CHURCH | PLEASANT HILL | OH | 45359 | STUMPFF RONALD E JR | Miami | 55594 | Newton | 330100 | 3301 | 949.2046 | 0 | 39109C | 2025-12-11 | X | AREA OF MINIMAL FLOOD HAZARD | 276.5591 | 278.4372 | 277.7476 | 0.2349 | PERSON | 6233 | PIPERS PINE SUBDIVISION | SENIOR_LIVING_FACILITY | MIAMI | |||||||||||||||||||||||||||||||||||||||||||
| L32-024010 | 39 | 109 | 4080 W MONROE CONCORD RD | TROY | OH | 45373 | HAHN TROY J TOD | Miami | 78456 | Union | 340100 | 3401 | 20193.2925 | 3 | 39109C | 2025-12-11 | X | AREA OF MINIMAL FLOOD HAZARD | 284.6141 | 286.2624 | 285.1981 | 5 | PERSON | 111 | HAHN CHRISTMAS TREE FARM | FARM | MIAMI | |||||||||||||||||||||||||||||||||||||||||||
| D08-103620 | 39 | 109 | WRIGHT-PATT CREDIT UNION | TROY | OH | 45373 | MERIGAN LTD | Miami | 18224 | Concord | 365002 | 3650.0200 | 5951.1950 | 1 | 39109C | 2025-12-11 | X | AREA OF MINIMAL FLOOD HAZARD | 282.7219 | 284.2759 | 283.5467 | 1.4710 | BUSINESS | 33636 | TROJAN AUTO CARE | AUTOMOTIVE_SERVICE | MIAMI | |||||||||||||||||||||||||||||||||||||||||||
| D08-005650 | 39 | 109 | RESIGNATION RECORDS | TROY | OH | 45373 | PALEJE WEST HOLDINGS LLC | Miami | 18224 | Concord | 365301 | 3653.0100 | 332.3888 | 1 | 39109C | 2025-12-11 | X | AREA WITH REDUCED FLOOD RISK DU… | 251.2385 | 251.9465 | 251.7180 | 0.0800 | BUSINESS | 42394 | MIAMI | |||||||||||||||||||||||||||||||||||||||||||||
| D08-004660 | 39 | 109 | RESIGNATION RECORDS | TROY | OH | 45373 | WIND HORSE LLC | Miami | 18224 | Concord | 365301 | 3653.0100 | 511.7003 | 2 | 39109C | 2025-12-11 | X | AREA WITH REDUCED FLOOD RISK DU… | 250.8429 | 251.3782 | 251.0749 | 0.1300 | BUSINESS | 3111 | MIAMI | |||||||||||||||||||||||||||||||||||||||||||||
| N44-077576 | 39 | 109 | 1281 CAMARO CT | PIQUA | OH | 45356 | FRY INVESTMENTS LTD | Miami | 62848 | Piqua | 300100 | 3001 | 1420.1021 | 2 | 39109C | 2025-12-11 | X | AREA OF MINIMAL FLOOD HAZARD | 271.8099 | 274.7032 | 272.8175 | 0 | BUSINESS | 52591 | MIAMI | |||||||||||||||||||||||||||||||||||||||||||||
| L32-067362 | 39 | 109 | 5364 IDDINGS RD | WEST MILTON | OH | 45383 | TRIPLE D AND B LLC | Miami | 78456 | Union | 340100 | 3401 | 8069.5897 | 4 | 39109C | 2025-12-11 | X | AREA OF MINIMAL FLOOD HAZARD | 283.2858 | 287.1907 | 285.1778 | 2 | BUSINESS | 3369 | MIAMI | |||||||||||||||||||||||||||||||||||||||||||||
| C06-032820 | 39 | 109 | 78 S I75 | TROY | OH | 45373 | PIQUA MATERIALS INC | Miami | 18224 | Concord | 365002 | 3650.0200 | 62194.6571 | 0 | 39109C | 2025-12-11 | X | AREA OF MINIMAL FLOOD HAZARD | 258.4267 | 268.7593 | 264.1610 | 15.3960 | BUSINESS | 3212 | MIAMI | |||||||||||||||||||||||||||||||||||||||||||||
| A01-250107 | 39 | 109 | HUBER HEIGHTS CONGREGATION OF J… | BETHEL | OH | 45371 | HUBER HTS CONGREGATION | Miami | 06110 | Bethel | 380100 | 3801 | 2491.9574 | 0 | 39109C | 2025-12-11 | X | AREA OF MINIMAL FLOOD HAZARD | 297.8998 | 299.1351 | 298.3221 | 0.6160 | NONPROFIT | 4885 | MIAMI | |||||||||||||||||||||||||||||||||||||||||||||
| H19-409002 | 39 | 109 | KOBLE PLUMBING LLC | COVINGTON | OH | 45318 | CSL OHIO SYSTEM LLC | Miami | 54138 | Newberry | 325000 | 3250 | 4250.5476 | 1 | 39109C | 2025-12-11 | X | AREA OF MINIMAL FLOOD HAZARD | 282.7540 | 283.4357 | 283.0941 | 1.0560 | BUSINESS | 3351 | MIAMI | |||||||||||||||||||||||||||||||||||||||||||||
| D08-106072 | 39 | 109 | WISHY WASHY CAR WASH | TROY | OH | 45373 | HARLOW BUILDERS INC | Miami | 18224 | Concord | 365301 | 3653.0100 | 639.1874 | 1 | 39109C | 2025-12-11 | X | AREA OF MINIMAL FLOOD HAZARD | 266.7083 | 267.4490 | 267.1439 | 0.1578 | BUSINESS | 2361 | MIAMI | |||||||||||||||||||||||||||||||||||||||||||||
| G12-082289 | 39 | 109 | EVANSTON ESTATES | MONROE | OH | 45371 | LYONS BRIAN K | Miami | 51492 | Monroe | 350101 | 3501.0100 | 1490.6280 | 1 | 39109C | 2025-12-11 | X | AREA OF MINIMAL FLOOD HAZARD | 288.4300 | 289.0385 | 288.7444 | 0.3680 | PERSON | MIAMI | ||||||||||||||||||||||||||||||||||||||||||||||
| G15-022962 | 39 | 109 | 826 ELDERWOOD AVE | TIPP CITY | OH | 45371 | OTTO RAY J | Miami | 51492 | Monroe | 355001 | 3550.0100 | 1207.6397 | 1 | 39109C | 2025-12-11 | X | AREA OF MINIMAL FLOOD HAZARD | 271.0857 | 272.4415 | 272.0189 | 0.2980 | PERSON | MIAMI | ||||||||||||||||||||||||||||||||||||||||||||||
| N44-026460 | 39 | 109 | FIRST CHURCH OF GOD | PIQUA | OH | 45356 | MCGRAW KEVIN A | Miami | 62848 | Piqua | 315100 | 3151 | 541.7678 | 1 | 39109C | 2025-12-11 | X | AREA OF MINIMAL FLOOD HAZARD | 267.6725 | 268.0893 | 267.9677 | 0.1400 | PERSON | MIAMI | ||||||||||||||||||||||||||||||||||||||||||||||
| C06-083536 | 39 | 109 | 1898 THORNWOOD CT | TROY | OH | 45373 | HUELS JENNA E | Miami | 18224 | Concord | 365302 | 3653.0200 | 2560.2786 | 1 | 39109C | 2025-12-11 | X | AREA OF MINIMAL FLOOD HAZARD | 269.1305 | 270.2930 | 269.9113 | 0.6330 | PERSON | MIAMI | ||||||||||||||||||||||||||||||||||||||||||||||
| J27-055294 | 39 | 109 | 1590 WEDGEWOOD DR | PIQUA | OH | 45356 | HEMM JEFFREY C | Miami | 74097 | Springcreek | 300100 | 3001 | 2396.6353 | 1 | 39109C | 2025-12-11 | X | AREA OF MINIMAL FLOOD HAZARD | 283.8867 | 287.4282 | 285.4197 | 0.5910 | PERSON | MIAMI | ||||||||||||||||||||||||||||||||||||||||||||||
| I20-058000 | 39 | 109 | 6868 STATE RT 718 | PLEASANT HILL | OH | 45359 | WRIGHT KYLE | Miami | 55594 | Newton | 330100 | 3301 | 5973.7710 | 2 | 39109C | 2025-12-11 | X | AREA OF MINIMAL FLOOD HAZARD | 285.3449 | 286.5053 | 285.9015 | 1.4700 | PERSON | MIAMI | ||||||||||||||||||||||||||||||||||||||||||||||
| K30-032850 | 39 | 109 | 4239 PIQUA TROY RD | TROY | OH | 45373 | ROWLEY JAMIE P | Miami | 74475 | Staunton | 365101 | 3651.0100 | 56419.0898 | 2 | 39109C | 2025-12-11 | X | AREA OF MINIMAL FLOOD HAZARD | 265.4402 | 272.0485 | 269.3152 | 14.1300 | PERSON | MIAMI | ||||||||||||||||||||||||||||||||||||||||||||||
| D08-031910 | 39 | 109 | BOYER PARK | TROY | OH | 45373 | DEWEY RONALD WILLIAM | Miami | 18224 | Concord | 365200 | 3652 | 695.9540 | 2 | 39109C | 2025-12-11 | X | AREA OF MINIMAL FLOOD HAZARD | 251.7751 | 252.3223 | 252.1153 | 0.1700 | PERSON | MIAMI | ||||||||||||||||||||||||||||||||||||||||||||||
| D08-012480 | 39 | 109 | MCKAIG RACE PARK | TROY | OH | 45373 | DULING ALAN C TOD | Miami | 18224 | Concord | 365301 | 3653.0100 | 757.5614 | 1 | 39109C | 2025-12-11 | X | AREA WITH REDUCED FLOOD RISK DU… | 251.5437 | 252.4553 | 252.1603 | 0.1900 | PERSON | MIAMI | ||||||||||||||||||||||||||||||||||||||||||||||
| L37-000480 | 39 | 109 | LUDLOW FALLS POST OFFICE | LUDLOW FALLS | OH | 45339 | COY DUANE E | Miami | 78456 | Union | 340100 | 3401 | 696.8395 | 1 | 39109C | 2025-12-11 | X | AREA OF MINIMAL FLOOD HAZARD | 275.8702 | 276.4921 | 276.2070 | 0.1700 | PERSON | MIAMI |