Listed by Legacy Properties Sotheby's International Realty
Exceptional commercial opportunity or cherished multigenerational retreat offering year-round gracious mountain living. Featuring six luxurious en-suite bedrooms with gas fireplaces, a deluxe commercial grade chef's kitchen with an impressive pantry and second floor studio space ideal for an office or staff. Expansive great room ideal for events and entertaining. Sparkling oak floors, and outstanding finish work throughout. The grounds offer gorgeous perennial gardens, raised planting beds for specializing gardening, a zen pond, locally sourced granite hardscaping, and a screened gazebo. A detached ''Wellness Cottage'' highlighting a first-floor spa room, indoor saltwater plunge pool, gym, and sauna, and a sunny spacious second floor three bedroom apartment provide excellent options for a unique retreat, home business, and/or investment endeavor. Meticulous attention to detail combined with casual elegance delivers impressive potential in a vibrant and charming community, offering easy access to Sunday River Ski Resort and Golf Club, scenic hiking, and regional lakes. This special property is a gateway to four seasons of adventure and relaxation in one of New England's premier destinations.

Listing Tools (detailViewNewGen)

Property Details of 174 Mayville Road

Property Details

Interior Features

Exterior Features

Community

Map Location

Listing data is derived in whole or in part from the Maine IDX & is for consumers' personal, non commercial use only. Dimensions are approximate and not guaranteed. All data should be independently verified. ©2025 Maine Real Estate Information System, Inc. All Rights Reserved. equal opportunity housing logo   Privacy Policy

Gallant Real Estate participates in ©2025 Maine Listings Internet Data Exchange program, allowing us to display other Maine IDX Participants' listings. This website does not display complete listings. Certain listings of other real estate brokerage firms have been excluded. Mortgage figures are estimates. Check with your bank or proposed mortgage company for actual interest rates. This product uses the FRED® API but is not endorsed or certified by the Federal Reserve Bank of St. Louis.

Hi there! How can we help you?

Contact us using the form below or give us a call.

Send Us A Message:

I agree to receive marketing and customer service calls and text messages from Gallant Real Estate. To opt out, you can reply 'stop' at any time or click the unsubscribe link in the emails. Consent is not a condition of purchase. Msg/data rates may apply. Msg frequency varies. Privacy Policy.

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Hi there! How can we help you?

Contact us using the form below or give us a call.

Send Us A Message:

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Hi there! How can we help you?

Contact us using the form below or give us a call.

Send Us A Message:

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

$

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.