Saved query 2012187c4ab3ff5c

Data Explorer

Query the US Nationwide Parcel Dataset

$1.75 / 1,000 records$100 minimum

39/80

Live SQL

SELECT * 
FROM "lr_parcel_us" 
WHERE statefp = '26' 
  AND countyfp = '049'

54,919 matching parcels

Data Preview

parcelid	statefp	countyfp	parceladdr	parcelcity	parcelstate	parcelzip	ownername	owneraddr	ownercity	ownerstate	ownerzip	countyname	cousubfp	cousubname	tractce	tractname	calcarea	imprvalue	landvalue	numbldgs	numunits	yearbuilt	numfloors	firmid	firmdate	fldzone	zonesubty	elevmin	elevmax	elevavg	usecode	usedesc	zoningcode	zoningdesc	taxacres	ownertype	naicscode	legaldesc	parceltype	accesstype	placename	placetype	lrversion	taxdistrict
41-17-376-016	26	049	1301 PINGREE AVE	FLINT	MI	48503	CITY OF FLINT	1101 S SAGINAW ST	FLINT	MI	48502	GENESEE	29000	FLINT	003200	32	59041.8821		750192	1	1	0	14400	26049C	2025-12-18	X	AREA OF MINIMAL FLOOD HAZARD	229.0165	233.2755	230.8396	201	COMMERCIAL	OS	OPEN SPACE	14.3520	GOVERNMENT	7212	UNPLATTED. THAT PART OF TH SE 1…	GOVT LOCAL	OPEN	BRENNAN PARK	PARK	2026.2	25010
46-35-308-001	26	049	COOPER AVE	FLINT	MI	48504	CITY OF FLINT	1101 S SAGINAW ST	FLINT	MI	48502	GENESEE	29000	FLINT	000700	7	46864.1719		622220		0	0	0	26049C	2025-12-18	X	AREA OF MINIMAL FLOOD HAZARD	232.7160	235.9582	234.6559	202	COMMERCIAL	OS	OPEN SPACE	23.1400	GOVERNMENT	7212	WASENA SUBDIVISION LOTS 200 TO …	GOVT LOCAL	OPEN	SARVIS PARK	PARK	2026.2	25010
41-07-305-004	26	049	1011 E FIFTH AVE	FLINT	MI	48503	1910 FLINT HOLDING LLC	1357 E LINCOLN AVE	MADISON HEIGHTS	MI	48071	GENESEE	29000	FLINT	013600	136	6219.7564		113757	1	1	0	25240	26049C	2025-12-18	X	AREA OF MINIMAL FLOOD HAZARD	217.1379	218.9963	218.2644	201	COMMERCIAL	CC	CITY CORRIDOR	1.7410	BUSINESS	6216	PART OF SEC 2, INDIAN RESERVATI…			MCNAUGHTON-MCKAY ELECTRIC COMPA…	HOME_SERVICE	2026.2	25010
41-18-154-027	26	049	720 CHURCH ST	FLINT	MI	48503	HOWARD HOMES 4 YOU LLC	6298 PINECROFT CT	FLINT	MI	48532	GENESEE	29000	FLINT	002800	28	827.6887		37984	1	1	0	2996	26049C	2025-12-18	X	AREA OF MINIMAL FLOOD HAZARD	227.5026	228.0507	227.7907	201	COMMERCIAL	DE	DOWNTOWN EDGE	0.2180	BUSINESS	5313	LOTS 6 & 8 EXC WLY 66 FT; ALSO …			DEBRA JACKSON, REALTOR	REAL_ESTATE_SERVICE	2026.2	25010
41-30-206-077	26	049	325 W ATHERTON RD	FLINT	MI	48507	ATTN LEASE ADMIN	9900 BREN RD MN008-W310	HOPKINS	MN	55343	GENESEE	29000	FLINT	003500	35	38926.7385		187392	1	1	0	208702	26049C	2025-12-18	X	AREA OF MINIMAL FLOOD HAZARD	232.8491	234.5455	233.8948	301	INDUSTRIAL	CE	COMMERCE & EMPLOYMENT	9.1100	PERSON	45611	PART OF NE 1/4 OF SEC 30, T7N, …			DIPLOMAT SPECIALTY PHARMACY HEA…	PHARMACY	2026.2	25010
46-34-226-011	26	049	4901 CLIO RD	FLINT	MI	48504	HALLWOOD PLAZA LLC	280 CHESTNUT ST	NEWARK	NJ	7105	GENESEE	29000	FLINT	000500	5	115512.5928		437519	1	1	0	224263	26049C	2025-12-18	X	AREA OF MINIMAL FLOOD HAZARD	233.4309	236.8081	234.8466	201	COMMERCIAL	CC	CITY CORRIDOR	24.9830	BUSINESS	531130	UNPLATTED PART OF NE 1/4 OF NE …			CUBESMART SELF STORAGE	SELF-STORAGE FACILITY	2026.2	25210
40-01-202-033	26	049	301 E MC CLELLAN ST	FLINT	MI	48505	BOARD OF EDUCATION	923 E KEARSLEY ST	FLINT	MI	48502	GENESEE	29000	FLINT	001100	11	27030.7316		28332		0	0	0	26049C	2025-12-18	X	AREA OF MINIMAL FLOOD HAZARD	244.8334	248.2612	247.0894	201	COMMERCIAL	MR-2	MIXED RESIDENTIAL	7.0830	PERSON	611110	HILLCREST. LOTS 301, 303, 305, …			GARFIELD SCHOOL	ELEMENTARY_SCHOOL	2026.2	25010
47-31-181-019	26	049	4317 CARLTON ST	FLINT	MI	48505	WEST ZYON	30 S DEAN AVE	TRENTON	NJ	8618	GENESEE	29000	FLINT	002000	20	537.1691	10384	4417	1	1	1912	0	26049C	2025-12-18	X	AREA OF MINIMAL FLOOD HAZARD	236.6818	239.5620	238.4260	401	RESIDENTIAL	GI-1	GREEN INNOVATION	0.1240	PERSON		MAPLEWOOD LOT 186					2026.2	25010
41-20-455-013	26	049	3616 DEARBORN ST	FLINT	MI	48507	WALDRON HELEN & YUILLE JANICE	1197 BURT LEAF LANE	GRAND BLANC	MI	48439	GENESEE	29000	FLINT	003300	33	647.4519	48146	12084	1	1	1957	0	26049C	2025-12-18	X	AREA OF MINIMAL FLOOD HAZARD	237.8470	238.5700	238.3131	401	RESIDENTIAL	TN-2	TRADITIONAL NEIGHBORHOOD	0.1450	PERSON		FARNAMWOOD NO. 2 LOT 738 EXC NL…					2026.2	25010
40-13-376-019	26	049	1616 CRESCENT DR	FLINT	MI	48503	BURHANS ZACHARY & WF SUSAN	1616 CRESCENT DR	FLINT	MI	48503	GENESEE	29000	FLINT	003700	37	1412.5920	182476	44349	1	1	1920	0	26049C	2025-12-18	X	AREA OF MINIMAL FLOOD HAZARD	236.8157	238.4007	237.8070	401	RESIDENTIAL	TN-1	TRADITIONAL NEIGHBORHOOD	0.3560	PERSON		KNOB HILL SUBDIVISION LOT 22 EX…					2026.2	25010
46-25-203-002	26	049	210 E YORK AVE	FLINT	MI	48505	EDWARDS PAULA J	510 WHITE WILLOW DR	FLINT	MI	48506	GENESEE	29000	FLINT	000200	2	432.5080	25038	3467	1	1	1965	0	26049C	2025-12-18	X	AREA OF MINIMAL FLOOD HAZARD	238.3820	238.8269	238.6240	401	RESIDENTIAL	GI-1	GREEN INNOVATION	0.0960	PERSON		ARDMORE LOT 80					2026.2	25010
41-18-252-018	26	049	E COURT ST	FLINT	MI	48503	MI STATE HIGHWAY COMMISSION	E COURT ST	FLINT	MI	48503	GENESEE	29000	FLINT	002900	29	8543.7046				0	0	0	26049C	2025-12-18	X	AREA OF MINIMAL FLOOD HAZARD	225.2227	233.2583	228.2916	202	COMMERCIAL	NONE	NONE	0	PERSON	5313	THAYRE AND EDDY'S ADDITION. LOT…			SUPPORT AI 82165455236656544556	REAL_ESTATE_SERVICE	2026.2	25010
46-25-251-025	26	049	229 E LORADO AVE	FLINT	MI	48505	JAVEY TAMMI	8213 BEACONCREST DR	AUSTIN	TX	78748	GENESEE	29000	FLINT	000200	2	388.4939	8047	3467	1	1	1950	0	26049C	2025-12-18	X	AREA OF MINIMAL FLOOD HAZARD	237.6514	238.5174	238.1376	401	RESIDENTIAL	GI-1	GREEN INNOVATION	0.0960	PERSON		ARDMORE LOT 688					2026.2	25010
40-01-104-013	26	049	401 W DEWEY ST	FLINT	MI	48505	VINCENT BRYAN L	401 W DEWEY ST	FLINT	MI	48505	GENESEE	29000	FLINT	001000	10	419.7333	18124	5000	1	1	1936	0	26049C	2025-12-18	X	AREA OF MINIMAL FLOOD HAZARD	238.9592	239.4664	239.3229	401	RESIDENTIAL	GN-1	GREEN NEIGHBORHOOD	0.1010	PERSON		CROSS ACRES LOT 39					2026.2	25010
41-29-151-056	26	049	4529 PENGELLY RD	FLINT	MI	48507	GROVES SHAWN J	2044 KINGSWOOD DR	FLINT	MI	48507	GENESEE	29000	FLINT	003500	35	414.9392	40570	11250	1	1	1948	0	26049C	2025-12-18	X	AREA OF MINIMAL FLOOD HAZARD	238.8217	239.2283	239.0075	401	RESIDENTIAL	TN-2	TRADITIONAL NEIGHBORHOOD	0.1030	PERSON		DIXIELAND LOT 408					2026.2	25010
40-01-302-012	26	049	320 W DAYTON ST	FLINT	MI	48505	GENESEE COUNTY LAND BANK AUTHOR…	452 S SAGINAW ST 2ND FL	FLINT	MI	48502	GENESEE	29000	FLINT	001000	10	415.8419	17644	5833	1	2	1928	0	26049C	2025-12-18	X	AREA OF MINIMAL FLOOD HAZARD	236.0370	237.2803	236.8406	401	RESIDENTIAL	GN-1	GREEN NEIGHBORHOOD	0.1080	PERSON		INDIAN VILLAGE NO. 1. LOT 644.					2026.2	25010
40-11-231-021	26	049	2302 MALLERY ST	FLINT	MI	48504	GENESEE COUNTY LAND BANK AUTHOR…	452 S SAGINAW ST 2ND FL	FLINT	MI	48502	GENESEE	29000	FLINT	001200	12	476.0938	18681	5000	1	1	1929	0	26049C	2025-12-18	X	AREA OF MINIMAL FLOOD HAZARD	235.3261	235.9681	235.7177	401	RESIDENTIAL	TN-2	TRADITIONAL NEIGHBORHOOD	0.1150	PERSON		MODERN HOUSING CORPORATION ADDI…					2026.2	25010
40-11-379-014	26	049	2408 ALTOONA ST	FLINT	MI	48504	VAUGHN LORETA C	11470 HERRINGTON RD	BYRON	MI	48418	GENESEE	29000	FLINT	001600	16	615.8612	68379	16574	1	1	1928	0	26049C	2025-12-18	X	AREA OF MINIMAL FLOOD HAZARD	226.9583	227.9828	227.5640	401	RESIDENTIAL	TN-2	TRADITIONAL NEIGHBORHOOD	0.1830	PERSON		MODERN HOUSING CORPORATION ADDI…					2026.2	25010
40-25-277-028	26	049	1044 HURON ST	FLINT	MI	48507	JUDGE TAMARA & BURNS JEREMY	1044 HURON ST	FLINT	MI	48507	GENESEE	29000	FLINT	013500	135	338.4088	30552	5279	1	1	1924	0	26049C	2025-12-18	X	AREA OF MINIMAL FLOOD HAZARD	233.3710	233.9574	233.5665	401	RESIDENTIAL	GN-2	GREEN NEIGHBORHOOD	0.0810	PERSON		VIRGINIA PLACE SUBDIVISION LOT …					2026.2	25010
41-17-380-030	26	049	1309 LIPPINCOTT BLVD	FLINT	MI	48503	CATES SHARON	1309 LIPPINCOTT BLVD	FLINT	MI	48503	GENESEE	29000	FLINT	003200	32	427.7315	32818	4312	1	1	1921	0	26049C	2025-12-18	X	AREA OF MINIMAL FLOOD HAZARD	229.2404	229.8140	229.4506	401	RESIDENTIAL	TN-2	TRADITIONAL NEIGHBORHOOD	0.1019	PERSON		LUCY-MASON-HOWARD PLAT LOT 96.					2026.2	25010
40-14-252-055	26	049	709 FRANK ST	FLINT	MI	48504	WILLIAMS EUGENE & WILLIAMS RO…	709 FRANK ST	FLINT	MI	48504	GENESEE	29000	FLINT	001600	16	516.0137	53301	13110	1	1	1927	0	26049C	2025-12-18	X	AREA OF MINIMAL FLOOD HAZARD	219.2423	219.9136	219.6132	401	RESIDENTIAL	TN-2	TRADITIONAL NEIGHBORHOOD	0.1260	PERSON		MODERN HOUSING CORPORATION ADDI…					2026.2	25010
46-25-204-015	26	049	354 E YORK AVE	FLINT	MI	48505	BLAYNE TOM	5003 MONTAIR	LAKEWOOD	CA	90712	GENESEE	29000	FLINT	000200	2	430.5714	18956	3467	1	1	1950	0	26049C	2025-12-18	X	AREA OF MINIMAL FLOOD HAZARD	241.3758	241.8609	241.7174	401	RESIDENTIAL	GI-1	GREEN INNOVATION	0.0960	PERSON		PROPERTY EXEMPT FROM AD VALOREM…					2026.2	25010
41-04-326-001	26	049	2710 BRANCH RD	FLINT	MI	48506	DIONNE AARON	PO BOX 761	OXFORD	MI	48371	GENESEE	29000	FLINT	002700	27	462.0996	29994	7551	1	1	1954	0	26049C	2025-12-18	X	AREA OF MINIMAL FLOOD HAZARD	230.2829	231.1342	230.5957	401	RESIDENTIAL	TN-2	TRADITIONAL NEIGHBORHOOD	0.1070	PERSON		THRIFT ADDITION NO. 1 LOT 687					2026.2	25010
41-19-435-003	26	049	208 MADISON AVE	FLINT	MI	48503	LIKE NEW HOMES LLC	920 N VERNON AVE	FLINT	MI	48506	GENESEE	29000	FLINT	003800	38	372.8619	16586	4000	1	1	1915	0	26049C	2025-12-18	X	AREA OF MINIMAL FLOOD HAZARD	231.5567	232.3209	232.0626	401	RESIDENTIAL	MR-1	MIXED RESIDENTIAL	0.0920	BUSINESS		COLLINGWOOD LOT 172					2026.2	25010
41-08-429-005	26	049	2322 GOLD AVE	FLINT	MI	48503	SOLIS AMELIA	2322 GOLD AVE	FLINT	MI	48503	GENESEE	29000	FLINT	003000	30	501.3674	61155	18992	1	1	1949	0	26049C	2025-12-18	X	AREA OF MINIMAL FLOOD HAZARD	230.0329	230.4768	230.2873	401	RESIDENTIAL	TN-2	TRADITIONAL NEIGHBORHOOD	0.1270	PERSON		WOODLAWN PARK NO. 3 LOT 1534					2026.2	25010