140 Aldrich Ave, Warwick, RI, 02889
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.
Getting Around
Car-Dependent
No Nearby Transit
Somewhat BikeableSchools
Construction
Condition
- Year built: 1932
Materials
- Foundation: Mixed
- Construction materials: Ceramic,Dry Wall,Plaster,Shingles,Wood
Type & Style
- Home type: SingleFamily
- Architectural style: Colonial,Contemporary
- Property subType: Single Family Residence
Interior
Appliances
- Appliances included: Dishwasher,Dryer,Disposal,Range Hood,Microwave,Oven/Range,Refrigerator,Washer
Basement
- Has basement: Yes
- Basement: Partial,Interior Entry,Unfinished,Storage Space,Utility,Work Shop
Bathroom
- Level: Second
Bathroom
- Level: Second
Bathroom
- Level: First
Bathroom
- Level: First
Bedrooms & Bathrooms
- Bedrooms: 5
- Bathrooms: 5
- Full bathrooms: 4
- 1/2 bathrooms: 1
Dining Room
- Level: First
Family Room
- Level: First
Features
- Wall (Cermaic),Wall (Dry Wall),Wall (Plaster),Cedar Closet(s)(s),Plumbing (Mixed),Insulation (Cap),Insulation (Unknown),Insulation (Walls)
- Window features: Insulated Windows
- Flooring: Ceramic Tile,Hardwood
- Number of fireplaces: 1
- Fireplace features: Brick
- Fireplace: Yes
- Attic: Attic Stairs, Attic Storage
- Finished area below ground: 0
- Finished area above ground: 4,661
Heating & Cooling
- Heating features: Electric,Solar,Baseboard,Forced Air,Heat Pump,Zoned
- Cooling features: Central Air,Ductless,Heat Pump
Interior Area
- Total structure area: 4,661
- Total interior livable area: 4,661 sqft
Kitchen
- Level: First
Living Room
- Level: First
Master Bedroom
- Level: Second
Mud Room
- Level: First
Other
- Level: Second
Other
- Level: Second
Other
- Level: Second
Other
- Level: Second
Other
- Level: First
Other
- Level: First
Other
- Level: Second
Porch
- Level: First
Storage
- Level: Lower
Sun Room
- Level: First
Property
Details
- Parcel number: WARWM381B0055L0000
- Zoning: A-40
- Other equipment: Cable TV,Hot Tub,Fuel Tank(s)
Features
- Pool features: In Ground
- Patio & porch: Patio,Porch
- Spa features: Hot Tub
- Fencing: Fenced
- Has view: Yes
- View description: Water
- Has water view: Yes
- Water view: Water
- On waterfront: Yes
- Waterfront features: Waterfront,Access,Beach,Mooring,Walk to Salt Water
Lot
- Lot size: 2.16 Acres
- Features: Sprinklers
Parking
- Total spaces: 8
- Parking features: Detached,Garage Door Opener,Driveway
- Has garage: Yes
- Attached garage spaces: 2
- Covered spaces: 2
- Has uncovered spaces: Yes
Climate Risk is Financial Risk
Every home has a financial story beyond the listing price. Below, you’ll see the climate risks that could affect this property — and in Bills & Affordability, how those risks may influence repairs, insurance, utilities, and long-term value.
Biggest Threats for This Home
- Coastal Flooding
- Tsunami
How This Home’s Risks Compare
FEMA Declared Disasters Across Rhode Island Counties
Understanding the Costs
Financial advisors generally recommend spending no more than 30% of your gross household income on housing costs. In practice, many households stretch to 35% or beyond — especially in high-cost markets.
Estimated Costs Today
| Monthly | Annual | |
|---|---|---|
| Mortgage | $17,950 | $215,400 |
| Home Insurance * | $1,713 | $20,556 |
| Property Taxes | $4,155 | $49,860 |
| Electricity | $949 | $11,391 |
| Total | $24,767 | $297,204 |
Income You'd Need if You Spent...
Rhode Island FAIR Plan Programs
How Costs Could Change Over Time
Climate risk is quickly impacting all of the major home ownership costs. Adjust the growth rates and percentage of income spent on housing below to see how your housing costs could change over the next 10 years — and what income you'd need to keep up.
Comparing Against the Market
Price Per Sq Ft
vs Other Active Listings
Avg $/sqft
vs Homes Sold Last Month
Median $/sqft
Current Market Trends
Median Price Per Square Foot
The median price per square foot of homes sold in this area each month. Compare this to this listing's price per square foot to gauge whether the home is priced in line with recent sales.
Historicals for This Listing
Zestimate History ($/sqft)
Price History
| Date | Event | Price |
|---|---|---|
| 2026-06-26 | Listed for sale | $3,550,000 |
| 2020-09-03 | Sold | $865,000 |
| 2020-07-31 | Listed for sale | $949,900 |
| 2020-03-12 | Listing removed | $999,000 |
| 2019-10-24 | Price change | $999,000 |
| 2019-07-11 | Listed for sale | $1,125,000 |
View on Zillow