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 = '073'
52,371 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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| {CA536C00-0936-4C5E-A8D1-BEE525… | 42 | 073 | PA | 16101 | PAVLICH ALBERT ROBERT MARY | Lawrence | 70080 | SHENANGO | 011100 | 111 | 107384.0150 | 0 | 42073C | 2025-12-21 | X | AREA OF MINIMAL FLOOD HAZARD | 7240 | NATURE_RESERVE | PERSON | 3366 | GOVT STATE | RESTRICTED | OTHER | STATE GAME LAND 336 | STATE RESOURCE MANAGEMENT AREA | 2024 | ||||||||||||||||||||||||||||||||||||||||||||
| {0AC5DB56-5E0E-41BF-84E7-18DE4B… | 42 | 073 | PA | 16117 | COMMONWEALTH OF PENNSYLVANIA | Lawrence | 81776 | WAYNE | 011500 | 115 | 815813.6254 | 0 | 42073C | 2025-12-21 | X | AREA OF MINIMAL FLOOD HAZARD | 7240 | NATURE_RESERVE | GOVERNMENT | 4871 | GOVT STATE | RESTRICTED | OTHER | STATE GAME LAND 148 | STATE RESOURCE MANAGEMENT AREA | 2024 | ||||||||||||||||||||||||||||||||||||||||||||
| {1702DD91-69AB-4B7A-9251-C7A9CF… | 42 | 073 | 499 CARMEN BEATRICE BLVD | ELLWOOD CITY | PA | 16117 | ELLWOOD CITY BORO PUBLIC SCHOOL | Lawrence | 23304 | ELLWOOD CITY | 011600 | 116 | 9988.1702 | 4 | 42073C | 2025-12-21 | X | AREA OF MINIMAL FLOOD HAZARD | GOVERNMENT | 61111 | GOVT LOCAL | RESTRICTED | EAST LINE AVENUE ATHLETIC COMPL… | LOCAL RECREATION AREA | 2024 | |||||||||||||||||||||||||||||||||||||||||||||
| {3A6AFC16-6EED-4992-B64E-BDD9C2… | 42 | 073 | 1300 W STATE ST | OAKWOOD | PA | 16101 | PALERMO F DOM ETAL | Lawrence | 78368 | UNION | 010700 | 107 | 723.1847 | 1 | 1 | 1 | 42073C | 2025-12-21 | X | AREA OF MINIMAL FLOOD HAZARD | PERSON | 44133 | API AUTOBODY PRODUCTS | VEHICLE_PARTS_STORE | 2024 | |||||||||||||||||||||||||||||||||||||||||||||
| {5BBCFFD5-B695-4610-A8EB-BC6D1D… | 42 | 073 | 194 SHINGLE HOLLOW RD | PA | PA | 16037 | ROCCON ROBERTA M RAYMOND J | Lawrence | 59488 | PERRY | 011500 | 115 | 72876.4952 | 2 | 1 | 1 | 42073C | 2025-12-21 | X | AREA OF MINIMAL FLOOD HAZARD | 319.3724 | 387.6321 | 341.7485 | PERSON | 2024 | |||||||||||||||||||||||||||||||||||||||||||||
| {9EC1ED1D-7E86-47C5-AC75-02325C… | 42 | 073 | 530 KATHRYN ST | NEW WILMINGTON | PA | 16142 | TOTO LEONARD J II | Lawrence | 54352 | NEW WILMINGTON | 010300 | 103 | 966.9507 | 1 | 1 | 2 | 42073C | 2025-12-21 | X | AREA OF MINIMAL FLOOD HAZARD | 1300 | RESIDENTIAL | PERSON | 2024 | ||||||||||||||||||||||||||||||||||||||||||||||
| {64BBE0D8-CD8C-41E2-9C8F-6AC0FA… | 42 | 073 | 302 BOSTON AVE | OAKWOOD | PA | 16101 | LAWRENCE CO HABITAT FOR HUMANITY | Lawrence | 78368 | UNION | 010700 | 107 | 830.4257 | 3 | 1 | 1 | 42073C | 2025-12-21 | X | AREA OF MINIMAL FLOOD HAZARD | NONPROFIT | 1141 | 2024 | |||||||||||||||||||||||||||||||||||||||||||||||
| {5E5A0D3A-D6A7-4843-BB82-F1E4E3… | 42 | 073 | 321 E HAZELCROFT AVE | NEW CASTLE | PA | 16105 | 4 U S PROPERTY LLC | Lawrence | 53368 | NEW CASTLE | 000100 | 1 | 1030.5366 | 2 | 42073C | 2025-12-21 | X | AREA OF MINIMAL FLOOD HAZARD | 1300 | RESIDENTIAL | BUSINESS | 531312 | 2024 | |||||||||||||||||||||||||||||||||||||||||||||||
| {DC0421AE-F52D-47A0-8455-AE99DC… | 42 | 073 | 338 E MOODY AVE | NEW CASTLE | PA | 16105 | NEW FALLS CORP | Lawrence | 53368 | NEW CASTLE | 000300 | 3 | 816.2341 | 2 | 1 | 1 | 42073C | 2025-12-21 | X | AREA OF MINIMAL FLOOD HAZARD | BUSINESS | 3325 | 2024 | |||||||||||||||||||||||||||||||||||||||||||||||
| {BCDA5812-16F2-4A3C-A894-070FF7… | 42 | 073 | 412 JENNIE LANE | UNION | PA | 16101 | PA AMERICAN WATER CO | Lawrence | 78368 | UNION | 010600 | 106 | 11527.1235 | 1 | 1 | 4 | 42073C | 2025-12-21 | X | AREA OF MINIMAL FLOOD HAZARD | BUSINESS | 22131 | 2024 | |||||||||||||||||||||||||||||||||||||||||||||||
| {01BA8085-4FC5-4ACB-A740-11027B… | 42 | 073 | 1908 HIGHLAND AVE | NEW CASTLE | PA | 16105 | R C B HOMES LLC | Lawrence | 53368 | NEW CASTLE | 000100 | 1 | 1107.7471 | 1 | 42073C | 2025-12-21 | X | AREA OF MINIMAL FLOOD HAZARD | 1300 | RESIDENTIAL | BUSINESS | 2361 | 2024 | |||||||||||||||||||||||||||||||||||||||||||||||
| {35ED3A32-BB03-48BF-B41B-D7EDDE… | 42 | 073 | 807 HARBOR ST | NEW CASTLE | PA | 16101 | CITY RESCUE MISSION | Lawrence | 53368 | NEW CASTLE | 000400 | 4 | 12751.9276 | 2 | 1 | 1 | 42073C | 2025-12-21 | X | AREA OF MINIMAL FLOOD HAZARD | NONPROFIT | 4851 | 2024 | |||||||||||||||||||||||||||||||||||||||||||||||
| {4BAAFBEE-9599-48FF-803D-63117F… | 42 | 073 | 207 BOSTON AVE | OAKWOOD | PA | 16101 | COOK JANETTE F GREGORY F | Lawrence | 78368 | UNION | 010700 | 107 | 951.2894 | 1 | 1 | 1 | 42073C | 2025-12-21 | X | AREA OF MINIMAL FLOOD HAZARD | PERSON | 2024 | ||||||||||||||||||||||||||||||||||||||||||||||||
| {E977F1A8-B302-4BA6-87EC-852B6F… | 42 | 073 | 1150 EASTBROOK | SCOTT | PA | 16101 | RECKARD JEFFREY L NICOLA J | Lawrence | 68408 | SCOTT | 010100 | 101 | 42708.3348 | 2 | 1 | 1 | 42073C | 2025-12-21 | X | AREA OF MINIMAL FLOOD HAZARD | PERSON | 2024 | ||||||||||||||||||||||||||||||||||||||||||||||||
| {76943841-104B-43BB-A4A0-35A067… | 42 | 073 | 1138 BROOKSHIRE DR | SHENANGO | PA | 16101 | GRANT GARY M RITA M | Lawrence | 70080 | SHENANGO | 011000 | 110 | 3733.7506 | 1 | 1 | 1 | 42073C | 2025-12-21 | X | AREA OF MINIMAL FLOOD HAZARD | PERSON | 2024 | ||||||||||||||||||||||||||||||||||||||||||||||||
| {A6C343DA-AD84-431F-AFE6-939B53… | 42 | 073 | 222 SETON DR | PA | PA | 16105 | AMUDI ABDULKADER S BETSY A | Lawrence | 53064 | NESHANNOCK | 010201 | 102.0100 | 2828.5307 | 1 | 1 | 1 | 42073C | 2025-12-21 | X | AREA OF MINIMAL FLOOD HAZARD | PERSON | 2024 | ||||||||||||||||||||||||||||||||||||||||||||||||
| {9D0036A1-2D7B-4B0A-9E81-EF554B… | 42 | 073 | 721 HARTZELL RD | HICKORY | PA | 16156 | TELESZ GREGORY T JILL R | Lawrence | 34248 | HICKORY | 010202 | 102.0200 | 37625.2357 | 1 | 1 | 1 | 42073C | 2025-12-21 | X | AREA OF MINIMAL FLOOD HAZARD | PERSON | 2024 | ||||||||||||||||||||||||||||||||||||||||||||||||
| {7D2821A0-8DA8-4EEC-9CE7-5B3A50… | 42 | 073 | 1651 SHAW RD | WASHINGTON | PA | 16156 | HARRIS RICHARD CAROLINE S | Lawrence | 81272 | WASHINGTON | 010100 | 101 | 4680.3710 | 1 | 1 | 1 | 42073C | 2025-12-21 | X | AREA OF MINIMAL FLOOD HAZARD | PERSON | 2024 | ||||||||||||||||||||||||||||||||||||||||||||||||
| {9FD15FEE-D6C9-47E9-8798-1681CB… | 42 | 073 | 112 E LAUREL AVE | NEW CASTLE | PA | 16101 | PIRKKALA OLIVER | Lawrence | 53368 | NEW CASTLE | 000300 | 3 | 270.8593 | 1 | 1 | 2 | 42073C | 2025-12-21 | X | AREA OF MINIMAL FLOOD HAZARD | PERSON | 2024 | ||||||||||||||||||||||||||||||||||||||||||||||||
| {4CE6C54A-C3A5-4E6B-B13A-268161… | 42 | 073 | 929 TEMPLE AVE | NEW CASTLE | PA | 16101 | TRUSHEL RUSSELL W | Lawrence | 53368 | NEW CASTLE | 000800 | 8 | 409.5512 | 2 | 1 | 1 | 42073C | 2025-12-21 | X | AREA OF MINIMAL FLOOD HAZARD | PERSON | 2024 | ||||||||||||||||||||||||||||||||||||||||||||||||
| {451789A0-D633-4FA0-9AC8-1DA527… | 42 | 073 | 318 ZOCCOLI RD | MAHONING | PA | 16116 | SIEGEL PAUL | Lawrence | 46648 | MAHONING | 010500 | 105 | 4283.2228 | 2 | 1 | 1 | 42073C | 2025-12-21 | X | AREA OF MINIMAL FLOOD HAZARD | PERSON | 2024 | ||||||||||||||||||||||||||||||||||||||||||||||||
| {3C91E9DA-F50D-4EBF-9ED1-12FCEF… | 42 | 073 | 1723 E WASHINGTON ST | NEW CASTLE | PA | 16101 | MCKAY JAMES LINDA | Lawrence | 53368 | NEW CASTLE | 000800 | 8 | 439.3553 | 2 | 1 | 1 | 42073C | 2025-12-21 | X | AREA OF MINIMAL FLOOD HAZARD | PERSON | 2024 | ||||||||||||||||||||||||||||||||||||||||||||||||
| {15A50CF3-D969-4E5A-9A62-34F6EF… | 42 | 073 | 637 JOHN ST | NEW CASTLE | PA | 16101 | ANNARUMO LAWRENCE PAUL SHIRLEY D | Lawrence | 53368 | NEW CASTLE | 000200 | 2 | 1344.1970 | 1 | 1 | 1 | 42073C | 2025-12-21 | X | AREA OF MINIMAL FLOOD HAZARD | PERSON | 2024 | ||||||||||||||||||||||||||||||||||||||||||||||||
| {EB406245-159E-46CC-BCE0-4E201D… | 42 | 073 | 228 4TH ST | ELLWOOD CITY | PA | 16117 | FRANZE ROBERT A LOREEKAY | Lawrence | 23304 | ELLWOOD CITY | 011800 | 118 | 412.7607 | 1 | 1 | 2 | 42073C | 2025-12-21 | X | AREA OF MINIMAL FLOOD HAZARD | PERSON | 2024 | ||||||||||||||||||||||||||||||||||||||||||||||||
| {2C01EECE-E0A9-4917-9BDE-5B7169… | 42 | 073 | 302 WOOD ST | ELLWOOD CITY | PA | 16117 | MARSANO GARY L SYLVIA A | Lawrence | 23304 | ELLWOOD CITY | 011600 | 116 | 500.3548 | 1 | 1 | 1 | 42073C | 2025-12-21 | X | AREA OF MINIMAL FLOOD HAZARD | PERSON | 2024 |