Saved query bc6093a686a2d112

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 = '25' 
  AND countyfp = '015'

61,736 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	totalvalue	saleamt	saledate	numbldgs	numunits	yearbuilt	numfloors	bldgsqft	bedrooms	halfbaths	fullbaths	firmid	firmdate	fldzone	zonesubty	elevmin	elevmax	elevavg	usecode	usedesc	zoningcode	ownertype	naicscode	legaldesc	book	page	parceltype	accesstype	iucnclass	placename	placetype	heating	heatfuel	cooling	foundation	roofcover	siding	taxyear
030 0 0001 0000 0	3310300000100000	25	015	367 MAIN ROAD	WESTHAMPTON	MA	01027	STACEY MICHAEL LINDA	367 MAIN RD	WESTHAMPTON	MA	01027	Hampshire	76380	Westhampton	822603	8226.0300	11539.2578	125300	91100	216400	48000	1978-07-26	1	1	1970	2	1800	3	0	2			—		297.7525	342.2726	313.9770	1010	Single Family	R1	PERSON			2040	0255						UNDETERMINED	UNDETERMINED	NO COOLING	CONCRETE	ASPH/F GLS/CMP	CLAPBOARD	2026
25 40		25	015	12 EASTWOOD DRIVE	SOUTHAMPTON	MA	01073	GHAREEB EDWARD G GHAREEB MARGAR…	12 EASTWOOD DR	SOUTHAMPTON	MA	01073	Hampshire	62745	Southampton	822500	8225	5938.3418	480500	133000	613500	61000	1989-09-10	1	1	1990		3084						—		82.0667	85.2489	83.1957	1010	Single Family	RR	PERSON			0000	0000						UNDETERMINED	OIL	UNDETERMINED		ASPH/F GLS/CMP	CLAPBOARD	2026
13 12		25	015	9 SUSAN DRIVE	SOUTHAMPTON	MA	01073	SELGRADE BRIAN P SELGRADE ELIZA…	9 SUSAN DR	SOUTHAMPTON	MA	01073	Hampshire	62745	Southampton	822500	8225	2530.8902	371200	116500	487700	352900	2019-08-12	1	1	1988		2680						—		61.1103	63.0789	61.9912	1010	Single Family	RN	PERSON			13353	276						UNDETERMINED	OIL	UNDETERMINED		ASPH/F GLS/CMP	VINYL SIDING	2026
28 132		25	015	21 KATELYN WAY	SOUTHAMPTON	MA	01073	PRAIRIE GUY P PRAIRIE BARBARA J	21 KATELYN WAY	SOUTHAMPTON	MA	01073	Hampshire	62745	Southampton	822500	8225	3782.6349	711500	143200	854700	526700	2010-02-19	1	1	2010		3603						—		84.1148	85.6999	85.0039	1010	Single Family	RN	PERSON			10104	0124						UNDETERMINED	GAS	UNDETERMINED		ASPH/F GLS/CMP	VINYL SIDING	2026
44 130		25	015	7 FREYER ROAD		MA	01073	AMY VIRGILIO	7 FREYER RD	SOUTHAMPTON	MA	01073	Hampshire	62745	Southampton	822500	8225	931.3681	101600	74700	176300	350000	2025-08-22	1	1	1950		1008						—		82.2938	83.1523	82.6747	1010	Single Family	RV	PERSON			15509	318						UNDETERMINED	OIL	UNDETERMINED		ASPH/F GLS/CMP	VINYL SIDING	2026
11C-117		25	015	374 NORTH PLEASANT STREET	AMHERST	MA	01002						Hampshire	01370	Amherst Town	820500	8205	1437.6301						1								250156	2026-01-21	X	AREA OF MINIMAL FLOOD HAZARD	80.9685	83.5467	82.1766					61131							UMASS PIKE	COLLEGE_UNIVERSITY
506 29 0		25	015	JOY HILL	HUNTINGTON	MA	01050						Hampshire	31785	Huntington	822601	8226.0100	326678.5265																—		282.2104	331.4342	302.5534					3211				NGO	RESTRICTED	OTHER	JOY HILL CR	CONSERVATION EASEMENT
26B-3		25	015	1530 SOUTH EAST STREET	AMHERST	MA	01002						Hampshire	01370	Amherst Town	820801	8208.0100	2787.9602														250156	2026-01-21	X	AREA OF MINIMAL FLOOD HAZARD	72.6181	77.5966	75.2518						ANR2001-00008
23A-114-001		25	015	6 MAIN STREET	FLORENCE	MA	01062						Hampshire	46330	Northampton	821602	8216.0200	1347.3259						1										—		82.5499	83.3499	82.8388					522130	s2021-011						NORTHAMPTON COOPERATIVE BANK	BANK_OR_CREDIT_UNION
20A-160		25	015	13 NORWOTTOCK CIRCLE	AMHERST	MA	01002						Hampshire	01370	Amherst Town	820801	8208.0100	2148.7007						1								250156	2026-01-21	X	AREA OF MINIMAL FLOOD HAZARD	49.8395	54.4307	52.4379
15B-29		25	015	24 THAYER STREET	AMHERST	MA	01002						Hampshire	01370	Amherst Town	820700	8207	696.9968						1								250156	2026-01-21	X	AREA OF MINIMAL FLOOD HAZARD	61.0237	62.2429	61.6121
14B-58		25	015	12 DICKINSON STREET	AMHERST	MA	01002						Hampshire	01370	Amherst Town	820500	8205	490.1677						1								250156	2026-01-21	X	AREA OF MINIMAL FLOOD HAZARD	83.6753	85.1977	84.4300
14C-30		25	015	78 WOODSIDE AVENUE	AMHERST	MA	01002						Hampshire	01370	Amherst Town	820500	8205	2020.7282						1								250156	2026-01-21	X	AREA OF MINIMAL FLOOD HAZARD	80.6294	82.3859	81.4193
11D-114		25	015	105 GRAY STREET	AMHERST	MA	01002						Hampshire	01370	Amherst Town	820500	8205	3119.2194						1								250156	2026-01-21	X	AREA OF MINIMAL FLOOD HAZARD	91.1225	94.1290	92.6110
30B-62		25	015	41 ELF HILL ROAD	AMHERST	MA	01002						Hampshire	01370	Amherst Town	820801	8208.0100	3289.6844						1								250156	2026-01-21	X	AREA OF MINIMAL FLOOD HAZARD	67.6736	74.1192	70.6361
26D-52		25	015	97 MECHANIC STREET	AMHERST	MA	01002						Hampshire	01370	Amherst Town	820801	8208.0100	2121.3436						1								250156	2026-01-21	X	AREA OF MINIMAL FLOOD HAZARD	73.4931	77.7405	76.7912
11B-149		25	015	219 STRONG STREET	AMHERST	MA	01002						Hampshire	01370	Amherst Town	820500	8205	1707.7163						1								250156	2026-01-21	X	AREA OF MINIMAL FLOOD HAZARD	100.7934	103.0791	101.7496
22 1		25	015	22 COVE ISLAND ROAD	SOUTH HADLEY	MA	01075						Hampshire	64145	South Hadley	821300	8213	191020.2602						15										—		31.0186	36.2877	32.0526					721110							COVE ISLAND RIVER HOUSE	HOTEL
31D-008-001		25	015	ROCK GARDEN	NORTHAMPTON	MA	01060						Hampshire	46330	Northampton	822000	8220	15023.0812						1										—		41.4500	59.3800	53.7618					23622							WRIGHT HALL, SMITH COLLEGE	CAMPUS_BUILDING
20B-73		25	015	6 EVENINGSTAR DRIVE	AMHERST	MA	01002						Hampshire	01370	Amherst Town	820801	8208.0100	11335.4869														250156	2026-01-21	X	AREA OF MINIMAL FLOOD HAZARD	60.9684	76.0276	68.5407
23 78		25	015	CONANT PARK		MA	01073						Hampshire	62745	Southampton	822500	8225	72252.5564																—		55.1458	69.6792	63.2663					712190				GOVT UNKNOWN	RESTRICTED		CONANT PARK	PARK
47 33		25	015	5 FERRY STREET		MA	01075						Hampshire	64145	South Hadley	821300	8213	7365.6218						1										—		68.1340	72.6322	71.0828					8131							STONY BROOK COMMUNITY CHURCH	CHRISTIAN_PLACE_OF_WORSHIP
340 008 H-0000-0020 0		25	015	29 MOUNTAIN STREET	HAYDENVILLE	MA	01039						Hampshire	79915	Williamsburg	822607	8226.0700	43405.9201						1										—		134.1757	152.2823	142.2431
52 77		25	015	144 MAIN STREET	WESTHAMPTON	MA	01027						Hampshire	19365	Easthampton	822402	8224.0200	792.6771						1										—		56.9808	58.0362	57.3566
23C-105-001		25	015	130 NONOTUCK STREET	FLORENCE	MA	01062						Hampshire	46330	Northampton	821602	8216.0200	2015.4700						1										—		67.8100	70.3700	68.6833