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-25034839109MOTE PARKPIQUAOH45356CITY OF PIQUAMiami62848Piqua31530031536122.9403039109C2025-12-11XAREA OF MINIMAL FLOOD HAZARD264.6058274.1921268.67391.5000GOVERNMENT7212GOVT LOCALOPENMOTE PARKLOCAL PARKMIAMI
G15-023026391094900 SOUTH COUNTY ROAD 5ATIPP CITYOH45371CUY INVESTMENTS LLCMiami51492Monroe3501023501.020017562.3628439109C2025-12-11XAREA OF MINIMAL FLOOD HAZARD280.1108283.0582281.43374.3160BUSINESS54194TIPP CITY VETERINARY HOSPITALANIMAL_OR_PET_SERVICEMIAMI
G15-02247039109811 JUNIPER CTTIPP CITYOH45371GRIESMEYER MICHAEL GMiami51492Monroe3550013550.01003155.4351139109C2025-12-11XAREA OF MINIMAL FLOOD HAZARD264.5649269.2159266.92510.7800PERSON52394WEALTH MANAGEMENT GROUPFINANCIAL_SERVICEMIAMI
G15-02388039109TIPP CITY POST OFFICETIPP CITYOH45371LEE PAUL DMiami51492Monroe3550023550.02002760.5316239109C2025-12-11XAREA OF MINIMAL FLOOD HAZARD251.9351253.7944252.99530.6820PERSON3335MAJESTIC METAL JOININGMANUFACTURERMIAMI
I26-00636839109BRETHREN IN CHRIST CHURCHPLEASANT HILLOH45359STUMPFF RONALD E JRMiami55594Newton3301003301949.2046039109C2025-12-11XAREA OF MINIMAL FLOOD HAZARD276.5591278.4372277.74760.2349PERSON6233PIPERS PINE SUBDIVISIONSENIOR_LIVING_FACILITYMIAMI
L32-024010391094080 W MONROE CONCORD RDTROYOH45373HAHN TROY J TODMiami78456Union340100340120193.2925339109C2025-12-11XAREA OF MINIMAL FLOOD HAZARD284.6141286.2624285.19815PERSON111HAHN CHRISTMAS TREE FARMFARMMIAMI
D08-10362039109WRIGHT-PATT CREDIT UNIONTROYOH45373MERIGAN LTDMiami18224Concord3650023650.02005951.1950139109C2025-12-11XAREA OF MINIMAL FLOOD HAZARD282.7219284.2759283.54671.4710BUSINESS33636TROJAN AUTO CAREAUTOMOTIVE_SERVICEMIAMI
D08-00565039109RESIGNATION RECORDSTROYOH45373PALEJE WEST HOLDINGS LLCMiami18224Concord3653013653.0100332.3888139109C2025-12-11XAREA WITH REDUCED FLOOD RISK DU…251.2385251.9465251.71800.0800BUSINESS42394MIAMI
D08-00466039109RESIGNATION RECORDSTROYOH45373WIND HORSE LLCMiami18224Concord3653013653.0100511.7003239109C2025-12-11XAREA WITH REDUCED FLOOD RISK DU…250.8429251.3782251.07490.1300BUSINESS3111MIAMI
N44-077576391091281 CAMARO CTPIQUAOH45356FRY INVESTMENTS LTDMiami62848Piqua30010030011420.1021239109C2025-12-11XAREA OF MINIMAL FLOOD HAZARD271.8099274.7032272.81750BUSINESS52591MIAMI
L32-067362391095364 IDDINGS RDWEST MILTONOH45383TRIPLE D AND B LLCMiami78456Union34010034018069.5897439109C2025-12-11XAREA OF MINIMAL FLOOD HAZARD283.2858287.1907285.17782BUSINESS3369MIAMI
C06-0328203910978 S I75TROYOH45373PIQUA MATERIALS INCMiami18224Concord3650023650.020062194.6571039109C2025-12-11XAREA OF MINIMAL FLOOD HAZARD258.4267268.7593264.161015.3960BUSINESS3212MIAMI
A01-25010739109HUBER HEIGHTS CONGREGATION OF J…BETHELOH45371HUBER HTS CONGREGATIONMiami06110Bethel38010038012491.9574039109C2025-12-11XAREA OF MINIMAL FLOOD HAZARD297.8998299.1351298.32210.6160NONPROFIT4885MIAMI
H19-40900239109KOBLE PLUMBING LLCCOVINGTONOH45318CSL OHIO SYSTEM LLCMiami54138Newberry32500032504250.5476139109C2025-12-11XAREA OF MINIMAL FLOOD HAZARD282.7540283.4357283.09411.0560BUSINESS3351MIAMI
D08-10607239109WISHY WASHY CAR WASHTROYOH45373HARLOW BUILDERS INCMiami18224Concord3653013653.0100639.1874139109C2025-12-11XAREA OF MINIMAL FLOOD HAZARD266.7083267.4490267.14390.1578BUSINESS2361MIAMI
G12-08228939109EVANSTON ESTATESMONROEOH45371LYONS BRIAN KMiami51492Monroe3501013501.01001490.6280139109C2025-12-11XAREA OF MINIMAL FLOOD HAZARD288.4300289.0385288.74440.3680PERSONMIAMI
G15-02296239109826 ELDERWOOD AVETIPP CITYOH45371OTTO RAY JMiami51492Monroe3550013550.01001207.6397139109C2025-12-11XAREA OF MINIMAL FLOOD HAZARD271.0857272.4415272.01890.2980PERSONMIAMI
N44-02646039109FIRST CHURCH OF GODPIQUAOH45356MCGRAW KEVIN AMiami62848Piqua3151003151541.7678139109C2025-12-11XAREA OF MINIMAL FLOOD HAZARD267.6725268.0893267.96770.1400PERSONMIAMI
C06-083536391091898 THORNWOOD CTTROYOH45373HUELS JENNA EMiami18224Concord3653023653.02002560.2786139109C2025-12-11XAREA OF MINIMAL FLOOD HAZARD269.1305270.2930269.91130.6330PERSONMIAMI
J27-055294391091590 WEDGEWOOD DRPIQUAOH45356HEMM JEFFREY CMiami74097Springcreek30010030012396.6353139109C2025-12-11XAREA OF MINIMAL FLOOD HAZARD283.8867287.4282285.41970.5910PERSONMIAMI
I20-058000391096868 STATE RT 718PLEASANT HILLOH45359WRIGHT KYLEMiami55594Newton33010033015973.7710239109C2025-12-11XAREA OF MINIMAL FLOOD HAZARD285.3449286.5053285.90151.4700PERSONMIAMI
K30-032850391094239 PIQUA TROY RDTROYOH45373ROWLEY JAMIE PMiami74475Staunton3651013651.010056419.0898239109C2025-12-11XAREA OF MINIMAL FLOOD HAZARD265.4402272.0485269.315214.1300PERSONMIAMI
D08-03191039109BOYER PARKTROYOH45373DEWEY RONALD WILLIAMMiami18224Concord3652003652695.9540239109C2025-12-11XAREA OF MINIMAL FLOOD HAZARD251.7751252.3223252.11530.1700PERSONMIAMI
D08-01248039109MCKAIG RACE PARKTROYOH45373DULING ALAN C TODMiami18224Concord3653013653.0100757.5614139109C2025-12-11XAREA WITH REDUCED FLOOD RISK DU…251.5437252.4553252.16030.1900PERSONMIAMI
L37-00048039109LUDLOW FALLS POST OFFICELUDLOW FALLSOH45339COY DUANE EMiami78456Union3401003401696.8395139109C2025-12-11XAREA OF MINIMAL FLOOD HAZARD275.8702276.4921276.20700.1700PERSONMIAMI