Saved query 3d3aa253585b83e1

Data Explorer

Query the US Nationwide Parcel Dataset

$1.75 / 1,000 records$100 minimum

40/80

Live SQL

SELECT * 
FROM "parcel_layer" 
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	naicscode	legaldesc	book	page	placename	placetype	taxdistrict
2200353020002701	8	01	073	702 5TH AVE N	BIRMINGHAM	AL	35203	ENGEL MARVIN	PO BOX 530487	BIRMINGHAM	AL	35253-0487	Jefferson	90324	BIRMINGHAM	002900	29	749.7417	01073C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	171.8204	172.6761	172.3910	C	M1	0.1900	PERSON	33635	37-1 2 INT IN POB NW INTER OF 7…	15	43	BEARINGS AND POWER TRANSMISSION	MANUFACTURER	31
1200192009006000	0	01	073	1700 CENTER POINT PKWY	CENTER POINT	AL	35215	MTZ PROPERTIES LLC	500 PLAZA DRIVE	BIRMINGHAM	AL	35215	Jefferson	90324	BIRMINGHAM	011803	118.0300	1567.4323	01073C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	244.0656	245.1718	244.8938	C	C1	0.3900	BUSINESS	44112	COM AT SW COR OF LOT 4 BLK 8 BO…	27	40	CHOCO'S AUTO SALES	AUTO_DEALER	47
4000063009012000	0	01	073	2316 DERBY DR	VESTAVIA HILLS	AL	35216	GROBAN CHRISTOPHER C JENNIFER	2316 DERBY DRIVE	VESTAVIA HILLS	AL	35216	Jefferson	90324	BIRMINGHAM	012917	129.1699	1254.3463	01073C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	153.7433	166.3718	160.0404	R	R2	0.3100	PERSON	54141	LOT 6 BLK 13 DERBY DOWNS 1ST SE…	70	69	LADDER 41 EXTERIOR CLEANING LLC	PROFESSIONAL_SERVICE	20
2900141003007001	0	01	073	540 VALLEY AVE	HOMEWOOD	AL	35209	PRIVATE MINI STORAGE GRP I LP	207 E CLARENDON	PHOENIX	AZ	85012-2072	Jefferson	90324	BIRMINGHAM	005800	58	7827.4783	01073C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	231.9924	245.4960	237.2144	C	QM1	1.9300	BUSINESS	531130	LOT 26-B RESUR LOT 26 2ND SEC O…	110	64	SELF-STORAGE AT U-HAUL	SELF-STORAGE FACILITY	31
4000043000008001	0	01	073	2272 VANESSA DR	MEADOW BROOK	AL	35242	COBRO LLC WILD OAK HOMES LLC	708 HEATHERWOOD DR	BIRMINGHAM	AL	35244	Jefferson	90324	BIRMINGHAM	012907	129.0700	1354.6788	01073C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	174.5359	179.8843	177.8028	R	R1	0.3300	BUSINESS	5312	THAT PT OF LOT 18 ALTADENA WOOD…	151	25			23
2900094002005000	0	01	073	1225 15TH ST SW	BIRMINGHAM	AL	35211	SFR WORKFORCE OWNER 2 LLC	PO BOX 4900	SCOTTSDALE	AZ	85261	Jefferson	90324	BIRMINGHAM	005200	52	648.6926	01073C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	175.0034	176.5360	175.7369	R	R3	0.1600	BUSINESS	3151	LOT 118 BLK 7 CLEVELAND	1	19			32
1400114002003001	0	01	073	1312 MOUNT OLIVE RD	GARDENDALE	AL	35071	SERRA CAPITAL LLC	5331 SICARD HOLLOW RD	BIRMINGHAM	AL	35242	Jefferson	91296	GARDENDALE	011707	117.0700	7906.6375	01073C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	155.7257	172.9147	164.1511	R	R1	1.9500	BUSINESS	3333	BEG NW COR OF LOT 1 LOUISE HALL…	0	0			10
3000352017060000	0	01	073	6208 OWEN ST	MIDFIELD	AL	35228	GATEWAY PROPERTIES SOUTH LLC	4000 FALLISTON DR	HELENA	AL	35080	Jefferson	90324	BIRMINGHAM	013300	133	620.1475	01073C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	155.2632	156.0784	155.6681	R	R2	0.1500	BUSINESS	5312	LOT 1 BL 5 HUDSON GROVE	1205	98			65
3000132032013000	0	01	073	505 64TH ST	FAIRFIELD	AL	35064	KILIMNIK INVESTMENT CORP	72 GOLDEN ORCHARD RD	MAPLE	ON	L6A OM7	Jefferson	90324	BIRMINGHAM	010604	106.0400	627.0547	01073C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	174.1719	174.9851	174.6283	R	R3	0.1500	BUSINESS	2121	LOT 3 BL 15 FAIRFIELD VILLAGE 2…	1016	71			55
2400061008012000	0	01	073	612 ROEBUCK FOREST DR	BIRMINGHAM	AL	35206	AMNL ASSET CO 2 LLC	5001 PLAZA ON THE LAKE STE 200	AUSTIN	TX	78746	Jefferson	90324	BIRMINGHAM	005302	53.0200	940.5563	01073C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	249.2173	250.7759	249.9576	R	R2	0.2300	BUSINESS	3241	LOT 4 BLK 1 ROEBUCK FOREST	49	31			36
0900341000047000	0	01	073	6417 CHRISSY DR	PINSON	AL	35126	OMEGA REZ 5B LLC	3545 LORNA RIDGE DRIVE	HOOVER	AL	35216	Jefferson	90621	CLAY	011110	111.1000	1560.3902	01073C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	255.8859	260.4180	258.4920	R	R1	0.3900	BUSINESS	4855	LOT 8 COSBY HILLS AMENDED MAP 1…	115	52			46
1300284039006000	0	01	073	115 1ST ST	TARRANT	AL	35217	KNAPHEIDE BIRMINGHAM LLC	2490 PINSON VALLEY PKWY	BIRMINGHAM	AL	35217	Jefferson	90324	BIRMINGHAM	011901	119.0100	1471.6369	01073C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	173.6112	174.8995	174.3444	C	R6	0.3600	BUSINESS	23816	LOTS 9 THRU 12 BLK 2 PITTSBURG …	5	145			18
3800022001001003	5	01	073	5172 AVENUE K	BESSEMER	AL	35020	SMITH CORRETTI LLC	229 SHERIDAN LN	VESTAVIA	AL	35216-1323	Jefferson	90324	BIRMINGHAM	010302	103.0200	7338.7288	01073C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	165.0156	174.2829	169.1672	R	R1-I3	1.8100	BUSINESS	3391	POB 775 FT W OF NE COR OF NW4 S…	1000	0			56
3800271004008000	0	01	073	4004 HOPEWELL RD SE	BESSEMER	AL	35022	WILLIS V PROPERTIES LLC	3616 LAKESIDE DR	BIRMINGHAM	AL	35243	Jefferson	90324	BIRMINGHAM	014301	143.0100	2678.1554	01073C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	157.0174	159.2498	158.1700	R	R2	0.6600	BUSINESS	5312	COM NW COR OF SE4 OF NE4 SEC 27…	1000	0			52
0900274000040000	3	01	073	6675 MOUNTAIN RIDGE ST	PINSON	AL	35126	HADG-CLAY LLC	8100 SHADES CREEK PKWY STE 400	BIRMINGHAM	AL	35209	Jefferson	90621	CLAY	011110	111.1000	696.7011	01073C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	340.8238	352.3397	347.9323	R	R1	0.1700	BUSINESS	3343	LOT 101 MOUNTAIN RIDGE SUB PHAS…	227	59			46
2200334008003000	0	01	073	1109 8TH AVE W	BIRMINGHAM	AL	35204	NIRVANADESHAUN CAPITAL LLC	830 GLENWOOD AVE STE 510	ATLANTA	GA	30316	Jefferson	90324	BIRMINGHAM	003001	30.0100	673.5670	01073C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	190.0473	192.9462	191.8647	R	R4	0.1700	BUSINESS	1125	LOT 8 BLK 23 BUSH HILLS	13	87			31
2400302001002000	0	01	073	1112 GRANTS MILL RD JOINT	IRONDALE	AL	35210	IRONDALE TWO LLC	2105 OLD MONTGOMERY HIGHWAY	PELHAM	AL	35124	Jefferson	90324	BIRMINGHAM	010803	108.0300	1517.4289	01073C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	274.4316	286.1417	279.2565	C	C1	0.3700	BUSINESS	3212	BEG AT NW COR OF LOT 15 TH SELY…	916	17			13
2000180000018000	2	01	073	7755 POWHATAN RD	MULGA	AL	35118	BIRMINGPORT BAPTIST CHURCH INC	7735 POWHATAN RD	MULGA	AL	35118-9679	Jefferson	92124	MAYTOWN-SYLVAN SPRINGS	012302	123.0200	2050.8181	01073C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	119.5844	128.5403	125.9351	R	I	0.5100	NONPROFIT	8131	BEG INT N R W POWHATAN RD N LIN…	1000	0			50
2500193003057000	0	01	073	1038 CREST RD	LEEDS	AL	35094	PULLIAM JEREMY RYAN BRITNEY S	1038 CREST RD	LEEDS	AL	35094	Jefferson	91845	LEEDS	011004	110.0400	2080.5917	01073C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	267.4128	282.6936	277.3894	R	R1	0.5100	PERSON		LOT 9 CAHABA HILLS 6TH SECTOR 1…	152	38			15
2900074012023000	0	01	073	1788 51ST ST	BIRMINGHAM	AL	35208	BEVILLE HERBERT JR	1788 51ST STREET ENSLEY	BIRMINGHAM	AL	35208-5141	Jefferson	90324	BIRMINGHAM	003802	38.0200	649.9638	01073C	2026-01-23	X	0.2 PCT ANNUAL CHANCE FLOOD HAZ…	160.2522	160.6790	160.4947	R	R3	0.1600	PERSON		LOT 23 BLK 35 MARTINS ADD TO BH…	903	49			35
2300273010013000	0	01	073	1116 MONTCLAIR RD	BIRMINGHAM	AL	35213	HACKER DARLENE THOMAS	1116 MONTCLAIR RD	BIRMINGHAM	AL	35213	Jefferson	90324	BIRMINGHAM	002306	23.0600	708.6762	01073C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	236.5335	239.8147	238.2098	R	R3	0.1800	PERSON		LOT 7 BLK 3 CRESTVIEW HILLS 5TH…	41	56			32
2200172001001035	0	01	073	827 COCHISE TRL	FORESTDALE	AL	35214	SEALS LATONYA MCCURDY	827 COCHISE TRL	BIRMINGHAM	AL	35214	Jefferson	90324	BIRMINGHAM	012401	124.0100	1462.5321	01073C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	176.2470	180.4424	178.4472	R	R2	0.3600	PERSON		LOT 21 HOLIDAY HILLS 15TH SECTO…	110	55			02
1200071002015001	0	01	073	2752 WOOD DR NE	CENTER POINT	AL	35215	DAVIS ANGELA R	2752 WOOD DR NE	BIRMINGHAM	AL	35215	Jefferson	90324	BIRMINGHAM	011207	112.0700	3289.4054	01073C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	241.9971	258.8496	251.8225	R	R1	0.8100	PERSON		COM SE COR OF SW 1 4 OF NE 1 4 …	0	0			47
2800191002002312	0	01	073	171 OLD MONTGOMERY HWY B	VESTAVIA HILLS	AL	35216	DICKERSON JAMES J	171-B OLD MONTGOMERY HIGHWAY	BIRMINGHAM	AL	35216	Jefferson	90324	BIRMINGHAM	012914	129.1399	41501.6390	01073C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	246.9921	300.0983	271.1105	R	R4	10.2500	PERSON		UNIT 171-B BLDG 2 FOXCROFT COND…	126	40			12
3000362003021000	0	01	073	6702 AVENUE K	BESSEMER	AL	35020	WHITFIELD SHARON R S WITH DEED	23013 MCGEHEE DR	MCCALLA	AL	35111	Jefferson	90324	BIRMINGHAM	010500	105	650.3254	01073C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	167.1890	169.4406	168.0217	R	R1-I3	0.1600	PERSON		LOT 12 BL 6 CRESCENT HEIGHTS	1206	86			56