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 = '001'
46,705 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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 41J16-0029---000 | 42 | 001 | 1904 WHITE HALL RD | LITTLESTOWN | PA | 17340 | MOREHEAD CHRISTOPHER M | 1904 WHITE HALL RD | LITTLESTOWN | PA | 17340 | ADAMS | 78264 | UNION | 031203 | 312.0299 | 6496.4476 | -470800 | -470800 | -470800 | 706200 | 192500 | 2014-02-12 | 1 | 1 | 42001C | 2025-12-21 | X | AREA OF MINIMAL FLOOD HAZARD | 175.8458 | 184.3632 | 179.1905 | RC | 1.6299 | PERSON | 7225 | 2 TRACTS | 5915 | 644 | CM MOREHEAD UPHOLSTERY | RESTAURANT | |||||||||||||||||||||||||||||
| 25C16-0076---000 | 42 | 001 | 151 BRENT RD | FAIRFIELD | PA | 17320 | BRENT JASON M ET AL | 151 BRENT RD | FAIRFIELD | PA | 17320 | ADAMS | 43056 | LIBERTY | 031600 | 316 | 2760.7822 | -413000 | -413000 | -413000 | 619500 | 1 | 2004-11-12 | 1 | 1 | 42001C | 2025-12-21 | X | AREA OF MINIMAL FLOOD HAZARD | 184.3187 | 198.1727 | 190.5182 | R | 0.8300 | PERSON | 7224 | 3769 | 229 | BILLY BRENT'S ORCHARD | BAR | ||||||||||||||||||||||||||||||
| 09F12-0178---000 | 42 | 001 | 775 OLD HARRISBURG RD | CUMBERLAND | PA | 17325 | GTC DOS LLC | PO BOX 2359 | PONTE VEDRA BEACH | FL | 32004 | ADAMS | 17640 | CUMBERLAND | 031401 | 314.0100 | 65790.9904 | -816000 | -816000 | -816000 | 1224000 | 10 | 2025-04-22 | 1 | 1 | 42001C | 2025-12-21 | AE | FLOODWAY | 143.6820 | 150.1828 | 145.9154 | CL | 16.6700 | BUSINESS | TOWER LEASE AGREEMENT 5457-516 | 7323 | 364 | ADAMS COUNTY CHIROPRACTIC | COMPLEMENTARY_AND_ALTERNATIVE_M… | ||||||||||||||||||||||||||||||
| 29D07-0020---000 | 42 | 001 | 80 NAWAKWA RD | BIGLERVILLE | PA | 17307 | TAYLOR MICHAEL M & REBECCA N | 80 NAWAKWA RD | BIGLERVILLE | PA | 17307 | ADAMS | 48608 | MENALLEN | 030300 | 303 | 1492.4539 | -195600 | -195600 | -195600 | 293400 | 129000 | 2005-08-02 | 1 | 1 | 42001C | 2025-12-21 | X | AREA OF MINIMAL FLOOD HAZARD | 267.1514 | 273.9734 | 270.7156 | R | 0.4400 | PERSON | 4066 | 129 | TAYLOR WEAPON SERVICES | SPORTING_GOODS_STORE | |||||||||||||||||||||||||||||||
| 06010-0005---000 | 42 | 001 | 122 MAPLE ST | LITTLESTOWN | PA | L-0005 | OMELIA ANDREW E & BRANDY N | 122 MAPLE ST | LITTLESTOWN | PA | 17340 | ADAMS | 07560 | BONNEAUVILLE | 030700 | 307 | 2041.0200 | -607400 | -607400 | -607400 | 911100 | 399900 | 2022-04-19 | 1 | 1 | 42001C | 2025-12-21 | X | AREA OF MINIMAL FLOOD HAZARD | 187.4878 | 190.0846 | 188.8551 | R | 0.5500 | PERSON | 23,989 SF | 6952 | 514 | ||||||||||||||||||||||||||||||||
| 07F07-0045---000 | 42 | 001 | 380 CARLISLE RD | BIGLERVILLE | PA | 17307 | HOLLABAUGH NEIL A & GEORGIA K | 380 CARLISLE RD | BIGLERVILLE | PA | 17307 | ADAMS | 10456 | BUTLER | 030500 | 305 | 7141.5742 | -496400 | -496400 | -496400 | 744600 | 195000 | 2002-07-15 | 1 | 1 | 42001C | 2025-12-21 | X | AREA OF MINIMAL FLOOD HAZARD | 217.9029 | 222.4780 | 220.8323 | R | 1.6900 | PERSON | 3 TRACTS | 2729 | 320 | ||||||||||||||||||||||||||||||||
| 43028-0128---000 | 42 | 001 | + LEE TRL W-0290 | FAIRFIELD | PA | 17320 | KAPLAN EDWARD J & DIANE L | 26 LEE TRL | FAIRFIELD | PA | 17320 | ADAMS | 11472 | CARROLL VALLEY | 031600 | 316 | 1875.8963 | -556000 | -556000 | -556000 | 834000 | 1 | 2008-07-21 | 1 | 1 | 42001C | 2025-12-21 | X | AREA OF MINIMAL FLOOD HAZARD | 263.5031 | 270.3118 | 267.7894 | R | 2.0700 | PERSON | SEC W LOTS 271,290,291,292 | 5267 | 179 | ||||||||||||||||||||||||||||||||
| 09E13-0004---000 | 42 | 001 | 1331 BLACK HORSE TAVERN RD | GETTYSBURG | PA | 17325 | BURKHOLDER RICHARD SCOTT & LEE… | 5290 BULL RD | DOVER | PA | 17315 | ADAMS | 17640 | CUMBERLAND | 031401 | 314.0100 | 461.7657 | -254600 | -254600 | -254600 | 381900 | 117000 | 2020-08-06 | 1 | 1 | 42001C | 2025-12-21 | X | AREA OF MINIMAL FLOOD HAZARD | 151.7998 | 154.1116 | 153.2614 | R | 0.0800 | PERSON | 3,667 SF, SMALL CLOSURE ERROR | 6645 | 619 | ||||||||||||||||||||||||||||||||
| 08008-0184---000 | 42 | 001 | 511 THIRD ST | HANOVER | PA | 17331 | VALENTINE NICHOLAS THEDIEM | 511 THIRD ST | HANOVER | PA | 17331 | ADAMS | 15632 | CONEWAGO | 031101 | 311.0100 | 723.6576 | -254600 | -254600 | -254600 | 381900 | 170000 | 2024-12-16 | 1 | 1 | 42001C | 2025-12-21 | X | AREA OF MINIMAL FLOOD HAZARD | 181.4596 | 182.8102 | 182.2489 | R | 0.1700 | PERSON | 7,495 SF | 7281 | 7 | ||||||||||||||||||||||||||||||||
| 22I05-0013E--000 | 42 | 001 | 20 QUAKER CHURCH RD | YORK SPRINGS | PA | 17372 | KMETZ JOHN P | 10 QUAKER CHURCH RD | YORK SPRINGS | PA | 17372 | ADAMS | 36424 | HUNTINGTON | 030200 | 302 | 24969.3965 | -1234400 | -1234400 | -1234400 | 1851600 | 1 | 2019-10-11 | 1 | 1 | 42001C | 2025-12-21 | X | AREA OF MINIMAL FLOOD HAZARD | 170.5643 | 181.9495 | 175.1560 | CC | 6.5500 | PERSON | REMAINING LANDS 22I05-0013F | 6541 | 695 | ||||||||||||||||||||||||||||||||
| 30G16-0004G--000 | 42 | 001 | 50 PATTERSON RD | GETTYSBURG | PA | L-0005 | COOL DAVID R & DEBRA D ET AL | 50 PATTERSON RD | GETTYSBURG | PA | 17325 | ADAMS | 51640 | MOUNT JOY | 031201 | 312.0100 | 5906.1413 | -592400 | -592400 | -592400 | 888600 | 1 | 2006-12-22 | 1 | 1 | 42001C | 2025-12-21 | X | AREA OF MINIMAL FLOOD HAZARD | 153.3531 | 156.4257 | 154.9796 | R | 1.5900 | PERSON | PART OF 30G16-0004 | 4687 | 267 | ||||||||||||||||||||||||||||||||
| 43024-0058---000 | 42 | 001 | 401 COUNTRY CLUB TRL UNIT L-0073 | FAIRFIELD | PA | 17320 | HIGH DINA L | 403 COUNTRY CLUB TRL | FAIRFIELD | PA | 17320 | ADAMS | 11472 | CARROLL VALLEY | 031600 | 316 | 2753.1846 | -73000 | -73000 | -73000 | 109500 | 10000 | 2008-03-14 | 1 | 1 | 42001C | 2025-12-21 | X | AREA OF MINIMAL FLOOD HAZARD | 170.2140 | 190.0242 | 180.0272 | L1 | 0.7700 | PERSON | LOT NO 73 SEC C | 5141 | 266 | ||||||||||||||||||||||||||||||||
| 08021-0134---000 | 42 | 001 | 23 STAR DR UNIT L-0110B | HANOVER | PA | 17331 | WALKINS RACHAEL | 23 STAR DR | HANOVER | PA | 17331 | ADAMS | 15632 | CONEWAGO | 031000 | 310 | 464.6462 | -331400 | -331400 | -331400 | 497100 | 178000 | 2020-08-14 | 1 | 1 | 42001C | 2025-12-21 | X | AREA OF MINIMAL FLOOD HAZARD | 166.5318 | 169.7675 | 168.5049 | R | 0.1100 | PERSON | 5,000 SF | 6650 | 635 | ||||||||||||||||||||||||||||||||
| 08009-0064---000 | 42 | 001 | 17 LINCOLN DR | HANOVER | PA | 17331 | GRIMM MEGHAN ALEXANDRA | 17 LINCOLN DR | HANOVER | PA | 17331 | ADAMS | 15632 | CONEWAGO | 031101 | 311.0100 | 2080.8308 | -345800 | -345800 | -345800 | 518700 | 260000 | 2023-03-31 | 1 | 1 | 42001C | 2025-12-21 | X | AREA OF MINIMAL FLOOD HAZARD | 180.4067 | 181.1936 | 180.7111 | R | 0.5000 | PERSON | 21,611 SF | 7078 | 523 | ||||||||||||||||||||||||||||||||
| 18C12-0075---000 | 42 | 001 | 1740 CARROLLS TRACT RD | ORRTANNA | PA | 17353 | WILES CORTNEY E | 1740 CARROLLS TRACT RD | ORRTANNA | PA | 17353 | ADAMS | 32200 | HAMILTONBAN | 031700 | 317 | 1023.8554 | -299000 | -299000 | -299000 | 448500 | 134900 | 2017-05-18 | 1 | 1 | 42001C | 2025-12-21 | X | AREA OF MINIMAL FLOOD HAZARD | 199.8691 | 204.3930 | 203.0934 | R | 0.2400 | PERSON | 10,572.97 SF | 6264 | 68 | ||||||||||||||||||||||||||||||||
| 30H16-0073---000 | 42 | 001 | 25 CALIFORNIA RD | LITTLESTOWN | PA | 17340 | REICHART JAMES R & TONIA R | 325 BULK PLANT RD | LITTLESTOWN | PA | 17340 | ADAMS | 51640 | MOUNT JOY | 031201 | 312.0100 | 2019.7801 | -335000 | -335000 | -335000 | 502500 | 124000 | 2015-12-17 | 1 | 1 | 42001C | 2025-12-21 | X | AREA OF MINIMAL FLOOD HAZARD | 178.3133 | 179.6878 | 179.0630 | R | 0.5300 | PERSON | COMBINED W/ 30H16-0073A--000 | 6096 | 756 | ||||||||||||||||||||||||||||||||
| 38G10-0602---000 | 42 | 001 | 28 W ASTER WAY | GETTYSBURG | PA | L-C071 | CIGNA EDWARD & CATHERINE | 28 W ASTER WAY | GETTYSBURG | PA | 17325 | ADAMS | 74680 | STRABAN | 030600 | 306 | 838.9921 | -864400 | -864400 | -864400 | 1296600 | 552570 | 2024-06-06 | 1 | 1 | 42001C | 2025-12-21 | X | AREA OF MINIMAL FLOOD HAZARD | 168.3903 | 170.5385 | 169.4113 | R | 0.2100 | PERSON | 9,025 SF | 7213 | 772 | ||||||||||||||||||||||||||||||||
| 30H16-0091A--000 | 42 | 001 | 636 HOFFMAN HOME RD | GETTYSBURG | PA | 17325 | BENNETT JAMES D & CAROLYN W JR | 636 HOFFMAN HOME RD | GETTYSBURG | PA | 17325 | ADAMS | 51640 | MOUNT JOY | 031201 | 312.0100 | 2901.7771 | -386000 | -386000 | -386000 | 579000 | 177000 | 2019-03-27 | 1 | 1 | 42001C | 2025-12-21 | X | AREA OF MINIMAL FLOOD HAZARD | 178.7100 | 181.6260 | 180.0593 | R | 0.8500 | PERSON | 37,202 SF | 6472 | 794 | ||||||||||||||||||||||||||||||||
| 38G09-0025C--000 | 42 | 001 | 20 RENTZEL RD | GETTYSBURG | PA | 17325 | SRACIC MICHAEL & FRANCIS P | 20 RENTZEL RD | GETTYSBURG | PA | 17325 | ADAMS | 74680 | STRABAN | 030600 | 306 | 224302.7954 | -1671800 | -1671800 | -1671800 | 2507700 | 1 | 2024-01-08 | 1 | 1 | 42001C | 2025-12-21 | X | AREA OF MINIMAL FLOOD HAZARD | 164.5213 | 170.6481 | 167.6253 | A | 56.3100 | PERSON | COMBINED W/38G09-0034A | 7169 | 232 | ||||||||||||||||||||||||||||||||
| 09E11-0041---000 | 42 | 001 | 1755 MUMMASBURG RD | GETTYSBURG | PA | 17325 | STONE BARRY D | 1745 MUMMASBURG RD | GETTYSBURG | PA | 17325 | ADAMS | 17640 | CUMBERLAND | 031401 | 314.0100 | 1514.8183 | -203000 | -203000 | -203000 | 304500 | 1 | 2023-01-18 | 1 | 1 | 42001C | 2025-12-21 | X | AREA OF MINIMAL FLOOD HAZARD | 188.0824 | 190.0944 | 189.0767 | RT | 0.4100 | PERSON | 17,997 SF | 7057 | 325 | ||||||||||||||||||||||||||||||||
| 36105-0004---000 | 42 | 001 | 54 LAKE MEADE DR UNIT M-0381 | EAST BERLIN | PA | 17316 | ZABAVSKY DESANKA | 54 LAKE MEADE DR | EAST BERLIN | PA | 17316 | ADAMS | 63616 | READING | 030103 | 301.0299 | 1643.9194 | -729400 | -729400 | -729400 | 1094100 | 1 | 2020-12-18 | 1 | 1 | 42001C | 2025-12-21 | X | AREA OF MINIMAL FLOOD HAZARD | 151.8188 | 162.4611 | 158.7958 | R | 0.4100 | PERSON | 17,697 SF | 6713 | 490 | ||||||||||||||||||||||||||||||||
| 08K14-0244---000 | 42 | 001 | 86 RAINBOW DR UNIT L-0021 | HANOVER | PA | 17331 | HITESHEW JAMES A | 86 RAINBOW DR | HANOVER | PA | 17331 | ADAMS | 15632 | CONEWAGO | 031102 | 311.0200 | 2063.1680 | -673200 | -673200 | -673200 | 1009800 | 327840 | 2016-09-23 | 1 | 1 | 42001C | 2025-12-21 | X | AREA OF MINIMAL FLOOD HAZARD | 160.4424 | 162.9163 | 161.7718 | R | 0.5100 | PERSON | PART OF 08K14-0001AA-000 | 6185 | 494 | ||||||||||||||||||||||||||||||||
| 30110-0002---000 | 42 | 001 | 14 JACKSON RD UNIT H-0014 | GETTYSBURG | PA | 17325 | COLBERT BRIAN R | 14 JACKSON RD | GETTYSBURG | PA | 17325 | ADAMS | 51640 | MOUNT JOY | 031201 | 312.0100 | 1463.2132 | -401200 | -401200 | -401200 | 601800 | 270000 | 2022-07-15 | 1 | 1 | 42001C | 2025-12-21 | X | AREA OF MINIMAL FLOOD HAZARD | 153.7579 | 156.8958 | 154.8140 | R | 0.3600 | PERSON | 15,750 SF | 6988 | 428 | ||||||||||||||||||||||||||||||||
| 27005-0136---000 | 42 | 001 | 64 CROUSE PARK | LITTLESTOWN | PA | 17340 | MOUL DANIEL P & LORI A | 45 SANDY CT | HANOVER | PA | 17331 | ADAMS | 43944 | LITTLESTOWN | 031300 | 313 | 411.8985 | -255800 | -255800 | -255800 | 383700 | 1 | 2020-02-03 | 1 | 1 | 42001C | 2025-12-21 | X | AREA OF MINIMAL FLOOD HAZARD | 182.2226 | 182.7568 | 182.4999 | R | 0.1000 | PERSON | 4,407 SF | 6581 | 421 | ||||||||||||||||||||||||||||||||
| 28005-0108---000 | 42 | 001 | 621 NORTH ST | MCSHERRYSTOWN | PA | 17344 | SMITH WAYNE J SR | 621 NORTH ST | MCSHERRYSTOWN | PA | 17344 | ADAMS | 46376 | MCSHERRYSTOWN | 031101 | 311.0100 | 768.4828 | -281800 | -281800 | -281800 | 422700 | 1 | 2024-11-18 | 1 | 1 | 42001C | 2025-12-21 | X | AREA OF MINIMAL FLOOD HAZARD | 175.4031 | 178.6371 | 176.9520 | R | 0.2000 | PERSON | 8,580 SF | 7270 | 531 |