Data Explorer
Query the US Nationwide Parcel Dataset
$1.75 / 1,000 records$100 minimum
43/80
Live SQL
SELECT * FROM "lr_parcel_us" WHERE statefp = '42' AND countyfp = '031'
26,243 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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2007570 | 42 | 031 | PA | TITLEY PETER J | KNOX PA 16232 | CLARION | 04696 | BEAVER | 160400 | 1604 | 702428.4523 | 396699 | 204141 | 0 | 600840 | 2018-07-27 | 362 | 1 | — | 388.9792 | 453.7141 | 426.9989 | PERSON | 7225 | BOOK 2018 PAGE 2464 | 2018 | 2464 | WOLFS DEN RESTAURANT | RESTAURANT | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||||||||||
| 5009360 | 42 | 031 | 41 WILSON AVE | PA | ACEY BRIAN T | CLARION PA 16214 | CLARION | 13800 | CLARION | 160600 | 1606 | 812.0878 | 35320 | 1800 | 0 | 37120 | 2001-09-18 | 1 | 1 | 1 | — | 448.0822 | 452.9551 | 450.5993 | PERSON | BOOK 564 PAGE 1117 | 564 | 1117 | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||
| 7005070 | 42 | 031 | 603 GRANT ST | PA | NEFF JESSICA R | EAST BRADY PA 16028 | CLARION | 20840 | EAST BRADY | 160701 | 1607.0100 | 813.8246 | 5360 | 930 | 0 | 6290 | 2023-04-07 | 2 | 1 | 1 | — | 281.5832 | 287.7750 | 285.0316 | PERSON | BOOK 2023 PAGE 1006 | 2023 | 1006 | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||
| 10084011 | 42 | 031 | 5642 FOREST RD | PA | PARKER JAMES M ET AL | MANSFIELD OH 44906 | CLARION | 25272 | FARMINGTON | 160101 | 1601.0100 | 5938.2737 | 13480 | 1530 | 0 | 15010 | 2001-06-01 | 2 | 1 | 2 | — | 495.4706 | 499.4457 | 497.6268 | PERSON | BOOK 554 PAGE 1017 | 554 | 1017 | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||
| 17001400 | 42 | 031 | 178 LOBAUGHHILL RD | PA | FANCHER LANCE A ET AL | RIMERSBURG PA 16248 | CLARION | 46464 | MADISON | 160701 | 1607.0100 | 1215.2893 | 9190 | 620 | 0 | 9810 | 2019-06-19 | 1 | 1 | 1 | — | 450.3155 | 452.5612 | 451.5658 | PERSON | BOOK 2019 PAGE 1859 | 2019 | 1859 | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||
| 10005460 | 42 | 031 | 37829 RTE 66 | PA | KNIGHT CARIE A | CLARION PA 16214 | CLARION | 25272 | FARMINGTON | 160101 | 1601.0100 | 4035.2028 | 10890 | 1500 | 0 | 12390 | 2005-08-18 | 2 | 1 | 1 | — | 495.6392 | 498.4804 | 497.4040 | PERSON | BOOK 678 PAGE 191 | 678 | 191 | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||
| 10008330 | 42 | 031 | 8201 RTE 36 | PA | FREDERICK LINDA M | TYLERSBURG PA 16361 | CLARION | 25272 | FARMINGTON | 160101 | 1601.0100 | 1695.4344 | 20309 | 1200 | 0 | 21509 | 1981-07-01 | 1 | 1 | 1 | — | 476.0474 | 478.4686 | 477.3466 | PERSON | BOOK 276 PAGE 863 | 276 | 863 | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||
| 34061009 | 42 | 031 | 51 SUNNY RD | PA | SCHMADER KYLE J | LUCINDA PA 16235 | CLARION | 81208 | WASHINGTON | 160201 | 1602.0100 | 3734.1619 | 58460 | 2100 | 0 | 60560 | 1997-06-01 | 1 | 1 | 1 | — | 484.9054 | 489.9351 | 487.2954 | PERSON | BOOK 472 PAGE 123 | 472 | 123 | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||
| 8000600 | 42 | 031 | 1772 BUCKHORN RD | PA | BELL KENNETH W | SHIPPENVILLE PA 16254 | CLARION | 23040 | ELK | 160300 | 1603 | 4594.7613 | 10420 | 1000 | 0 | 11420 | 2021-11-10 | 1 | 1 | 1 | — | 457.0341 | 459.6950 | 458.8352 | PERSON | BOOK 2021 PAGE 5117 | 2021 | 5117 | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||
| 14001650 | 42 | 031 | 152 MAPLE DR | PA | OCHS ERIC M ET AL | LUCINDA PA 16235 | CLARION | 40288 | KNOX | 160202 | 1602.0200 | 1732.7444 | 15970 | 1180 | 0 | 17150 | 2016-10-14 | 1 | 1 | 1 | — | 471.7312 | 475.5180 | 473.7026 | PERSON | BOOK 2016 PAGE 4259 | 2016 | 4259 | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||
| 7003200 | 42 | 031 | 418 GRANT ST | PA | LIPINSKI TIMOTHY | EAST BRADY PA 16028 | CLARION | 20840 | EAST BRADY | 160701 | 1607.0100 | 861.6114 | 7720 | 930 | 0 | 8650 | 2020-09-15 | 1 | 1 | 2 | — | 283.9025 | 287.9877 | 285.9157 | PERSON | BOOK 2020 PAGE 3253 | 2020 | 3253 | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||
| 34003800 | 42 | 031 | 109 COYOTE LN | PA | MANBECK SCOTT W & CHARLETTE S | ARNOLD MD 21012 | CLARION | 81208 | WASHINGTON | 160201 | 1602.0100 | 942.3769 | 7311 | 440 | 0 | 7751 | 2023-11-13 | 1 | 1 | — | 486.0003 | 487.5310 | 486.7460 | PERSON | BOOK 2023 PAGE 3391 | 2023 | 3391 | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||||||||||||
| 13003300 | 42 | 031 | 855 PETROLIA ST | PA | BAUCOM SARAH | KNOX PA 16232 | CLARION | 40272 | KNOX | 160400 | 1604 | 1384.5893 | 15480 | 1960 | 0 | 17440 | 2018-06-16 | 1 | 1 | — | 415.1619 | 417.6290 | 416.4523 | PERSON | BOOK 2018 PAGE 2015 | 2018 | 2015 | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||||||||||||
| 6001910 | 42 | 031 | 198 S 4TH AVE | PA | PASSAVANT MEMORIAL HOMES | ROCHESTER PA 15074 | CLARION | 13808 | CLARION | 160103 | 1601.0300 | 977.8266 | 9090 | 1750 | 0 | 10840 | 2001-08-20 | 1 | 1 | — | 430.0341 | 437.6696 | 433.6203 | PERSON | BOOK 560 PAGE 985 | 560 | 985 | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||||||||||||
| 10006150 | 42 | 031 | 901 MEALY DR | PA | GATESMAN THOMAS L ET UX | HEBRON IN 46341 | CLARION | 25272 | FARMINGTON | 160101 | 1601.0100 | 1697.6149 | 4650 | 770 | 0 | 5420 | 1982-08-01 | 1 | 1 | — | 467.2210 | 470.3516 | 468.9876 | PERSON | BOOK 283 PAGE 287 | 283 | 287 | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||||||||||||
| 10050180 | 42 | 031 | PA | MILLS MARK A | COOKSBURG PA 16217 | CLARION | 25272 | FARMINGTON | 160101 | 1601.0100 | 5513.9220 | 15830 | 1440 | 0 | 17270 | 2013-08-22 | 1 | 1 | 2 | — | 459.5922 | 470.5203 | 464.5501 | PERSON | BOOK 0 PAGE 0 | 0 | 0 | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||||||||||||
| 30096002 | 42 | 031 | PA | UNKNOWN | SLIGO PA 16255 | CLARION | 71176 | SLIGO | 160500 | 1605 | 193.9302 | 0 | 380 | 0 | 380 | 1996-11-01 | — | 341.1570 | 341.8704 | 341.5907 | UNDETERMINED | BOOK 462 PAGE 1071 | 462 | 1071 | GOVT UNKNOWN | RESTRICTED | SLIGO BOROUGH | LOCAL OTHER OR UNKNOWN | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||
| 17006060 | 42 | 031 | 972 LAWSONHAM RD | PA | CRAIG RANDALL L | RIMERSBURG PA 16248 | CLARION | 46464 | MADISON | 160701 | 1607.0100 | 7959.7113 | 14454 | 1700 | 0 | 16154 | 1990-04-02 | 3 | 1 | — | 451.5557 | 461.0366 | 457.3145 | PERSON | BOOK 366 PAGE 144 | 366 | 144 | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||||||||||||
| 21000350 | 42 | 031 | 24232 RTE 66 | PA | MAZE JENNIFER MAE | CLARION PA 16214 | CLARION | 57536 | PAINT | 160300 | 1603 | 1022.5705 | 9131 | 750 | 0 | 9881 | 2019-08-13 | 1 | 1 | — | 470.8170 | 473.2476 | 472.0473 | PERSON | BOOK 2019 PAGE 2642 | 2019 | 2642 | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||||||||||||
| 34003190 | 42 | 031 | PA | REEHER RONALD E | TIONESTA PA 16353 | CLARION | 81208 | WASHINGTON | 160201 | 1602.0100 | 3220.7568 | 0 | 530 | 0 | 530 | 1990-07-01 | 1 | 1 | 1 | — | 474.2560 | 476.2760 | 475.2896 | PERSON | BOOK 370 PAGE 413 | 370 | 413 | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||||||||||||
| 19040350 | 42 | 031 | PA | KLINGENSMITH CHAD R | SLIGO PA 16255 | CLARION | 50464 | MONROE | 160800 | 1608 | 8042.8740 | 0 | 1360 | 0 | 1360 | 2021-02-26 | 1 | 1 | 1 | — | 384.6484 | 390.9690 | 387.6531 | PERSON | BOOK 2021 PAGE 917 | 2021 | 917 | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||||||||||||
| 10013790 | 42 | 031 | 6625 RTE 36 | PA | KAYE MATTHEW J & STACIE E | LEEPER PA 16233 | CLARION | 25272 | FARMINGTON | 160101 | 1601.0100 | 3106.9476 | 13190 | 1320 | 0 | 14510 | 2023-07-10 | 2 | 1 | — | 498.8698 | 501.0831 | 499.9480 | PERSON | BOOK 2023 PAGE 1953 | 2023 | 1953 | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||||||||||||
| 2005750 | 42 | 031 | 6313 RTE 208 | PA | KAHLE KATHRYN D | KNOX PA 16232 | CLARION | 04696 | BEAVER | 160400 | 1604 | 2866.2399 | 9250 | 1320 | 0 | 10570 | 2020-06-18 | 2 | 1 | — | 418.1359 | 427.5523 | 422.8238 | PERSON | BOOK 2020 PAGE 2136 | 2020 | 2136 | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||||||||||||
| 14004080 | 42 | 031 | 945 LAWN DR | PA | SCHMADER MARY ALICE | LUCINDA PA 16235 | CLARION | 40288 | KNOX | 160202 | 1602.0200 | 2172.7721 | 19520 | 1140 | 0 | 20660 | 1984-10-01 | 1 | 1 | — | 467.3944 | 474.0921 | 470.9048 | PERSON | BOOK 298 PAGE 623 | 298 | 623 | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||||||||||||
| 22098013 | 42 | 031 | PA | COOK TERRY E & MARTHA J | PARKER PA 16049 | CLARION | 59456 | PERRY | 160500 | 1605 | 998.0367 | 1620 | 390 | 0 | 2010 | 1998-05-28 | 1 | 1 | — | 325.3772 | 329.4966 | 327.2707 | PERSON | BOOK 491 PAGE 704 | 491 | 704 | 2026.2 | 2024 |