Saved query 5b6b427bacbd7ce3

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 = '18' 
  AND countyfp = '093'

32,360 matching parcels

Data Preview

parcelid	statefp	countyfp	parceladdr	parcelcity	parcelstate	parcelzip	countyname	cousubfp	cousubname	tractce	tractname	calcarea	numbldgs	firmid	firmdate	fldzone	zonesubty	elevmin	elevmax	elevavg	usecode	naicscode	placename	placetype	taxdistrict
47-06-22-121-002 000-010	18	093	2600 Smile Ln	Bedford	IN	47421	Lawrence	69102	Shawswick	950800	9508	1237.4350	1	18093C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	201.9602	203.9327	202.9826	447	458	B FANCY BOUTIQUE AND SALON	FASHION_AND_APPAREL_STORE	47010
47-14-12-100-059 000-004	18	093	494 Boone Ln	Mitchell	IN	47446	Lawrence	46980	Marion	951201	9512.0100	7443.9999	1	18093C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	209.2766	216.2539	212.7205	511	54143	FLEENOR'S GRAPHICS	DESIGN_SERVICE	47004
47-03-07-410-005 000-006	18	093	35 Patton Hts	Bedford	IN	47421	Lawrence	47304	Marshall	950602	9506.0200	5757.3221	1	18093C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	213.5962	222.8369	218.9720	510	7225	HOOVER'S CANDY SHOP	CASUAL_EATERY	47006
47-11-35-441-003 000-005	18	093	1120 Maple St	Mitchell	IN	47446	Lawrence	46980	Marion	951300	9513	929.0196	1	18093C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	209.8053	210.1836	210.0301	510				47005
47-02-23-100-035 000-008	18	093	917 Roberts Ln	Heltonville	IN	47436	Lawrence	60624	Pleasant Run	950500	9505	25879.3892	1	18093C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	220.9842	231.6887	226.0389	101				47008
47-06-23-104-005 000-010	18	093	2020 I St	Bedford	IN	47421	Lawrence	69102	Shawswick	951100	9511	1036.3590	1	18093C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	203.7534	208.8520	206.2610	510				47010
47-03-05-100-068 000-006	18	093	628 N Helton Rd	Springville	IN	47462	Lawrence	47304	Marshall	950602	9506.0200	5993.7699	1	18093C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	201.0461	208.0798	205.2484	511				47006
47-10-32-600-045 000-004	18	093	169 Sams Rd	Mitchell	IN	47446	Lawrence	46980	Marion	951201	9512.0100	19108.3369	1	18093C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	199.1394	208.0004	204.7930	101				47004
47-12-08-100-023 000-012	18	093	St Rd 450	Bedford	IN	47470	Lawrence	72044	Spice Valley	950702	9507.0200	28457.1313	1	18093C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	154.2355	164.5383	161.0276	104				47012
47-06-15-111-048 000-010	18	093	522 U St	Bedford	IN	47421	Lawrence	69102	Shawswick	951000	9510	1025.7176	1	18093C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	214.1121	216.5589	215.2501	510				47010
47-07-31-200-030 000-009	18	093	1011 Vinegar Hill Rd	Bedford	IN	47421	Lawrence	69102	Shawswick	951201	9512.0100	4229.9734	2	18093C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	206.0258	209.7247	207.9726	591				47009
47-06-24-141-013 000-010	18	093	422 Sycamore Dr	Bedford	IN	47421	Lawrence	69102	Shawswick	951000	9510	2641.7498	1	18093C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	155.9224	163.2147	159.8184	510				47010
47-11-35-100-069 000-005	18	093	126 Hel Mar Dr	Mitchell	IN	47446	Lawrence	46980	Marion	951202	9512.0200	743.2971	1	18093C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	208.5320	209.2423	208.9532	510				47005
47-13-15-300-015 000-013	18	093	446 Winegar Rd	Mitchell	IN	47446	Lawrence	72044	Spice Valley	950702	9507.0200	7308.6087	2	18093C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	214.7807	233.5814	223.0102	511				47013
47-16-18-700-008 000-001	18	093	6770 Suddarth Ln	Mitchell	IN	47452	Lawrence	06436	Bono	951201	9512.0100	286560.8453	2	18093C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	213.7054	232.9404	224.8140	104				47001
47-06-14-314-031 000-010	18	093	1202 N St	Bedford	IN	47421	Lawrence	69102	Shawswick	950900	9509	564.9201	1	18093C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	213.3136	213.8126	213.5486	510				47010
47-05-19-100-016 000-003	18	093	791 St Rd 158	Williams	IN	47470	Lawrence	36054	Indian Creek	950702	9507.0200	41890.3893	2	18093C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	160.1938	209.0973	180.8768	101				47003
47-06-24-121-009 000-010	18	093	1737 Valley View Drive	Bedford	IN	47421	Lawrence	69102	Shawswick	951100	9511	4497.6767	1	18093C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	175.3531	188.9608	182.5989	510				47010
47-07-25-440-018 000-009	18	093	Dawn Court	Bedford	IN	47421	Lawrence	69102	Shawswick	950400	9504	3290.9156	1	18093C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	223.5786	228.5190	225.9314	500				47009
47-03-02-400-023 000-006	18	093	113 Hardin Ridge Rd	Bedford	IN	47421	Lawrence	47304	Marshall	950500	9505	80699.9712	1	18093C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	170.0616	208.4334	196.1174	101				47006
47-15-09-400-009 000-004	18	093	1075 Noe Rd	Orleans	IN	47452	Lawrence	46980	Marion	951201	9512.0100	4142.1829	1	18093C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	218.5341	224.8333	222.6550	511				47004
47-07-33-300-018 000-009	18	093	2952 Vinegar Hill Rd	Bedford	IN	47421	Lawrence	69102	Shawswick	951201	9512.0100	41496.9628	1	18093C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	165.0718	207.3240	193.9715	101				47009
47-06-23-113-059 000-010	18	093	707 17th St	Bedford	IN	47421	Lawrence	69102	Shawswick	951000	9510	728.7425	1	18093C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	211.2322	214.2326	212.5342	510				47010
47-04-09-200-008 000-007	18	093	2812 Popcorn Church Rd	Springville	IN	47462	Lawrence	59040	Perry	950601	9506.0100	38124.6816	1	18093C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	196.4836	202.2481	199.3814	101				47007
47-06-27-401-021 000-010	18	093	2211 36th Street	Bedford	IN	47421	Lawrence	69102	Shawswick	950800	9508	1442.0780	1	18093C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	196.9303	199.7845	198.4860	511				47010