Saved query 0b8c4abd5e2437ad

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 = '01' 
  AND countyfp = '117'

108,061 matching parcels

Data Preview

parcelid	taxacctnum	statefp	countyfp	parceladdr	parcelcity	parcelstate	parcelzip	countyname	cousubfp	cousubname	tractce	tractname	calcarea	numbldgs	firmid	firmdate	fldzone	zonesubty	elevmin	elevmax	elevavg	taxacres	naicscode	legaldesc	book	page	placename	placetype	taxyear
13 5 21 2 001 001 014	13 5 21 2 001 001 014	01	117	1054 WILTSHIRE LANE	HELENA	AL	35080	SHELBY	90036	ALABASTER-HELENA	030336	303.3600	16790.7317	0	01117C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	128.7798	150.7484	138.8909	4.1400		BEG SE COR W1/2 NW1/4 W TO SW C…	00	000			2019
13 1 02 4 001 001 024	13 1 02 4 001 001 024	01	117	1110 CAMELLIA RIDGE DRIVE	PELHAM	AL	35124	SHELBY	90036	ALABASTER-HELENA	030316	303.1600	702.4675	1	01117C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	204.0536	206.1673	205.5793	0			51	095			2021
13 4 18 1 002 033 000	13 4 18 1 002 033 000	01	117	1032 CLIFTON ROAD	HOOVER	AL	35244	SHELBY	90036	ALABASTER-HELENA	030351	303.5100	916.1833	4	01117C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	134.8358	141.2707	137.0811	0
13 3 07 2 001 015 000	13 3 07 2 001 015 000	01	117	4181 SOUTH SHADES CREST ROAD	HOOVER	AL	35244	SHELBY	90036	ALABASTER-HELENA	030351	303.5100	5112.9911	0	01117C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	215.2691	226.7370	222.0913	0
08 8 27 0 001 039 011	08 8 27 0 001 039 011	01	117	11051 HWY 280	STERRETT	AL	35147	SHELBY	93321	VINCENT	030103	301.0299	7843.6867	0	01117C	2026-01-23	X	0.2 PCT ANNUAL CHANCE FLOOD HAZ…	139.3018	143.8652	141.0273		531130				METRO MINI STORAGE - WESTOVER	SELF-STORAGE FACILITY
03 9 31 0 993 030 000	03 9 31 0 993 030 000	01	117	906 BARRISTERS COURT	BIRMINGHAM	AL	35242	SHELBY	90558	CHELSEA	030212	302.1200	68.2368	1	01117C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	159.5166	159.6325	159.5516				41	136
13 7 25 1 001 001 004	13 7 25 1 001 001 004	01	117	1811 MCCAIN PARKWAY	PELHAM	AL	35124	SHELBY	90036	ALABASTER-HELENA	030345	303.4500	3739.5443	0	01117C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	150.6907	162.3272	154.8895						SOUTHEASTERN BUTCHER SUPPLIES	MANUFACTURER
28 4 17 4 008 052 000	28 4 17 4 008 052 000	01	117	184 COLEMAN WAY	CALERA	AL	35040	SHELBY	90450	CALERA	030503	305.0299	822.3863	1	01117C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	178.4802	182.1949	180.2800	0
03 9 31 0 011 001 000	03 9 31 0 011 001 000	01	117	1001 WINDSOR DRIVE	BIRMINGHAM	AL	35242	SHELBY	90036	ALABASTER-HELENA	030330	303.3000	237.6379	2	01117C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	199.3711	202.3752	200.8971	0
36 2 03 2 003 032 000	36 2 03 2 003 032 000	01	117	4450 HWY 25	MONTEVALLO	AL	35115	SHELBY	92205	MONTEVALLO	030405	304.0500	1085.8710	0	01117C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	133.3477	134.6202	133.9242		6216				DAVE'S CONSTRUCTION AND BUILDERS	HOME_SERVICE
08 9 30 4 004 031 000	08 9 30 4 004 031 000	01	117	212 CHELSEA PARK ROAD	CHELSEA	AL	35043	SHELBY	90558	CHELSEA	030219	302.1900	523.3244	1	01117C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	151.5310	153.4889	152.5585	0
09 7 36 4 004 033 000	09 7 36 4 004 033 000	01	117	9986 CHELSEA PARK TRAIL	CHELSEA	AL	35043	SHELBY	90558	CHELSEA	030219	302.1900	641.2423	1	01117C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	162.4754	165.8052	164.2189	0
13 4 18 2 001 021 001	13 4 18 2 001 021 001	01	117	10 IDLE LANE	HELENA	AL	35080	SHELBY	90036	ALABASTER-HELENA	030351	303.5100	407.4287	0	01117C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	129.4818	131.3952	130.5104	0
14 1 12 1 002 055 000	14 1 12 1 002 055 000	01	117	531 BENT CREEK TRACE	CHELSEA	AL	35043	SHELBY	90036	ALABASTER-HELENA	030615	306.1500	1883.6519	1	01117C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	184.2998	188.9441	187.2167
22 7 36 3 002 027 000	22 7 36 3 002 027 000	01	117	255 TRAINING CENTER DRIVE	CALERA	AL	35040	SHELBY	90450	CALERA	030502	305.0200	1250.0036		01117C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	169.1483	170.9046	170.0156	0
35 1 01 1 006 047 000	35 1 01 1 006 047 000	01	117	1139 TIMBERLINE RIDGE	CALERA	AL	35040	SHELBY	90450	CALERA	030502	305.0200	1240.5938		01117C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	181.3594	190.9988	186.8370	0
20 6 13 0 002 010 000	20 6 13 0 002 010 000	01	117	272 LOKEY DRIVE	WILSONVILLE	AL	35186	SHELBY	93474	WILSONVILLE	030800	308	10537.4099	1	01117C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	122.0020	127.5043	124.7974	0
08 8 33 0 000 017 001	08 8 33 0 000 017 001	01	117	404 ROCK SCHOOL ROAD	WILSONVILLE	AL	35186	SHELBY	90558	CHELSEA	030219	302.1900	28501.8057	2	01117C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	164.7754	176.7948	172.3980	7.1600
13 4 20 3 005 051 000	13 4 20 3 005 051 000	01	117	4132 OLD CAHABA PARKWAY	HELENA	AL	35080	SHELBY	90036	ALABASTER-HELENA	030336	303.3600	490.9612	0	01117C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	124.5476	126.5350	125.9295	0
15 8 34 0 000 008 005	15 8 34 0 000 008 005	01	117	FOSTER CEMETERY	COLUMBIANA	AL	35051	SHELBY	90711	COLUMBIANA	030701	307.0100	1244.8887	1	01117C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	165.6573	168.0955	167.4978	0.3100
34 3 06 3 005 005 000	34 3 06 3 005 005 000	01	117	316 OAKMONT CIRCLE	CALERA	AL	35040	SHELBY	90450	CALERA	030502	305.0200	724.7311		01117C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	153.6353	157.1364	155.4502	0
08 9 31 1 004 060 000	08 9 31 1 004 060 000	01	117	591 GRAYSON PLACE	CHELSEA	AL	35043	SHELBY	90558	CHELSEA	030219	302.1900	686.2615	1	01117C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	160.0301	161.4068	160.5264	0.1500
28 5 16 2 011 013 000	28 5 16 2 011 013 000	01	117	2035 KERRY CIRCLE	CALERA	AL	35040	SHELBY	90450	CALERA	030503	305.0299	831.9101	1	01117C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	165.3261	171.0361	168.9905
23 7 25 2 003 049 000	23 7 25 2 003 049 000	01	117	329 TANGLEWOOD CIRCLE	ALABASTER	AL	35007	SHELBY	90036	ALABASTER-HELENA	030613	306.1300	986.3442	0	01117C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	152.7304	154.7807	154.3302
28 5 16 3 003 006 000	28 5 16 3 003 006 000	01	117	515 14TH STREET	CALERA	AL	35040	SHELBY	90450	CALERA	030503	305.0299	3654.5552	0	01117C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	161.4543	163.9176	162.8103