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 = '42' AND countyfp = '021'
85,157 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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 57-010 609.000 | 42 | 021 | 2025 BEDFORD ST | CAMBRIA CITY | PA | 15904 | LEARNING LAMP INC | 2025 BEDFORD ST | JOHNSTOWN | PA | 15904 | CAMBRIA | 74432 | STONYCREEK | 010500 | 105 | 2159.8373 | 117010 | 13400 | 130410 | 180000 | 1 | 1 | 2 | — | 512.6850 | 517.9890 | 515.4426 | E | BUSINESS | IRREG CB AP | 2472 | 503 | THE LEARNING LAMP | SOCIAL_OR_COMMUNITY_SERVICE | 2024 | ||||||||||||||||||||||||||||||||||
| 57-008 516.000 | 42 | 021 | 1600 BEDFORD ST | CAMBRIA CITY | PA | 15902 | ED MICHELLE | 1604 BEDFORD ST | JOHNSTOWN | PA | 15902 | CAMBRIA | 74432 | STONYCREEK | 010500 | 105 | 552.6499 | 6180 | 1000 | 7180 | 1 | 1 | 1 | 1 | — | 459.9482 | 464.0038 | 461.5283 | R | PERSON | 44 X 126 H | 1774 | 744 | OUT OF HIS MIND DANCE | SPORT_OR_FITNESS_FACILITY | 2024 | ||||||||||||||||||||||||||||||||||
| 55-005 014.00B | 42 | 021 | 307 STATE ST | CAMBRIA CITY | PA | 15905 | MACCHIA VOMANO LLC | C O CATANESE GROUP 307 STATE ST | JOHNSTOWN | PA | 15905 | CAMBRIA | 72344 | SOUTHMONT | 011200 | 112 | 501.0891 | 105740 | 5060 | 110800 | 825000 | 1 | 1 | 2 | — | 469.8785 | 471.9797 | 471.1194 | R | BUSINESS | 11 03 CB COMMON AREA | 1995 | 811 | FAMILY DENTAL CENTER | DENTAL_CLINIC | 2024 | ||||||||||||||||||||||||||||||||||
| 23-003 206.001 | 42 | 021 | 490 TWIN DR | CAMBRIA CITY | PA | 15909 | JAMES CYNTHIA ANN LEWIS RANDALL | 490 TWIN DR | JOHNSTOWN | PA | 15909 | CAMBRIA | 21896 | EAST TAYLOR | 010100 | 101 | 2006.8756 | 35160 | 1000 | 36160 | 1 | 1 | 1 | 1 | — | 529.1890 | 533.0980 | 531.5617 | R | PERSON | H | 1612 | 91 | 2024 | ||||||||||||||||||||||||||||||||||||
| 45-012 104.000 | 42 | 021 | 215 BREWER | PATTON | PA | 16668 | CARETTI JOYCE C | 216 BREWER AVE | PATTON | PA | 16668 | CAMBRIA | 58432 | PATTON | 012000 | 120 | 817.5027 | 7400 | 1180 | 8580 | 1 | 1 | 1 | 1 | — | 535.6292 | 539.5203 | 537.3405 | R | PERSON | 60 X 144 H | 1545 | 187 | 2024 | ||||||||||||||||||||||||||||||||||||
| 50-024 213.001 | 42 | 021 | 331 ELBERT ST | CAMBRIA CITY | PA | 15904 | SESTRICH ANTHONY M AUDREY J | 331 ELBERT ST | JOHNSTOWN | PA | 15904 | CAMBRIA | 64544 | RICHLAND | 010801 | 108.0100 | 1155.2292 | 11880 | 2480 | 14360 | 56000 | 1 | 1 | 1 | — | 563.0778 | 564.6540 | 564.0312 | R | PERSON | 84 X 145 H G | 1703 | 1084 | 2024 | ||||||||||||||||||||||||||||||||||||
| 34-045 200.000 | 42 | 021 | 2738 WILLIAM PENN AVE | CAMBRIA CITY | PA | 15909 | PORADA EDWIN J CAROLYN G | 2738 WILLIAM PENN AVE | JOHNSTOWN | PA | 15909 | CAMBRIA | 37352 | JACKSON | 011500 | 115 | 2327.5562 | 7980 | 3020 | 11000 | 1 | 1 | 1 | 1 | — | 518.4143 | 523.7803 | 520.5854 | R | PERSON | 122 X 191 H | 1245 | 0861 | 2024 | ||||||||||||||||||||||||||||||||||||
| 32-033 200.000 | 42 | 021 | 728 DEMUTH ST | CAMBRIA CITY | PA | 15904 | RIZZO ANTHONY J LYNDA A | PO BOX 5041 | JOHNSTOWN | PA | 15904 | CAMBRIA | 28720 | GEISTOWN | 010600 | 106 | 2005.7026 | 11820 | 3920 | 15740 | 60000 | 1 | 1 | 1 | — | 592.6522 | 595.8290 | 594.2603 | R | PERSON | 100 X 215 1H | 1356 | 0101 | 2024 | ||||||||||||||||||||||||||||||||||||
| 13-017 114.000 | 42 | 021 | 4502 COLONEL DRAKE HWY | PATTON | PA | 16668 | STROHMIER SCOTT W REBECCA S | 4502 COLONEL DRAKE HIGHWAY | PATTON | PA | 16668 | CAMBRIA | 14056 | CLEARFIELD | 012000 | 120 | 3399.7846 | 12290 | 1520 | 13810 | 76000 | 1 | 1 | 1 | — | 564.3708 | 570.6138 | 566.6416 | R | PERSON | H | 1931 | 748 | 2024 | ||||||||||||||||||||||||||||||||||||
| 34-005 165.000 | 42 | 021 | 530 KISSELL LN | CAMBRIA CITY | PA | 15909 | JOHNS BARRY L MARY ANN | C O MARY ANN JOHNS 530 KISSELL … | JOHNSTOWN | PA | 15909 | CAMBRIA | 37352 | JACKSON | 011500 | 115 | 2353.6568 | 24180 | 1720 | 25900 | 1 | 1 | 1 | 1 | — | 566.8741 | 571.9344 | 569.4597 | R | PERSON | H | 2519 | 1385 | 2024 | ||||||||||||||||||||||||||||||||||||
| 48-008 132.000 | 42 | 021 | 161 GIGGUETOWN | PORTAGE | PA | 15946 | PATNEY JOEL SHERIE | 161 GIGGUETOWN RD | PORTAGE | PA | 15946 | CAMBRIA | 62056 | PORTAGE | 012900 | 129 | 15781.0736 | 18980 | 1320 | 20300 | 46500 | 1 | 1 | 1 | — | 754.9817 | 773.9424 | 764.5017 | R | PERSON | H | 1177 | 0811 | 2024 | ||||||||||||||||||||||||||||||||||||
| 62-025 146.000 | 42 | 021 | 110 BRETTON RD | CAMBRIA CITY | PA | 15905 | HOLBAY ASHLEY E | 110 BRETTON RD | JOHNSTOWN | PA | 15905 | CAMBRIA | 79360 | UPPER YODER | 011100 | 111 | 1003.4400 | 18280 | 3020 | 21300 | 82500 | 1 | 1 | 1 | — | 533.6709 | 538.6392 | 536.0801 | R | PERSON | 80 X 135 H | 2783 | 641 | 2024 | ||||||||||||||||||||||||||||||||||||
| 43-011 209.000 | 42 | 021 | 1096 CHESTNUT ST | NANTY GLO | PA | 15943 | SHEDLOCK REVOCABLE TRUST | 1096 CHESTNUT ST | NANTY GLO | PA | 15943 | CAMBRIA | 52616 | NANTY-GLO | 011600 | 116 | 657.4491 | 7310 | 980 | 8290 | 1 | 1 | 1 | 1 | — | 535.9869 | 539.0593 | 537.7298 | R | TRUST | 50 X 140 H | 2528 | 26 | 2024 | ||||||||||||||||||||||||||||||||||||
| 62-004 150.000 | 42 | 021 | 316 MEADOW DR | CAMBRIA CITY | PA | 15905 | SHAFFER KYLE S STACIE A | R3316 WOODCREST DR | JOHNSTOWN | PA | 15905 | CAMBRIA | 79360 | UPPER YODER | 011100 | 111 | 13496.2271 | 16280 | 3080 | 19360 | 45000 | 2 | 1 | 1 | — | 538.2816 | 555.3129 | 546.4724 | R | PERSON | H G | 2799 | 352 | 2024 | ||||||||||||||||||||||||||||||||||||
| 41-002 120.000 | 42 | 021 | 5743 ADMIRAL PEARY HWY | LILLY | PA | 15938 | G T G ASSOCIATES LLC | 5700 ADMIRAL PEARY HWY | EBENSBURG | PA | 15931 | CAMBRIA | 52360 | MUNSTER | 012700 | 127 | 41050.5191 | 15550 | 1780 | 17330 | 58500 | 2 | 1 | 1 | — | 513.8469 | 561.5285 | 534.4664 | A | BUSINESS | H G CARPORT | 2616 | 2 | 2024 | ||||||||||||||||||||||||||||||||||||
| 34-019 107.002 | 42 | 021 | CHICKAREE HILL RD REAR | PA | 15943 | PENNSYLVANIA GAME COMMISSION | 2001 ELMERTON AVE | HARRISBURG | PA | 17110 | CAMBRIA | 37352 | JACKSON | 011500 | 115 | 40471.9874 | 2000 | 2000 | 1 | — | 698.3804 | 709.9426 | 705.3131 | P | NATURE_RESERVE | PERSON | 2566 | 295 | GOVT STATE | OPEN | OTHER | STATE GAME LAND 079 | STATE RESOURCE MANAGEMENT AREA | 2024 | ||||||||||||||||||||||||||||||||||||
| 84-000 102.002 | 42 | 021 | 124 IRON ST | CAMBRIA CITY | PA | 15901 | SMITH BROS PROPERTY LLC | 124 IRON ST | JOHNSTOWN | PA | 15906 | CAMBRIA | 38288 | JOHNSTOWN | 013400 | 134 | 5623.2551 | 38590 | 700 | 39290 | 15000 | 1 | 1 | — | 353.9531 | 355.3786 | 354.6574 | C | INDUSTRIAL | BUSINESS | CB FENCE CC PAVING | JOHNSTOWN HYDRAULICS INC | AUTOMOTIVE_SERVICE | 2024 | ||||||||||||||||||||||||||||||||||||
| 23-022 410.001 | 42 | 021 | 1376 BRIGGS AVE | CAMBRIA CITY | PA | 15909 | WASHABAUGH ROBERT E LISSA | 1376 BRIGGS AVE | JOHNSTOWN | PA | 15909 | CAMBRIA | 21896 | EAST TAYLOR | 010100 | 101 | 1416.2562 | 13090 | 1180 | 14270 | 106000 | 1 | 1 | 1 | — | 545.4240 | 547.2943 | 546.8761 | R | PERSON | IRREG H OB | 1883 | 208 | 2024 | ||||||||||||||||||||||||||||||||||||
| 68-024 117.000 | 42 | 021 | 103 HARMONY DR | WHITE | PA | 16640 | ALBERT RICHARD L ANITA L | 1360 GOOD ST | JOHNSTOWN | PA | 15905 | CAMBRIA | 84448 | WHITE | 012100 | 121 | 1652.5373 | 4860 | 4860 | 9720 | 29000 | 1 | 1 | — | 444.0433 | 451.6959 | 447.6266 | R | RESIDENTIAL | PERSON | 85 X 260 H | 2547 | 1145 | 2024 | ||||||||||||||||||||||||||||||||||||
| 34-004 106.002 | 42 | 021 | 1102 SWIGLE MT RD | MINERAL POINT | PA | 15942 | BLANCHETTI JANICE E MICHAEL J | 1102 SWIGLE MOUNTAIN RD | MINERAL POINT | PA | 15942 | CAMBRIA | 37352 | JACKSON | 011500 | 115 | 4010.4117 | 23030 | 1500 | 24530 | 1 | 1 | 1 | 1 | — | 684.0968 | 687.0112 | 685.8315 | R | PERSON | H G | 2575 | 291 | 2024 | ||||||||||||||||||||||||||||||||||||
| 57-007 246.000 | 42 | 021 | 1642 LINWOOD AVE | CAMBRIA CITY | PA | 15902 | SHAFFER LISA J | 1642 LINWOOD AVE | JOHNSTOWN | PA | 15902 | CAMBRIA | 74432 | STONYCREEK | 010500 | 105 | 445.9622 | 11020 | 920 | 11940 | 57000 | 1 | 1 | 1 | — | 507.2810 | 511.0547 | 509.3376 | R | PERSON | 40 X 120 H | 2541 | 155 | 2024 | ||||||||||||||||||||||||||||||||||||
| 16-012 500.000 | 42 | 021 | 7711 ADMIRAL PEARY HWY | CRESSON | PA | 16630 | LYNCH JOHN D BRENDA M | 7711 ADMIRAL PEARY HWY | CRESSON | PA | 16630 | CAMBRIA | 17144 | CRESSON | 012800 | 128 | 1036.9742 | 14740 | 2120 | 16860 | 119700 | 1 | 1 | 1 | — | 648.6097 | 652.3348 | 650.5822 | R | PERSON | 93 X 120 2H | 2215 | 293 | 2024 | ||||||||||||||||||||||||||||||||||||
| 08-057 605.000 | 42 | 021 | 211 LAURELBROOK RD | EBENSBURG | PA | 15931 | BODENSCHATZ MARK L NANCY T | 211 LAURELBROOK RD | EBENSBURG | PA | 15931 | CAMBRIA | 10880 | CAMBRIA | 012500 | 125 | 1393.6639 | 34200 | 3520 | 37720 | 141000 | 1 | 1 | 1 | — | 626.2426 | 630.9813 | 628.6856 | R | PERSON | 100 X 150 H | 1298 | 0331 | 2024 | ||||||||||||||||||||||||||||||||||||
| 56-098 403.000 | 42 | 021 | 709 CROSBY | NORTHERN CAMBRIA | PA | 15714 | DUNCHACK ROBIN J | 709 CROSBY AVE | NORTHERN CAMBRIA | PA | 15714 | CAMBRIA | 55000 | NORTHERN CAMBRIA | 011900 | 119 | 863.0060 | 9580 | 1400 | 10980 | 35000 | 2 | 1 | 1 | — | 445.2128 | 453.3212 | 449.1081 | R | PERSON | 73 X 134 H G | 2416 | 792 | 2024 | ||||||||||||||||||||||||||||||||||||
| 15-011 120.000 | 42 | 021 | 1002 2ND ST | CRESSON | PA | 16630 | EQUITY TRUST COMPANY | 54 COUNTRY CLUB RD | CRESSON | PA | 16630 | CAMBRIA | 17136 | CRESSON | 012800 | 128 | 2017.4281 | 55640 | 8150 | 63790 | 305000 | 1 | 1 | 1 | — | 614.5008 | 615.1449 | 614.8553 | C | TRUST | 181 X 120 CB AP | CRESSON CLEANING SUPPLY | FOOD_AND_BEVERAGE_STORE | 2024 |