Water Views - Golf Course
Address
140 Aldrich Avenue, Warwick, RI
Price
$ 3,250,000
Property Attributes
- MLS#1422041
- TypeSingle Family
- Listing Status Active
- CountyKent
- CityWarwick
- NeighborhoodWarwick Neck
- Zip02889
- Style
- Year Built1932
- Taxes$ 20985
- Price$ 3,250,000
- Bedrooms5
- Full Bathrooms4
- Half Bathrooms1
- Sqr Footage4661
- Lot Size2.159 Acres
Data Source:
Rhode Island Statewide MLS (RIAR)
Property Description
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.
| Price History | |
|---|---|
| 8/31/2026 | Listed $3,250,000 |
General Features
| Sewer | Septic Tank |
|---|---|
| Heating | Baseboard,Electric,Forced Air,Heat Pump,Solar,Zoned |
| Cooling | Central Air,Ductless,Heat Pump |
| Possession | Negotiable |
| Zoning | A-40 |
| Garage Spaces | 2 |
| Patio/Porch Features | Patio,Porch |
| Pool Features | In Ground |
| Security Features | Security System Owned |
| Construction Materials | Drywall,Plaster,Shingle Siding,Wood Siding |
| Year Built | 1932 |
| Electric | 200+ Amp Service,Circuit Breakers,Generator,220 Volts |
| View | Saltwater,Water |
| Stories Count | 2 |
| Levels | Two |
| Property Subtype | Single Family Residence |
| Tax Year | 2026 |
| Waterfront Features | Beach Access,Mooring,Water Access,Walk to Water,Waterfront |
| Community Features | Golf,Highway Access,Near Schools,Pool,Recreation Area,Restaurant,Shopping,Tennis Court(s) |
| County | Kent |
| New Construction | false |
| Property Type | Residential |
| Attached Garage | false |
| Energy Efficient | Doors,HVAC,Insulation,Roof,Windows |
| Subdivision Name | Warwick Neck |
| Garage Y/N | true |
| Green Energy Generation | Solar |
| Green Indoor Air Quality | Moisture Control,Ventilation |
| Other Structures | Outbuilding |
| Total Rooms | 10 |
| Full Baths | 4 |
| Status | Active |
| City | Warwick |
| Senior Community Y/N | false |
| Lot Size Units | Square Feet |
| Lot Size Square Feet | 94046 |
| Spa Features | Hot Tub |
| Land Lease Y/N | false |
| Tax Annual Amount | 20985 |
| Standard Status | Active |
| Tax Assessed Value | 1597000 |
| Tax Lot | 55 |
| Property Sub Type Additional | Single Family Residence |
Interior Features
| Interior Amenities | Attic,Bathtub,Cedar Closet(s),Permanent Attic Stairs,Storage,Stall Shower,Tub Shower,Cable TV |
|---|---|
| Basement | Interior Entry,Partial,Unfinished |
| Flooring | Ceramic Tile,Hardwood |
| Total Fireplaces | 1 |
| Fireplace Features | Masonry |
| Total Stories | 2 |
| Basement (Y/N) | true |
| Air Conditioning Y/N | true |
| Heating Y/N | true |
| Window Features | Thermal Windows |
| Fireplace Y/N | true |
| Half Baths | 1 |
| Total Bedrooms | 5 |
| LivingAreaSource | Other |
| Total Baths | 5 |
Exterior Features
| Exterior Amenities | Porch,Patio,Sprinkler/Irrigation,Paved Driveway |
|---|---|
| Fencing | Fenced |
| Parking Features | Detached,Garage,Garage Door Opener |
| Lot Features | Sprinkler System,Waterfront |
| Water Source | Connected,Public |
| Total Parking | 8 |
| Inclusions | House: 4,661 SF Garage studio: 923 SF Cabana: 229 SF |
| Lot Size Area | 94046 |
| Foundation Details | Combination |
| Spa | true |
| Building Area Total | 4661 |
| Lot Size Acres | 2.159 |
| Waterfront Y/N | true |
| Covered Spaces | 2 |
Amenities
- Foreclosure
- Views
- Short Sale
- New Construction
- Adult 55+
- Lease To Own
- No HOA Fees
- Furnished
- Primary On Main
- Air Conditioning
- Seller Finance
- Green
- Fixer Upper
- Horse
- Golf
- Fireplace
- Deck
- Garage
- Basement
- Pool
Property vs Single Family Average in 02889
Price
Taxes
Year Built
Massachusetts MLS Property Info Network (MLSPIN) - The property listing data and information set forth herein were provided to MLS Property Information Network, Inc. from third party sources, including sellers, lessors and public records, and were compiled by MLS Property Information Network, Inc. The property listing data and information are for the personal, non commercial use of consumers having a good faith interest in purchasing or leasing listed properties of the type displayed to them and
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.
The data relating to real estate for sale on this website appears in part through the SMARTMLS Internet Data Exchange program, a voluntary cooperative exchange of property listing data between licensed real estate brokerage firms, and is provided by SMARTMLS through a licensing agreement. Listing information is from various brokers who participate in the SMARTMLS IDX program and not all listings may be visible on the site. The property information being provided on or through the website is for the
