Title Page Background
DEBUG FN args: Array ( [0] => 1870 [1] => [2] => [3] => agent ) BEFORE: Site: 1870 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1870 Igate: njhud LocID: 1870 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 1870 AND i.igate IN ('nyhud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'nyhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1870 [1] => [2] => [3] => lender ) BEFORE: Site: 1870 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1870 Igate: njhud LocID: 1870 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 1870 AND i.igate IN ('nyhud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'nyhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1870 [1] => [2] => [3] => other ) BEFORE: Site: 1870 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1870 Igate: njhud LocID: 1870 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 1870 AND i.igate IN ('nyhud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'nyhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

1457 North Road
North Blenheim, NY 12131
Don Blouin with BELLEAYRE REALTY, original listing - (607) 434-9249

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $549,000
Beds: 4
Baths: Full: 3
Status: Active
SqFt: --
Agency: BELLEAYRE REALTY
Agency Phone: (607) 434-9249

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 33 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1997
Notes: COUNTRY PARADISE FOUND! The private and serene setting will sell you on this spacious well maintained 4 bedroom, 2.5 bath 2,700+/- square foot recently updated Colonial home. Hidden away on 33+ open & wooded surveyed acres with your own hiking trails, 4 ponds, perennial flowering plantings, exotic trees and panoramic mountain views, all within minutes to Plattekill, Windham & Hunter Mountains. Located in North Blenheim in the beautiful Schoharie Valley, less than 2 3/4 hours from the GW Bridge you'll find this oasis just minutes to popular farmers markets, trendy farm to table restaurants & cafes, local distilleries & cideries, arts programs & mountain festivals. Also nearby are: Mine Kill State Park, known for its waterfalls, hiking/snowshoeing, swimming, boating & fishing, Kaaterskill Waterfalls and Howes Caves. You'll approach this welcoming home by driving through the woods up the tree lined driveway to a rolling meadow with a spring fed pond and the calming sound of the Mill Creek just below. This home features large rooms & handsome oak floors, a recently upgraded 30' eat-in gourmet kitchen with stainless appliances & ample quartz counters, sliders lead out to a 58' long deck to enjoy those summer BBQs, views & star gazing, or enjoy the evening up the trail at the fire pit overlooking the ponds, mountain views & memorable sunsets. Off the kitchen is the fully equipped laundry and 1/2 bath, a large formal dining room, front hall and double set of French doors open to the inviting 25' living room with brick fireplace and built-in bookcase. Upstairs hall leads to a huge primary bedroom ensuite with jacuzzi bath and a 10' room ideal for work from home/online schooling with fiber optic internet available. The 24' x 44' finished basement, ideal for entertaining, boasts a bar, TV and rec/game area, a furnace/utility room and passage door to the grounds. In addition to the efficient 3-zone Buderus Logano oil furnace there's an outdoor Central Boiler wood furnace for alternative or back-up heat. Note: The Blenheim Hill Farm wedding venue is just down the road. This property has a lucrative Airbnb short term rental history should one care to earn income when not enjoying the property. This just listed unique offering will not last long. Schedule your viewing now before it's gone!
MlsNumber: --
ListingId: 11500102


Listing Provided By: BELLEAYRE REALTY, original listing
Phone: (607) 434-9249
Office Phone: (607) 434-9249
Agent Name: Don Blouin
Disclaimer: Copyright © 2025 My State MLS. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App