Saved query 16c412d9f99bbf70

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

227,319 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	book	page	parceltype	accesstype	iucnclass	placename	placetype	fireplaces	heating	heatfuel	cooling	foundation	roofcover	siding	taxyear
0020 0000 00910		25	009	23 HILLTOP CIRCLE	WEST NEWBURY	MA	01985	COOK NORMAN E BEVERLY A T E LEO…	23 HILLTOP CIR	WEST NEWBURY	MA	01985-1813	Essex	77150	West Newbury	263100	2631	4019.9925	464200	429600	893800	470000	2016-11-29	1	1	1979	2	2718	10	2	3	25009C	2026-01-21	X	AREA OF MINIMAL FLOOD HAZARD	46.4118	53.2944	49.8143	1040	TWO FAMILY	RA	PERSON		35482	559						1	HOT WATER	UNDETERMINED	OTHER	POURED CONCRETE	ASPHALT SH		2026
95-21	96	25	009	59 MIDDLE ROAD	AMESBURY TOWN	MA	01913	KARVIELIS MICHAEL G DEBRA A KAR…	59 MIDDLE RD	AMESBURY	MA	01913	Essex	01185	Amesbury	266100	2661	2049.4732	216200	249400	465600	258000	2007-08-01	1	1	1940		1335				25009C	2026-01-21	X	AREA OF MINIMAL FLOOD HAZARD	30.0643	34.1290	32.2110	1010	Single Family	R40	PERSON	6216	27073	0063				KARVIELIS ELECTRIC	HOME_SERVICE		UNDETERMINED	OIL	UNDETERMINED		ASPH/F GLS/CMP	VINYL SIDING	2026
194-0-35	0194 0000 0035 A	25	009	59 TENNEY STREET	LAWRENCE	MA	01841	RODRIGUEZ EMIL	59 TENNEY ST	LAWRENCE	MA	01841	Essex	34550	Lawrence	250400	2504	415.8525	481000	104700	585700	392000	2020-10-23	1	1	1915		2049				25009C	2026-01-21	X	AREA OF MINIMAL FLOOD HAZARD	19.0857	19.8320	19.4779	104M	Two Family	R3	PERSON		16561	0211							UNDETERMINED	GAS	UNDETERMINED		ASPH/F GLS/CMP	VINYL SIDING	2026
81-0-96	0081 0000 0096 A	25	009	214 FARNHAM STREET	LAWRENCE	MA	01843	CARMEN D NUNEZ DEALVAREZ T E GE…	214 FARNHAM STREET	LAWRENCE	MA	01843	Essex	34550	Lawrence	251600	2516	734.7952	734800	156500	891300	100	2022-01-31	2	1	1910		1955				25009C	2026-01-21	X	AREA OF MINIMAL FLOOD HAZARD	17.5858	18.7694	18.3478	109M	Multi Hses MDL-03	R3	PERSON		17329	0164							UNDETERMINED	GAS	UNDETERMINED		ASPH/F GLS/CMP	VINYL SIDING	2026
160-0-76	0160 0000 0076 A	25	009	120 EVERETT STREET	LAWRENCE	MA	01843	RHONA KYEYUNE	118-120 EVERETT STREET	LAWRENCE	MA	01843	Essex	34550	Lawrence	251500	2515	555.2507	441500	186600	628100	785000	2026-04-29	1	1	1970		2074				25009C	2026-01-21	X	AREA OF MINIMAL FLOOD HAZARD	17.5597	19.0514	17.9681	104M	Two Family	R2	PERSON		18566	0194							UNDETERMINED	ELECTRIC	UNDETERMINED		ASPH/F GLS/CMP	VINYL SIDING	2026
101-0-71	0101 0000 0071 A	25	009	39 ABBOTT STREET	LAWRENCE	MA	01843	CHERLEE ST ROSE YONNES ST ROSE	39 ABBOTT STREET	LAWRENCE	MA	01843	Essex	34550	Lawrence	251600	2516	790.1107	409000	161200	570200	515000	2021-11-15	1	1	1900		2563				25009C	2026-01-21	X	AREA OF MINIMAL FLOOD HAZARD	16.6448	18.0208	17.8061	1010	Single Family	R2	PERSON		17229	0091							UNDETERMINED	OIL	UNDETERMINED		ASPH/F GLS/CMP	VINYL SIDING	2026
160-0-25	0160 0000 0025 A	25	009	83 EVERETT STREET	LAWRENCE	MA	01843	SANTANA RAFAEL A	83 EVERETT ST	LAWRENCE	MA	01841	Essex	34550	Lawrence	251500	2515	930.8903	398500	226200	624700	233000	2009-09-11	1	1	1964		1740				25009C	2026-01-21	X	AREA OF MINIMAL FLOOD HAZARD	19.5538	24.3684	21.6803	1010	Single Family	R1	PERSON		11763	0261							UNDETERMINED	GAS	UNDETERMINED		ASPH/F GLS/CMP	VINYL SIDING	2026
53-0-56	0053 0000 0056 A	25	009	25 LEROY AVENUE	LAWRENCE	MA	01841	DEJESUS YUDELKIS T E INCELIS DE…	25 LEROY AVE	LAWRENCE	MA	01841	Essex	34550	Lawrence	250800	2508	723.6925	345200	206200	551400	250000	2014-04-30	1	1	1954		1656				25009C	2026-01-21	X	AREA OF MINIMAL FLOOD HAZARD	19.4786	21.5160	21.0375	1010	Single Family	R2	PERSON		13839	0180							UNDETERMINED	OIL	UNDETERMINED		ASPH/F GLS/CMP	ASBEST SHINGLE	2026
23-2		25	009	156 WETHERSFIELD STREET	ROWLEY	MA	01969	ESTELLA SEAN ESTELLA JANET	156 WETHERSFIELD ST	ROWLEY	MA	01969	Essex	58405	Rowley	270100	2701	2939.7934	233100	283800	516900	291500	2007-01-12	1	1	1965		912				25009C	2026-01-21	X	AREA OF MINIMAL FLOOD HAZARD	19.2028	21.0399	20.3451	1010	Single Fam MDL-01	OUT	PERSON		26477	0079							UNDETERMINED	OIL	UNDETERMINED		ASPH/F GLS/CMP	ALUMINUM SIDNG	2026
30-81		25	009	15 MARLBORO STREET	NEWBURYPORT	MA	01950	MOORE KIM B TRS JUNE R MOORE TRS	15 MARLBORO ST	NEWBURYPORT	MA	01950	Essex	45245	Newburyport	268400	2684	378.2901	638000	457000	1095000	532500	2010-11-30	1	1	1850		2058				25009C	2026-01-21	X	AREA OF MINIMAL FLOOD HAZARD	5.8800	6.8647	6.5658	1010	SINGLE FAM		TRUST		30016	0485							UNDETERMINED	OIL	UNDETERMINED		ASPH/F GLS/CMP	VINYL SIDING	2026
190-0-83-1	0190 0000 0083 1A	25	009	22 FLORENCE STREET	LAWRENCE	MA	01841	DIAZ HEIDY YOCASTA	22 - 24 FLORENCE ST	LAWRENCE	MA	01841	Essex	34550	Lawrence	250300	2503	135.6495	446300	75200	521500	179900	2015-03-31	1	1	1910		1930				25009C	2026-01-21	AE		16.1154	16.7489	16.3216	104M	Two Family	I2	PERSON		14177	0291							UNDETERMINED	GAS	UNDETERMINED		ASPH/F GLS/CMP	VINYL SIDING	2026
101-3		25	009	3 STOREYBROOKE DRIVE	NEWBURYPORT	MA	01950	APPLETON CYNTHIA R	3 STOREYBROOKE ROAD	NEWBURYPORT	MA	01950	Essex	45245	Newburyport	268100	2681	909.1576	287500	510700	798200		1978-07-27	1	1	1961		1050				25009C	2026-01-21	X	AREA OF MINIMAL FLOOD HAZARD	20.8537	22.6142	21.2801	1010	SINGLE FAM		PERSON		06498	0053							UNDETERMINED	GAS	UNDETERMINED		ASPH/F GLS/CMP	WOOD SHINGLE	2026
8 83		25	009	96 MIDDLE STREET	GLOUCESTER	MA	01930						Essex	26150	Gloucester	221500	2215	398.5703	605700	253400	859100			1	1	1900		4748				25009C	2026-01-21	X	AREA OF MINIMAL FLOOD HAZARD	14.4100	15.9862	15.2311	0342	PROF OFFICE	CCD	UNDETERMINED	54192						CALLISTO & CO. PHOTOGRAPHY	PROFESSIONAL_SERVICE				NO COOLING		ASPH/F GLS/CMP	ALUMINUM SIDNG	2026
67 40		25	009	16 BEACH ROAD	GLOUCESTER	MA	01930						Essex	26150	Gloucester	221300	2213	419.0213	771300	527200	1298500			1	1	1895		2237				25009C	2026-01-21	X	AREA OF MINIMAL FLOOD HAZARD	15.5986	16.9290	16.1129	1010	SING FAM	R-20	UNDETERMINED										UNDETERMINED	OIL	UNDETERMINED		ASPH/F GLS/CMP	SHINGLE	2026
199 35		25	009	22 LAWNDALE CIRCLE	GLOUCESTER	MA	01930						Essex	26150	Gloucester	221901	2219.0100	4336.1550	497400	247600	745000			1	1	2010		1512				25009C	2026-01-21	X	AREA OF MINIMAL FLOOD HAZARD	21.6901	29.1230	24.9486	1010	SING FAM	R-30	UNDETERMINED										UNDETERMINED	ELECTRIC	UNDETERMINED		ASPH/F GLS/CMP	VINYL SIDING	2026
169 56		25	009	205 HESPERUS AVENUE	GLOUCESTER	MA	01930						Essex	26150	Gloucester	221901	2219.0100	1024.8222	657400	1091300	1748700			1	1	1986		1981				25009C	2026-01-21	X	AREA OF MINIMAL FLOOD HAZARD	5.7999	8.9263	7.9881	1010	SING FAM	R-20	UNDETERMINED										UNDETERMINED	OIL	UNDETERMINED		ASPH/F GLS/CMP	SHINGLE	2026
99 53		25	009	8 SHORE HILL ROAD	GLOUCESTER	MA	01930						Essex	26150	Gloucester	221800	2218	878.5986	256900	268700	525600			1	1	1900		984				25009C	2026-01-21	X	AREA OF MINIMAL FLOOD HAZARD	13.1001	15.3538	14.4274	1010	SING FAM	R-10	UNDETERMINED										UNDETERMINED	GAS	UNDETERMINED		ASPH/F GLS/CMP	VERTICAL WOOD	2026
201 19		25	009	371 WESTERN AVENUE	GLOUCESTER	MA	01930						Essex	26150	Gloucester	221901	2219.0100	2280.1019	528400	238200	766600			1	1	1920		2368				25009C	2026-01-21	X	AREA OF MINIMAL FLOOD HAZARD	17.5199	35.7333	24.7904	1010	SING FAM	R-30	UNDETERMINED										UNDETERMINED	OIL	UNDETERMINED		ASPH/F GLS/CMP	VINYL SIDING	2026
96 54		25	009	8 APPLE STREET	GLOUCESTER	MA	01930						Essex	26150	Gloucester	221800	2218	533.8187	296200	225500	521700			1	1	1967		912				25009C	2026-01-21	X	AREA OF MINIMAL FLOOD HAZARD	10.4500	11.7978	11.2567	1010	SING FAM	R-10	UNDETERMINED										UNDETERMINED	OIL	UNDETERMINED		ASPH/F GLS/CMP	SHINGLE	2026
5 24		25	009	56 GRANITE STREET	GLOUCESTER	MA	01930						Essex	26150	Gloucester	221700	2217	205.3010	405500	129100	534600			1	1	1900		2055				25009C	2026-01-21	X	AREA OF MINIMAL FLOOD HAZARD	3.1400	8.8347	5.2529	1040	TWO FAMILY MDL-01	R-5	UNDETERMINED										UNDETERMINED	OIL	UNDETERMINED		ASPH/F GLS/CMP	VINYL SIDING	2026
170 44		25	009	4 DUBLIN LANE	GLOUCESTER	MA	01930						Essex	26150	Gloucester	221901	2219.0100	967.5279	265200		265200			1	1	1900		575				25009C	2026-01-21	X	AREA OF MINIMAL FLOOD HAZARD	8.6601	10.8687	10.0040	1020	CONDO MDL-05	R-20	UNDETERMINED														ASPH/F GLS/CMP		2026
033 048		25	009	70 FOREST STREET	DANVERS	MA	01923						Essex	16250	Danvers	211402	2114.0200	148408.7066						1								25009C	2026-01-21	X	AREA OF MINIMAL FLOOD HAZARD	21.7499	50.8875	38.6397					4922			GOVT UNKNOWN	RESTRICTED	OTHER	ENDICOTT PARK	LOCAL PARK
65-13		25	009	29 MORNINGSIDE DRIVE	TOPSFIELD	MA	01983						Essex	70150	Topsfield	214100	2141	24264.9621						1								25009C	2026-01-21	AE	FLOODWAY	9.9927	20.3240	11.0760					8141			GOVT UNKNOWN	RESTRICTED	V	MORNINGSIDE RIVER CONSERVATION …	PRIVATE CONSERVATION
27-0277		25	009	126 NORTH STREET	SALEM	MA	01970						Essex	59105	Salem	204600	2046	2390.5579						1								25009C	2026-01-21	X	AREA OF MINIMAL FLOOD HAZARD	7.5600	9.2698	8.5688					445131						SALEM FOOD STORE	CONVENIENCE_STORE
25 13		25	009	38R RAILROAD AVENUE	GLOUCESTER	MA	01930						Essex	26150	Gloucester	221500	2215	365.6526						2								25009C	2026-01-21	X	AREA OF MINIMAL FLOOD HAZARD	15.4400	16.5072	16.0302					45931						AUDREY'S FLOWER SHOP	FLOWERS_AND_GIFTS_STORE