Welcome to this beautiful 4 bed Colonial on a corner lot in Seventeen Farms! This home has been lovingly cared for and has so much to offer including new hardwood floors on the main level, fresh paint throughout, laundry on the 2nd floor, updated 2.5 baths, primary bedroom with private bath & walk in closet, cathedral ceilings in living room, formal dining room, office/flex room on main level, finished family room, and workout/storage room in lower level. Enjoy gas heat, central air, gas fireplace, 2 car garage, new shed, brick front exterior, irrigation system, wired for invisible fence, wood deck, underground utilities, town water, private septic. Appliances and washer/dryer set are included. Conveniently located near schools, EG Main St shops, dining, Greenwich Cove, parks, theater, market, and so much more!
Sold for $830,000 on 06/20/25
$830,000
476 Sleepy Hollow Farm Rd, Warwick, RI 02886
4beds
2,705sqft
Single Family Residence
Built in 1997
0.43 Acres Lot
$818,200 Zestimate®
$307/sqft
$4,234 Estimated rent
Home value
$818,200
$777,000 - $859,000
$4,234/mo
Zestimate® history
Loading...
Owner options
Explore your selling options
What's special
Zillow last checked: 8 hours ago
Listing updated: August 25, 2025 at 07:08am
Listed by:
The Stone Alliance Team 401-623-1419,
Coldwell Banker Realty
Bought with:
Skylar Ceceri, RES.0049233
Lane Ceceri Group
Source: StateWide MLS RI,MLS#: 1382819
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 3
- Full bathrooms: 2
- 1/2 bathrooms: 1
Primary bedroom
- Level: Second
Bathroom
- Level: First
Bathroom
- Level: Second
Other
- Level: Second
Other
- Level: Second
Other
- Level: Second
Laundry
- Level: Second
Heating
- Natural Gas, Central, Forced Air, Heat Pump
Cooling
- Central Air, Ductless
Appliances
- Included: Gas Water Heater, Dishwasher, Dryer, Microwave, Oven/Range, Refrigerator, Washer
Features
- Wall (Dry Wall), Cathedral Ceiling(s), Stairs, Plumbing (Mixed), Insulation (Unknown), Ceiling Fan(s)
- Flooring: Ceramic Tile, Hardwood, Carpet
- Windows: Insulated Windows
- Basement: Full,Interior Entry,Partially Finished,Family Room,Office,Storage Space,Utility,Workout Room
- Number of fireplaces: 1
- Fireplace features: Gas
Interior area
- Total structure area: 2,265
- Total interior livable area: 2,705 sqft
- Finished area above ground: 2,265
- Finished area below ground: 440
Property
Parking
- Total spaces: 6
- Parking features: Attached, Garage Door Opener, Integral, Driveway
- Attached garage spaces: 2
- Has uncovered spaces: Yes
Features
- Patio & porch: Deck
Lot
- Size: 0.43 Acres
- Features: Corner Lot, Cul-De-Sac, Sprinklers
Details
- Additional structures: Outbuilding
- Parcel number: WARWM229B0011L0000
- Zoning: RES
- Special conditions: Conventional/Market Value
- Other equipment: Cable TV
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Colonial
- Property subtype: Single Family Residence
Materials
- Dry Wall, Brick, Vinyl Siding
- Foundation: Concrete Perimeter
Condition
- New construction: No
- Year built: 1997
Utilities & green energy
- Electric: 100 Amp Service
- Sewer: Septic Tank
- Water: Public
- Utilities for property: Underground Utilities, Water Connected
Community & neighborhood
Community
- Community features: Near Public Transport, Golf, Highway Access, Interstate, Private School, Public School, Recreational Facilities, Restaurants, Schools, Near Shopping
Location
- Region: Warwick
- Subdivision: Seventeen Farms
HOA & financial
HOA
- Has HOA: No
- HOA fee: $325 annually
Price history
| Date | Event | Price |
|---|---|---|
| 6/20/2025 | Sold | $830,000+3.9%$307/sqft |
Source:  StateWide MLS RI #1382819 | ||
| 4/29/2025 | Pending sale | $799,000$295/sqft |
Source: StateWide MLS RI #1382819 | ||
| 4/24/2025 | Listed for sale | $799,000+25%$295/sqft |
Source: StateWide MLS RI #1382819 | ||
| 8/24/2022 | Sold | $639,000$236/sqft |
Source: StateWide MLS RI #1315933 | ||
| 7/27/2022 | Contingent | $639,000$236/sqft |
Source: StateWide MLS RI #1315933 | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | $8,864 | $612,600 |
| 2024 | $8,864 +2% | $612,600 |
| 2023 | $8,693 +5% | $612,600 +38.6% |
Find assessor info on the county website
Neighborhood: 02886
Nearby schools
GreatSchools rating
- 9/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
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 .
$818,200
2% more+ $16,364
With Zillow Showcase(estimated)
$834,564