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;

205 Oakfield Smyrna Road
Oakfield, ME 04763
Andrew Mooers with Mooers Realty, original listing - (207) 532-6573

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $599,500
Beds: 24
Baths: ½: 3
Status: Active
SqFt: 7152 Square Feet
Agency: Mooers Realty
Agency Phone: (207) 532-6573

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1987
Notes: Need Space? Want Modern And No Repairs? Love The Look Of Natural Cedar Logs With Cathedral And Vaulted Ceilings, Angled Walls Of Glass? This New Maine Listing Is Worth Checking Out And To Watch The Video. Is 4100' S/F Of Interior Space Enough Elbow Room For Extended Family, Multi Generations Under One Roof Line? Or Need Space For A Home / Business Combination? Get The Mix You Need At 205 Oakfield Smyrna RD Oakfield ME. Frontage of 178' With Parking Lot That Serves The 1987 Front Section. Extra Parking Behind The New In 2001 Addition. Cedar Log Construction, Two Flu Lined Chimneys. One Serves The Multi Zone Oil Hot Water Furnace, Other For Your Woodstove. Four Heat Pumps, 3 AC and 1 Both Heating/Cooling And 24K BTU. Outdoor Wood Boiler! Already Wired For Telecommunication. Double Glass Atrium Doors On New Addition, 4 Exits Make This Easy To Develop And Transform. Handicap Access Friendly Ramp, 168' Open Deck On South Side. Besides 25 Rooms, 3 Large Storage Areas To Work Into Your Dream Floor Plan Needs. Live In Part, Put The Rest To Work Until You Grow Into All Of This Big, Beautiful Building. 3 Half Baths (One Oversized And Ready For Shower). 2 Kitchens Too! The Log Home Maker That Carefully Constructed This Building Has Over 2500 Homes, Commercial Use Buildings Under Their Belt For Experience. If You Know Anything About Building Construction, You Will Be Impressed With The Attention To Fine Details, The Mechanical Systems In This Building Ready For Development. Run A Lodge, Surrounded By Rec Trails To Four Wheel, Snowmobile. All Kinds Of Lakes In This Vacation Destination Of Aroostook County. Use For Offices, Day Care, Not Just Transforming Into Living Space For Home And Multiple Apartment Rentals. Opportunity Knocks And Please Share Information On This Property Listing In A Key Location Just Off Interstate 95 With High Exposure. Hunting, Fishing, Relaxing In Maine. Two Nearby Golf Courses. One Incredible Property Listing. Questions? Please Reach Out. Here To Hel
MlsNumber: --
ListingId: 1615194


Listing Provided By: Mooers Realty, original listing
Phone: (207) 532-6573
Office Phone: (207) 532-6573
Agent Name: Andrew Mooers
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.


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 = 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;
Real Estate Expert Photo for Josh Cheney
Josh Cheney
ASCIIRE/MAX County
Call Today!: (207) 227-4631

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App