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 = 1827 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 = 1827 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 = 1827 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;

6709 Upper Road
Ellicottville, NY 14731
Todd E VanDyke with RE/MAX On Point, original listing - (716) 373-7325

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $945,000
Beds: 6
Baths: Full: 5
Status: Active
SqFt: 3512 Square Feet
Agency: RE/MAX On Point
Agency Phone: (716) 373-7325

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2007
Notes: Discover Ellicottville’s hidden treasure, where elegance meets mountain charm. Nestled in a prime location, this breathtaking retreat offers exciting views of the slopes, best enjoyed through expansive panoramic windows or while unwinding on the wrap-around deck with your morning coffee. Step inside and feel the warmth of this meticulously designed home, featuring six spacious bedrooms including a loft and a private owner bedroom - and five luxurious full bathrooms—plenty of room! Whether relaxing after a day on the slopes or a round of golf, the cozy recreational bar/coffee area is the perfect spot to unwind. Indulge in the home’s thoughtfully curated amenities, including multiple fireplaces, theatre room, an entertainment-ready outdoor space, a hot tub tucked beneath a charming gazebo, and an expansive deck built for gatherings under the stars. The chef’s kitchen is a dream, fully equipped with appliances and ample space for culinary creations. The ground-floor master suite is your personal sanctuary, featuring a spa-like en-suite with a jacuzzi tub, separate shower, and double vanities. But the true gem of the Upper Road home? A private guest suite—complete with an extra bedroom, living area, and two bathrooms—ideal for an in-law retreat, home office, or even a lucrative rental opportunity. Practicality meets luxury with a one-car garage offering additional storage, a dedicated first floor laundry room with storage for supplies, and a durable concrete driveway and patio area. Plus, with a proven track record as a high-demand vacation rental, this home isn’t just a getaway—it’s an investment in your future. Ideal location right up the road from the Sky High Mountain Coaster and Adventure Park, along with the Yodeler Lodge and ski area. This is more than just a home—it’s an opportunity to own one of Ellicottville’s most distinguished properties. Whether you’re looking for a lucrative rental, a vacation retreat, or a forever home, this is waiting for you. Multi year rental income and expense reports are available to qualified parties. County record full market value 2024 is $1,159,633 spelling opportunity! Rentals managed for over a decade by the listing broker.
MlsNumber: --
ListingId: B1589437


Listing Provided By: RE/MAX On Point, original listing
Phone: (716) 581-0724
Office Phone: (716) 373-7325
Agent Name: Todd E VanDyke
Disclaimer: Copyright © 2025 New York State Alliance of MLSs, LLC. 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