Saved query 23a586330a11f942

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 = '29' 
  AND countyfp = '107'

22,959 matching parcels

Data Preview

parcelid	taxacctnum	statefp	countyfp	parceladdr	parcelcity	parcelstate	parcelzip	ownername	owneraddr	ownercity	ownerstate	ownerzip	countyname	cousubfp	cousubname	tractce	tractname	calcarea	numbldgs	numunits	yearbuilt	firmid	firmdate	fldzone	zonesubty	elevmin	elevmax	elevavg	taxacres	ownertype	naicscode	legaldesc	parceltype	accesstype	iucnclass	placename	placetype	taxdistrict
14-7 0-36-4-002-059 000	1470364002059000	29	107	N CONNOR	ODESSA	MO	64076-0000	KOLKMEYER GLEN LISA DEERVIEW PR…	DEERVIEW PROPERTIES LLC	BATES CITY	MO	64011-9789	Lafayette	14428	Clay	090601	906.0100	1127.7607	1	1	1984	29107C	2025-12-25	X	AREA OF MINIMAL FLOOD HAZARD	279.9611	282.1996	281.2982	0.2786	BUSINESS	6215	PT LOT 16 BLK 1 CITIZENS SUBD 6…						ODR7-ODRD-ODFD-CLIB-ODES-ODRB-O…
19-2 0-04-2-001-011 000	1920042001011000	29	107	S MAIN	CONCORDIA	MO	64020-0000	BKR PROPERTIES LLC		SCOTTSDALE	AZ	85262-0000	Lafayette	25858	Freedom	090500	905	905.7927	1	1	2023	29107C	2025-12-25	X	AREA OF MINIMAL FLOOD HAZARD	239.2974	241.0641	240.2914	0.2238	BUSINESS	5312	PT LOT 8 ALL LOT 9 BLK C MARTIN…						CNR2-CNRD-CNFD-CLIB-CONC-CNAM
05-9 0-29-2-001-044 000	0590292001044000	29	107	WATER ST	DOVER	MO	64022-0000	RASA FARMS INC		LEXINGTON	MO	64067-0000	Lafayette	19936	Dover	090200	902	3034.1290	1	1	1968	29107C	2025-12-25	X	AREA OF MINIMAL FLOOD HAZARD	246.1886	249.2774	248.1788	0.7497	BUSINESS	1122	LOTS 9 10 30 31 ORIGINAL TOWN D…						LXR5-DVRD-CDFD-CLIB-DOVR
03-8 0-33-1-002-006 000	0380331002006000	29	107	BROADWAY ST	LEXINGTON	MO	64067-0000	MERRIMACK CONSTRUCTION LLC		LEXINGTON	MO	64067-0000	Lafayette	41888	Lexington	090200	902	930.9180	1	1	1919	29107C	2025-12-25	X	AREA OF MINIMAL FLOOD HAZARD	256.0345	259.2948	257.7007	0.2300	BUSINESS	2361	LOTS 7 8 BLK 44 FIRST ADDN TO L…						LXR5-LXRD-NOFD-CLIB-LEXN
19-2 0-04-2-002-070 000	1920042002070000	29	107	S BISMARK	CONCORDIA	MO	64020-0000	HOMES BY HANNAH DESIGN LLC		CONCORDIA	MO	64020-0000	Lafayette	25858	Freedom	090500	905	668.7435	2	1	1917	29107C	2025-12-25	X	AREA OF MINIMAL FLOOD HAZARD	241.5392	242.5089	242.0411	0.1652	BUSINESS	54141	PT LOT 15 BLK A ORIGINAL TOWN C…						CNR2-CNRD-CNFD-CLIB-CONC-CNAM
08-7 0-26-3-002-032 010	0870263002032010	29	107	E COAL ST	CORDER	MO	64021-0000	MOENKHOFF WELDING REPAIR LLC		ALMA	MO	64001-0000	Lafayette	19936	Dover	090401	904.0100	1933.2879	2			29107C	2025-12-25	X	AREA OF MINIMAL FLOOD HAZARD	264.1883	265.9688	264.9123	0.4778	BUSINESS	333992	LOT 1 ELIZABETH A CORDERS SUBD …				MOENKHOFF WELDING AND REPAIR	MANUFACTURER	LCC1-CDRD-CDFD-CLIB-CORD
05-7 0-26-0-000-002 010	0570260000002010	29	107	HWY 24	WAVERLY	MO	64096-0000	PLAGGEMEYER JAMES HENRY II AMBER		WAVERLY	MO	64096-0000	Lafayette	19936	Dover	090300	903	41148.1129	1			29107C	2025-12-25	X	AREA OF MINIMAL FLOOD HAZARD	251.4275	271.6177	266.0235	10.1683	PERSON	4551	PT OF N1 2 OF NW1 4 903-80 1120…				AMAZING GRACE ORCHARD	FOOD_AND_BEVERAGE_STORE	SR10-WVRD-CDFD-CLIB-NOCTY-TBWS
03-7 0-26-3-001-001 080	0370263001001080	29	107	EXPEDITION DR	LEXINGTON	MO	64067-0000	CLAY WILLIAM ERVIN II E LISA ANN		LEXINGTON	MO	64067-0000	Lafayette	41888	Lexington	090200	902	7402.0910	1	1	2009	29107C	2025-12-25	X	AREA OF MINIMAL FLOOD HAZARD	250.0401	256.0433	253.1940	1.8276	PERSON		LOT 8 ARROW RIDGE ESTATES 588-7…						LXR5-LXRD-NOFD-CLIB-NOCTY
06-6 0-14-3-003-032 000	0660143003032000	29	107	W WALNUT ST	WAVERLY	MO	64096-0000	HERRERA JEREMY		MARSHALL	MO	65340-0000	Lafayette	47882	Middleton	090300	903	1300.6049	1	1	1920	29107C	2025-12-25	X	AREA OF MINIMAL FLOOD HAZARD	243.2698	245.4981	244.2208	0.3213	PERSON		LOTS 7 8 BLK 19 ST THOMAS 3RD A…						SR10-WVRD-WVFD-CLIB-WAVY-CCAM
24-2 0-10-0-000-009 100	2420100000009100	29	107	BLUFF DR	OAK GROVE	MO	64075-0000	RILEY MICHAEL D		OAK GROVE	MO	64075-0000	Lafayette	68456	Sni-A-Bar	090602	906.0200	8716.6355	2	1	2004	29107C	2025-12-25	X	AREA OF MINIMAL FLOOD HAZARD	250.5628	258.8615	255.7722	2.1539	PERSON		LOT 9 BLUFF AT BENT OAK 1ST PLA…						OGR6-2WCR-SVFD-CLIB-NOCTY-MCC
19-3 0-05-4-000-110 000	1930054000110000	29	107	S BISMARK	CONCORDIA	MO	64020-0000	BALDWIN KEVIN LISA R		CONCORDIA	MO	64020-0000	Lafayette	25858	Freedom	090500	905	1327.8856	1	1	1968	29107C	2025-12-25	X	AREA OF MINIMAL FLOOD HAZARD	230.6902	233.3124	232.5724	0.3281	PERSON		LOT 1 UPHAUS SUBD 483-415 652-7…						CNR2-CNRD-CNFD-CLIB-CONC-CNAM
19-2 0-04-3-003-100 000	1920043003100000	29	107	S BISMARK	CONCORDIA	MO	64020-0000	SCHELP MARK		CONCORDIA	MO	64020-0000	Lafayette	25858	Freedom	090500	905	725.9499	1	1	1980	29107C	2025-12-25	X	AREA OF MINIMAL FLOOD HAZARD	239.9318	241.3662	240.8772	0.1793	PERSON		LOT 10 BLK L ORIGINAL TOWN CONC…						CNR2-CNRD-CNFD-CLIB-CONC-CNAM
17-3 0-06-3-002-072 000	1730063002072000	29	107	WALNUT ST	HIGGINSVILLE	MO	64037-0000	DUNCAN WILLIAM SHLIMANOFF ANTHO…		HIGGINSVILLE	MO	64037-0000	Lafayette	18406	Davis	090402	904.0200	2088.6634	1	1	1995	29107C	2025-12-25	X	AREA OF MINIMAL FLOOD HAZARD	244.0774	248.8343	246.7381	0.5161	PERSON		PT LOT 7 BLK 17 ASBURYS ADDN 63…						LCC1-HGRD-HFPD-HGLB-HIGG
16-1 0-01-4-002-088 000	1610014002088000	29	107	FAIRGROUND AVE	HIGGINSVILLE	MO	64037-0000	WOODEN PHILIP		HIGGINSVILLE	MO	64037-0000	Lafayette	18406	Davis	090402	904.0200	580.6011	1	1	1903	29107C	2025-12-25	X	AREA OF MINIMAL FLOOD HAZARD	253.0425	254.2521	253.7306	0.1434	PERSON		LOT 2 BLK 8 ASBURYS ADDN 596-73…						LCC1-HGRD-HFPD-HGLB-HIGG
19-2 0-04-3-001-061 000	1920043001061000	29	107	S ST LOUIS	CONCORDIA	MO	64020-0000	TREECE DEBRA K		CONCORDIA	MO	64020-0000	Lafayette	25858	Freedom	090500	905	1068.3885	2	1	1940	29107C	2025-12-25	X	AREA OF MINIMAL FLOOD HAZARD	239.5343	240.2707	239.8698	0.2640	PERSON		ALL LOT 7 PT LOT 8 LUEDEMANNS A…						CNR2-CNRD-CNFD-CLIB-CONC-CNAM
16-1 0-01-4-003-100 000	1610014003100000	29	107	W 29TH ST	HIGGINSVILLE	MO	64037-0000	BERRY GREG B		HIGGINSVILLE	MO	64037-1819	Lafayette	18406	Davis	090402	904.0200	1299.1461	1	1	1950	29107C	2025-12-25	X	AREA OF MINIMAL FLOOD HAZARD	260.2985	261.5394	261.1132	0.3210	PERSON		LOTS 8 9 BLK 5 SOUTHERN HEIGHTS…						LCC1-HGRD-HFPD-HGLB-HIGG
03-8 0-33-1-004-030 000	0380331004030000	29	107	SOUTHWEST BLVD	LEXINGTON	MO	64067-0000	BERETTA KIRT A CARLA J		LEXINGTON	MO	64067-0000	Lafayette	41888	Lexington	090100	901	1306.1082	1	1	1910	29107C	2025-12-25	X	AREA OF MINIMAL FLOOD HAZARD	257.7495	260.9794	259.5500	0.3227	PERSON		PT LOTS 1 2 BLK 1 WENTWORTHS AD…						LXR5-LXRD-NOFD-CLIB-LEXN
03-7 0-35-2-000-021 010	0370352000021010	29	107	FRANKLIN AVE	LEXINGTON	MO	64067-0000	CURTIS JOSH J SARAH A		LEXINGTON	MO	64067-0000	Lafayette	41888	Lexington	090200	902	1076.7885	1	1	1985	29107C	2025-12-25	X	AREA OF MINIMAL FLOOD HAZARD	256.3554	258.1773	257.5914	0.2659	PERSON		LOT 8 LEXINGTON VFW MEMORIAL PO…						LXR5-LXRD-NOFD-CLIB-LEXN
14-7 0-35-4-000-022 000	1470354000022000	29	107	N 9TH ST	ODESSA	MO	64076-0000	LAXSON CHARLES B SHERRIE L		ODESSA	MO	64076-0000	Lafayette	14428	Clay	090601	906.0100	1053.8453	2	1	1978	29107C	2025-12-25	X	AREA OF MINIMAL FLOOD HAZARD	286.9746	290.6545	288.6999	0.2603	PERSON		LOT 1 BLK 2 STOLPE SUBD 611-857…						ODR7-ODRD-ODFD-CLIB-ODES-ODRB-O…
06-4 0-18-0-000-001 010	0640180000001010	29	107	BALTIMORE BEND RD	WAVERLY	MO	64096-0000	CONSERVATION COMMISSION OF THE …		JEFFERSON CITY	MO	65102-0000	Lafayette	47882	Middleton	090300	903	2274770.5171	0			29107C	2025-12-25	X	AREA OF MINIMAL FLOOD HAZARD				562.1282	GOVERNMENT	92412	PT OF NW1 4 PT OF NE1 4 PT OF S…	GOVT UNKNOWN	RESTRICTED	V	BALTIMORE BEND CONSERVATION AREA	STATE CONSERVATION AREA	SR10-WVRD-WVFD-CLIB-NOCTY-CCAM
23-1 0-01-1-003-020 000	2310011003020000	29	107	ROSES CIR	ODESSA	MO	64076-0000	LASURE ANTHONY SHERRY LYNNE		ODESSA	MO	64076-0000	Lafayette	68456	Sni-A-Bar	090601	906.0100	816.7235	1	1	1989	29107C	2025-12-25	X	AREA OF MINIMAL FLOOD HAZARD	273.0950	275.6623	274.6630	0.2017	PERSON		LOT 4 JENNINGS 2ND ADDN 738-997…						ODR7-ODRD-ODFD-CLIB-ODES-ODRB-O…
03-8 0-34-3-001-049 020	0380343001049020	29	107	AULL LN	LEXINGTON	MO	64067-0000	MCCUBBIN SETH DYLAN		LEXINGTON	MO	64067-0000	Lafayette	41888	Lexington	090200	902	824.3159	2	1	1910	29107C	2025-12-25	X	AREA OF MINIMAL FLOOD HAZARD	252.8031	254.4786	253.5328	0.2036	PERSON		LOT 13 BLK 6 SOUTH SIDE ADDN 66…						LXR5-LXRD-NOFD-CLIB-LEXN
12-6 0-23-1-002-002 000	1260231002002000	29	107	E HWY 224	NAPOLEON	MO	64074-0000	NELSON JAMES SHIRLEY		NAPOLEON	MO	64074-0000	Lafayette	14428	Clay	090100	901	1922.0461	1	1	1923	29107C	2025-12-25	X	AREA OF MINIMAL FLOOD HAZARD	212.7594	218.7960	215.1880	0.4751	PERSON		PT LOTS 1 4 SUBURBAN ADDN 600-9…						WNR9-WNRD-WNFD-CLIB-NAPL-WNPR-W…
03-8 0-27-3-003-040 000	0380273003040000	29	107	N BOUNDARY	LEXINGTON	MO	64067-0000	CRUMBLE WILLIAM		LEXINGTON	MO	64067-0000	Lafayette	41888	Lexington	090200	902	608.3682	1	1	1940	29107C	2025-12-25	X	AREA OF MINIMAL FLOOD HAZARD	248.6829	258.2760	253.4161	0.1503	PERSON		PT LOTS 10 11 BLK B HUNTERS ADD…						LXR5-LXRD-NOFD-CLIB-LEXN
19-3 0-05-4-000-053 000	1930054000053000	29	107	S BISMARK	CONCORDIA	MO	64020-0000	EVANS SCOTT GINGER		CONCORDIA	MO	64020-0000	Lafayette	25858	Freedom	090500	905	727.0546	1	1	1975	29107C	2025-12-25	X	AREA OF MINIMAL FLOOD HAZARD	236.8490	238.8584	237.9032	0.1796	PERSON		LOT 5 BLK A M F NEUHAUSS 2ND AD…						CNR2-CNRD-CNFD-CLIB-CONC-CNAM