Welcome to your dream coastal retreat on an expansive 2.9 acres of prime waterfront real estate. This beautifully renovated 4 bedroom and 3 1/2 bath estate offers direct walk-out access to the beach and sweeping unobstructed water views from nearly every room. This one-of-a- kind property, blends modern and comfort with timeless elegance. Inside the home has been completely updated featuring brand new hardwood floors, fresh designer paint throughout and an open-concept floor plan, ideal for both everyday living and entertaining. Oversized windows flood the space with natural light and frame picture perfect views of the shoreline. The fully renovated primary suite is a true sanctuary, offering panoramic water views, an en-suite bathroom and a private balcony overlooking the beach. Additional highlights include air conditioning, oversized deck, mooring rights and an attached 3-car garage with conversion potential for guest quarters or a studio and a seamless indoor-outdoor flow to the water's edge. The 2.9-acre lot offers the rare opportunity to a possible subdivide and develop an additional parcel-ideal for a guest home, investment property, or resale. This exceptional property delivers on every level. Private tours available by appointment only.
Sold for $1,800,000 on 11/05/25
$1,800,000
25 Ives Rd, Warwick, RI 02818
4beds
2,504sqft
Single Family Residence
Built in 1985
2.9 Acres Lot
$1,780,500 Zestimate®
$719/sqft
$4,486 Estimated rent
Home value
$1,780,500
$1.62M - $1.96M
$4,486/mo
Zestimate® history
Loading...
Owner options
Explore your selling options
What's special
Zillow last checked: 8 hours ago
Listing updated: November 05, 2025 at 10:33am
Listed by:
Terry Cipolla 401-787-0512,
First Choice Real Estate Group
Bought with:
Slocum Home Team
eXp Realty
Source: StateWide MLS RI,MLS#: 1394531
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 4
- Full bathrooms: 3
- 1/2 bathrooms: 1
Primary bedroom
- Level: Second
Bathroom
- Level: First
Bathroom
- Level: Second
Other
- Level: Second
Other
- Level: First
Other
- Level: Second
Dining area
- Level: First
Family room
- Level: First
Other
- Level: First
Kitchen
- Level: First
Heating
- Natural Gas, Forced Air
Cooling
- Central Air
Appliances
- Included: Gas Water Heater, Dishwasher, Range Hood, Microwave, Oven/Range, Refrigerator
Features
- Wall (Dry Wall), Cathedral Ceiling(s), Plumbing (Mixed), Ceiling Fan(s)
- Flooring: Ceramic Tile, Hardwood
- Doors: Storm Door(s)
- Windows: Insulated Windows
- Basement: None
- Has fireplace: No
- Fireplace features: None
Interior area
- Total structure area: 2,504
- Total interior livable area: 2,504 sqft
- Finished area above ground: 2,504
- Finished area below ground: 0
Property
Parking
- Total spaces: 8
- Parking features: Integral, Driveway
- Attached garage spaces: 3
- Has uncovered spaces: Yes
Features
- Patio & porch: Deck, Patio
- Has view: Yes
- View description: Water
- Has water view: Yes
- Water view: Water
- Waterfront features: Waterfront, Mooring, Ocean Front, Saltwater Front, Walk To Water
Lot
- Size: 2.90 Acres
- Features: Sprinklers
Details
- Parcel number: WARWM201B0185L0000
- Special conditions: Conventional/Market Value
- Other equipment: Cable TV
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Contemporary
- Property subtype: Single Family Residence
Materials
- Dry Wall, Vinyl Siding
- Foundation: Concrete Perimeter
Condition
- New construction: No
- Year built: 1985
Utilities & green energy
- Electric: 150 Amp Service
- Sewer: Septic Tank
- Utilities for property: Water Connected
Community & neighborhood
Security
- Security features: Security System Owned
Community
- Community features: Golf, Highway Access, Marina, Private School, Public School, Recreational Facilities, Restaurants, Schools, Near Shopping, Near Swimming, Tennis
Location
- Region: Warwick
- Subdivision: Potowomut
Price history
| Date | Event | Price |
|---|---|---|
| 11/5/2025 | Sold | $1,800,000-5%$719/sqft |
Source:  StateWide MLS RI #1394531 | ||
| 10/7/2025 | Pending sale | $1,895,000$757/sqft |
Source: StateWide MLS RI #1394531 | ||
| 9/17/2025 | Contingent | $1,895,000$757/sqft |
Source: StateWide MLS RI #1394531 | ||
| 9/8/2025 | Listed for sale | $1,895,000+22.3%$757/sqft |
Source: StateWide MLS RI #1394531 | ||
| 11/7/2024 | Listing removed | $1,550,000$619/sqft |
Source: StateWide MLS RI #1369261 | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | $14,817 | $1,024,000 |
| 2024 | $14,817 +2% | $1,024,000 |
| 2023 | $14,531 +20.2% | $1,024,000 +58.6% |
Find assessor info on the county website
Neighborhood: 02818
Nearby schools
GreatSchools rating
- 5/10Cedar Hill SchoolGrades: K-5Distance: 3.2 mi
- 5/10Winman Junior High SchoolGrades: 6-8Distance: 4.8 mi
- 5/10Toll Gate High SchoolGrades: 9-12Distance: 4.8 mi
Get pre-qualified for a loan
At Zillow Home Loans, we can pre-qualify you in as little as 5 minutes with no impact to your credit score.An equal housing lender. NMLS #10287.
Sell for more on Zillow
Get a free Zillow Showcase℠ listing and you could sell for .
$1,780,500
2% more+ $35,610
With Zillow Showcase(estimated)
$1,816,110