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 = '51' AND countyfp = '790'
11,866 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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4714 | 1031457 | 51 | 790 | 310 ORCHARD AVE … | STAUNTON | VA | 24401 | DIAMOND DEVELOPMENT REAL ESTATE… | PO BOX 10113, BLACKSBURG, VA 2… | BLACKSBURG | VA | 24062 | Staunton | 95875 | Staunton | 000300 | 3 | 3082.6272 | 2006-10-06 | 1 | 1 | 32931 | 51015C | 2026-01-08 | X | AREA OF MINIMAL FLOOD HAZARD | 462.7510 | 475.2850 | 469.2883 | DWELLING, TOWNHOUSE | R3 | 0.7560 | BUSINESS | 71311 | LOT 280A(REV LOTS 278-281 INCL … | GOVT LOCAL | OPEN | GYPSEY HILL PARK | LOCAL PARK | |||||||||||||||||||||||||||||||
| 9474 | 1150722 | 51 | 790 | 216 FRONTIER DR … | STAUNTON | VA | 24401 | HALTERMAN, ABRAM R; TRUSTEE & S… | 9 MIDDLEBROOK AVE, STAUNTON, V… | STAUNTON | VA | 24401 | Staunton | 95875 | Staunton | 000600 | 6 | 12692.1968 | 2022-07-26 | 1 | 1 | 136387 | 51015C | 2026-01-08 | X | AREA OF MINIMAL FLOOD HAZARD | 445.1730 | 455.3450 | 449.1817 | RESTAURANTS | B2 | 3.1309 | TRUST | 722410 | LOT 1 | DICES NIGHT CLUB | BAR | |||||||||||||||||||||||||||||||||
| 7145 | 1151276 | 51 | 790 | 810 GRUBERT AVE … | STAUNTON | VA | 24401 | ANTIQUE AND CLASSIC AUTOMOBILES… | 502 ELLENDION AVE, STAUNTON, V… | STAUNTON | VA | 24401 | Staunton | 95875 | Staunton | 000300 | 3 | 1851.1386 | 2023-05-01 | 1 | 1 | 21997 | 51015C | 2026-01-08 | AE | 458.0870 | 464.9240 | 460.6715 | RETAIL | B1 | 0.5050 | BUSINESS | 44112 | (LOT 2 BLK A) … | ANTIQUE AND CLASSIC AUTOMOBILES… | AUTO_DEALER | ||||||||||||||||||||||||||||||||||
| 8198 | 1124160 | 51 | 790 | 1915 W BEVERLEY ST … | STAUNTON | VA | 24401 | VALLEY OIL CORP … | P O BOX 364, STAUNTON, VA 24402 | STAUNTON | VA | 24402 | Staunton | 95875 | Staunton | 000300 | 3 | 1877.9045 | 1969-08-04 | 1 | 1 | 20908 | 51015C | 2026-01-08 | X | AREA OF MINIMAL FLOOD HAZARD | 463.5140 | 468.9790 | 464.6425 | CONVENIENCE STORE | B2 | 0.4800 | BUSINESS | 457110 | LOTS 21-24 SEC 4 1ST GRAY LOT 1… | ROYAL | GAS_STATION | |||||||||||||||||||||||||||||||||
| 7888 | 1145392 | 51 | 790 | 420 CARTER ST … | STAUNTON | VA | 24401 | RSSHUTTERLEE LLC | 3007 SHUTTERLEE MILL RD, STAUN… | STAUNTON | VA | 24401 | Staunton | 95875 | Staunton | 000401 | 4.0100 | 777.3799 | 2019-08-13 | 1 | 1 | 7100 | 51015C | 2026-01-08 | X | AREA OF MINIMAL FLOOD HAZARD | 447.4759 | 452.3680 | 450.6448 | DWELLING, SINGLE-FAMILY | R3 | 0.1630 | BUSINESS | 4855 | BLK 13 N POR LOT 1 & 2 … | |||||||||||||||||||||||||||||||||||
| 10093 | 1152224 | 51 | 790 | 1320 MIDDLEBROOK AVE … | STAUNTON | VA | 24401 | STAUNTON AUGUSTA PROPERTIES, LLC | 939 N AUGUSTA ST , STAUNTON, VA… | STAUNTON | VA | 24401 | Staunton | 95875 | Staunton | 000600 | 6 | 292108.1160 | 2024-09-25 | 1 | 1 | 3034781 | 51015C | 2026-01-08 | X | AREA OF MINIMAL FLOOD HAZARD | 449.9819 | 517.6129 | 481.0449 | RESIDENTIAL LAND (LOW DENSITY) | R2 | 69.6690 | BUSINESS | 5312 | PARCEL 68 69.67 ACRES PEMBERTO… | |||||||||||||||||||||||||||||||||||
| 3851 | 1148834 | 51 | 790 | 12 CHURCHVILLE AVE … | STAUNTON | VA | 24401 | JUSTICE REAL ESTATE, LLC | 201 NIGHTHAWK RD, LYNCHBURG, VA… | LYNCHBURG | VA | 24504 | Staunton | 95875 | Staunton | 000100 | 1 | 553.2177 | 2020-03-27 | 1 | 1 | 6185 | 51015C | 2026-01-08 | X | AREA OF MINIMAL FLOOD HAZARD | 434.3810 | 435.8009 | 434.8774 | GENERAL BUSINESS DISTRICT | B2 | 0.1419 | BUSINESS | 2372 | (POR LOT 12 & ALL LOT 13 & PARC… | |||||||||||||||||||||||||||||||||||
| 7056 | 1147741 | 51 | 790 | 321 FAYETTE ST … | STAUNTON | VA | 24401 | SCHNITZHOFER REAL ESTATE LLC | 928 ROCKWAY ST STAUNTON, VA 24… | STAUNTON | VA | 24401 | Staunton | 95875 | Staunton | 000100 | 1 | 903.4198 | 2018-07-30 | 1 | 1 | 9024 | 51015C | 2026-01-08 | X | AREA OF MINIMAL FLOOD HAZARD | 425.8810 | 433.9760 | 429.5815 | RESIDENTIAL LAND (LOW DENSITY) | R4 | 0.2070 | BUSINESS | 5312 | (LOT 28 BLK D) … | |||||||||||||||||||||||||||||||||||
| 4594 | 1146910 | 51 | 790 | 107 W BEVERLEY ST … | STAUNTON | VA | 24401 | CHURCH SCHOOLS IN THE DIOCESE O… | 235 W FREDERICK ST, STAUNTON, … | STAUNTON | VA | 24401 | Staunton | 95875 | Staunton | 000100 | 1 | 626.1335 | 2017-04-11 | 1 | 1 | 7013 | 51015C | 2026-01-08 | X | AREA OF MINIMAL FLOOD HAZARD | 428.8070 | 430.7690 | 429.8706 | RETAIL | B2 | 0.1610 | NONPROFIT | 6111 | (LOT 10(REV)BLK Q) (INCL 105-10… | |||||||||||||||||||||||||||||||||||
| 102162 | 1150314 | 51 | 790 | 105 SOUTHVIEW DR | STAUNTON | VA | 24401 | AUGUSTA OPPORTUNITIES, INC | P.O. BOX 2648, STAUNTON, VA 244… | STAUNTON | VA | 24402 | Staunton | 95875 | Staunton | 000402 | 4.0199 | 752.2727 | 2025-07-03 | 1 | 1 | 8103 | 51015C | 2026-01-08 | X | AREA OF MINIMAL FLOOD HAZARD | 460.2090 | 465.8550 | 463.0158 | RESIDENTIAL LAND (LOW DENSITY) | R4 | 0.1860 | BUSINESS | 4869 | LOT 236, SECTION 5 SOUTH VIEW | |||||||||||||||||||||||||||||||||||
| 8216 | 1148094 | 51 | 790 | 301 INSTITUTE ST … | STAUNTON | VA | 24401 | TETON PROPERTIES LLC | P O BOX 1968, STAUNTON, VA 244… | STAUNTON | VA | 24402 | Staunton | 95875 | Staunton | 000300 | 3 | 1049.7807 | 2019-02-26 | 1 | 1 | 12066 | 51015C | 2026-01-08 | X | AREA OF MINIMAL FLOOD HAZARD | 461.2120 | 474.1579 | 467.4682 | DWELLING, TWO-FAMILY (DUPLEX) | R4 | 0.2770 | BUSINESS | 5312 | LOTS 3 & 4 … | |||||||||||||||||||||||||||||||||||
| 2802 | 1148198 | 51 | 790 | 610 CHERRY HILL DR … | STAUNTON | VA | 24401 | RAMSEY RENTALS, LLC | 1672 BARTERBROOK RD, STAUNTON,… | STAUNTON | VA | 24401 | Staunton | 95875 | Staunton | 000401 | 4.0100 | 659.5633 | 2019-04-26 | 1 | 1 | 7013 | 51015C | 2026-01-08 | X | AREA OF MINIMAL FLOOD HAZARD | 456.4670 | 458.9389 | 457.4634 | DWELLING, SINGLE-FAMILY | R2 | 0.1610 | BUSINESS | 53212 | LOT 10 … | |||||||||||||||||||||||||||||||||||
| 2275 | 1123620 | 51 | 790 | 341 DUPONT AVE … | STAUNTON | VA | 24401 | TWW PROPERTIES LLC … | P O BOX 232, WEYERS CAVE, VA 2… | WEYERS CAVE | VA | 24486 | Staunton | 95875 | Staunton | 000300 | 3 | 696.5554 | 2016-03-02 | 1 | 1 | 6969 | 51015C | 2026-01-08 | X | AREA OF MINIMAL FLOOD HAZARD | 456.8519 | 463.5520 | 460.3571 | DWELLING, SINGLE-FAMILY | R3 | 0.1600 | BUSINESS | 5312 | BLK 8 LOT 1 … | |||||||||||||||||||||||||||||||||||
| 12327 | 1019510 | 51 | 790 | 118 CARRSBROOK DR … | STAUNTON | VA | 24401 | CARRSBROOK PROPERTY OWNERS, ASS… | P O BOX 388, STAUNTON, VA 24402 | STAUNTON | VA | 24402 | Staunton | 95875 | Staunton | 000402 | 4.0199 | 18107.1928 | 2006-01-03 | 1 | 1 | 195802 | 51015C | 2026-01-08 | X | AREA OF MINIMAL FLOOD HAZARD | 441.2070 | 469.6000 | 448.8228 | RESIDENTIAL LAND (LOW DENSITY) | R3c | 4.4950 | NONPROFIT | 81391 | PHASE 3 GREEN SPACE 3.783AC; 0.… | |||||||||||||||||||||||||||||||||||
| 4563 | 1148448 | 51 | 790 | 513 BRIDGE ST … | STAUNTON | VA | 24401 | BISCUIT WAREHOUSE, LLC | P.O. BOX 1273, STAUNTON, VA 24… | STAUNTON | VA | 24402 | Staunton | 95875 | Staunton | 000600 | 6 | 594.6366 | 2019-08-20 | 1 | 1 | 4922 | 51015C | 2026-01-08 | AE | FLOODWAY | 422.9620 | 424.5969 | 424.0361 | GENERAL BUSINESS DISTRICT | I2 | 0.1130 | BUSINESS | 49311 | (LOT 9 BLK E) … | |||||||||||||||||||||||||||||||||||
| 12187 | 1151353 | 51 | 790 | 200 COLLINSWOOD DR … | STAUNTON | VA | 24401 | THOMASON, DORIS D | 200 COLLINSWOOD DR, STAUNTON, … | STAUNTON | VA | 24401 | Staunton | 95875 | Staunton | 000401 | 4.0100 | 401.6073 | 2023-06-09 | 1 | 1 | 4268 | 51015C | 2026-01-08 | X | AREA OF MINIMAL FLOOD HAZARD | 493.0310 | 494.9280 | 494.1229 | DWELLING, SINGLE-FAMILY | R4 | 0.0980 | PERSON | LOT 19 0.099 AC … | ||||||||||||||||||||||||||||||||||||
| 6909 | 1148221 | 51 | 790 | 1515 CHURCHVILLE AVE … | STAUNTON | VA | 24401 | RICHARDSON, AARON M & NEUMEISTE… | 1515 CHURCHVILLE AVE, STAUNTON… | STAUNTON | VA | 24401 | Staunton | 95875 | Staunton | 000401 | 4.0100 | 3739.6177 | 2021-08-30 | 1 | 1 | 35980 | 51015C | 2026-01-08 | X | AREA OF MINIMAL FLOOD HAZARD | 465.8840 | 481.8900 | 474.7326 | DWELLING, SINGLE-FAMILY | R2 | 0.8260 | PERSON | POR LOT 13 … | ||||||||||||||||||||||||||||||||||||
| 880 | 1150003 | 51 | 790 | 1211 DONAGHE ST … | STAUNTON | VA | 24401 | MARGUEZ, JUAN VICENTE DIAZ & MA… | 1211 DONAGHE ST, STAUNTON, VA … | STAUNTON | VA | 24401 | Staunton | 95875 | Staunton | 000402 | 4.0199 | 1289.4946 | 2021-09-15 | 1 | 1 | 12153 | 51015C | 2026-01-08 | X | AREA OF MINIMAL FLOOD HAZARD | 465.0920 | 469.0079 | 467.1556 | DWELLING, SINGLE-FAMILY | R2 | 0.2790 | PERSON | LOT 2 MOORE ADD ADJ GIBSON … | ||||||||||||||||||||||||||||||||||||
| 1534 | 1109048 | 51 | 790 | 806 LAMMERMOOR DR … | STAUNTON | VA | 24401 | SIMMONS, ROBYN C … | 1065 DUCK RUN RD, PENN LAIRD, … | PENN LAIRD | VA | 22846-9756 | Staunton | 95875 | Staunton | 000500 | 5 | 2012.6981 | 2010-11-30 | 1 | 1 | 22302 | 51015C | 2026-01-08 | X | AREA OF MINIMAL FLOOD HAZARD | 415.4809 | 421.0729 | 418.3400 | DWELLING, SINGLE-FAMILY | R1 | 0.5120 | PERSON | BLK B LOT 15 UNIT 7 … | ||||||||||||||||||||||||||||||||||||
| 1798 | 1132906 | 51 | 790 | 804 BURWELL AVE … | STAUNTON | VA | 24401 | WINDLEY, JOSHUA E & SILVIA C … | 27 TAYLOR ST, STAUNTON, VA 244… | STAUNTON | VA | 24401-2514 | Staunton | 95875 | Staunton | 000402 | 4.0199 | 493.6059 | 2006-06-02 | 1 | 1 | 5314 | 51015C | 2026-01-08 | X | AREA OF MINIMAL FLOOD HAZARD | 458.1489 | 462.6109 | 460.6355 | DWELLING, SINGLE-FAMILY | R2 | 0.1220 | PERSON | LOT 5 … | ||||||||||||||||||||||||||||||||||||
| 3724 | 1150216 | 51 | 790 | 2525 N SHARLAINE DR … | STAUNTON | VA | 24401 | SHICKLE, MELISSA DAWN | 2525 N SHARLAINE DR, STAUNTON,… | STAUNTON | VA | 24401 | Staunton | 95875 | Staunton | 000300 | 3 | 685.8260 | 2021-12-16 | 1 | 1 | 7884 | 51015C | 2026-01-08 | X | AREA OF MINIMAL FLOOD HAZARD | 481.5939 | 488.4970 | 485.2173 | DWELLING, SINGLE-FAMILY | R2 | 0.1810 | PERSON | BLK A LOT 1 UNIT 2 … | ||||||||||||||||||||||||||||||||||||
| 6013 | 1148106 | 51 | 790 | 203 S ST CLAIR ST … | STAUNTON | VA | 24401 | MCDOWELL, ANDREW S & MCDOWELL, … | 203 S ST CLAIR ST, STAUNTON, V… | STAUNTON | VA | 24401 | Staunton | 95875 | Staunton | 000100 | 1 | 1315.4124 | 2023-09-29 | 1 | 1 | 14287 | 51015C | 2026-01-08 | X | AREA OF MINIMAL FLOOD HAZARD | 439.5120 | 448.4779 | 443.7349 | DWELLING, SINGLE-FAMILY | R4 | 0.3280 | PERSON | (LOT 5 BLK YY) … | ||||||||||||||||||||||||||||||||||||
| 1623 | 1150146 | 51 | 790 | 1 BARRISTERS ROW … | STAUNTON | VA | 24401 | BARRISTERS ROW STAUNTON, LLC | 2903 N AUGUSTA ST, STAUNTON, V… | STAUNTON | VA | 24401 | Staunton | 95875 | Staunton | 000100 | 1 | 492.8655 | 2021-11-19 | 1 | 1 | 6070 | 51015C | 2026-01-08 | AE | 422.4649 | 423.8179 | 423.1303 | GENERAL OFFICE | B2 | 0.1390 | BUSINESS | 3325 | LOT 1R | ||||||||||||||||||||||||||||||||||||
| 10637 | 1145212 | 51 | 790 | 103 SMITHLEIGH CR … | STAUNTON | VA | 24401 | FARRELL, JAMES JR, TRS … | 103 SMITHLEIGH CR, STAUNTON, V… | STAUNTON | VA | 24401 | Staunton | 95875 | Staunton | 000402 | 4.0199 | 1685.6584 | 2014-05-23 | 1 | 1 | 18208 | 51015C | 2026-01-08 | X | AREA OF MINIMAL FLOOD HAZARD | 434.0809 | 439.8469 | 437.1449 | DWELLING, SINGLE-FAMILY | R1 | 0.4180 | TRUST | LOT 9 SEC 2 … | ||||||||||||||||||||||||||||||||||||
| 6978 | 1046031 | 51 | 790 | 3 SHANNON PL … | STAUNTON | VA | 24401 | COBB 2018 IR, LLC | 1 RED DEER PL, STAUNTON, VA 244… | STAUNTON | VA | 24401 | Staunton | 95875 | Staunton | 000402 | 4.0199 | 239.1986 | 2026-05-01 | 1 | 1 | 2787 | 51015C | 2026-01-08 | X | AREA OF MINIMAL FLOOD HAZARD | 448.7900 | 450.0700 | 449.4663 | DWELLING, TOWNHOUSE | R3c | 0.0640 | BUSINESS | 31183 | LOT 3 SEC 1 … |