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 = '18' AND countyfp = '157'
89,651 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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 79-07-14-227-009 000-003 | 18 | 157 | 1782 N 400 E | LAFAYETTE | IN | 47905 | Tippecanoe | 22342 | Fairfield | 010800 | 108 | 8769.4396 | 0 | 18157C | 2025-12-14 | X | AREA OF MINIMAL FLOOD HAZARD | 162.0259 | 201.5924 | 186.2969 | 699 | R1 | 3211 | NGO | OPEN | V | CLEGG MEMORIAL GARDEN | LOCAL CONSERVATION AREA | TIPPECANOE COUNTY SOLID WASTE M… | |||||||||||||||||||||||||||||||||||||||||
| 79-03-21-400-017 000-017 | 18 | 157 | 6103 E 600 N | WEST LAFAYETTE | IN | 47906 | Tippecanoe | 75914 | Tippecanoe | 010201 | 102.0100 | 35281.3040 | 1 | 18157C | 2025-12-14 | X | AREA OF MINIMAL FLOOD HAZARD | 182.1570 | 190.2495 | 186.3170 | 820 | A | 71219 | PRIVATE | CLOSED | TIPMONT | PUBLIC_UTILITY | 79017 | ||||||||||||||||||||||||||||||||||||||||||
| 79-11-11-400-013 000-033 | 18 | 157 | 3700 DAVID HOWARTH DR | LAFAYETTE | IN | 47909 | Tippecanoe | 82070 | Wea | 010700 | 107 | 68946.0853 | 1 | 18157C | 2025-12-14 | X | AREA OF MINIMAL FLOOD HAZARD | 198.4776 | 200.9244 | 200.2386 | 340 | I3 | 33635 | HEARTLAND AUTOMOTIVE | AUTOMOTIVE_SERVICE | 79033 | ||||||||||||||||||||||||||||||||||||||||||||
| 79-07-20-437-001 000-004 | 18 | 157 | 638 NORTH ST | LAFAYETTE | IN | 47901 | Tippecanoe | 22342 | Fairfield | 000400 | 4 | 809.5032 | 1 | 18157C | 2025-12-14 | X | AREA OF MINIMAL FLOOD HAZARD | 170.0852 | 173.7096 | 172.2266 | 680 | R2U | 61141 | TANGO LAFAYETTE | SPECIALTY_SCHOOL | 79004 | ||||||||||||||||||||||||||||||||||||||||||||
| 79-09-26-400-008 000-028 | 18 | 157 | 6830 SR 25 S | WEST POINT | IN | 47992 | Tippecanoe | 81926 | Wayne | 010600 | 106 | 40304.8579 | 9 | 18157C | 2025-12-14 | X | AREA OF MINIMAL FLOOD HAZARD | 212.2476 | 220.9664 | 218.5383 | 101 | AW | 71394 | WILD ABOUT HORSES EQUESTRIAN CE… | SPORT_OR_FITNESS_FACILITY | TIPPECANOE COUNTY SOLID WASTE M… | ||||||||||||||||||||||||||||||||||||||||||||
| 79-07-27-226-001 000-004 | 18 | 157 | 3465 SOUTH ST | LAFAYETTE | IN | 47905 | Tippecanoe | 22342 | Fairfield | 001800 | 18 | 3227.0290 | 1 | 18157C | 2025-12-14 | X | AREA OF MINIMAL FLOOD HAZARD | 204.9817 | 208.8300 | 206.0783 | 420 | GB | 44414 | XFINITY STORE BY COMCAST | HOME_SERVICE | 79004 | ||||||||||||||||||||||||||||||||||||||||||||
| 79-07-13-328-015 000-003 | 18 | 157 | EISENHOWER RD | LAFAYETTE | IN | 47905 | Tippecanoe | 22342 | Fairfield | 010800 | 108 | 11650.1921 | 2 | 18157C | 2025-12-14 | X | AREA OF MINIMAL FLOOD HAZARD | 185.8404 | 188.7380 | 187.0879 | 599 | R1 | 71394 | WILDCAT HIGHLANDS REC | SPORT_OR_FITNESS_FACILITY | 79003 | ||||||||||||||||||||||||||||||||||||||||||||
| 79-06-24-427-005 000-029 | 18 | 157 | 1609 STATE ST | WEST LAFAYETTE | IN | 47906 | Tippecanoe | 79352 | Wabash | 010600 | 106 | 568.5814 | 0 | 18157C | 2025-12-14 | X | AREA OF MINIMAL FLOOD HAZARD | 185.6581 | 186.4627 | 185.9478 | 500 | PDMX | 111 | PURDUE UNIVERSITY STUDENT FARM | FARM | TIPPECANOE COUNTY SOLID WASTE M… | ||||||||||||||||||||||||||||||||||||||||||||
| 79-11-12-251-001 000-033 | 18 | 157 | BUILDING SOUTH 460 EAST | LAFAYETTE | IN | 47905 | Tippecanoe | 82070 | Wea | 010700 | 107 | 20573.9913 | 1 | 18157C | 2025-12-14 | X | AREA OF MINIMAL FLOOD HAZARD | 200.4432 | 205.4522 | 202.3203 | 499 | 23812 | L2 STRUCTURES | SPECIALTY_STORE | 79033 | |||||||||||||||||||||||||||||||||||||||||||||
| 79-05-14-200-010 000-014 | 18 | 157 | 8001 SR 26 W | WEST LAFAYETTE | IN | 47906 | Tippecanoe | 69300 | Shelby | 010600 | 106 | 8660.0093 | 0 | 18157C | 2025-12-14 | X | AREA OF MINIMAL FLOOD HAZARD | 202.8401 | 207.5311 | 204.5580 | 511 | AA | TIPPECANOE COUNTY SOLID WASTE M… | |||||||||||||||||||||||||||||||||||||||||||||||
| 79-10-01-426-033 000-021 | 18 | 157 | SMITH DR | LAFAYETTE | IN | 47909 | Tippecanoe | 77660 | Union | 010600 | 106 | 1578.2076 | 1 | 18157C | 2025-12-14 | X | AREA OF MINIMAL FLOOD HAZARD | 189.7145 | 190.3039 | 190.0107 | 599 | SHADELAND | 79021 | |||||||||||||||||||||||||||||||||||||||||||||||
| 79-14-26-400-002 000-011 | 18 | 157 | W 1300 S | ROMNEY | IN | 47981 | Tippecanoe | 62964 | Randolph | 011000 | 110 | 1509.6907 | 0 | 18157C | 2025-12-14 | X | AREA OF MINIMAL FLOOD HAZARD | 230.8576 | 232.2277 | 231.3633 | 501 | AA | 79011 | |||||||||||||||||||||||||||||||||||||||||||||||
| 79-07-29-406-010 000-004 | 18 | 157 | 414 BOMBERDING AVE | LAFAYETTE | IN | 47905 | Tippecanoe | 22342 | Fairfield | 001000 | 10 | 570.4412 | 2 | 18157C | 2025-12-14 | X | AREA OF MINIMAL FLOOD HAZARD | 200.7443 | 201.8719 | 201.3226 | 510 | R2 | 79004 | |||||||||||||||||||||||||||||||||||||||||||||||
| 79-07-15-840-011 000-004 | 18 | 157 | 2178 ULEN LN | LAFAYETTE | IN | 47904 | Tippecanoe | 22342 | Fairfield | 000300 | 3 | 793.7419 | 1 | 18157C | 2025-12-14 | X | AREA OF MINIMAL FLOOD HAZARD | 179.7092 | 180.5184 | 180.1283 | 510 | R1B | 79004 | |||||||||||||||||||||||||||||||||||||||||||||||
| 79-08-21-400-020 000-009 | 18 | 157 | 200 N 775 E | LAFAYETTE | IN | 47905 | Tippecanoe | 59148 | Perry | 010901 | 109.0100 | 8093.5582 | 1 | 18157C | 2025-12-14 | X | AREA OF MINIMAL FLOOD HAZARD | 194.9388 | 197.6287 | 195.8901 | 511 | AW | 79009 | |||||||||||||||||||||||||||||||||||||||||||||||
| 79-01-34-104-001 000-016 | 18 | 157 | 402 E OXFORD ST | OTTERBEIN | IN | 47906 | Tippecanoe | 69300 | Shelby | 010201 | 102.0100 | 586.6483 | 1 | 18157C | 2025-12-14 | X | AREA OF MINIMAL FLOOD HAZARD | 214.2205 | 214.5777 | 214.4101 | 510 | OTTERBEIN | 79016 | |||||||||||||||||||||||||||||||||||||||||||||||
| 79-04-17-100-004 000-017 | 18 | 157 | GOLDSBERRY RD | BATTLE GROUND | IN | 47920 | Tippecanoe | 75914 | Tippecanoe | 010100 | 101 | 40539.7444 | 0 | 18157C | 2025-12-14 | X | AREA OF MINIMAL FLOOD HAZARD | 160.6519 | 182.9756 | 177.3434 | 100 | A | TIPPECANOE COUNTY SOLID WASTE M… | |||||||||||||||||||||||||||||||||||||||||||||||
| 79-07-22-103-036 000-004 | 18 | 157 | 2618 ELMWOOD AVE | LAFAYETTE | IN | 47904 | Tippecanoe | 22342 | Fairfield | 000300 | 3 | 804.4949 | 1 | 18157C | 2025-12-14 | X | AREA OF MINIMAL FLOOD HAZARD | 181.3552 | 184.1061 | 183.0915 | 510 | R1B | 79004 | |||||||||||||||||||||||||||||||||||||||||||||||
| 79-07-12-452-002 000-003 | 18 | 157 | 2172 IRONBRIDGE CT | LAFAYETTE | IN | 47905 | Tippecanoe | 22342 | Fairfield | 010800 | 108 | 984.0956 | 1 | 18157C | 2025-12-14 | X | AREA OF MINIMAL FLOOD HAZARD | 203.6214 | 204.4863 | 204.1854 | 510 | R1 | 79003 | |||||||||||||||||||||||||||||||||||||||||||||||
| 79-07-23-177-042 000-004 | 18 | 157 | 3700 UNION ST | LAFAYETTE | IN | 47905 | Tippecanoe | 22342 | Fairfield | 001800 | 18 | 3811.7233 | 2 | 18157C | 2025-12-14 | X | AREA OF MINIMAL FLOOD HAZARD | 206.6938 | 211.2765 | 208.6589 | 511 | R1 | 79004 | |||||||||||||||||||||||||||||||||||||||||||||||
| 79-03-27-326-003 000-017 | 18 | 157 | 5431 PROPHETS ROCK RD | WEST LAFAYETTE | IN | 47906 | Tippecanoe | 75914 | Tippecanoe | 010100 | 101 | 14099.4886 | 0 | 18157C | 2025-12-14 | X | AREA OF MINIMAL FLOOD HAZARD | 164.6837 | 182.0432 | 174.5463 | 541 | R1 | 79017 | |||||||||||||||||||||||||||||||||||||||||||||||
| 79-07-15-453-002 000-004 | 18 | 157 | 1751 HEMLOCK RD | LAFAYETTE | IN | 47905 | Tippecanoe | 22342 | Fairfield | 001900 | 19 | 2822.0373 | 1 | 18157C | 2025-12-14 | X | AREA OF MINIMAL FLOOD HAZARD | 192.1941 | 195.7004 | 193.9939 | 510 | R1B | TIPPECANOE COUNTY SOLID WASTE M… | |||||||||||||||||||||||||||||||||||||||||||||||
| 79-04-30-400-008 000-027 | 18 | 157 | 5701 ANJOLEA WAY | LAFAYETTE | IN | 47905 | Tippecanoe | 81080 | Washington | 010100 | 101 | 9062.6947 | 1 | 18157C | 2025-12-14 | X | AREA OF MINIMAL FLOOD HAZARD | 168.3446 | 196.2839 | 190.4808 | 511 | A | 79027 | |||||||||||||||||||||||||||||||||||||||||||||||
| 79-11-12-452-003 000-031 | 18 | 157 | US52 S | LAFAYETTE | IN | 47905 | Tippecanoe | 82070 | Wea | 010700 | 107 | 2658.7347 | 1 | 18157C | 2025-12-14 | X | AREA OF MINIMAL FLOOD HAZARD | 201.5843 | 204.1021 | 202.8443 | 499 | I3 | 79031 | |||||||||||||||||||||||||||||||||||||||||||||||
| 79-04-30-226-005 000-027 | 18 | 157 | 5833 N 600 E | LAFAYETTE | IN | 47905 | Tippecanoe | 81080 | Washington | 010100 | 101 | 2043.4704 | 2 | 18157C | 2025-12-14 | X | AREA OF MINIMAL FLOOD HAZARD | 195.2788 | 196.1061 | 195.7043 | 510 | A | TIPPECANOE COUNTY SOLID WASTE M… |