Stately renovated, this exceptional four-bed residence is perfectly sited on a premium lot within the sought-after Seventeen Farms neighborhood. Thoughtfully redesigned with local DesignBuild group REDHOUSE, this sun-filled home is tailored for elegant entertaining and effortless daily living. At its center, a designer kitchen showcases striking marble countertops, large pantry with sliding barn door, and top-tier stainless appliances. A generous island with seating transitions into the family room, framed by oversized windows, bespoke built-ins and a gas fireplace, creating a warm yet refined gathering space. Sliding glass doors extend the living experience outdoors to a beautifully constructed cobblestone patio, enveloped by a granite stone wall and anchored by a charming fire pit. Entertain in Dining Room with crown moldings, custom window seat and hardwoods. First floor flex space for Home Office with full bathroom and custom tile walk in shower. The second level reveals a luxurious primary suite highlighted by a one-of-a-kind spa bath. This extraordinary space features a frameless glass shower with solid Corian walls, marble finishes, and heated floors. Spacious Walk in Closet with custom shelving. Three additional generously proportioned bedrooms, a newly updated full bath complete upstairs. The finished lower adds versatile living space and includes a 300-bottle wine cellar, ideal for the discerning collector. Significant upgrades include roof, HVAC, electrical, & more
Under contract
$965,000
442 Sleepy Hollow Farm Rd, Warwick, RI 02886
4beds
3,226sqft
Est.:
Single Family Residence
Built in 1997
0.44 Acres Lot
$-- Zestimate®
$299/sqft
$-- HOA
What's special
Generous island with seatingGas fireplaceDesigner kitchenGranite stone wallSun-filled homeHeated floorsCharming fire pit
- 26 days |
- 3,467 |
- 134 |
Likely to sell faster than
Zillow last checked: 7 hours ago
Listing updated: March 15, 2026 at 10:01pm
Listed by:
Dean Benjamin 401-965-0225,
RE/MAX Professionals
Source: StateWide MLS RI,MLS#: 1405801
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 4
- Full bathrooms: 3
- 1/2 bathrooms: 1
Primary bedroom
- Level: Second
- Area: 252 Square Feet
- Dimensions: 18
Bathroom
- Level: First
- Area: 36 Square Feet
- Dimensions: 9
Bathroom
- Level: First
- Area: 12 Square Feet
- Dimensions: 3
Other
- Level: Second
- Area: 110 Square Feet
- Dimensions: 11
Other
- Level: Second
- Area: 144 Square Feet
- Dimensions: 12
Other
- Level: Second
- Area: 99 Square Feet
- Dimensions: 11
Dining room
- Level: First
- Area: 120 Square Feet
- Dimensions: 12
Family room
- Level: First
- Area: 300 Square Feet
- Dimensions: 15
Other
- Level: First
- Area: 98 Square Feet
- Dimensions: 14
Kitchen
- Level: First
- Area: 306 Square Feet
- Dimensions: 18
Other
- Level: Second
Office
- Level: First
- Area: 126 Square Feet
- Dimensions: 14
Recreation room
- Level: Lower
- Area: 494 Square Feet
- Dimensions: 19
Storage
- Level: Lower
- Area: 506 Square Feet
- Dimensions: 22
Other
- Level: Lower
- Area: 27 Square Feet
- Dimensions: 9
Heating
- Natural Gas, Forced Air
Cooling
- Central Air
Appliances
- Included: Gas Water Heater
Features
- Wall (Dry Wall), Plumbing (Mixed), Insulation (Ceiling), Insulation (Floors), Insulation (Walls)
- Flooring: Hardwood
- Basement: Full,Interior Entry,Partially Finished,Media Room,Wine Cellar
- Number of fireplaces: 1
- Fireplace features: Gas
Interior area
- Total structure area: 2,626
- Total interior livable area: 3,226 sqft
- Finished area above ground: 2,626
- Finished area below ground: 600
Property
Parking
- Total spaces: 4
- Parking features: Attached, Driveway
- Attached garage spaces: 2
- Has uncovered spaces: Yes
Features
- Patio & porch: Patio, Porch
Lot
- Size: 0.44 Acres
- Features: Cul-De-Sac, Sidewalks, Sprinklers, Wooded
Details
- Parcel number: WARWM229B0014L0000
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Colonial
- Property subtype: Single Family Residence
Materials
- Dry Wall, Vinyl Siding
- Foundation: Concrete Perimeter
Condition
- New construction: No
- Year built: 1997
Utilities & green energy
- Electric: 200+ Amp Service
- Sewer: Septic Tank
- Utilities for property: Water Connected
Community & HOA
Community
- Features: Near Public Transport, Commuter Bus, Highway Access, Hospital, Interstate, Private School, Public School, Recreational Facilities, Restaurants, Schools, Near Shopping, Tennis
- Subdivision: Seventeen Farms
HOA
- Has HOA: No
Location
- Region: Warwick
Financial & listing details
- Price per square foot: $299/sqft
- Tax assessed value: $707,300
- Annual tax amount: $9,595
- Date on market: 3/4/2026
Estimated market value
Not available
Estimated sales range
Not available
Not available
Price history
Price history
| Date | Event | Price |
|---|---|---|
| 3/9/2026 | Contingent | $965,000$299/sqft |
Source:  StateWide MLS RI #1405801 Report a problem | ||
| 3/4/2026 | Listed for sale | $965,000+24.5%$299/sqft |
Source: StateWide MLS RI #1405801 Report a problem | ||
| 12/30/2022 | Sold | $775,000+6.9%$240/sqft |
Source: StateWide MLS RI #1325703 Report a problem | ||
| 12/9/2022 | Pending sale | $724,900$225/sqft |
Source: StateWide MLS RI #1325703 Report a problem | ||
| 11/30/2022 | Listed for sale | $724,900+27.2%$225/sqft |
Source: StateWide MLS RI #1325703 Report a problem | ||
| 1/16/2018 | Sold | $570,000+0%$177/sqft |
Source: StateWide MLS RI #1178338 Report a problem | ||
| 11/25/2017 | Listed for sale | $569,900+25.9%$177/sqft |
Source: Williams & Stuart Real Estate #1178338 Report a problem | ||
| 3/22/2013 | Sold | $452,500-3.7%$140/sqft |
Source: Public Record Report a problem | ||
| 1/17/2013 | Listed for sale | $469,900+9.3%$146/sqft |
Source: RI Real Estate Services #1032149 Report a problem | ||
| 7/15/2011 | Sold | $430,000-2.3%$133/sqft |
Source: Public Record Report a problem | ||
| 3/19/2011 | Listed for sale | $439,900+28.1%$136/sqft |
Source: RE/MAX METRO #987068 Report a problem | ||
| 8/7/2001 | Sold | $343,500+43.1%$106/sqft |
Source: Public Record Report a problem | ||
| 4/30/1998 | Sold | $240,000$74/sqft |
Source: Public Record Report a problem | ||
Public tax history
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | $10,235 | $707,300 |
| 2024 | $10,235 +3.2% | $707,300 +1.2% |
| 2023 | $9,920 -1% | $699,100 +30.7% |
| 2022 | $10,019 | $534,900 |
| 2021 | $10,019 | $534,900 |
| 2020 | $10,019 | $534,900 |
| 2019 | $10,019 +21.7% | $534,900 +35.2% |
| 2018 | $8,231 +2.8% | $395,700 |
| 2017 | $8,009 | $395,700 |
| 2016 | $8,009 +3.7% | $395,700 +6.3% |
| 2015 | $7,723 +3.4% | $372,200 |
| 2014 | $7,466 +1.4% | $372,200 |
| 2013 | $7,366 +6.6% | $372,200 -4.7% |
| 2011 | $6,908 +1.2% | $390,500 |
| 2010 | $6,826 -2.1% | $390,500 -20.8% |
| 2009 | $6,970 +5.4% | $492,900 |
| 2008 | $6,610 +3% | $492,900 +18.7% |
| 2007 | $6,417 | $415,100 |
| 2006 | $6,417 +4.4% | $415,100 |
| 2004 | $6,148 -0.7% | $415,100 +86.5% |
| 2003 | $6,194 | $222,560 |
Find assessor info on the county website
BuyAbility℠ payment
Est. payment
$6,013/mo
Principal & interest
$4976
Property taxes
$1037
More affordability tools
Climate risks
Neighborhood: 02886
Nearby schools
GreatSchools rating
- 7/10Scott SchoolGrades: K-5Distance: 1.9 mi
- 5/10Winman Junior High SchoolGrades: 6-8Distance: 2 mi
- 5/10Toll Gate High SchoolGrades: 9-12Distance: 2 mi
Local experts in 02886
- Rhode Island
- Kent County
- Warwick
- 02886
- 442 Sleepy Hollow Farm Rd
Nearby cities
Nearby zip codes
Other Warwick Topics
