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

223 Nevells Way
Ellsworth, ME 04605
Steve Shelton with Ellsworth, Maine, original listing - (207) 667-7423

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,900,000
Beds: 4
Baths: Full: 5, ½: 1
Status: Active
SqFt: 4275 Square Feet
Agency: Ellsworth, Maine
Agency Phone: (207) 667-7423

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2022
Notes: Simply exquisite lake front living with this newly constructed 3 level gorgeous masterpiece on Green Lake with stone columns and two massive deck and patio spaces for outdoor living. Comes completely turnkey and furnished along with new Pontoon Boat, jet ski, inflatable with motor and John Deere Gator and Lawn mower along with all the misc tools to maintain the property. Main floor is level entry with massive cathedral great room with fireplace that is open to the kitchen and dining area leading into a finished and heated sunporch with fireplace. Going through the chef's kitchen and pantry area there is another entrance by the attached heated garage. Primary Suite on First floor on the other end with incredible bathroom and laundry attached. Second level has two ensuite bedrooms and a loft area connecting the two. The lower level is another awesome space with custom wine cellar, utility room, another bedroom and bath and a large living area and bar/entertainment area that leads out to a beautiful stone patio. Completely fenced in waterside lawn that leads down the dock where you can jump on your pontoon boat or jet ski to explore the lake. Large manicured front lawn area leads up toward the detached and heated 3 car garage/workshop that also has an RV hook up on the side with a separate septic tank and power for any guests that want to stay plugged in for the summer. Just an incredible offering ready for you to enjoy Maine lake front living all just a short ride to town and only 45 min to Acadia National Park. Full sprinkler system and 22 KW generator as well as irrigation for the lawns
MlsNumber: --
ListingId: 1604575


Listing Provided By: Ellsworth, Maine, original listing
Phone: (207) 667-7423
Office Phone: (207) 667-7423
Agent Name: Steve Shelton
Disclaimer: Copyright © 2024 Better Homes and Gardens-The Masiello Group. 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