Saved query 43cfc868876b0b2e

Data Explorer

Query the US Nationwide Parcel Dataset

$1.75 / 1,000 records$100 minimum

44/80

Live SQL

SELECT * 
FROM "lr_parcel_us" 
WHERE statefp = '37' 
  AND countyfp = '185'

23,606 matching parcels

Data Preview

parcelid	statefp	countyfp	parcelstate	ownername	owneraddr	countyname	cousubfp	cousubname	tractce	tractname	calcarea	imprvalue	landvalue	agvalue	totalvalue	yearbuilt	numfloors	fldzone	elevmin	elevmax	elevavg	usedesc	ownertype	legaldesc	parceltype	accesstype	iucnclass	placename	placetype	lrversion	taxyear
2990730772	37	185	NC	JOHN HANCOCK LIFE INSURANCE CO	11016 RUSHMORE DR SUITE 200	WARREN	91112	FISHING CREEK	950103	9501.0300	3845911.6425	0	840314	0	840314	0	0	—	50.0204	97.2321	73.6359	VACANT	BUSINESS	BURT 138						2026.2	2024
	37	185	NC	UNKNOWN		WARREN	91112	FISHING CREEK	950103	9501.0300	6270.8843							—	56.2891	72.8349	67.7924		GOVERNMENT		GOVT UNKNOWN	OPEN	OTHER	EMBRO GAME LAND	STATE CONSERVATION AREA	2026.2
	37	185	NC	STATE OF NORTH CAROLINA		WARREN	93896	WARRENTON	950300	9503	10814.3906							—	123.5733	126.8443	124.7646		GOVERNMENT		GOVT STATE	CLOSED	OTHER	CONSERVATION RESERVE ENHANCEMEN…	CONSERVATION EASEMENT	2026.2
	37	185	NC	STATE OF NORTH CAROLINA		WARREN	93896	WARRENTON	950300	9503	4175.7892							—	121.2542	123.7587	122.5782		GOVERNMENT		GOVT STATE	CLOSED	OTHER	CONSERVATION RESERVE ENHANCEMEN…	CONSERVATION EASEMENT	2026.2
	37	185	NC	UNKNOWN		WARREN	91112	FISHING CREEK	950103	9501.0300	3794.2464							—	51.2415	53.9352	52.2934		UNDETERMINED		GOVT UNKNOWN	RESTRICTED	OTHER	NC LAND AND WATER FUND CONSERVA…	STATE OTHER OR UNKNOWN	2026.2
	37	185	NC	STATE OF NORTH CAROLINA		WARREN	91684	JUDKINS	950103	9501.0300	37950.7576							—	74.2138	89.6495	82.9705		GOVERNMENT		GOVT STATE	CLOSED	OTHER	CONSERVATION RESERVE ENHANCEMEN…	CONSERVATION EASEMENT	2026.2
	37	185	NC	STATE OF NORTH CAROLINA		WARREN	91684	JUDKINS	950103	9501.0300	4229.3110							—	74.2563	76.8115	75.3380		GOVERNMENT		GOVT STATE	CLOSED	OTHER	CONSERVATION RESERVE ENHANCEMEN…	CONSERVATION EASEMENT	2026.2
	37	185	NC	STATE OF NORTH CAROLINA		WARREN	91684	JUDKINS	950103	9501.0300	9331.2337							—	78.3783	84.9418	82.3191		GOVERNMENT		GOVT STATE	CLOSED	OTHER	CONSERVATION RESERVE ENHANCEMEN…	CONSERVATION EASEMENT	2026.2
	37	185	NC	STATE OF NORTH CAROLINA		WARREN	93896	WARRENTON	950201	9502.0100	9968.2290							—	107.1038	113.0363	109.4496		GOVERNMENT		GOVT STATE	CLOSED	OTHER	CONSERVATION RESERVE ENHANCEMEN…	CONSERVATION EASEMENT	2026.2
	37	185	NC	STATE OF NORTH CAROLINA		WARREN	93896	WARRENTON	950201	9502.0100	11804.9334							—	111.0862	115.6902	113.2724		GOVERNMENT		GOVT STATE	CLOSED	OTHER	CONSERVATION RESERVE ENHANCEMEN…	CONSERVATION EASEMENT	2026.2
	37	185	NC	UNKNOWN		WARREN	92340	NUTBUSH	950202	9502.0200	4021.3816							—	112.0015	112.3658	112.1324		UNDETERMINED		GOVT UNKNOWN	UNKNOWN	OTHER	WARREN COUNTY OPEN SPACE	LOCAL OTHER OR UNKNOWN	2026.2
	37	185	NC	STATE OF NORTH CAROLINA		WARREN	91684	JUDKINS	950103	9501.0300	45656.5642							—	84.4502	97.8695	92.3311		GOVERNMENT		GOVT STATE	CLOSED	OTHER	CONSERVATION RESERVE ENHANCEMEN…	CONSERVATION EASEMENT	2026.2
	37	185	NC	STATE OF NORTH CAROLINA		WARREN	91112	FISHING CREEK	950103	9501.0300	30603.8358							—	50.6683	56.2593	52.8046		GOVERNMENT		GOVT STATE	CLOSED	OTHER	CONSERVATION RESERVE ENHANCEMEN…	CONSERVATION EASEMENT	2026.2
	37	185	NC	STATE OF NORTH CAROLINA		WARREN	93896	WARRENTON	950201	9502.0100	91161.6169							—	97.5681	116.4781	109.0209		GOVERNMENT		GOVT STATE	CLOSED	OTHER	CONSERVATION RESERVE ENHANCEMEN…	CONSERVATION EASEMENT	2026.2
	37	185	NC	UNKNOWN		WARREN	92688	RIVER	950102	9501.0200	28656.8532							—	89.9205	100.4101	96.1985		UNDETERMINED		GOVT UNKNOWN	UNKNOWN	OTHER	WARREN COUNTY - BUCK SPRING PARK	LOCAL RECREATION AREA	2026.2
	37	185	NC			WARREN	91112	FISHING CREEK	950103	9501.0300	86014.3750	0	0	0	0	0	0	—	72.7717	90.3072	82.1415									2026.2	2024
	37	185	NC	STATE OF NORTH CAROLINA		WARREN	93896	WARRENTON	950300	9503	156275.7597							—	93.8635	121.2453	110.1023		GOVERNMENT		GOVT STATE	CLOSED	OTHER	CONSERVATION RESERVE ENHANCEMEN…	CONSERVATION EASEMENT	2026.2
	37	185	NC	UNKNOWN		WARREN	93896	WARRENTON	950300	9503	2648.9940							—	104.7233	114.3641	111.8705		UNDETERMINED		GOVT UNKNOWN	UNKNOWN	OTHER	NC LAND AND WATER FUND PROJECT	STATE OTHER OR UNKNOWN	2026.2
	37	185	NC	UNKNOWN		WARREN	91684	JUDKINS	950103	9501.0300	6416.2897							—	78.7190	84.5892	81.9885		GOVERNMENT		GOVT UNKNOWN	OPEN	OTHER	EMBRO GAME LAND	STATE CONSERVATION AREA	2026.2
	37	185	NC	STATE OF NORTH CAROLINA		WARREN	91684	JUDKINS	950103	9501.0300	18930.1361							—	79.9672	88.2366	86.0100		GOVERNMENT		GOVT STATE	UNKNOWN	V	EMBRO GAME LAND DEDICATED NATUR…	CONSERVATION EASEMENT	2026.2
	37	185	NC	STATE OF NORTH CAROLINA		WARREN	93896	WARRENTON	950300	9503	73018.5226							—	111.3875	124.7284	119.5615		GOVERNMENT		GOVT STATE	CLOSED	OTHER	CONSERVATION RESERVE ENHANCEMEN…	CONSERVATION EASEMENT	2026.2
	37	185	NC	UNKNOWN		WARREN	93896	WARRENTON	950300	9503	21465.7490							—	80.6436	99.8268	86.0568		UNDETERMINED		GOVT UNKNOWN	UNKNOWN	OTHER	NC LAND AND WATER FUND PROJECT	STATE OTHER OR UNKNOWN	2026.2
	37	185	NC	UNKNOWN		WARREN	91112	FISHING CREEK	950103	9501.0300	192019.3246							—	51.3277	63.4968	56.7498		UNDETERMINED		GOVT UNKNOWN	UNKNOWN	OTHER	NC LAND AND WATER FUND PROJECT	STATE OTHER OR UNKNOWN	2026.2
	37	185	NC	UNKNOWN		WARREN	91112	FISHING CREEK	950103	9501.0300	40635.7325							—	48.7526	57.3451	51.8358		UNDETERMINED		GOVT UNKNOWN	RESTRICTED	OTHER	NC LAND AND WATER FUND CONSERVA…	STATE OTHER OR UNKNOWN	2026.2
	37	185	NC	UNKNOWN		WARREN	93896	WARRENTON	950300	9503	61936.8763							—	83.4366	113.8875	101.4773		UNDETERMINED		GOVT UNKNOWN	UNKNOWN	OTHER	NC LAND AND WATER FUND PROJECT	STATE OTHER OR UNKNOWN	2026.2