Data Explorer
Query the US Nationwide Parcel Dataset
$1.75 / 1,000 records$100 minimum
39/80
Live SQL
SELECT * FROM "lr_parcel_us" WHERE statefp = '51' AND countyfp = '800'
45,585 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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 55-01-027 | 51 | 800 | 13482 WINDSOR BLVD | WINDSOR | VA | 23487 | EDWARDS DUDLEY JOE SR REV TRUST | SUFFOLK | 95987 | SUFFOLK | 075405 | 754.0500 | 5263.9904 | 167700 | 200000 | 367700 | 2022-12-16 | 2 | 1 | 1973 | 1344 | 3 | 0 | 1 | 510156 | 2026-01-08 | X | AREA OF MINIMAL FLOOD HAZARD | 20.0950 | 21.8809 | 21.2318 | 4 | SINGLE FAMILY | RAC | 2 | TRUST | G2 AUTO SOLUTIONS | AUTOMOTIVE_SERVICE | UNDETERMINED | GAS | UNDETERMINED | CRAWL/RAISED | ASPHALT | 2026.2 | 2024 | ||||||||||||||||||||||||||
| 56-01-003D | 51 | 800 | 23088 SANDY POINT LN | WINDSOR | VA | 23487 | BROCK PETER A RHONDA H | SUFFOLK | 95987 | SUFFOLK | 075405 | 754.0500 | 4373.3289 | 223700 | 40000 | 263700 | 186000 | 2011-11-16 | 2 | 1 | 1984 | 1746 | 3 | 1 | 2 | 510156 | 2026-01-08 | X | AREA OF MINIMAL FLOOD HAZARD | 22.5919 | 23.8536 | 23.3190 | 2 | SINGLE FAMILY | RAC | 1 | PERSON | CENTRAL AIR | GAS | UNDETERMINED | CRAWL/RAISED | ASPHALT | 2026.2 | 2024 | |||||||||||||||||||||||||||
| 71-01-035 | 51 | 800 | 6434 CARRSVILLE HWY | CARRSVILLE | VA | 23315 | BATTLE ANNIE M EST ET AL | SUFFOLK | 95987 | SUFFOLK | 075803 | 758.0300 | 27206.4486 | 98100 | 132100 | 82100 | 66000 | 1 | 1 | 1979 | 1536 | 3 | 0 | 2 | 510156 | 2026-01-08 | X | AREA OF MINIMAL FLOOD HAZARD | 13.3878 | 19.0975 | 16.8987 | 2 | SINGLE FAMILY | RAC | 4 | PERSON | UNDETERMINED | GAS | UNDETERMINED | CRAWL/RAISED | ASPHALT | 2026.2 | 2024 | ||||||||||||||||||||||||||||
| 55-01-028 | 51 | 800 | 13510 WINDSOR BLVD | WINDSOR | VA | 23487 | PERRY SUSAN LYNN | SUFFOLK | 95987 | SUFFOLK | 075405 | 754.0500 | 31239.3125 | 461000 | 91800 | 552800 | 2025-03-14 | 4 | 1 | 1947 | 1992 | 3 | 0 | 2 | 510156 | 2026-01-08 | X | AREA OF MINIMAL FLOOD HAZARD | 18.8741 | 23.0344 | 21.3312 | 2 | SINGLE FAMILY | RAC | 11 | PERSON | SOLAR | SOLAR | UNDETERMINED | CRAWL/RAISED | ASPHALT | 2026.2 | 2024 | ||||||||||||||||||||||||||||
| 50-01-028 | 51 | 800 | 18236 SANDY RIDGE DR | WINDSOR | VA | 23487 | BROWN BARBARA | SUFFOLK | 95987 | SUFFOLK | 075302 | 753.0200 | 31305.7441 | 222300 | 118900 | 341200 | 2023-01-31 | 1 | 1 | 2007 | 1360 | 3 | 0 | 2 | 510156 | 2026-01-08 | X | AREA OF MINIMAL FLOOD HAZARD | 20.0607 | 25.9407 | 22.6528 | 2 | SINGLE FAMILY | RAC | 9.6100 | PERSON | UNDETERMINED | OIL | UNDETERMINED | CRAWL/RAISED | ASPHALT | 2026.2 | 2024 | ||||||||||||||||||||||||||||
| 61A-01-014 | 51 | 800 | 10294 OLD MYRTLE RD | CARRSVILLE | VA | 23315 | ADAMS SUSAN DIANE | SUFFOLK | 95987 | SUFFOLK | 075405 | 754.0500 | 7941.4323 | 254600 | 35000 | 289600 | 2016-11-18 | 2 | 1 | 1979 | 1708 | 3 | 1 | 1 | 510156 | 2026-01-08 | X | AREA OF MINIMAL FLOOD HAZARD | 20.4119 | 22.5328 | 22.0886 | 2 | SINGLE FAMILY | RAC | 0 | PERSON | UNDETERMINED | GAS | UNDETERMINED | CRAWL/RAISED | ASPHALT | 2026.2 | 2024 | ||||||||||||||||||||||||||||
| 50-01-028A | 51 | 800 | 18244 SANDY RIDGE DR | WINDSOR | VA | 23487 | DANIELS CONSTRUCTION CORP | SUFFOLK | 95987 | SUFFOLK | 075302 | 753.0200 | 3497.1517 | 35000 | 35000 | 2025-10-17 | 2 | 1 | 1969 | 1128 | 3 | 0 | 1 | 510156 | 2026-01-08 | X | AREA OF MINIMAL FLOOD HAZARD | 23.7848 | 25.6924 | 24.9650 | 2 | SINGLE FAMILY | RAC | 0.8640 | BUSINESS | UNDETERMINED | GAS | UNDETERMINED | CRAWL/RAISED | ASPHALT | 2026.2 | 2024 | |||||||||||||||||||||||||||||
| 56-01-003E | 51 | 800 | 23070 SANDY POINT LN | WINDSOR | VA | 23487 | DUNN EARL F TAMBRA JEAN P | SUFFOLK | 95987 | SUFFOLK | 075405 | 754.0500 | 4623.6416 | 145400 | 40000 | 185400 | 2 | 1 | 1986 | 1482 | 3 | 0 | 2 | 510156 | 2026-01-08 | X | AREA OF MINIMAL FLOOD HAZARD | 22.7962 | 24.4134 | 23.5161 | 2 | SINGLE FAMILY | RAC | 1 | PERSON | UNDETERMINED | OIL | UNDETERMINED | CRAWL/RAISED | ASPHALT | 2026.2 | 2024 | |||||||||||||||||||||||||||||
| 2 | 91003000020 | 51 | 800 | 1 | VA | 23321 | SUFFOLK | 95987 | SUFFOLK | 075205 | 752.0500 | 1256.2145 | 2002-09-13 | 1 | 1 | 2001 | 2 | 2365 | 3 | 1 | 2 | 510034 | 2026-01-08 | X | AREA OF MINIMAL FLOOD HAZARD | 4.2454 | 5.7868 | 5.3039 | 1010 | 0.3100 | 2 MERRIMAC LANDING | 4688 | 433 | 1 | Forced Hot Air | UNDETERMINED | Full | CONCRETE SLAB | FACE BRICK | 2026.2 | MERRIMAC LANDING, TAYLOR COMMONS | ||||||||||||||||||||||||||||||
| 204 | 91001002040 | 51 | 800 | 1 | VA | 23321 | SUFFOLK | 95987 | SUFFOLK | 075206 | 752.0599 | 617.1819 | 2020-10-26 | 1 | 1 | 2009 | 2 | 1742 | 3 | 1 | 2 | 510034 | 2026-01-08 | X | AREA OF MINIMAL FLOOD HAZARD | 5.9496 | 6.7491 | 6.4095 | 1010 | 0.1520 | 77 SUFFOLK ST PUGHSVILLE | 10243 | 1211 | 1 | Forced Hot Air | UNDETERMINED | Full | CONCRETE SLAB | FACE BRICK | 2026.2 | PUGHSVILLE | ||||||||||||||||||||||||||||||
| 23 | 91001000230 | 51 | 800 | 1 | VA | 23321 | SUFFOLK | 95987 | SUFFOLK | 075206 | 752.0599 | 1560.8029 | 2003-07-10 | 1 | 1 | 1974 | 1 | 1316 | 3 | 0 | 1 | 510034 | 2026-01-08 | X | AREA OF MINIMAL FLOOD HAZARD | 1.5987 | 4.1035 | 3.1329 | 1010 | 0.3850 | PT 87-89-91 RESUB LOTS ON JOHN … | 4981 | 463 | 1 | Electric | ELECTRIC | None | BRICK WALL | FACE BRICK | 2026.2 | PUGHSVILLE | ||||||||||||||||||||||||||||||
| 30 | 91001000300 | 51 | 800 | 1 | VA | 23321 | SUFFOLK | 95987 | SUFFOLK | 075206 | 752.0599 | 668.9064 | 2019-05-28 | 1 | 1 | 2006 | 2 | 2394 | 5 | 1 | 2 | 510034 | 2026-01-08 | X | AREA OF MINIMAL FLOOD HAZARD | 5.1635 | 5.9805 | 5.6234 | 7918 | 0.1650 | 76 PEARL ST PUGHSVILLE | 10015 | 1600 | 1 | Forced Hot Air | UNDETERMINED | Full | CONCRETE SLAB | 2026.2 | PUGHSVILLE | |||||||||||||||||||||||||||||||
| 77 | 91001000770 | 51 | 800 | 1 | VA | 23321 | SUFFOLK | 95987 | SUFFOLK | 075206 | 752.0599 | 668.9230 | 2024-08-13 | 1 | 1 | 1972 | 1 | 1320 | 4 | 0 | 2 | 510034 | 2026-01-08 | X | AREA OF MINIMAL FLOOD HAZARD | 5.3528 | 6.0853 | 5.8137 | 1010 | 0.1650 | 91 QUEEN ST PUGHSVILLE | 10775 | 1202 | 0 | Forced Hot Air | UNDETERMINED | Full | CINDER BLOCK | 2026.2 | PUGHSVILLE | |||||||||||||||||||||||||||||||
| 195 | 91001001950 | 51 | 800 | 1 | VA | 23321 | SUFFOLK | 95987 | SUFFOLK | 075206 | 752.0599 | 624.7119 | 2022-05-09 | 1 | 1 | 2009 | 2 | 1811 | 4 | 1 | 2 | 510034 | 2026-01-08 | X | AREA OF MINIMAL FLOOD HAZARD | 6.1199 | 7.0737 | 6.6640 | 1010 | 0.1540 | 82 PUGHSVILLE MAIN ST | 10557 | 746 | 0 | Forced Hot Air | UNDETERMINED | Full | CONCRETE SLAB | 2026.2 | PUGHSVILLE | |||||||||||||||||||||||||||||||
| 36 | 91003000360 | 51 | 800 | 1 | VA | 23321 | SUFFOLK | 95987 | SUFFOLK | 075205 | 752.0500 | 928.9428 | 2003-03-11 | 1 | 1 | 2002 | 2 | 1967 | 4 | 1 | 2 | 510034 | 2026-01-08 | X | AREA OF MINIMAL FLOOD HAZARD | 5.5876 | 6.6037 | 6.1819 | 1010 | 0.2300 | 36 MERRIMAC LANDING | 4860 | 188 | 1 | Forced Hot Air | UNDETERMINED | Full | CONCRETE SLAB | 2026.2 | MERRIMAC LANDING, TAYLOR COMMONS | |||||||||||||||||||||||||||||||
| 33 | 91001000330 | 51 | 800 | 1 | VA | 23321 | SUFFOLK | 95987 | SUFFOLK | 075206 | 752.0599 | 668.9058 | 2016-10-25 | 1 | 1 | 2007 | 2 | 3202 | 4 | 0 | 4 | 510034 | 2026-01-08 | X | AREA OF MINIMAL FLOOD HAZARD | 4.1304 | 5.2539 | 4.7107 | 1010 | 0.1650 | 80 PEARL ST PUGHSVILLE | 9713 | 1970 | 2 | Forced Hot Air | UNDETERMINED | Full | BRICK WALL | 2026.2 | PUGHSVILLE | |||||||||||||||||||||||||||||||
| 12 | 91003000120 | 51 | 800 | 1 | VA | 23321 | SUFFOLK | 95987 | SUFFOLK | 075205 | 752.0500 | 963.9458 | 2017-04-26 | 1 | 1 | 2002 | 2 | 2243 | 3 | 1 | 2 | 510034 | 2026-01-08 | X | AREA OF MINIMAL FLOOD HAZARD | 5.1969 | 6.7470 | 6.0995 | 1010 | 0.2380 | 12 MERRIMAC LANDING | 9779 | 1998 | 1 | Forced Hot Air | UNDETERMINED | Full | CONCRETE SLAB | 2026.2 | MERRIMAC LANDING, TAYLOR COMMONS | |||||||||||||||||||||||||||||||
| 11 | 91001000110 | 51 | 800 | 1 | VA | 23321 | SUFFOLK | 95987 | SUFFOLK | 075206 | 752.0599 | 621.9910 | 2023-07-07 | 1 | 1 | 1996 | 2 | 1736 | 4 | 1 | 2 | 510034 | 2026-01-08 | X | AREA OF MINIMAL FLOOD HAZARD | 4.6937 | 5.4237 | 5.0864 | 1010 | 0.1650 | 74 CLIFTON ST PUGHSVILLE | 10677 | 307 | 1 | Forced Hot Air | UNDETERMINED | Full | CONCRETE SLAB | 2026.2 | PUGHSVILLE | |||||||||||||||||||||||||||||||
| 148 | 142002001480 | 51 | 800 | 1 | VA | 23321 | SUFFOLK | 95987 | SUFFOLK | 075206 | 752.0599 | 332.8405 | 2020-06-25 | 1 | 1 | 2020 | 2 | 1933 | 3 | 1 | 2 | 510156 | 2026-01-08 | X | AREA OF MINIMAL FLOOD HAZARD | 6.2744 | 7.1796 | 6.7321 | 1050 | 0.0820 | 148 TOWNHOMES AT JOLLIFF LANDIN… | 10171 | 249 | 0 | Forced Hot Air | UNDETERMINED | Full | CONCRETE SLAB | 2026.2 | JOLLIFF LANDING | |||||||||||||||||||||||||||||||
| 107 | 91001001070 | 51 | 800 | 1 | VA | 23321 | SUFFOLK | 95987 | SUFFOLK | 075206 | 752.0599 | 668.9622 | 2014-02-25 | 1 | 1 | 2005 | 2 | 2612 | 4 | 1 | 2 | 510034 | 2026-01-08 | X | AREA OF MINIMAL FLOOD HAZARD | 5.0290 | 6.1960 | 5.8194 | 1010 | 0.1650 | 84A SUBD PLAT OF LOTS IN PUGHSV… | 9325 | 172 | 1 | Forced Hot Air | UNDETERMINED | Full | CONCRETE SLAB | 2026.2 | PUGHSVILLE | |||||||||||||||||||||||||||||||
| 35 | 91003000350 | 51 | 800 | 1 | VA | 23321 | SUFFOLK | 95987 | SUFFOLK | 075205 | 752.0500 | 930.6642 | 2002-10-09 | 1 | 1 | 2002 | 1 | 2205 | 4 | 0 | 3 | 510034 | 2026-01-08 | X | AREA OF MINIMAL FLOOD HAZARD | 5.5553 | 6.5833 | 6.1934 | 1010 | 0.2300 | 35 MERRIMAC LANDING | 4712 | 813 | 1 | Forced Hot Air | UNDETERMINED | Full | CONCRETE SLAB | 2026.2 | MERRIMAC LANDING, TAYLOR COMMONS | |||||||||||||||||||||||||||||||
| 226 | 91001002260 | 51 | 800 | 1 | VA | 23321 | SUFFOLK | 95987 | SUFFOLK | 075206 | 752.0599 | 634.1923 | 2025-07-03 | 1 | 1 | 2009 | 2 | 1915 | 3 | 1 | 2 | 510034 | 2026-01-08 | X | AREA OF MINIMAL FLOOD HAZARD | 6.3124 | 6.8417 | 6.5620 | 1010 | 0.1560 | 72 SUFFOLK ST PUGHSVILLE | 10870 | 456 | 2 | Forced Hot Air | UNDETERMINED | Full | CONCRETE SLAB | 2026.2 | PUGHSVILLE | |||||||||||||||||||||||||||||||
| 8 | 91003000080 | 51 | 800 | 1 | VA | 23321 | SUFFOLK | 95987 | SUFFOLK | 075205 | 752.0500 | 1034.8261 | 2005-05-19 | 1 | 1 | 2002 | 2 | 2275 | 4 | 1 | 2 | 510034 | 2026-01-08 | X | AREA OF MINIMAL FLOOD HAZARD | 5.3329 | 6.5744 | 6.0322 | 1010 | 0.2560 | 8 MERRIMAC LANDING | 6002 | 480 | 1 | Forced Hot Air | UNDETERMINED | Full | CONCRETE SLAB | 2026.2 | MERRIMAC LANDING, TAYLOR COMMONS | |||||||||||||||||||||||||||||||
| 7 | 91001000070 | 51 | 800 | 1 | VA | 23321 | SUFFOLK | 95987 | SUFFOLK | 075206 | 752.0599 | 868.8025 | 2016-10-31 | 1 | 1 | 1972 | 1 | 960 | 3 | 0 | 1 | 510034 | 2026-01-08 | X | AREA OF MINIMAL FLOOD HAZARD | 2.4671 | 4.0114 | 3.2890 | 1010 | 0.2140 | 79 CLIFTON ST PUGHSVILLE | W185 | 884 | 0 | Forced Hot Air | UNDETERMINED | Full | CINDER BLOCK | 2026.2 | PUGHSVILLE | |||||||||||||||||||||||||||||||
| 36 | 91001000360 | 51 | 800 | 1 | VA | 23321 | SUFFOLK | 95987 | SUFFOLK | 075206 | 752.0599 | 668.9053 | 2026-04-20 | 1 | 1 | 1972 | 1 | 1056 | 3 | 0 | 2 | 510034 | 2026-01-08 | X | AREA OF MINIMAL FLOOD HAZARD | 2.3833 | 3.7603 | 3.2331 | 1010 | 0.1650 | 84 PEARL ST PUGHSVILLE | 10969 | 349 | 0 | Electric | ELECTRIC | None | CINDER BLOCK | 2026.2 | PUGHSVILLE |