Saved query 7e4d175d5c47f1bf

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 = '36' 
  AND countyfp = '003'

34,679 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	agvalue	totalvalue	saledate	numbldgs	numunits	numfloors	fldzone	elevmin	elevmax	elevavg	taxacres	ownertype	naicscode	book	page	placename	placetype	taxdistrict
16400700010130000000	00000000178	36	003	5043 MCANDREWS RD	ALFRED	NY	14802	Graziano Anthony A	5043 MCANDREWS RD	ALFRED	NY	14802	Allegany	01209	Alfred	950800	9508	598.4403	102505	104500	102505	1995	2023-06-20	1	1	1	—	531.4486	534.7655	533.7110	0.1478	PERSON	4242	2023	41210	ALFRED PHARMACY	PHARMACY_AND_DRUG_STORE	ALFRED
08600000010100010000	00000000330	36	003	8614 BROWN RD	ROCHESTER	NY	14620	Fink-Gefell Margaret	8614 BROWN RD	ROCHESTER	NY	14620	Allegany	01451	Almond	950100	9501	71356.5403	131900	156900	131900	25000	2016-12-19	1			—	453.8544	485.1275	465.9837	17.6270	PERSON	5612	2016	87547	SIERRA EVANS RICHARD	TECHNICAL_SERVICE	ALMOND
15500000010090010000	00000000010	36	003	4764 EAST EDDY DR	LEWISTON	NY	14092	Break Away FC LLC	4764 EAST EDDY DR	LEWISTON	NY	14092	Allegany	27705	Friendship	950401	9504.0100	303508.3595	3800	85200	3800	81400	2013-05-24	1			—	610.6101	671.9979	645.8487	74.9907	BUSINESS	23833	2013	63438			FRIENDSHIP
12200000010090110000	00000000129	36	003	20416 E EUCLID DR	Centennial CO	NY	80016	KTK BRUNO LLC	20416 E EUCLID DR	Centennial CO	CO	80016	Allegany	79202	West Almond	950100	9501	244269.9431	34200	98000	34200	63800	2023-11-01	1			—	482.3150	570.5738	520.3249	60.3583	BUSINESS	3391	2023	45062			WEST ALMOND
13400000010060010000	00000000874	36	003	5641 STATE ROUTE 19	BELMONT	NY	14813	Collins Bryan	5641 STATE ROUTE 19	BELMONT	NY	14813	Allegany	02187	Angelica	951302	9513.0200	187064.3527		52400		52400	2022-06-23	0			—	457.3327	481.7095	473.1300	45.1000	PERSON	56191	2022	24414	COLLINS CREEKSIDE EVENT VENUE	EVENT_OR_PARTY_SERVICE	ANGELICA
18201100020340000000	00000000608	36	003	4092 STATE ROUTE 275	FRIENDSHIP	NY	14739	Golden Scott	4092 STATE ROUTE 275	FRIENDSHIP	NY	14739	Allegany	27705	Friendship	950600	9506	401.3332	44700	45900	44700	1200	2015-05-06	1			—	463.2239	464.6460	463.9803	0.0970	PERSON		2015	76750			FRIENDSHIP
02700000010190110000	00000000620	36	003	8243 VERMONT HILL RD	HOLLAND	NY	14009	Boone Richard R	8243 VERMONT HILL RD	HOLLAND	NY	14009	Allegany	36112	Hume	951302	9513.0200	216093.6012	6800	74300	6800	67500	2019-07-11	1			—	356.4022	420.6380	392.3467	53.3898	PERSON		2019	3003			HUME
23700000010140000000	00000002752	36	003	2760 PETROLIA RD	WELLSVILLE	NY	14895	Armstrong William C	2760 PETROLIA RD	WELLSVILLE	NY	14895	Allegany	79103	Wellsville	951100	9511	6042.0169	71000	75000	71000	4000	1996-08-07	1			—	501.8344	504.1746	503.1351	1.4930	PERSON		1115	55			WELLSVILLE
08200000010040000000	00000000376	36	003	4831 SOUTH DESERT DUSK RD	TAYLORSVILLE	NY	84118	Wilcox Jessica M	4831 SOUTH DESERT DUSK RD	TAYLORSVILLE	UT	84118	Allegany	01319	Allen	951302	9513.0200	318690.0800	19600	95300	19600	75700	2021-07-15	2			—				80.8000	PERSON	111	2021	15393	FIREFLY FARM - ANGELICA, NY	FARM	ALLEN
15500000010290030000	00000001442	36	003	766 FLETCHER ST	TONAWANDA	NY	14150	Bacon Thomas C	766 FLETCHER ST	TONAWANDA	NY	14150	Allegany	27705	Friendship	950401	9504.0100	83147.2271	46800	74600	46800	27800	2022-03-11	0			—	600.4290	639.4880	617.9442	20.5446	PERSON		2022	21191			FRIENDSHIP
14400000010110020000	00000001287	36	003	620 60TH ST	NIAGARA FALLS	NY	14304	DiLaura Patrick	620 60TH ST	NIAGARA FALLS	NY	14304	Allegany	05573	Belfast	951301	9513.0100	15011.4530	1000	11000	1000	10000	2007-03-28	0			—	583.3610	598.7680	592.7475	3.7090	PERSON		1619	92			BELFAST
23901400010350000000	00000001893	36	003	151 N FRANKLIN ST	WELLSVILLE	NY	14895	Cooper Aaron	151 N FRANKLIN ST	WELLSVILLE	NY	14895	Allegany	79103	Wellsville	950900	9509	849.4211	7000	15000	7000	8000	2016-10-24	1			—	455.7119	456.5541	456.2215	0.2098	PERSON		2016	86523			WELLSVILLE
21601500010510000000	00000000342	36	003	6 ELM ST	ANDOVER	NY	14806	Grant Seth Shelly W	6 ELM ST	ANDOVER	NY	14806	Allegany	02154	Andover	950900	9509	620.1930	60000	61300	60000	1300	2006-07-14	1			—	505.2593	505.7973	505.4759	0.1532	PERSON		1541	38			ANDOVER
23900000020580030000	00000003186	36	003	2800 HILLCREST DR	WELLSVILLE	NY	14895	Hills Alan J	2800 HILLCREST DR	WELLSVILLE	NY	14895	Allegany	79103	Wellsville	950900	9509	2183.7881	15000	24000	15000	9000	2023-06-06	1			—	477.2538	481.8439	478.6361	0.5390	PERSON		2023	40798			WELLSVILLE
23901000030050020000	00000001720	36	003	52 1 2 E DYKE ST	WELLSVILLE	NY	14895	Polselli Benjamin	52 1 2 E DYKE ST	WELLSVILLE	NY	14895	Allegany	79103	Wellsville	950700	9507	1248.3321	32000	43000	32000	11000	2013-11-25	2			—	455.3534	456.1111	455.7849	0.2316	PERSON		2013	66717			WELLSVILLE
17200000010530030000	00000000842	36	003	5051 NYS ROUTE 244	BELMONT	NY	14813	Burnell Curtis I	5051 NYS ROUTE 244	BELMONT	NY	14813	Allegany	02011	Amity	950600	9506	2032.5916	31900	36400	31900	4500	2008-05-14	2			—	435.7611	440.2775	437.7204	0.5022	PERSON		1739	1			AMITY
21200600010100000000	00000000581	36	003	3898 MAIN ST	SCIO	NY	14880	Perry Daniel	3898 MAIN ST	SCIO	NY	14880	Allegany	65772	Scio	950700	9507	2413.7126	23500	33800	23500	10300	2013-11-25	2			—	443.8118	444.9869	444.3207	0.5963	PERSON		2013	66712			SCIO
07801300010240000000	00000000995	36	003	3285 RANDALL RD	RANSOMVILLE	NY	14131	Schultz James J	3285 RANDALL RD	RANSOMVILLE	NY	14131	Allegany	12243	Caneadea	950402	9504.0200	11086.3741	58300	65600	58300	7300	2016-09-14	0			—	418.2650	437.8129	428.2058	2.7393	PERSON		2016	85878			CANEADEA
15900000010300040000	00000001478	36	003	77 HUMPHREY ST	MARBLEHEAD	NY	01945	Gilliland Jason	77 HUMPHREY ST	MARBLEHEAD	MA	01945	Allegany	02011	Amity	950600	9506	3331.8435	33300	40600	33300	7300	2004-08-31	1			—	429.8587	432.1091	431.0937	0.8000	PERSON		1333	158			AMITY
10500100010250000000	00000000227	36	003	97 S MAIN ST	Belfast NY	NY	14711	France Mavis A	97 S MAIN ST	Belfast NY	NY	14711	Allegany	05573	Belfast	950402	9504.0200	1082.7987	49400	53400	49400	4000	2012-01-10	1			—	391.4400	393.0240	392.5411	0.2675	PERSON		2012	52588			BELFAST
23901300010380020000	00000001822	36	003	6363 MAIN ST	WILLIAMSVILLE	NY	14221	National Fuel Gas Dist	6363 MAIN ST	WILLIAMSVILLE	NY	14221	Allegany	79103	Wellsville	951000	9510	22658.0767	355200	400000	355200	44800		1			—	455.0331	457.8486	455.8089	5.5985	PERSON	2212	877	00268			WELLSVILLE
18300000010310020000	00000000994	36	003	4466 STATE ROUTE 275 FRIEDNSHIP…	FRIEDNSHIP	NY	14739	Sortore Malcolm	4466 STATE ROUTE 275 FRIEDNSHIP…	FRIEDNSHIP	NY	14739	Allegany	27705	Friendship	950600	9506	3309.1023	56300	61400	56300	5100	2018-10-05	1			—	448.0190	451.2359	450.4073	0.8179	PERSON		2018	99468			FRIENDSHIP
07701900010120000000	00000000739	36	003	8591 SUNSET RD	KENMORE	NY	14217	Smith Harmon J	8591 SUNSET RD	KENMORE	NY	14217	Allegany	12243	Caneadea	950402	9504.0200	822.7486	40100	132000	40100	91900	2005-10-31	1			—	441.4330	449.6690	444.8397	0.2032	PERSON		1464	171			CANEADEA
21601500030320010000	00000000459	36	003	50 ROCHAMEAU AVE	ANDOVER	NY	14806	Meyers Robert Bonnie	50 ROCHAMEAU AVE	ANDOVER	NY	14806	Allegany	02154	Andover	950900	9509	2198.9553	67100	71400	67100	4300	2017-06-06	2			—	510.1277	513.0180	512.0341	0.5100	PERSON		2017	90143			ANDOVER
23900700010710000000	00000001396	36	003	75 SUNNYDALE AVE	WELLSVILLE	NY	14895	Smith Roy Lisa	75 SUNNYDALE AVE	WELLSVILLE	NY	14895	Allegany	79103	Wellsville	950900	9509	1044.8182	94000	104000	94000	10000	1999-06-16	1			—	465.8529	466.6730	466.3506	0.2581	PERSON		1167	162			WELLSVILLE