Saved query 6644127e1b088618

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

310,699 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	numunits	fldzone	elevmin	elevmax	elevavg	usecode	zoningcode	zoningdesc	ownertype	naicscode	placename	placetype
41816221S	06	019	1321 E SAN BRUNO AVE	FRESNO	CA	93710-7225	KAZMI ARSHAD SALMA	5658 RAVENSPUR DR 206	PALOS VERDES	CA	90275	FRESNO	91080	FRESNO	005403	54.0300	1498.3213	1117003	1117003	1117003	2015-03-05	4	16	—	100.3818	101.0346	100.7038	A16	RM-3	Residential Multi Family High D…	PERSON	6216	VIRTUAL ASSISTANT SERVICE	HOME_SERVICE
32906013S	06	019	4630 S FIG AVE	FRESNO	CA	93706-9642	VENTURA TODD A LYNETTE	4630 S FIG	FRESNO	CA	93706	FRESNO	91080	FRESNO	001800	18	39574.4970	492828	492828	492828	2018-02-20	1		—	82.3456	83.6581	82.8224	S01	AE20	Exclusive Agricultural	PERSON		ROTH MOTOR SPORTS	VEHICLE_DEALER
07515312	06	019	16774 12TH ST	HURON	CA	93234	RUIZ MERCEDES A LIFE ESTATE	PO BOX 608	HURON	CA	93234-0608	FRESNO	91360	HURON	007802	78.0200	927.8424	33676	33676	33676	1991-07-10	1	2	—	107.8387	108.1827	107.9951	A02	LDR	Low Density Residential	PERSON
43009011	06	019	4563 E SIERRA MADRE AVE	FRESNO	CA	93726-1240	JEFFERS JOHN AVINA MIGUEL A	4565 E SIERRA MADRE	FRESNO	CA	93726	FRESNO	91080	FRESNO	005304	53.0400	1397.7777	163558	163558	163558	2024-03-19	3	2	—	102.1929	103.0437	102.4148	A02	CMX	Corridor Center Mixed Use	PERSON
45019207	06	019	1111 N ADOLINE AVE	FRESNO	CA	93728-2945	MARTINEZ ANGELA RENEE MONIQUE	1111 N ADOLINE	FRESNO	CA	93728	FRESNO	91080	FRESNO	002100	21	629.5934	152105	152105	152105	2013-06-05	1		—	89.3926	89.8613	89.5721	S01	RS-5	Residential Single Family Mediu…	PERSON
55433310	06	019	713 KAWEAH AVE	CLOVIS	CA	93619-6906	WALKER RYAN KINDRA	713 KAWEAH	CLOVIS	CA	93619	FRESNO	91080	FRESNO	005914	59.1400	418.1794	378325	378325	378325	2013-07-03	1		—	117.4614	118.2430	117.9496	000	R-2	Multi Family Medium Density Res…	PERSON
40327211	06	019	8665 0 N CEDAR AVE	FRESNO	CA	93720-1838	HWM PROPERTIES LLC	1807 E EVERGLADE	FRESNO	CA	93720	FRESNO	91080	FRESNO	005507	55.0700	393.2426	175210	175210	175210	2011-04-27	1		—	113.0757	113.6035	113.4245	S01	RS-5	Residential Single Family Mediu…	BUSINESS
47008126	06	019	4625 E EL MONTE WAY	FRESNO	CA	93702-3833	SANTANA PEDRO LETICIA	4548 E EDNA	FRESNO	CA	93725	FRESNO	91080	FRESNO	001301	13.0100	574.0664	63053	63053	63053	1997-08-27	1		—	92.4981	92.8571	92.6746	S01	RS-5	Residential Single Family Mediu…	PERSON
31050327	06	019	6256 E SUSSEX WAY	FRESNO	CA	93727-7948	DERR RONNIE	6256 E SUSSEX	FRESNO	CA	93727	FRESNO	91080	FRESNO	005805	58.0500	691.6059	260696	260696	260696	2011-08-11	1		—	109.0024	109.6522	109.4888	S01	RS-4	Residential Single Family Mediu…	PERSON
05717031S	06	019	20746 S PIO PICO AVE	LATON	CA	93242	VAN GRONINGEN GARY JANICE TRS	4220 E WOOD	LATON	CA	93242	FRESNO	91570	LATON	007400	74	1441.0528	212241	212241	212241	2020-12-03	1		—	77.6356	78.2462	77.8927	CS1	C4	Central Trading	TRUST
31702029	06	019	242 O ST	SANGER	CA	93657-2354	GONZALEZ BRIAN K MARTHA	242 O ST	SANGER	CA	93657-2354	FRESNO	92800	SANGER	006002	60.0200	989.7173	153224	153224	153224	2011-04-29	1		—	112.8057	113.1919	112.9881	S01	R-1-6	Single Family Residential	PERSON
40727044	06	019	1059 W SIERRA AVE	FRESNO	CA	93711-2033	HALSTEAD CHARLES	1059 W SIERRA	FRESNO	CA	93711	FRESNO	91080	FRESNO	004503	45.0300	376.8908	218456	218456	218456	2016-08-30	1		—	103.2144	103.5485	103.4154	S01	RS-4	Residential Single Family Mediu…	PERSON
41721103	06	019	1143 W SAN JOSE AVE	FRESNO	CA	93711-3112	MURPHY PATRICK JOANNA M BERTOLU…	1143 W SAN JOSE	FRESNO	CA	93711	FRESNO	91080	FRESNO	004506	45.0600	1127.4727	253574	253574	253574	1997-10-24	1		—	98.7415	99.0893	98.9156	S01	R1AH-C-NB	Single Family Residential Condi…	PERSON
56709213S	06	019	1898 E SOLAR AVE	FRESNO	CA	93720-1497	CLARK PAUL A ROWENA D	1898 E SOLAR	FRESNO	CA	93720	FRESNO	91080	FRESNO	005529	55.2900	747.1396	277737	277737	277737	2008-10-28	1		—	116.3126	116.8896	116.6320	S01	RS-4	Residential Single Family Mediu…	PERSON
31263210S	06	019	5623 W FLORADORA AVE	FRESNO	CA	93722-9096	REINHARDT ERIC W MELANIE L	5623 W FLORADORA	FRESNO	CA	93722	FRESNO	91080	FRESNO	003811	38.1100	557.6127	163277	163277	163277	2010-09-16	1		—	82.1918	82.9109	82.6518	S01	RS-5	Residential Single Family Mediu…	PERSON
57306205	06	019	3936 0 BELLAIRE AVE	CLOVIS	CA	93619-5282	BAIRD STEPHEN L DEBORAH J TRS	3936 BELLAIRE	CLOVIS	CA	93619	FRESNO	91080	FRESNO	005912	59.1200	693.3578	495996	495996	495996	2019-08-20	1		—	112.6347	113.3560	113.0698	S01	R-1	Single Family Residential	TRUST
42817115	06	019	4375 N ANNA ST	FRESNO	CA	93726-3204	SYLVESTER JAMIE JEFFREY PAUL	PO BOX 608	FRESNO	CA	93709-0608	FRESNO	91080	FRESNO	005301	53.0100	711.6938	327725	327725	327725	2022-01-07	1		—	96.5242	97.2714	96.8247	S01	RS-5	Residential Single Family Mediu…	PERSON
46224318	06	019	4805 E TULARE ST	FRESNO	CA	93727-3063	SINGH GURDIP SINGH KULDIP ETAL	1078 N ASH	CLOVIS	CA	93611	FRESNO	91080	FRESNO	002904	29.0400	655.4140	260100	260100	260100	2022-04-11	1		—	94.3253	94.8323	94.5753	S01	O	Office	PERSON
31221029	06	019	1495 N BLYTHE AVE	FRESNO	CA	93722-5602	FLORES MARCO	1495 N BLYTHE	FRESNO	CA	93722	FRESNO	91080	FRESNO	003808	38.0800	11647.9165	217700	217700	217700	1996-08-28	2		—	83.4930	84.6306	83.8833	S01	RR-C-NB	Rural Residential Conditional N…	PERSON
38905413	06	019	2126 GAITHER ST	SELMA	CA	93662-2823	ROQUE MARIA MANUEL	2126 GAITHER	SELMA	CA	93662	FRESNO	92990	SELMA	007002	70.0200	544.3067	104053	104053	104053	2003-08-19	1		—	93.9331	94.2986	94.1185	S01	R-1-7	One Family Zone	PERSON
50421205	06	019	6717 W GIBSON AVE	FRESNO	CA	93723-4019	RUIZ JAIME PEDRO RUIZ JOSHUA LE…	6717 W GIBSON	FRESNO	CA	93723	FRESNO	91080	FRESNO	004218	42.1800	681.2242	314748	314748	314748	2022-12-08	1		—	89.0389	90.0409	89.5896	S01	RS-4	Residential Single Family Mediu…	PERSON
56601224	06	019	7636 N LEONARD AVE	CLOVIS	CA	93619-9028	MASTRIANO MATTHEW A STEPHANIE L	7636 N LEONARD	CLOVIS	CA	93619	FRESNO	91080	FRESNO	005912	59.1200	9762.8734	529085	529085	529085	2016-09-27	1		—	124.3747	126.2849	125.4184	S01	RR	Rural Residential	PERSON
40376205S	06	019	2809 0 E NILES AVE	FRESNO	CA	93720-4959	BADRIZADEH MEHRANGIZ TRE	1895 E CASTLEBROOK DR	FRESNO	CA	93730-3456	FRESNO	91080	FRESNO	005508	55.0800	668.6378	405612	405612	405612	2023-03-20	1		—	110.7030	111.5217	111.1660	S01	RS-3	Residential Single Family Low D…	PERSON
46105601	06	019	3904 E VERRUE AVE	FRESNO	CA	93702-2846	CARILLO PEDRO RAMOS MARIA L	3904 E VERRUE	FRESNO	CA	93702	FRESNO	91080	FRESNO	002602	26.0200	580.2922	215000	215000	215000	2005-02-01	1		—	91.8646	92.1417	92.0168	S01	RS-5	Residential Single Family Mediu…	PERSON
35843116	06	019	3827 GAYNOR CIR	SELMA	CA	93662-2165	ANDERSON PATRICIA L	3827 GAYNOR CIR	SELMA	CA	93662-2165	FRESNO	92990	SELMA	007003	70.0300	794.8426	148203	148203	148203	2004-08-24	1		—	96.4696	96.9547	96.7934	S01	R-1-7	One Family Zone	PERSON