Data Explorer
Query the US Nationwide Parcel Dataset
$1.75 / 1,000 records$100 minimum
38/80
Live SQL
SELECT * FROM "lr_parcel_us" WHERE statefp = '20' AND countyfp = '157'
7,244 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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0791542001010004000 | 20 | 157 | 527 WICK ST | KS | SOTHERS BEVERLYSOTHERS KAYLEN… | REPUBLIC | 16050 | COURTLAND | 978200 | 9782 | 2185.4545 | 1 | 1 | 1 | — | 456.9948 | 458.3450 | 457.4349 | 1300 | RESIDENTIAL | PERSON | 3S | 20 | 5W | S20 T3S R5W | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||||||||||||||
| 0791542001004006000 | 20 | 157 | 314 PERSHING ST | KS | CHURCH COURTLAND COVENANT | REPUBLIC | 16050 | COURTLAND | 978200 | 9782 | 1194.8880 | 1 | 1 | 1 | — | 457.7066 | 458.5360 | 458.2202 | 1300 | RESIDENTIAL | NONPROFIT | 3S | 20 | 5W | S20 T3S R5W | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||||||||||||||
| 0790562300000002000 | 20 | 157 | 0 DIAMOND RD | KS | ISAACSON JORDAN N & LAUREN K | REPUBLIC | 06550 | BIG BEND | 978200 | 9782 | 647374.8294 | — | 452.4809 | 471.9657 | 457.6112 | PERSON | 424510 | 1S | 23 | 5W | S23 T1S R5W | AURORA CO-OP - REPUBLIC | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||||||||
| 0791452200000004000 | 20 | 157 | 0 HILLTOP LN | KS | WALLACE JOAN MARIE | REPUBLIC | 63375 | SCANDIA | 978200 | 9782 | 925264.0340 | — | 444.7759 | 469.7263 | 460.0664 | PERSON | 3S | 22 | 4W | S22 T3S R4W | MIKE KASL | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||||||||||||||||||
| 0790852200000006000 | 20 | 157 | 1520 170TH RD | KS | SPLICHAL EDWIN G & KAREN J | REPUBLIC | 24675 | FREEDOM | 978100 | 9781 | 11299.5268 | 2 | 1 | 1 | — | 481.7200 | 488.9695 | 485.3877 | PERSON | 2S | 22 | 3W | S22 T2S R3W | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||||||||||||||||
| 0791321000000003010 | 20 | 157 | 1165 US HWY 81 | KS | ANDERSON STEVEN D TRUST | REPUBLIC | 05625 | BELLEVILLE | 978300 | 9783 | 710.9602 | 1 | 1 | 2 | — | 469.8955 | 470.2703 | 470.0974 | TRUST | 3S | 10 | 3W | S10 T3S R3W | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||||||||||||||||
| 0790611100000005000 | 20 | 157 | 516 JADE RD | KS | NEWMAN TROY L & CHRISTINA L | REPUBLIC | 77975 | WHITE ROCK | 978200 | 9782 | 32033.6376 | 4 | 1 | 1 | — | 466.7626 | 474.6570 | 471.6438 | PERSON | 2S | 11 | 5W | S11 T2S R5W | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||||||||||||||||
| 0790872600000001000 | 20 | 157 | 1498 180TH RD | KS | POPELKA CHARLES E & JEAN M | REPUBLIC | 24675 | FREEDOM | 978300 | 9783 | 11492.2243 | 1 | 1 | — | 466.6938 | 473.5096 | 470.5813 | PERSON | 2S | 26 | 3W | S26 T2S R3W | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||||||||
| 0791541704002002000 | 20 | 157 | 0 GRANT ST | KS | HOARD SCOTT A & NOAH A | REPUBLIC | 16050 | COURTLAND | 978200 | 9782 | 5661.9029 | — | 458.7539 | 460.3267 | 459.5671 | 1300 | RESIDENTIAL | PERSON | 3S | 17 | 5W | S17 T3S R5W | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||||||||
| 0790110200000001000 | 20 | 157 | KS | KAPTLE INC | REPUBLIC | 00900 | ALBION | 978100 | 9781 | 1283826.3607 | 1 | 1 | 1 | — | 475.3375 | 486.3555 | 482.7621 | BUSINESS | 1S | 2 | 1W | S2 T1S R1W | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||||||||
| 0790993000000001010 | 20 | 157 | KS | WILBER MORRIS & CHRISTINE TRUST | REPUBLIC | 22575 | FAIRVIEW | 978100 | 9781 | 311251.9912 | 3 | 1 | 1 | — | 456.8224 | 471.6192 | 463.8171 | TRUST | 2S | 30 | 2W | S30 T2S R2W | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||||||||
| 0791210100000002000 | 20 | 157 | 0 NICKEL RD | KS | OLSON FRED & PAT TRUST | REPUBLIC | 35325 | JEFFERSON | 978100 | 9781 | 635010.3648 | 1 | — | 474.8343 | 485.1072 | 480.3195 | TRUST | 3S | 1 | 2W | S1 T3S R2W | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||||||||||||||||||
| 0791351600000005020 | 20 | 157 | 0 QUEEN RD | KS | HANSEN NICHOLAS A & JULIE A | REPUBLIC | 05625 | BELLEVILLE | 978200 | 9782 | 3265.5257 | 1 | — | 469.2470 | 470.5483 | 470.0339 | PERSON | 3S | 16 | 3W | S16 T3S R3W | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||||||||||||||||||
| 0790151604013002000 | 20 | 157 | 510 PINE ST | KS | CITY OF NARKA | REPUBLIC | 00900 | ALBION | 978100 | 9781 | 980.9934 | 1 | — | 480.4758 | 481.8106 | 481.2322 | GOVERNMENT | 1S | 16 | 1W | S16 T1S R1W | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||||||||||||||||||
| 0790211200000005000 | 20 | 157 | 0 CEDAR RD | KS | HOUDEK KYLE DFRYBARGER LORI M | REPUBLIC | 61200 | ROSE CREEK | 978100 | 9781 | 629716.6955 | 1 | — | 453.9229 | 480.3838 | 470.7823 | PERSON | 1S | 12 | 2W | S12 T1S R2W | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||||||||||||||||||
| 0790993100000004000 | 20 | 157 | KS | STRNAD DLOYD J REVOCABLE TRUST… | REPUBLIC | 22575 | FAIRVIEW | 978100 | 9781 | 92918.2073 | — | 450.3145 | 469.7253 | 463.2331 | 8000 | FARMLAND | TRUST | 2S | 31 | 2W | S31 T2S R2W | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||||||||||||||||||
| 0790873503007007000 | 20 | 157 | 910 M ST | KS | REPUBLIC | 05600 | BELLEVILLE | 978300 | 9783 | 1522.3958 | 1 | 1 | — | 469.8866 | 470.6536 | 470.2247 | 2S | 35 | 3W | S35 T2S R3W | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 0791661403002005000 | 20 | 157 | 0 KARL ST | KS | SEGERHAMMAR SHARON K | REPUBLIC | 05150 | BEAVER | 978200 | 9782 | 2322.4132 | — | 460.1244 | 461.0665 | 460.5126 | PERSON | 4S | 14 | 5W | S14 T4S R5W | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 0790352200000006000 | 20 | 157 | 170 RD | KS | PEAKE CHARLOTTE R | REPUBLIC | 40325 | LIBERTY | 978100 | 9781 | 637880.5484 | — | 475.9677 | 499.9339 | 488.4195 | PERSON | 1S | 22 | 3W | S22 T1S R3W | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 0790730800000001010 | 20 | 157 | 90 RD | KS | MOLTER NANCY | REPUBLIC | 72300 | UNION | 978200 | 9782 | 320449.8991 | — | 461.0454 | 476.7211 | 469.8801 | PERSON | 2S | 8 | 4W | S8 T2S R4W | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 0790193200000002000 | 20 | 157 | 0 FIR RD | KS | MC GAVRAN MARGARET LIVING TRUST | REPUBLIC | 00900 | ALBION | 978100 | 9781 | 166410.3680 | — | 480.0024 | 483.6623 | 482.1053 | TRUST | 1S | 32 | 1W | S32 T1S R1W | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 0790151604004004000 | 20 | 157 | 406 KANSAS AVE | KS | HASSE MARY JANE | REPUBLIC | 00900 | ALBION | 978100 | 9781 | 948.9031 | — | 482.5746 | 483.3795 | 483.1008 | PERSON | 1S | 16 | 1W | S16 T1S R1W | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 0791220900000002000 | 20 | 157 | 0 US HWY 36 | KS | POPELKA MARK | REPUBLIC | 35325 | JEFFERSON | 978100 | 9781 | 318818.9031 | — | 463.1901 | 476.1462 | 470.3746 | PERSON | 3S | 9 | 2W | S9 T3S R2W | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 0791061400000006000 | 20 | 157 | 0 KING RD | KS | NOVAK JEFF W & MELISSA | REPUBLIC | 23200 | FARMINGTON | 978100 | 9781 | 325780.6972 | — | 450.0260 | 465.4447 | 458.2760 | PERSON | 2S | 14 | 1W | S14 T2S R1W | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||||||||||
| 0791841800000008000 | 20 | 157 | 140 RD | KS | HOPE FARMS INC | REPUBLIC | 41075 | LINCOLN | 978200 | 9782 | 313511.9045 | — | 460.8516 | 471.6358 | 467.8186 | BUSINESS | 4S | 18 | 3W | S18 T4S R3W | 2026.2 | 2024 |