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

3446 State Route 28
Blue Mountain Lake, NY 12812
Ethan Vander Molen with Terrie O'Connor Realtors, original listing - (201) 786-9055

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $469,000
Beds: --
Baths: --
Status: Active
SqFt: 8020 Square Feet
Agency: Terrie O'Connor Realtors
Agency Phone: (201) 786-9055

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Commercial Sale-Business
Year Built: 1967
Notes: Prime Property for Sale in Blue Mountain Lake, NY - Commercial/Residential Space<br /> <br /> Located in the heart of the stunning Adirondack Mountains, this unique property in Blue Mountain Lake, NY, offers endless possibilities for both residential and commercial use. Whether you're looking to establish a business in a highly sought-after location or seeking a peaceful, scenic retreat, this building provides the perfect foundation for your vision.<br /> <br /> With its spacious interior and charming exterior, the property features flexible spaces that can easily be adapted to suit a variety of needs. The building is ideally positioned to capture the town of Blue Mountain Lake and the surrounding landscape. The property is just moments away from outdoor recreation, including hiking, boating, and fishing, as well as the vibrant local culture, making it an ideal location for a wide range of uses.<br /> <br /> For commercial purposes, the property offers high visibility along the well-traveled State Route 28, providing an excellent opportunity for a retail business, restaurant, gallery, or office space, among other possibilities. With its proximity to the lake and surrounding attractions, it's the perfect location to attract visitors, tourists, and locals alike.<br /> <br /> Alternatively, for residential use, the property offers a spacious and versatile layout, ideal for creating a cozy Adirondack home or vacation retreat. Whether you're looking for a year-round residence or a seasonal getaway, the location and natural beauty will ensure a peaceful and inspiring living environment.<br /> <br /> With a combination of parking, easy access, and a prime location in one of the Adirondacks' most desirable towns, this property is a rare find. Don't miss your chance to own a piece of Blue Mountain Lake's charm, where the opportunities are as wide as your imagination.
MlsNumber: --
ListingId: 203532


Listing Provided By: Terrie O'Connor Realtors, original listing
Phone: (201) 970-3626
Office Phone: (201) 786-9055
Agent Name: Ethan Vander Molen
Disclaimer: Copyright © 2024 Adirondack Champlain Valley 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