Saved query d996e25196480b23

Data Explorer

Query the US Nationwide Parcel Dataset

$1.75 / 1,000 records$100 minimum

37/80

Live SQL

SELECT * 
FROM "lr_parcel_us" 
WHERE statefp = '01' 
  AND countyfp = '117'

108,061 matching parcels

Data Preview

parcelid	taxacctnum	statefp	countyfp	parceladdr	parcelcity	parcelstate	parcelzip	ownername	owneraddr	ownercity	ownerstate	ownerzip	countyname	cousubfp	cousubname	tractce	tractname	calcarea	firmid	firmdate	fldzone	zonesubty	elevmin	elevmax	elevavg	usecode	zoningcode	taxacres	ownertype	legaldesc	book	page	parceltype	accesstype	iucnclass	lrversion	taxdistrict
2700184000059000	0	01	117	4513 COTSWOLD LN		AL		DUNCAN CLARENCE W DUNCAN FRANCE…	4513 COTSWOLD LN	BIRMINGHAM	AL	35242	SHELBY	90558	CHELSEA	980100	9801	503.4276	01117C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	173.0370	176.3306	173.7238	R	RG	0.1200	PERSON	LOT 425 COTSWOLD SUB PHASE 1-A …	225	44	GOVT LOCAL	OPEN	OTHER	2026.2	32
2700184000060000	0	01	117	4533 COTSWOLD LN COMMON		AL		COTSWALD DEVELOPMENT LTD	4 OFFICE PARK CIRCLE SUITE 101	BIRMINGHAM	AL	35223	SHELBY	90558	CHELSEA	980100	9801	3804.3016	01073C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	159.6874	174.8766	169.3974	R	RG	0.9400	BUSINESS	COMMON AREA C COTSWOLD SUB PHAS…	225	44	GOVT LOCAL	OPEN	OTHER	2026.2	32
2700184000058000	0	01	117	4509 COTSWOLD LN		AL		BADHAM HALCYANN J	4509 COTSWOLD LN	BIRMINGHAM	AL	35242	SHELBY	90558	CHELSEA	980100	9801	441.7128	01117C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	173.2900	177.4212	174.1885	R	RG	0.1100	PERSON	LOT 426 COTSWOLD SUB PHASE 1-A …	225	44	GOVT LOCAL	OPEN	OTHER	2026.2	32
4000092000014000	0	01	117	4913 COSHATT DR	HOOVER	AL	35244	PHILPOT HAROLD CRAIG	4909 COSHATT DR	HOOVER	AL	35244	SHELBY	90036	ALABASTER-HELENA	030304	303.0400	1034.2353	01073C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	142.1913	153.2561	146.3859	R	A1	0.2600	PERSON	PT LOT B-2B FINAL RECORD PLAT O…	247	82				2026.2	23
4200143000009036	3	01	117	123 JONAGOLD RD	BESSEMER	AL	35022	TRIPLE P CORPORATION	28399 BURKART DR	ORANGE BEACH	AL	36561	SHELBY	90036	ALABASTER-HELENA	030350	303.5000	1160.3476	01073C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	166.1689	183.7089	174.1480	R	R1	0.2900	BUSINESS	POB SE COR OF SW1/4 OF SEC 14 T…	1000	0				2026.2	50
4200233000001005	0	01	117	1450 CHEROKEE BEACH RD ROW	BESSEMER	AL	35022	TODD TERRY JOAN	43 BROOKVIEW LN	HELENA	AL	35080	SHELBY	90036	ALABASTER-HELENA	030350	303.5000	253.1699	01117C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	141.6921	143.3736	142.3861	R	A1	0.0600	PERSON	COM AT SE COR OF N 1/2 OF NE4 O…	1000	0				2026.2	67
4200232000001003	0	01	117	111 EMPIRE CIR	BESSEMER	AL	35022	KELLEY DAVID BRIAN	5089 COBBLESTONE RD	WINSTON-SALEM	NC	27106	SHELBY	90036	ALABASTER-HELENA	030350	303.5000	3120.2847	01117C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	144.0963	168.8423	158.7834	R	A1	0.7700	PERSON	COM AT SE COR OF SE1/4 OF NW 1/…	1000	0				2026.2	67
4200232000001029	0	01	117	133 JONAGOLD RD	BESSEMER	AL	35022	BRADY RESIDENTIAL CONSTRUCTION	2089 KNOLLWOOD PL	BIRMINGHAM	AL	35242	SHELBY	90036	ALABASTER-HELENA	030350	303.5000	2991.5578	01117C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	188.4645	197.6697	194.3546	R	A-1	0.7400	PERSON	LOT 37 ROYAL GROVE PHASE 2 41/77	1041	77				2026.2	67
4200232000001028	0	01	117	141 JONAGOLD RD	BESSEMER	AL	35022	MCCOMBS TERRY A DONNA KAY	141 JONAGOLD ROAD	HELENA	AL	35080	SHELBY	90036	ALABASTER-HELENA	030350	303.5000	2650.4457	01117C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	186.0398	195.6313	191.8203	R	A-1	0.6500	PERSON	LOT 36-A RESURVEY OF LOTS 34 35…	1049	8				2026.2	67
4200232000001025	0	01	117	100 ORCHARD LN	BESSEMER	AL	35022	WASHINGTON CLIFTON L	100 ORCHARD LN	HELENA	AL	35080	SHELBY	90036	ALABASTER-HELENA	030350	303.5000	1845.2175	01117C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	143.4535	149.4783	146.5009	R	A1	0.4600	PERSON	LOT 23 ROYAL GROVE PHASE I PB 3…	1037	31				2026.2	67
4200232000001023	0	01	117	110 EMPIRE CIR	BESSEMER	AL	35022	BRADY RESIDENTIAL CONSTRUCTION	2089 KNOLLWOOD PL	BIRMINGHAM	AL	35242	SHELBY	90036	ALABASTER-HELENA	030350	303.5000	5139.3353	01117C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	144.9812	161.3899	152.4441	R	A1	1.2700	PERSON	LOT 21 ROYAL GROVE PHASE I PB 3…	1037	31				2026.2	67
4200232000001030	0	01	117	129 JONAGOLD RD	BESSEMER	AL	35022	BRADY RESIDENTIAL CONSTRUCTION	2089 KNOLLWOOD PL	BIRMINGHAM	AL	35242	SHELBY	90036	ALABASTER-HELENA	030350	303.5000	1727.0787	01117C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	186.9180	196.4162	192.9667	R	A-1	0.4300	PERSON	LOT 38 ROYAL GROVE PHASE 2 41/77	1041	77				2026.2	67
4200143000109000	3	01	117	4645 S SHADES CREST RD	BESSEMER	AL	35022	LAUREL LAKES LLC	788 SPRING HILL RD	TALLADEGA	AL	35160	SHELBY	90036	ALABASTER-HELENA	030350	303.5000	399.5075	01117C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	230.2625	235.3543	233.6635	R	R-1	0.1000	BUSINESS	LOT C2 COMMON AREA ASBURY PARC …	1041	70				2026.2	67
4200143000009020	0	01	117	2939 GLEN GATE DR	BESSEMER	AL	35022	STEWART MARJORIE ANN	2939 GLEN GATE DRIVE	HELENA	AL	35022	SHELBY	90036	ALABASTER-HELENA	030350	303.5000	2389.1585	01117C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	175.2363	184.3486	180.4878	R	R1	0.5900	PERSON	LOT 41 GLEN GATE 31/9	1031	9				2026.2	67
4200232000001015	0	01	117	132 ROYAL GALA DR	BESSEMER	AL	35022	BRADY RESIDENTIAL CONSTRUCTION	2089 KNOLLWOOD PL	BIRMINGHAM	AL	35242-241	SHELBY	90036	ALABASTER-HELENA	030350	303.5000	2679.2012	01117C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	168.0527	183.5827	176.1122	R	A1	0.6600	PERSON	LOT 13 ROYAL GROVE PHASE I PB 3…	1037	31				2026.2	67
4200282000065000	0	01	117	3631 OAKLEAF DR JOINT	BESSEMER	AL	35022	SPAINHOUR CHARLES J RHONDA M SP…	3631 OAKLEAF DR	HELENA	AL	35022	SHELBY	90036	ALABASTER-HELENA	030350	303.5000	358.7190	01073C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	176.3562	180.5120	177.7611	R	R1	0.0900	PERSON	THAT PT OF LOT 507 TIMBERLAKE S…	1041	47				2026.2	67
4200143000009035	0	01	117	2944 GLEN GATE DR JOINT	BESSEMER	AL	35022	GENTILE JON JANICE R	2944 GLEN GATE DR	HELENA	AL	35022	SHELBY	90036	ALABASTER-HELENA	030350	303.5000	841.9172	01117C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	167.3008	183.4614	174.2457	R	R1	0.2100	PERSON	LOT 39A GLEN GATE 31/9	1031	9				2026.2	67
4100072000001000	0	01	117	4149 S SHADES CREST RD	JOINT	AL	35244	SOUTHCREST PROPERTIES LLC	4129 S SHADES CREST RD	BIRMINGHAM	AL	35244	SHELBY	90036	ALABASTER-HELENA	030351	303.5100	890.6417	01117C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	212.3916	218.0189	216.1787	R	A-1	0.2200	BUSINESS	COM SE COR OF NW4 SEC 7 TP 20S …	1000	0				2026.2	50
4100072000001031	0	01	117	1141 MOUNTAINWOOD LN SE JOINT	HOOVER	AL	35244	SHINN RICHARD A SUZANNE J SHINN	1141 MOUNTAINWOOD LN SE	BIRMINGHAM	AL	35244	SHELBY	90036	ALABASTER-HELENA	030351	303.5100	2261.4430	01117C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	208.7089	219.0285	214.0229	R	A1	0.5600	PERSON	POB SE COR OF NW4 OF NW4 SEC 7 …	1000	0				2026.2	50
4200143000009021	0	01	117	2940 GLEN GATE DR	BESSEMER	AL	35022	COOK BONNIE A JAMIE WILSON	2940 GLEN GATE DR	HELENA	AL	35022	SHELBY	90036	ALABASTER-HELENA	030350	303.5000	2156.2611	01117C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	169.3612	181.4596	175.3471	R	R1	0.5300	PERSON	LOT 40 GLEN GATE 31/9	1031	9				2026.2	67
4200141000003001	0	01	117	4555 S SHADES CREST RD	BESSEMER	AL	35022	MASON RICHARD	4555 SOUTH SHADES CREST RD	HELENA	AL	35022	SHELBY	90036	ALABASTER-HELENA	030350	303.5000	1932.9272	01073C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	217.9111	226.0307	224.0692	R	R1	0.4800	PERSON	LOT 1 SILVER LAKES 1ST SECTOR 3…	1033	26				2026.2	67
4200232000001031	0	01	117	125 JONAGOLD RD	BESSEMER	AL	35022	MOLLICE JOSEPH TERRI	125 JONAGOLD RD	HELENA	AL	35080	SHELBY	90036	ALABASTER-HELENA	030350	303.5000	11566.0325	01117C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	166.4903	203.2898	190.4608	R	A-1	2.8600	PERSON	LOT 39 ROYAL GROVE PHASE 2 41/77	1041	77				2026.2	67
4200141000001002	0	01	117	4505 S SHADES CREST RD	BESSEMER	AL	35022	LAIRD TIMOTHY S JENNIFER C	4503 S SHADES CREST RD	HOOVER	AL	35022	SHELBY	90036	ALABASTER-HELENA	030350	303.5000	174.2840	01117C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	216.7902	218.3258	217.6384	R	A1	0.0400	PERSON	COM SE COR OF NE4 OF NE4 SEC 14…	1000	0				2026.2	50
4200232000001016	0	01	117	128 ROYAL GALA DR		AL		BRADY RESIDENTIAL CONSTRUCTION	2089 KNOLLWOOD PL	BIRMINGHAM	AL	35242	SHELBY	90036	ALABASTER-HELENA	030350	303.5000	1514.9210	01073C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	165.1224	178.4613	171.4749	R	A1	0.3700	PERSON	LOT 14 ROYAL GROVE PHASE I PB 3…	1037	31				2026.2	67
4100063000020000	3	01	117	4071 S SHADES CREST RD		AL		RIVERWOODS PROPERTIES LLC	123 RIVERWOODS PKWY	HELENA	AL	35080	SHELBY	90036	ALABASTER-HELENA	030351	303.5100	406.5346	01073C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	222.6446	225.3892	224.2267	R	A-1	0.1000	BUSINESS	COM AT SE INTER OF CO RD 2 E LI…	1000	0				2026.2	66