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
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.
