Saved query 61dca04725800ee5

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 = '035'

132,879 matching parcels

Data Preview

parcelid	statefp	countyfp	parceladdr	parcelcity	parcelstate	parcelzip	countyname	cousubfp	cousubname	tractce	tractname	calcarea	imprvalue	landvalue	totalvalue	saleamt	saledate	numbldgs	numunits	firmid	firmdate	fldzone	zonesubty	elevmin	elevmax	elevavg	usecode	usedesc	zoningcode	taxacres	naicscode	legaldesc	book	page	placename	placetype	taxdistrict
1808 468 07 44 01	34	035	97 CEDAR GROVE LA	Franklin Township	NJ	08873	Somerset	24900	Franklin	054301	543.0100	3736.2929	1612200	237800	1850000	1600000	2021-12-03	1	1	34035C	2025-09-03	X	AREA OF MINIMAL FLOOD HAZARD	23.5238	25.2333	24.2300	999	Commercial	CR	0.8700	6212	.87 ACRE	7413	2352	CEDAR GROVE DENTAL ASSOCIATES	DENTAL_CLINIC	87
1808 507 15 1 02	34	035	441 ELIZABETH AVENUE	Franklin Township	NJ	08873	Somerset	24900	Franklin	054301	543.0100	19615.1745	7000000	3000000	10000000	1650000	2011-06-21	1	1	34035C	2025-09-03	X	AREA OF MINIMAL FLOOD HAZARD	24.0354	26.9973	26.2810	999	Commercial	B-I	4.8190	8121	4.819 AC	6431	608	MARCOS ACEVEDO BARBERING	PERSONAL_OR_BEAUTY_SERVICE	75
1816 91 14	34	035	28 W SOMERSET ST	Raritan Borough	NJ	08869	Somerset	61980	Raritan	050500	505	528.1528	501000	124000	625000	10	2021-01-20	1	1	34035C	2025-09-03	X	AREA OF MINIMAL FLOOD HAZARD	19.0765	19.6303	19.3933	738	Commercial		0.1293	4855	49X115	7299	3658	BLUE STAR CARTING	PUBLIC_UTILITY	22
1818 115 26 01	34	035	190 W MAIN ST	Somerville Borough	NJ	08876	Somerset	68460	Somerville	050100	501	812.1798	1142100	264000	1406100	1	2016-01-26	1	1	34035C	2025-09-03	X	AREA OF MINIMAL FLOOD HAZARD	19.3182	20.5490	19.8451	999	Commercial		0.1561	722511	40X170	6851	2280	AVORA	RESTAURANT	12
1806 444 41 01	34	035	846- N BRANCH RD	Bridgewater Township	NJ	08807	Somerset	07720	Bridgewater	050801	508.0100	12917.3693	57400	295100	352500		2000-10-31	1	1	34035C	2025-09-03	X	AREA OF MINIMAL FLOOD HAZARD	39.9089	46.4195	43.2488		Commercial		3.3353	92111	3.3353	2324	829	JUNIPER LANE SWIM CLUB	CORPORATE_OR_BUSINESS_OFFICE	9
1805 61 01 12	34	035	438 WINDMILL WAY	Branchburg Township	NJ	08876	Somerset	07180	Branchburg	053602	536.0200	3573.7307	488900	185000	673900	100	2025-04-22	1	1	34035C	2025-09-03	X	AREA OF MINIMAL FLOOD HAZARD	37.0279	40.0704	38.5261	000	Residential	LD	0.9000		0.9000	7612	2315			8.0200
1818 58 01 30	34	035	63 HAMILTON ST.	Somerville Borough	NJ	08876	Somerset	68460	Somerville	050400	504	948.8493	128900	61200	190100	299000	2023-12-13	1	1	34035C	2025-09-03	X	AREA OF MINIMAL FLOOD HAZARD	14.7164	16.8690	16.2477	000	Residential	R-2	0.1862		61X133	7538	2602			6
1819 11 14	34	035	224 BECK AVENUE	South Bound Brook Borough	NJ	08880	Somerset	68730	South Bound Brook	053000	530	463.5684	147800	91000	238800	215000	2026-02-24	1	1	34035C	2025-09-03	X	AREA OF MINIMAL FLOOD HAZARD	19.4168	20.3931	19.9078	000	Residential	R-2	0.1148		50X100	7672	1274			2
1802 4301 5	34	035	42 COLTS GLEN LN	Bernards Township	NJ	07920	Somerset	05560	Bernards	052604	526.0400	47171.0850	2988600	653900	3642500	1	2026-02-04	1	1	34035C	2025-09-03	X	AREA OF MINIMAL FLOOD HAZARD	126.0420	150.3281	133.2989	000	Residential	R1	11.3300		11.33AC	7664	402			43
1810 205 13 14	34	035	30 COLLINS DRIVE	Hillsborough Township	NJ	08844	Somerset	31890	Hillsborough	053807	538.0700	1951.4514	442600	449100	891700	306997	1997-12-19	1	1	34035C	2025-09-03	X	AREA OF MINIMAL FLOOD HAZARD	29.1290	30.8561	30.0565		Residential	RA	0.4820		0.4820	2153	610			140
1808 367 14	34	035	7 HEINRICH RD	Franklin Township	NJ	08873	Somerset	24900	Franklin	053103	531.0300	1156.8854	203400	362200	565600	100	2008-08-14	1	1	34035C	2025-09-03	X	AREA OF MINIMAL FLOOD HAZARD	29.3904	32.1603	31.2229		Residential	R20	0.2792		80X152 AVG	6162	2942			6102
1809 116 13 11	34	035	7 BEECHWOOD TERRACE	Green Brook Township	NJ	08812	Somerset	27510	Green Brook	052100	521	1869.7877	462300	360500	822800	630000	2014-07-25	1	1	34035C	2025-09-03	X	AREA OF MINIMAL FLOOD HAZARD	41.4485	55.3918	49.8128		Residential	SMD	0.4600		0.46 AC	6737	1682			18
1810 163 04 7	34	035	57 NEW AMWELL ROAD	Hillsborough Township	NJ	08844	Somerset	31890	Hillsborough	053705	537.0500	2625.4918	130700	272400	403100	1	2025-07-10	1	1	34035C	2025-09-03	X	AREA OF MINIMAL FLOOD HAZARD	31.6599	33.2599	32.4429		Residential	CR	0.6480		0.6480	7626	2869			86
1810 162 17	34	035	3 CUMBERLAND ROAD	Hillsborough Township	NJ	08844	Somerset	31890	Hillsborough	053804	538.0400	2025.4084	159100	380000	539100	632000	2025-06-30	1	1	34035C	2025-09-03	X	AREA OF MINIMAL FLOOD HAZARD	30.0526	31.2779	30.4751		Residential	CR	0.5000		0.5000	7626	1660			56
1819 40 6	34	035	220 MAPLE AVENUE	South Bound Brook Borough	NJ	08880	Somerset	68730	South Bound Brook	053000	530	414.1751	135900	106000	241900	255000	2008-10-28	1	1	34035C	2025-09-03	X	AREA OF MINIMAL FLOOD HAZARD	14.0866	16.2818	15.6505		Residential	R-2	0.1148		50X100	6172	821			12
1806 473 24	34	035	656 THRUWAY DRIVE	Bridgewater Township	NJ	08807	Somerset	07720	Bridgewater	050802	508.0200	3437.5586	388400	253700	642100	792000	2025-04-11	1	1	34035C	2025-09-03	X	AREA OF MINIMAL FLOOD HAZARD	31.0787	32.8110	32.2111	000	Residential		0.6492		101X280	7613	2680			62
1808 474 15	34	035	33 MARCY ST	Franklin Township	NJ	08873	Somerset	24900	Franklin	053501	535.0100	955.0310	189800	370900	560700	295000	2017-08-30	1	1	34035C	2025-09-03	X	AREA OF MINIMAL FLOOD HAZARD	12.4825	13.2342	12.9125		Residential	R10	0.2360		106X97	6987	2963			9501
1808 11 18 16 01	34	035	88 TREETOPS CIR	Franklin Township	NJ	08540	Somerset	24900	Franklin	053402	534.0200	921.9334	520800	406000	926800	568500	2007-08-29	1	1	34035C	2025-09-03	X	AREA OF MINIMAL FLOOD HAZARD	58.6654	59.7097	59.2970		Residential	R10A	0.2300		.230 ACRES	6066	3015			16
1808 11 09 47	34	035	12 COLTS RUN RD	Franklin Township	NJ	08540	Somerset	24900	Franklin	053402	534.0200	983.8763	496400	450000	946400	507500	2013-09-27	1	1	34035C	2025-09-03	X	AREA OF MINIMAL FLOOD HAZARD	58.0452	60.3783	59.1042		Residential	R10A	0.2300		.230 ACRES	6674	921			16
1803 7 3 01	34	035	41 CARRIAGE HOUSE RD.	Bernardsville Borough	NJ	07924	Somerset	05590	Bernardsville	052702	527.0200	22039.5944	871100	762000	1633100	1400000	2020-12-15	1	1	34035C	2025-09-03	X	AREA OF MINIMAL FLOOD HAZARD	207.4134	220.1505	214.8896		Residential	R110	5.0800		5.08AC	7301	1463			07
1813 7019 27	34	035	87 ADAMS DRIVE	Montgomery Township	NJ	08502	Somerset	47580	Montgomery	053905	539.0500	4055.7476	334500	208000	542500	960000	2022-06-06	1	1	34035C	2025-09-03	X	AREA OF MINIMAL FLOOD HAZARD	16.7576	29.0999	25.0253	000	Residential		1.0020		1.002 AC	7449	1078			21
1809 143 4	34	035	31 ROCK ROAD W.	Green Brook Township	NJ	08812	Somerset	27510	Green Brook	052100	521	1931.7593	401700	436800	838500	870000	2024-05-16	1	1	34035C	2025-09-03	X	AREA OF MINIMAL FLOOD HAZARD	154.1046	159.2290	156.2431		Residential	LD1	0.3788		110X150 AV.	7560	775			24
1819 67 33	34	035	10 ARMSTRONG STREET	South Bound Brook Borough	NJ	08880	Somerset	68730	South Bound Brook	053000	530	656.1934	171200	108000	279200		2024-02-27	1	1	34035C	2025-09-03	X	AREA OF MINIMAL FLOOD HAZARD	14.5266	15.4765	14.9341	000	Residential	R-3	0.1522		85X78 AVG	7547	1246			16
1810 145 2	34	035	6 BEEKMAN LANE	Hillsborough Township	NJ	08844	Somerset	31890	Hillsborough	053707	537.0700	8916.5085	346600	310000	656600	241000	1997-10-20	1	1	34035C	2025-09-03	X	AREA OF MINIMAL FLOOD HAZARD	23.4064	30.2131	27.1038		Residential	RS	2		2.0000	2145	300			6
1805 76 6	34	035	512 WHITON RD	Branchburg Township	NJ	08853	Somerset	07180	Branchburg	053602	536.0200	5570.1506	294500	179200	473700	385000	2021-07-01	1	1	34035C	2025-09-03	X	AREA OF MINIMAL FLOOD HAZARD	44.8448	54.8972	50.2758		Residential	LD	1.3600		1.36 AC	7362	3110			11