Saved query 1aaa850cc8e52a19

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 = '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	numbldgs	firmid	firmdate	fldzone	zonesubty	staticbfe	elevmin	elevmax	elevavg	usecode	taxacres	ownertype	naicscode	legaldesc	book	page	placename	placetype	taxdistrict
00Y9C008	1009000300080000	37	033	577 MAIN ST	YANCEYVILLE	NC	27379	GREGORY CARLTON DEATON	BLANCH	NC	27212	CASWELL	94120	YANCEYVILLE	930200	9302	2792.9106	3	37033C	2026-01-01	X	AREA OF MINIMAL FLOOD HAZARD	-9999				01	0	PERSON	81311	BOOK 580, PAGE 546; BOOK 176, P…	580	546	FRESH ANOINTED APOSTOLIC TABERN…	RELIGIOUS_ORGANIZATION	52
0138 123	0138000001230000	37	033	5070 NC HWY 57	SEMORA	NC	27343	MAGNOLIA HILLS OF THE SOUTH	REIDSVILLE	NC	27320	CASWELL	92080	MILTON	930100	9301	5009.1372	1	37033C	2026-01-01	X	AREA OF MINIMAL FLOOD HAZARD	-9999				49	1.5700	PERSON	45911	BOOK 563, PAGE 768; BOOK 618, P…	563	768	DOLLAR GENERAL	DISCOUNT_STORE	52
0031 347	0031000003470000	37	033	DINK RD	PELHAM	NC	27311	THOMAS L & BRENDA L HOSKINS	PELHAM	NC	27311	CASWELL	92468	PELHAM	930300	9303	40014.9608		37033C	2026-01-01	X	AREA OF MINIMAL FLOOD HAZARD	-9999	174.1936	182.6647	176.6759		10.0100	PERSON		BOOK 454, PAGE 151; BOOK 222, P…	454	151			52
0083 040	0083000000400000	37	033	331 PIEDMONT DR	YANCEYVILLE	NC	27379	PIEDMONT TECH INSTITUTE & PIEDM…	YANCEYVILLE	NC	27379	CASWELL	94120	YANCEYVILLE	930200	9302	54729.4481	1	37033C	2026-01-01	X	AREA OF MINIMAL FLOOD HAZARD	-9999				46,46	13.4600	NONPROFIT	6113		236	227	PIEDMONT COMMUNITY COLLEGE	COLLEGE_UNIVERSITY	52
0016 011	0016000000110000	37	033	PRINCETON RD	DANVILLE	NC	27311	THOMAS S BOOKER TRUSTEE & THOMA…	DANVILLE	VA	24541	CASWELL	92468	PELHAM	930300	9303	234013.6356		37033C	2026-01-01	X	AREA OF MINIMAL FLOOD HAZARD	-9999	134.7588	176.8576	148.6217		57.9000	TRUST		BOOK 535, PAGE 1408; BOOK 650, …	535	1408			52
0135 026	0135000000260000	37	033	NC HWY 49	PROSPECT HILL	NC	27314	HELMS HUNDRED ACRE WOOD LLC	RALEIGH	NC	27613	CASWELL	91492	HIGHTOWERS	930600	9306	398525.4654	1	37033C	2026-01-01	X	AREA OF MINIMAL FLOOD HAZARD	-9999					100.7099	BUSINESS		BOOK 618, PAGE 526; BOOK 657, P…	618	526			52
0008 071	0008000000710000	37	033	11008 PARK SPRINGS RD	RUFFIN	NC	27326	JERRY K & DONNA S PASCHAL	RUFFIN	NC	27326	CASWELL	91888	LOCUST HILL	930400	9304	62305.9647	1	37033C	2026-01-01	X	AREA OF MINIMAL FLOOD HAZARD	-9999					15.6700	PERSON		BOOK 549, PAGE 1185; BOOK 470, …	549	1185			52
0086 040	0086000000400000	37	033	205 GEORGE RUSSELL RD	YANCEYVILLE	NC	27379	RUBY DIANE KELLIHAN	YANCEYVILLE	NC	27379	CASWELL	94120	YANCEYVILLE	930600	9306	4736.3162	1	37033C	2026-01-01	X	AREA OF MINIMAL FLOOD HAZARD	-9999				05	1.3200	PERSON		BOOK 566, PAGE 605; BOOK 428, P…	566	605			52
0019A033	0019010000330000	37	033	429 JEFFRIES RD	PELHAM	NC	27311	DANNY & VERA WILSON	PELHAM	NC	27311	CASWELL	92468	PELHAM	930300	9303	3971.0202	1	37033C	2026-01-01	X	AREA OF MINIMAL FLOOD HAZARD	-9999				01	0	PERSON		BOOK 174, PAGE 323; BOOK 161, P…	174	323			52
0023 009	0023000000090000	37	033	9871 PARK SPRINGS RD	RUFFIN	NC	27326	OLETA JONES CHAMBERS & & PEGGY …	RUFFIN	NC	27326	CASWELL	91888	LOCUST HILL	930400	9304	5125.6589	1	37033C	2026-01-01	X	AREA OF MINIMAL FLOOD HAZARD	-9999				01	1.5000	PERSON		BOOK 436, PAGE 32; BOOK 144, PA…	436	32			52
0071 098	0071000000980000	37	033	1222 MARSHALL GRAVES RD	YANCEYVILLE	NC	27379	LEWIS D GRAVES L/E & LABONITA G…	YANCEYVILLE	NC	27379	CASWELL	90056	ANDERSON	930500	9305	4076.6564	1	37033C	2026-01-01	X	AREA OF MINIMAL FLOOD HAZARD	-9999				01	1.0099	PERSON		BOOK 584, PAGE 1071; BOOK 575, …	584	1071			52
0117 041	0117000000410000	37	033	365 HIGHTOWERS RD	MEBANE	NC	27302	JAMIE STEVEN & MISTY P COOK	PROSPECT HILL	NC	27314	CASWELL	91492	HIGHTOWERS	930600	9306	163849.4146	1	37033C	2026-01-01	X	AREA OF MINIMAL FLOOD HAZARD	-9999					43.4099	PERSON		BOOK 641, PAGE 1543; BOOK 286, …	641	1543			52
0137 049	0137000000490000	37	033	15491 NC HWY 119 N	SEMORA	NC	27343	JEB REALTY LLC	DANVILLE	VA	24540	CASWELL	92080	MILTON	930100	9301	5791.1892	1	37033C	2026-01-01	X	AREA OF MINIMAL FLOOD HAZARD	-9999				05	1.5299	BUSINESS		BOOK 568, PAGE 585; BOOK 490, P…	568	585			52
125A 059	0125010000590000	37	033	8 ROBIN RD	SEMORA	NC	27343	MICHAEL J LAWSON JR	FUQUAY VARINA	NC	27343	CASWELL	92080	MILTON	930600	9306	3542.4123	1	37033C	2026-01-01	X	AREA OF MINIMAL FLOOD HAZARD	-9999				01	0	PERSON		BOOK 617, PAGE 556; BOOK 599, P…	617	556			52
0052 052	0052000000520000	37	033	741 BLACKWELL RD	YANCEYVILLE	NC	27379	MARY G GLENN DOROTHY BLACKWELL …	YANCEYVILLE	NC	27379	CASWELL	94120	YANCEYVILLE	930200	9302	4440.0037	1	37033C	2026-01-01	X	AREA OF MINIMAL FLOOD HAZARD	-9999				01	0	PERSON		BOOK 561, PAGE 1404; BOOK 176, …	561	1404			52
0131 073	0131000000730000	37	033	1662 JOHN OAKLEY RD	PROSPECT HILL	NC	27314	CHAD DANIEL MILLS & & CURTIS D …	PROSPECT HILL	NC	27314	CASWELL	91492	HIGHTOWERS	930600	9306	13849.2660	2	37033C	2026-01-01	X	AREA OF MINIMAL FLOOD HAZARD	-9999				05	3.5000	PERSON		BOOK 561, PAGE 1329; BOOK 504, …	561	1329			52
0128 054	0128000000540000	37	033	381 PERCY BRANN	LEASBURG	NC	27291	KIEFER LANDSCAPING INC	DURHAM	NC	27713	CASWELL	91756	LEASBURG	930600	9306	85489.4257	1	37033C	2026-01-01	X	0.2 PCT ANNUAL CHANCE FLOOD HAZ…	-9999					22.8700	BUSINESS		BOOK 649, PAGE 1190; BOOK 639, …	649	1190			52
0124 091	0124000000910000	37	033	135 MOTLEY DR	MILTON	NC	27305	ONASSIS & GLADYS L J STEWART	MILTON	NC	27305	CASWELL	92080	MILTON	930100	9301	7383.4338	2	37033C	2026-01-01	X	AREA OF MINIMAL FLOOD HAZARD	-9999				05	1.8200	PERSON		BOOK 539, PAGE 425; BOOK 526, P…	539	425			52
0031 325	0031000003250000	37	033	94 HOLLAND RD	PELHAM	NC	27311	ARTEMAS ABBOTT	PELHAM	NC	27311	CASWELL	92468	PELHAM	930300	9303	4781.5061	1	37033C	2026-01-01	X	AREA OF MINIMAL FLOOD HAZARD	-9999				01	1.2500	PERSON		BOOK 507, PAGE 846; BOOK 497, P…	507	846			52
0114 094	0114000000940000	37	033	2077 NC HWY 119	LEASBURG	NC	27291	MICHAEL COLEY & LINDA HARVEY	YANCEYVILLE	NC	27379	CASWELL	91756	LEASBURG	930600	9306	9884.7132	1	37033C	2026-01-01	X	AREA OF MINIMAL FLOOD HAZARD	-9999				05	2.7200	PERSON		BOOK 641, PAGE 648; BOOK 316, P…	641	648			52
0090 106	0090000001060000	37	033	307 ROSS ACRES # 2 RD	BURLINGTON	NC	27217	HAZEL ROBINSON	BURLINGTON	NC	27217	CASWELL	90056	ANDERSON	930600	9306	6006.7996	1	37033C	2026-01-01	X	AREA OF MINIMAL FLOOD HAZARD	-9999					1.6399	PERSON		BOOK 517, PAGE 994; BOOK 277, P…	517	994			52
0095 031	0095000000310000	37	033	5012 NC HWY 62	BLANCH	NC	27212	BILLY D & PORCHIA BRANDON L/E &…	BLANCH	NC	27212	CASWELL	90880	DAN RIVER	930100	9301	5356.7402	1	37033C	2026-01-01	X	AREA OF MINIMAL FLOOD HAZARD	-9999				01	1.4600	PERSON		BOOK 653, PAGE 1530; BOOK 189, …	653	1530			52
0106 006	0106000000060000	37	033	538 CULVER RD	MILTON	NC	27305	STANDFIELD'S RENTAL LLC	MILTON	NC	27305	CASWELL	92080	MILTON	930100	9301	7026.0683	2	37033C	2026-01-01	X	AREA OF MINIMAL FLOOD HAZARD	-9999					2.2500	BUSINESS		BOOK 641, PAGE 1395; BOOK 590, …	641	1395			52
0118 036	0118000000360000	37	033	3183 CORBETT RIDGE RD	MEBANE	NC	27302	KIZZIE DARLENE CAMPOS	MEBANE	NC	27302	CASWELL	91492	HIGHTOWERS	930600	9306	5460.5606	1	37033C	2026-01-01	X	AREA OF MINIMAL FLOOD HAZARD	-9999				05	1.4600	PERSON		BOOK 597, PAGE 1332; BOOK 582, …	597	1332			52
0063 088	0063000000880000	37	033	COMPTON RD	PROVIDENCE	NC	27315	CASTELLO SIDNEY	YANCEYVILLE	NC	27379	CASWELL	90880	DAN RIVER	930300	9303	3940.8073	1	37033C	2026-01-01	X	AREA OF MINIMAL FLOOD HAZARD	-9999					1	PERSON		BOOK 262, PAGE 865; BOOK 176, P…	262	865			52