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.

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.

Name

Your Email Address

Phone

Message Send me the deed for 140 Aldrich Avenue Warwick RI 02889 (ID#:1397293)

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

Name

Your Email Address

Phone

Message Send me the survey or tax map for 140 Aldrich Avenue Warwick RI 02889 (ID#:1397293)

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

Name

Your Email Address

Phone

Message I would like more information for 140 Aldrich Avenue Warwick RI 02889 (ID#:1397293)

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

Listing Tools

Property Details of 140 Aldrich Avenue, Warwick Neck

Property Details

Basic Information

Location

Interior Features

Bedrooms

Other

Exterior Features

Features

Community

Area

Map Location

Costello Realty

Hi there! How can we help you?

Listing Tools

Hi there! How can we help you?

Property Details of 140 Aldrich Avenue, Warwick Neck

Property Details

Basic Information

Location

Interior Features

Bedrooms

Other

Exterior Features

Features

Community

Area

Map Location

Hi there! How can we help you?

Hi there! How can we help you?

Hi there! How can we help you?

Costello Realty