Saved query af1a92fc02bddde3

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

2,960 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	totalvalue	numbldgs	numunits	numfloors	firmid	firmdate	fldzone	zonesubty	elevmin	elevmax	elevavg	usecode	zoningcode	zoningdesc	taxacres	ownertype	naicscode	parceltype	accesstype	iucnclass	placename	placetype
6203014540	06	003	SEASON PASS AND TICKET OFFICE	KIRKWOOD	CA	95646	SWANSON CHARLES CAROL TTEE SWAN…	1037 SUNBURST DR	CARSON CITY	NV	89705-8060	Alpine	91890	Markleeville	010000	100	89.3952	18000	18000	18000	0	0			06003C	2026-01-20	D		2384.0661	2384.2263	2384.1704	RCT4	PD	Planned Development	0.0200	TRUST
003160003	06	003			CA	95223	US FOREST SERVICE					Alpine	91890	Markleeville	010000	100	241995.9376					0			06003C	2026-01-20	D		2051.7087	2197.8662	2101.9746		AG	Agriculture	59.8800	GOVERNMENT	1153	GOVT FEDERAL	RESTRICTED	IB	CARSON-ICEBERG WILDERNESS	WILDERNESS AREA
003050008	06	003			CA		STATE					Alpine	91890	Markleeville	010000	100	83137.2953					0			06003C	2026-01-20	D		2145.6079	2220.2790	2174.3694		AG	Agriculture	20.5100	BUSINESS	4871	GOVT STATE	RESTRICTED	OTHER	CALIFORNIA STATE LANDS COMMISSI…	STATE RESOURCE MANAGEMENT AREA
005140005	06	003	LAKE ALPINE RESORT		CA	95223						Alpine	91890	Markleeville	010000	100	1102.8075					1			06003C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	2255.7175	2259.6652	2257.9668				0.2700		1153	GOVT FEDERAL	RESTRICTED	OTHER	STANISLAUS NATIONAL FOREST	NATIONAL FOREST
005130003	06	003			CA	95223						Alpine	91890	Markleeville	010000	100	983.6708					0			06003C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	2264.6184	2274.5075	2270.2191				0.2500		1153	GOVT FEDERAL	RESTRICTED	OTHER	STANISLAUS NATIONAL FOREST	NATIONAL FOREST
005150004	06	003			CA	95223						Alpine	91890	Markleeville	010000	100	1785.3379					1			06003C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	2272.9919	2279.2661	2276.4249				0.4400		1153	GOVT FEDERAL	RESTRICTED	OTHER	STANISLAUS NATIONAL FOREST	NATIONAL FOREST
005210003	06	003			CA	95223						Alpine	91890	Markleeville	010000	100	61034.9753					20			06003C	2026-01-20	D		1867.1055	1884.9331	1873.4281				15.0800		1153	GOVT FEDERAL	RESTRICTED	OTHER	STANISLAUS NATIONAL FOREST	NATIONAL FOREST
006160027	06	003	1377 KIRKWOOD MEADOWS DRIVE	KIRKWOOD	CA	95646						Alpine	91890	Markleeville	010000	100	4563.0101					1	1	5	06003C	2026-01-20	D		2377.1381	2384.0156	2380.2197				1.1200		53121				KIRKWOOD MOUNTAIN REALTY	REAL_ESTATE_SERVICE
005010018	06	003	MEADOW CAF		CA	95223						Alpine	91890	Markleeville	010000	100	19625.3579					1	1	1	06003C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	2150.8933	2153.6430	2152.2848				4.8300		42391				BEAR VALLEY ADVENTURE COMPANY	SPORTING_GOODS_STORE
002160004	06	003			CA	96120						Alpine	91890	Markleeville	010000	100	83783.1831					0			06003C	2026-01-20	D		2250.7219	2340.6672	2303.3719				20.6800		712190	GOVT STATE	RESTRICTED	V	HOPE VALLEY WILDLIFE AREA	STATE CONSERVATION AREA
002110015	06	003			CA	95646						Alpine	91890	Markleeville	010000	100	167485.6667					0			06003C	2026-01-20	D		2396.4099	2540.5849	2475.9629				41.3100		7212	GOVT STATE	RESTRICTED	V	RED LAKE WILDLIFE AREA	STATE CONSERVATION AREA
001210008	06	003			CA	96120						Alpine	91890	Markleeville	010000	100	166439.7676					0			06003C	2026-01-20	D		1589.0900	1692.5686	1611.2301				41.1100		7212	GOVT STATE	RESTRICTED		EAST FORK CARSON RIVER FISHING …	STATE RECREATION AREA
6202007570	06	003	MOUNTAIN CLUB	KIRKWOOD	CA	95646						Alpine	91890	Markleeville	010000	100	49.0373					0			06003C	2026-01-20	D		2384.9101	2385.9423	2385.4634				0.0100		6216				BODY SLOPES MASSAGE	WELLNESS_SERVICE
003150006	06	003			CA	95223						Alpine	91890	Markleeville	010000	100	968861.3329					0			06003C	2026-01-20	D								239.4100		1142	GOVT FEDERAL	RESTRICTED	IB	CARSON-ICEBERG WILDERNESS	WILDERNESS AREA
006240012	06	003	THE MEADOWS	KIRKWOOD	CA	95646						Alpine	91890	Markleeville	010000	100	436.0888					1	1	2	06003C	2026-01-20	D		2370.5141	2375.4160	2372.2590				0.1100
002230042	06	003	19750 HWY 89		CA	96120						Alpine	91890	Markleeville	010000	100	156093.3771					0			06003C	2026-01-20	D		1832.1402	1894.1368	1863.7641				38.6100		722515				CALLIPARE'S ALPINE CAFE	CAFE
002020018	06	003			CA	96120						Alpine	91890	Markleeville	010000	100	1152300.1018					0			06003C	2026-01-20	D								284.5800		71219	GOVT FEDERAL	RESTRICTED	OTHER	TOIYABE NATIONAL FOREST	NATIONAL FOREST
005294001	06	003	10 JOHN EBBETTS ROAD	BEAR VALLEY	CA	95223						Alpine	91890	Markleeville	010000	100	1134.1361					1			06003C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	2192.0249	2195.1457	2193.2445				0.2800
005462009	06	003	185 SNOWSHOE ROAD	BEAR VALLEY	CA	95223						Alpine	91890	Markleeville	010000	100	1428.2471					0			06003C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	2253.0642	2270.3547	2260.2864				0.3500
005360006	06	003	150 QUAKING ASPEN ROAD	BEAR VALLEY	CA	95223						Alpine	91890	Markleeville	010000	100	917.7417					1			06003C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	2161.8488	2166.2587	2164.0465				0.2300
006090013	06	003	SUN MEADOWS 3	KIRKWOOD	CA	95646						Alpine	91890	Markleeville	010000	100	72.9028					1	1	3	06003C	2026-01-20	D		2373.7441	2375.9763	2374.6299				0.0200
001160006	06	003	170 FOOTHILL ROAD	MESA VISTA	CA	96120						Alpine	91890	Markleeville	010000	100	3732.6496					1			06003C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	1555.1964	1559.8822	1557.4747				0.9300
005294008	06	003	18 JOHN EBBETTS ROAD	BEAR VALLEY	CA	95223						Alpine	91890	Markleeville	010000	100	982.2368					0			06003C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	2192.2731	2196.8371	2194.7327				0.2400
005282004	06	003	76 SCHIMKE ROAD	BEAR VALLEY	CA	95223						Alpine	91890	Markleeville	010000	100	1373.3112					1			06003C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	2187.5688	2196.9174	2192.4394				0.3400
005341001	06	003	401 QUAKING ASPEN ROAD	BEAR VALLEY	CA	95223						Alpine	91890	Markleeville	010000	100	1455.6322					1			06003C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	2190.4875	2196.0012	2193.3033				0.3600