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;

983 Cape Rosier Road
Brooksville, ME 04642
Stephen Sprague with ERA Dawson-Bradford Co., original listing - (207) 947-6788

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $395,000
Beds: 1
Baths: Full: 1
Status: Active
SqFt: 384 Square Feet
Agency: ERA Dawson-Bradford Co.
Agency Phone: (207) 947-6788

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 39 acre(s)
Property Type: Other-Single Family Residence
Year Built: 2023
Notes: Idyllic, peaceful, magnificent property located in the heart of Cape Rosier, Harborside, Maine. Living here promises calm and quiet, a multitude of birds, wildlife, and privacy to be who you are. This 39-acre parcel offers so much and to top it off, is surrounded by Holbrook Island Sanctuary State Park, open all year round. The sanctuary has trails, incredible beaches, birds, wildlife and even ancient volcanos. The property has a new 1500' road leading down to the 24x16 tiny home complete with all the utilities, full bathroom, septic system, drilled well with Bison handpump, stationary generator, woodshed. All built the last 2 years. The acreage boasts 2300' of estuary and stream ''Goose Pond'' full of birds and wildlife with surrounding fields to keep your Kayaks. The property is also subdividable with 3 lot areas already buildable while all along maintaining privacy for each. Mature large trees are everywhere, Oak, Maple, Ash, Birch and Pine are abundant. There are new trails marked and cut, and old trails that can be brought back to life, 2+ miles of trails and more. Harborside itself has several beaches, coves to kayak, trails to hike and so much wildlife and things to do. Nearby Blue Hill, Castine and Deer Isle offer groceries, stores and shops. Don't let this wonderful property pass you by, call now for more information.
MlsNumber: --
ListingId: 1605503


Listing Provided By: ERA Dawson-Bradford Co., original listing
Phone: (207) 319-8129
Office Phone: (207) 947-6788
Agent Name: Stephen Sprague
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