Saved query d43e6aa8e55daa8f

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 = '047'

91,933 matching parcels

Data Preview

parcelid	taxacctnum	statefp	countyfp	parceladdr	parcelcity	parcelstate	parcelzip	ownername	owneraddr	ownercity	ownerstate	ownerzip	countyname	cousubfp	cousubname	tractce	tractname	calcarea	saledate	numbldgs	numunits	firmid	firmdate	fldzone	zonesubty	staticbfe	elevmin	elevmax	elevavg	usecode	zoningcode	zoningdesc	taxacres	ownertype	naicscode	book	page	placename	placetype
431060052	431060052000	06	047	680 0 ALDER LN	LOS BANOS	CA	93635-9692	GILL PRICAM KARNALL	13765 SYCAMORE DR	MORGAN HILL	CA	95037-9407	Merced	91760	LOS BANOS	002301	23.0100	731.7600	2010-05-26	1		06047C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD		37.2879	38.0090	37.7858	101.0000	R-1	Low Density Residential	0.1809	PERSON	71394	431	06	TWIN TIGERS KUNG-FU OWNED BY DR…	GYM
031360061	031360061000	06	047	640 0 W 16TH ST	MERCED	CA	95340-4721	RK LEGACY COMMERCIAL HOLDINGS L…	3323 E OLIVE AVE	MERCED	CA	95340-9338	Merced	91960	MERCED	001301	13.0100	3832.6611	2025-01-06	1		06047C	2026-01-20	AO			50.8920	51.8998	51.5107	404.0000	C-C	Central Commercial District	0.9468	BUSINESS	7225	031	36	BRANDING IRON RESTAURANT	RESTAURANT
056150023	056150023000	06	047	6660 0 BAILEY RD	ATWATER	CA	95301-9567	LIPPASSONSCHMITZ RENATE TRE	6660 BAILEY RD	ATWATER	CA	95301-9567	Merced	91960	MERCED	000901	9.0100	73994.9545	2022-04-20	5		06047C	2026-01-20	A			38.4024	39.7234	38.8027	707.0000	A-1	General Agriculture	18.2831	PERSON	81291	056	15	LAST HOPE CAT KINGDOM	ANIMAL_OR_PET_SERVICE
035124032	035124032000	06	047	1680 0 ELLEN AVE	MERCED	CA	95341-5201	ELLEN AVE INVESTMENT LLC	625 N WEST KNOLL DR	WEST HOLLYWOOD	CA	90069-5205	Merced	91960	MERCED	001700	17	791.8544	2010-09-14	3	4	06047C	2026-01-20	AO			54.1413	54.5292	54.3695	202.0000	R-4	High Density Residential	0.1956	BUSINESS	52591	035	12
011041023	011041023000	06	047	15970 0 EL CAPITAN WAY	DELHI	CA	95315-9754	FARIAS BULMARO LETICIA	3745 FOSBERG RD	TURLOCK	CA	95382-0334	Merced	91670	LIVINGSTON-DELHI	000201	2.0099	1405.9659	2021-02-26	1	1	06047C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD		35.4888	36.0672	35.6575	104.0000	C-1	Neighborhood Commercial	0.3473	PERSON		011	04
055190001	055190001000	06	047	20085 0 ELKO ST	STEVINSON	CA	95374-9631	VIERRA JIMMY MICHEAL TRE	PO BOX 104	STEVINSON	CA	95374-0104	Merced	91290	HILMAR-IRWIN	000401	4.0100	7425.8927	2007-10-23	6	2	06047C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD		25.3721	25.8543	25.5553	201.0000	R-1	Single Family Residential	1.8347	PERSON		055	19
037063012	037063012000	06	047	371 0 DE LA GUERRA ST	PLANADA	CA	95365-8039	MORENO TONIE A	PO BOX 589	PLANADA	CA	95365-0589	Merced	92500	PLANADA-LE GRAND	001901	19.0100	696.8971	1993-02-05	1		06047C	2026-01-20	AH		231	69.5441	69.8463	69.6318	101.0000	R-1	Single Family Residential	0.1721	PERSON		037	06
022062014	022062014000	06	047	322 0 PARADISE DR	LIVINGSTON	CA	95334-9364	KAUR DALJIT	1860 YORK AVE	LIVINGSTON	CA	95334-9360	Merced	91670	LIVINGSTON-DELHI	000305	3.0500	568.8490	2025-01-13	1		06047C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD		38.8579	39.4149	39.2448	101.0000	R-1	Low Density Residential	0.1408	PERSON		022	06
146274023	146274023000	06	047	6593 0 NICHOLAS DR	WINTON	CA	95388-9275	LEON LUIS L YOLANDA M	6593 W NICHOLAS DR	WINTON	CA	95388	Merced	90150	ATWATER	000504	5.0400	656.3460	2011-09-02	1		06047C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD		54.4724	54.9867	54.8634	101.0000	R-1-5000	Single Family Residential	0.1619	PERSON		146	27
037270018	037270018000	06	047	9469 AMISTAD STREET	PLANADA	CA	95365	AVINA MERCY R	PO BOX 54	PLANADA	CA	95365-0054	Merced	92500	PLANADA-LE GRAND	001901	19.0100	774.5009	2014-07-17	1		06047C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD		70.7878	71.2519	71.0904	101.0000	R-1	Single Family Residential	0.1914	PERSON		037	27
207280022	207280022000	06	047	6241 0 SPLIT OAK DR	ATWATER	CA	95301-9202	BURROLA ROBERT VICTORIA	6241 W SPLIT OAK DR	ATWATER	CA	95301	Merced	90150	ATWATER	000702	7.0200	4262.8840	2003-09-19	3		06047C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD		42.3761	43.4559	42.9004	101.0000	R-R	Rural Residential	1.0532	PERSON		207	28
236043002	236043002000	06	047	3564 0 BEALS AVE	MERCED	CA	95348-2802	LOCKE KRISTI LYNN	3564 BEALS AVE	MERCED	CA	95348-2802	Merced	91960	MERCED	001006	10.0600	798.9536	2015-11-20	1		06047C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD		52.5819	53.3371	52.9417	101.0000	R-1-6	Low Density Residential	0.1974	PERSON		236	04
067120017	067120017000	06	047	4043 PLAINSBURG RD	LE GRAND	CA	95333-9726	GONZALEZ MANUEL ELENA	4043 PLAINSBURG RD	LE GRAND	CA	95333-9726	Merced	92500	PLANADA-LE GRAND	001902	19.0200	4178.4700	2021-01-06	2	1	06047C	2026-01-20	AO			65.5106	66.1048	65.8101	201.0000	A-1	General Agriculture	1.0323	PERSON		067	12
008045011	008045011000	06	047	3175 MCKEE RD	MERCED	CA	95340-1768	GOSE MICHAEL ALLEN GOSE CINDY R…	3183 MCKEE RD	MERCED	CA	95340-1768	Merced	91960	MERCED	002602	26.0200	888.1381	2021-06-25	1		06047C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD		56.2032	56.6622	56.4254	101.0000	R-1	Single Family Residential	0.2194	PERSON		008	04
056280010	056280010000	06	047	8235 0 SUNSET DR	ATWATER	CA	95301-9305	CLEM LORENZO MUSSANO ERIN	8235 SUNSET DR	ATWATER	CA	95301-9305	Merced	90150	ATWATER	000505	5.0500	3260.8719	2016-08-05	2		06047C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD		45.5616	47.0812	46.1607	101.0000	A-1	General Agriculture	0.8056	PERSON		056	28
004341030	004341030000	06	047	1814 0 CEDAR LAKE CT	ATWATER	CA	95301-4912	NICHOLAS LINDA LEE TRE	1814 CEDAR LAKE CT	ATWATER	CA	95301-4912	Merced	90150	ATWATER	000802	8.0200	622.1759	2018-05-09	1		06047C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD		48.3355	48.8602	48.7441	101.0000	P-D-9	Planned Development	0.1537	PERSON		004	34
156070015	156070015000	06	047	800 0 ACACIA CT	ATWATER	CA	95301-2302	LUIS STEVE	2779 CARMEL CT	ATWATER	CA	95301-2000	Merced	90150	ATWATER	000603	6.0300	1241.8248	2021-01-05	1		06047C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD		51.8037	52.3516	52.0754	203.0000	R-3	High Density Residential	0.3068	PERSON		156	07
082781021	082781021000	06	047	705 0 GROVE CT	LOS BANOS	CA	93635-8286	AGUIRRE ATENEDORO RUIZ LEONOR	705 GROVE CT	LOS BANOS	CA	93635-8286	Merced	91760	LOS BANOS	002204	22.0400	642.8314	2020-03-09	1		06047C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD		33.8156	34.4625	34.2277	101.0000	R-1	Low Density Residential	0.1588	PERSON		082	78
003083015	003083015000	06	047	481 BROADWAY AVE	ATWATER	CA	95301-4405	HARO DIEGO ALBERTO SOLIS SOLIS …	481 BROADWAY AVE	ATWATER	CA	95301-4405	Merced	90150	ATWATER	000701	7.0100	873.0358	2022-07-22	1		06047C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD		45.3374	45.9014	45.6430	101.0000	D-BD	Downtown Business	0.2157	PERSON		003	08
143281026	143281026000	06	047	2851 0 BLACK PINE WAY	LIVINGSTON	CA	95334-9695	SORIA CLAUDIA MILLAN MILLAN ANA…	2851 BLACK PINE WAY	LIVINGSTON	CA	95334-9695	Merced	91670	LIVINGSTON-DELHI	000301	3.0099	529.5414	2012-05-29	1		06047C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD		42.6080	43.3492	43.0223	101.0000	R-1	Low Density Residential	0.1308	PERSON		143	28
007271011	007271011000	06	047	2980 0 PINEWOOD CT	MERCED	CA	95348-2557	RESNER WILLIAM E KAREN E TRS	2980 PINEWOOD CT	MERCED	CA	95348-2557	Merced	91960	MERCED	001004	10.0399	1070.4091	1996-02-22	1		06047C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD		51.8224	52.6904	52.3633	101.0000	R-1-6	Low Density Residential	0.2644	TRUST		007	27
047596006	047596006000	06	047	1054 0 NEWCASTLE DR	LIVINGSTON	CA	95334-9362	SINGH GURMIT KAUR HARPREET	1054 NEWCASTLE DR	LIVINGSTON	CA	95334-9362	Merced	91670	LIVINGSTON-DELHI	000305	3.0500	511.5310	2018-07-09	1		06047C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD		37.3009	37.9134	37.7242	101.0000	R-1	Low Density Residential	0.1264	PERSON		047	59
009210012	009210012000	06	047	16241 SCHOOL COURT	DELHI	CA	95315	PULIDO JACINTO JR	PO BOX 896	DELHI	CA	95315-0896	Merced	91670	LIVINGSTON-DELHI	000205	2.0500	620.9657	2003-03-31	1		06047C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD		35.6941	36.2521	36.0755	101.0000	R-1	Single Family Residential	0.1532	PERSON		009	21
004214017	004214017000	06	047	945 POPPY HILLS DR	ATWATER	CA	95301-4809	JAIMEZ ANTONIA	945 POPPY HILLS DR	ATWATER	CA	95301-4809	Merced	90150	ATWATER	000801	8.0100	603.9825	2018-02-20	1		06047C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD		48.3920	49.3200	48.9349	101.0000	P-D-9	Planned Development	0.1492	PERSON		004	21
428140015	428140015000	06	047	819 JEFFREY RD	LOS BANOS	CA	93635-3817	ROMERO JOSE VICTOR LUNA CORTESO…	819 JEFFREY RD	LOS BANOS	CA	93635-3817	Merced	91760	LOS BANOS	002303	23.0300	752.2872	2022-07-25	1		06047C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD		34.3666	34.7156	34.5198	102.0000	R-2	Medium Density Residential	0.1859	PERSON		428	14