Saved query 75757fb9d42bedf1

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 = '06' 
  AND countyfp = '031'

52,473 matching parcels

Data Preview

parcelid	statefp	countyfp	parceladdr	parcelcity	parcelstate	parcelzip	ownername	owneraddr	ownercity	ownerstate	ownerzip	countyname	cousubfp	cousubname	tractce	tractname	calcarea	imprvalue	landvalue	agvalue	saledate	numbldgs	firmid	firmdate	fldzone	zonesubty	staticbfe	elevmin	elevmax	elevavg	usecode	zoningcode	zoningdesc	taxacres	ownertype	naicscode	placename	placetype	taxdistrict
012032005000	06	031	516 0 E 7TH ST	HANFORD	CA	93230-4608	JESUS MARIA ALVAREZ REVOC FAMIL…	DBA JALISCO CORN TORTILLA FACTO…	HANFORD	CA	93230	KINGS	91220	HANFORD	000902	9.0200	627.1325	320461	320461	320461	2005-08-19	1	06031C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	-9999	70.3684	70.7809	70.5663	5500	C-S	Service Commercial	0	TRUST	7225	JALISCO CORN TORTILLA FACTORY	RESTAURANT	HFD
012323021000	06	031	790 0 WASHINGTON ST	HANFORD	CA	93230-5660	MARTINEZ SERVANDO MARIBEL HW	790 WASHINGTON ST	HANFORD	CA	93230-5660	KINGS	91220	HANFORD	001002	10.0200	729.6080	86225	86225	86225	1996-10-07	1	06031C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	-9999	68.5901	69.2378	68.7140	0100	R-L-5	Low Density Residential Five Th…	0	PERSON		MARTINEZ PARTY RENTAL	SPECIALTY_STORE	HFD
023240017000	06	031	150 0 S 19TH AVE	LEMOORE	CA	93245-3468	MONTCLAIR LEMOORE AR LP	69 NW NEWPORT AVE SUITE 200	BEND	OR	97703	KINGS	91590	LEMOORE	000407	4.0700	27954.3000	3925394	3925394	3925394		36	06031C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	-9999	61.7729	63.2404	62.4490	6600	RMD	Medium Density Residential	6.8200	BUSINESS		HUGHES AUTO WRECKING AND TOWING…	VEHICLE_SERVICE	LEM
008270027000	06	031	510 E GRANGEVILLE BLVD	HANFORD	CA	93230-3080	DRAXLER LAND CO INC	2761 MARLIN STREETR	WEST SACRAMENTO	CA	95691	KINGS	91220	HANFORD	000701	7.0100	922.9024	134909	134909	134909	2014-10-01	1	06031C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	-9999	72.7561	73.2559	73.0293	4900	R-H	High Density Residential	0.3000	BUSINESS				HFD
014790013000	06	031	1295 0 CANYONCREEK ST	HANFORD	CA	93230-6941	LANTZ DAWNA E	1295 CANYONCREEK ST	HANFORD	CA	93230-6941	KINGS	91220	HANFORD	000702	7.0200	860.4889	202216	202216	202216	2012-07-03	1	06031C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	-9999	74.1194	74.7305	74.5259	0100	R-L-5	Low Density Residential Five Th…	0	PERSON				HFD
028202016000	06	031	8942 0 KANSAS AVE	HANFORD	CA	93230-9565	BARCELLOS AVELINO C JR MARY E HW	8942 KANSAS AVE	HANFORD	CA	93230-9565	KINGS	91220	HANFORD	001200	12	11685.9928	266648	266648	266648	2016-08-29	1	06031C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	-9999	59.4357	60.0809	59.6517	1910	AG20	General Agricultural District 2…	2.8900	PERSON				HFD
012126014000	06	031	118 0 W 2ND ST	HANFORD	CA	93230-5003	INIGUEZ JUAN ELSA E H ACEVES HW	2446 DOVER CANYON DR	TULARE	CA	93274-1653	KINGS	91220	HANFORD	001100	11	698.1654	56866	56866	56866	2019-02-14	1	06031C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	-9999	69.8200	70.2957	70.0144	0100	R-M	Medium Density Residential	0	PERSON				HFD
011140039000	06	031	1379 0 ACRES WAY	HANFORD	CA	93230-7692	BURR ROMEALLO ANTON	1379 ACRES WAY	HANFORD	CA	93230-7692	KINGS	91220	HANFORD	001003	10.0300	1006.5173	326400	326400	326400	2023-02-28	1	06031C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	-9999	67.1191	67.4887	67.2771	0100	R-L-5	Low Density Residential Five Th…	0	PERSON				HFD
012480084000	06	031	1425 0 HAYDEN AVE	HANFORD	CA	93230-5539	CARRILLO SANDRA H	PO BOX 182	ARMONA	CA	93202-0182	KINGS	91220	HANFORD	001002	10.0200	628.2255	79919	79919	79919	2012-01-20	1	06031C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	-9999	67.6611	68.0823	67.8562	0100	R-L-5	Low Density Residential Five Th…	0	PERSON				HFD
023410051000	06	031	1445 0 LINCOLN LN	LEMOORE	CA	93245-4914	WEDDERBURN LOY C LIVING TR	1445 LINCOLN LN	LEMOORE	CA	93245-4914	KINGS	91590	LEMOORE	000402	4.0199	907.7374	131047	131047	131047	2008-02-13	1	06031C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	-9999	61.4962	62.4011	62.0791	0100	RLD	Low Density Residential	0	TRUST				LEM
021250024000	06	031	612 0 GRANADA CIR	LEMOORE	CA	93245-4150	TAFOLLA OSCAR JOSEFA HW	612 GRANADA CIR	LEMOORE	CA	93245-4150	KINGS	91590	LEMOORE	000405	4.0500	765.3299	190747	190747	190747	2012-01-26	1	06031C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	-9999	63.7170	64.5156	64.0116	0100	RLD	Low Density Residential	0	PERSON				LEM
009370023000	06	031	2333 0 W BRISTOL LN	HANFORD	CA	93230-8977	WILDES JOSHUA A ALBA A HW	2333 W BRISTOL LN	HANFORD	CA	93230-8977	KINGS	91220	HANFORD	000603	6.0300	647.2050	382593	382593	382593	2017-08-15	1	06031C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	-9999	69.6551	70.1822	70.0565	0100	R-L-5	Low Density Residential Five Th…	0	PERSON				HFD
021260085000	06	031	514 0 IVORY ST	LEMOORE	CA	93245-2122	MAMUAD JULIETTE	514 IVORY ST	LEMOORE	CA	93245-2122	KINGS	91590	LEMOORE	000405	4.0500	656.3918	289814	289814	289814	2019-01-22	1	06031C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	-9999	63.9878	64.6686	64.4387	0100	RLD	Low Density Residential	0	PERSON				LEM
008263011000	06	031	1805 0 N REDINGTON ST	HANFORD	CA	93230-2055	SBE LP	PO BOX 1109	VISALIA	CA	93279-1109	KINGS	91220	HANFORD	000602	6.0199	821.2114	124056	124056	124056	2024-07-29	1	06031C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	-9999	72.4124	72.7147	72.5136	0100	R-L-5	Low Density Residential Five Th…	0	BUSINESS				HFD
009490119000	06	031	2646 0 W BERKSHIRE	HANFORD	CA	93230-8893	LENNAR HOMES OF CALIFORNIA LLC	8080 N PALM AVE 110	FRESNO	CA	93711	KINGS	91220	HANFORD	000603	6.0300	448.8518	109161	109161	109161	2024-06-26	1	06031C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	-9999	69.3553	69.9036	69.7983	0100	R-L-5	Low Density Residential Five Th…	0	BUSINESS				HFD
040231025000	06	031	917 0 E WHITNEY ST	AVENAL	CA	93204-2028	HIGUERA ALEJANDRA P	917 E WHITNEY ST	AVENAL	CA	93204-2028	KINGS	90170	AVENAL	001703	17.0300	501.9217	221698	221698	221698	2005-11-10	1	06031C	2026-01-20	X	0.2 PCT ANNUAL CHANCE FLOOD HAZ…	-9999	248.6587	249.5330	249.2702	0100	R1	Single Family Residential	0	PERSON				AVN
010232004000	06	031	207 0 W IVY ST	HANFORD	CA	93230-3828	SANCHEZ EDGAR	207 W IVY ST	HANFORD	CA	93230-3828	KINGS	91220	HANFORD	000902	9.0200	700.3871	223295	223295	223295	2006-08-31	1	06031C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	-9999	70.3614	70.9645	70.5386	0100	O-R	Office Residential	0	PERSON				HFD
023160035000	06	031	683 0 OTERO ST	LEMOORE	CA	93245-4602	BRAVO JOSE BEATRICE HW	683 OTERO ST	LEMOORE	CA	93245-4602	KINGS	91590	LEMOORE	000402	4.0199	649.2598	144473	144473	144473	1998-12-28	1	06031C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	-9999	62.6080	63.1335	62.8963	0100	RLD	Low Density Residential	0	PERSON				LEM
020075007000	06	031	19 0 MARTIN ST	LEMOORE	CA	93245-2641	BILLINGSLEY THOMAS C SUSAN W HW	PO BOX 276	LEMOORE	CA	93245-0276	KINGS	91590	LEMOORE	000407	4.0700	1037.2359	219806	219806	219806	2010-10-22	2	06031C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	-9999	63.0995	63.5038	63.2643	0120	RN	Traditional Neighborhood Reside…	0	PERSON				LEM
008021002000	06	031	144 0 W AMBER WAY	HANFORD	CA	93230-1751	FLORES LISA 100	144 W AMBER WAY	HANFORD	CA	93230-1751	KINGS	91220	HANFORD	000602	6.0199	659.1383	296514	296514	296514	2022-06-03	1	06031C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	-9999	73.3905	74.1600	73.8868	0100	R-L-5	Low Density Residential Five Th…	0	PERSON				HFD
007120066000	06	031	193 0 E WILLOW ST	HANFORD	CA	93230-1227	GARCIA GABRIEL CONNIE HW	193 WILLOW ST	HANFORD	CA	93230	KINGS	91220	HANFORD	000701	7.0100	803.0718	262143	262143	262143	2017-12-05	1	06031C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	-9999	73.8783	74.3792	74.1428	0100	R-L-8	Low Density Residential Eight T…	0	PERSON				HFD
010390042000	06	031	1212 0 W MALONE ST	HANFORD	CA	93230-2623	MITCHELL SANDRA	1212 W MALONE ST	HANFORD	CA	93230-2623	KINGS	91220	HANFORD	001001	10.0100	670.0182	240543	240543	240543	2018-08-03	1	06031C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	-9999	69.3558	70.2813	69.9175	0100	R-L-5	Low Density Residential Five Th…	0	PERSON				HFD
010282008000	06	031	530 0 E 9TH ST	HANFORD	CA	93230-4037	PEREZ MAURILIO BERTHA HW	530 E 9TH ST	HANFORD	CA	93230-4037	KINGS	91220	HANFORD	000902	9.0200	884.6318	207665	207665	207665	2003-05-01	1	06031C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	-9999	70.9214	71.6127	71.0606	0100	R-M	Medium Density Residential	0	PERSON				HFD
011270047000	06	031	1237 0 NICOLE AVE	HANFORD	CA	93230-7666	NUNO HECTOR F D ELIZABETH V M HW	1237 NICOLE AVE	HANFORD	CA	93230-7666	KINGS	91220	HANFORD	001003	10.0300	488.2744	138207	138207	138207	2013-10-21	1	06031C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	-9999	66.8755	67.7139	67.4218	0100	R-L-5	Low Density Residential Five Th…	0	PERSON				HFD
008203032000	06	031	2044 0 N BURL DR	HANFORD	CA	93230-2107	VAN NOORT BRIDGETTE R GREGORY D…	2044 BURL DR	HANFORD	CA	93230	KINGS	91220	HANFORD	000701	7.0100	648.3632	257681	257681	257681	2018-02-23	1	06031C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	-9999	74.1366	74.6344	74.4493	0100	R-L-5	Low Density Residential Five Th…	0	PERSON				HFD