Data Explorer
Query the US Nationwide Parcel Dataset
$1.75 / 1,000 records$100 minimum
36/80
Live SQL
SELECT * FROM "lr_parcel_us" WHERE statefp = '19' AND countyfp = '079'
19,279 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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| {3EC0A790-025E-49AB-8877-3CC7EE… | 19 | 079 | IA | O'CONNOR LARRY | 2111 250TH ST | HAMILTON | 91812 | HAMILTON | 960500 | 9605 | 152529.8829 | 1 | — | 339.0996 | 343.8778 | 340.8038 | AGRICULTURAL | PERSON | 87N | 4 | SW | 25W | SW 1/4S4 T87N R25W | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||||||||||||||||
| {E0EEB293-0527-4512-BBD8-44927F… | 19 | 079 | IA | RISETTER RAE JEAN | 13886 260TH ST | HAMILTON | 92739 | LYON | 960200 | 9602 | 160502.2336 | — | 316.7565 | 331.6291 | 320.2914 | AGRICULTURAL | PERSON | 87N | 24 | SE | 24W | SE 1/4S24 T87N R24W | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||||||||
| {F0FC279A-E6C7-40FB-B2F6-462702… | 19 | 079 | IA | SCHWANDT KEITH P & LISA A | 1831 UBBEN AVE | HAMILTON | 93696 | ROSE GROVE | 960200 | 9602 | 158401.0543 | — | 360.5348 | 363.6765 | 362.1402 | AGRICULTURAL | PERSON | 88N | 8 | NE | 23W | NE 1/4S8 T88N R23W | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||||||||
| {15ED2712-1FFD-422B-95C9-6FCCA1… | 19 | 079 | IA | EVANS RICHARD ANDREW REVOCABLE… | 812 NOB HILL DR WEST | HAMILTON | 93696 | ROSE GROVE | 960200 | 9602 | 159816.9395 | — | 361.5194 | 365.0379 | 363.5497 | AGRICULTURAL | TRUST | 88N | 5 | SW | 23W | SW 1/4S5 T88N R23W | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||||||||
| {6B1980BB-D3C5-4E26-92C7-427059… | 19 | 079 | IA | SWENSON ROBERT L TRUST | 1413 PRAIRIE DR | HAMILTON | 93696 | ROSE GROVE | 960200 | 9602 | 117869.0529 | — | 355.5360 | 363.4328 | 359.4516 | AGRICULTURAL | TRUST | 88N | 19 | NW | 23W | NW 1/4S19 T88N R23W | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||||||||
| {ADAB60C9-2730-4AF6-87C3-E2FC97… | 19 | 079 | IA | LUHMAN MICHAEL D & LISA J JT R… | 22756 HIGHWAY S21 | HAMILTON | 93696 | ROSE GROVE | 960200 | 9602 | 151740.9676 | — | 350.5730 | 354.5839 | 352.5444 | AGRICULTURAL | TRUST | 88N | 25 | SW | 23W | SW 1/4S25 T88N R23W | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||||||||
| {D90F5F17-AF28-4F78-9406-A4ECEE… | 19 | 079 | IA | HP FAMILY FARMS HAMILTON LC | 510 S 17TH ST STE 104 | HAMILTON | 92739 | LYON | 960200 | 9602 | 38362.7011 | — | 316.9205 | 326.1643 | 321.4388 | AGRICULTURAL | BUSINESS | 87N | 34 | SE | 24W | SE 1/4S34 T87N R24W | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||||||||
| {755CFEF6-059F-4B42-96DC-C5047A… | 19 | 079 | IA | HANSON DONALD E | 10581 620TH AVE | HAMILTON | 93783 | SCOTT | 960200 | 9602 | 160828.6623 | — | 341.3003 | 348.5311 | 345.7107 | AGRICULTURAL | PERSON | 86N | 36 | NE | 23W | NE 1/4S36 T86N R23W | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||||||||
| {A490C927-CED9-44DB-B66C-C3D65F… | 19 | 079 | IA | LARSON BRENT A & JODY I | PO BOX 243 | HAMILTON | 93783 | SCOTT | 960200 | 9602 | 156648.4766 | — | 306.7013 | 317.0977 | 308.7488 | AGRICULTURAL | PERSON | 86N | 29 | SW | 23W | SW 1/4S29 T86N R23W | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||||||||
| {29F5848A-AC84-48F1-9DB1-03AF55… | 19 | 079 | IA | LANE WOOD FARMS INC | 3165 360TH ST | HAMILTON | 93783 | SCOTT | 960200 | 9602 | 162799.7266 | — | 330.9068 | 341.1232 | 337.2667 | AGRICULTURAL | BUSINESS | 86N | 9 | SE | 23W | SE 1/4S9 T86N R23W | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||||||||
| {727F9B92-AB02-430A-B819-F6B426… | 19 | 079 | IA | DOYLE DEAN A REVOCABLE TRUST | 450 SW 7TH ST UNIT 209 | HAMILTON | 92739 | LYON | 960200 | 9602 | 158326.3751 | — | 322.1403 | 328.6061 | 325.8672 | AGRICULTURAL | TRUST | 87N | 26 | NE | 24W | NE 1/4S26 T87N R24W | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||||||||
| {773709CD-A0BA-47C8-B70B-21D0F2… | 19 | 079 | IA | BRS AG LLC | 2066 290TH ST | HAMILTON | 91812 | HAMILTON | 960500 | 9605 | 82930.8902 | — | 341.4057 | 345.0066 | 343.4586 | AGRICULTURAL | BUSINESS | 87N | 4 | SE | 25W | SE 1/4S4 T87N R25W | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||||||||
| {5AC6088D-6D88-4F59-B551-A53C70… | 19 | 079 | IA | ISVIK HOWARD C & LORI A | 2674 BRIGGS WOOD RD | HAMILTON | 91812 | HAMILTON | 960200 | 9602 | 3338.8996 | — | 323.4487 | 327.8545 | 326.5494 | AGRICULTURAL | PERSON | 87N | 12 | NW | 25W | NW 1/4S12 T87N R25W | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||||||||
| {D322FE00-EF6B-4DC5-89A4-CCA0EC… | 19 | 079 | IA | FURMAN FAMILY FARMS LLC | 2607 NORTHRIDGE PARKWAY | HAMILTON | 91812 | HAMILTON | 960500 | 9605 | 151969.8531 | — | 325.5375 | 331.0722 | 328.0371 | AGRICULTURAL | BUSINESS | 87N | 14 | NW | 25W | NW 1/4S14 T87N R25W | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||||||||
| {7EBD603C-274B-4884-B41D-FBB736… | 19 | 079 | IA | VANDIEST FAMILY LLC | PO BOX 610 | HAMILTON | 91812 | HAMILTON | 960500 | 9605 | 81567.6589 | — | 336.8151 | 339.6771 | 338.1864 | AGRICULTURAL | BUSINESS | 87N | 18 | SW | 25W | SW 1/4S18 T87N R25W | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||||||||
| {78E6D9DB-8FF2-4284-835A-0F76A4… | 19 | 079 | IA | MERRILL HENKE FARMS LP | 40 RUE GRAND BLVD | HAMILTON | 93696 | ROSE GROVE | 960200 | 9602 | 161230.5551 | — | 350.7697 | 354.2065 | 352.3125 | AGRICULTURAL | BUSINESS | 88N | 34 | SE | 23W | SE 1/4S34 T88N R23W | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||||||||
| {C4C362D2-2DEB-440D-A0C9-1924E8… | 19 | 079 | IA | PATTERSON ERIC C | 2550 230TH ST | HAMILTON | 92454 | LIBERTY | 960200 | 9602 | 158827.4807 | — | 358.6669 | 363.3386 | 360.2657 | AGRICULTURAL | PERSON | 88N | 1 | SW | 24W | SW 1/4S1 T88N R24W | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||||||||
| {071D8FD7-4955-4293-908D-40AA26… | 19 | 079 | IA | CANFIELD RONNY LEE & FRANCINE … | 403 WHITE FOX DR | HAMILTON | 91812 | HAMILTON | 960200 | 9602 | 150882.1095 | — | 324.6982 | 330.2264 | 326.7991 | AGRICULTURAL | PERSON | 87N | 14 | SE | 25W | SE 1/4S14 T87N R25W | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||||||||
| {C2F0E1F0-8839-4FAC-A420-87C0E9… | 19 | 079 | IA | SCHWARZ FARM CORP | 8810 W CLARKE ST | HAMILTON | 91812 | HAMILTON | 960200 | 9602 | 89735.6249 | — | 321.1672 | 324.8682 | 322.0422 | AGRICULTURAL | BUSINESS | 87N | 13 | SE | 25W | SE 1/4S13 T87N R25W | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||||||||
| {C6B2656A-54DB-4457-B379-15284A… | 19 | 079 | IA | SHARER LARRY & DONNA | 2373 320TH ST | HAMILTON | 91812 | HAMILTON | 960500 | 9605 | 145921.8481 | — | 329.1385 | 334.7953 | 331.1495 | AGRICULTURAL | PERSON | 87N | 23 | NW | 25W | NW 1/4S23 T87N R25W | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||||||||
| {46B34979-2105-49DC-AB0F-134B02… | 19 | 079 | IA | LONGNECKER LINDA L | 516 PARK ST | HAMILTON | 91812 | HAMILTON | 960200 | 9602 | 88122.4274 | — | 320.1464 | 325.6561 | 323.6384 | AGRICULTURAL | PERSON | 87N | 13 | NW | 25W | NW 1/4S13 T87N R25W | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||||||||
| {6E99752A-B1D9-4EAF-BDC4-B56E9C… | 19 | 079 | IA | GROVES WILFRED A III & MARJORI… | 2995 NEELY AVENUE | HAMILTON | 91812 | HAMILTON | 960500 | 9605 | 12846.0916 | — | 322.5873 | 326.3530 | 325.3970 | AGRICULTURAL | TRUST | 87N | 11 | SW | 25W | SW 1/4S11 T87N R25W | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||||||||
| {802E7427-2918-447C-A4F4-A849AE… | 19 | 079 | IA | FONKEN BRIAN N & CYNTHIA C | 2840 NORTHWESTERN AVE | HAMILTON | 91812 | HAMILTON | 960500 | 9605 | 38069.8625 | — | 336.8877 | 341.0943 | 338.0988 | AGRICULTURAL | PERSON | 87N | 8 | SE | 25W | SE 1/4S8 T87N R25W | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||||||||
| {B1C3D572-C241-4E19-A667-97E103… | 19 | 079 | IA | LONGNECKER LINDA L | 516 PARK ST | HAMILTON | 91812 | HAMILTON | 960200 | 9602 | 16173.5580 | — | 322.5724 | 327.7644 | 325.7612 | AGRICULTURAL | PERSON | 87N | 13 | SE | 25W | SE 1/4S13 T87N R25W | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||||||||
| {73B53708-8DED-4EE6-9C7E-76C45F… | 19 | 079 | IA | FONKEN BRIAN N & CYNTHIA C | 2840 NORTHWESTERN AVE | HAMILTON | 91812 | HAMILTON | 960500 | 9605 | 151212.8786 | — | 337.3253 | 343.9228 | 340.1506 | AGRICULTURAL | PERSON | 87N | 8 | SE | 25W | SE 1/4S8 T87N R25W | 2026.2 | 2024 |