Saved query bca7fbc45aab5606

Data Explorer

Query the US Nationwide Parcel Dataset

$1.75 / 1,000 records$100 minimum

40/80

Live SQL

SELECT * 
FROM "lr_parcel_us" 
WHERE statefp = '34' 
  AND countyfp = '037'

76,566 matching parcels

Data Preview

parcelid	taxacctnum	statefp	countyfp	parceladdr	parcelcity	parcelstate	ownername	owneraddr	ownercity	ownerstate	ownerzip	countyname	cousubfp	cousubname	tractce	tractname	calcarea	saledate	firmid	firmdate	fldzone	zonesubty	usecode	usedesc	zoningcode	taxacres	ownertype	legaldesc	book	page	lrversion
1909-000130000-000150000-00000	1909-13-15	34	037	57 KING COLE RD		NJ	CURRENT OWNER	57 KING COLE RD	HAMBURG, NJ	NJ	07419	SUSSEX	29220	HAMBURG	372700	3727	1575.3172	2004-04-29	34037C	2025-09-03	X	AREA OF MINIMAL FLOOD HAZARD	1	ST FRM	RR	0.3810	PERSON	100X166	2818	23	2026.2
1912-403030000-000050000-00000	1912-40303-5	34	037	116 VERMONT TRL		NJ	CURRENT OWNER	116 VERMONT TR	HOPATCONG, NJ	NJ	07843	SUSSEX	32910	HOPATCONG	374500	3745	755.7156	2008-03-19	34037C	2025-09-03	X	AREA OF MINIMAL FLOOD HAZARD	1	1SF	R-1	0.1840	PERSON	80X100	3201	746	2026.2
1915-000220001-000180000-00000	1915-22.01-18	34	037	48 SUSSEX ST		NJ	CURRENT OWNER	48 SUSSEX ST	NEWTON, NJ	NJ	07860	SUSSEX	51930	NEWTON	373800	3738	645.2549	2025-06-17	34037C	2025-09-03	X	AREA OF MINIMAL FLOOD HAZARD	1	2S-0-7AG	T-3	0.1719	PERSON	00000.172 AC.	10387	1144	2026.2
1918-270040000-000050000-00000	1918-27004-5	34	037	16 GLEN RD		NJ	CURRENT OWNER	25 GLEN RD	SPARTA, NJ	NJ	07871	SUSSEX	69690	SPARTA	373200	3732	682.3504	2001-02-22	34037C	2025-09-03	X	AREA OF MINIMAL FLOOD HAZARD	1	OLD STYLE	R-4	0.1700	PERSON	55X141	2527	283	2026.2
1921-005010000-000120000-00000	1921-501-12	34	037	1 MUNSON ST		NJ	CURRENT OWNER	1 MUNSON ST	SUSSEX, NJ	NJ	07461	SUSSEX	71670	SUSSEX	371200	3712	372.1124	2021-04-14	34037C	2025-09-03	X	AREA OF MINIMAL FLOOD HAZARD	1	2SF-O	R-2	0.0918	PERSON	50X80	3592	942	2026.2
1909-000070000-000040000-00000	1909-7-4	34	037	13 AMES BLVD		NJ	CURRENT OWNER	2 CRAIG RD	VERNON, NJ	NJ	07462	SUSSEX	29220	HAMBURG	372700	3727	801.6852	2012-03-26	34037C	2025-09-03	X	AREA OF MINIMAL FLOOD HAZARD	4A	2SS 1G	BC	0.1920	PERSON	59X142	3287	656	2026.2
1911-000310000-000030000-00000	1911-31-3	34	037	30 DEER TRL		NJ	CURRENT OWNER	30 DEER TRAIL LAKE RD	STOCKHOLM, NJ	NJ	07460	SUSSEX	29850	HARDYSTON	372600	3726	1379.7776	2011-10-31	34037C	2025-09-03	X	AREA OF MINIMAL FLOOD HAZARD	1	1SF	R-3	0.3439	PERSON	.344 AC	3295	744	2026.2
1910-030050000-000050000-00000	1910-3005-5	34	037	92 CRESCENT DR		NJ	CURRENT OWNER	92 CRESCENT DR	NEWTON, NJ	NJ	07860	SUSSEX	29490	HAMPTON	372000	3720	1933.8981	2019-03-04	34037C	2025-09-03	X	AREA OF MINIMAL FLOOD HAZARD	1	1S F R	R1.5	0.4591	PERSON	200X100	3510	948	2026.2
1918-030400000-000040000-00000	1918-3040-4	34	037	30 BALSAM PKWY		NJ	CURRENT OWNER	30 BALSAM PKWY	SPARTA, NJ	NJ	07871	SUSSEX	69690	SPARTA	373400	3734	406.0471	1990-12-28	34037C	2025-09-03	X	AREA OF MINIMAL FLOOD HAZARD	1	CAPE COD	R-3	0.1000	PERSON	60X70 LMCC	1780	312	2026.2
1906-006040000-000050000-00000	1906-604-5	34	037	372 RUTHERFORD AVE		NJ	CURRENT OWNER	617 DEVON ST	KEARNY, NJ	NJ	07032	SUSSEX	24930	FRANKLIN	372900	3729	1049.3526	2015-10-28	34037C	2025-09-03	X	AREA OF MINIMAL FLOOD HAZARD	43	2SF-O-MULTI	B-2	0.2590	PERSON	.259 AC	3376	790	2026.2
1912-112090000-000240000-00000	1912-11209-24	34	037	317 SANTA FE TRL		NJ	CURRENT OWNER	317 SANTA FE TR	HOPATCONG, NJ	NJ	07843	SUSSEX	32910	HOPATCONG	374900	3749	976.0663	2017-05-01	34037C	2025-09-03	X	AREA OF MINIMAL FLOOD HAZARD	1	1SF	R-1	0.2100	PERSON	128X114 IRR	3426	847	2026.2
1902-000010004-000110010-00000	1902-1.04-11.10	34	037	7 WINDING WAY		NJ	CURRENT OWNER	7 WINDING WAY	ANDOVER, NJ	NJ	07821	SUSSEX	01360	ANDOVER	373500	3735	1190.3396	2023-10-25	34037C	2025-09-03	X	AREA OF MINIMAL FLOOD HAZARD	1	1SS-F,F	R0.5	0.2900	PERSON	130X102	10278	1626	2026.2
1904-003370001-000400000-00000	1904-337.01-40	34	037	46 LYNN DR		NJ	CURRENT OWNER	46 LYNN DR	ANDOVER, NJ	NJ	07821	SUSSEX	09160	BYRAM	374400	3744	1778.4550	2025-12-17	34037C	2025-09-03	X	AREA OF MINIMAL FLOOD HAZARD	1	1SFO	R-3	0.4600	PERSON	.460 AC	10427	822	2026.2
1908-000700000-000060000-00000	1908-70-6	34	037	9 FOREST RD		NJ	CURRENT OWNER	9 FOREST RD	ANDOVER, NJ	NJ	07821	SUSSEX	27420	GREEN	374100	3741	743.1748	2016-02-04	34037C	2025-09-03	X	AREA OF MINIMAL FLOOD HAZARD	1	1SF-L-BIG	0004	0.1840	PERSON	80X100	3384	387	2026.2
1918-050160000-000350000-00000	1918-5016-35	34	037	19 LEWIS LN		NJ	CURRENT OWNER	19 LEWIS LN	SPARTA, NJ	NJ	07871	SUSSEX	69690	SPARTA	373400	3734	1301.5154	2024-08-28	34037C	2025-09-03	X	AREA OF MINIMAL FLOOD HAZARD	1	RANCH	R-3	0.3200	PERSON	100X125	10339	933	2026.2
1911-000630000-000170000-00000	1911-63-17	34	037	3356 RT 94		NJ	CURRENT OWNER	3356 ROUTE 94	HAMBURG, NJ	NJ	07419	SUSSEX	29850	HARDYSTON	372500	3725	788.9328	2024-10-04	34037C	2025-09-03	X	AREA OF MINIMAL FLOOD HAZARD	1	1SF	R-C	0.4200	PERSON	.420 AC	10343	1	2026.2
1908-001040000-000070000-00000	1908-104-7	34	037	98 MACKERLEY RD		NJ	CURRENT OWNER	98 MACKERLEY RD	NEWTON, NJ	NJ	07860	SUSSEX	27420	GREEN	374100	3741	11432.1435	2022-11-18	34037C	2025-09-03	X	AREA OF MINIMAL FLOOD HAZARD	1	2SF-L-BIG	0005	2.7300	PERSON	2.73 ACS	3656	746	2026.2
1912-104170000-000080000-00000	1912-10417-8	34	037	27 MORRIS RD		NJ	CURRENT OWNER	27 MORRIS RD	STANHOPE, NJ	NJ	07874	SUSSEX	32910	HOPATCONG	374800	3748	439.9984	2022-11-04	34037C	2025-09-03	X	AREA OF MINIMAL FLOOD HAZARD	1	1SF	R-1	0.1150	PERSON	50X100	3655	928	2026.2
1906-006070000-000550000-00000	1906-607-55	34	037	47 NESTOR ST		NJ	CURRENT OWNER	47 NESTOR ST	FRANKLIN, NJ	NJ	07416	SUSSEX	24930	FRANKLIN	372900	3729	488.3087	2013-07-22	34037C	2025-09-03	X	AREA OF MINIMAL FLOOD HAZARD	1	1SF-R-UG	R-4	0.1210	PERSON	.121 AC	3316	661	2026.2
1904-000170000-005240000-00000	1904-17-524	34	037	8 ADAIR ST		NJ	CURRENT OWNER	8 ADAIR ST	STANHOPE, NJ	NJ	07874	SUSSEX	09160	BYRAM	374200	3742	918.2180	2022-01-20	34037C	2025-09-03	X	AREA OF MINIMAL FLOOD HAZARD	1	1SF	R-5	0.2200	PERSON	.229 AC	3623	574	2026.2
1918-160100000-000090000-00000	1918-16010-9	34	037	31 PROSPER PL		NJ	CURRENT OWNER	31 PROSPER PL	SPARTA, NJ	NJ	07871	SUSSEX	69690	SPARTA	373100	3731	499.5757	2020-03-09	34037C	2025-09-03	X	AREA OF MINIMAL FLOOD HAZARD	1	COLUMBIA	PVC	0.1210	PERSON	.121 ACS	3552	48	2026.2
1912-107110000-000070000-00000	1912-10711-7	34	037	2 LAWRIE AVE		NJ	CURRENT OWNER	2 LAWRIE AVE	HOPATCONG, NJ	NJ	07843	SUSSEX	32910	HOPATCONG	374800	3748	365.6330	2020-01-17	34037C	2025-09-03	X	AREA OF MINIMAL FLOOD HAZARD	1	1SF	R-1	0.0920	PERSON	40X100	3548	171	2026.2
1915-000170002-000140000-00000	1915-17.02-14	34	037	9 MASON AVE		NJ	CURRENT OWNER	9 MASON AVE	NEWTON, NJ	NJ	07860	SUSSEX	51930	NEWTON	373800	3738	835.4140	2023-11-27	34037C	2025-09-03	X	AREA OF MINIMAL FLOOD HAZARD	1I	1SF	T-3	0.2170	PERSON	00000.217 AC.	10283	460	2026.2
1912-111080000-000110000-00000	1912-11108-11	34	037	8	BERGEN	NJ	CURRENT OWNER	8 BERGEN TR	HOPATCONG, NJ	NJ	07843	SUSSEX	32910	HOPATCONG	374900	3749	563.2564	2018-04-11	34037C	2025-09-03	X	AREA OF MINIMAL FLOOD HAZARD	1		R-1	0.1380	PERSON	60X100	3473	127	2026.2
1922-005400000-000130000-00000	1922-540-13	34	037	30 ERIC TRL		NJ	CURRENT OWNER	30 ERIC TRL	SUSSEX, NJ	NJ	07461	SUSSEX	75740	VERNON	371700	3717	5789.1431	1989-12-22	34037C	2025-09-03	X	AREA OF MINIMAL FLOOD HAZARD	1	1S FV 2 2BG	R-3	1.4300	PERSON	1.43 AC	1700	349	2026.2