Saved query c0ed12b46f7a74c6

Data Explorer

Query the US Nationwide Parcel Dataset

$1.75 / 1,000 records$100 minimum

38/80

Live SQL

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

61,798 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	usecode	taxacres	ownertype	legaldesc	lrversion	taxdistrict
15-02-04-1-001-022-000	38523	01	069	116 7TH AVE	ASHFORD	AL	36312	WEEMS JIMMY & IRA	PO BOX 224	ASHFORD	AL	36312	HOUSTON	90900	DOTHAN	041902	419.0200	1496.7412	01069C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	111	0.3698	PERSON	0882 B 1	2026.2	04
09-05-16-2-000-004-016	14711	01	069	111 CHANTILLY PL	DOTHAN	AL	36303	UPTAIN CHARLES A & MELODY D	111 CHANTILLY PL	DOTHAN	AL	36303	HOUSTON	90900	DOTHAN	040204	402.0400	1757.1744	01069C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	9999	0	PERSON	1291 A 12	2026.2	03
09-07-25-3-004-008-001	21812	01	069	1214 S BELL ST	DOTHAN	AL	36301	SIZEMORE TONY GERALD & CATHY B	1214 S BELL ST	DOTHAN	AL	36301	HOUSTON	90900	DOTHAN	041100	411	1304.9238	01069C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	9999	0.3224	PERSON	0230 0002 1	2026.2	03
03-09-31-0-001-020-000	2759	01	069	107 KENSINGTON CT	DOTHAN	AL	36303	MINCEY JAMES M & NANCY NICOLE	107 KENSINGTON CT	DOTHAN	AL	36303	HOUSTON	90900	DOTHAN	041500	415	1587.5745	01069C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	111	0.3922	PERSON	1103 B 4	2026.2	03
10-08-28-4-000-004-056	61835	01	069	335 COTTON RIDGE LN	DOTHAN	AL	36301	SANCHEZ CARLOS RICARDO SEQUERA …	335 COTTON RIDGE LN	DOTHAN	AL	36301	HOUSTON	90900	DOTHAN	040900	409	1045.3047	01069C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	111	0.2582	PERSON	12-092 B 16	2026.2	03
04-08-33-0-005-029-000	3354	01	069	2613 TIMOTHY RD	DOTHAN	AL	36305	R & S PROPERTY INVESTMENTS LLC	1161 HONEYSUCKLE RD	DOTHAN	AL	36305	HOUSTON	90900	DOTHAN	040302	403.0200	1862.9016	01069C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	111	0	BUSINESS	0610 D 17	2026.2	03
09-08-34-2-000-010-018	58582	01	069	218 FOLSOM RD	DOTHAN	AL	36301	BRADY GENE & KARAN	218 FOLSOM RD	DOTHAN	AL	36301	HOUSTON	90900	DOTHAN	040801	408.0100	1816.4533	01069C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	913	0.4488	PERSON	14-017 B 24	2026.2	03
09-02-03-1-010-011-000	63124	01	069	118 MONTREAT CT	DOTHAN	AL	36303	HOLMES WILLIE	118 MONTREAT CT	DOTHAN	AL	36303	HOUSTON	90900	DOTHAN	040302	403.0200	580.7014	01069C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	913	0	PERSON	13-041 C 17	2026.2	03
09-07-26-2-008-016-000	22910	01	069	302 RIMSON RD	DOTHAN	AL	36301	WEST MAIN PROPERTIES INC	C O FORREST & FIELDS REAL ESTA …	DOTHAN	AL	36301	HOUSTON	90900	DOTHAN	040700	407	1094.9711	01069C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	9999	0.2705	BUSINESS	0315 E 2	2026.2	03
09-08-27-1-003-015-000	24383	01	069	1857 HARTFORD HWY	DOTHAN	AL	36305	SKIP LLC	134 LILAC LN	DOTHAN	AL	36305	HOUSTON	90900	DOTHAN	040700	407	1346.8043	01069C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	111	0	BUSINESS	0854 B 7	2026.2	03
10-09-31-4-001-016-072	33942	01	069	2310 BROOKWOOD DR	DOTHAN	AL	36303	INTEGRATED PROPERTIES LLC	1202 DARTMOUTH DR	DOTHAN	AL	36303	HOUSTON	90900	DOTHAN	040900	409	793.4425	01069C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	111	0.1960	BUSINESS	1041 C 6	2026.2	03
10-09-31-4-001-001-084	33843	01	069	2408 CREEKWOOD DR	DOTHAN	AL	36301	FRAZIER TERESA K & CHERIE PATRI…	2408 CREEKWOOD DR	DOTHAN	AL	36301	HOUSTON	90900	DOTHAN	040900	409	812.4482	01069C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	111	0.2007	PERSON	1041 D 5	2026.2	03
09-07-36-1-004-010-000	23546	01	069	703 OWENS ST	DOTHAN	AL	36301	KAPERAK BRITTANY	703 OWENS ST	DOTHAN	AL	36301	HOUSTON	90900	DOTHAN	041100	411	1324.3555	01069C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	111	0.3272	PERSON	0362 F 15	2026.2	03
09-04-19-0-019-012-000	12782	01	069	111 SPYGLASS RD	DOTHAN	AL	36305	LEOPOLD VERNON & JENNIFER	111 SPYGLASS RD	DOTHAN	AL	36305	HOUSTON	90900	DOTHAN	040206	402.0600	595.6507	01069C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	913	0	PERSON	1265 A 12	2026.2	03
11-08-33-2-003-005-000	35907	01	069	400 MARIE ST	ASHFORD	AL	36312	GOFF ADRIEN ELIZABETH	400 MARIE ST	ASHFORD	AL	36312	HOUSTON	90900	DOTHAN	041902	419.0200	1788.0872	01069C	2026-01-23	AE		111	0.4417	PERSON	0375 B 5	2026.2	04
10-07-26-2-000-012-000	30506	01	069	66 WICKER RD	COWARTS	AL	36321	GORDON SALLY MERLE & DAVID AARON	66 WICKER RD	COWARTS	AL	36321	HOUSTON	90900	DOTHAN	041901	419.0100	2069.0357	01069C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	111	0.5112	PERSON	0659 19	2026.2	21
16-08-28-0-000-023-000	41504	01	069	0 WILLIE VARNUM RD	DOTHAN	AL	36301	SHOWALTER CHARLES E	3271 WILLIE VARNUM RD	DOTHAN	AL	36301	HOUSTON	90747	COTTONWOOD	042000	420	9129.6078	01069C	2026-01-23	A		8330	0	PERSON	0848 5	2026.2	01
19-06-13-4-003-006-000	47506	01	069	0 DENVER ST	DOTHAN	AL	36303	JONES ROBERT L	607 WINDSOR CT	DOTHAN	AL	36303	HOUSTON	90747	COTTONWOOD	042000	420	2772.8031	01069C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	910	0	PERSON		2026.2	20
09-02-09-3-001-017-001	9334	01	069	1500 BURBANK ST	DOTHAN	AL	36303	SMITH KRISTIE LANE	1500 BURBANK ST	DOTHAN	AL	36303	HOUSTON	90900	DOTHAN	040204	402.0400	1812.8164	01069C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	111	0	PERSON		2026.2	03
10-08-33-4-000-003-010	31322	01	069	1201 MCCALLISTER RD	DOTHAN	AL	36301	HUGHES JAMES GREGORY & PATRICIA…	1201 MCCALLISTER RD	DOTHAN	AL	36301	HOUSTON	90900	DOTHAN	040900	409	3140.2038	01069C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	111	0.7758	PERSON		2026.2	03
21-02-03-0-000-010-000	48953	01	069	0 SUMLAR FARM RD	ASHFORD	AL	36312	LURIE DOUGLAS N	206 THORNBERRY PL	ASHFORD	AL	36312	HOUSTON	91368	GORDON	041800	418	321785.8769	01069C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	0	0	PERSON		2026.2	01
15-01-01-0-000-001-018	69756	01	069	3133 PANSEY RD	ASHFORD	AL	36312	WATSON TYLER & KIMBERLY CAROL	3133 PANSEY RD	ASHFORD	AL	36312	HOUSTON	90900	DOTHAN	041902	419.0200	20673.4356	01069C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	812	5.1083	PERSON		2026.2	01
17-02-09-0-000-010-000	42744	01	069	730 NATIONAL RD	DOTHAN	AL	36301	MIXON ANITA ANN & PEGGY JEAN LA…	50 FULLER RD	DOTHAN	AL	36301	HOUSTON	90900	DOTHAN	040802	408.0200	308699.3002	01069C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	0	76.2767	PERSON		2026.2	03
16-06-23-0-000-005-005	68077	01	069	0 FOWLER RD	ASHFORD	AL	36312	PARAMORE MARTHA J (LIFE EST)	1908 FOWLER RD	ASHFORD	AL	36312	HOUSTON	90747	COTTONWOOD	042000	420	123896.3192	01069C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	9999	30	PERSON		2026.2	01
14-02-03-0-000-001-000	37246	01	069	0 N CO ROAD 95	DOTHAN	AL	36303	MCLAUGHLIN PROPERTIES LLC	1008 BROOKSTONE CT	DOTHAN	AL	36303	HOUSTON	91368	GORDON	041800	418	244107.0429	01069C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	9999	60.3212	BUSINESS		2026.2	01