Saved query f1487904f881e627

Data Explorer

Query the US Nationwide Parcel Dataset

$1.75 / 1,000 records$100 minimum

46/80

Live SQL

SELECT * 
FROM "lr_parcel_us" 
WHERE statefp = '25' 
  AND countyfp = '015'

65,941 matching parcels

Data Preview

parcelid	statefp	countyfp	parceladdr	parcelcity	parcelstate	parcelzip	ownername	owneraddr	ownercity	ownerstate	ownerzip	countyname	cousubfp	cousubname	tractce	tractname	calcarea	firmid	firmdate	fldzone	zonesubty	staticbfe	elevmin	elevmax	elevavg	usecode	zoningcode	taxacres	ownertype	book	page	lrversion
14A_45_1	25	015	45 AMITY PL	AMHERST	MA	01002	BARSBY CHRISTINE M	45 AMITY PL	AMHERST	MA	01002	HAMPSHIRE	01370	AMHERST TOWN	820500	8205	44804.4682	250156	2026-01-21	X	AREA OF MINIMAL FLOOD HAZARD	-9999	51.8222	63.8786	56.4405	1020	RN20	0.1398	PERSON	11680	0333	2026.2
14A_58_1	25	015	58 AMITY PL	AMHERST	MA	01002	ROSENBERG LAUREN ELIZABETH TRUS…	P O BOX 3040	AMHERST	MA	01004 3040	HAMPSHIRE	01370	AMHERST TOWN	820500	8205	44804.4682	250156	2026-01-21	X	AREA OF MINIMAL FLOOD HAZARD	-9999	51.8222	63.8786	56.4405	1020	RN20	0.1398	PERSON	9471	0175	2026.2
14A_34_1	25	015	34 AMITY PL	AMHERST	MA	01002	LILLYDAHL SANDRA J LIFE ESTATE	34 AMITY PL	AMHERST	MA	01002	HAMPSHIRE	01370	AMHERST TOWN	820500	8205	44804.4682	250156	2026-01-21	X	AREA OF MINIMAL FLOOD HAZARD	-9999	51.8222	63.8786	56.4405	1020	RN20	0.1398	PERSON	12263	0282	2026.2
8_2_A	25	015	BAY RD	HADLEY	MA	01035	MARTULA DAVID T	277 BAY RD	HADLEY	MA	01035	HAMPSHIRE	27690	HADLEY	821400	8214	749.3795			—			65.0286	65.8121	65.4266	1320	AR	0.1700	PERSON	6086	0243	2026.2
5_E_10	25	015	18 ROCKY HILL RD	HADLEY	MA	01035	NORRIS SUSAN	18 ROCKY HILL RD	HADLEY	MA	01035	HAMPSHIRE	27690	HADLEY	821400	8214	2637.9544			—			40.6464	41.7293	41.1893	1010	AR	0.6887	PERSON	14833	0164	2026.2
6_B_4-_3	25	015	TAYLOR ST	GRANBY	MA	01033	MATTHESS CYNTHIA M	367 NORWICH AVE	COLCHESTER	CT	06415	HAMPSHIRE	26535	GRANBY	820900	8209	5563.3771			—			89.8011	95.9199	92.8856	7120	RS	1.3300	PERSON	10295	0032	2026.2
2_C_11-_2	25	015	86 WEST ST	GRANBY	MA	01033	GYALTSEN SHERAB	86 WEST ST	GRANBY	MA	01033	HAMPSHIRE	26535	GRANBY	820900	8209	4587.2889			—			80.0344	81.9366	80.8092	1010	RS	1.1283	PERSON	15254	0235	2026.2
210-43-0	25	015	42 PANTRY RD	HATFIELD	MA	01038	SHIELDS SANDRA D	42 PANTRY RD	W HATFIELD	MA	01088	HAMPSHIRE	29265	HATFIELD	821500	8215	3967.7908			—			42.2588	54.0014	46.2887	101	RR	0.9100	PERSON	1877	143	2026.2
5_D_A_5	25	015	142 EAST ST	GRANBY	MA	01033	ALDRICH WILLIAM M	142 EAST ST	GRANBY	MA	01033	HAMPSHIRE	26535	GRANBY	820900	8209	1436.5456			—			77.6037	80.5613	79.1119	1010	RS	0.3489	PERSON	7508	0150	2026.2
3_D_B_18	25	015	16 KAREN DR	GRANBY	MA	01033	FISH LINDA A	16 KAREN DR	GRANBY	MA	01033	HAMPSHIRE	26535	GRANBY	820900	8209	1976.9701			—			69.1766	71.7592	70.2985	1010	RS	0.4500	PERSON	2213	0206	2026.2
54-0-24	25	015	8 DUNHAM AVE	WARE	MA	01082	GUZIK TINA M	8 DUNHAM AV	WARE	MA	01082	HAMPSHIRE	72880	WARE	820102	8201.0200	929.6485			—			141.3510	142.1785	141.8791	101	SR	0.2300	PERSON	5725	173	2026.2
30-0-17	25	015	0 UPPER CHURCH ST	WARE	MA	01082	HARRIS FAMILY TRUST CLIFFORD G	193 UPPER CHURCH ST	WARE	MA	01082	HAMPSHIRE	72880	WARE	820101	8201.0100	1704.2819			—			165.1130	168.9711	166.4681	601	RR	0.4600	TRUST	15374	55	2026.2
57-0-31	25	015	54 S ST	WARE	MA	01082	ANDERSON LEANN M	54 SOUTH ST	WARE	MA	01082	HAMPSHIRE	72880	WARE	820102	8201.0200	914.6402			—			130.5377	132.8948	131.7456	101	SR	0.2200	PERSON	6486	347	2026.2
59-0-31	25	015	153 W MAIN ST	WARE	MA	01082	ORSZULAK JODY	153 WEST MAIN ST	WARE	MA	01082	HAMPSHIRE	72880	WARE	820101	8201.0100	1309.3560			—			143.0001	146.5660	144.8052	101	DTR	0.3400	PERSON	7014	27	2026.2
61-0-201	25	015	27 OTIS AVE	WARE	MA	01082	PARK OTIS LLC	PO BOX 140355	BOSTON	MA	02114	HAMPSHIRE	72880	WARE	820101	8201.0100	503.8051			—			135.6122	139.9622	137.6314	111	DTR	0.1400	BUSINESS	14975	57	2026.2
62-0-57	25	015	134 EAGLE ST	WARE	MA	01082	PODKOWKA JACK T	134 EAGLE ST	WARE	MA	01082	HAMPSHIRE	72880	WARE	820101	8201.0100	390.1315			—			137.9552	138.3769	138.1258	101	DTR	0.1100	PERSON	6918	244	2026.2
7_A_15	25	015	5 MEADOW ST	HADLEY	MA	01035	MASTERSON MELINA A	5 MEADOW ST	HADLEY	MA	01035	HAMPSHIRE	27690	HADLEY	821400	8214	843.2801			—			43.9111	44.5979	44.2295	1010	AR	0.2287	PERSON	14700	0236	2026.2
3_F_C_17	25	015	12 SMITH AVE	GRANBY	MA	01033	MUNGER JOHN D	12 SMITH AV	GRANBY	MA	01033	HAMPSHIRE	26535	GRANBY	820900	8209	1637.6798			—			85.5673	92.4224	88.1601	1010	RS	0.3972	PERSON	5039	0284	2026.2
24-0-1	25	015	133 CHURCH ST	WARE	MA	01082	O`REGAN KEVIN	133 CHURCH ST	WARE	MA	01082	HAMPSHIRE	72880	WARE	820101	8201.0100	2986.8081			—			180.2892	186.2224	182.7979	101	DTR	0.9500	PERSON	5924	188	2026.2
16-11-12	25	015	6 DESANTIS DR	WARE	MA	01082	CHEVALIER KEITH	6 DESANTIS DR	WARE	MA	01082	HAMPSHIRE	72880	WARE	820101	8201.0100	2468.1996			—			173.8430	184.8580	179.8082	101	RR	0.5800	PERSON	12389	210	2026.2
3_D_B_5	25	015	17 HIGH ST	GRANBY	MA	01033	PIQUETTE PAUL E	17 HIGH ST	GRANBY	MA	01033	HAMPSHIRE	26535	GRANBY	820900	8209	1839.9025			—			69.9664	72.3974	71.2089	1010	RS	0.4419	PERSON	5493	0196	2026.2
9-0-160	25	015	1 MEADOW HEIGHTS DR	WARE	MA	01082	JUSZCZYK MARY T LIFE ESTATE	1 MEADOW HEIGHTS DR	WARE	MA	01082	HAMPSHIRE	72880	WARE	820101	8201.0100	1398.6738			—			138.4324	139.8781	139.0296	101	SR	0.4400	PERSON	7232	18	2026.2
222-108-0	25	015	26 MAPLE ST	HATFIELD	MA	01038	MORIARTY BRIAN F	26 MAPLE ST	HATFIELD	MA	01038	HAMPSHIRE	29265	HATFIELD	821500	8215	996.1475			—			38.0349	38.8481	38.4962	101	TC	0.2700	PERSON	5831	259	2026.2
220-48-0	25	015	52 GORE AVE	HATFIELD	MA	01038	ODEA RICHARD	52 GORE AV	HATFIELD	MA	01038	HAMPSHIRE	29265	HATFIELD	821500	8215	3842.3094			—			40.4700	47.1439	45.3790	101	RR	0.9200	PERSON	1558	641	2026.2
5_F_14	25	015	8 EAST ST	HADLEY	MA	01035	FIL THOMAS S	38 NEWTON LN	HADLEY,	MA	01035	HAMPSHIRE	27690	HADLEY	821400	8214	2371.9854			—			40.1388	40.8758	40.3575	3930	AR	0.5608	PERSON	4606	0037	2026.2