Saved query 9d46044796c2b9e1

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

524,671 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	naicscode	legaldesc	book	page	parceltype	accesstype	placename	placetype	lrversion
99-92-U072	25	017	72 APACHE WAY	TEWKSBURY	MA	01876	MAFFEO JAMES B	72 APACHE WY	TEWKSBURY	MA	01876	MIDDLESEX	69415	TEWKSBURY	315401	3154.0100	189183.9394	25017C	2026-01-21	X	AREA OF MINIMAL FLOOD HAZARD	-9999	24.6158	42.8442	31.9065	1020	MFD	0.0023	PERSON	71394		31682	0001			INDIAN RIDGE FITNESS CENTER	GYM	2026.2
044 0040 0021	25	017	2 OSPREY LN	WESTFORD	MA	01886	CRAIG DANIEL P	2 OSPREY LN	WESTFORD	MA	01886	MIDDLESEX	76135	WESTFORD	318100	3181	559723.6573	25017C	2026-01-21	X	AREA OF MINIMAL FLOOD HAZARD	-9999	58.4099	93.9995	70.0851	102	RA	0	PERSON	721		33058	85			SUMMER VILLAGE	HOTEL	2026.2
5_6_1_178	25	017	350 WELLMAN AVE	CHELMSFORD	MA	01863	BISCHOFF NICHOLINA	350 WELLMAN AV	NO CHELMSFORD	MA	01863	MIDDLESEX	13135	CHELMSFORD	317302	3173.0200	249220.5265	25017C	2026-01-21	X	0.2 PCT ANNUAL CHANCE FLOOD HAZ…	-9999	27.6499	36.3405	31.4974	1021	RM	0	PERSON			22143	0021			DOUGLAS WORLD TRAVEL	TRAVEL_SERVICE	2026.2
252_1840_382	25	017	382 DOUGLAS RD	LOWELL	MA		COMMONWEALTH OF MASSACHUSETTS	382 DOUGLAS RD	LOWELL	MA	01852	MIDDLESEX	37000	LOWELL	312502	3125.0200	18161.6039	25017C	2026-01-21	X	AREA OF MINIMAL FLOOD HAZARD	-9999	33.8255	37.7112	36.4329	920C	SSF	4.4748	GOVERNMENT	713940	0000		0000	GOVT STATE	RESTRICTED	JANAS MEMORIAL SKATING RINK	SKATING_RINK	2026.2
59-11	25	017	115 MILL ST	BELMONT	MA	02478	MCLEAN HOSPITAL CORP	115 MILL ST	BELMONT	MA	02478	MIDDLESEX	05070	BELMONT	357700	3577	172873.2882	25017C	2026-01-21	X	AREA OF MINIMAL FLOOD HAZARD	-9999	46.5219	81.4422	67.7116	955	17	3300989	BUSINESS			14084	272			CHRIS PALMER, MD	OUTPATIENT_CARE_FACILITY	2026.2
93_G_6	25	017	7 CHESTER AVE	SOMERVILLE	MA		CARNEIRO MANOEL P	7 CHESTER AVE	SOMERVILLE	MA	02143	MIDDLESEX	62535	SOMERVILLE	351404	3514.0400	339.5742	25017C	2026-01-21	X	AREA OF MINIMAL FLOOD HAZARD	-9999	12.2921	16.6728	13.4806	1040	NR	0.0847	PERSON	6216	45338 0564	45338	0564			NEW ENGLAND ESSENTIAL CLEANING …	HOME_SERVICE	2026.2
048-62-2788-000	25	017	301 BROOK ST	FRAMINGHAM	MA		TOWN OF FRAMINGHAM	301 BROOK ST	FRAMINGHAM	MA	01701	MIDDLESEX	24960	FRAMINGHAM	383903	3839.0300	49078.1413	25017C	2026-01-21	X	AREA OF MINIMAL FLOOD HAZARD	-9999	57.1055	76.2648	62.7694	934	R-3	12.6500	GOVERNMENT	61111	11615 0420	11615	0420			WALSH MIDDLE SCHOOL	MIDDLE_SCHOOL	2026.2
139_1915_460	25	017	460 DUTTON ST	LOWELL	MA		UNITED STATES OF AMERICA	67 KIRK ST	LOWELL	MA	01852	MIDDLESEX	37000	LOWELL	310101	3101.0100	1002.2414	25017C	2026-01-21	X	AREA OF MINIMAL FLOOD HAZARD	-9999	25.5524	29.6332	28.9897	9000	DMU	0.2500	GOVERNMENT		07136 0096	07136	0096	GOVT FEDERAL	RESTRICTED			2026.2
142_490_62	25	017	62 BELLEVUE ST	LOWELL	MA		TAING LY HUY	704 BRIDGE ST	LOWELL	MA	01850	MIDDLESEX	37000	LOWELL	311800	3118	523.6762	25017C	2026-01-21	X	AREA OF MINIMAL FLOOD HAZARD	-9999	46.2556	48.1285	47.6014	1050	TMF	0.1276	PERSON		35599 0005	35599	0005			APSARA JEWELRY	FASHION_AND_APPAREL_STORE	2026.2
179_1240_52	25	017	52 CHURCH ST	LOWELL	MA		KOKINOS CHARLES A	527 PAWTUCKET BLVD UNIT 507	LOWELL	MA	01854 2038	MIDDLESEX	37000	LOWELL	310101	3101.0100	259.2350	25017C	2026-01-21	X	AREA OF MINIMAL FLOOD HAZARD	-9999	26.5763	27.0124	26.8312	3400	DMU	0.0632	PERSON		00225 0009	00225	0009			TOWERS MOTOR PARTS CORP	VEHICLE_PARTS_STORE	2026.2
13 422 0	25	017	171 U 58 SWANTON ST	WINCHESTER	MA	01890	HOSHMAND LISA LAI-SANG TRUST	3781 HOBSTONE PLACE	DUBLIN	CA	94568	MIDDLESEX	80510	WINCHESTER	338200	3382	77450.9760	25017C	2026-01-21	AE	FLOODWAY	-9999	4.6000	20.4280	6.9010	102	RA	0	TRUST							SOLAR SOLUTIONS WINDOW TINTING	AUTOMOTIVE_SERVICE	2026.2
125_1565_81	25	017	81 CRESCENT ST	LOWELL	MA		SREY SARAH	81 CRESCENT ST	LOWELL	MA	01851	MIDDLESEX	37000	LOWELL	311600	3116	458.4251	25017C	2026-01-21	X	AREA OF MINIMAL FLOOD HAZARD	-9999	42.8745	45.0485	44.0717	1010	TSF	0.1220	PERSON		31077 0129	31077	0129					2026.2
97_2405_91	25	017	91 FOURTH AVE	LOWELL	MA		POULIN DENIS R	93 FOURTH AVE	LOWELL	MA	01854	MIDDLESEX	37000	LOWELL	310500	3105	770.3813	25017C	2026-01-21	X	AREA OF MINIMAL FLOOD HAZARD	-9999	32.9983	33.7170	33.4208	1040	TTF	0.1894	PERSON		21613 0067	21613	0067					2026.2
139-23-0607-000	25	017	4 FAIRVIEW RD	FRAMINGHAM	MA		MORI RICHARD C MARY ELLEN	4 FAIRVIEW ROAD	FRAMINGHAM	MA	01702	MIDDLESEX	24960	FRAMINGHAM	383200	3832	1664.2669	25017C	2026-01-21	X	AREA OF MINIMAL FLOOD HAZARD	-9999	76.5278	77.6513	76.9357	101	G	0.4068	PERSON		11187 0363	11187	0363					2026.2
34_4770_796	25	017	796 PRINCETON BLVD	LOWELL	MA		KHIN SOK	796 PRINCETON BLVD	LOWELL	MA	01851 4529	MIDDLESEX	37000	LOWELL	311400	3114	778.5094	25017C	2026-01-21	X	AREA OF MINIMAL FLOOD HAZARD	-9999	31.7274	32.6317	32.2236	1010	SSF	0.1840	PERSON		07354 0146	07354	0146					2026.2
89_4655_306	25	017	306 PINE ST	LOWELL	MA		HAM CHANNY	306 PINE ST	LOWELL	MA	01851	MIDDLESEX	37000	LOWELL	311500	3115	874.7660	25017C	2026-01-21	X	AREA OF MINIMAL FLOOD HAZARD	-9999	56.7144	58.1122	57.4265	1010	TSF	0.2169	PERSON		22139 0013	22139	0013					2026.2
154_1595_198	25	017	198 CUMBERLAND RD	LOWELL	MA		COMMUNITY TEAMWORK INC	155 MERRIMACK ST	LOWELL	MA	01852	MIDDLESEX	37000	LOWELL	310300	3103	296.8613	25017C	2026-01-21	X	AREA OF MINIMAL FLOOD HAZARD	-9999	25.7648	26.5122	26.1989	9591	TTF	0.0716	BUSINESS		37666 0139	37666	0139					2026.2
234_6235_192	25	017	192 WENTWORTH AVE	LOWELL	MA		LICNIKAS PETER M III	192 WENTWORTH AVE	LOWELL	MA	01852	MIDDLESEX	37000	LOWELL	312502	3125.0200	1152.1571	25017C	2026-01-21	X	AREA OF MINIMAL FLOOD HAZARD	-9999	56.7173	60.6172	58.2586	1010	SSF	0.2890	PERSON		22486 0111	22486	0111					2026.2
218_160_245	25	017	245 ANDOVER ST	LOWELL	MA		KNUDSON BRYCE E	245 ANDOVER ST	LOWELL	MA	01852 1438	MIDDLESEX	37000	LOWELL	312501	3125.0100	1746.2465	25017C	2026-01-21	X	AREA OF MINIMAL FLOOD HAZARD	-9999	48.4030	50.4624	49.7645	1010	SSF	0.4252	PERSON		33516 0267	33516	0267					2026.2
182_1570_174	25	017	174 CROSBY ST	LOWELL	MA		CHERRY TREE REAL ESTATE LLC	30 CATLIN RD	BROOKLINE	MA	02446	MIDDLESEX	37000	LOWELL	312000	3120	600.7738	25017C	2026-01-21	X	AREA OF MINIMAL FLOOD HAZARD	-9999	26.0035	26.6695	26.3075	1110	TMF	0.1358	BUSINESS		35299 0204	35299	0204					2026.2
41_5745_92	25	017	92 TOWER DR	LOWELL	MA		RATTY PAUL E	92 TOWER DR	LOWELL	MA	01854	MIDDLESEX	37000	LOWELL	310601	3106.0100	3315.3651	25017C	2026-01-21	X	AREA OF MINIMAL FLOOD HAZARD	-9999	30.8964	36.9352	32.8826	1010	SSF	0.8191	PERSON		07895 0157	07895	0157					2026.2
239_1425_50	25	017	50 COMMERCIAL ST	LOWELL	MA		CITY OF LOWELL	375 MERRIMACK ST	LOWELL	MA	01852	MIDDLESEX	37000	LOWELL	312300	3123	1776.1964	25017C	2026-01-21	X	AREA OF MINIMAL FLOOD HAZARD	-9999	40.7457	45.3209	42.5114	9300	TSF	0.4435	GOVERNMENT		01034 0001	01034	0001					2026.2
118_1575_163_1	25	017	163.1 CROSS ST	LOWELL	MA		MCGRATH ROBERT	8 TRUELL RD	AMHERST	NH	03031	MIDDLESEX	37000	LOWELL	311100	3111	316.3095	25017C	2026-01-21	X	AREA OF MINIMAL FLOOD HAZARD	-9999	34.4053	36.7415	35.5828	1040	TTF	0.0790	PERSON		00189 0135	00189	0135					2026.2
192_6390_91	25	017	91 WILLARD ST	LOWELL	MA		BLANCO JOSEPH M	91 WILLARD ST	LOWELL	MA	01850	MIDDLESEX	37000	LOWELL	310200	3102	812.3347	25017C	2026-01-21	X	AREA OF MINIMAL FLOOD HAZARD	-9999	36.0235	39.5518	37.9550	1010	TSF	0.2039	PERSON		00228 0048	00228	0048					2026.2
176_3455_239	25	017	239 LAKEVIEW AVE	LOWELL	MA		YIANOPOULOS PETER C	6 KETTLE WAY	DRACUT	MA	01826	MIDDLESEX	37000	LOWELL	310400	3104	284.4996	25017C	2026-01-21	X	0.2 PCT ANNUAL CHANCE FLOOD HAZ…	-9999	21.1721	21.6394	21.4197	1050	TMF	0.0641	PERSON		13197 0031	13197	0031					2026.2