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','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 = 1213 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 = 1213 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;

123 Rattlesnake Road
Brownfield, ME 04010
Jodi Chute with Pine Tree Realty of Maine, LLC, original listing - (207) 650-3750

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $274,900
Beds: 1
Baths: --
Status: Active
SqFt: 192 Square Feet
Agency: Pine Tree Realty of Maine, LLC
Agency Phone: (207) 650-3750

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1965
Notes: Owning a cabin with 150 feet of waterfront on Pequawket Pond is a dream come true! You can boat right from your dock, which is a great spot for fishing, kayaking, swimming, and more. While the property might need some repairs due to vacancy, it presents a blank canvas for you to customize and improve according to your tastes and needs. The covered porch area provides a perfect place to relax and take in the beautiful views. There's even an outhouse that makes a great conversation piece. Pequawket Pond consists of 81 acres & is known for its natural beauty and wildlife, including the iconic sounds of loons. The sandy bottom waterfront of the neighboring property enhances the overall charm of the area. A brand new 4-bedroom septic system is already in place, which is a significant benefit for any future renovations or expansions. The property spans a double lot totaling ¾ of an acre, offering ample space for expansion. You could add additional living spaces or recreational areas, making it ideal for gatherings and family events. The availability of the back lot presents a great opportunity to build a garage with living space above. This could serve as additional accommodation for guests, family, or even as a rental property. The Backburner Restaurant is right around the corner, and the cabin is conveniently located just minutes from Fryeburg Village, providing easy access to restaurants and local shops. It's only 20 minutes away from North Conway, New Hampshire, a hub for shopping, dining, and entertainment. The location offers year-round activities. In winter, you can enjoy skiing at Pleasant Mountain Ski Resort and Cranmore Mountain. Snowmobiling is also popular in the area. In summer, you can engage in various water activities on the pond. This property on Pequawket Pond offers a mix of natural beauty, potential for customization, and convenience to amenities, making it an ideal retreat for relaxation and recreation. Seller offering concessions.
MlsNumber: --
ListingId: 1585827


Listing Provided By: Pine Tree Realty of Maine, LLC, original listing
Phone: (207) 893-8006
Office Phone: (207) 650-3750
Agent Name: Jodi Chute
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