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

90 Swan Hill Road
Bethel, ME 04217

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $945,000
Beds: 4
Baths: 3
Status: Active
SqFt: 3107
Agency: EXP REALTY LLC
Agency Phone: (856) 207-1951

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 2 acre(s)
Property Type: Residential
Year Built: 2023
Notes: 'MEMORIAL DAY COMPLETION DATE'' 'STUNNING MOUNTAIN HOME WITH GRAFTON NOTCH AND SUNDAY RIVER VIEWS'' This privately tucked away, new construction, home sits on 2.02 acres amongst the tall towering firs. Approaching through the sweeping driveway this mountain chalet with rustic charm gives way to an elegant interior offering an open first floor plan with perfectly designed kitchen, rustic alder cabinets, large central island, granite counter tops, stainless appliances, dining area, open living room with vaulted ceiling, gas fireplace with raised hearth and field stone surround. Step out the first-floor mudroom to a sunny covered porch with south westerly views of the slopes; then on to the over-sized deck with northly views of Grafton notch. The second floor offers a private master suite with vaulted ceiling, walk-in closet, tiled master bath and loft. The home also features an additional mudroom / gear room with built-ins and abundant storage in it's finished walk-out basement. This level includes a spacious family room for entertaining, bedroom, full bath, bunk room, plus home office/den. Also, the lot offers ample space for future garage and parking. Just a few features that makes this a perfect four-season retreat, only 6 miles from the quaint village of Bethel with all its restaurants and other amenities and 9 miles from the ski slopes!! Vacation or year-round home this spacious home boasts of attention to details in its three levels of living space, comfortably accommodating many guests. Truly a stunning home, built with exceptional craftmanship and design. MEMORIAL DAY COMPLETION DATE!<br /> NEW POTOS COMING SOON! Broker interest in property.
MlsNumber: 1581276


Listing Provided By: EXP REALTY LLC, original listing
Name: EXP REALTY LLC
Phone: (856) 207-1951
Office Name: EXP Realty
Office Phone: (888) 439-8743
Agent Name: Terry Keiser
Disclaimer: Copyright © 2024 Maine Real Estate Information System, Inc. 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