INNOVATE
Real Estate
No photos available for this listing

$3,550,000

140 Aldrich Avenue
Warwick, RI 02889
Listed by Rebecca Mayer
Bedrooms
5
Bathrooms
4.1
Living area
4,661 sqft
Year built
1932

About this home

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.

Highlights

WaterfrontFireplace

Property details

MLS #
1397293
Property type
Single Family Residence
Subdivision
Warwick Neck
Status
Active
Days on market
N/A
On market date
N/A
Stories
N/A
Garage spaces
2
Lot size
2.159 acres

Location

Get directions →
Loading map…

Nearby schools

Within 10 miles · public school directory data (NCES)

Elementary
Warwick Neck School
0.34 mi away · Grades 0-5
Nearest school -- attendance-zone data not available here
3.0
Local Score (student-teacher ratio only (preliminary -- will incorporate state test-score data once available)) -- not an official state rating
Enrollment
279
Student:teacher ratio
15.5:1
District
Warwick
Middle
Warwick Veterans Middle School
2.27 mi away · Grades 6-8
Nearest school -- attendance-zone data not available here
4.0
Local Score (student-teacher ratio only (preliminary -- will incorporate state test-score data once available)) -- not an official state rating
Enrollment
1,160
Student:teacher ratio
12.3:1
District
Warwick
High
Pilgrim High School
4.62 mi away · Grades 9-12
Nearest school -- attendance-zone data not available here
5.0
Local Score (student-teacher ratio only (preliminary -- will incorporate state test-score data once available)) -- not an official state rating
Enrollment
1,176
Student:teacher ratio
10.9:1
District
Warwick

Mortgage calculator

Estimate only — actual rate and payment depend on your lender, credit, and loan program.

$
%
%
Adjust tax / insurance estimates
% / yr
$
/mo
Est. monthly payment
$21,529/mo
$710,000 down
$2,840,000 loan
Principal & interest$18,420
Property tax (est.)$2,958
Home insurance (est.)$150

Similar homes you might like

No photo
$4,250,000
160 Sand Hill Cove Road
Narragansett, 02882
4 bd·2.1 ba·3,086 sqft
Listed by Jim Durkin
No photo
$4,250,000
0 South Harbor (10H) Drive S
Portsmouth, 02840
4 bd·4.1 ba·4,932 sqft
Listed by Michelle Aumann
No photo
$4,200,000
6 Chapel Place
Westerly, 02891
3 bd·2 ba·1,674 sqft
Listed by Donna Krueger-Simmons
No photo
$4,199,000
15 Courageous Circle
Bristol, 02809
5 bd·4.1 ba·7,212 sqft
Listed by Beth Davis
No photo
$4,150,000
155 D West Main Road
Little Compton, 02837
3 bd·2.1 ba·6,049 sqft
Listed by Cherry Arnold
No photo
$4,100,000
325 Post Road
Westerly, 02891
5 bd·6.1 ba·4,260 sqft
Listed by Kathleen Pupa
No photo
$3,995,000
99 Meadowlark Lane
Portsmouth, 02871
5 bd·4.2 ba·7,061 sqft
Listed by The Hadfield Group
No photo
$3,995,000
694 Charlestown Beach Road
Charlestown, 02813
3 bd·2 ba·1,408 sqft
Listed by Patricia Berg

Data source: Listing information provided by Rhode Island Association of REALTORS via Trestle/CoreLogic. Last updated June 26, 2026.

Information herein deemed reliable but not guaranteed; all measurements, school assignments, HOA fees, taxes, and feature lists are approximate and should be independently verified. Equal Housing Opportunity.