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 = '34' AND countyfp = '039'
149,798 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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2006-002080000-000030000-00000 | 63000 | 34 | 039 | 75 2ND AVE APT 2 | GARWOOD BOROUGH | NJ | 07027 | ELMALAH MUSTAFA | 75 SECOND AVE | UNION | 25800 | GARWOOD | 036900 | 369 | 626.5581 | 187600 | 167700 | 0 | 355300 | 650000 | 2023-12-20 | 1 | 3 | 42 | 1 | 1400 | 34039C | 2025-09-03 | X | AREA OF MINIMAL FLOOD HAZARD | -9999 | 24.5400 | 25.4199 | 25.0365 | 00/00/00 | PERSON | 75 SECOND AVE | 6535 | 2263 | 2026.2 | 2024 | ||||||||||||||||||||||||||||||
| 2013-000670000-000150000-00000 | 05302000 | 34 | 039 | 464 W LAKE AVENUE UN | RAHWAY | NJ | 07065 | MEVAWALA KIRIT AMISHA | 464 W LAKE AVE | UNION | 61530 | RAHWAY | 035700 | 357 | 520.1825 | 96700 | 55600 | 0 | 152300 | 145000 | 1987-08-25 | 1 | 1 | 1 | 2 | 772 | 34039C | 2025-09-03 | X | AREA OF MINIMAL FLOOD HAZARD | -9999 | 8.5400 | 10.0299 | 9.4009 | 00/00/00 | PERSON | 464 W LAKE AVE | 3520 | 378 | 2026.2 | 2024 | ||||||||||||||||||||||||||||||
| 2013-003770000-000030001-00000 | 00539001 | 34 | 039 | 1709 LAWRENCE STREET UN | RAHWAY | NJ | 07065 | GRUBBS WILLIAM | 1553 ESSEX ST | UNION | 61530 | RAHWAY | 036000 | 360 | 718.4640 | 84400 | 78100 | 0 | 162500 | 1 | 2023-07-26 | 1 | 1 | 1 | 1 | 683 | 34039C | 2025-09-03 | X | AREA OF MINIMAL FLOOD HAZARD | -9999 | 5.6500 | 8.1399 | 6.9553 | 00/00/00 | PERSON | 270 LAFAYETTE ST | 6519 | 2263 | 2026.2 | 2024 | ||||||||||||||||||||||||||||||
| 2011-002060000-000050000-00000 | 00222000 | 34 | 039 | 180 UNION AVENUE UN NEW | PROVIDENCE BOROUGH | NJ | 07974 | CAHILL SCOTT DANA | 180 UNION AVE | UNION | 51810 | NEW PROVIDENCE | 038103 | 381.0299 | 1404.6652 | 157700 | 94800 | 0 | 252500 | 285000 | 2000-01-28 | 1 | 1 | 1 | 2 | 804 | 34039C | 2025-09-03 | X | AREA OF MINIMAL FLOOD HAZARD | -9999 | 69.1400 | 74.4199 | 71.4342 | 00/00/00 | PERSON | 180 UNION AVE | 4931 | 340 | 2026.2 | 2024 | ||||||||||||||||||||||||||||||
| 2015-007140000-000140000-00000 | 00010675 | 34 | 039 | 142 E COLFAX AVENUE UN ROSELLE | PARK BOROUGH | NJ | 07204 | HUXFORD PATRICIA E | 142 COLFAX AVE E | UNION | 64650 | ROSELLE PARK | 033700 | 337 | 929.2128 | 99700 | 106800 | 0 | 206500 | 1 | 2015-03-24 | 1 | 1 | 1 | 1 | 672 | 34039C | 2025-09-03 | X | AREA OF MINIMAL FLOOD HAZARD | -9999 | 22.2200 | 23.4399 | 22.7620 | 00/00/00 | PERSON | 142 COLFAX AVE E | 6049 | 926 | 2026.2 | 2024 | ||||||||||||||||||||||||||||||
| 2013-001650000-000070000-00000 | 07641000 | 34 | 039 | 497 SEMINARY AVENUE UN | RAHWAY | NJ | 07065 | CHARLES PIERRE R | 497 SEMINARY AVE | UNION | 61530 | RAHWAY | 035700 | 357 | 946.4405 | 93800 | 62300 | 0 | 156100 | 290000 | 2017-07-17 | 1 | 1 | 42 | 1 | 876 | 34039C | 2025-09-03 | X | AREA OF MINIMAL FLOOD HAZARD | -9999 | 6.8900 | 7.4299 | 7.1311 | 00/00/00 | PERSON | 497 SEMINARY AVE | 6205 | 562 | 2026.2 | 2024 | ||||||||||||||||||||||||||||||
| 2015-007020000-000130000-00000 | 00009560 | 34 | 039 | 818 PROSPECT STREET UN ROSELLE | PARK BOROUGH | NJ | 07204 | MATOS MANUEL ROSALIA | 818 PROSPECT ST | UNION | 64650 | ROSELLE PARK | 033800 | 338 | 464.6705 | 201600 | 97000 | 0 | 298600 | 334500 | 2009-07-22 | 1 | 1 | 1 | 2 | 1010 | 34039C | 2025-09-03 | X | AREA OF MINIMAL FLOOD HAZARD | -9999 | 28.6400 | 29.6099 | 29.2361 | 00/00/00 | PERSON | 818 PROSPECT ST | 5773 | 304 | 2026.2 | 2024 | ||||||||||||||||||||||||||||||
| 2015-003020000-000230000-00000 | 00003060 | 34 | 039 | 329 SEATON AVENUE UN ROSELLE | PARK BOROUGH | NJ | 07204 | IACOVO DORA FELIPO ROSA | 329 SEATON AVE | UNION | 64650 | ROSELLE PARK | 033800 | 338 | 561.5751 | 244800 | 130000 | 0 | 374800 | 100 | 2007-01-26 | 1 | 1 | 42 | 1 | 1335 | 34039C | 2025-09-03 | X | AREA OF MINIMAL FLOOD HAZARD | -9999 | 25.1200 | 25.6699 | 25.4100 | 00/00/00 | PERSON | 329 SEATON AVE | 5632 | 909 | 2026.2 | 2024 | ||||||||||||||||||||||||||||||
| 2018-037040000-000210001-00000 | 34 | 039 | 25 GROVE ST UN | SUMMIT | NJ | 07901 | CURIALE NICOLINO | 235 MORRIS AVENUE | UNION | 71430 | SUMMIT | 038000 | 380 | 462.0983 | 181200 | 67000 | 0 | 248200 | 1 | 2003-02-25 | 1 | 1 | 10 | 1 | 803 | 34039C | 2025-09-03 | X | AREA OF MINIMAL FLOOD HAZARD | -9999 | 61.6600 | 63.2699 | 62.6535 | 00/00/00 | PERSON | 25 GROVE STREET | 5365 | 717 | 2026.2 | 2024 | |||||||||||||||||||||||||||||||
| 2003-005550000-000170000-00000 | 679200-2 | 34 | 039 | 55 MYRTLE STREET UN | CRANFORD TOWNSHIP | NJ | 07016 | RODRIGUEZ ALEX TEOMI KAREN | 55 MYRTLE ST | UNION | 15640 | CRANFORD | 037300 | 373 | 530.4691 | 76600 | 66000 | 0 | 142600 | 429000 | 2022-10-17 | 1 | 1 | 1 | 2 | 34039C | 2025-09-03 | X | AREA OF MINIMAL FLOOD HAZARD | -9999 | 26.6800 | 27.7899 | 27.5431 | 00/00/00 | PERSON | 55 MYRTLE ST | 6489 | 125 | 2026.2 | 2024 | |||||||||||||||||||||||||||||||
| 2020-013010000-000460000-00000 | 34 | 039 | 723 OAK AVENUE UN | WESTFIELD | NJ | 07090 | MIZRACH BRUCE M KAREN ROSE | 723 OAK AVE | UNION | 79040 | WESTFIELD | 036400 | 364 | 976.9318 | 149600 | 476600 | 0 | 626200 | 272000 | 1997-08-18 | 1 | 1 | 1 | 1 | 755 | 34039C | 2025-09-03 | X | AREA OF MINIMAL FLOOD HAZARD | -9999 | 45.4399 | 47.0399 | 46.3301 | 00/00/00 | PERSON | 723 OAK AVE | 4560 | 53 | 2026.2 | 2024 | |||||||||||||||||||||||||||||||
| 2001-010020000-000860000-00000 | 34 | 039 | 179 RIVERBEND ROAD UN BERKELEY | HEIGHTS TOWNSHIP | NJ | 07922 | TURNEY JAMES IGLESIAS-BLAZQUEZ R | 179 RIVER BEND ROAD | UNION | 05320 | BERKELEY HEIGHTS | 038202 | 382.0200 | 1115.0494 | 136000 | 150400 | 0 | 286400 | 620000 | 2008-02-08 | 1 | 2 | 1962 | 1 | 2206 | 34039C | 2025-09-03 | X | 0.2 PCT ANNUAL CHANCE FLOOD HAZ… | -9999 | 64.5100 | 66.2899 | 65.2015 | 000 | PERSON | 179 RIVER BEND RD | 5713 | 525 | 2026.2 | 2008 | |||||||||||||||||||||||||||||||
| 2018-039060000-000040000-00000 | 34 | 039 | 4 JOHN ST UN | SUMMIT | NJ | 07901 | VOIGHT DIANE A. | 4 JOHN STREET | UNION | 71430 | SUMMIT | 038000 | 380 | 371.9192 | 120700 | 68700 | 0 | 189400 | 175000 | 1993-01-20 | 2 | 1 | 42 | 1 | 1085 | 34039C | 2025-09-03 | X | AREA OF MINIMAL FLOOD HAZARD | -9999 | 76.4900 | 78.8700 | 77.7814 | 00/00/00 | PERSON | 4 JOHN ST | 3927 | 164 | 2026.2 | 2024 | |||||||||||||||||||||||||||||||
| 2018-025020000-000170000-00000 | 34 | 039 | 113 WHITTREDGE ROAD UN | SUMMIT | NJ | 07901 | CHAMBEAU BRUCE V MARILYN A. | 113 WHITTREDGE RD | UNION | 71430 | SUMMIT | 037700 | 377 | 1990.3217 | 428300 | 446500 | 0 | 874800 | 676500 | 1991-06-10 | 1 | 1 | 10 | 2 | 1075 | 34039C | 2025-09-03 | X | AREA OF MINIMAL FLOOD HAZARD | -9999 | 113.5599 | 119.1500 | 115.7405 | 00/00/00 | PERSON | 113 WHITTREDGE ROAD | 3740 | 284 | 2026.2 | 2024 | |||||||||||||||||||||||||||||||
| 2014-006020000-000040000-00000 | 1988 | 34 | 039 | 620 GALVIN AVENUE UN | ROSELLE BOROUGH | NJ | 07203 | BROWN SHAUNTAE | 620 GALVIN AVE | UNION | 64620 | ROSELLE | 034100 | 341 | 348.5122 | 118900 | 57400 | 0 | 176300 | 395000 | 2021-10-26 | 2 | 1 | 1 | 716 | 34039C | 2025-09-03 | X | AREA OF MINIMAL FLOOD HAZARD | -9999 | 15.1399 | 17.0799 | 16.3808 | 00/00/00 | PERSON | 620 GALVIN AVE | 6439 | 2023 | 2026.2 | 2024 | |||||||||||||||||||||||||||||||
| 2014-002050000-000120000-00000 | 5919 | 34 | 039 | 119 HAWTHORNE STREET UN | ROSELLE BOROUGH | NJ | 07203 | GOMEZ HIPOLITO R PAREDES | 119 HAWTHORNE ST | UNION | 64620 | ROSELLE | 034000 | 340 | 464.8211 | 49900 | 60000 | 0 | 109900 | 160000 | 2017-12-05 | 1 | 1 | 1 | 884 | 34039C | 2025-09-03 | X | AREA OF MINIMAL FLOOD HAZARD | -9999 | 15.1900 | 16.3099 | 15.7974 | 00/00/00 | PERSON | 119 HAWTHORNE ST | 6234 | 889 | 2026.2 | 2024 | |||||||||||||||||||||||||||||||
| 2001-031020000-000040000-00000 | 34 | 039 | 50 BROOKSIDE LANE UN BERKELEY | HEIGHTS TOWNSHIP | NJ | 07922 | ERVIN TODD R. | 50 BROOKSIDE LANE | UNION | 05320 | BERKELEY HEIGHTS | 038202 | 382.0200 | 2296.8288 | 169800 | 152600 | 0 | 322400 | 107500 | 1996-08-07 | 2 | 1 | 1998 | 1 | 1800 | 34039C | 2025-09-03 | X | AREA OF MINIMAL FLOOD HAZARD | -9999 | 118.6000 | 120.6399 | 119.6467 | 000 | PERSON | 50 BROOKSIDE LANE | 4419 | 205 | 2026.2 | 2016 | |||||||||||||||||||||||||||||||
| 2017-028010000-000010000-00000 | 34 | 039 | 28 IRWIN STREET UN | SPRINGFIELD TOWNSHIP | NJ | 07081 | BALTUSROL GOLF CLUB ATTN ACCOUN… | 201 SHUNPIKE RD BOX 9 | UNION | 70020 | SPRINGFIELD | 037601 | 376.0100 | 929.8637 | 475700 | 204700 | 0 | 680400 | 575000 | 2021-11-10 | 1 | 1 | 10 | 2 | 1336 | 34039C | 2025-09-03 | X | AREA OF MINIMAL FLOOD HAZARD | -9999 | 43.7900 | 45.4599 | 44.4928 | 00/00/00 | NONPROFIT | 28 IRWIN ST | 6442 | 2478 | 2026.2 | 2024 | |||||||||||||||||||||||||||||||
| 2001-016070000-000390000-00000 | 34 | 039 | 1039 MOUNTAIN AVENUE UN BERKELEY | HEIGHTS TOWNSHIP | NJ | 07922 | MOAVEN NADER | 1039 MOUNTAIN AVE | UNION | 05320 | BERKELEY HEIGHTS | 038202 | 382.0200 | 5965.4100 | 229600 | 160500 | 0 | 390100 | 732500 | 2014-01-16 | 2 | 1 | 1950 | 1 | 3580 | 34039C | 2025-09-03 | X | AREA OF MINIMAL FLOOD HAZARD | -9999 | 65.8400 | 72.7000 | 68.7776 | 000 | PERSON | 1039 MOUNTAIN AVE | 5989 | 648 | 2026.2 | 2019 | |||||||||||||||||||||||||||||||
| 2013-001780000-000160000-00000 | 08494000 | 34 | 039 | 1185 MOONEY PLACE UN | RAHWAY | NJ | 07065 | PORTILLO XAVIERA A | 1185 MOONEY PL | UNION | 61530 | RAHWAY | 035700 | 357 | 540.4802 | 100800 | 71600 | 0 | 172400 | 282000 | 2013-04-10 | 2 | 1 | 1 | 572 | 34039C | 2025-09-03 | X | AREA OF MINIMAL FLOOD HAZARD | -9999 | 5.5800 | 6.2999 | 5.9367 | 00/00/00 | PERSON | 1185 MOONEY PL | 5949 | 612 | 2026.2 | 2024 | |||||||||||||||||||||||||||||||
| 2020-036010000-000200000-00000 | 34 | 039 | 1033 COOLIDGE STREET UN | WESTFIELD | NJ | 07090 | SUSSMAN STEVEN LAURA | 1033 COOLIDGE ST | UNION | 79040 | WESTFIELD | 036400 | 364 | 780.8067 | 208200 | 473000 | 0 | 681200 | 0 | 1993-06-21 | 1 | 1 | 1 | 2 | 918 | 34039C | 2025-09-03 | X | AREA OF MINIMAL FLOOD HAZARD | -9999 | 27.3900 | 28.7299 | 28.0853 | 00/00/00 | PERSON | 1033 COOLIDGE ST | 3981 | 300 | 2026.2 | 2024 | |||||||||||||||||||||||||||||||
| 2004-008120000-000430002-00000 | 34 | 039 | 255 PINE ST APT 1 | ELIZABETH | NJ | 07206 | FRANCISCO CHRISTINA S | 255 PINE ST | UNION | 21000 | ELIZABETH | 039801 | 398.0100 | 234.7299 | 211200 | 142500 | 0 | 353700 | 165000 | 2008-06-24 | 2 | 3 | 42 | 2 | 931 | 34039C | 2025-09-03 | X | AREA OF MINIMAL FLOOD HAZARD | -9999 | 6.2000 | 7.0699 | 6.5671 | 00/00/00 | PERSON | 255 PINE ST | 5725 | 232 | 2026.2 | 2024 | |||||||||||||||||||||||||||||||
| 2009-000090000-000150000-00000 | 34 | 039 | 2033 ALBERTA AVENUE UN | LINDEN | NJ | 07036 | RODRIGUEZ LEWIS | 2033 ALBERTA AVE | UNION | 40350 | LINDEN | 034500 | 345 | 464.6494 | 63200 | 47500 | 0 | 110700 | 450000 | 2023-03-24 | 1 | 1 | 1 | 555 | 34039C | 2025-09-03 | X | AREA OF MINIMAL FLOOD HAZARD | -9999 | 8.6600 | 10.7399 | 9.2936 | 00/00/00 | PERSON | 2033 ALBERTA AVE | 6505 | 699 | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||
| 2009-004870000-000070000-00000 | 34 | 039 | 919 MCCANDLESS PLACE UN | LINDEN | NJ | 07036 | MIENIOK ROMUALD ZLATICA | 919 MC CANDLESS PL | UNION | 40350 | LINDEN | 035200 | 352 | 521.3431 | 78400 | 47100 | 0 | 125500 | 1 | 2014-10-14 | 1 | 1 | 1 | 972 | 34039C | 2025-09-03 | X | AREA OF MINIMAL FLOOD HAZARD | -9999 | 3.4800 | 4.1099 | 3.8043 | 00/00/00 | PERSON | 919 MC CANDLESS PL | 6027 | 637 | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||
| 2004-004540000-000140000-00000 | 34 | 039 | 557 GRIER AVENUE UN | ELIZABETH | NJ | 07202 | MERRERO LUIS J ELSA | 557 GRIER AVE | UNION | 21000 | ELIZABETH | 030703 | 307.0299 | 549.8825 | 253100 | 219000 | 0 | 472100 | 80000 | 1993-01-26 | 2 | 1 | 1 | 1 | 858 | 34039C | 2025-09-03 | X | AREA OF MINIMAL FLOOD HAZARD | -9999 | 5.5600 | 7.3299 | 6.4844 | 00/00/00 | PERSON | 557 GRIER AVE | 3931 | 147 | 2026.2 | 2024 |