Saved query a4a41ec187ecd7fa

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 = '27' 
  AND countyfp = '123'

172,310 matching parcels

Data Preview

parcelid	statefp	countyfp	parceladdr	parcelcity	parcelstate	parcelzip	ownername	owneraddr	ownercity	ownerstate	ownerzip	countyname	cousubfp	cousubname	tractce	tractname	calcarea	imprvalue	landvalue	totalvalue	saleamt	saledate	numbldgs	numunits	yearbuilt	numfloors	bldgsqft	bedrooms	firmid	firmdate	fldzone	zonesubty	elevmin	elevmax	elevavg	usecode	usedesc	taxacres	ownertype	naicscode	legaldesc	placename	placetype	heating	heatfuel	cooling	siding	taxyear	taxdistrict
052823120114	27	123	203 MONTROSE PL	SAINT PAUL	MN	55104	EDWARD PIECHOWSKI SEAN RYAN	203 MONTROSE PL	SAINT PAUL	MN	55104	Ramsey	58000	St. Paul	043002	430.0200	685.5061	435200	102000	537200	295900	2013-12-23	2	1	1936	2	1863	3	27123C	2026-01-19	X	AREA OF MINIMAL FLOOD HAZARD	257.3143	261.6227	260.0071	510	SINGLE FAMILY DWELLING, PLATTED…	0.1700	PERSON	721110	DESNOYER PARK RAMSEY CO MINN S …	THE MONTROSE MODERNE	HOTEL	UNDETERMINED	UNDETERMINED	OTHER	STUCCO	2027	St. Paul School District
312922431415	27	123	500 ROBERT ST N 509	SAINT PAUL	MN	55101	MICHAEL J BURLING GILLIAN E BUR…	500 ROBERT ST N UNIT 509	SAINT PAUL	MN	55101	Ramsey	58000	St. Paul	034204	342.0400	2624.3856	176200	1000	177200	185000	2018-08-30	1	1	1916	1	1174	1	27123C	2026-01-19	X	AREA OF MINIMAL FLOOD HAZARD	237.6002	241.9330	239.9998	550	CONDO	0.0300	PERSON	6239	CIC NO 535 ROSSMOR UNIT NO 509	GOLDEN GARTERS BURLESQUE REVUE	MUSIC_VENUE	UNDETERMINED	UNDETERMINED	OTHER	BRICK	2027	St. Paul School District
122822230293	27	123	2368 LONDIN LN E	MAPLEWOOD	MN	55119	MICHELE P GELLERMAN	2368 LONDIN LN UNIT 46	MAPLEWOOD	MN	55119	Ramsey	40382	Maplewood	042504	425.0400	81102.8555	139200	30000	169200	69900	1998-02-27	213	1	1972	2	1320	3	27123C	2026-01-19	X	AREA OF MINIMAL FLOOD HAZARD	292.5232	309.9556	301.1114	574	TOWNHOME - TICO	0.0400	PERSON	712190	CONDO NO 294 MCKNIGHT TOWNHOME …	CRESTVIEW PARK	PARK	UNDETERMINED	UNDETERMINED	OTHER	ALUM/VINYL	2027	North St. Paul/Maplewood/Oakdal…
312922440659	27	123	406 WACOUTA ST 308	SAINT PAUL	MN	55101	SUSAN HUGHES	406 WACOUTA ST 308	SAINT PAUL	MN	55101	Ramsey	58000	St. Paul	034203	342.0299	3957.4485	185200	1000	186200	185000	2026-01-30	2	1	1905	1	720	1	27123C	2026-01-19	X	AREA OF MINIMAL FLOOD HAZARD	229.8363	231.9155	231.0534	550	CONDO	0.0200	PERSON	713940	CIC NO 687 RIVER PK LOFTS CONDO…	ZUMBA ZIN DRINA LA CHICA	GYM	UNDETERMINED	UNDETERMINED	OTHER	BRICK	2027	St. Paul School District
342922120062	27	123	1604 MARGARET ST	SAINT PAUL	MN	55106	CHRISTINA ANN HELGESON GABRIEL …	1604 MARGARET ST	SAINT PAUL	MN	55106	Ramsey	58000	St. Paul	034602	346.0200	454.4092	193600	37500	231100	210000	2023-10-24	1	1	1925	1	1037	3	27123C	2026-01-19	X	AREA OF MINIMAL FLOOD HAZARD	280.6968	283.8527	282.8988	510	SINGLE FAMILY DWELLING, PLATTED…	0.1100	PERSON	2361	G V BACON S ADDITION LOT 14 BLK…			UNDETERMINED	UNDETERMINED	OTHER	ASBESTOS	2027	St. Paul School District
352923130203	27	123	505 GROTTO ST N	SAINT PAUL	MN	55104	DANMARK PROPERTIES LLC	7100 NORTHLAND CIR STE 410	SAINT PAUL	MN	55104	Ramsey	58000	St. Paul	032500	325	371.6295	197600	25000	222600	145000	2008-10-31	1	2	1898	2	2176	6	27123C	2026-01-19	X	AREA OF MINIMAL FLOOD HAZARD	269.2291	269.8505	269.5202	520	TWO FAMILY DWELLING - UP/DWN	0.0900	BUSINESS	5312	SYNDICATE NO 1 ADDITION N 1 2 O…			UNDETERMINED	UNDETERMINED	CENTRAL AIR	BRICK	2027	St. Paul School District
042823110113	27	123	1641 HAGUE AVE	SAINT PAUL	MN	55104	KATELYN MARIAH	1641 HAGUE AVE	SAINT PAUL	MN	55104	Ramsey	58000	St. Paul	035000	350	452.3596	248700	74900	323600	104900	2025-09-11	1	1	1909	2	1630	4	27123C	2026-01-19	X	AREA OF MINIMAL FLOOD HAZARD	280.7614	281.5057	281.2579	510	SINGLE FAMILY DWELLING, PLATTED…	0.1100	PERSON	81391	SCHROEDER S ADDITION TO THE CI …			HOT WATER	UNDETERMINED	CENTRAL AIR	ALUM/VINYL	2027	St. Paul School District
282922440017	27	123	824 ATLANTIC ST	SAINT PAUL	MN	55106	ZHENG RENTAL PROPERTIES LLC	1570 FALCON DR	SAINT PAUL	MN	55106	Ramsey	58000	St. Paul	031701	317.0100	514.4398	181700	26200	207900	54000	2011-09-15	1	1	1978	1	828	3	27123C	2026-01-19	X	AREA OF MINIMAL FLOOD HAZARD	264.9663	267.0179	266.2028	510	SINGLE FAMILY DWELLING, PLATTED…	0.1300	BUSINESS	5323	MESSERLI ESCHBACH S ADDITION LO…			UNDETERMINED	UNDETERMINED	CENTRAL AIR	FRAME	2027	St. Paul School District
202922410101	27	123	773 COTTAGE AVE E	SAINT PAUL	MN	55106	JANE M BARNARD	773 COTTAGE AVE E	SAINT PAUL	MN	55106	Ramsey	58000	St. Paul	030602	306.0200	479.8308	186800	35000	221800	125000	2000-01-21	2	1	1928	2	1190	3	27123C	2026-01-19	X	AREA OF MINIMAL FLOOD HAZARD	272.4646	273.5564	272.8666	510	SINGLE FAMILY DWELLING, PLATTED…	0.1200	PERSON		KING S ARCADE PARK LOT 21 BLK 2			UNDETERMINED	UNDETERMINED	OTHER	STUCCO	2027	St. Paul School District
072822340007	27	123	269 CURTICE ST W	SAINT PAUL	MN	55107	LISA L VELASCO	269 CURTICE ST W	SAINT PAUL	MN	55107	Ramsey	58000	St. Paul	037000	370	244.5642	206700	14600	221300	142900	2004-04-03	1	1	1890	2	1137	3	27123C	2026-01-19	X	AREA OF MINIMAL FLOOD HAZARD	290.7700	291.5452	291.3068	510	SINGLE FAMILY DWELLING, PLATTED…	0.0600	PERSON		SWEENEY S ADDITION TO WEST ST E…			UNDETERMINED	UNDETERMINED	OTHER	STUCCO	2027	St. Paul School District
122823440039	27	123	858 CHIPPEWA AVE	SAINT PAUL	MN	55107	KATIE MURPHY SERGEI HANKA	858 CHIPPEWA AVE	SAINT PAUL	MN	55107	Ramsey	58000	St. Paul	037000	370	696.9626	296100	122800	418900	440000	2024-05-04	2	1	1939	2	1704	3	27123C	2026-01-19	X	AREA OF MINIMAL FLOOD HAZARD	300.5761	301.9223	301.2634	510	SINGLE FAMILY DWELLING, PLATTED…	0.1700	PERSON		BANNING OLIVIER S ADDITION S 25…			UNDETERMINED	UNDETERMINED	OTHER	ALUM/VINYL	2027	St. Paul School District
032823130045	27	123	1305 PORTLAND AVE	SAINT PAUL	MN	55104	MARGARET MCDONALD JESSE FOOLBEAR	1305 PORTLAND AVE	SAINT PAUL	MN	55104	Ramsey	58000	St. Paul	035300	353	556.5996	333300	86400	419700	370000	2020-04-06	2	1	1936	2	1483	2	27123C	2026-01-19	X	AREA OF MINIMAL FLOOD HAZARD	283.9010	285.3128	284.5705	510	SINGLE FAMILY DWELLING, PLATTED…	0.1400	PERSON		ANNA E RAMSEY ADD ENLG TO ST P …			UNDETERMINED	UNDETERMINED	OTHER	FRAME	2027	St. Paul School District
092823120059	27	123	1740 BERKELEY AVE	SAINT PAUL	MN	55105	BRENDAN R RYLANDER LAURA H RYLA…	1740 BERKELEY AVE	SAINT PAUL	MN	55105	Ramsey	58000	St. Paul	036400	364	473.7421	281000	136000	417000	322000	2016-08-22	2	1	1922	1	1123	4	27123C	2026-01-19	X	AREA OF MINIMAL FLOOD HAZARD	281.7429	282.3398	282.0782	510	SINGLE FAMILY DWELLING, PLATTED…	0.1200	PERSON		MACALESTER VILLAS LOT 11 BLK 4			HOT WATER	UNDETERMINED	CENTRAL AIR	ASBESTOS	2027	St. Paul School District
052922240084	27	123	2880 COSTA LN	LITTLE CANADA	MN	55117	SHUN MING CHAN VINA Y B CHAN	2880 COSTA LN	LITTLE CANADA	MN	55117	Ramsey	37502	Little Canada	042102	421.0200	928.9816	378700	76500	455200	173500	1995-07-01	1	1	1994	2	2244	4	27123C	2026-01-19	X	AREA OF MINIMAL FLOOD HAZARD	275.4833	276.4984	276.1070	510	SINGLE FAMILY DWELLING, PLATTED…	0.2300	PERSON		COSTA ESTATES THIRD ADDITION LO…			UNDETERMINED	UNDETERMINED	OTHER	ALUM/VINYL	2027	Roseville School District
292922240164	27	123	970 BURR ST	SAINT PAUL	MN	55130	JEMAL HASSEN	5600 W LAKE ST	SAINT PAUL	MN	55130	Ramsey	58000	St. Paul	030900	309	459.6649	219200	25000	244200	47250	2008-06-12	1	2	1894	2	1829	4	27123C	2026-01-19	X	AREA OF MINIMAL FLOOD HAZARD	255.9418	258.7598	258.1664	520	TWO FAMILY DWELLING - UP/DWN	0.1100	PERSON		FAIRVIEW ADDITION LOT 12 BLK 14			UNDETERMINED	UNDETERMINED	CENTRAL AIR	ALUM/VINYL	2027	St. Paul School District
362923340043	27	123	460 IGLEHART AVE	SAINT PAUL	MN	55103	ANDREW A LATHAM WENDY A WEBER	460 IGLEHART AVE	SAINT PAUL	MN	55103	Ramsey	58000	St. Paul	034000	340	727.7222	524200	56300	580500	447500	2004-10-29	2	1	1896	2	2334	3	27123C	2026-01-19	X	AREA OF MINIMAL FLOOD HAZARD	281.1237	282.2118	281.8484	510	SINGLE FAMILY DWELLING, PLATTED…	0.1800	PERSON		MACKUBIN AND MARSHALL S ADDITI …			HOT WATER	UNDETERMINED	CENTRAL AIR	ASBESTOS	2027	St. Paul School District
012823140322	27	123	291 7TH ST W 1107	SAINT PAUL	MN	55102	NATH MANAGEMENT INC	900 AMERICAN BLVD STE 300	SAINT PAUL	MN	55102	Ramsey	58000	St. Paul	035900	359	1045.7251	111000	1000	112000			1	1	1982	1	676	1	27123C	2026-01-19	X	AREA OF MINIMAL FLOOD HAZARD	236.8519	237.4696	237.3759	550	CONDO	0.0200	BUSINESS	6216	CIC NO 538 IRVINE PK TOWERS II …	MPERIAL HEALTH	MEDICAL_SERVICE	UNDETERMINED	ELECTRIC	CENTRAL AIR	BRICK	2027	St. Paul School District
202923140037	27	123	2175 HENDON AVE	SAINT PAUL	MN	55108	TY LILJA AMY LILJA	2175 HENDON AVE	SAINT PAUL	MN	55108	Ramsey	58000	St. Paul	030100	301	650.1043	503800	143000	646800	480000	2017-02-15	2	1	1924	1	2225	3	27123C	2026-01-19	X	AREA OF MINIMAL FLOOD HAZARD	290.0421	294.9635	293.2235	510	SINGLE FAMILY DWELLING, PLATTED…	0.1600	PERSON		ST ANTHONY PARK NORTH EX N 5O F…			UNDETERMINED	UNDETERMINED	OTHER	STUCCO	2027	St. Paul School District
162823320174	27	123	2048 VILLARD AVE	SAINT PAUL	MN	55116	JEREMY NEY	192 PARK PL	SAINT PAUL	MN	55116	Ramsey	58000	St. Paul	037601	376.0100	756.7112	285500	96600	382100	339900	2022-07-14	2	1	1954	1	1775	3	27123C	2026-01-19	X	AREA OF MINIMAL FLOOD HAZARD	253.5629	254.4468	254.0893	510	SINGLE FAMILY DWELLING, PLATTED…	0.1900	PERSON		MURRAY LANE ADDITION PLAT 3 LOT…			UNDETERMINED	UNDETERMINED	OTHER	ALUM/VINYL	2027	St. Paul School District
232822410007	27	123	1464 POINT DOUGLAS RD S	SAINT PAUL	MN	55119	TOONMAJ N XIONG KONGMANY P XIONG	1464 POINT DOUGLAS RD S	SAINT PAUL	MN	55119	Ramsey	58000	St. Paul	037403	374.0299	1559.7179	306400	19000	325400	189000	2015-02-20	1	1	1964	1	1300	3	27123C	2026-01-19	X	AREA OF MINIMAL FLOOD HAZARD	230.4164	233.6332	232.3064	510	SINGLE FAMILY DWELLING, PLATTED…	0.1300	PERSON		BACHMAN ADDITION LOTS 5 6 AND L…			HOT WATER	UNDETERMINED	CENTRAL AIR	STUCCO	2027	St. Paul School District
232923230092	27	123	1023 NEBRASKA AVE W	SAINT PAUL	MN	55117	NEAL CALLINAN TANA CALLINAN	1023 NEBRASKA AVE W	SAINT PAUL	MN	55117	Ramsey	58000	St. Paul	030300	303	1324.9435	384500	84000	468500	532000	2025-12-04	2	1	1938	1	1147	2	27123C	2026-01-19	X	AREA OF MINIMAL FLOOD HAZARD	278.2777	281.0860	279.6674	510	SINGLE FAMILY DWELLING, PLATTED…	0.3200	PERSON		COMO E 1OO FT OF W 2O6 FT OF S …			UNDETERMINED	UNDETERMINED	OTHER	BRICK	2027	St. Paul School District
022922140012	27	123	2929 MCKNIGHT RD N	MAPLEWOOD	MN	55109	THOMAS E NICKLES TR JOANN H NIC…	2929 MCKNIGHT RD N	MAPLEWOOD	MN	55109	Ramsey	40382	Maplewood	042401	424.0100	853.3726	305200	66100	371300	228000	2003-11-21	1	1	1968	1	1384	3	27123C	2026-01-19	X	AREA OF MINIMAL FLOOD HAZARD	300.3161	301.4992	301.0271	510	SINGLE FAMILY DWELLING, PLATTED…	0.2500	TRUST		ROBERT TILSEN S MPLWD HGTS 4 LO…			UNDETERMINED	UNDETERMINED	OTHER	ALUM/VINYL	2027	North St. Paul/Maplewood/Oakdal…
092823230060	27	123	1944 PALACE AVE	SAINT PAUL	MN	55105	ANN MARIE HENDERSON	1944 PALACE AVE	SAINT PAUL	MN	55105	Ramsey	58000	St. Paul	036300	363	473.5572	315900	123600	439500	347400	2023-07-17	2	1	1924	2	1420	3	27123C	2026-01-19	X	AREA OF MINIMAL FLOOD HAZARD	283.8139	284.3995	284.1611	510	SINGLE FAMILY DWELLING, PLATTED…	0.1200	PERSON		HANKEE S CLEVELAND VIEW LOT 2 B…			HOT WATER	UNDETERMINED	OTHER	STUCCO	2027	St. Paul School District
202923310067	27	123	1372 KESTON ST	SAINT PAUL	MN	55108	ROBB M LAGESON JANET D LAGESON	1372 KESTON ST	SAINT PAUL	MN	55108	Ramsey	58000	St. Paul	030100	301	1310.5557	419200	141000	560200	340000	2010-05-27	1	1	1939	1	1742	3	27123C	2026-01-19	X	AREA OF MINIMAL FLOOD HAZARD	282.1184	287.8779	282.9007	510	SINGLE FAMILY DWELLING, PLATTED…	0.4000	PERSON		ST ANTHONY PARK NORTH NLY 27 FT…			UNDETERMINED	UNDETERMINED	OTHER	BRICK	2027	St. Paul School District
342922410080	27	123	1675 EUCLID ST	SAINT PAUL	MN	55106	CHAD CHAN	1675 EUCLID ST	SAINT PAUL	MN	55106	Ramsey	58000	St. Paul	034701	347.0100	646.2757	209000	48400	257400	104000	2012-09-28	2	1	1955	1	984	3	27123C	2026-01-19	X	AREA OF MINIMAL FLOOD HAZARD	283.9317	285.4366	285.0350	510	SINGLE FAMILY DWELLING, PLATTED…	0.1600	PERSON		BISANZ BROS MEADOW BROOK E 4O F…			UNDETERMINED	UNDETERMINED	OTHER	ALUM/VINYL	2027	St. Paul School District