Active with Contract

Listing Tools

This waterfront retreat is located directly on 82-acre Locustville Pond and is an entertainer's or sport enthusiast paradise! The property consists of a 6155 SF, 3/4 bedroom home, all rooms are individually insulated, 4-1/2 bath, 2 full kitchens, one upstairs and one downstairs, a large owner's suite with two large closets, 2 laundry areas, a full body gym, a climate controlled safe room - which would make a great wine cellar, a generator, large decks and patios, a 2 car and 4 car heated garage and a separate 3-bay commercial garage with electricity located at the far end of the property, a built-in pool and two docks; one has a boat lift and a storage shed, an additional barn/shed, an electric pet fence, security system - all on 3.07 private, beautifully landscaped and hard-scaped secluded acres! Horses/farm permitted, multi generational living, vacation retreat, car collectors, home occupation. Located minutes from "The Preserve" sporting center, easy access from major highways.

Property Details of 25 Fairview Avenue, Locustville Pond/Hope Valley

Property Details

Interior Features

Exterior Features

Utilities and Appliances

Other Details

Map Location

Driving Directions

Listed by Bonnie Begos of RE/MAX FLAGSHIP, INC.

IDX information is provided exclusively for consumers’ personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information is deemed reliable but is not guaranteed.  ©  2024 State-Wide Multiple Listing Service. All rights reserved.

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 be contacted by the Teri Degnan Real Estate & Consulting via call, email, and text. To opt out, you can reply 'stop' at any time or click the unsubscribe link in the emails. Message and data rates may apply.

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.