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 = '165'
106,194 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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 02071020430 | 39 | 165 | OH | DAY MICKEY A & ZACHARY T | FRANKLIN-TRENTON RD | WARREN | 28490 | FRANKLIN | 030101 | 301.0100 | 2455.4658 | 39165C | 2025-12-11 | X | AREA OF MINIMAL FLOOD HAZARD | 201.6303 | 202.8195 | 201.9788 | 100 | GOVERNMENT | 5 -1-7 | 5924 | 918 | GOVT LOCAL | OPEN | V | MIAMI CONSERVANCY DISTRICT | STATE CONSERVATION AREA | 2026.2 | 16 | |||||||||||||||||||||||||||||||||||||||||
| 01303010020 | 39 | 165 | OH | MONTGOMERY COUNTY PARK DI | FRANKLIN-MADISON RD | WARREN | 28490 | FRANKLIN | 030101 | 301.0100 | 170551.0084 | 39165C | 2025-12-11 | X | AREA OF MINIMAL FLOOD HAZARD | 246.7639 | 269.0712 | 263.5394 | 660 | PERSON | 5 -2-33 | 482 | 624 | GOVT LOCAL | OPEN | TWIN CREEK METROPARK | LOCAL PARK | 2026.2 | 16 | ||||||||||||||||||||||||||||||||||||||||||
| 07023010010 | 39 | 165 | OH | QUEST CHURCH INC. | 6933 HENDRICKSON RD | WARREN | 77868 | TURTLECREEK | 031602 | 316.0200 | 40297.1827 | 39165C | 2025-12-11 | X | AREA OF MINIMAL FLOOD HAZARD | 203.2399 | 209.4879 | 205.5151 | 685 | NONPROFIT | 4 -2-2 | 5284 | 642 | QUESTCHURCH | CHRISTIAN_PLACE_OF_WORSHIP | 2026.2 | 53 | ||||||||||||||||||||||||||||||||||||||||||||
| 15041510160 | 39 | 165 | OH | BUTLER WARREN RD LLC. | 7452 BUTLER-WARREN RD | WARREN | 21238 | DEERFIELD | 031904 | 319.0400 | 41803.7856 | 39165C | 2025-12-11 | X | AREA OF MINIMAL FLOOD HAZARD | 265.9909 | 273.6773 | 270.7524 | 480 | BUSINESS | 2-3-4 | 3890 | 518 | 513 TINT MASTERS | AUTOMOTIVE_SERVICE | 2026.2 | 8 | ||||||||||||||||||||||||||||||||||||||||||||
| 11053000152 | 39 | 165 | OH | CHELSEA MONROE HOLDINGS | 1000 PREMIUM OUTLETS RD | WARREN | 77868 | TURTLECREEK | 031601 | 316.0100 | 321028.1451 | 39165C | 2025-12-11 | AREA NOT INCLUDED | 203.3599 | 217.2638 | 212.6168 | 798 | BUSINESS | CIN. PREM. OUTLETS LOT: 4 | 5194 | 340 | OSHKOSH B'GOSH | FASHION_AND_APPAREL_STORE | 2026.2 | 58 | |||||||||||||||||||||||||||||||||||||||||||||
| 07033010020 | 39 | 165 | OH | MIDDLETOWN DRE LLC | 3451 S DIXIE HWY | WARREN | 28490 | FRANKLIN | 030700 | 307 | 1457.3835 | 39165C | 2025-12-11 | AREA NOT INCLUDED | 222.9869 | 224.6525 | 223.7975 | 400 | BUSINESS | 4 -2-3 | 1335 | 980 | DAVITA BUTLER COUNTY DIALYSIS | CLINIC_OR_TREATMENT_CENTER | 2026.2 | 23 | |||||||||||||||||||||||||||||||||||||||||||||
| 11051010030 | 39 | 165 | OH | SAMS LLC | 100 N GARVER RD | WARREN | 77868 | TURTLECREEK | 031602 | 316.0200 | 3116.1080 | 39165C | 2025-12-11 | AREA NOT INCLUDED | 210.3093 | 218.1553 | 215.8960 | 447 | BUSINESS | 3 -3-5 | 5824 | 317 | HOWELL HOME TEAM | REAL_ESTATE_SERVICE | 2026.2 | 58 | |||||||||||||||||||||||||||||||||||||||||||||
| 07031510140 | 39 | 165 | OH | JRCJ RAL ESTATE LLC | 3607 DIXIE HWY | WARREN | 28490 | FRANKLIN | 030700 | 307 | 3549.7330 | 39165C | 2025-12-11 | AREA NOT INCLUDED | 212.8668 | 221.6062 | 220.3368 | 435 | BUSINESS | TOWNGATE EAST 1 LOT: PT. 3 | 2483 | 353 | SONIC DRIVE IN | FAST_FOOD_RESTAURANT | 2026.2 | 23 | |||||||||||||||||||||||||||||||||||||||||||||
| 07011000180 | 39 | 165 | OH | 944 GREENTREE LLC | 944 GREENTREE RD | WARREN | 77868 | TURTLECREEK | 031602 | 316.0200 | 10757.5965 | 39165C | 2025-12-11 | AREA NOT INCLUDED | 198.4122 | 202.6456 | 201.7932 | 499 | BUSINESS | 4-2-1 | 3879 | 242 | BUCKEYE POWER SALES | HARDWARE_HOME_AND_GARDEN_STORE | 2026.2 | 58 | |||||||||||||||||||||||||||||||||||||||||||||
| 07033510500 | 39 | 165 | OH | CITY OF MIDDLETOWN | S DIXIE HWY | WARREN | 28490 | FRANKLIN | 030700 | 307 | 748.5027 | 39165C | 2025-12-11 | AREA NOT INCLUDED | 227.0767 | 228.4922 | 227.7174 | 400 | GOVERNMENT | 4 -2-3 | 3467 | 474 | MADDOX INSURANCE AGENCY | FINANCIAL_SERVICE | 2026.2 | 23 | |||||||||||||||||||||||||||||||||||||||||||||
| 07043510020 | 39 | 165 | OH | SMITH CHARLES RICHARD * | 4131 S DIXIE HWY | WARREN | 28490 | FRANKLIN | 030700 | 307 | 5024.0898 | 39165C | 2025-12-11 | AREA NOT INCLUDED | 221.8963 | 224.5606 | 223.3197 | 415 | PERSON | 4 -2-4 | 942 | 639 | SMITH BLACKTOP | HOME_SERVICE | 2026.2 | 23 | |||||||||||||||||||||||||||||||||||||||||||||
| 07033520010 | 39 | 165 | OH | ROBIN SPRINGS ACQUISITION | 6930 LEFFERSON RD | WARREN | 28490 | FRANKLIN | 030700 | 307 | 37333.1174 | 39165C | 2025-12-11 | AREA NOT INCLUDED | 215.4590 | 236.4870 | 228.6484 | 403 | PERSON | 4 -2-3 | 3672 | 213 | ROBIN SPRINGS APARTMENTS | HISTORIC_SITE | 2026.2 | 23 | |||||||||||||||||||||||||||||||||||||||||||||
| 11063000270 | 39 | 165 | OH | MORVO REALTY LLC | 176 GARVER RD | WARREN | 77868 | TURTLECREEK | 031602 | 316.0200 | 18589.8380 | 39165C | 2025-12-11 | AREA NOT INCLUDED | 203.1459 | 210.4850 | 206.5728 | 454 | BUSINESS | 3 -3-6 | 4878 | 332 | JOE MORGAN HONDA | AUTO_DEALER | 2026.2 | 58 | |||||||||||||||||||||||||||||||||||||||||||||
| 07033510090 | 39 | 165 | OH | CRAWFORD LEASING LLC | 3140 S DIXIE HWY | WARREN | 28490 | FRANKLIN | 030700 | 307 | 2283.7016 | 39165C | 2025-12-11 | AREA NOT INCLUDED | 230.6291 | 233.3011 | 231.9767 | 447 | BUSINESS | 4 -2-3 | 2180 | 554 | SURE HOPE CHRISTIAN ASSEMBLY | CHRISTIAN_PLACE_OF_WORSHIP | 2026.2 | 23 | |||||||||||||||||||||||||||||||||||||||||||||
| 15046000010 | 39 | 165 | OH | WALNUT MEADOWS * | WALNUT MEADOWS DR | WARREN | 21238 | DEERFIELD | 032004 | 320.0400 | 5811.0042 | 39165C | 2025-12-11 | X | AREA OF MINIMAL FLOOD HAZARD | 269.9625 | 273.4831 | 271.5789 | 559 | PERSON | WALNUT MEADOWS LOT: R/W | 87 | 72 | 2026.2 | 8 | ||||||||||||||||||||||||||||||||||||||||||||||
| 02071010010 | 39 | 165 | OH | HARTBARGER DONALD D | FRANKLIN-TRENTON RD | WARREN | 28490 | FRANKLIN | 030101 | 301.0100 | 8746.8453 | 39165C | 2025-12-11 | X | AREA OF MINIMAL FLOOD HAZARD | 202.3229 | 203.7209 | 202.9733 | 501 | PERSON | 5 -1-7 | 5077 | 781 | 2026.2 | 16 | ||||||||||||||||||||||||||||||||||||||||||||||
| 15041010190 | 39 | 165 | OH | VARGAS PROPERTIES LLC | 7036 BUTLER-WARREN RD | WARREN | 21238 | DEERFIELD | 031904 | 319.0400 | 3929.7314 | 39165C | 2025-12-11 | X | AREA OF MINIMAL FLOOD HAZARD | 263.1300 | 269.7928 | 267.2151 | 511 | BUSINESS | 2 -3-4 | 2699 | 145 | 2026.2 | 8 | ||||||||||||||||||||||||||||||||||||||||||||||
| 15033020090 | 39 | 165 | OH | ERTEL TAMI & TERRENCE | 8714 BUTLER-WARREN RD | WARREN | 21238 | DEERFIELD | 032004 | 320.0400 | 2811.0119 | 39165C | 2025-12-11 | X | AREA OF MINIMAL FLOOD HAZARD | 287.4343 | 289.0411 | 288.1649 | 510 | PERSON | PLAINVIEW LOT: 11 | 5951 | 463 | 2026.2 | 8 | ||||||||||||||||||||||||||||||||||||||||||||||
| 01303510080 | 39 | 165 | OH | LANGE PETER D. & * | 9044 FRANKLIN-MADISON RD | WARREN | 28490 | FRANKLIN | 030101 | 301.0100 | 1834.1204 | 39165C | 2025-12-11 | X | AREA OF MINIMAL FLOOD HAZARD | 268.5065 | 269.7979 | 269.1518 | 511 | PERSON | 5 -2-30 | 2189 | 503 | 2026.2 | 16 | ||||||||||||||||||||||||||||||||||||||||||||||
| 01311010120 | 39 | 165 | OH | SATTERFIELD BENNY B. & T | MADISON RD | WARREN | 28490 | FRANKLIN | 030101 | 301.0100 | 20293.0054 | 39165C | 2025-12-11 | X | AREA OF MINIMAL FLOOD HAZARD | 249.6722 | 259.7687 | 253.2217 | 501 | PERSON | 5 -2-31 | 1227 | 963 | 2026.2 | 16 | ||||||||||||||||||||||||||||||||||||||||||||||
| 01303510070 | 39 | 165 | OH | CARTER DENNIS L. & RHOND | 9056 FRANKLIN-MADISON RD | WARREN | 28490 | FRANKLIN | 030101 | 301.0100 | 1655.0829 | 39165C | 2025-12-11 | X | AREA OF MINIMAL FLOOD HAZARD | 268.4401 | 269.9751 | 269.0249 | 511 | PERSON | 5 -2-30 | 575 | 316 | 2026.2 | 16 | ||||||||||||||||||||||||||||||||||||||||||||||
| 15033510010 | 39 | 165 | OH | ANTON CHAD A & MICHELLE* | 8770 BUTLER-WARREN RD | WARREN | 21238 | DEERFIELD | 032004 | 320.0400 | 7005.4866 | 39165C | 2025-12-11 | X | AREA OF MINIMAL FLOOD HAZARD | 283.7694 | 287.8793 | 286.4953 | 510 | PERSON | PLAINVIEW LOT: 10 | 5605 | 147 | 2026.2 | 8 | ||||||||||||||||||||||||||||||||||||||||||||||
| 15033020050 | 39 | 165 | OH | MC KINNEY GINA L. & | 8644 BUTLER-WARREN RD | WARREN | 21238 | DEERFIELD | 032004 | 320.0400 | 2788.1108 | 39165C | 2025-12-11 | X | AREA OF MINIMAL FLOOD HAZARD | 290.6102 | 291.9752 | 291.2403 | 510 | PERSON | PLAINVIEW LOT: 15 | 5164 | 757 | 2026.2 | 8 | ||||||||||||||||||||||||||||||||||||||||||||||
| 11043000200 | 39 | 165 | OH | WHITTEN DENNIS R. & BONN | 1862 BUTLER-WARREN RD | WARREN | 77868 | TURTLECREEK | 031601 | 316.0100 | 20255.6110 | 39165C | 2025-12-11 | X | AREA OF MINIMAL FLOOD HAZARD | 238.0684 | 243.2771 | 240.4355 | 511 | PERSON | 03-3-04 | 3050 | 32 | 2026.2 | 53 | ||||||||||||||||||||||||||||||||||||||||||||||
| 15061000040 | 39 | 165 | OH | FREESE DANIEL M | 5466 BUTLER-WARREN RD | WARREN | 21238 | DEERFIELD | 031908 | 319.0800 | 20362.6918 | 39165C | 2025-12-11 | X | AREA OF MINIMAL FLOOD HAZARD | 268.5928 | 271.8488 | 270.2517 | 511 | PERSON | 2 -3-6 | 284 | 462 | 2026.2 | 8 |