Saved query 8db1b0332427eb58

Data Explorer

Query the US Nationwide Parcel Dataset

$1.75 / 1,000 records$100 minimum

43/80

Live SQL

SELECT * 
FROM "lr_parcel_us" 
WHERE statefp = '45' 
  AND countyfp = '003'

102,595 matching parcels

Data Preview

parcelid	statefp	countyfp	parceladdr	parcelcity	parcelstate	parcelzip	ownername	owneraddr	ownercity	ownerstate	ownerzip	countyname	cousubfp	cousubname	tractce	tractname	calcarea	saledate	firmid	firmdate	fldzone	zonesubty	elevmin	elevmax	elevavg	usedesc	taxacres	ownertype	naicscode	legaldesc	book	page	placename	placetype	lrversion	taxdistrict
138-05-06-007	45	003	24 COMMERCE CT	AIKEN	SC	29803	MONTY BATES	PO BOX 243	AIKEN	SC	29802	AIKEN	90026	AIKEN	021603	216.0300	2677.9037	2015-10-26	45003C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	147.7760	149.6634	149.1152	COMMERCIAL	0.6600	PERSON	6216	LT 16A BANKS MILL BUSINESS PARK	58	886	MONTY BATES SIDING	HOME_SERVICE	2026.2	UNINCORPORATED
054-00-06-015	45	003	5191 GLASTONBURY CT	BEECH ISLAND	SC	29842	RANDY WILKERSON	5191 GLASTONBURY	BEECH ISLAND	SC	29842	AIKEN	90208	BEECH ISLAND	020903	209.0300	2994.7676	2014-06-06	45003C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	66.3812	69.5693	67.6152	OWNER OCCUPIED RESIDENTIAL	1	PERSON	6216	THE RETREAT STORM BRANCH LOT 25…	54	475-1	KICKIN GLASS ART, LLC	HOME_SERVICE	2026.2	NORTH AUGUSTA
290-18-05-006	45	003	107 JERUSALEM BRANCH RD	SALLEY	SC	29137	KEN SMOAK	7232 EDMUND	PELION	SC	29123	AIKEN	92977	SALLEY	021800	218	276806.3383	2020-08-18	45003C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	104.7688	122.7591	115.5305	AGRICULTURAL	68.5100	PERSON		S HWY14	56	47			2026.2	WAGENER
162-00-06-011	45	003	570 MT PLEASANT RD	MONETTA	SC	29105	NEIL EULIANO	570 MT PLEASANT	MONETTA	SC	29105	AIKEN	92223	MONETTA	020100	201	292355.7077	2016-11-04	45003C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	128.6789	155.3280	141.2414	DISABLED VETERAN	72.1800	PERSON		TRACT C-1 C-2 AT THE INTERSECTI…	58	823			2026.2	MONETTA
202-00-02-040	45	003	95 POPLAR BRANCH RD	AIKEN	SC	29805	THE TIMOTHY HUTTO LIVING TRUST	PO BOX 422	WAGENER	SC	29164	AIKEN	92223	MONETTA	020100	201	95225.7792	2025-03-05	45003C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	91.2056	104.0275	95.4352	AGRICULTURAL	23.3500	TRUST		E/SD OF POPLAR BRANCH RD PARCEL…	57	58			2026.2	WAGENER
135-13-01-001	45	003	1754 COLUMBIA HWY N	AIKEN	SC	29801	CITY OF AIKEN	PO BOX 1177	AIKEN	SC	29802	AIKEN	90026	AIKEN	021601	216.0100	121360.2089	2020-08-28	45003C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	96.1592	115.4096	104.6153	GOVERNMENT	28.7100	GOVERNMENT		N BY SHAWS CREEK HWY 1	M145	216			2026.2	UNINCORPORATED
091-08-05-002	45	003	146 ANDERSON POND RD	AIKEN	SC	29803	WYMAN SEIGLER	146 ANDERSON POND	AIKEN	SC	29803	AIKEN	92379	NEW ELLENTON	022003	220.0300	3947.1624		45003C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	133.4443	137.5552	135.7440	OWNER OCCUPIED RESIDENTIAL	1	PERSON	6216	S/SD OF ANDERSON POND RD	46	128	AIKEN WELL DRILLING	HOME_SERVICE	2026.2	UNINCORPORATED
129-00-10-038	45	003	LIGONS RD	RIDGE SPRING	SC	29129	CULPEPER CAPITAL LLC	PO BOX 90	NORTH GARDEN	VA	22959	AIKEN	92223	MONETTA	020100	201	793708.3495	2023-06-27	45003C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	121.1065	171.9949	150.0145	AGRICULTURAL	195.5000	BUSINESS		TRACT ON EASTER BRANCH	40	29			2026.2	MONETTA
202-00-02-032	45	003	WILDERNESS RD	AIKEN	SC	29805	DENNIS CONRAD	40 RAVENWOOD	AIKEN	SC	29803	AIKEN	92223	MONETTA	020100	201	94692.0570	2010-03-03	45003C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	90.8277	129.6743	110.6521	AGRICULTURAL	23.0200	PERSON		TR-1 EW/SD OF WILDERNESS RD	39	137			2026.2	MONETTA
205-00-06-010	45	003	9229 TWIFFY LN	AIKEN	SC	29805	JOSEPH TILLMAN AND JANE PHILLIP…	9229 TWIFFY	AIKEN	SC	29805	AIKEN	90028	AIKEN NORTHEAST	020200	202	144148.8474	2019-02-28	45003C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	79.0294	95.1698	83.3384	AGRICULTURAL	35.2100	TRUST		S OF STATE HWY 302	54	127			2026.2	UNINCORPORATED
221-00-09-003	45	003	HIDEAWAY LN	WAGENER	SC	29164	HARVE MOBLEY	1009 BLACKHEATH	AIKEN	SC	29803	AIKEN	93562	WAGENER	021700	217	43802.1215		45003C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	85.1343	106.6625	97.4390	NON-OWNER OCCUPIED RESIDENTIAL	10.8200	PERSON		TRACT D WEXFORD MILL INC	43	294-1			2026.2	UNINCORPORATED
036-18-08-001	45	003	JEFFERSON DAVIS HWY	WARRENVILLE	SC	29851	LOMBARD CORP	PO BOX 1119	ALLENDALE	SC	29810	AIKEN	92418	NORTH AUGUSTA	021001	210.0100	232618.3146		45003C	2026-01-08	AE	FLOODWAY	41.1521	50.0080	43.2809	CORPORATE AGRICULTURAL	60.8700	BUSINESS		S OF HWY 1 78	34	187			2026.2	LANG BATH CLEAR
046-00-04-003	45	003	185 KATIE LN	TRENTON	SC	29847	ANDREW LEE ESTATE	1016 NORTH BROOK	AIKEN	SC	29805	AIKEN	90026	AIKEN	020301	203.0100	306381.5690		45003C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	106.3061	168.1042	133.5228	AGRICULTURAL	70	ESTATE		W OF SOUTHERN RWY	74	340			2026.2	GREGG
075-08-05-004	45	003	CHAVOUS RD	AIKEN	SC	29803	GLOVER DOROTHY D HELEN D HARRIS	4097 NORTH SILVERTON	AIKEN	SC	29803	AIKEN	92379	NEW ELLENTON	022004	220.0400	155548.2285		45003C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	48.1877	86.8955	61.7728	AGRICULTURAL	40	PERSON		TRACT 7 HENRY JOHNSON EST	M70	168			2026.2	UNINCORPORATED
285-00-03-011	45	003	DEAN SWAMP CHURCH RD	SPRINGFIELD	SC	29146	RONALD HALL	PO BOX 445	SALLEY	SC	29137	AIKEN	92977	SALLEY	021800	218	125120.0178		45003C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	72.5874	86.9662	80.2844	AGRICULTURAL	30.7000	PERSON		E/SD OF VETERANS RD	45	156			2026.2	SALLEY
218-00-08-015	45	003	73 SANDY TRL	WAGENER	SC	29164	JEANA KUNZ	96 SANDY	WAGENER	SC	29164	AIKEN	93562	WAGENER	021700	217	3298.1924	2017-11-17	45003C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	149.0348	150.4075	149.6351	NON-OWNER OCCUPIED RESIDENTIAL	0.8100	PERSON		PARCEL B W OF ANDERSON RD	49	64-2			2026.2	WAGENER
074-20-09-001	45	003	3007 SILVER BLUFF RD	AIKEN	SC	29803	KAREN SIMON	3007 SILVER BLUFF	AIKEN	SC	29803	AIKEN	92379	NEW ELLENTON	022004	220.0400	41775.1637	2018-01-08	45003C	2026-01-08	X	0.2 PCT ANNUAL CHANCE FLOOD HAZ…	50.8159	65.0398	55.9179	AGRICULTURAL	10.7800	PERSON		ON HWY 28 32 TRACT D-3 D-4	56	469			2026.2	UNINCORPORATED
202-00-02-041	45	003	301 WILDERNESS RD	AIKEN	SC	29805	THE KEVIN MICHAEL AND CHARLOTTE…	301 WILDERNESS	AIKEN	SC	29805	AIKEN	92223	MONETTA	020100	201	109553.6753	2025-12-11	45003C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	90.2169	122.8295	103.7161	AGRICULTURAL	27.4800	TRUST		E/SD OF WILDERNESS RD	55	898			2026.2	MONETTA
088-13-09-005	45	003	321 WANDO RIDGE RD	AIKEN	SC	29801	LEE HILTON	321 WANDO RIDGE	AIKEN	SC	29801	AIKEN	90026	AIKEN	021201	212.0100	910.6475	2022-03-24	45003C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	95.5012	97.2982	96.9261	OWNER OCCUPIED RESIDENTIAL	1	PERSON		HITCHCOCK CROSSING LOT B-4 SECT…	62	318-320			2026.2	GREGG
107-09-16-001	45	003	311 PASCALIS PL	AIKEN	SC	29803	WILLIAM THEISS	311 PASCALIS	AIKEN	SC	29803	AIKEN	90026	AIKEN	021201	212.0100	704.1246	2023-09-25	45003C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	141.7453	143.9109	143.2010	OWNER OCCUPIED RESIDENTIAL	1	PERSON		COLLETON PARK LOT 57 SECTION 1	54	708			2026.2	CITY OF AIKEN
285-00-03-013	45	003	DEAN SWAMP CHURCH RD	SALLEY	SC	29137	JUDY HALL	PO BOX 482	SALLEY	SC	29137	AIKEN	92977	SALLEY	021800	218	114988.1524	2022-02-09	45003C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	72.8159	87.0164	78.9779	AGRICULTURAL	28.6700	PERSON		E/SD OF DEAN SWAMP CHURCH RD TR…	59	429			2026.2	SALLEY
196-00-14-003	45	003	703 MT EBAL RD	BATESBURG	SC	29006	CHARLES LOVELL	703 MT EBAL	BATESBURG	SC	29006	AIKEN	92223	MONETTA	020100	201	54753.9502	2005-12-27	45003C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	117.0156	132.7796	124.1540	AGRICULTURAL	14.1600	PERSON		N/D MOUNT EBAL RD HWY 134	50	757			2026.2	MONETTA
274-00-09-035	45	003	156 ERNEST JOHNSON RD	WAGENER	SC	29164	THOMAS TYLER	1018 MILLERS POND	WAGENER	SC	29164	AIKEN	92977	SALLEY	021800	218	307774.4373	2016-03-18	45003C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	86.0413	120.8290	106.9355	AGRICULTURAL	76.1700	PERSON		TRACTS B THUR E N/SD OF EMEST J…	56	30			2026.2	WAGENER
214-00-03-025	45	003	769 HOLDER RD	BATESBURG	SC	29006	JAMES WATKINS IV	767 HOLDER	BATESBURG	SC	29006	AIKEN	92223	MONETTA	020100	201	106190.3573	2007-09-13	45003C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	116.1839	143.1535	132.3525	NON-OWNER OCCUPIED RESIDENTIAL	26.2300	PERSON		LOT B E/SD OF HUCKLEBERRY FIN RD	50	761			2026.2	MONETTA
165-00-12-003	45	003	HUTTO POND RD	AIKEN	SC	29805	SAMMY GARDNER	144 HUTTO POND	AIKEN	SC	29805	AIKEN	92223	MONETTA	020100	201	7489.4194	2015-12-21	45003C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	126.9238	133.0452	128.9678	NON-OWNER OCCUPIED RESIDENTIAL	1.8500	PERSON		JOHN HENRY EST MATTIE LOWE EST …	57	601			2026.2	MONETTA