Saved query 3334b40f86e43aa1

Data Explorer

Query the US Nationwide Parcel Dataset

$1.75 / 1,000 records$100 minimum

40/80

Live SQL

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

330,120 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	lrversion	taxdistrict
4000084004021000	0	01	073	4734 SYLVANER LN	HOOVER	AL	35244	WATSON KENNY	4734 SYLVANER LANE	BIRMINGHAM	AL	35244	JEFFERSON	90324	BIRMINGHAM	012907	129.0700	1824.2641	01073C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	165.7310	173.4859	169.9398	R	R2	0.4500	PERSON	LOT 29 BLK 6 WINE RIDGE 2ND SEC…	107	47	2026.2	02
2200113001021000	0	01	073	2230 42ND AVE N	BIRMINGHAM	AL	35207	PATTON EDDIE L JR	3762 GRENNOCH LN	HOUSTON	TX	77025	JEFFERSON	90324	BIRMINGHAM	012004	120.0400	501.5715	01073C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	197.5216	202.3550	200.3665	R	R4	0.1200	PERSON	LOT 28 BLK 2 WASHINGTON HTS 16/…	16	51	2026.2	39
2900212006016000	0	01	073	1668 PINE AVE SW	BIRMINGHAM	AL	35211	HOLLOWELL BRENDA	23701 BEVERLY ST	OAK PARK	MI	48237	JEFFERSON	90324	BIRMINGHAM	013002	130.0200	947.7196	01073C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	203.5642	208.9618	205.4705	R	R3	0.2300	PERSON	LOT 6 BLK 8 PLAT A ISHKOODA	35	59	2026.2	34
1300363012034000	0	01	073	11 SUNSET LN	CENTER POINT	AL	35215	STEELE SHERRY M	11 SUNSET LN	BIRMINGHAM	AL	35215	JEFFERSON	90324	BIRMINGHAM	005905	59.0500	977.1286	01073C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	209.8506	212.0690	210.6031	R	R2	0.2400	PERSON	LOT 29 BOWDEN-BISHOP ADD TO ROE…	41	68	2026.2	31
2200233026006000	0	01	073	1329 24TH AVE N	BIRMINGHAM	AL	35204	JOHNSON NORMAN	1329 24TH AVE N	BIRMINGHAM	AL	35204	JEFFERSON	90324	BIRMINGHAM	001200	12	580.4569	01073C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	168.8199	169.9234	169.3144	R	R6	0.1400	PERSON	LOT 19 BLK 1 MUNGER RLTY COS 1 …	15	97	2026.2	35
2300154012006000	3	01	073	7111 DIVISION AVE	BIRMINGHAM	AL	35206	EDWARDS ANDRE L	924 THOMAS DR	BIRMINGHAM	AL	35215	JEFFERSON	90324	BIRMINGHAM	002200	22	766.6561	01073C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	192.7187	193.2766	193.0357	R	R4	0.1900	PERSON	LOT 15 BLK 13 EAST LAKE	1	217	2026.2	33
2300082021008000	3	01	073	5012 43RD PL N	TARRANT	AL	35217	GRAVES LURA OLENE	5000 43RD PL N	BIRMINGHAM	AL	35217	JEFFERSON	90324	BIRMINGHAM	000400	4	650.0522	01073C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	196.2817	201.4806	199.7137	R	R3	0.1600	PERSON	LOT 5 BLK 9 JEFFERSON HILLS 3RD…	16	9	2026.2	35
3000223025009000	3	01	073	1508 10TH AVE	MIDFIELD	AL	35228	MCCULLAR KEVIN	2061 EDENWOOD DR	HUEYTOWN	AL	35023	JEFFERSON	90324	BIRMINGHAM	013801	138.0100	677.1740	01073C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	158.2315	168.5211	163.3261	R	B2	0.1700	PERSON	LOT 13 BL C WEST FAIRFIELD	1002	38	2026.2	51
2300181016004000	0	01	073	3921 37TH AVE N	TARRANT	AL	35217	ESLAVA MARIA DE LA LUZ	2204 HUGHES DR	FULTONDALE	AL	35068	JEFFERSON	90324	BIRMINGHAM	000400	4	742.2935	01073C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	190.3849	193.3670	191.7383	R	R4	0.1800	PERSON	LOT 6 BLK 4 W M WESTBROOK ADD T…	12	89	2026.2	39
0900122000017000	0	01	073	6521 MAGNOLIA DR	PINSON	AL	35126	CARROLL JAMES BRENDA	6521 MAGNOLIA DR	PINSON	AL	35126	JEFFERSON	92484	PALMERDALE	011206	112.0600	2090.2205	01073C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	241.6500	247.3646	244.0913	R	A1	0.5200	PERSON	LOT 60 EMERALD VALLEY RESORT 80…	80	16	2026.2	02
2200292001003000	0	01	073	109 ALDER AVE	FORESTDALE	AL	35214	DORSEY ROSLYN V	109 ALDER AVE	BIRMINGHAM	AL	35214	JEFFERSON	90324	BIRMINGHAM	001100	11	621.0579	01073C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	187.7807	192.4770	190.0683	R	R4	0.1500	PERSON	LOTS 2 3 BLK D EAST HGLDS ADD T…	3	104	2026.2	33
2900164018004000	0	01	073	2017 14TH PL SW	BIRMINGHAM	AL	35211	ELLIOTT BENNIE LAMAR	1500 EXETER AVE APT 411	BESSEMER	AL	35020	JEFFERSON	90324	BIRMINGHAM	013002	130.0200	626.6958	01073C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	199.4241	205.2473	202.5089	R	R3	0.1500	PERSON	LOT 10 BLK 37 MASON CITY	6	8	2026.2	35
2300201013019000	0	01	073	4532 11TH AVE N	BIRMINGHAM	AL	35212	TURNER LEE G	4532 11TH AVE N	BIRMINGHAM	AL	35212	JEFFERSON	90324	BIRMINGHAM	000500	5	650.3892	01073C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	182.2154	183.9208	182.9875	R	R4	0.1600	PERSON	LOT 17 BLK 1 BROWNS REEDS ADD T…	903	20	2026.2	31
1200291012009000	0	01	073	1401 OAK TER	CENTER POINT	AL	35235	WARD NOAH CHRISTIAN	1401 OAK TER	BIRMINGHAM	AL	35235	JEFFERSON	90324	BIRMINGHAM	005907	59.0700	1393.4636	01073C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	270.8997	276.1750	273.2255	R	R1	0.3400	PERSON	LOT 9 BLK G SPRING LAKE MANOR	36	89	2026.2	37
1300361005006000	0	01	073	949 PARKWAY DR	CENTER POINT	AL	35215	SANDERS DENNIS C SANDERS ISAIAH	949 PARKWAY DR	BIRMINGHAM	AL	35215	JEFFERSON	90324	BIRMINGHAM	005905	59.0500	1170.4392	01073C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	212.9139	214.9454	214.0555	R	R2	0.2900	PERSON	LOT 6 BLK 5 MEADOWBROOK ESTS	34	6	2026.2	35
2900044010022000	0	01	073	1024 FULTON AVE SW	BIRMINGHAM	AL	35211	ARRINGTON SHARON D	1024 FULTON AVE SW	BIRMINGHAM	AL	35211	JEFFERSON	90324	BIRMINGHAM	004000	40	882.4349	01073C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	171.8134	173.2528	172.5512	R	R4	0.2200	PERSON	LOT 19 BLK 17 WEST END LAND IMP…	1	38	2026.2	39
3000223016001000	0	01	073	1502 9TH AVE W	MIDFIELD	AL	35228	COLFAX PROPERTIES LLC	2068 BROOK HIGHLAND RIDGE	BIRMINGHAM	AL	35242	JEFFERSON	90324	BIRMINGHAM	013801	138.0100	652.2741	01073C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	164.5017	167.7830	166.8198	R	B2	0.1600	BUSINESS	LOT 9 BL A WEST FAIRFIELD	1002	38	2026.2	58
2900074033018000	0	01	073	5520 CT P	BIRMINGHAM	AL	35208	HENDERSON TAREZ R	353 EAST CENTERVIEW DR	CARSON	CA	90746	JEFFERSON	90324	BIRMINGHAM	003802	38.0200	609.4121	01073C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	164.4877	165.7681	165.1047	R	R3	0.1500	PERSON	LOT 19 BLK 3 MRS BETTIE RICKS A…	13	64	2026.2	36
2300143025008000	0	01	073	744 71ST ST S	BIRMINGHAM	AL	35206	AO PROPCO 1 LLC	199 LAFAYETTE STREET	NEW YORK	NY	10012	JEFFERSON	90324	BIRMINGHAM	002200	22	557.1422	01073C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	220.1356	221.9607	220.5916	R	R3	0.1400	BUSINESS	LOT 12 BLK 2 HAWKINS ADD TO GAT…	6	25	2026.2	34
0900174000066000	0	01	073	7621 ASPEN RIDGE LN	PINSON	AL	35126	GRIFFIN ANGELA	120 AMERICA STREET	ORLANDO	FL	32801	JEFFERSON	92484	PALMERDALE	011206	112.0600	1797.9542	01073C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	247.1174	254.5296	251.3217	R	R-2	0.4400	PERSON	LOT 540 ASPEN RIDGE 5TH SECTOR …	226	31	2026.2	48
2700074007009000	0	01	073	4133 ALSTON LN	MEADOW BROOK	AL	35242	SMITH JAN M	4133 ALSTON LN	VESTAVIA	AL	35242	JEFFERSON	91845	LEEDS	012703	127.0300	845.5046	01073C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	187.0735	188.5019	188.0676	R	R7PUD	0.2100	PERSON	LOT 145 ALSTON MEADOWS PB 194 P…	194	73	2026.2	20
3900291000075000	0	01	073	5266 COTTAGE LN	HOOVER	AL	35226	DESENO LAUREN	9530 CRETE CIR	TUSCALOOSA	AL	35406	JEFFERSON	91656	HOOVER	014415	144.1500	399.2435	01073C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	188.5841	189.7821	189.4978	R	PR1	0.1000	PERSON	LOT 70 THE COTTAGES AT DEER VAL…	1032	37	2026.2	66
2200262016009000	0	01	073	1618 19TH AVE N	BIRMINGHAM	AL	35234	HALL LESLIE M	1618 19TH AVE N	BIRMINGHAM	AL	35204	JEFFERSON	90324	BIRMINGHAM	001400	14	743.1629	01073C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	165.8684	169.8789	168.0186	R	R3	0.1800	PERSON	LOT 14 BLK 3 NORTH HAVEN SEC 26…	5	23	2026.2	36
0300190000019011	0	01	073	1652 MORTON RD	WARRIOR	AL	35180	MCMURRAY CARL A	1652 MORTON RD	WARRIOR	AL	35180	JEFFERSON	93366	WARRIOR	011402	114.0200	2170.2417	01073C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	158.4397	162.4946	160.8722	R	R1	0.5400	PERSON	LOT 6 SWEETWATER 1ST ADD TO 2ND…	194	39	2026.2	02
2300031026008000	3	01	073	1321 91ST ST N	BIRMINGHAM	AL	35206	WILSON NAOMI	1325 91ST ST N	BIRMINGHAM	AL	35206	JEFFERSON	90324	BIRMINGHAM	011904	119.0400	662.9517	01073C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	254.7411	258.4885	256.6217	R	R3	0.1600	PERSON	LOT 18 BLK 2 AIRPORT ESTS 1ST A…	26	12	2026.2	31