Riverfront Agricultural
For Sale
Contact for pricing
Pending
506 Queen Anne Rd, Amsterdam, NY 12010
112-acre property with Mohawk River frontage, barns, greenhouses, ponds, and on-site well and utilities.
Property SizeContact for details
Lot Size112.00 Acres
Days on Market151
Property Features for 506 Queen Anne Rd
General Information
Standard status
Pending
Lot size
112.00 Acres
Property subtype
Industrial, Land
Site & Location
Road Access
Yes
Utilities to Site
Yes
Amenities
barns
greenhouses
ponds
Listing Agency:
eXp Realty
Listed By:
Conner Roohan · License #NY 10401260092
(888) 276-0630
Source:
Crexi
Added: Apr 10
Changed: Aug 24
Last Checked: Sep 7 at 6:25AM
Displayed information is deemed reliable but is not guaranteed and should be independently verified. All listing content including descriptions, pricing, images are the copyrighted material of eXp Realty
Investment Insights
Based on property information with market context.
This 112-acre riverfront agricultural property offers 2,300 feet of frontage overlooking the Mohawk River. The site borders county land and is described as subdividable for development, subject to applicable approvals. Improvements include multiple barns, four greenhouses that could be repurposed or reused, and four ponds.
The property previously supported 1,000 head of cattle and can again be used as a ranch, a gentleman’s farm, or for agriculture. A well on site is stated to be able to pump 40,000 gallons of water per day, and each barn has its own water access and electrical panel.
Additional site details are available in the documents, including information related to the water supply and existing improvements.
The property previously supported 1,000 head of cattle and can again be used as a ranch, a gentleman’s farm, or for agriculture. A well on site is stated to be able to pump 40,000 gallons of water per day, and each barn has its own water access and electrical panel.
Additional site details are available in the documents, including information related to the water supply and existing improvements.
Key Highlights
- 112‑acre property with 2,300 ft of frontage overlooking the Mohawk River and bordering county land
- On‑site well can pump 40,000 gallons of water per day
- Barns have individual water access and electrical panels
Property Analytics
Property Profile
Current Use
Lease Details
Yes
Paved road access
Yes
Utilities to site
Location Intelligence
Trade Area within ½ mile
13
Businesses Nearby
Explore this area
Business Placement
Demographics for 12010, NY
28,845
Population
13,436
Households
2.1
Avg Household Size
41
Median Age
23%
College-Educated
89%
High-School Grad
128.3 sq mi
ZIP Area
225
Density / Sq Mi
$60,013
Median Household Income
$40,664
Median Earnings
$952
Median Rent
$161,500
Median Home Value
Questions? Ask Rey
Realmo’s AI knows this listing — price, zoning, demand, history. Ask anything.
Frequently Asked Questions
What type of property is this?
Agricultural land / Farmland - 112-acre property with Mohawk River frontage, barns, greenhouses, ponds, and on-site well and utilities.
Where is this agricultural land / farmland located?
The property is located at 506 Queen Anne Rd Amsterdam, NY.
What are key features of this property?
This property features: 112‑acre property with 2,300 ft of frontage overlooking the Mohawk River and bordering county land; On‑site well can pump 40,000 gallons of water per day; Barns have individual water access and electrical panels
