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','nyhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nyhud', 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','nyhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nyhud', 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','nyhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nyhud', 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;

7352 Route 23a
Hunter, NY 12442
Regina Tortorella with Coldwell Banker Village Green - Windham, original listing - (518) 734-4200

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,495,000
Beds: 4
Baths: Full: 4, ½: 1
Status: Active
SqFt: 4487 Square Feet
Agency: Coldwell Banker Village Green - Windham
Agency Phone: (518) 734-4200

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 4 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2023
Notes: Welcome to Elk Ridge Lodge, where custom craftsmanship meets the serene beauty of upstate New York. Nestled on over 4.2 acres, this Newly constructed escape is the perfect package with log cabin charm, modern amenities, and breathtaking views. Perched on a hill behind a privacy gate, Elk Ridge Lodge invites you into a world of opulence. A long-paved driveway leads to a grand entrance with a dramatic log carport, setting the stage for the grandeur inside. The tranquil Red Kill Creek meanders the property's edge, adding to its picturesque allure. Step inside to immediate panoramic views of the slopes, walls of glass, vaulted ceilings, and a stunning floor-to-ceiling stone fireplace w/ heat circulator. The open layout includes a chef's kitchen featuring granite, ss appliances, a Monogram gas stove and a breakfast nook. There are four bedrooms, including two ensuites. The primary first-floor ensuite offers private deck access, a cedar-lined walk-in closet, and a luxurious bathroom with a double vanity and oversized tiled shower. Multiple rooms cater to work-from-home needs or additional living areas, all with serene mountain views. The second floor features two bedrooms, a second ensuite, and a loft area showcasing a chairlift from Hunter Resort, further enhancing the ambiance. The lower-level walkout is perfect for aprs-ski entertainment, featuring a wood-burning stove, a fourth bedroom and bathroom, and a custom bar with a copper bar top and, refrigerator, wine fridge, ice maker, and more. Elk Ridge Lodge's outdoor areas are equally impressive. A wrap-around deck, patio, and fire table area are perfect for alfresco dining and lounging. Additionally, there is a heated ski room w/storage that leads to an attached 3-car garage equipped with heat and additional storage above. Notable features include custom built furnishings (included), a smart home system,10 thick foundation walls, spray foam insulation, a security system with an owner-controlled security gate, central air, & shed. Located within walking distance of Scribner's Lodge and The Hunter Resort, this retreat offers easy access to dining and entertainment options. It's perfect for ski enthusiasts, luxury property seekers, or investors looking for a high-income potential short-term rental catering to wedding and event guests. Don't miss out! Elk Ridge Lodge is an extraordinary opportunity whether you're looking for a winter haven or a unique luxury property, this lodge offers an incredible lifestyle.
MlsNumber: --
ListingId: 153535


Listing Provided By: Coldwell Banker Village Green - Windham, original listing
Phone: (518) 734-4200
Office Phone: (518) 734-4200
Agent Name: Regina Tortorella
Disclaimer: Copyright © 2024 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','nyhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nyhud', 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