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

219 Middle Road
Skowhegan, ME 04976
Nicholas Corrow with Your Home Sold Guaranteed Realty, original listing - (207) 629-9211

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $879,900
Beds: 5
Baths: Full: 2
Status: Active
SqFt: 2747 Square Feet
Agency: Your Home Sold Guaranteed Realty
Agency Phone: (207) 629-9211

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 55 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1800
Notes: OFFER DEADLINE: THURSDAY, JANUARY 16TH AT 5PM, SELLER TO RESPOND WITHIN 24 HOURS.<br /> <br /> Welcome to a truly unique and timeless estate where classic New England charm meets contemporary elegance. This extensively renovated 1800s-style farmhouse is the perfect blend of historic character and modern refinement, offering a lifestyle of comfort and sophistication with over 55 acres of land.<br /> <br /> From the moment you step inside, you'll be captivated by the attention to detail and seamless integration of old-world charm and high-end upgrades. The immaculate kitchen is a chef's dream, while the delightful dining room sets the stage for elegant gatherings. The luxurious living room invites you to relax in style, creating an ambiance of pure indulgence with its Lopi wood burning fireplace sure to keep you warm in the winter months.<br /> <br /> Beyond the living room, the master suite is a sanctuary of its own, featuring a sophisticated walk-in closet area, a sunlit bedroom with fireplace, and a luxury en-suite bathroom complete with a his-and-hers vanity, a separate makeup vanity, and a tiled, glass-enclosed shower.<br /> <br /> Upstairs, the versatility continues with multiple bedrooms, bonus room--currently utilized as an office, and a cozy den area with yet another fireplace, perfect for large families, guest accommodations, or work-from-home setups.<br /> <br /> Step outside and immerse yourself in an entertainer's paradise. A brand-new in-ground, heated pool takes center stage, accompanied by a dedicated pool house with a shower, bathroom, and a spacious concrete patio. The expansive full deck overlooking the grounds is ideal for summer barbecues or serene mornings with coffee in hand.<br /> <br /> For hobbyists or those in need of extra storage, the barn is a dream come true, offering ample space and a full, dedicated workshop. With over 55 acres of land to roam and explore, you'll never run out of adventure.<br /> <br /> Properties like this don't come around often--seize your chance to own this incredible estate!
MlsNumber: --
ListingId: 1612283


Listing Provided By: Your Home Sold Guaranteed Realty, original listing
Phone: (207) 649-4437
Office Phone: (207) 629-9211
Agent Name: Nicholas Corrow
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