Saved query a069f0c6e38a21fb

Data Explorer

Query the US Nationwide Parcel Dataset

$1.75 / 1,000 records$100 minimum

45/80

Live SQL

SELECT * 
FROM "parcel_layer" 
WHERE statefp = '33' 
  AND countyfp = '019'

26,025 matching parcels

Data Preview

parcelid	taxacctnum	statefp	countyfp	parceladdr	parcelcity	parcelstate	parcelzip	owneraddr	ownercity	ownerstate	ownerzip	countyname	cousubfp	cousubname	tractce	tractname	calcarea	imprvalue	landvalue	totalvalue	saleamt	saledate	numbldgs	numunits	yearbuilt	numfloors	bldgsqft	bedrooms	fullbaths	firmid	firmdate	fldzone	zonesubty	elevmin	elevmax	elevavg	usecode	usedesc	zoningcode	ownertype	naicscode	book	page	placename	placetype	heating	heatfuel	cooling	roofcover	siding	taxyear
142-24	21960	33	019	4 MARCOTTE AVE	Claremont	NH	03743	4 MARCOTTE AVE	CLAREMONT	NH	03743	Sullivan	12900	Claremont	975800	9758	1146.3900	182900	38700	221600	185000	2021-08-04	1	1	1954	1	1296	3	2	33019C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	193.8289	198.6128	196.3040	101	1 Family MDL-01	R1	PERSON		2162	0342			HOT WATER	OIL	MINI SPLIT	ASPHALT SHNGL	VINYL	2026
133-82	16930	33	019	5 JUNIPER HILL	Claremont	NH	03743	5 JUNIPER HILL	CLAREMONT	NH	03743	Sullivan	12900	Claremont	975902	9759.0200	950.7590	176300	37900	214200	119530	2018-05-18	1	1	1957	1	1225	3	1	33019C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	192.3313	198.1127	195.4582	101	1 Family MDL-01	CR1	PERSON		2038	0327			HOT WATER	OIL	NO COOLING	ASPHALT SHNGL	WOOD SHINGLE	2026
133-95	16340	33	019	25 HARTFORD ST	Claremont	NH	03743	8 DEVON ST	CLAREMONT	NH	03743	Sullivan	12900	Claremont	975902	9759.0200	1385.9715	135100	39700	174800	175000	2024-11-27	1	1	1897	2	2184	5	3	33019C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	170.4082	175.1994	172.5463	102M	2 Family MDL-03	CR1	BUSINESS		2276	687			HOT WATER	OIL	NO COOLING	ASPHALT SHNGL	VINYL	2026
116-015000	2089	33	019	43 HAMMOND ACRES	CHARLESTOWN	NH	03603	43 HAMMOND ACRES	CHARLESTOWN	NH	03603	Sullivan	11380	Charlestown	975700	9757	1521.4924	134900	26300	161200	89900	1999-06-21	1	1	1988	1	1405	3	2	33019C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	109.0198	114.3734	112.7323	1010	Single Family		TRUST		1193	0634			HOT WATER	OIL	NO COOLING	ASPH/FBRGL	VINYL SIDING	2022
106-070000	505	33	019	16 MICHAEL AVENUE	CHARLESTOWN	NH	03603	207 TWISTBACK RD	CLAREMONT	NH	03743	Sullivan	11380	Charlestown	975700	9757	1219.9590	170600	34200	204800	300000	2023-10-26	1	1	1975	1	1546	3	3	33019C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	145.5182	146.9198	146.3604	1011	Sing. Fam. w Inlaw		PERSON		2243	88			HOT WATER	OIL	NO COOLING	METAL	VINYL SIDING	2022
154-15	40500	33	019	4 CLOVER ST	Claremont	NH	03743	4 CLOVER ST	CLAREMONT	NH	03743	Sullivan	12900	Claremont	975800	9758	1755.4415	166600	40700	207300	260000	2024-07-02	1	1	1954	1	1199	3	1	33019C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	198.9049	204.7211	200.9267	101	1 Family MDL-01	R1	PERSON		2262	590			HOT WATER	OIL	NO COOLING	ASPHALT SHNGL	CLAPBOARD	2026
131-205	22380	33	019	193 PLEASANT ST	Claremont	NH	03743	120 MAPLE AVE	CLAREMONT	NH	03743	Sullivan	12900	Claremont	975902	9759.0200	429.2179	144200	15900	160100	20000	2018-05-02	1	1	1910	1	1435	3	1	33019C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	170.1668	171.0284	170.7009	101	1 Family MDL-01	PR	PERSON		2037	0516			CENTRAL AIR	OIL	NO COOLING	ASPHALT SHNGL	ASBEST SHINGLE	2026
131-41	26860	33	019	96 SUMMER ST	Claremont	NH	03743	96 SUMMER ST	CLAREMONT	NH	03743	Sullivan	12900	Claremont	975902	9759.0200	1407.0239	232100	61800	293900	233900	2017-12-22	1	1	1935	1	5927			33019C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	162.0316	166.1332	163.3522	332	Auto Repr MDL-94	CR2	BUSINESS	6216	2028	0173	JOE'S FAMILY CAR CARE	AUTOMOTIVE_SERVICE	CENTRAL AIR		CENTRAL AIR	ASPHALT SHNGL	PRE-FAB WOOD	2026
233-042000	903	33	019	38 KINSON LANE	CHARLESTOWN	NH	03603	PO BOX 22	CHARLESTOWN	NH	03603	Sullivan	11380	Charlestown	975700	9757	13370.3367	40300	39600	79900	90000	2007-08-02	1	1	1984	1	924	2	2	33019C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	135.6308	154.4723	144.3676	1030	Mobile Home		PERSON		1652	0794			CENTRAL AIR	OIL	NO COOLING	METAL	VINYL SIDING	2022
114-024000	780	33	019	1064 OLD CLAREMONT ROAD	CHARLESTOWN	NH	03603	1064 OLD CLAREMONT RD	CHARLESTOWN	NH	03603	Sullivan	11380	Charlestown	975700	9757	9180.0505	144900	26400	171300	50000	1900-03-24	1	1	1800	2	2892	6	3	33019C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	140.0960	150.3589	146.6195	1010	Single Family		PERSON		1028	0727			HOT WATER	OIL	NO COOLING	METAL	VINYL SIDING	2022
101-015000	2699	33	019	18 OLD CLAREMONT ROAD	CHARLESTOWN	NH	03603	18 OLD CLAREMONT ROAD	CHARLESTOWN	NH	03603	Sullivan	11380	Charlestown	975700	9757	188284.8322	156500	50840	207340	275000	2015-04-23	1	1	1994	1	1144	2	2	33019C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	101.6002	202.8397	160.7102	1010	Single Family		PERSON		1941	0401			CENTRAL AIR	OIL	NO COOLING	ASPH/FBRGL	VINYL SIDING	2022
129-90	31400	33	019	6 BECKWITH AVE	Claremont	NH	03743	PO BOX 66	WINDSOR	VT	05089	Sullivan	12900	Claremont	975800	9758	1042.2722	171700	38300	210000	207500	2022-04-29	1	1	1940	1	1117	2	1	33019C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	163.6638	164.4559	163.9934	101	1 Family MDL-01	R1	PERSON		2193	0384			CENTRAL AIR	OIL	NO COOLING	STANDING SEAM	VINYL	2026
143-96	20010	33	019	278 PLEASANT ST	Claremont	NH	03743	278 PLEASANT ST	CLAREMONT	NH	03743	Sullivan	12900	Claremont	975902	9759.0200	1267.2989	195400	23800	219200	362000	2026-02-17	1	1	1930	2	3380	7	3	33019C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	181.7319	185.7528	183.4781	103M	3 Family MDL-03	R1	PERSON		2317	242			HOT WATER	OIL	NO COOLING	ASPHALT SHNGL	CLAPBOARD	2026
107-127	9050	33	019	300 MAIN ST	Claremont	NH	03743	300 MAIN ST	CLAREMONT	NH	03743	Sullivan	12900	Claremont	975800	9758	1643.4925	262800	16100	278900	259900	2021-08-02	1	1	1900	1	2048	2	2	33019C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	129.8355	134.1810	132.6250	101	1 Family MDL-01	CB2	PERSON		2162	0026			HOT WATER	OIL	NO COOLING	ASPHALT SHNGL	CLAPBOARD	2026
129-156	62380	33	019	17 42ND ST	Claremont	NH	03743	17 42ND ST	CLAREMONT	NH	03743	Sullivan	12900	Claremont	975800	9758	2000.3902	132900	41700	174600	103000	2017-07-12	1	1	1934	1	947	2	1	33019C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	155.8601	159.7165	158.0390	101	1 Family MDL-01	R1	PERSON		2012	0669			HOT WATER	OIL	NO COOLING	ASPHALT SHNGL	WALL BOARD	2026
225-263-000		33	019	11 FAIRWAY DRIVE	GRANTHAM	NH	03753	PO BOX 1709	GRANTHAM	NH	03753	Sullivan	31220	Grantham	975200	9752	3079.7241	398800	65600	464400	364000	2008-05-14	1	1	1989	2	2274	3	2	33019C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	340.4946	350.3964	346.5035	1014	SFR GOLF MDL-01	RR1	TRUST		1688	0291			HOT WATER	OIL	NO COOLING	ASPH/F GLS/CMP	CLAPBOARD	2022
216-028-000		33	019	1284 ROUTE 10 NORTH	GRANTHAM	NH	03753	3310 WILLIAMSBURG STREET	SARASOTA	FL	34231	Sullivan	31220	Grantham	975200	9752	6390.0284	217000	59900	276900	205000	2026-02-05	1	1	1850	1	1602	3	2	33019C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	354.1052	367.7864	360.5643	1010	SINGLE FAM MDL-01	RR1	PERSON		2316	534			CENTRAL AIR	OIL	NO COOLING	STAND SEAM	CLAPBOARD	2022
81-7	5840	33	019	243 OLD CHURCH RD	Claremont	NH	03743	243 OLD CHURCH RD	CLAREMONT	NH	03743	Sullivan	12900	Claremont	975800	9758	1383.3902	188600	39500	228100	44300	2001-07-20	1	1	1850	1	1575	3	1	33019C	2026-01-22	AE		107.8300	112.2621	110.7987	101	1 Family MDL-01	I2	PERSON		1265	0016			HOT WATER	OIL	NO COOLING	ASPHALT SHNGL	CLAPBOARD	2026
131-211	22410	33	019	20 WEST PLEASANT ST	Claremont	NH	03743	20 WEST PLEASANT ST	CLAREMONT	NH	03743	Sullivan	12900	Claremont	975902	9759.0200	499.9489	178600	17200	195800		1999-03-08	1	1	1857	1	1294	4	2	33019C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	170.5218	170.9694	170.7464	101	1 Family MDL-01	PR	TRUST		1182	0511			STEAM	OIL	NO COOLING	ASPHALT SHNGL	VINYL	2026
95-6	12690	33	019	246 NORTH ST	Claremont	NH	03743	246 NORTH ST	CLAREMONT	NH	03743	Sullivan	12900	Claremont	975901	9759.0100	672.3064	196000	32300	228300		2018-08-19	1	1	1920	2	1430	4	1	33019C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	155.8599	156.5089	156.2270	101	1 Family MDL-01	CR2	PERSON		2048	0995			HOT WATER	OIL	NO COOLING	STANDING SEAM	VINYL	2026
234-026-000		33	019	23 GREENSWARD DRIVE	GRANTHAM	NH	03753	PO BOX 1111	GRANTHAM	NH	03753	Sullivan	31220	Grantham	975200	9752	2823.4643	312200	61800	374000	415000	2022-12-06	1	1	1989	2	2411	3	1	33019C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	365.5410	369.5794	368.1263	1014	SFR GOLF MDL-01	RR1	PERSON		2216	360			HOT WATER	OIL	NO COOLING	ASPH/F GLS/CMP	WOOD ON SHEATH	2022
116-012000	1340	33	019	9 HAMMOND ACRES	CHARLESTOWN	NH	03603	9 HAMMOND ACRES	CHARLESTOWN	NH	03603	Sullivan	11380	Charlestown	975700	9757	1548.3376	147700	26700	174400		2025-03-10	1	1	1986	1	1673	3	1	33019C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	110.3053	115.6861	113.9326	1010	Single Family		TRUST		2284	877			HOT WATER	OIL	MINI SPLIT	ASPH/FBRGL	CLAPBOARD	2022
181-7	44914	33	019	8 MINCKLERS RD	Claremont	NH	03743	8 MINCKLERS RD	CLAREMONT	NH	03743	Sullivan	12900	Claremont	975902	9759.0200	7446.6714	258900	30800	289700		1990-01-02	1	1	1990	1	1914	2	2	33019C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	175.4705	190.9894	185.4189	101	1 Family MDL-01	RR	PERSON		0902	0749			FLOOR UNIT	GAS	NO COOLING	STANDING SEAM	PRE-FAB WOOD	2026
222-169-000		33	019	11 WHIP-POOR-WILL WALK	GRANTHAM	NH	03753	PO BOX 915	GRANTHAM	NH	03753	Sullivan	31220	Grantham	975200	9752	1700.0019	341600	36600	378200	295000	2007-09-25	1	1	1989	1	2308	3	2	33019C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	350.8667	355.9090	354.3380	1010	SINGLE FAM MDL-01	RR1	PERSON		1660	0084			HOT WATER	GAS	CENTRAL AIR	ASPH/F GLS/CMP	CLAPBOARD	2022
221-041-000		33	019	301 OLDE FARMS ROAD	GRANTHAM	NH	03753	4 TYLER ROAD	HANOVER	NH	03755	Sullivan	31220	Grantham	975200	9752	25717.5610	245800	80500	326300	159000	2003-11-19	1	1	1983	1	1472	3	2	33019C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	384.2647	414.5340	401.2372	1010	SINGLE FAM MDL-01	RR2	PERSON		1415	0460			CENTRAL AIR	GAS	NO COOLING	STAND SEAM	CLAPBOARD	2022