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

573 Lakeview Road
Topsfield, ME 04490
Sheldon Anderson with Realty of Maine, original listing - (207) 942-6310

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $504,000
Beds: 2
Baths: Full: 2
Status: Active
SqFt: 1600 Square Feet
Agency: Realty of Maine
Agency Phone: (207) 942-6310

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 2 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2024
Notes: Are you looking for a fully furnished and outfitted maintenance free home on a crystal clear lake with both trout and salmon species? This is a brand new semi-custom build on the South shore of East Musquash Lake in Topsfield, Maine. East Musquash Lake is lightly developed with a lot of shoreline in conservation. There are only 2 lots available on the lake and they abut this home's lot. The home sits on 2.5+/- acres with 189+/-' of road frontage and 300+/-' of waterfront. It is appriximately 100' setback from the water and 300+' setback from the road. The nice gentlely sloping frontage makes enjoying the lake effortless. The home itself is an open design kitchen and livingroom with vaulted ceilings, custom cabinets, granite counters, a large island and a gas fireplace with a live-edge rustic mantle. All new stainless steel appliances and a stackable washer/dryer. The 10 X 42 covered porch on the lake side expands the living space for additional seating and a place to barbeque, play cribbage or just enjoy the scenery. There are 2 bedrooms on the main floor that both have there own attached full bath with custom tile showers and walk-in closets. The real v-match pine wall covering, rustic vinyl plank floors and log furnishings create a cozy backwoods atmosphere. The sleeping loft adds an additional 400 square feet of finished space. All brand new including all the furnishings, utensils, bedding and linens, ready for the new occupants to enjoy. With a 100% maintenance free exterior this should provide years of hands free enjoyment. Inquire today, here to help! Sign on the property.
MlsNumber: --
ListingId: 1599402


Listing Provided By: Realty of Maine, original listing
Phone: (207) 267-0656
Office Phone: (207) 942-6310
Agent Name: Sheldon Anderson
Disclaimer: Copyright © 2025 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