Saved query 4ae88e7aadb385a3

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

36,134 matching parcels

Data Preview

parcelid	taxacctnum	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	usecode	usedesc	zoningcode	zoningdesc	taxacres	ownertype	naicscode	book	page	placename	placetype
55-150-044	055-150-044-000	06	101	2161 DEER CREEK DR	YUBA CITY	CA	95991-8454	COOKE STEVE	2161 DEER CREEK DR	YUBA CITY	CA	95991-8454	SUTTER	93820	YUBA CITY	050403	504.0300	558.0508	199870	199870	199870	2011-11-07	1	060394	2026-01-20	X	0.2 PCT ANNUAL CHANCE FLOOD HAZ…	120	Single Family Residence	R-1	One Family Residence District	0.1378	PERSON		55	150
57-213-024	057-213-024-000	06	101	1670 SANDPIPER DR	YUBA CITY	CA	95993-7157	JINDHERD YASMIN B	1670 SANDPIPER DR	YUBA CITY	CA	95993-7157	SUTTER	93820	YUBA CITY	050503	505.0300	656.4419	169612	169612	169612	2008-10-27	1	060394	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	120	Single Family Residence	R-1	One Family Residence District	0.1621	PERSON		57	213
55-060-042	055-060-042-000	06	101	2395 PECAN DR	YUBA CITY	CA	95991-8434	FULP SANDRA ETAL	2395 PECAN DR	YUBA CITY	CA	95991-8434	SUTTER	93820	YUBA CITY	050403	504.0300	596.3501	424766	424766	424766	2021-10-13	1	060394	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	120	Single Family Residence	R-1	One Family Residence District	0.1473	PERSON		55	060
56-310-067	056-310-067-000	06	101	1545 JODI DR	YUBA CITY	CA	95993-8283	KAUR MANDEEP ETAL	1545 JODI DR	YUBA CITY	CA	95993-8283	SUTTER	93820	YUBA CITY	050504	505.0400	538.2095	400160	400160	400160	2017-12-01	1	060394	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	120	Single Family Residence	R-1	One Family Residence District	0.1329	PERSON		56	310
56-320-029	056-320-029-000	06	101	1065 0 MARTIN CT	YUBA CITY	CA	95993-9739	NUNEZ DANIELVERONICA	3306 WALTON ROAD	YUBA CITY	CA	95993	SUTTER	93820	YUBA CITY	050504	505.0400	468.0901	243649	243649	243649	2008-11-20	1	060394	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	120	Single Family Residence	PD	Planned Development District	0.1156	PERSON		56	320
56-330-023	056-330-023-000	06	101	1525 GREENWICH CIR	YUBA CITY	CA	95993-7003	GREEN MICHAEL	1525 GREENWICH CIR	YUBA CITY	CA	95993-7003	SUTTER	93820	YUBA CITY	050504	505.0400	280.0197	243718	243718	243718	2016-06-01	1	060394	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	120	Single Family Residence	PD	Planned Development District	0.0691	PERSON		56	330
55-130-011	055-130-011-000	06	101	680 SHANGHAI BEND RD	YUBA CITY	CA	95991-8326	JOHNSON MATTHEW LJOI L	680 SHANGHAI BEND RD	YUBA CITY	CA	95991-8326	SUTTER	93820	YUBA CITY	050402	504.0200	657.5112	332602	332602	332602	2008-02-08	1	060394	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	120	Single Family Residence	R-1	One Family Residence District	0.1624	PERSON		55	130
22-172-030	022-172-030-000	06	101	1273 0 PAMELA CT	YUBA CITY	CA	95991-6740	GATES RYANELIZABETH	1273 PAMELA CT	YUBA CITY	CA	95991-6740	SUTTER	93820	YUBA CITY	050401	504.0100	755.3216	245689	245689	245689	2015-09-11	1	060394	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	120	Single Family Residence	R-1	One Family Residence District	0.1866	PERSON		22	172
56-080-065	056-080-065-000	06	101	1893 PARKWOOD DR	YUBA CITY	CA	95993-8318	MEHMI AMARJIT S ET	1893 PARKWOOD DR	YUBA CITY	CA	95993-8318	SUTTER	93820	YUBA CITY	050504	505.0400	777.8831	220236	220236	220236	2009-05-29	1	060394	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	120	Single Family Residence	R-1	One Family Residence District	0.1922	PERSON		56	080
26-101-022	026-101-022-000	06	101	1100 HUNN RD	YUBA CITY	CA	95991-5703	KIDO PATRICIA A	1100 HUNN RD	YUBA CITY	CA	95991-5703	SUTTER	93820	YUBA CITY	050301	503.0100	1111.6867	182976	182976	182976	2003-11-12	1	060394	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	120	Single Family Residence	R-1	One Family Residence District	0.2746	PERSON		26	101
57-011-018	057-011-018-000	06	101	1918 CHERRY ST	YUBA CITY	CA	95993-5110	LYNN THOMAS J	1918 CHERRY ST	YUBA CITY	CA	95993-5110	SUTTER	93820	YUBA CITY	050503	505.0300	1021.5630	314572	314572	314572	2018-05-31	1	060394	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	120	Single Family Residence	R-1	One Family Residence District	0.2524	PERSON		57	011
23-421-012	023-421-012-000	06	101	2191 SANBORN RD	YUBA CITY	CA	95993-9256	TEYES ETAL BALTAZAR	2191 SANBORN RD	YUBA CITY	CA	95993-9256	SUTTER	93820	YUBA CITY	050504	505.0400	3717.2647	652800	652800	652800	2022-12-28	1	060394	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	120	Single Family Residence	ER	Estate Residential	0.9184	PERSON		23	421
56-272-014	056-272-014-000	06	101	1170 0 ROBERT DR	YUBA CITY	CA	95993-6436	ALTAMIRANO MIGUELEGLA	1170 ROBERT DR	YUBA CITY	CA	95991	SUTTER	93820	YUBA CITY	050504	505.0400	1730.1217	234265	234265	234265	2003-04-10	1	060394	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	120	Single Family Residence	R-1	One Family Residence District	0.4274	PERSON		56	272
23-130-006	023-130-006-000	06	101	204 BARRY RD	YUBA CITY	CA	95991-9713	TRINDADE ZACHARY R	204 BARRY RD	YUBA CITY	CA	95991-9713	SUTTER	93820	YUBA CITY	050402	504.0200	3275.0466	298464	298464	298464	2020-08-31	1	060394	2026-01-20	X	0.2 PCT ANNUAL CHANCE FLOOD HAZ…	120	Single Family Residence	AG	Agriculture	0.8091	PERSON		23	130
56-310-004	056-310-004-000	06	101	1398 JODI DR	YUBA CITY	CA	95993-9266	KAUR SUKHWINDER	1395 JODI DR	YUBA CITY	CA	95993-9266	SUTTER	93820	YUBA CITY	050504	505.0400	574.2512	236075	236075	236075	2009-04-03	1	060394	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	120	Single Family Residence	R-1	One Family Residence District	0.1418	PERSON		56	310
22-341-019	022-341-019-000	06	101	1187 LOIS LN	YUBA CITY	CA	95991-6913	WILLIAMS BRANT	1187 LOIS LN	YUBA CITY	CA	95991-6913	SUTTER	93820	YUBA CITY	050402	504.0200	1018.5988	185910	185910	185910	2013-01-17	1	060394	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	120	Single Family Residence	R-1	One Family Residence District	0.2516	PERSON		22	341
53-343-002	053-343-002-000	06	101	864 CAROLINA AVE	YUBA CITY	CA	95991-6160	MEZA CARMINA	864 CAROLINA AVE	YUBA CITY	CA	95991-6160	SUTTER	93820	YUBA CITY	050301	503.0100	737.3606	150195	150195	150195	2011-03-11	1	060394	2026-01-20	AREA NOT INCLUDED		120	Single Family Residence	R-1	One Family Residence District	0.1821	PERSON		53	343
56-300-066	056-300-066-000	06	101	2010 NICHOLAS DR	YUBA CITY	CA	95993-9254	RAI ETAL AMARJIT KAUR	1210 LANCASTER WAY	YUBA CITY	CA	95991-4072	SUTTER	93820	YUBA CITY	050504	505.0400	711.7554	489600	489600	489600		1	060394	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	120	Single Family Residence	R-1	One Family Residence District	0.1758	PERSON		56	300
54-150-001	054-150-001-000	06	101	1364 EASTWIND DR	YUBA CITY	CA	95991-7550	CHEEMA A N FAM 20 TR ETA	1793 REGENCY WAY	YUBA CITY	CA	95993-5177	SUTTER	93820	YUBA CITY	050401	504.0100	839.3659	182242	182242	182242	2012-01-30	2	060394	2026-01-20	AREA NOT INCLUDED		130	Multiple Res. - 2-4 Units	R-2	Two Family Residence District	0.2073	PERSON		54	150
53-281-019	053-281-019-000	06	101	615 WINSHIP RD	YUBA CITY	CA	95991-6235	FINCH LEE FAM TR ET	9255 ARMSTRONG RD	MARYSVILLE	CA	95901-3001	SUTTER	93820	YUBA CITY	050302	503.0200	781.1021	107554	107554	107554	2010-04-29	1	060394	2026-01-20	AREA NOT INCLUDED		120	Single Family Residence	R-1	One Family Residence District	0.1930	PERSON		53	281
56-190-005	056-190-005-000	06	101	1661 EDWIN DR	YUBA CITY	CA	95993-7617	BASSI HARDIP S	1661 EDWIN DR	YUBA CITY	CA	95993-7617	SUTTER	93820	YUBA CITY	050504	505.0400	740.3850	198441	198441	198441		1	060394	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	120	Single Family Residence	R-1	One Family Residence District	0.1828	PERSON		56	190
52-013-006	052-013-006-000	06	101	1272 COLUSA AVE	YUBA CITY	CA	95991-3655	LESSER BENJAMINNICOLE	1547 PALLS VERDES MALL 201	WALNUT CREEK	CA	94597	SUTTER	93820	YUBA CITY	050201	502.0100	1990.2215	2144401	2144401	2144401	2020-03-16	6			—		310	Commercial - Improved	C-3	General Commercial District	0.4917	PERSON	7225	52	013	2 BITS CAFE	CAFE
25-150-038	025-150-038-000	06	101	1133 WILSON RD	YUBA CITY	CA	95991-9536	MAGENHEIMER FAM 96 TR ET	1820 TUDOR RD	YUBA CITY	CA	95993-9516	SUTTER	93825	YUBA CITY SOUTHWEST	051000	510	18405.4813	298538	298538	298538	2007-12-04	1	060394	2026-01-20	A		205	Rural - <10ac w/1 SFR	AG	Agriculture	4.5472	BUSINESS		25	150
28-020-091	028-020-091-000	06	101	3768 GALLAGHER RD	RIO OSO	CA	95674-9628	SINGLE BILLIE REV TR ET	3768 GALLAGHER RD	RIO OSO	CA	95674-9628	SUTTER	93180	SOUTH SUTTER	051100	511	7504.7832	117677	117677	117677		1	060394	2026-01-20	A		205	Rural - <10ac w/1 SFR	AG	Agriculture	1.8541	PERSON		28	020
35-170-016	035-170-016-000	06	101	7350 0 LOCUST RD	PLEASANT GROVE	CA	95668-9627	NIEGEL GREGORY TR ETAL	2939A HOWSLEY RD	PLEASANT GROVE	CA	95668-9723	SUTTER	93180	SOUTH SUTTER	051100	511	310096.9035	147390	147390	147390			060394	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	200	OPEN LAND GT 15-w Imp/No SFR	AG	Agriculture	76.6159	PERSON		35	170