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 ('wihud','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 = 'wihud', 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 ('wihud','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 = 'wihud', 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 ('wihud','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 = 'wihud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

283 Avenue Of The Stars
North Blenheim, NY 12131

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $679,000
Beds: 3
Baths: Full: 3
Status: Active
SqFt: 2400 Square Feet
Agency: LIVING STRUCTURES

Map Details Show Map | Show StreetView




House Features

Appliances: Dishwasher, Washer, Microwave, Refrigerator, Dryer
Architectural Style: Other
Flooring: Carpet, Tile, Vinyl
Heating: Forced Air, Stove
Rooms: Bathroom 1, Bathroom 2, Bathroom 3, Bedroom 1, Bedroom 2, Bedroom 3, Family Room

Window Features

Parking Features: Garage, Garage - Detached
Roof: Asphalt
View: Mountain

Neighborhood/Schools

Elementary School/District: Canyon
Middle/Junior High School/District: Canyon
High School/District: Canyon
Subvidision Name:

Description/Comments


Lot Size: 11 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2000
Notes: Welcome to 283 Avenue of the Stars nestled just minutes away from a wide array of outdoor adventures for every season; yet tucked away offering ultimate privacy & solitude. This contemporary chalet style home situated on 11.5 acres offers 3 distinct levels of living, perfect for entertaining. The lower level is a quintessential Rec/Media Room also having a sizable bedroom and full bathroom. The main (2nd) level and center-piece of the home boasts an expansive open living/dining space w/beautiful cathedral ceiling, wood-stove & a wall of windows that floods the space w/natural light. The primary bedroom w/ ensuite bathroom, an additional bedroom and full bright bathroom completes this level. And finally, the loft which is a great space for a studio, den or another amazing gathering area. Stepping outside, the 2-tiered wraparound decks afford an ample area to entertain. You can dine al fresco while enjoying the distant mountain views with the pond just below; or spend time rain or shine under the covered terrace. The lower deck is where you will find the hot tub for year-round enjoyment. This property offers significant road frontage along two areas of Avenue of the Stars providing investors an opportunity to subdivide or develop & improve the upper portion with a glamping/small cabin site or two to add to the existent STR income and the potential for a lucrative ROI. Improvements completed are as follows: On-demand electric water heater: 2019 Resurfaced & reinforced the driveway: 2019 Replaced all interior doors throughout home - 2019 New expanded decks & stairs - 2020 Home exterior stained - 2020 Hot Tub/Spa - 2020 SS Refrigerator - 2020 Dishwasher - 2021 Wood stove - 2021 First level flooring replaced - 2021 New bathroom vanities & faucets - 2023. This property affords year round fun & adventure a mere one mile away with activities for each season - Mine Kill State Park offers the following: swimming with a pool complex having 3 separate swim areas, hiking, waterfalls, boating - kayaking & motor, water-skiing, X-country skiing & ice skating in winter months and educational programs throughout the year! In addition, there are three downhill ski resorts & villages nearby - Plattekill - 22 miles, Windham - 24 miles - Hunter - 42 minutes There are countless farm stands, wineries and festivals in neighboring towns & villages in the spring, fall & summer months as well. NYC is 148 miles Schedule your showing today and discover everything the Southern Schoharie Valley & beautiful Northern Catskills has to offer!
MlsNumber: --


Listing Provided By: LIVING STRUCTURES, original listing
Phone: (518) 622-3487
Office Phone: (518) 622-3487
Agent Name: Patricia Macaluso
Disclaimer: Copyright © 2024 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