Listing Tools

Spectacular waterfront estate perched high above Narragansett Bay. Enjoy magnificent water views and sunrises while surrounded by 2+ acres of beautifully landscaped privacy. A two-year long renovation (2020-2022) has yielded top quality results, inside and out. Extensive improvements include new heating, A/C, spectacular kitchen and baths, Pella Architectural Series windows and doors, a 20.3 KW Tesla solar-shingled roofing system and a garage studio. A heated in-ground pool overlooking the Bay with spa and cabana plus a guest mooring that accommodates a 35'-40' boat all contribute to an incredible outdoor experience. Located conveniently close to Warwick Country Club, TF Green Airport and Rocky Point Park, the property provides a relaxing oasis on Warwick Neck.

Property Details of 140 Aldrich Avenue, Warwick Neck

Property Details

Interior Features

Exterior Features

Utilities and Appliances

Community

Other Details

Nearest Landvest Office

Cape Cod - Woods Hole, MA

Cape Cod - Woods Hole, MA

617-357-8990
97 Water Street,
Woods Hole, MA 02543
Our Agents

Never Miss New Listings

Never miss new listings between $3,195,000 - $3,905,000 in this neighborhood
Successfully Subscribed!
Do not fill in this field:

We respect your privacy. By submitting this form, you agree to receive communication from LandVest. We will never share or sell your information. You can opt-out at any time.

We will never spam you or sell your details. You can unsubscribe whenever you like.

Map Location

Do not fill in this field:

We respect your privacy. By submitting this form, you agree to receive communication from LandVest. We will never share or sell your information. You can opt-out at any time.

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

Schedule A Visit

Schedule a Visit

We respect your privacy. By submitting this form, you agree to receive communication from LandVest. We will never share or sell your information. You can opt-out at any time.

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

 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.  ©  2026 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:

We respect your privacy. By submitting this form, you agree to receive communication from LandVest. We will never share or sell your information. You can opt-out at any time.

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.