Saved query 62e577aab0d5a850

Data Explorer

Query the US Nationwide Parcel Dataset

$1.75 / 1,000 records$100 minimum

42/80

Live SQL

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

267,955 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	parceltype	accesstype	placename	placetype	lrversion
109 0 20	25	009	200 LOWELL ST	ANDOVER	MA	01810	WEST PARISH CHURCH	LOWELL RESERVATION	ANDOVER	MA	01810	ESSEX	01465	ANDOVER	254401	2544.0100	209627.3475	25009C	2026-01-21	X	AREA OF MINIMAL FLOOD HAZARD	-9999	39.9131	58.0687	47.0538	953	SRB	41.1200	NONPROFIT			GOVT UNKNOWN	RESTRICTED	WEST PARISH CENTER DISTRICT	HISTORIC_SITE	2026.2
81-1-25	25	009	25 ENGLISH COMMONS	TOPSFIELD	MA		LIPSON PHILIP D	101 STATION DR STE 250	WESTWOOD	MA	02050	ESSEX	70150	TOPSFIELD	214100	2141	268409.1586	25009C	2026-01-21	X	AREA OF MINIMAL FLOOD HAZARD	-9999	15.6531	59.2544	34.2844	102	EHD	0	PERSON	32960	0361			ENGLISH COMMONS	HISTORIC_SITE	2026.2
187 0 4 C	25	009	0 MINUTEMAN RD	ANDOVER	MA	01810	ARE-MA REGION NO 93 LLC	26 NORTH EUCLID AV	PASADENA	CA	91101	ESSEX	01465	ANDOVER	254402	2544.0200	19355.8594	25009C	2026-01-21	X	AREA OF MINIMAL FLOOD HAZARD	-9999	17.0953	27.0877	21.8901	440	ID2	4.8000	BUSINESS	17274	258					2026.2
3-144B3	25	009	3 SAWYER LN UNIT C	SALISBURY	MA	01952	BORAGINE RALPH	3 SAWYER LN UNIT C	SALISBURY	MA	01952	ESSEX	59245	SALISBURY	267104	2671.0400	61978.0171	25009C	2026-01-21	X	AREA OF MINIMAL FLOOD HAZARD	-9999	3.4301	9.0899	6.0718	102	R1	0	PERSON	27514	266					2026.2
220-10	25	009	6 EVELETH RD	GLOUCESTER	MA	01930	LONDON GREG S TIRZAH LEA	6 EVELETH RD	GLOUCESTER	MA	01930	ESSEX	26150	GLOUCESTER	221902	2219.0200	85641.0619	25009C	2026-01-21	X	AREA OF MINIMAL FLOOD HAZARD	-9999	-0.8400	27.9367	11.1321	1040	R-20	19.8800	PERSON	32837	61					2026.2
110-27	25	009	35 BARTLETTS REACH	AMESBURY	MA	01913	WILLWERTH FAMILY TRUST	35 BARTLETTS REACH	AMESBURY	MA	01913	ESSEX	01185	AMESBURY	266100	2661	369081.5297	25009C	2026-01-21	X	AREA OF MINIMAL FLOOD HAZARD	-9999	-1.1200	39.3275	9.3723	1021	OSC	0	TRUST	34321	82					2026.2
584-9I-91	25	009	8 COUNTRY SPRING LP	HAVERHILL	MA	01830	CARBONE MAX	8 COUNTRY SPRING LOOP	HAVERHILL	MA	01832	ESSEX	29405	HAVERHILL	260401	2604.0100	52363.2995	25009C	2026-01-21	X	AREA OF MINIMAL FLOOD HAZARD	-9999	28.3844	48.8993	35.6383	102		0	PERSON	37190	2			COMPUTER CURE SOLUTIONS	TECHNICAL_SERVICE	2026.2
588-422DF-62	25	009	62 DANFORTH CT	HAVERHILL	MA	01830	BEVILACQUA FRANCIS-ETUX	62 DANFORTH COURT	HAVERHILL	MA	01832	ESSEX	29405	HAVERHILL	260402	2604.0200	487306.9701	25009C	2026-01-21	X	AREA OF MINIMAL FLOOD HAZARD	-9999	29.8353	95.0231	62.6633	102		0	PERSON	37001	233			VJG	PROFESSIONAL_SERVICE	2026.2
770-6B-23	25	009	23 STERLING LN	HAVERHILL	MA	01830	ADAMS GIDEON F	23 STERLING LANE	BRADFORD	MA	01835	ESSEX	29405	HAVERHILL	261102	2611.0200	41004.7410	25009C	2026-01-21	X	AREA OF MINIMAL FLOOD HAZARD	-9999	22.4587	50.1063	35.2291	102		0	PERSON	35055	226					2026.2
634-BH-5-131	25	009	131 BRICKETT HILL CIR	HAVERHILL	MA	01830	CALLIHAN-HILL DONNA C	131 BRICKETT HILL CIRCLE	HAVERHILL	MA	01830	ESSEX	29405	HAVERHILL	260401	2604.0100	159376.7715	25009C	2026-01-21	X	AREA OF MINIMAL FLOOD HAZARD	-9999	25.8314	45.3028	39.2564	102		0	PERSON	34845	173			BRICKETT HILL CONDOS	LODGING	2026.2
770-6A-8	25	009	8 STERLING LN	HAVERHILL	MA	01830	DICESARE MICHAEL J	8 STERLING LN	BRADFORD	MA	01835	ESSEX	29405	HAVERHILL	261102	2611.0200	41004.7410	25009C	2026-01-21	X	AREA OF MINIMAL FLOOD HAZARD	-9999	22.4587	50.1063	35.2291	102		0	PERSON	22744	232					2026.2
588-422P-65	25	009	65 PERKINS CT	HAVERHILL	MA	01830	SHORT KATHLEEN M	65 PERKINS COURT	HAVERHILL	MA	01832	ESSEX	29405	HAVERHILL	260402	2604.0200	487306.9701	25009C	2026-01-21	X	AREA OF MINIMAL FLOOD HAZARD	-9999	29.8353	95.0231	62.6633	102		0	PERSON	29058	347			VJG	PROFESSIONAL_SERVICE	2026.2
588-422WP-18	25	009	18 W PARISH CT	HAVERHILL	MA	01830	MEGED REALTY TRUST	18 WEST PARISH COURT	HAVERHILL	MA	01832	ESSEX	29405	HAVERHILL	260402	2604.0200	487306.9701	25009C	2026-01-21	X	AREA OF MINIMAL FLOOD HAZARD	-9999	29.8353	95.0231	62.6633	102		0	TRUST	41339	562			VJG	PROFESSIONAL_SERVICE	2026.2
588-422P-34	25	009	34 PERKINS CT	HAVERHILL	MA	01830	M&S REALTY TRUST	1 CEDAR CREST LANE	BRADFORD	MA	01835	ESSEX	29405	HAVERHILL	260402	2604.0200	487306.9701	25009C	2026-01-21	X	AREA OF MINIMAL FLOOD HAZARD	-9999	29.8353	95.0231	62.6633	102		0	TRUST	30356	165			VJG	PROFESSIONAL_SERVICE	2026.2
634-BH-15-198	25	009	15 IRIS WAY	HAVERHILL	MA	01830	CLARK STEPHEN R ETUX	25 IRIS WAY	HAVERHILL	MA	01830	ESSEX	29405	HAVERHILL	260401	2604.0100	159376.7715	25009C	2026-01-21	X	AREA OF MINIMAL FLOOD HAZARD	-9999	25.8314	45.3028	39.2564	102		0	PERSON	22781	317			BRICKETT HILL CONDOS	LODGING	2026.2
588-422P-42	25	009	42 PERKINS CT	HAVERHILL	MA	01830	TAKER LAURETTA H	42 PERKINS CT UNIT 21D	HAVERHILL	MA	01832	ESSEX	29405	HAVERHILL	260402	2604.0200	487306.9701	25009C	2026-01-21	X	AREA OF MINIMAL FLOOD HAZARD	-9999	29.8353	95.0231	62.6633	102		0	PERSON	24334	333			VJG	PROFESSIONAL_SERVICE	2026.2
588-422WP-24	25	009	24 W PARISH CT	HAVERHILL	MA	01830	PEABODY CARLA E	24 WEST PARISH CT	HAVERHILL	MA	01832	ESSEX	29405	HAVERHILL	260402	2604.0200	487306.9701	25009C	2026-01-21	X	AREA OF MINIMAL FLOOD HAZARD	-9999	29.8353	95.0231	62.6633	102		0	PERSON	21833	312			VJG	PROFESSIONAL_SERVICE	2026.2
588-422WM-1	25	009	1 W MEADOW RD	HAVERHILL	MA	01830	AAD51 REVOCABLE TRUST	44 ELMWOOD AV	SALEM	NH	03079	ESSEX	29405	HAVERHILL	260402	2604.0200	487306.9701	25009C	2026-01-21	X	AREA OF MINIMAL FLOOD HAZARD	-9999	29.8353	95.0231	62.6633	102		0	TRUST	38964	567			VJG	PROFESSIONAL_SERVICE	2026.2
588-422CL-15	25	009	15 CLEMENT CT	HAVERHILL	MA	01830	JANUSZ AMY E	15 CLEMENT CT	HAVERHILL	MA	01832	ESSEX	29405	HAVERHILL	260402	2604.0200	487306.9701	25009C	2026-01-21	X	AREA OF MINIMAL FLOOD HAZARD	-9999	29.8353	95.0231	62.6633	102		0	PERSON	19175	482			VJG	PROFESSIONAL_SERVICE	2026.2
588-422WP-10	25	009	10 W PARISH CT	HAVERHILL	MA	01830	GLENDA L GILLERAN REV TRUST	10 WEST PARISH CT	HAVERHILL	MA	01832	ESSEX	29405	HAVERHILL	260402	2604.0200	487306.9701	25009C	2026-01-21	X	AREA OF MINIMAL FLOOD HAZARD	-9999	29.8353	95.0231	62.6633	102		0	TRUST	32249	441			VJG	PROFESSIONAL_SERVICE	2026.2
634-BH-25-94	25	009	25 TULIP CIR	HAVERHILL	MA	01830	MATTHEWS LINDA D	13 TULIP CR	HAVERHILL	MA	01830	ESSEX	29405	HAVERHILL	260401	2604.0100	159376.7715	25009C	2026-01-21	X	AREA OF MINIMAL FLOOD HAZARD	-9999	25.8314	45.3028	39.2564	102		0	PERSON	32893	500			BRICKETT HILL CONDOS	LODGING	2026.2
584-9I-70	25	009	32 COUNTRY MEADOW RD	HAVERHILL	MA	01830	DURKIN CONNOR	32 COUNTRY MEADOW RD	HAVERHILL	MA	01832	ESSEX	29405	HAVERHILL	260401	2604.0100	52363.2995	25009C	2026-01-21	X	AREA OF MINIMAL FLOOD HAZARD	-9999	28.3844	48.8993	35.6383	102		0	PERSON	38236	331			COMPUTER CURE SOLUTIONS	TECHNICAL_SERVICE	2026.2
634-BH-6-151	25	009	6 IRIS WAY	HAVERHILL	MA	01830	FLAHERTY DOROTHY A	34 IRIS WAY	HAVERHILL	MA	01830	ESSEX	29405	HAVERHILL	260401	2604.0100	159376.7715	25009C	2026-01-21	X	AREA OF MINIMAL FLOOD HAZARD	-9999	25.8314	45.3028	39.2564	102		0	PERSON	36756	250			BRICKETT HILL CONDOS	LODGING	2026.2
584-9I-27	25	009	26 COUNTRY HILL LN	HAVERHILL	MA	01830	KLOPOTOSKI TERRI L	26 COUNTRY HILL LN	HAVERHILL	MA	01832	ESSEX	29405	HAVERHILL	260401	2604.0100	52363.2995	25009C	2026-01-21	X	AREA OF MINIMAL FLOOD HAZARD	-9999	28.3844	48.8993	35.6383	102		0	PERSON	16793	506			COMPUTER CURE SOLUTIONS	TECHNICAL_SERVICE	2026.2
634-BH-36-233	25	009	233 BRICKETT HILL CIR	HAVERHILL	MA	01830	GAVIN JOHN M-ETUX	233 BRICKETT HILL CIRCLE	HAVERHILL	MA	01830	ESSEX	29405	HAVERHILL	260401	2604.0100	159376.7715	25009C	2026-01-21	X	AREA OF MINIMAL FLOOD HAZARD	-9999	25.8314	45.3028	39.2564	102		0	PERSON	30459	430			BRICKETT HILL CONDOS	LODGING	2026.2