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 = '19' AND countyfp = '169'
42,166 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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1601100200 | 1601100200 | 19 | 169 | 73344 280TH ST | COLLINS | IA | 50055 | IOWA DEPT OF NATURAL RESOURCES | 6200 PARK AVENUE STE 200 | DES MOINES | IA | 50321 | Story | 90777 | Collins | 010200 | 102 | 179525.8119 | -109200 | 0 | 0 | 218400 | 0 | 0 | 19169C | 2025-12-25 | X | AREA OF MINIMAL FLOOD HAZARD | 298.6875 | 320.6228 | 310.1914 | A | Bare Land | 43.4400 | GOVERNMENT | 92412 | SECTION:01 TOWNSHIP:82 RANGE:… | 248 | 152 | GOVT STATE | RESTRICTED | V | HENDRICKSON MARSH WILDLIFE MANA… | STATE CONSERVATION AREA | 2026 | 50029 - COLLINS TWP/ COLLINS-MA… | ||||||||||||||||||||||||
| 0914104070 | 0914105080 | 19 | 169 | 625 S 17TH ST UNIT 205 | AMES | IA | 50010 | BT AMES STUDENT HOUSING DST | 4807 INNOVATE LN | MADISON | WI | 53718 | Story | 94566 | Washington | 001000 | 10 | 20680.7738 | 166700 | 181700 | 166700 | 15000 | 0 | 0 | 19169C | 2025-12-25 | X | AREA OF MINIMAL FLOOD HAZARD | 275.6734 | 278.3984 | 276.4308 | R | R 260 | 0 | PERSON | 71212 | QUARTERS AT AMES UNIT 205 BLDG… | 2022 | 09008 | THE QUARTERS AMES | HISTORIC_SITE | 2026 | 01001 - AMES CITY/AMES SCH, 0.0… | |||||||||||||||||||||||||||
| 0517300145 | 0517300145 | 19 | 169 | 6299 510TH AVE | AMES | IA | 50014 | WINDHORST, NICHOLAS & SARAH M | 6299 510TH AVE | AMES | IA | 50014 | Story | 91428 | Franklin | 000104 | 1.0400 | 6968.5469 | 397400 | 606900 | 397400 | 209500 | 0 | 0 | 19169C | 2025-12-25 | X | AREA OF MINIMAL FLOOD HAZARD | 290.5759 | 293.2166 | 292.1865 | R | Single-Family / Owner Occupied | 1.5300 | PERSON | 54135 | OLIVER'S SD LOT 3 & PT LOT 4 PA… | 2018 | 08829 | RGV LABOR SERVICES | PROFESSIONAL_SERVICE | 2026 | 51049 - FRANKLIN TWP/GILBERT SC… | |||||||||||||||||||||||||||
| 0909199035 | 0909200048 | 19 | 169 | 2311 CHAMBERLAIN ST UNIT 306 | AMES | IA | 50014 | SZ AMES APARTMENTS LLC | PO BOX 11277 | CHICAGO | IL | 60611 | Story | 94566 | Washington | 001102 | 11.0200 | 3958.3663 | 147400 | 172400 | 147400 | 25000 | 0 | 0 | 19169C | 2025-12-25 | X | AREA OF MINIMAL FLOOD HAZARD | 281.7240 | 288.1648 | 284.2933 | R | R 220 | 0 | BUSINESS | 5312 | EDGE CONDOMINIUMS UNIT 306 AME… | 2021 | 15179 | SHAWN SMITH | ATTORNEY_OR_LAW_FIRM | 2026 | 01001 - AMES CITY/AMES SCH, 0.0… | |||||||||||||||||||||||||||
| 0908361565 | 0908360010 | 19 | 169 | 1300 COCONINO RD UNIT 242 | AMES | IA | 50014 | FPA6 UNIVERSITY WEST LLC | 6191 STATE HIGHWAY 161 SUITE 100 | IRVING | TX | 75039 | Story | 94566 | Washington | 001304 | 13.0399 | 33657.2196 | 115700 | 130700 | 115700 | 15000 | 0 | 0 | 19169C | 2025-12-25 | X | AREA OF MINIMAL FLOOD HAZARD | 306.3813 | 307.8541 | 307.2633 | R | R 220 | 0 | BUSINESS | 6113 | COCONINO ROAD 1300 CONDOMINIUMS… | 2018 | 11170 | UNIVERSITY WEST POOL | SWIMMING_POOL | 2026 | 01001 - AMES CITY/AMES SCH, 0.0… | |||||||||||||||||||||||||||
| 0909127280 | 0909127095 | 19 | 169 | 119 STANTON AVE UNIT 402 | AMES | IA | 50014 | MARKER CAMPUSTOWN PROPCO 1 LLC | 3813 WEST CHESTER PIKE | NEWTOWN SQUARE | PA | 19073 | Story | 94566 | Washington | 001102 | 11.0200 | 2304.9001 | 103700 | 123700 | 103700 | 20000 | 0 | 0 | 19169C | 2025-12-25 | X | AREA OF MINIMAL FLOOD HAZARD | 288.2761 | 291.1641 | 289.8527 | R | R 260 | 0 | BUSINESS | 44121 | LEGACY TOWER CONDOMINIUMS UNIT… | 2025 | 08839 | ALEKCO INSURANCE | FINANCIAL_SERVICE | 2026 | 01001 - AMES CITY/AMES SCH, 0.0… | |||||||||||||||||||||||||||
| 0909127475 | 0909127095 | 19 | 169 | 119 STANTON AVE UNIT 515 | AMES | IA | 50014 | MARKER CAMPUSTOWN PROPCO 1 LLC | 3813 WEST CHESTER PIKE | NEWTOWN SQUARE | PA | 19073 | Story | 94566 | Washington | 001102 | 11.0200 | 2304.9001 | 141400 | 161400 | 141400 | 20000 | 0 | 0 | 19169C | 2025-12-25 | X | AREA OF MINIMAL FLOOD HAZARD | 288.2761 | 291.1641 | 289.8527 | R | R 260 | 0 | BUSINESS | 44121 | LEGACY TOWER CONDOMINIUMS UNIT… | 2025 | 08839 | ALEKCO INSURANCE | FINANCIAL_SERVICE | 2026 | 01001 - AMES CITY/AMES SCH, 0.0… | |||||||||||||||||||||||||||
| 0909127345 | 0909127095 | 19 | 169 | 119 STANTON AVE UNIT 416 | AMES | IA | 50014 | MARKER CAMPUSTOWN PROPCO 1 LLC | 3813 WEST CHESTER PIKE | NEWTOWN SQUARE | PA | 19073 | Story | 94566 | Washington | 001102 | 11.0200 | 2304.9001 | 141400 | 161400 | 141400 | 20000 | 0 | 0 | 19169C | 2025-12-25 | X | AREA OF MINIMAL FLOOD HAZARD | 288.2761 | 291.1641 | 289.8527 | R | R 260 | 0 | BUSINESS | 44121 | LEGACY TOWER CONDOMINIUMS UNIT… | 2025 | 08839 | ALEKCO INSURANCE | FINANCIAL_SERVICE | 2026 | 01001 - AMES CITY/AMES SCH, 0.0… | |||||||||||||||||||||||||||
| 0909201900 | 0909201275 | 19 | 169 | 200 STANTON AVE UNIT 613 | AMES | IA | 50014 | MARKER CAMPUSTOWN PROPCO 2 LLC | 3813 WEST CHESTER PIKE | NEWTOWN SQUARE | PA | 19073 | Story | 94566 | Washington | 001102 | 11.0200 | 1351.3711 | 143400 | 163400 | 143400 | 20000 | 0 | 0 | 19169C | 2025-12-25 | X | AREA OF MINIMAL FLOOD HAZARD | 288.0583 | 290.2578 | 289.1548 | R | R 250 | 0 | BUSINESS | 486910 | STANTON AVENUE 200 CONDOMINIUMS… | 2025 | 08843 | CYCLONE PLAZA | HISTORIC_SITE | 2026 | 01001 - AMES CITY/AMES SCH, 0.0… | |||||||||||||||||||||||||||
| 0509280100 | 0509280100 | 19 | 169 | 100 CHRISTIAN PETERSEN AVE | GILBERT | IA | 50105 | JACOBSON, PAUL JAMES & TAMMY JO… | 100 CHRISTIAN PETERSEN AVE | GILBERT | IA | 50105-1018 | Story | 91428 | Franklin | 000103 | 1.0300 | 814.6959 | 190700 | 264400 | 190700 | 73700 | 0 | 0 | 19169C | 2025-12-25 | X | AREA OF MINIMAL FLOOD HAZARD | 301.9475 | 302.7277 | 302.3878 | R | Single-Family / Owner Occupied | 0 | PERSON | 6117 | VILLAGE NORTH 3RD ADD LOT:1 G… | 2023 | 06146 | MY COLLEGE HELPER IOWA | EDUCATIONAL_SERVICE | 2026 | 05047 - GILBERT CITY/ GILBERT S… | |||||||||||||||||||||||||||
| 0914277125 | 0914276300 | 19 | 169 | 528 BILLY SUNDAY RD UNIT 306 | AMES | IA | 50010 | TAILWIND WEST LAFAYETTE LLC 46.… | 530 S FRONT ST STE 100 | MANKATO | MN | 56001 | Story | 94566 | Washington | 001302 | 13.0200 | 9613.6629 | 140000 | 160000 | 140000 | 20000 | 0 | 0 | 19169C | 2025-12-25 | X | AREA OF MINIMAL FLOOD HAZARD | 269.0490 | 273.6622 | 272.3393 | R | R 220 | 0 | BUSINESS | 48611 | BILLY SUNDAY ROAD I CONDOMINIUM… | 2022 | 05276 | NATIONAL FARMERS ORGANIZATION | AGRICULTURAL_SERVICE | 2026 | 01001 - AMES CITY/AMES SCH, 0.0… | |||||||||||||||||||||||||||
| 0909199110 | 0909200048 | 19 | 169 | 2311 CHAMBERLAIN ST UNIT 404 | AMES | IA | 50014 | SZ AMES APARTMENTS LLC | PO BOX 11277 | CHICAGO | IL | 60611 | Story | 94566 | Washington | 001102 | 11.0200 | 3958.3663 | 145500 | 170500 | 145500 | 25000 | 0 | 0 | 19169C | 2025-12-25 | X | AREA OF MINIMAL FLOOD HAZARD | 281.7240 | 288.1648 | 284.2933 | R | R 220 | 0 | BUSINESS | 5312 | EDGE CONDOMINIUMS UNIT 404 AME… | 2021 | 15179 | SHAWN SMITH | ATTORNEY_OR_LAW_FIRM | 2026 | 01001 - AMES CITY/AMES SCH, 0.0… | |||||||||||||||||||||||||||
| 1506200100 | 1506200100 | 19 | 169 | 62614 280TH ST | NEVADA | IA | 50201 | JENNETT, NICHOLAS J | 62614 280TH ST | NEVADA | IA | 50201-7555 | Story | 92034 | Indian Creek | 010200 | 102 | 172179.0553 | -51700 | 0 | 0 | 103400 | 0 | 0 | 19169C | 2025-12-25 | X | AREA OF MINIMAL FLOOD HAZARD | 272.8200 | 288.9443 | 278.9467 | A, AD | Single-Family / Owner Occupied | 41.8400 | PERSON | 71212 | SECTION:06 TOWNSHIP:82 RANGE:… | 2023 | 02986 | OCTAGON ROUND BARN, INDIAN CREE… | HISTORIC_SITE | 2026 | 54061 - INDIAN CREEK TWP/ COLLI… | |||||||||||||||||||||||||||
| 0914450405 | 0914450095 | 19 | 169 | 221 CRYSTAL ST UNIT 204 | AMES | IA | 50010 | IOWA CRYSTAL LLC | PO BOX 5684 | SAN CLEMENTE | CA | 92671 | Story | 94566 | Washington | 001302 | 13.0200 | 16814.6970 | 120700 | 135700 | 120700 | 15000 | 0 | 0 | 19169C | 2025-12-25 | X | AREA OF MINIMAL FLOOD HAZARD | 272.8183 | 274.8406 | 273.8915 | R | R 220 | 0 | BUSINESS | 71212 | CRYSTAL CONDOMINIUMS UNIT 204 … | 2017 | 01521 | CRYSTAL COVE | HISTORIC_SITE | 2026 | 01001 - AMES CITY/AMES SCH, 0.0… | |||||||||||||||||||||||||||
| 0112188306 | 0112188100 | 19 | 169 | 619 ELM AVE | STORY CITY | IA | 50248 | LALAN, MIKE & MARY | 619 ELM AVE APT 306 | STORY CITY | IA | 50248 | Story | 92340 | Lafayette | 010600 | 106 | 1811.7211 | 86300 | 89300 | 86300 | 3000 | 0 | 0 | 19169C | 2025-12-25 | X | AREA OF MINIMAL FLOOD HAZARD | 306.4554 | 307.2117 | 306.7770 | R | Condominium | 0 | PERSON | 62131 | SCANDIA CENTRE CONDOMINIUMS UN… | 2018 | 07040 | GOEDERS FAMILY CHIROPRACTIC | COMPLEMENTARY_AND_ALTERNATIVE_M… | 2026 | 14090 - STORY CITY CITY/ROLAND-… | |||||||||||||||||||||||||||
| 0914106060 | 0914105080 | 19 | 169 | 619 S 17TH ST UNIT 207 | AMES | IA | 50010 | BT AMES STUDENT HOUSING DST | 4807 INNOVATE LN | MADISON | WI | 53718 | Story | 94566 | Washington | 001000 | 10 | 20680.7738 | 189900 | 204900 | 189900 | 15000 | 0 | 0 | 19169C | 2025-12-25 | X | AREA OF MINIMAL FLOOD HAZARD | 275.6734 | 278.3984 | 276.4308 | R | R 260 | 0 | PERSON | 71212 | QUARTERS AT AMES UNIT 207 BLDG… | 2022 | 09008 | THE QUARTERS AMES | HISTORIC_SITE | 2026 | 01001 - AMES CITY/AMES SCH, 0.0… | |||||||||||||||||||||||||||
| 0909127435 | 0909127095 | 19 | 169 | 119 STANTON AVE UNIT 506 | AMES | IA | 50014 | MARKER CAMPUSTOWN PROPCO 1 LLC | 3813 WEST CHESTER PIKE | NEWTOWN SQUARE | PA | 19073 | Story | 94566 | Washington | 001102 | 11.0200 | 2304.9001 | 121800 | 141800 | 121800 | 20000 | 0 | 0 | 19169C | 2025-12-25 | X | AREA OF MINIMAL FLOOD HAZARD | 288.2761 | 291.1641 | 289.8527 | R | R 260 | 0 | BUSINESS | 44121 | LEGACY TOWER CONDOMINIUMS UNIT… | 2025 | 08839 | ALEKCO INSURANCE | FINANCIAL_SERVICE | 2026 | 01001 - AMES CITY/AMES SCH, 0.0… | |||||||||||||||||||||||||||
| 0909201770 | 0909201275 | 19 | 169 | 200 STANTON AVE UNIT 401 | AMES | IA | 50014 | MARKER CAMPUSTOWN PROPCO 2 LLC | 3813 WEST CHESTER PIKE | NEWTOWN SQUARE | PA | 19073 | Story | 94566 | Washington | 001102 | 11.0200 | 1351.3711 | 196900 | 221900 | 196900 | 25000 | 0 | 0 | 19169C | 2025-12-25 | X | AREA OF MINIMAL FLOOD HAZARD | 288.0583 | 290.2578 | 289.1548 | R | R 220 | 0 | BUSINESS | 486910 | STANTON AVENUE 200 CONDOMINIUMS… | 2025 | 08843 | CYCLONE PLAZA | HISTORIC_SITE | 2026 | 01001 - AMES CITY/AMES SCH, 0.0… | |||||||||||||||||||||||||||
| 0908361245 | 0908360010 | 19 | 169 | 1300 COCONINO RD UNIT 204 | AMES | IA | 50014 | FPA6 UNIVERSITY WEST LLC | 6191 STATE HIGHWAY 161 SUITE 100 | IRVING | TX | 75039 | Story | 94566 | Washington | 001304 | 13.0399 | 33657.2196 | 108700 | 123700 | 108700 | 15000 | 0 | 0 | 19169C | 2025-12-25 | X | AREA OF MINIMAL FLOOD HAZARD | 306.3813 | 307.8541 | 307.2633 | R | R 220 | 0 | BUSINESS | 6113 | COCONINO ROAD 1300 CONDOMINIUMS… | 2018 | 11170 | UNIVERSITY WEST POOL | SWIMMING_POOL | 2026 | 01001 - AMES CITY/AMES SCH, 0.0… | |||||||||||||||||||||||||||
| 0932390235 | 0932390235 | 19 | 169 | 1100 GREENVIEW ST | KELLEY | IA | 50134 | CLARK, JALYN DAWN | 1100 GREENVIEW ST | KELLEY | IA | 50134 | Story | 94566 | Washington | 010101 | 101.0100 | 934.9661 | 177800 | 218200 | 177800 | 40400 | 0 | 0 | 19169C | 2025-12-25 | X | AREA OF MINIMAL FLOOD HAZARD | 312.8034 | 313.4111 | 313.2111 | R | Single-Family / Owner Occupied | 0 | PERSON | 81291 | KELLEY WEST 1ST ADD LOT:10 KE… | 2021 | 15557 | HAPPY TAILS ACADEMY | ANIMAL_OR_PET_SERVICE | 2026 | 07015 - KELLEY CITY/BALLARD SCH… | |||||||||||||||||||||||||||
| 0908361255 | 0908360010 | 19 | 169 | 1300 COCONINO RD UNIT 206 | AMES | IA | 50014 | FPA6 UNIVERSITY WEST LLC | 6191 STATE HIGHWAY 161 SUITE 100 | IRVING | TX | 75039 | Story | 94566 | Washington | 001304 | 13.0399 | 33657.2196 | 108700 | 123700 | 108700 | 15000 | 0 | 0 | 19169C | 2025-12-25 | X | AREA OF MINIMAL FLOOD HAZARD | 306.3813 | 307.8541 | 307.2633 | R | R 220 | 0 | BUSINESS | 6113 | COCONINO ROAD 1300 CONDOMINIUMS… | 2018 | 11170 | UNIVERSITY WEST POOL | SWIMMING_POOL | 2026 | 01001 - AMES CITY/AMES SCH, 0.0… | |||||||||||||||||||||||||||
| 0914450480 | 0914450095 | 19 | 169 | 221 CRYSTAL ST UNIT 219 | AMES | IA | 50010 | IOWA CRYSTAL LLC | PO BOX 5684 | SAN CLEMENTE | CA | 92671 | Story | 94566 | Washington | 001302 | 13.0200 | 16814.6970 | 85400 | 100400 | 85400 | 15000 | 0 | 0 | 19169C | 2025-12-25 | X | AREA OF MINIMAL FLOOD HAZARD | 272.8183 | 274.8406 | 273.8915 | R | R 220 | 0 | BUSINESS | 71212 | CRYSTAL CONDOMINIUMS UNIT 219 … | 2017 | 01521 | CRYSTAL COVE | HISTORIC_SITE | 2026 | 01001 - AMES CITY/AMES SCH, 0.0… | |||||||||||||||||||||||||||
| 0909127570 | 0909127095 | 19 | 169 | 119 STANTON AVE UNIT 608 | AMES | IA | 50014 | MARKER CAMPUSTOWN PROPCO 1 LLC | 3813 WEST CHESTER PIKE | NEWTOWN SQUARE | PA | 19073 | Story | 94566 | Washington | 001102 | 11.0200 | 2304.9001 | 141400 | 161400 | 141400 | 20000 | 0 | 0 | 19169C | 2025-12-25 | X | AREA OF MINIMAL FLOOD HAZARD | 288.2761 | 291.1641 | 289.8527 | R | R 260 | 0 | BUSINESS | 44121 | LEGACY TOWER CONDOMINIUMS UNIT… | 2025 | 08839 | ALEKCO INSURANCE | FINANCIAL_SERVICE | 2026 | 01001 - AMES CITY/AMES SCH, 0.0… | |||||||||||||||||||||||||||
| 0909199130 | 0909200048 | 19 | 169 | 2311 CHAMBERLAIN ST UNIT 408 | AMES | IA | 50014 | SZ AMES APARTMENTS LLC | PO BOX 11277 | CHICAGO | IL | 60611 | Story | 94566 | Washington | 001102 | 11.0200 | 3958.3663 | 145900 | 170900 | 145900 | 25000 | 0 | 0 | 19169C | 2025-12-25 | X | AREA OF MINIMAL FLOOD HAZARD | 281.7240 | 288.1648 | 284.2933 | R | R 220 | 0 | BUSINESS | 5312 | EDGE CONDOMINIUMS UNIT 408 AME… | 2021 | 15179 | SHAWN SMITH | ATTORNEY_OR_LAW_FIRM | 2026 | 01001 - AMES CITY/AMES SCH, 0.0… | |||||||||||||||||||||||||||
| 0909199265 | 0909200048 | 19 | 169 | 2311 CHAMBERLAIN ST UNIT 601 | AMES | IA | 50014 | SZ AMES APARTMENTS LLC | PO BOX 11277 | CHICAGO | IL | 60611 | Story | 94566 | Washington | 001102 | 11.0200 | 3958.3663 | 154200 | 179200 | 154200 | 25000 | 0 | 0 | 19169C | 2025-12-25 | X | AREA OF MINIMAL FLOOD HAZARD | 281.7240 | 288.1648 | 284.2933 | R | R 220 | 0 | BUSINESS | 5312 | EDGE CONDOMINIUMS UNIT 601 AME… | 2021 | 15179 | SHAWN SMITH | ATTORNEY_OR_LAW_FIRM | 2026 | 01001 - AMES CITY/AMES SCH, 0.0… |