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 = '09'
1,219,940 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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 731-20 | 09 | 120 | 629 CONNECTICUT AVE | STRATFORD | CT | 06614 | MARINA FRANCISCA | 80 NORTH ACRE PLACE | STRATFORD | CT | 06614 | GREATER BRIDGEPORT | 08070 | BRIDGEPORT | 074300 | 743 | 726.9283 | 94350 | 65290 | -5720 | 179660 | 2021-05-10 | 1 | 1 | 1930 | 1 | 3024 | 09001C | 2025-12-14 | X | AREA OF MINIMAL FLOOD HAZARD | 5.5425 | 6.1482 | 5.9236 | ORS | PERSON | 45711 | 10452/328 | OASIS MARKET INC | CONVENIENCE_STORE | 2026.2 | ||||||||||||||||||||||||||||||
| e0947e64-98e5-4074-a7b7-22c63a9… | 09 | 140 | 9 LA ROVERA TER | ANSONIA | CT | 06401 | MCNEMAR DENISE | 9 LAROVERA TERR | Naugatuck Valley | 01220 | ANSONIA | 125200 | 1252 | 920.6047 | 168350 | 44170 | 700 | 213220 | 199000 | 2001-01-28 | 1 | 1 | 1999 | 2 | 1338 | 3 | 09009C | 2025-12-14 | X | AREA OF MINIMAL FLOOD HAZARD | 68.2853 | 74.7434 | 72.7996 | Residential | B | B | PERSON | 6216 | LOGAN AND LOGAN D USA | HOME_SERVICE | 2026.2 | 2024 | |||||||||||||||||||||||||||||
| c4a4634d-2ee2-42a7-bae8-12e5ffe… | 09 | 140 | 39 COLMAN DR | WATERBURY | CT | 06716 | LUMIA PAUL T CANDACE I | 39 COLMAN DR | Naugatuck Valley | 87560 | WOLCOTT | 361100 | 3611 | 3600.7174 | 151770 | 63170 | 8350 | 223290 | 280000 | 2003-08-29 | 1 | 1 | 1987 | 2 | 1940 | 3 | 09009C | 2025-12-14 | X | AREA OF MINIMAL FLOOD HAZARD | 227.5804 | 240.6669 | 233.7888 | Res Dwelling | R-40 | PERSON | 621340 | PUTTIN' ON THE RITZ | PHYSICAL_MEDICINE_AND_REHABILIT… | 2026.2 | 2010 | ||||||||||||||||||||||||||||||
| 1823-14 | 09 | 120 | 86 JUDSON PL | BRIDGEPORT | CT | 06610 | GRANT DWIGHT & JENNIFER | 86 JUDSON PL | BRIDGEPORT | CT | 06610 | GREATER BRIDGEPORT | 08070 | BRIDGEPORT | 073700 | 737 | 583.3230 | 80020 | 55020 | -5700 | 154990 | 115000 | 1 | 1 | 1952 | 125 | 1551 | 3 | 09001C | 2025-12-14 | X | AREA OF MINIMAL FLOOD HAZARD | 13.9288 | 16.4914 | 15.1378 | RB | PERSON | 4360/0141 | 2026.2 | ||||||||||||||||||||||||||||||||
| 2554-3A | 09 | 120 | 3590 MADISON AVE | BRIDGEPORT | CT | 06606 | BOURDEAU DEBORAH L ETAL | 3590 MADISON AVE | BRIDGEPORT | CT | 06606 | GREATER BRIDGEPORT | 08070 | BRIDGEPORT | 072600 | 726 | 659.7116 | 60650 | 64174 | -6480 | 147504 | 2007-11-07 | 1 | 1 | 1940 | 125 | 1573 | 3 | 09001C | 2025-12-14 | X | AREA OF MINIMAL FLOOD HAZARD | 74.7643 | 77.0027 | 75.2158 | RA | PERSON | 7674/0261 | 2026.2 | ||||||||||||||||||||||||||||||||
| 2256A-12 | 09 | 120 | 91 STRATFIELD PL | BRIDGEPORT | CT | 06606 | ESTEVES GUIOMAR & ALVARO P | 91 STRATFIELD PL | BRIDGEPORT | CT | 06606 | GREATER BRIDGEPORT | 08070 | BRIDGEPORT | 072200 | 722 | 524.7969 | 74920 | 59700 | -8420 | 164090 | 1 | 1 | 1957 | 125 | 1446 | 3 | 09001C | 2025-12-14 | X | AREA OF MINIMAL FLOOD HAZARD | 49.5683 | 52.6785 | 50.8635 | RA | PERSON | 0000/0000 | 2026.2 | |||||||||||||||||||||||||||||||||
| 26e39168-b38d-4094-bcb7-aa4be8a… | 09 | 110 | 133 WILCOX ST | NEW BRITAIN | CT | 06051 | RAZO MARIA D | 133 WILCOX ST | Capitol | 50440 | NEW BRITAIN | 416100 | 4161 | 747.9419 | 93380 | 36820 | 420 | 130620 | 72400 | 2001-12-05 | 1 | 1 | 1957 | 1 | 1518 | 5 | 09003C | 2025-12-14 | X | AREA OF MINIMAL FLOOD HAZARD | 60.4540 | 62.4880 | 61.4478 | 1040 | Two Family | T | PERSON | 2026.2 | 2016 | ||||||||||||||||||||||||||||||||
| 1f48db80-bd3e-4225-af0b-5ee76fe… | 09 | 180 | 181 PENNSYLVANIA AVE | NIANTIC | CT | 06357 | GLADUE MARY ELLEN TR | 181 PENNSYLVANIA AVE | Southeastern Connecticut | 23400 | EAST LYME | 870701 | 8707.0100 | 1920.8899 | 142310 | 56070 | 7560 | 205940 | 1 | 2023-02-02 | 1 | 1 | 1962 | 1 | 1720 | 2 | 09011C | 2025-12-14 | X | AREA OF MINIMAL FLOOD HAZARD | 11.3793 | 14.1444 | 12.3921 | 1010 | Single Fam M-01 | R40 | TRUST | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||
| 1e317f27-f778-470e-b1e9-5e89f0e… | 09 | 180 | 226 CONNECTICUT AVE | NEW LONDON | CT | 06320 | VALENZUELA ANGEL A | 226 CONNECTICUT AVE | Southeastern Connecticut | 52350 | NEW LONDON | 690300 | 6903 | 447.9230 | 80640 | 32480 | 2240 | 115360 | 89000 | 2010-07-12 | 1 | 1 | 1890 | 1 | 1925 | 3 | 09011C | 2025-12-14 | X | AREA OF MINIMAL FLOOD HAZARD | 17.0260 | 19.4092 | 18.5757 | 1010 | Single Family | R-1A | PERSON | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||
| 3ff94cac-62ea-4f11-ab3e-74826e7… | 09 | 140 | 10 SOBIN DR | ANSONIA | CT | 06401 | HECKLER BRIAN K | 10 SOBIN DR | Naugatuck Valley | 01220 | ANSONIA | 125200 | 1252 | 1254.8183 | 182700 | 66570 | 0 | 249270 | 165000 | 1995-01-20 | 1 | 1 | 1994 | 1 | 1288 | 3 | 09009C | 2025-12-14 | X | AREA OF MINIMAL FLOOD HAZARD | 129.8185 | 131.9841 | 131.2641 | Residential | A | A | PERSON | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||
| 11b046c7-f1ca-4d87-95b9-c9cd230… | 09 | 110 | 11 SALEM CIR | WINDSOR LOCKS | CT | 06095 | JAMES ROBIN RYAN CHRISTIAN JS | 11 SALEM CIR | Capitol | 87000 | WINDSOR | 473700 | 4737 | 908.2959 | 61740 | 43400 | 1470 | 106610 | 232500 | 2020-06-12 | 1 | 1 | 1951 | 1 | 1152 | 3 | 09003C | 2025-12-14 | X | AREA OF MINIMAL FLOOD HAZARD | 29.6997 | 32.2534 | 31.5156 | 1010 | Single Fam | R10 | PERSON | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||
| 1cf2c133-69de-4c91-b640-53af979… | 09 | 180 | 158 N WAWECUS HILL RD | NORWICH | CT | 06360 | SMITH ROBERT R | 158 NORTH WAWECUS HILL RD | Southeastern Connecticut | 56270 | NORWICH | 696200 | 6962 | 7344.0298 | 87600 | 52500 | 9200 | 149300 | 266000 | 2019-10-17 | 4 | 1 | 1950 | 1 | 1584 | 4 | 09011C | 2025-12-14 | X | AREA OF MINIMAL FLOOD HAZARD | 84.0719 | 90.3274 | 87.4299 | 1010 | Single Family | R80 | PERSON | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||
| 72ada252-b9d0-49a9-bcc7-46be8df… | 09 | 180 | 23 SAPIA DR E | NIANTIC | CT | 06357 | HARMS DAVID A HEATHER C | 23 SAPIA DR | Southeastern Connecticut | 23400 | EAST LYME | 870703 | 8707.0300 | 21962.1323 | 291130 | 121240 | 37030 | 449400 | 635000 | 2021-02-02 | 2 | 1 | 2010 | 2 | 2940 | 4 | 09011C | 2025-12-14 | X | AREA OF MINIMAL FLOOD HAZARD | 8.5112 | 34.4813 | 21.1870 | 1010 | Single Fam M-01 | R40 | PERSON | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||
| 36c9812f-67a2-402b-a4fb-98a37c1… | 09 | 180 | 315 BAYONET ST | NEW LONDON | CT | 06320 | DALLAIRE DENISE | 78 NICHOLAS AVE | Southeastern Connecticut | 52350 | NEW LONDON | 870300 | 8703 | 707.3576 | 58590 | 32480 | 0 | 91070 | 100000 | 2018-06-15 | 1 | 1 | 1964 | 996 | 3 | 09011C | 2025-12-14 | X | AREA OF MINIMAL FLOOD HAZARD | 32.9749 | 41.0422 | 37.3541 | 1010 | Single Family | R-1A | PERSON | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||
| 1ac3c940-b4f8-4eb2-a84d-16727ca… | 09 | 140 | 10 EAGLE DR | SHELTON | CT | 06484 | OSTROFSKY GREGORY M | 10 EAGLE DR | Naugatuck Valley | 68170 | SHELTON | 110500 | 1105 | 3948.5327 | 253680 | 106050 | 770 | 360500 | 0 | 2 | 1 | 1984 | 2 | 2394 | 5 | 09001C | 2025-12-14 | X | AREA OF MINIMAL FLOOD HAZARD | 152.0387 | 159.6251 | 154.0719 | Residential | R-1 | R-1 | PERSON | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||
| 3cc7c588-a803-43ae-beb8-08b5a6c… | 09 | 110 | 181 WEST RD | MARLBOROUGH | CT | 06447 | MARLBOROUGH TOWN OF | PO BOX 29 | Capitol | 45820 | MARLBOROUGH | 524100 | 5241 | 71680.3856 | 0 | 134220 | 39760 | 173980 | 0 | 7 | 09003C | 2025-12-14 | X | AREA OF MINIMAL FLOOD HAZARD | 107.3982 | 138.7627 | 114.8538 | Mun Park Lnd | R | GOVERNMENT | 3211 | GOVT LOCAL | RESTRICTED | V | BALLFIELD | LOCAL CONSERVATION AREA | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||
| 8f8d9362-8e35-4416-b0ec-08c9b2d… | 09 | 110 | 41 SHEEP HILL DR | WEST HARTFORD | CT | 06117 | XU WEI | 41 SHEEP HILL DRIVE | Capitol | 82590 | WEST HARTFORD | 497500 | 4975 | 1306.1677 | 175000 | 111860 | 10010 | 296870 | 440000 | 2012-08-23 | 1 | 1 | 1964 | 1 | 2193 | 4 | 09003C | 2025-12-14 | X | AREA OF MINIMAL FLOOD HAZARD | 49.4914 | 51.3806 | 50.1894 | Res Dwelling | R-13 | PERSON | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||
| 2f1616d4-624a-4353-a622-d4120a1… | 09 | 110 | 111 SPRUCE DR | EAST HARTFORD | CT | 06118 | MOORCROFT DAVID | 111 SPRUCE DR | Capitol | 22630 | EAST HARTFORD | 510900 | 5109 | 1478.4763 | 125920 | 45930 | 0 | 171850 | 172000 | 2017-05-02 | 1 | 1 | 1964 | 2 | 1400 | 3 | 09003C | 2025-12-14 | X | AREA OF MINIMAL FLOOD HAZARD | 15.4994 | 17.6155 | 16.8366 | One Family | R2 | PERSON | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||
| 7c93dd15-07a7-4ef6-bb48-284df0a… | 09 | 140 | 145 BROOKS HILL RD | WATERBURY | CT | 06716 | TESTA PETER J JR | 145 BROOKS HILL RD | Naugatuck Valley | 87560 | WOLCOTT | 361100 | 3611 | 6629.1779 | 166910 | 51820 | 840 | 219570 | 0 | 1998-05-29 | 1 | 1 | 1974 | 1 | 1763 | 3 | 09009C | 2025-12-14 | X | AREA OF MINIMAL FLOOD HAZARD | 178.0454 | 190.6562 | 184.4274 | Res Dwelling | R-40 | PERSON | 2026.2 | 2010 | |||||||||||||||||||||||||||||||||
| 3ac13ff1-c989-4a37-9251-591c707… | 09 | 110 | 144 RED STONE HILL | PLAINVILLE | CT | 06062 | GALVEZ ALEXANDER EVELIN | 144-B REDSTONE HILL | Capitol | 60120 | PLAINVILLE | 420500 | 4205 | 4271.4071 | 301980 | 66220 | 0 | 368200 | 480000 | 2020-07-06 | 1 | 1 | 1994 | 1 | 3564 | 4 | 09003C | 2025-12-14 | X | AREA OF MINIMAL FLOOD HAZARD | 63.4600 | 77.3306 | 70.6943 | SINGLE FAMILY | R-20 | PERSON | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||
| 0c81fbce-2e3c-4aa5-b88d-8e28c62… | 09 | 110 | 65 JEAN RD | MANCHESTER | CT | 06040 | HARRISON SAMUEL J III | 65 JEAN ROAD | Capitol | 44700 | MANCHESTER | 515000 | 5150 | 1860.2154 | 144100 | 46700 | 0 | 190800 | 140000 | 1997-09-26 | 1 | 1 | 1951 | 1 | 1543 | 3 | 09003C | 2025-12-14 | X | AREA OF MINIMAL FLOOD HAZARD | 115.1736 | 121.4634 | 117.9739 | Single Family | AA | PERSON | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||
| 77d25e97-58cc-4ebc-8471-23758c1… | 09 | 180 | 1 RAINBOW CT | QUAKER HILL | CT | 06375 | ANTIPOFF GREGORY D JENNA L | 1 RAINBOW COURT | Southeastern Connecticut | 80280 | WATERFORD | 693600 | 6936 | 3763.4864 | 213400 | 91740 | 0 | 305140 | 0 | 2016-09-13 | 1 | 1 | 1999 | 2 | 2185 | 4 | 09011C | 2025-12-14 | X | AREA OF MINIMAL FLOOD HAZARD | 48.9058 | 59.4108 | 55.6946 | Res Dwelling | R-40 | PERSON | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||
| ff0cee2c-8fe2-4f5b-ac83-42d5a52… | 09 | 140 | 16 GREAT PYRENEES WAY | BRISTOL | CT | 06010 | CRACCO PHILIP ROXANNE | 16 GREAT PYRENEES WAY | Naugatuck Valley | 08490 | BRISTOL | 405802 | 4058.0200 | 5073.8267 | 392350 | 85190 | 17780 | 495320 | 450000 | 2018-10-09 | 1 | 1 | 1997 | 1 | 4553 | 3 | 09003C | 2025-12-14 | X | AREA OF MINIMAL FLOOD HAZARD | 260.3326 | 272.9516 | 268.1016 | Single Family | R-25 | PERSON | 2026.2 | 2008 | |||||||||||||||||||||||||||||||||
| 08936a45-2be4-4bef-8102-ee0e013… | 09 | 110 | 22 PLUM ORCHARD RD | SOUTHINGTON | CT | 06489 | KROLL CARMELINDA | 22 PLUM ORCHARD RD | Capitol | 70550 | SOUTHINGTON | 430203 | 4302.0300 | 654.8501 | 56200 | 41180 | 430 | 97810 | 139500 | 2013-05-09 | 1 | 1 | 1955 | 1 | 792 | 2 | 09003C | 2025-12-14 | X | AREA OF MINIMAL FLOOD HAZARD | 60.4533 | 61.2052 | 60.7499 | Single Family | R-12 | PERSON | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||
| a4c5f995-d496-4f54-985f-28cffff… | 09 | 180 | 18 CARIBOU DR | NORWICH | CT | 06360 | GIONET FRANK | 18 CARIBOU DR | Southeastern Connecticut | 56270 | NORWICH | 696100 | 6961 | 2420.8803 | 75000 | 37800 | 1900 | 114700 | 139900 | 2001-12-03 | 3 | 1 | 1972 | 1092 | 3 | 09011C | 2025-12-14 | X | AREA OF MINIMAL FLOOD HAZARD | 79.2552 | 81.0299 | 79.9921 | 1010 | Single Family | R40 | PERSON | 2026.2 | 2024 |