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

450 Fort Fairfield Road
Presque Isle, ME 04769
Leigh Smith with RE/MAX County, original listing - (207) 769-2900

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,900,000
Beds: 5
Baths: Full: 2, ½: 2
Status: Active
SqFt: 14000 Square Feet
Agency: RE/MAX County
Agency Phone: (207) 769-2900

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 750 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2002
Notes: For Sale: Premier 750-Acre Outdoor Center<br /> <br /> Discover the ultimate outdoor paradise with this expansive outdoor center offering approximately 750 acres, perfect for year-round recreation and events. Nestled in nature's embrace, this property features a stunning 7,000 sq ft lodge, complete with a commercial kitchen, a grand stone fireplace, and vaulted ceilings that create a warm and inviting atmosphere. <br /> <br /> Key Features:<br /> <br /> Lodge: 7,000 sq ft with a commercial kitchen, stone fireplace, vaulted ceilings, common room dining area, restrooms, shower rooms, and a sauna.<br /> Accessory Buildings: Multiple buildings, including equipment storage and a wax building that offers repurposing potential.<br /> Parking: Ample parking to accommodate large groups and events.<br /> Trails:<br /> 25 miles of single-track mountain bike trails.<br /> 30 KM of dedicated, world-class cross-country ski trails with a biathlon range.<br /> 35 miles of maintained hiking trails that follow both mountain bike and ski trails.<br /> 9-hole disc golf course.<br /> Mountain Biking: Extensive bike trails for thrilling mountain biking adventures.<br /> Riverfront Access: Enjoy direct access to the scenic Aroostook River.<br /> Versatile Venue: The venue offers limitless possibilities in addition to its continued use as an outdoor recreation and event center, such as a corporate retreat, or snowmobile destination.<br /> Prime Location: Situated along the town boundary of Presque Isle and Fort Fairfield, just 5 minutes from downtown Presque Isle and 15 minutes to the Canadian border.<br /> Nearby Airport: Close to Presque Isle International Airport with daily commercial flights.<br /> Snowmobile Trails: Access to a network of over 14,000 miles of connected, groomed snowmobile trails throughout Maine.<br /> Outdoor Activities: Endless fishing and hunting opportunities, with chances to see bear, deer, and even moose.<br /> Natural Beauty: Fresh clean air, with the captivating charm of Aroostook County and the chance to witness the Northern Lights.
MlsNumber: --
ListingId: 1611543


Listing Provided By: RE/MAX County, original listing
Phone: (207) 227-4501
Office Phone: (207) 769-2900
Agent Name: Leigh Smith
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