Title Page Background
HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 1842 AND i.igate IN ('usahud','mihud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mihud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 1842 AND i.igate IN ('usahud','mihud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mihud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 1842 AND i.igate IN ('usahud','mihud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mihud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;

128 W Moorehouse Road
Cairo, NY 12413
Theodore Banta III with RVW Select Properties, original listing - 627-6290

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,895,000
Beds: 1
Baths: ¼: 1
Status: Active
SqFt: 800 Square Feet
Agency: RVW Select Properties
Agency Phone: 627-6290

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 125 acre(s)
Property Type: Residential-Cabin
Year Built: 2011
Notes: Welcome to Paradise! A Magnificent & Serendipitous Property with 125 acres! The property features a custom built off-grid cabin using the land's timber & stone resources, there's over 2,000' of The Catskill Creek with both sides owned (which is unparalleled), there's over 3,500' of road frontage, there's over 1,000' of private gorgeous waterfalls, there's an historic old railroad bed from the 1880's, a nostalgic & dreamy swimming hole, multiple fishing areas, beautiful mountain views, extraordinary landscapes, & 3 points of access to the property. Enjoy & play in the dreamy swimming hole basking in the sun jumping off of rocks & swimming in The Catskill Creek feeling warm & cold springs massaging your feet. Enchant yourself in the private waterfalls nestled between 2 ridges where another soul cannot find or observe you. While sitting, standing, or meditating in the waterfalls allow yourself to be free from the illusion of life creating a state of bliss & joy. Kayak, canoe, & fish for trout & bass. Sit, lounge, & meditate on the large flat rocks around the creek listening to the water running while observing the hawks & eagles fly up & down stream. Listen to the whispers & the songs of nature: trees, winds, birds, wildlife, & leaves & know what is to be a steward of land while discovering your essence. In the movie 'A River Runs Through It', a quote is: '...The water runs over the words.' You can hike, horseback ride, 4-wheel, walk, & run on the beautiful trails & old railroad bed observing nature with wonder & awe. Camp at secluded areas throughout the property with bonfires that only you relish. You will find & know the limitless peace & serenity of this extraordinary estate. Imagine yourself beginning your travels with the anticipation of visiting these beautiful natural landscapes with its vibrant wildlife & elegant birds, its private waterfalls, trails, & swimming holes to relax, play, explore, & restore in its magnificent beauty! It's also a Prime Development Opportunity for housing or commerce. It's a great opportunity for a Housing Development, Resort, Campground, Glamping site, Agri-business, Commercial Site, School, Manufacturing, & more. The property has great proximity to the area's destinations & attractions as it's 20 minutes to Windham Ski Mountain, 30 mins to Hunter Ski Mountain, 10 mins to Zoom Flume Water Park, 20 mins to Dutchman's Landing & the Hudson River. View our 3D virtual & sky tours & multi-media website of the cabin & property.
MlsNumber: --
ListingId: 156208


Listing Provided By: RVW Select Properties, original listing
Phone: (518) 627-6290
Office Phone: 627-6290
Agent Name: Theodore Banta III
Disclaimer: Copyright © 2025 Columbia Greene and Northern Dutchess MLS. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


Local Real Estate Expert

HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 1842 AND i.igate IN ('usahud','mihud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mihud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;
Real Estate Expert Photo for Lisa Jaeger
Lisa Jaeger
ASCIIColdwell Banker Village Green Realty
Call Today!: (518) 755-2573

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App