Dusty Batten
← INNOVATE Real Estate
Single Family Residence at 140 Aldrich Avenue, Warwick
Single Family Residence at 140 Aldrich Avenue, Warwick, photo 2 of 50
Single Family Residence at 140 Aldrich Avenue, Warwick, photo 3 of 50
Single Family Residence at 140 Aldrich Avenue, Warwick, photo 4 of 50
Single Family Residence at 140 Aldrich Avenue, Warwick, photo 5 of 50
Single Family Residence at 140 Aldrich Avenue, Warwick, photo 6 of 50
Single Family Residence at 140 Aldrich Avenue, Warwick, photo 7 of 50
Single Family Residence at 140 Aldrich Avenue, Warwick, photo 8 of 50
Single Family Residence at 140 Aldrich Avenue, Warwick, photo 9 of 50
Single Family Residence at 140 Aldrich Avenue, Warwick, photo 10 of 50
Single Family Residence at 140 Aldrich Avenue, Warwick, photo 11 of 50
Single Family Residence at 140 Aldrich Avenue, Warwick, photo 12 of 50
Single Family Residence at 140 Aldrich Avenue, Warwick, photo 13 of 50
Single Family Residence at 140 Aldrich Avenue, Warwick, photo 14 of 50
Single Family Residence at 140 Aldrich Avenue, Warwick, photo 15 of 50
Single Family Residence at 140 Aldrich Avenue, Warwick, photo 16 of 50
Single Family Residence at 140 Aldrich Avenue, Warwick, photo 17 of 50
Single Family Residence at 140 Aldrich Avenue, Warwick, photo 18 of 50
Single Family Residence at 140 Aldrich Avenue, Warwick, photo 19 of 50
Single Family Residence at 140 Aldrich Avenue, Warwick, photo 20 of 50
Single Family Residence at 140 Aldrich Avenue, Warwick, photo 21 of 50
Single Family Residence at 140 Aldrich Avenue, Warwick, photo 22 of 50
Single Family Residence at 140 Aldrich Avenue, Warwick, photo 23 of 50
Single Family Residence at 140 Aldrich Avenue, Warwick, photo 24 of 50
Single Family Residence at 140 Aldrich Avenue, Warwick, photo 25 of 50
Single Family Residence at 140 Aldrich Avenue, Warwick, photo 26 of 50
Single Family Residence at 140 Aldrich Avenue, Warwick, photo 27 of 50
Single Family Residence at 140 Aldrich Avenue, Warwick, photo 28 of 50
Single Family Residence at 140 Aldrich Avenue, Warwick, photo 29 of 50
Single Family Residence at 140 Aldrich Avenue, Warwick, photo 30 of 50
Single Family Residence at 140 Aldrich Avenue, Warwick, photo 31 of 50
Single Family Residence at 140 Aldrich Avenue, Warwick, photo 32 of 50
Single Family Residence at 140 Aldrich Avenue, Warwick, photo 33 of 50
Single Family Residence at 140 Aldrich Avenue, Warwick, photo 34 of 50
Single Family Residence at 140 Aldrich Avenue, Warwick, photo 35 of 50
Single Family Residence at 140 Aldrich Avenue, Warwick, photo 36 of 50
Single Family Residence at 140 Aldrich Avenue, Warwick, photo 37 of 50
Single Family Residence at 140 Aldrich Avenue, Warwick, photo 38 of 50
Single Family Residence at 140 Aldrich Avenue, Warwick, photo 39 of 50
Single Family Residence at 140 Aldrich Avenue, Warwick, photo 40 of 50
Single Family Residence at 140 Aldrich Avenue, Warwick, photo 41 of 50
Single Family Residence at 140 Aldrich Avenue, Warwick, photo 42 of 50
Single Family Residence at 140 Aldrich Avenue, Warwick, photo 43 of 50
Single Family Residence at 140 Aldrich Avenue, Warwick, photo 44 of 50
Single Family Residence at 140 Aldrich Avenue, Warwick, photo 45 of 50
Single Family Residence at 140 Aldrich Avenue, Warwick, photo 46 of 50
Single Family Residence at 140 Aldrich Avenue, Warwick, photo 47 of 50
Single Family Residence at 140 Aldrich Avenue, Warwick, photo 48 of 50
Single Family Residence at 140 Aldrich Avenue, Warwick, photo 49 of 50
Single Family Residence at 140 Aldrich Avenue, Warwick, photo 50 of 50
50 photos

$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
10
On market date
June 23, 2026
Stories
N/A
Total bathrooms
5
Garage spaces
2
Parking spaces
8
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

105 Charlotte Drive
New
$3,500,000
105 Charlotte Drive
Warwick, 02818
3 bd·3.1 ba·4,318 sqft
0 days on market
Waterfront
Listed by Lori Joyal
30 Angell Court
$3,500,000
30 Angell Court
Warwick, 02889
4 bd·5.1 ba·5,914 sqft
61 days on market
Waterfront
Listed by Sandy Pellegrino
57 Old Forge Road
$2,985,000
57 Old Forge Road
Warwick, 02818
6 bd·4.2 ba·5,095 sqft
46 days on market
Waterfront
Listed by Dean deTonnancourt

Data source: Listing information provided by Rhode Island Association of REALTORS via Trestle/CoreLogic. Last updated July 7, 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.