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 = '40' AND countyfp = '093'
8,343 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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 470000274 | 1000572 | 40 | 093 | 268461 CRYSTAL LN LN | AMES | OK | 73718 | SCHMIDT KELLY R TRACY L | 268461 CRYSTAL LN | AMES | OK | 73718 | Major | 90936 | East Major | 955100 | 9551 | 10145.6190 | 280389 | 9000 | 289389 | 180000 | 2020-04-08 | 1 | 1 | 2010 | 1324 | 2 | 3 | — | 345.1393 | 354.4978 | 347.3186 | RR | 2.6000 | PERSON | 4871 | 2 6 ACRES IN NW 13-20N-10W BOOK… | 2071 | 313 | GOVT STATE | RESTRICTED | CLO LANDS | STATE RESOURCE MANAGEMENT AREA | UNDETERMINED | UNDETERMINED | OTHER | CONCRETE BLOCK | METAL, PREFORMED | FRAME, SIDING, VINYL | 2026 | |||||||||||||||||||
| 470008589 | 1009324 | 40 | 093 | 55331 FRANCES RD | AMES | OK | 73718 | FIELDER TERRY J DIANA L | PO BOX 116 | AMES | OK | 73718 | Major | 90936 | East Major | 955100 | 9551 | 2871.6992 | 115952 | 5000 | 120952 | 70000 | 1999-11-04 | 1 | 1 | 1971 | 1800 | 3 | 2 | — | 349.6392 | 352.7812 | 350.8075 | RR | PERSON | 4871 | CRYSTAL LAKES FIRST ADDN LOT 1 … | 1494 | 157 | GOVT STATE | RESTRICTED | CLO LANDS | STATE RESOURCE MANAGEMENT AREA | UNDETERMINED | UNDETERMINED | OTHER | CONCRETE BLOCK | METAL, FORMED SEAMS | FRAME, SIDING, WOOD | 2026 | ||||||||||||||||||||
| 470008602 | 1009338 | 40 | 093 | 55319 SILVERLAKE DR | AMES | OK | 73718 | ALMACK MARK RUSSELL | 526 NOBLE ST | ALVA | OK | 73717 | Major | 90936 | East Major | 955100 | 9551 | 2066.5698 | 75607 | 5000 | 80607 | 79000 | 2014-11-10 | 1 | 1 | 1969 | 1006 | 2 | 1 | — | 345.6393 | 347.3375 | 346.5376 | RR | PERSON | 4871 | CRYSTAL LAKES FIRST ADDN 2ND RE… | 1886 | 470 | GOVT STATE | RESTRICTED | CLO LANDS | STATE RESOURCE MANAGEMENT AREA | UNDETERMINED | UNDETERMINED | OTHER | POURED CONCRETE | COMPOSITION SHINGLE | FRAME, SIDING, WOOD | 2026 | ||||||||||||||||||||
| 470013357 | 1003986 | 40 | 093 | 229531 E COUNTY ROAD 52 | CHESTER | OK | 73838 | WHETSTONE MITCH | PO BOX 181 | SEILING | OK | 73663 | Major | 91105 | Fairview | 955200 | 9552 | 20224.1863 | 203107 | 11500 | 214607 | 1 | 1 | 2018 | 1887 | 3 | 2 | — | 560.3677 | 569.6645 | 564.1893 | RR | 5 | PERSON | 4871 | 5 ACRE TRACT IN NWNE 33-21N-16W… | 1995 | 498 | GOVT STATE | RESTRICTED | CLO LANDS | STATE RESOURCE MANAGEMENT AREA | UNDETERMINED | UNDETERMINED | OTHER | POURED CONCRETE | METAL, FORMED SEAMS | VENEER, MASONRY | 2026 | |||||||||||||||||||||
| 470003833 | 1004413 | 40 | 093 | 42516 HIGHWAY 412 | RINGWOOD | OK | 73768 | MAJORS VANESSA MARIE MAJORS CHR… | 42516 HIGHWAY 412 | RINGWOOD | OK | 73768 | Major | 90936 | East Major | 955100 | 9551 | 20135.2050 | 424388 | 15000 | 439388 | 440000 | 2023-04-20 | 1 | 1 | 2002 | 3429 | 4 | 2 | — | 400.1221 | 407.2317 | 403.7492 | RR | 5 | PERSON | 42384 | 5 ACRE TRACT IN S2SW 10-22N-10W… | 2172 | 361 | MAJORS WELDING & FABRICATION | MANUFACTURER | HEAT PUMP | ELECTRIC | HEAT PUMP | CONCRETE BLOCK | COMPOSITION SHINGLE | VENEER, MASONRY | 2026 | |||||||||||||||||||||
| 470001295 | 1001669 | 40 | 093 | 243593 E COUNTY ROAD 554 | FAIRVIEW | OK | 73737 | VOTH LEONARD C VOTH AMANDA C | 243593 E COUNTY ROAD 554 | FAIRVIEW | OK | 73737-3140 | Major | 91105 | Fairview | 955200 | 9552 | 39846.6390 | 123938 | 27000 | 150938 | 160000 | 2014-11-05 | 1 | 1 | 1997 | 2128 | 4 | 3 | — | 531.0875 | 537.2684 | 533.2604 | RR | 9.8000 | PERSON | 9 8 ACRE TRACT IN NE 14-20N-14W… | 1885 | 605 | UNDETERMINED | UNDETERMINED | OTHER | WOOD/BLOCK PIERS | COMPOSITION SHINGLE | FRAME, PLYWOOD OR HARDBOARD | 2026 | ||||||||||||||||||||||||
| 470011425 | 1004394 | 40 | 093 | 42482 S COUNTY ROAD 266 | RINGWOOD | OK | 73768 | CHAPPELL RYAN | 42482 S COUNTY ROAD 266 | RINGWOOD | OK | 73768 | Major | 90936 | East Major | 955100 | 9551 | 81349.3668 | 119426 | 7684 | 127110 | 30000 | 2021-04-05 | 1 | 1 | 2014 | 1800 | 3 | 2 | — | 402.7672 | 411.7559 | 406.0914 | RR | 20 | PERSON | S2SWNW 10-22N-10W BOOK 2107 - P… | 2107 | 239 | UNDETERMINED | UNDETERMINED | OTHER | WOOD/BLOCK PIERS | COMPOSITION SHINGLE | FRAME, SIDING, VINYL | 2026 | ||||||||||||||||||||||||
| 470010801 | 1005496 | 40 | 093 | 46243 S COUNTY ROAD 244 | FAIRVIEW | OK | 73737 | REESE WILLIS BRETT REESE DEBORA… | 46243 S COUNTY ROAD 244 | FAIRVIEW | OK | 73737-5635 | Major | 91105 | Fairview | 955200 | 9552 | 42149.5102 | 146111 | 7736 | 153847 | 95000 | 2006-12-19 | 1 | 1 | 1952 | 2416 | 3 | 2 | — | 416.5646 | 419.9982 | 418.9658 | RR | 10.4000 | PERSON | 10 4 ACRE TRACT IN NE 35-22N-14… | 1674 | 332 | UNDETERMINED | UNDETERMINED | OTHER | CONCRETE BLOCK | COMPOSITION SHINGLE | FRAME, SIDING, WOOD | 2026 | ||||||||||||||||||||||||
| 470007372 | 1008037 | 40 | 093 | 115 W BROADWAY ST | FAIRVIEW | OK | 73737 | POSTAL HOLDINGS LLC NATIONWIDE … | 75 COLUMBIA AVENUE | CEDARHURST | NY | 11516 | Major | 91105 | Fairview | 955300 | 9553 | 345.9647 | 185188 | 1303 | 186491 | 198000 | 2018-04-26 | 1 | 1 | 1970 | 1 | 4550 | — | 396.5559 | 396.9685 | 396.7982 | UC | BUSINESS | 491110 | LTS 3-4 PARLANS ADDITION FAIRVI… | 2005 | 103 | UNITED STATES POSTAL SERVICE | POST_OFFICE | CENTRAL AIR | UNDETERMINED | CENTRAL AIR | TAR & GRAVEL | BRICK, SOLID | 2026 | ||||||||||||||||||||||||
| 470003740 | 1004298 | 40 | 093 | 41218 S COUNTY ROAD 266 | RINGWOOD | OK | 73768 | GASKILL JARED GASKILL DANIELLA | 41218 S COUNTY ROAD 266 | RINGWOOD | OK | 73768 | Major | 90936 | East Major | 955100 | 9551 | 44848.9719 | 354349 | 29000 | 383349 | 427000 | 2025-08-13 | 1 | 1 | 2021 | 2222 | 3 | 2 | — | 399.7929 | 410.8200 | 403.1828 | RA | 10.6000 | PERSON | 10 6 ACRE TRACT IN W2NW 3-22N-1… | 2230 | 413 | UNDETERMINED | UNDETERMINED | OTHER | POURED CONCRETE | METAL, FORMED SEAMS | FRAME, SIDING, METAL | 2026 | ||||||||||||||||||||||||
| 470000696 | 1001035 | 40 | 093 | 253794 E COUNTY ROAD 54 | FAIRVIEW | OK | 73737 | PENDERGRAFT JOHNNY ETUX | 601 N MAIN ST | FAIRVIEW | OK | 73737-1215 | Major | 91105 | Fairview | 955300 | 9553 | 389512.9171 | 393846 | 17252 | 411098 | 45000 | 2004-06-02 | 1 | 1 | 2014 | 2389 | 4 | 2 | — | 397.5435 | 412.1921 | 404.3556 | RA | 97.0100 | PERSON | 97 01 ACRE IN SE 4-20N-12W BOOK… | 1607 | 469 | UNDETERMINED | UNDETERMINED | OTHER | POURED CONCRETE | COMPOSITION SHINGLE | VENEER, MASONRY | 2026 | ||||||||||||||||||||||||
| 470000166 | 1000442 | 40 | 093 | 57266 S COUNTY ROAD 271 | AMES | OK | 73718 | FIELDER DANNY RAY | 57266 S COUNTY ROAD 271 | AMES | OK | 73718 | Major | 90936 | East Major | 955100 | 9551 | 4046.7034 | 100327 | 5000 | 105327 | 2001-03-28 | 1 | 1 | 1979 | 1407 | 3 | 1 | — | 362.8926 | 363.6607 | 363.1835 | RR | 1 | PERSON | 1 ACRE TRACT IN NW 28-20N-09W B… | 1530 | 256 | UNDETERMINED | UNDETERMINED | OTHER | POURED CONCRETE | COMPOSITION SHINGLE | VENEER, MASONRY | 2026 | |||||||||||||||||||||||||
| 470001973 | 1002416 | 40 | 093 | 0 | OK | 73718 | MUNKRES FARMS LLC OTIS MUNKRES | 271123 E COUNTY ROAD 55 | AMES | OK | 73718 | Major | 90936 | East Major | 955100 | 9551 | 323975.8450 | 67052 | 13026 | 80078 | 94670 | 2003-12-12 | 1 | 1 | 2010 | 720 | 1 | 1 | — | 385.6693 | 393.8573 | 389.1144 | RA | 80 | BUSINESS | 3111 | N2NW 17-21N-09W BOOK 1719 - PAG… | 1598 | 117 | UNDETERMINED | UNDETERMINED | OTHER | COMPOSITION SHINGLE | FRAME, CEMENT FIBER | 2026 | |||||||||||||||||||||||||
| 470007248 | 1007916 | 40 | 093 | 410 S SIXTH AVE | FAIRVIEW | OK | 73737 | MEYERS JEFFREY BILL MEYERS CHAR… | PO BOX 91 | FAIRVIEW | OK | 73737 | Major | 91105 | Fairview | 955300 | 9553 | 650.3031 | 28155 | 3500 | 31655 | 5000 | 2012-08-06 | 1 | 1 | 1920 | 1056 | 2 | 1 | — | 396.3544 | 396.7525 | 396.5682 | UR | PERSON | LTS 5-6 BLK 119 FAIRVIEW OC BOO… | 1820 | 48 | FLOOR UNIT | UNDETERMINED | OTHER | CONCRETE BLOCK | COMPOSITION SHINGLE | ASBESTOS SIDING | 2026 | |||||||||||||||||||||||||
| 470008023 | 1008739 | 40 | 093 | 11 LEGION DR | FAIRVIEW | OK | 73737 | HALDEMAN STEVE D JUDY | 11065 HWY 58 | RINGWOOD | OK | 73768 | Major | 91105 | Fairview | 955300 | 9553 | 1234.2906 | 47264 | 6643 | 53907 | 19000 | 2000-08-05 | 1 | 1 | 1952 | 1128 | 2 | 1 | — | 390.9140 | 391.6694 | 391.3655 | UR | PERSON | LT 6 BLK 3 VETERANS ADDN FAIRVI… | 1514 | 522 | UNDETERMINED | UNDETERMINED | OTHER | CONCRETE BLOCK | COMPOSITION SHINGLE | FRAME, PLYWOOD OR HARDBOARD | 2026 | |||||||||||||||||||||||||
| 470008177 | 1008903 | 40 | 093 | 104 S MAIN AVE | MENO | OK | 73760 | NICHOLS ANGELA A | 5710 E CHESTNUT AVE | ENID | OK | 73701 | Major | 90936 | East Major | 955100 | 9551 | 1504.2431 | 44905 | 6440 | 51345 | 33000 | 2002-10-02 | 1 | 1 | 1950 | 1184 | 3 | 1 | — | 409.2461 | 409.9371 | 409.6786 | UR | PERSON | S 15 OF LT 2 LTS 3-4 BLK 1 WEDE… | 1569 | 101 | UNDETERMINED | UNDETERMINED | OTHER | CONCRETE BLOCK | COMPOSITION SHINGLE | FRAME, SIDING, WOOD | 2026 | |||||||||||||||||||||||||
| 470006198 | 1006897 | 40 | 093 | 323 E TEXAS ST | CLEO SPRINGS | OK | 73729 | MCCLURE GREG S | 323 E TEXAS ST | CLEO SPRINGS | OK | 73729 | Major | 90936 | East Major | 955100 | 9551 | 974.7427 | 91413 | 3675 | 95088 | 70500 | 2021-02-19 | 1 | 1 | 1930 | 1305 | 2 | 2 | — | 388.8414 | 389.4568 | 389.0694 | UR | PERSON | LTS 12-14 BLK 48 CLEO SPRINGS O… | 2104 | 245 | UNDETERMINED | UNDETERMINED | OTHER | CONCRETE BLOCK | COMPOSITION SHINGLE | VENEER, MASONRY | 2026 | |||||||||||||||||||||||||
| 470000007 | 1000269 | 40 | 093 | 274413 E COUNTY ROAD 53 | AMES | OK | 73718 | HAJEK BRENT LEE REVOCABLE TRUST… | HAJEK BRENT TRUSTEE 274413 E CO… | AMES | OK | 73718 | Major | 90936 | East Major | 955100 | 9551 | 12802.1076 | 226240 | 10000 | 236240 | 2021-08-19 | 1 | 1 | 1930 | 1176 | 4 | 2 | — | 386.9404 | 388.5753 | 387.7614 | RR | 3 | TRUST | 3 AC IN NW 1-20N-09W BOOK 2120 … | 2120 | 395 | UNDETERMINED | UNDETERMINED | OTHER | CONCRETE BLOCK | COMPOSITION SHINGLE | FRAME, SIDING, VINYL | 2026 | |||||||||||||||||||||||||
| 470008025 | 1008741 | 40 | 093 | 15 LEGION DR | FAIRVIEW | OK | 73737 | NORBY STEVEN A NORBY JAMIE D | 15 LEGION DR | FAIRVIEW | OK | 73737 | Major | 91105 | Fairview | 955300 | 9553 | 760.0657 | 97608 | 4095 | 101703 | 20000 | 2023-03-14 | 1 | 1 | 1952 | 988 | 3 | 1 | — | 390.7605 | 391.2557 | 391.0113 | UR | PERSON | LT 8 BLK 3 VETERANS ADDN FAIRVI… | 2171 | 103 | UNDETERMINED | UNDETERMINED | OTHER | CONCRETE BLOCK | COMPOSITION SHINGLE | FRAME, SIDING, VINYL | 2026 | |||||||||||||||||||||||||
| 470006272 | 1006971 | 40 | 093 | 200 N 1ST ST | CLEO SPRINGS | OK | 73729 | CHIPMAN NONA M | 200 N 1ST ST | CLEO SPRINGS | OK | 73729-8013 | Major | 90936 | East Major | 955100 | 9551 | 976.2094 | 27813 | 3678 | 31491 | 8000 | 1993-09-27 | 1 | 1 | 1950 | 812 | 2 | 1 | — | 387.1909 | 387.9064 | 387.4997 | UR | PERSON | LTS 10-12 BLK 4 GAMBILLS FIRST … | 1333 | 52 | UNDETERMINED | UNDETERMINED | OTHER | CONCRETE BLOCK | COMPOSITION SHINGLE | FRAME, PLYWOOD OR HARDBOARD | 2026 | |||||||||||||||||||||||||
| 470007805 | 1008505 | 40 | 093 | 1314 N MAIN ST | FAIRVIEW | OK | 73737 | KUSCH MICHAEL LEON ETUX | 1314 N MAIN ST | FAIRVIEW | OK | 73737 | Major | 91105 | Fairview | 955300 | 9553 | 1171.2273 | 111967 | 1450 | 113417 | 1 | 1 | 1965 | 1842 | 3 | 2 | — | 387.9684 | 389.6931 | 389.4064 | UR | 0.2900 | PERSON | 29 AC TRACT IN W2NW 22-21N-12W … | 1319 | 286 | UNDETERMINED | UNDETERMINED | OTHER | POURED CONCRETE | COMPOSITION SHINGLE | VENEER, MASONRY | 2026 | ||||||||||||||||||||||||||
| 470001138 | 1001497 | 40 | 093 | 245771 E COUNTY ROAD 58 | LONGDALE | OK | 73755 | MITCH TERRY MITCH RITA K RLE | 245771 E COUNTY ROAD 58 | LONGDALE | OK | 73755 | Major | 91105 | Fairview | 955200 | 9552 | 24118.6366 | 61800 | 17500 | 79300 | 1 | 1 | 1977 | 1288 | 2 | 2 | — | 508.0199 | 514.3397 | 510.4309 | RR | 6 | PERSON | 6 AC STRIP ALONG WEST SIDE OF N… | 1920 | 486 | UNDETERMINED | UNDETERMINED | OTHER | CONCRETE BLOCK | COMPOSITION SHINGLE | FRAME, PLYWOOD OR HARDBOARD | 2026 | ||||||||||||||||||||||||||
| 470002767 | 1003280 | 40 | 093 | 24804 HIGHWAY 60 | FAIRVIEW | OK | 73737 | BARTEL CHRIS D | 24804 HIGHWAY 60 | FAIRVIEW | OK | 73737-4625 | Major | 91105 | Fairview | 955300 | 9553 | 6487.3777 | 181910 | 7150 | 189060 | 1 | 1 | 1985 | 1359 | 3 | 2 | — | 426.3331 | 432.1049 | 429.4755 | RR | 1.8600 | PERSON | 1 86 ACRE TRACT IN SE 30-21N-12… | 677 | 233 | UNDETERMINED | UNDETERMINED | OTHER | POURED CONCRETE | COMPOSITION SHINGLE | VENEER, MASONRY | 2026 | ||||||||||||||||||||||||||
| 470001419 | 1001804 | 40 | 093 | 57502 S COUNTY ROAD 240 | OK | 73838 | ELWELL TIM ELWELL KELLEY | 57772 S COUNTY ROAD 240 | CHESTER | OK | 73838-2239 | Major | 91105 | Fairview | 955200 | 9552 | 160571.4877 | 15654 | 8187 | 23841 | 2002-09-25 | 1 | 1 | 1995 | 1440 | 3 | 2 | — | 512.9552 | 532.4149 | 518.5177 | RA | 40 | PERSON | NWSW 29-20N-14W BOOK 1570 - PAG… | 1570 | 271 | UNDETERMINED | UNDETERMINED | OTHER | WOOD/BLOCK PIERS | METAL, RIBBED | FRAME, SIDING, VINYL | 2026 | ||||||||||||||||||||||||||
| 470006036 | 1006736 | 40 | 093 | 207 W HOYLE ST | AMES | OK | 73718 | LEHENBAUER PAGE | PO BOX 234 | PEASTER | TX | 76485 | Major | 90936 | East Major | 955100 | 9551 | 1488.5926 | 91074 | 4830 | 95904 | 2021-04-12 | 1 | 1 | 1975 | 1572 | 3 | 2 | — | 365.1282 | 365.8062 | 365.3983 | UR | PERSON | W 15 OF LOT 18 ALL OF LOTS 19-2… | 2180 | 591 | FLOOR UNIT | UNDETERMINED | OTHER | CONCRETE BLOCK | COMPOSITION SHINGLE | FRAME, PLYWOOD OR HARDBOARD | 2026 |