Data Explorer
Query the US Nationwide Parcel Dataset
$1.75 / 1,000 records$100 minimum
27/80
Live SQL
SELECT * FROM "lr_parcel_us" WHERE statefp = '42'
6,011,253 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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 23J03-0004---000 | 42 | 001 | 160 LATIMORE VALLEY RD | PA | CHASE SARA JEANNE | 518 CARLISLE ST | HANOVER | PA | 17331 | ADAMS | 41672 | LATIMORE | 030101 | 301.0100 | 339001.6515 | 354100 | 354100 | 354100 | 0 | 1 | 2014-02-11 | 42001C | 2025-12-21 | X | AREA OF MINIMAL FLOOD HAZARD | 151.0464 | 166.7707 | 157.3508 | A | 87.2700 | PERSON | PARCEL 1 | 5915 | 559 | GOVT LOCAL | CLOSED | ADAMS COUNTY AGRICULTURAL EASEM… | AGRICULTURAL EASEMENT | 2026.2 | ||||||||||||||||||||||||||||||||
| 07G07-0034---000 | 42 | 001 | 1279 STONE JUG RD | PA | ADAMIK THERESA A | 1279 STONE JUG RD | ASPERS | PA | 17304 | ADAMS | 10456 | BUTLER | 030500 | 305 | 531869.0946 | 309400 | 309400 | 309400 | 0 | 1 | 2017-06-21 | 42001C | 2025-12-21 | X | AREA OF MINIMAL FLOOD HAZARD | A | 134.9000 | PERSON | SURVEY 2011, COMBINED W/07G07-0… | 6274 | 187 | NGO | CLOSED | OTHER | 2011-05 | AGRICULTURAL EASEMENT | 2026.2 | ||||||||||||||||||||||||||||||||||
| 0103007170 | 0019 | 42 | 009 | 14200 DOUBLE PINE RD NE | FLINTSTONE | PA | 21530 | PINEY RUN GUN CLUB INC | 13505 BEALLS MILL RD NE | CUMBERLAND | MD | 21502 | BEDFORD | 46928 | MANN | 961001 | 9610.0100 | 2847.8643 | 45600 | 82200 | 127800 | 1 | 1 | 1882 | 872 | 42009C | 2025-12-21 | X | AREA OF MINIMAL FLOOD HAZARD | 322.8411 | 333.3017 | 328.2121 | 27.5800 | NONPROFIT | IMPS27.582A | 00355 | 0347 | 2026.2 | ALLE | ||||||||||||||||||||||||||||||||
| 36K08-0023---000 | 42 | 001 | 444 BROWNS DAM RD | PA | SHEMON MICHAEL L | 444 BROWNS DAM RD | NEW OXFORD | PA | 17350 | ADAMS | 63616 | READING | 030104 | 301.0400 | 326736.8819 | 457300 | 457300 | 457300 | 0 | 1 | 2021-01-22 | 42001C | 2025-12-21 | X | AREA OF MINIMAL FLOOD HAZARD | 128.8009 | 152.9250 | 141.6161 | A | 84.3100 | PERSON | CLOSURE ERROR, AC. PLOTTED FRO… | 6732 | 637 | 2026.2 | ||||||||||||||||||||||||||||||||||||
| 27014-0057---000 | 42 | 001 | 274 S COLUMBUS AVE UNIT L-0147 | PA | TOMPKINS IVAN C & CAHTERINE E | 274 S COLUMBUS AVE | LITTLESTOWN | PA | 17340 | ADAMS | 43944 | LITTLESTOWN | 031300 | 313 | 1204.2769 | 167400 | 167400 | 167400 | 0 | 1 | 2015-04-02 | 42001C | 2025-12-21 | X | AREA OF MINIMAL FLOOD HAZARD | 185.5657 | 187.0562 | 186.2506 | R | 0.2800 | PERSON | 6019 | 414 | 2026.2 | |||||||||||||||||||||||||||||||||||||
| 38H11-0001---000 | 42 | 001 | 1731 HUNTERSTOWN RD | PA | KESTREL ACQUISITION LLC | 8403 COLESVILLE RD SUITE 915 | SILVER SPRING | MD | 20910 | ADAMS | 74680 | STRABAN | 030600 | 306 | 1186128.1655 | 17304500 | 17304500 | 17304500 | 0 | 10 | 2018-06-06 | 42001C | 2025-12-21 | X | AREA OF MINIMAL FLOOD HAZARD | I | 298.9100 | BUSINESS | 14 TRACTS, AC. PLOTTED FROM DE… | 6385 | 180 | NRG ENERGY | PUBLIC_UTILITY | 2026.2 | |||||||||||||||||||||||||||||||||||||
| 06009-0040A--000 | 42 | 001 | UNASSIGNED | PA | S & A CUSTOM BUILT HOMES INC | 2121 OLD GATESBURG RD #200 | STATE COLLEGE | PA | 16803 | ADAMS | 07560 | BONNEAUVILLE | 030700 | 307 | 81256.6665 | 879800 | 879800 | 879800 | 0 | 42001C | 2025-12-21 | X | AREA OF MINIMAL FLOOD HAZARD | 186.8111 | 196.1933 | 190.4363 | CL | 14.4900 | BUSINESS | 3167 | 98 | 2026.2 | |||||||||||||||||||||||||||||||||||||||
| 05002-0007---000 | 42 | 001 | 350 E YORK ST | PA | EYLER ROY K | 350 E YORK ST | BIGLERVILLE | PA | 17307 | ADAMS | 06296 | BIGLERVILLE | 030500 | 305 | 1283.6740 | 135200 | 135200 | 135200 | 0 | 1 | 42001C | 2025-12-21 | X | AREA OF MINIMAL FLOOD HAZARD | 195.7617 | 198.1633 | 197.1446 | RC | 0.2600 | PERSON | 364 | 827 | 2026.2 | ||||||||||||||||||||||||||||||||||||||
| 27J17-0054---000 | 42 | 001 | 635 HANOVER PIKE | PA | MAYBERRY AT MASON DIXON LLC | 126 ONYX RD | NEW OXFORD | PA | 17350 | ADAMS | 43944 | LITTLESTOWN | 031300 | 313 | 431904.6716 | 907200 | 907200 | 907200 | 0 | 1 | 2023-05-10 | 42001C | 2025-12-21 | X | AREA OF MINIMAL FLOOD HAZARD | CL | 107.2100 | BUSINESS | DEED 7107-122 PENN DOT R/W 0.22… | 7090 | 770 | 2026.2 | |||||||||||||||||||||||||||||||||||||||
| 40I07-0044---000 | 42 | 001 | 775 FIVE POINTS RD | PA | HILLANDALE GETTYSBURG LP | 3910 OXFORD RD | GETTYSBURG | PA | 17325 | ADAMS | 78160 | TYRONE | 030200 | 302 | 983542.0219 | 12926700 | 12926700 | 12926700 | 0 | 1 | 2021-06-02 | 42001C | 2025-12-21 | X | AREA OF MINIMAL FLOOD HAZARD | A | 248.2200 | BUSINESS | COMBINED W/40I07-0049 | 7149 | 12 | 2026.2 | |||||||||||||||||||||||||||||||||||||||
| 22H04-0018B--000 | 42 | 001 | 1117 FARM VIEW RD | PA | BONNIE BRAE FRUIT FARMS INC | 1230 IDAVILLE-YORK SPRINGS RD | GARDNERS | PA | 17324 | ADAMS | 36424 | HUNTINGTON | 030200 | 302 | 858794.1374 | 363300 | 363300 | 363300 | 0 | 650000 | 2012-01-09 | 42001C | 2025-12-21 | X | AREA OF MINIMAL FLOOD HAZARD | A | 216.7000 | BUSINESS | COMBINED WITH H4-18A | 5665 | 474 | 2026.2 | |||||||||||||||||||||||||||||||||||||||
| 40G04-0093---000 | 42 | 001 | OLD CARLISLE ROAD | PA | BEAR MOUNTAIN ORCHARDS INC | 1415 POTATO RD | ASPERS | PA | 17304 | ADAMS | 78160 | TYRONE | 030200 | 302 | 549664.0548 | 156900 | 156900 | 156900 | 0 | 750000 | 2022-07-15 | 42001C | 2025-12-21 | X | AREA OF MINIMAL FLOOD HAZARD | AO | 142.6500 | BUSINESS | NEW SURVEY 2022 | 6988 | 329 | 2026.2 | |||||||||||||||||||||||||||||||||||||||
| 22I06-0023---000 | 42 | 001 | 910 WEIRMANS MILL RD | PA | RUDOLPH DENNIS J & ROSANNE | 910 WEIRMANS MILL RD | YORK SPRINGS | PA | 17372 | ADAMS | 36424 | HUNTINGTON | 030200 | 302 | 564499.3485 | 526000 | 526000 | 526000 | 0 | 800000 | 2015-10-30 | 42001C | 2025-12-21 | X | AREA OF MINIMAL FLOOD HAZARD | A | 144.4900 | PERSON | 6082 | 1 | 2026.2 | ||||||||||||||||||||||||||||||||||||||||
| 0134005214 | 0128 | 42 | 009 | PA | HELM MICHAEL A | PSC 2 BOX 5879 | APO AE | FC | 09012 | BEDFORD | 17664 | CUMBERLAND VALLEY | 961100 | 9611 | 2857.2554 | 800 | 800 | 800 | 0 | 0 | 42009C | 2025-12-21 | X | AREA OF MINIMAL FLOOD HAZARD | 249.8142 | 281.3441 | 261.9120 | 0.0800 | PERSON | 14431 HAZEN RD ADJ | 02170 | 0068 | 2026.2 | ALLE | |||||||||||||||||||||||||||||||||||||
| 14006303 | 14006303 | 42 | 055 | FIRST AVE | CASCADE | PA | 21719 | CCHL PROPERTIES LLC | 30 EMLYN LN | MECHANICSBURG | PA | 17055 | FRANKLIN | 81240 | WASHINGTON | 012502 | 125.0200 | 5837.2957 | 42055C | 2025-12-21 | X | AREA OF MINIMAL FLOOD HAZARD | R | 1.4422 | BUSINESS | LOT 0.15 ACRESFIRST AVEBLUE RI… | 07481 | 0409 | 2026.2 | 14 | |||||||||||||||||||||||||||||||||||||||||
| 27000282 | 27000282 | 42 | 055 | PENNSYLVANIA AVE | HAGERSTOWN | PA | 21742 | HARTLE DANA TRUSTEE L/E FOR ALE… | 17809 GREENTREE TER | HAGERSTOWN | MD | 21740 | FRANKLIN | 02696 | ANTRIM | 011900 | 119 | 390.1068 | 42055C | 2025-12-21 | X | AREA OF MINIMAL FLOOD HAZARD | R | 0.0963 | TRUST | LOT 40X72E/S MIDDLEBURG PIKE | 07328 | 0005 | 2026.2 | 27 | |||||||||||||||||||||||||||||||||||||||||
| 14010467 | 14010467 | 42 | 055 | FIRST AVE | CASCADE | PA | 21719 | WILLARD PAUL C | 5920 OLD FT RITCHIE ROAD | SABILLASVILLE | MD | 21780 | FRANKLIN | 81240 | WASHINGTON | 012502 | 125.0200 | 2722.1392 | 42055C | 2025-12-21 | X | AREA OF MINIMAL FLOOD HAZARD | R | 0.6729 | PERSON | RR LOTS 1-2 95X8524X85 FIRST AV… | 00723 | 0887 | 2026.2 | 14 | |||||||||||||||||||||||||||||||||||||||||
| 14011811 | 14011811 | 42 | 055 | WALDHEIM RD | CASCADE | PA | 21719 | HOOVER WARREN B JR | 6925 E TURNER CAMP RD | INVERNESS | FL | 34453 | FRANKLIN | 81240 | WASHINGTON | 012502 | 125.0200 | 591.0315 | 42055C | 2025-12-21 | X | AREA OF MINIMAL FLOOD HAZARD | R | 0.1458 | PERSON | PTLT IRRG .07 AC (GWALDHEIM RO… | 00796 | 0147 | 2026.2 | 14 | |||||||||||||||||||||||||||||||||||||||||
| 14000666 | 14000666 | 42 | 055 | HILLTOP RD | CASCADE | PA | 21719 | GRIMM JARED E ERFURDT KELLY M | 14714 HILLTOP RD | CASCADE | MD | 21719 | FRANKLIN | 81240 | WASHINGTON | 012502 | 125.0200 | 4809.0818 | 42055C | 2025-12-21 | X | AREA OF MINIMAL FLOOD HAZARD | R | 1.1888 | PERSON | LOT 0.506 ACRES14714 HILLTOP RD | 07635 | 0471 | 2026.2 | 14 | |||||||||||||||||||||||||||||||||||||||||
| 14008411 | 14008411 | 42 | 055 | PEN MAR RD | CASCADE | PA | 21719 | SAGI PROPERTY TWO LLC | C/O VALLEY PROP OF HAG LLC 921 … | HAGERSTOWN | MD | 21740 | FRANKLIN | 81240 | WASHINGTON | 012502 | 125.0200 | 1923.0045 | 42055C | 2025-12-21 | X | AREA OF MINIMAL FLOOD HAZARD | M | 0.4757 | BUSINESS | 0.436 ACRES24700 PEN MAR RDMASO… | 02481 | 0138 | 2026.2 | 14 | |||||||||||||||||||||||||||||||||||||||||
| 14010513 | 14010513 | 42 | 055 | FIRST AVE | CASCADE | PA | 21719 | JOHNSON RICHARD E JOHNSON KIM L | 13716 MONTEREY LN | BLUE RIDGE SUMMIT | PA | 17214 | FRANKLIN | 81240 | WASHINGTON | 012502 | 125.0200 | 16925.5035 | 42055C | 2025-12-21 | X | AREA OF MINIMAL FLOOD HAZARD | R | 4.1857 | PERSON | 1.874 ACRESBLUE RIDGE SUMMIT | 01353 | 0201 | 2026.2 | 14 | |||||||||||||||||||||||||||||||||||||||||
| 27004334 | 27004334 | 42 | 055 | PENNSYLVANIA AVE | HAGERSTOWN | PA | 21742 | EBY CURVIN EBY GLENNIS | 19534 REIDTOWN RD | HAGERSTOWN | MD | 21742 | FRANKLIN | 02696 | ANTRIM | 011900 | 119 | 1161.3051 | 42055C | 2025-12-21 | X | AREA OF MINIMAL FLOOD HAZARD | R | 0.2869 | PERSON | LOT 50X19114733 PENNSYLVANIA AVE | 07409 | 0174 | 2026.2 | 27 | |||||||||||||||||||||||||||||||||||||||||
| 0120001100 | 0070 | 42 | 111 | PA | DETRICK COLIN R-KEITH L ET UX | 413 SCENIC LN | RIDGELEY | WV | 26753 | SOMERSET | 71920 | SOUTHAMPTON | 021300 | 213 | 436.0371 | 2700 | 2700 | 0 | 0 | 42111C | 2025-12-21 | X | AREA OF MINIMAL FLOOD HAZARD | 628.5640 | 644.9381 | 636.9943 | 0.5000 | PERSON | 1/2A | 00377 | 0047 | 2026.2 | ALLE | ||||||||||||||||||||||||||||||||||||||
| 14010149 | 14010149 | 42 | 055 | WALDHEIM RD | CASCADE | PA | 21719 | A & L PROPERTIES LLC C/O DONALD… | 13630 POPLAR GROVE RD | HAGERSTOWN | MD | 21742 | FRANKLIN | 81240 | WASHINGTON | 012502 | 125.0200 | 104.7689 | 42055C | 2025-12-21 | X | AREA OF MINIMAL FLOOD HAZARD | R | 0.0257 | BUSINESS | 0.108 ACRE24714 WALDHEIM ROAD | 02913 | 0321 | 2026.2 | 14 | |||||||||||||||||||||||||||||||||||||||||
| 29900000010150020000 | 00000001462 | 42 | 105 | 6781 CO RD 18 | PA | MEAD LOUIS CHARLOTTE | POTTER | 69736 | SHARON | 950200 | 9502 | 809.0738 | 1998-07-15 | — | 464.3610 | 465.5199 | 464.8895 | 210 | 0.1998 | PERSON | 1 | 299 | 1 | T1 R1 SEC 299 | 1149 | 76 | 2026.2 |