Saved query f15829f9590861b6

Data Explorer

Query the US Nationwide Parcel Dataset

$1.75 / 1,000 records$100 minimum

0/80

Live SQL

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

76,567 matching parcels

Data Preview

parcelid	taxacctnum	statefp	countyfp	parceladdr	parcelcity	parcelstate	parcelzip	ownername	owneraddr	ownercity	ownerstate	ownerzip	countyname	cousubfp	cousubname	tractce	tractname	calcarea	saledate	numbldgs	firmid	firmdate	fldzone	zonesubty	usecode	usedesc	zoningcode	taxacres	ownertype	naicscode	legaldesc	book	page	placename	placetype
1907-018010000-000120002-Q0030	1907-1801-12.02-Q0030	34	037	67-107 PHIL HARDIN RD	NEWTON	NJ	07860	CURRENT OWNER	65 FREDONIA RD	NEWTON, NJ	NJ	07860	SUSSEX	25140	FREDON	374000	3740	155952.7022	2008-05-22	1	34037C	2025-09-03	X	AREA OF MINIMAL FLOOD HAZARD	3B		AR-6	38.8300	PERSON	11111	38.83 AC	3202	803	SPRINGHOUSE CREAMERY	FARM
1902-001540000-000470000-00000	1902-154-47	34	037	470 RT 206 SO	NEWTON	NJ	07860	CURRENT OWNER	PO BOX 400	BUDD LAKE, NJ	NJ	07828	SUSSEX	01360	ANDOVER	373600	3736	5915.7014	2007-08-22	2	34037C	2025-09-03	X	AREA OF MINIMAL FLOOD HAZARD	4A	1SCB-A	R0.5	1.4000	PERSON		1.40 AC	3167	281	A&B BAGELS AND DELI	CASUAL_EATERY
1912-505070000-000150000-00000	1912-50507-15	34	037	18 DIBERT RD	ANDOVER	NJ	07821	CURRENT OWNER	18 DIBERT RD	ANDOVER, NJ	NJ	07821	SUSSEX	32910	HOPATCONG	374500	3745	2440.6393	2023-12-29	1	34037C	2025-09-03	X	AREA OF MINIMAL FLOOD HAZARD	1	1SF 1UG	R-1	0.5960	PERSON		87X323	10295	513
1924-000540000-000040012-00000	1924-54-4.12	34	037	53 SHERMAN RIDGE RD	SUSSEX	NJ	07461	CURRENT OWNER	53 SHERMAN RIDGE RD	WANTAGE, NJ	NJ	07461	SUSSEX	76790	WANTAGE	371802	3718.0200	16853.5049	2012-03-02	1	34037C	2025-09-03	X	AREA OF MINIMAL FLOOD HAZARD	2	1SF	R-5	4.2200	PERSON		4.22 AC	3286	527
1912-402100000-000130000-00000	1912-40210-13	34	037	12 JEFFERSON TRL	HOPATCONG	NJ	07843	CURRENT OWNER	20 MAPLE TERRACE	STANHOPE, NJ	NJ	07874	SUSSEX	32910	HOPATCONG	374900	3749	383.7064	2023-06-05	1	34037C	2025-09-03	X	AREA OF MINIMAL FLOOD HAZARD	1	1SF	R-1	0.0950	PERSON		40X103	10257	1082
1920-004120000-000090000-00000	1920-412-9	34	037	902 PRIMROSE PATH	NEWTON	NJ	07860	CURRENT OWNER	902 PRIMROSE PATH	NEWTON, NJ	NJ	07860	SUSSEX	70890	STILLWATER	373900	3739	1047.2488	1997-07-30	1	34037C	2025-09-03	X	AREA OF MINIMAL FLOOD HAZARD	1	1SF-R-AG	R5A	0.2190	PERSON		75X127 AV	2231	345
1912-202100000-000150000-00000	1912-20210-15	34	037	59 LEO AVE	STANHOPE	NJ	07874	CURRENT OWNER	PO BOX 157	MT. FREEDOM NJ	NJ	07970	SUSSEX	32910	HOPATCONG	374800	3748	1132.5050	2016-01-11	1	34037C	2025-09-03	X	AREA OF MINIMAL FLOOD HAZARD	1	1SF	R-1	0.2870	PERSON		100X150IRR	3383	52
1904-001330000-000100000-00000	1904-133-10	34	037	10 LAKEVIEW TRL	ANDOVER	NJ	07821	CURRENT OWNER	307 STATE ST	MT BETHEL, PA	PA	18343	SUSSEX	09160	BYRAM	374200	3742	929.1002	1998-12-23	1	34037C	2025-09-03	X	AREA OF MINIMAL FLOOD HAZARD	1	1SF	R-5	0.2300	PERSON		.230 AC	2345	171
1905-001490000-000070000-00000	1905-149-7	34	037	5 ORCHARD ST	BRANCHVILLE	NJ	07826	CURRENT OWNER	5 ORCHARD ST	BRANCHVILLE, NJ	NJ	07826	SUSSEX	24810	FRANKFORD	372200	3722	1967.4909	2006-09-08	1	34037C	2025-09-03	X	AREA OF MINIMAL FLOOD HAZARD	1	2SF	AR	0.2296	PERSON		100X100	3077	150
1918-040080000-000570000-00000	1918-4008-57	34	037	240 ALPINE TRL	SPARTA	NJ	07871	CURRENT OWNER	240 ALPINE TRL	SPARTA, NJ	NJ	07871	SUSSEX	69690	SPARTA	373100	3731	3223.1996	2009-12-28	1	34037C	2025-09-03	X	AREA OF MINIMAL FLOOD HAZARD	1	COLONIAL	R-3	0.8000	PERSON		77X416 LMCC	3241	691
1902-001090000-000010000-00000	1902-109-1	34	037	210 MC PEEK RD	LAFAYETTE	NJ	07848	CURRENT OWNER	210 MCPEEK RD	LAFAYETTE, NJ	NJ	07848	SUSSEX	01360	ANDOVER	373600	3736	4714.8936	2013-07-10	1	34037C	2025-09-03	X	AREA OF MINIMAL FLOOD HAZARD	1	1.5SF-0	R-2	1.3700	PERSON		1.37 AC	3316	386
1912-403030000-000060000-00000	1912-40303-6	34	037	118 VERMONT TRL	HOPATCONG	NJ	07843	CURRENT OWNER	118 VERMONT TR	HOPATCONG, NJ	NJ	07843	SUSSEX	32910	HOPATCONG	374500	3745	377.6399	2017-05-18	1	34037C	2025-09-03	X	AREA OF MINIMAL FLOOD HAZARD	1	1SF	R-1	0.0920	PERSON		40X100	3430	603
1918-040020000-000090000-00000	1918-4002-9	34	037	104 VALLEY VIEW TRL	SPARTA	NJ	07871	CURRENT OWNER	104 VALLEY VIEW TRL	SPARTA, NJ	NJ	07871	SUSSEX	69690	SPARTA	373400	3734	1424.6140	1994-12-30	1	34037C	2025-09-03	X	AREA OF MINIMAL FLOOD HAZARD	1	RANCH	R-3	0.3500	PERSON		80X194 LMCC	2067	20
1922-002910000-000390000-00000	1922-291-39	34	037	100 TALL TIMBERS RD	SUSSEX	NJ	07461	CURRENT OWNER	100 TALL TIMBERS RD	SUSSEX, NJ	NJ	07461	SUSSEX	75740	VERNON	371300	3713	10969.8130	1984-03-30	2	34037C	2025-09-03	X	AREA OF MINIMAL FLOOD HAZARD	1	TRAILER PARK	SR	2.7100	PERSON		2.71 AC	1174	40
1920-035030000-000040001-00000	1920-3503-4.01	34	037	950 FREDON RD	NEWTON	NJ	07860	CURRENT OWNER	950 FREDON RD	NEWTON, NJ	NJ	07860	SUSSEX	70890	STILLWATER	373900	3739	5591.0832	2004-06-11	1	34037C	2025-09-03	X	AREA OF MINIMAL FLOOD HAZARD	1	1SF-2-BG	R3A	1.6210	PERSON		1.621 AC	2828	315
1906-006010000-000320000-00000	1906-601-32	34	037	53 STERLING ST	FRANKLIN	NJ	07416	CURRENT OWNER	53 STERLING ST	FRANKLIN, NJ	NJ	07416	SUSSEX	24930	FRANKLIN	372900	3729	947.6198	2002-03-22	1	34037C	2025-09-03	X	AREA OF MINIMAL FLOOD HAZARD	1	1SF-R-UG	R-4	0.2340	PERSON		.234 AC	2623	253
1918-040150000-000170000-00000	1918-4015-17	34	037	14 SUMMIT RD	SPARTA	NJ	07871	CURRENT OWNER	14 SUMMIT RD	SPARTA, NJ	NJ	07871	SUSSEX	69690	SPARTA	373100	3731	565.1323	1999-09-28	1	34037C	2025-09-03	X	AREA OF MINIMAL FLOOD HAZARD	1	RANCH	R-3	0.1400	PERSON		60X100 LMCC	2410	28
1915-000210004-000020000-00000	1915-21.04-2	34	037	25 YORK RD	NEWTON	NJ	07860	CURRENT OWNER	25 YORK RD	NEWTON, NJ	NJ	07860	SUSSEX	51930	NEWTON	373800	3738	859.5156	2002-03-19	1	34037C	2025-09-03	X	AREA OF MINIMAL FLOOD HAZARD	1	1SF-2-1AG	T-3	0.2080	PERSON		00000.208 AC.	2629	29
1913-000050002-000210000-00000	1913-5.02-21	34	037	22 HAMPTON HEIGHTS RD	LAFAYETTE	NJ	07848	CURRENT OWNER	22 HAMPTON HEIGHTS RD	LAFAYETTE, NJ	NJ	07848	SUSSEX	37440	LAFAYETTE	372400	3724	1825.3444	2023-08-11	1	34037C	2025-09-03	X	AREA OF MINIMAL FLOOD HAZARD	1	F1S	R01	0.4800	PERSON		.48 AC	10264	442
1910-018010000-000480000-00000	1910-1801-48	34	037	7 RT 521	HAMPTON	NJ	07860	CURRENT OWNER	7 RT 521	NEWTON, NJ	NJ	07860	SUSSEX	29490	HAMPTON	372000	3720	3319.5197	1996-05-01	1	34037C	2025-09-03	X	AREA OF MINIMAL FLOOD HAZARD	1	1SF	R-3	1.0040	PERSON		1.004 AC	2171	99
1912-304020000-000070000-00000	1912-30402-7	34	037	201 CHINCOPEE AVE	HOPATCONG	NJ	07843	CURRENT OWNER	201 CHINCOPEE AVE	HOPATCONG, NJ	NJ	07843	SUSSEX	32910	HOPATCONG	374700	3747	1548.3486	2016-02-19	1	34037C	2025-09-03	X	AREA OF MINIMAL FLOOD HAZARD	1	1SF1G	R-1	0.4020	PERSON		100X175	3384	815
1911-000200000-000210017-00000	1911-20-21.17	34	037	3 CARRIAGE LN	HAMBURG	NJ	07419	CURRENT OWNER	149A WHEATSWORTH RD	HARDYSTON, NJ	NJ	07419	SUSSEX	29850	HARDYSTON	372600	3726	1983.1835	1998-12-18	1	34037C	2025-09-03	X	AREA OF MINIMAL FLOOD HAZARD	15C	DETENTION BASIN	MID3	0.5400	PERSON		.540 AC	2341	316
1918-040170000-000510000-00000	1918-4017-51	34	037	6 BROMLEY CT	SPARTA	NJ	07871	CURRENT OWNER	6 BROMLEY CT	SPARTA, NJ	NJ	07871	SUSSEX	69690	SPARTA	373100	3731	4053.4357	2020-09-01	1	34037C	2025-09-03	X	AREA OF MINIMAL FLOOD HAZARD	1	COLONIAL	RR	1	PERSON		1 AC	3572	994
1917-004010000-000150001-00000	1917-401-15.01	34	037	46 FLATBROOK RD	BRANCHVILLE	NJ	07826	CURRENT OWNER	46 FLATBROOK RD	BRANCHVILLE, NJ	NJ	07826	SUSSEX	65700	SANDYSTON	371900	3719	7899.9426	2005-11-17	1	34037C	2025-09-03	X	AREA OF MINIMAL FLOOD HAZARD	1	1SF-2	D 2A	1.8200	PERSON		1.82 AC	2991	156
1924-000330000-000190000-00000	1924-33-19	34	037	10 MOORE RD	SUSSEX	NJ	07461	CURRENT OWNER	10 MOORE RD	WANTAGE, NJ	NJ	07461	SUSSEX	76790	WANTAGE	371100	3711	1622.1350	2018-09-14	1	34037C	2025-09-03	X	AREA OF MINIMAL FLOOD HAZARD	2	2 SF	R-5	0.5100	PERSON		0.51 AC	3493	12