Saved query 39d81cb85321f0ad

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 = '097'

225,063 matching parcels

Data Preview

parcelid	statefp	countyfp	parceladdr	parcelcity	parcelstate	parcelzip	ownername	owneraddr	ownercity	ownerstate	ownerzip	countyname	cousubfp	cousubname	tractce	tractname	calcarea	numbldgs	firmid	firmdate	fldzone	zonesubty	staticbfe	elevmin	elevmax	elevavg	ownertype	naicscode	parceltype	accesstype	iucnclass	placename	placetype
2808273000032XXX	01	097	462 Hearth Dr	MOBILE	AL	36609	MALLORY STERLING T	462 Hearth Dr	MOBILE	AL	36609-3209	Mobile	93105	Tanner Williams	003704	37.0400	1256.5222	1	01097C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD		37.6675	40.2150	39.2278	PERSON	7121	GOVT FEDERAL	RESTRICTED	V	PAPAHANAUMOKUAKEA MARINE NATION…	NATIONAL MONUMENT
240203000007008X	01	097	9828 Raintree Ct 8 #	SEMMES	AL	36575	DOROUGH JOHN W JR & BRENDA G	9828 Raintree Ct 8 #	SEMMES	AL	36575-8920	Mobile	92889	Semmes	006305	63.0500	3458.5903	1	01097C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD		71.9187	75.9356	73.9249	PERSON	7121	GOVT FEDERAL	RESTRICTED	V	PAPAHANAUMOKUAKEA MARINE NATION…	NATIONAL MONUMENT
2906400004665XXX	01	097	1114 Spring Hill Ave	MOBILE	AL	36604	NGUYEN NHAM, ANH NGUYEN & KHUYE…	6924 Providence Estates Dr	MOBILE	AL	36695	Mobile	92187	Mobile	000401	4.0100	856.1800	1	01097C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD		5.1713	6.0163	5.5485	PERSON	811192	GOVT FEDERAL	RESTRICTED	V	THE HAND CAR WASH AND DETAIL	AUTOMOTIVE_SERVICE
3308283002021XXX	01	097	5503 Quail Run	THEODORE	AL	36582	PARTON SERENA L	7180 Pierson Dr	MOBILE	AL	36619-1246	Mobile	92187	Mobile	006902	69.0200	1081.2473	1	01097C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD		30.4769	31.0833	30.7990	PERSON	7121	GOVT FEDERAL	RESTRICTED	V	PAPAHANAUMOKUAKEA MARINE NATION…	NATIONAL MONUMENT
3303084000001330	01	097	3333 Austin Dr	MOBILE	AL	36695	WEBB RONALD D & JUDITH P WEBB	3333 Austin Dr	MOBILE	AL	36695-3221	Mobile	92187	Mobile	003708	37.0800	904.6311	1	01097C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD		12.4608	14.9501	13.7290	PERSON	7121	GOVT FEDERAL	RESTRICTED	V	PAPAHANAUMOKUAKEA MARINE NATION…	NATIONAL MONUMENT
2808381001075XXX	01	097	411 Saint John Pl	MOBILE	AL	36609	COLLINS MARGARET GALLOWAY & RON…	411 Saint John Pl	MOBILE	AL	36609	Mobile	93105	Tanner Williams	003203	32.0300	1757.1899	1	01097C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD		34.6201	39.0037	36.5859	PERSON	7121	GOVT FEDERAL	RESTRICTED	V	PAPAHANAUMOKUAKEA MARINE NATION…	NATIONAL MONUMENT
2906400008098XXX	01	097	1306 Chamberlain Ave	MOBILE	AL	36604	MCKENNA ROBERT P & MELISSA MCKE…	1306 Chamberlain Ave	MOBILE	AL	36604-2219	Mobile	92187	Mobile	000901	9.0100	505.0023	1	01097C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD		9.0034	9.5464	9.2500	PERSON	7121	GOVT FEDERAL	RESTRICTED	V	PAPAHANAUMOKUAKEA MARINE NATION…	NATIONAL MONUMENT
3301021000055XXX	01	097	3965 Byronell Dr	MOBILE	AL	36693	STUBBLEFIELD WILLIAM G & JANET …	3965 Byronell Dr	MOBILE	AL	36693-5504	Mobile	92187	Mobile	003100	31	2813.2341	1	01097C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD		42.4152	45.7477	44.0008	PERSON	7121	GOVT FEDERAL	RESTRICTED	V	PAPAHANAUMOKUAKEA MARINE NATION…	NATIONAL MONUMENT
3001000007001XXX	01	097	2703 Battleship Pkwy	MOBILE	AL	36602	ALABAMA STATE OF	64 N Union St	MONTGOMERY	AL	36130-3020	Mobile	92187	Mobile	001200	12	195460.2199	1	01097C	2026-01-23	VE		13	-0.9174	3.5222	1.5130	GOVERNMENT	4871	GOVT FEDERAL	RESTRICTED	V	ALABAMA BATTLESHIP COMMISSION	TRAVEL_SERVICE
2906400005012XXX	01	097	1220 Martin Luther King	MOBILE	AL	36603	LAFFITTE TYLER LAVON JR	5317 Forest Oaks Dr	MOBILE	AL	36618-2415	Mobile	92187	Mobile	000401	4.0100	363.2482	1	01097C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD		7.7414	8.6269	8.1190	PERSON	7121	GOVT FEDERAL	RESTRICTED	V	PAPAHANAUMOKUAKEA MARINE NATION…	NATIONAL MONUMENT
3401013000086XXX	01	097	8490 Placid Dr	MOBILE	AL	36695	NELSON PAUL A & LESLIE A	8490 Placid Dr	MOBILE	AL	36695-3663	Mobile	92187	Mobile	006804	68.0400	2709.4760	1	01097C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD		40.7383	47.6969	45.4651	PERSON	7121	GOVT FEDERAL	RESTRICTED	V	PAPAHANAUMOKUAKEA MARINE NATION…	NATIONAL MONUMENT
2907420004015XXX	01	097	2048 Clement St	MOBILE	AL	36617	FORTUNE FLORETTA P C/O YOLANDA …	2050 Clement St	MOBILE	AL	36617-3106	Mobile	92187	Mobile	000802	8.0200	565.8601	1	01097C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD		8.8512	9.3327	9.0645	BUSINESS	712120	GOVT FEDERAL	RESTRICTED	V	PAPAHANAUMOKUAKEA MARINE NATION…	NATIONAL MONUMENT
390301000201501X	01	097	6900 Dauphin Island Pkwy	MOBILE	AL	36605	CMR INVESTMENTS LLC	1274 Savannah Dr	MOBILE	AL	36609	Mobile	93114	Theodore	007000	70	6885.7658	3	01097C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD		2.4545	5.5421	4.0779	BUSINESS	712190	GOVT FEDERAL	RESTRICTED	V	PAPAHANAUMOKUAKEA MARINE NATION…	NATIONAL MONUMENT
2707252000002XXX	01	097	8150 Westminster Dr	MOBILE	AL	36695	DONNEE ROBERT E & NORMA K	8150 Westminster Dr	MOBILE	AL	36695-9154	Mobile	93105	Tanner Williams	006409	64.0900	3224.9503	1	01097C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD		62.9983	63.6062	63.3729	PERSON	7121	GOVT FEDERAL	RESTRICTED	V	PAPAHANAUMOKUAKEA MARINE NATION…	NATIONAL MONUMENT
2210440009507XXX	01	097	116 Gatti Ave	PRICHARD	AL	36610	RUGGS ESSIE MAE	116 Gatti Ave	PRICHARD	AL	36610-2134	Mobile	92187	Mobile	004800	48	439.7767	1	01097C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD		10.4762	10.9912	10.7007	PERSON	7121	GOVT FEDERAL	RESTRICTED	V	PAPAHANAUMOKUAKEA MARINE NATION…	NATIONAL MONUMENT
2809324000076XXX	01	097	2017 Cathedral Way	MOBILE	AL	36695	PHILLIPS WALTER & MARY ANN PHIL…	2017 Cathedral Way	MOBILE	AL	36695-3820	Mobile	93105	Tanner Williams	003705	37.0500	1360.4058	1	01097C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD		52.5488	55.2128	53.9337	PERSON	7121	GOVT FEDERAL	RESTRICTED	V	PAPAHANAUMOKUAKEA MARINE NATION…	NATIONAL MONUMENT
3302091000055030	01	097	2900 Blue Ridge Dr	MOBILE	AL	36693	BYRD CYNTHIA D	2900 Blue Ridge Dr	MOBILE	AL	36693-3301	Mobile	92187	Mobile	003712	37.1200	1240.9385	1	01097C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD		48.2147	50.2404	49.4052	PERSON	7121	GOVT FEDERAL	RESTRICTED	V	PAPAHANAUMOKUAKEA MARINE NATION…	NATIONAL MONUMENT
3305380003028XXX	01	097	4051 Oak Ridge Ave	MOBILE	AL	36619	SCHMIDT RUTH MARIE	4051 Oak Ridge Ave	MOBILE	AL	36619-1802	Mobile	92187	Mobile	006802	68.0200	1912.4742	1	01097C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD		28.5565	30.1606	29.2876	PERSON	7121	GOVT FEDERAL	RESTRICTED	V	PAPAHANAUMOKUAKEA MARINE NATION…	NATIONAL MONUMENT
2202032000090XXX	01	097	Street	SARALAND	AL	36571	CLANCY JUSTIN MANCLE	8531 Lister Dairy Rd	CREOLA	AL	36525-4908	Mobile	92187	Mobile	005500	55	6677.7024	1	01097C	2026-01-23	X	0.2 PCT ANNUAL CHANCE FLOOD HAZ…		4.0331	5.3795	4.6011	PERSON	7121	GOVT FEDERAL	RESTRICTED	V	PAPAHANAUMOKUAKEA MARINE NATION…	NATIONAL MONUMENT
3309304000045XXX	01	097	7140 Westchester Dr	MOBILE	AL	36619	HERRIN JOHN	7140 Westchester Dr	MOBILE	AL	36619	Mobile	93114	Theodore	006904	69.0400	1512.5192	2	01097C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD		40.6222	41.9331	41.0852	PERSON	7121	GOVT FEDERAL	RESTRICTED	V	PAPAHANAUMOKUAKEA MARINE NATION…	NATIONAL MONUMENT
2707251000002XXX	01	097	880 Schillinger Rd	MOBILE	AL	36695	GCR PROPERTIES LLC	5805 Highway 90	THEODORE	AL	36582-1609	Mobile	93105	Tanner Williams	006409	64.0900	6379.5553	1	01097C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD		50.2555	57.4090	55.1188	BUSINESS	722511	GOVT FEDERAL	RESTRICTED	V	SAM MIGUEL.	RESTAURANT
2806141003027XXX	01	097	27 Lancaster Rd	MOBILE	AL	36608	RAYFORD CATHARINE SOOST	27 Lancaster Rd	MOBILE	AL	36608-1903	Mobile	92187	Mobile	003501	35.0100	783.4624	1	01097C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD		56.2550	58.6284	57.5617	PERSON	7121	GOVT FEDERAL	RESTRICTED	V	PAPAHANAUMOKUAKEA MARINE NATION…	NATIONAL MONUMENT
2806372001061XXX	01	097	143 Myrtlewood Ln	MOBILE	AL	36608	DEMPSEY TODD CULLEN & KATHERINE…	143 Myrtlewood Ln	MOBILE	AL	36608	Mobile	92187	Mobile	003302	33.0200	2728.4848	1	01097C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD		34.1246	39.9565	37.0090	PERSON	7121	GOVT FEDERAL	RESTRICTED	V	PAPAHANAUMOKUAKEA MARINE NATION…	NATIONAL MONUMENT
2907230003108XXX	01	097	2714 Spring Hill Ave	MOBILE	AL	36607	CUMMINGS MARL M III,	16227 PO Box	MOBILE	AL	36616-0227	Mobile	92187	Mobile	002600	26	866.8377	1	01097C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD		9.6074	10.3489	10.0390	PERSON	7121	GOVT FEDERAL	RESTRICTED	V	PAPAHANAUMOKUAKEA MARINE NATION…	NATIONAL MONUMENT
3303054002051XXX	01	097	6588 Old Dobbin Dr	MOBILE	AL	36695	CRENSHAW JONTE & JAKYRA HUNTER	6588 Old Dobbin Dr	MOBILE	AL	36695-3742	Mobile	92187	Mobile	003708	37.0800	1220.6382	1	01097C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD		36.3262	40.1688	38.3486	PERSON	7121	GOVT FEDERAL	RESTRICTED	V	PAPAHANAUMOKUAKEA MARINE NATION…	NATIONAL MONUMENT