Saved query a4a85b6efd417e9b

Data Explorer

Query the US Nationwide Parcel Dataset

$1.75 / 1,000 records$100 minimum

45/80

Live SQL

SELECT * 
FROM "lr_parcel_us" 
WHERE statefp = '37' 
  AND countyfp = '033'

17,124 matching parcels

Data Preview

parcelid	taxacctnum	statefp	countyfp	parceladdr	parcelcity	parcelstate	parcelzip	ownername	ownercity	ownerstate	ownerzip	countyname	cousubfp	cousubname	tractce	tractname	calcarea	firmid	firmdate	fldzone	zonesubty	staticbfe	elevmin	elevmax	elevavg	usecode	taxacres	ownertype	legaldesc	book	page	lrversion	taxdistrict
0007 032	0007000000320000	37	033	3105 QUICK RD	RUFFIN	NC		LESLIE E BROWN	RUFFIN	NC	27326	CASWELL	91888	LOCUST HILL	930400	9304	4079.6737	37033C	2026-01-01	X	AREA OF MINIMAL FLOOD HAZARD	-9999				01	1.0800	PERSON	BOOK 310, PAGE 42; BOOK 329, PA…	310	42	2026.2	52
0031 018	0031000000180000	37	033	866 HOLLAND RD	PELHAM	NC		SHIRLEY JEAN PRICE	PELHAM	NC	27311	CASWELL	92468	PELHAM	930300	9303	1936.9874	37033C	2026-01-01	X	AREA OF MINIMAL FLOOD HAZARD	-9999				01	0	PERSON	BOOK 498, PAGE 364; BOOK 326, P…	498	364	2026.2	52
0031 370	0031000003700000	37	033	QUARRY ACCESS RD	PELHAM	NC		SOUTHSIDE REALTY INVESTMENTS & …	DUBLIN	VA	24084	CASWELL	92468	PELHAM	930300	9303	4651.3131	37033C	2026-01-01	X	AREA OF MINIMAL FLOOD HAZARD	-9999	196.8022	204.8489	199.4991		1.1299	BUSINESS	BOOK 585, PAGE 106; BOOK 585, P…	585	106	2026.2	52
0065 104	0065000001040000	37	033	857 PURLEY CHURCH RD	YANCEYVILLE	NC		PAUL LAMONT JEFFERS	YANCEYVILLE	NC	27379	CASWELL	90880	DAN RIVER	930200	9302	1395.6553	37033C	2026-01-01	X	AREA OF MINIMAL FLOOD HAZARD	-9999				05	0	PERSON	BOOK 465, PAGE 590; BOOK 302, P…	465	590	2026.2	52
00Y4G003	1004000700030000	37	033	181 OAK TREE ST	YANCEYVILLE	NC		EGYPTIAN PARTNERS LLC	YANCEYVILLE	NC	27379	CASWELL	94120	YANCEYVILLE	930200	9302	703.9364	37033C	2026-01-01	X	AREA OF MINIMAL FLOOD HAZARD	-9999				01	0	BUSINESS	BOOK 512, PAGE 710; BOOK 633, P…	512	710	2026.2	52
0090 105	0090000001050000	37	033	1706 E HUGHES MILL RD	BURLINGTON	NC		JEANNETTE SHAW-PEREZ	BURLINGTON	NC	27215	CASWELL	90056	ANDERSON	930600	9306	3865.0550	37033C	2026-01-01	X	AREA OF MINIMAL FLOOD HAZARD	-9999				05	1.0299	PERSON	BOOK 639, PAGE 1019; BOOK 614, …	639	1019	2026.2	52
0051 026	0051000000260000	37	033	5096 ALLISON RD	PELHAM	NC		ROSS & ETHEL GWYNN JR	PELHAM	NC	27311	CASWELL	91888	LOCUST HILL	930400	9304	2936.6541	37033C	2026-01-01	X	AREA OF MINIMAL FLOOD HAZARD	-9999				01	0	PERSON	BOOK 167, PAGE 7; BOOK 152, PAG…	167	7	2026.2	52
0003 119	0003000001190000	37	033	160 FOREST DR	PELHAM	NC		WENDELL HENDERSON	PELHAM	NC	27311	CASWELL	92468	PELHAM	930300	9303	4036.3505	37033C	2026-01-01	X	AREA OF MINIMAL FLOOD HAZARD	-9999				01	0	PERSON		195	407	2026.2	52
0049 016	0049000000160000	37	033	2660 PARK SPRINGS RD	PROVIDENCE	NC		SHELIA EVERHART	LEXINGTON	NC	27292	CASWELL	92468	PELHAM	930400	9304	3937.7796	37033C	2026-01-01	X	AREA OF MINIMAL FLOOD HAZARD	-9999				01	1.0399	PERSON		165	122	2026.2	52
0138 019	0138000000190000	37	033	13820 NC HWY 119	SEMORA	NC		CURTIS & BARBARA MCCAIN	SEMORA	NC	27343	CASWELL	92080	MILTON	930100	9301	2060.4181	37033C	2026-01-01	X	AREA OF MINIMAL FLOOD HAZARD	-9999				01	0	PERSON		163	768	2026.2	52
0137 014	0137000000140000	37	033	527 TAYLOR RD	SEMORA	NC		HERBERT O & DALE DUNN	SEMORA	NC	27343	CASWELL	92080	MILTON	930100	9301	2895.8632	37033C	2026-01-01	X	AREA OF MINIMAL FLOOD HAZARD	-9999				01	0	PERSON		189	337	2026.2	52
0074 020	0074000000200000	37	033	9217 NC HWY 62	YANCEYVILLE	NC		JUSTIN G & TINA H BARTS	BURLINGTON	NC	27217	CASWELL	90056	ANDERSON	930600	9306	3723.6568	37033C	2026-01-01	X	AREA OF MINIMAL FLOOD HAZARD	-9999				01	1.5000	PERSON		614	1450	2026.2	52
0050 132	0050000001320000	37	033	7267 ALLISON	PELHAM	NC		CHRISTOPHER C EATON & & NICHOLE…	PELHAM	NC	27311	CASWELL	92468	PELHAM	930400	9304	4384.2256	37033C	2026-01-01	X	AREA OF MINIMAL FLOOD HAZARD	-9999				01	1.0800	PERSON		593	784	2026.2	52
0106 113	0106000001130000	37	033	10073 NC HWY 62	MILTON	NC		MILTON B & JUANITA C WITHERS	MILTON	NC	27305	CASWELL	92080	MILTON	930100	9301	8910.8312	37033C	2026-01-01	X	AREA OF MINIMAL FLOOD HAZARD	-9999				05	2.2000	PERSON		286	328	2026.2	52
0138 009	0138000000090000	37	033	14048 NC HWY 119	SEMORA	NC		ZENOBA STEWART	ELLICOTT CITY	MD	21043	CASWELL	92080	MILTON	930100	9301	2405.4505	37033C	2026-01-01	X	AREA OF MINIMAL FLOOD HAZARD	-9999				01	0	PERSON		273	898	2026.2	52
0103 076	0103000000760000	37	033	8287 NC HWY 119TH HWY	MEBANE	NC		MARIA MIRIAM MARTINEZ GONZALEZ	MEBANE	NC	27302	CASWELL	90056	ANDERSON	930600	9306	4584.5585	37033C	2026-01-01	X	AREA OF MINIMAL FLOOD HAZARD	-9999				01	1.2699	PERSON		606	1148	2026.2	52
0022 065	0022000000650000	37	033	250 BIG OAK CL	RUFFIN	NC		CHRISTOPHER JUSTIN ARAGON	RUFFIN	NC	27326	CASWELL	91888	LOCUST HILL	930400	9304	4762.3772	37033C	2026-01-01	X	AREA OF MINIMAL FLOOD HAZARD	-9999				05	1.1699	PERSON		372	719	2026.2	52
0123 236	0123000002360000	37	033	671 MCCANN RD	MILTON	NC		JAMES M & TINA BRYANT	MILTON	NC	27305	CASWELL	92080	MILTON	930100	9301	20236.4835	37033C	2026-01-01	X	AREA OF MINIMAL FLOOD HAZARD	-9999				01	5	PERSON		245	661	2026.2	52
0141 026	0141000000260000	37	033	2875 SOLOMON LEA ROAD RD	LEASBURG,	NC		BARRY D SHAW	LEASBURG	NC	27291	CASWELL	91756	LEASBURG	930600	9306	7638.3724	37033C	2026-01-01	X	AREA OF MINIMAL FLOOD HAZARD	-9999				05	2.1900	PERSON		405	346	2026.2	52
0008 001	0008000000010000	37	033	64 ASHLAND RD	RUFFIN	NC		MARY COLEMAN HARRISON	RUFFIN	NC	27326	CASWELL	91888	LOCUST HILL	930400	9304	2987.0972	37033C	2026-01-01	X	AREA OF MINIMAL FLOOD HAZARD	-9999				01	0	PERSON		616	1311	2026.2	52
0014 022	0014000000220000	37	033	10678 CHERRY GROVE RD	REIDSVILLE	NC		JAMES H MANSFIELD	REIDSVILLE	NC	27320	CASWELL	93137	STONEY CREEK	930500	9305	3987.0505	37033C	2026-01-01	X	AREA OF MINIMAL FLOOD HAZARD	-9999				01	1.5000	PERSON		203	107	2026.2	52
0057 048	0057000000480000	37	033	197 MILESVILLE RD	ELON	NC		MYRON WALTER APPLE	ELON	NC	27244	CASWELL	93137	STONEY CREEK	930500	9305	6567.9202	37033C	2026-01-01	X	AREA OF MINIMAL FLOOD HAZARD	-9999				01	1.7200	PERSON		457	611	2026.2	52
0019 075	0019000000750000	37	033	807 S NUNNALLY RD	PELHAM	NC		BRENDA MURRAY LIPSCOMB	PELHAM	NC	27311	CASWELL	92468	PELHAM	930300	9303	4372.5709	37033C	2026-01-01	X	AREA OF MINIMAL FLOOD HAZARD	-9999				01	1.0599	PERSON		216	660	2026.2	52
0062 132	0062000001320000	37	033	3759 WALTERS MILL RD	PROVIDENCE	NC		RICKY W & TAMMY W RIGGS	PROVIDENCE	NC	27315	CASWELL	90880	DAN RIVER	930300	9303	12744.8653	37033C	2026-01-01	X	AREA OF MINIMAL FLOOD HAZARD	-9999				01	3.4100	PERSON		360	624	2026.2	52
0067 158	0067000001580000	37	033			NC	0	CASWELL COUNTY	YANCEYVILLE	NC	27379	CASWELL	94120	YANCEYVILLE	930200	9302	6569.8925	37033C	2026-01-01	X	AREA OF MINIMAL FLOOD HAZARD	-9999					1.8500	PERSON		300	383	2026.2	52