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

926 Detroit Road
Troy, ME 04987
Elaine Pelletier with Bangor, Maine, original listing - (207) 942-6711

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,350,000
Beds: 6
Baths: Full: 4
Status: Active
SqFt: 4550 Square Feet
Agency: Bangor, Maine
Agency Phone: (207) 942-6711

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 208 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2005
Notes: **Spectacular 205+/-Acre Estate with Two Renovated Homes, Extensive Trails, and 3 Farm Ponds**This remarkable 205+/- acre estate offers unparalleled privacy, luxury, and versatility with two nicely renovated homes, each brimming with modern updates and charm. Perfect for those seeking a serene retreat or a multi-generational living solution.**White House** Step into this beautifully updated three bedroom, office home featuring a new metal roof and a stunning great room, ideal for entertaining or relaxing. The kitchen is fully equipped with a stove, refrigerator, and dishwasher. Two full baths and a laundry room with a new washing machine add to the convenience. **Red House** This three bedroom gem combines classic elegance with modern amenities. The large kitchen boasts granite countertops, and the first floor includes a dining room, living room, bedroom, laundry room, full bath, and an office. The second-floor master suite is a true retreat, featuring a walk-in closet, a luxurious bath with a steam shower, and a private deck overlooking a large garden.**Outdoor Features** - **Five-Bay Garage**: Includes a second story, perfect for additional storage or a workshop.- **Additional Shed**: Offers extra storage for tools, equipment, or hobbies.- **Three Farm Ponds**: Ideal for enjoying nature, fishing, or as a scenic backdrop.- **Meticulously Maintained Trails**: Perfect for walking, riding, or exploring the expansive property.- **Large Garden Area**: Ready for your green thumb to flourish.This estate is a rare opportunity, combining modern living with expansive outdoor spaces. Whether you're looking for a peaceful haven or a property with income potential, this one-of-a-kind estate is not to be missed.
MlsNumber: --
ListingId: 1600797


Listing Provided By: Bangor, Maine, original listing
Phone: (207) 852-4021
Office Phone: (207) 942-6711
Agent Name: Elaine Pelletier
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.


Local Real Estate Expert

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 = 1218 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;
Real Estate Expert Photo for Patti Montana
Patti Montana
ASCIIeXp Realty
Call Today!: (207) 401-5500

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App