OFF MARKET

Off market jun 2025 for $830K

$828,780

•

2,705

sq ft

476 Sleepy Hollow Farm Rd, Warwick, RI 02886

About this home

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!

Single-familyProperty Type

1997Year Built

0.43 acresLot Size

$306Est. Price/Sq.Ft.

2 car garageParking

Listed by The Stone Alliance Team • Coldwell Banker Realty

Bought with Skylar Ceceri • Lane Ceceri Group

Redfin checked: a minute ago

•Source:RIS #1382819

Redfin Estimate

$828,780

$1,220 since sold in June 2025$25K since October

Recently sold homes
Estimate history
Homes for sale

This home's estimate is 0.9% lower than the average sale price ($836K) of 6 comparable homes.

SOLD JUL 22, 2026
$814,000
A
4 beds2.5 baths2,724 sq ft
115 Castle Rock Rd, Warwick, RI 02886
SOLD JUL 24, 2026
$785,000
B
4 beds2.5 baths2,754 sq ft
193 Sleepy Hollow Farm Rd, Warwick, RI 02886
SOLD JUN 2, 2026
$930,000
C
4 beds2.5 baths2,722 sq ft
94 Castle Rocks Rd, Warwick, RI 02886
SOLD JUL 14, 2026
$923,000
D
4 beds2.5 baths3,229 sq ft
283 Castle Rocks Rd, Warwick, RI 02886
SOLD OCT 22, 2026
$645,000
E
4 beds2.5 baths3,020 sq ft
33 Old Oak Dr, Warwick, RI 02886
SOLD JUN 2, 2026
$920,000
F
4 beds2.5 baths3,534 sq ft
105 Castle Rocks Rd, Warwick, RI 02886

Claim this home to receive a free report every month with insights on the changing estimate.

Earn from this home

Sell

$131,123

Est. take-home

List your home with Redfin and save $8,288

Rent

$2,214/mo

Redfin rental estimate

List your home for rent

Market trends in 02886, RI

Last updated October 2026

Buyer's Market

Seller's Market

Seller's market

Sale-to-list price

100.7%

0.7% MoM

Median sale price

$461K

$33K MoM

Avg. days on market

29d

1 days MoM

Recently sold homes

115

5 MoM

New listings for sale

NEW 12 HRS AGO
$649,900
4 beds2.5 baths2,491 sq ft
765 Toll Gate Rd, Warwick, RI 02886
COMING SOON
$399,900
2 beds2 baths1,403 sq ft
662 Orleans Ct, Warwick, RI 02886
OPEN SUN, 1PM TO 2:30PM
$355,000
2 beds1 bath960 sq ft
28 Elmer Ave, Warwick, RI 02886
OPEN SAT, 11:30AM TO 1PM
$524,900
6 beds2 baths3,780 sq ft
855 Jefferson Blvd, Warwick, RI 02886
OPEN SAT, 12PM TO 2PM
$499,000
3 beds2 baths1,732 sq ft
3275 West Shore Rd, Warwick, RI 02888
OPEN SAT, 10:30AM TO 12PM
$429,000
3 beds2 baths1,425 sq ft
881 Greenwich Ave #12, Warwick, RI 02886
OPEN TODAY, 4:30PM TO 6PM
$215,000
1 bed1 bath690 sq ft
3524 W Shore Rd #309, Warwick, RI 02886
$379,000
2 beds1 bath960 sq ft
105 Airway Rd, Warwick, RI 02886
$355,000
2 beds1 bath1,073 sq ft
882 Halifax Dr, Warwick, RI 02886
OPEN SAT, 10AM TO 11AM
$899,900
4 beds3 baths2,260 sq ft
81 83 Cadora Ave, Warwick, RI 02886
See all

Provided by Redfin

Sale history for 476 Sleepy Hollow Farm Rd

Date

Event

Price

RIS #1382819

Jun 20, 2025

Sold

$830,000

$307/sq ft

Apr 28, 2025

Pending

—

Apr 24, 2025

Listed

$799,000

$295/sq ft

RIS #1315933

Aug 24, 2022

Sold

$639,000

$236/sq ft

Jul 27, 2022

Contingent

—

Jul 22, 2022

Listed

$639,000

$236/sq ft

+32

Year

Property tax

Land + Additions

Assessment*

2025

$8,352 (−5.8%)

$158,600 + $499,000

$657,600

2024

$8,864 (+2.0%)

$137,800 + $474,800

$612,600

2023

$8,693 (+5.0%)

$137,800 + $474,800

$612,600

2022

$8,281

$105,700 + $336,400

$442,100

2021

$8,281

$105,700 + $336,400

$442,100

2020

$8,281

$105,700 + $336,400

$442,100

2019

$8,281 (+3.0%)

$105,700 + $336,400

$442,100

2018

$8,043 (+2.8%)

$105,700 + $281,000

$386,700

2017

$7,827

$105,700 + $281,000

$386,700

2016

$7,827 (+11.1%)

$105,700 + $281,000

$386,700

2015

$7,045 (+3.5%)

$105,000 + $234,500

$339,500

2014

$6,810 (+1.4%)

$105,000 + $234,500

$339,500

2013

$6,719 (+2.0%)

$105,000 + $234,500

$339,500

2012

$6,587

$123,400 + $239,700

$363,100

Tax history for 476 Sleepy Hollow Farm Rd

Year

Property tax

Land + Additions

Assessment*

2025

$8,352 (−5.8%)

$158,600 + $499,000

$657,600

2024

$8,864 (+2.0%)

$137,800 + $474,800

$612,600

2023

$8,693 (+5.0%)

$137,800 + $474,800

$612,600

2022

$8,281

$105,700 + $336,400

$442,100

2021

$8,281

$105,700 + $336,400

$442,100

2020

$8,281

$105,700 + $336,400

$442,100

2019

$8,281 (+3.0%)

$105,700 + $336,400

$442,100

2018

$8,043 (+2.8%)

$105,700 + $281,000

$386,700

2017

$7,827

$105,700 + $281,000

$386,700

2016

$7,827 (+11.1%)

$105,700 + $281,000

$386,700

2015

$7,045 (+3.5%)

$105,000 + $234,500

$339,500

2014

$6,810 (+1.4%)

$105,000 + $234,500

$339,500

2013

$6,719 (+2.0%)

$105,000 + $234,500

$339,500

2012

$6,587

$123,400 + $239,700

$363,100

*Taxable value of land and structures on it ("additions") is determined regularly by local assessors and does not affect market price.

Public record

Public record
Permits

Beds

Baths

2.5

Stories

Lot width

—

Lot depth

—

Lot size

0.43 Acres

Year renovated

—

Sq. Ft.

2,265

Year built

1997

Style

Single Family Residential

County

Kent County

APN

124332

Parking Spaces

—

Basement

—

Accessible

—

HOA Dues

—

Garage

—

Features

—

Last updated by owner on Jun 22, 2026.

Property details

Parking

Garage/Carport Information
Has Garage
Has Attached Garage
# of Garage Spaces: 2

Parking
Features: Attached, Built In, Garage, Garage Door Opener
# of Parking (Total): 6
# of Covered Spaces: 2

Interior

Virtual Tour

Bathroom Information
# of Full Bathrooms: 2
# of Half Bathrooms: 1

Room Information
# of Rooms (Total): 10
Has Basement
Basement Information: Full, Interior Entry, Partially Finished

Fireplace Information
Has Fireplace
# of Fireplaces: 1
Features: Gas

Equipment
Appliances: Dryer, Dishwasher, Gas Water Heater, Microwave, Oven, Range, Refrigerator, Water Heater, Washer

Interior Features
Window Features: Thermal Windows
Flooring: Ceramic Tile, Hardwood, Carpet
Other Features: Attic, Bathtub, Cathedral Ceiling(s), High Ceilings, Tub Shower, Vaulted Ceiling(s), Cable TV

Exterior

Building Information
Stories: 2
Stories (Total): 2
Construction Details: Drywall, Brick, Vinyl Siding

Exterior Features
Exterior Features: Deck, Sprinkler/Irrigation, Paved Driveway
Patio And Porch Features: Deck
Other Structures: Outbuilding
Fencing: Electric

Lot Information
Lot Size Area: 18,730
Lot Size Acres: 0.43
Lot Features: Corner Lot, Cul-De-Sac, Sprinkler System
Zoning: RES

Property Information
Below Grade Finished Area: 440
Above Grade Finished Area: 2,265
Foundation Details: Concrete Perimeter

Financial

Assessments and Fees
Assessed Value: $613,000

Tax Information
Annual Tax Amount: $8,865
Tax Year: 2024

Utilities

Utility Information
Utilities: Underground Utilities
Sewer: Septic Tank
Water Source: Connected, Public

Heating & Cooling
Has Cooling
Cooling: Central Air, Ductless
Has Heating
Heating: Central, Forced Air, Gas, Heat Pump

Location

HOA Information
Association Fee: $325
Annually

Community Information
Community Features: Golf, Highway Access, Near Schools, Public Transportation, Recreation Area, Restaurant, Shopping

Public facts

Beds: 4
Baths: 2.5
Sq. Ft.: 2,265
Stories: 2.0
Lot Size: 0.43 acres
Style: Single Family Residential
Year Built: 1997
Year Renovated: —
County: Kent County
APN: 124332

Home facts updated by county records on Jun 22, 2026

Around this home

Schools

K - 12
Preschool & daycare

Scott School

Public K-5 • Assigned • 1.9mi

7/10

Winman Junior High School

Public 6-8 • Assigned • 1.8mi

5/10

Toll Gate High School

Public 9-12 • Assigned • 1.8mi

5/10

Provided by GreatSchools

Lifestyle

Provided by Walk Score and Local Logic

Climate risks

1/10 Flood Factor

Minimal risk of a flood reaching the building in the next 30 years

1/10 Fire Factor

Unlikely to be in a wildfire in next 30 years

5/10 Heat Factor

7 days above 96° expected this year, 16 days in 30 years

8/10 Wind Factor

80% chance of strong winds in next 30 years

2/10 Air Factor

2 unhealthy days expected this year, 2 days in 30 years

Provided by First Street

Historical weather

Warwick, RI • 02886

Average low and high temperatures (°F)

35°

21°

37°

23°

51°

34°

60°

42°

68°

52°

80°

62°

83°

67°

79°

60°

75°

58°

63°

48°

54°

38°

40°

26°

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

Sun exposure

In this area, properties receive around 9 hours in June and 4.6 hours in December, placing it below the U.S. average for solar exposure.

9 hrs

4.6 hrs

JuneDecember

Provided by Shadowmap

Estimated sale price

$788,000 – $954,000

Reach more buyers when you sell with Redfin. Save up to $8,288 in fees. 3 minutes to get started.

Get a free, detailed breakdown of how we calculated your estimate.

Nearby similar homes

OPEN SUN, 12PM TO 2PM

$649,900

3 beds1 bath1,344 sq ft

32 Kenson Dr, East Greenwich, RI 02818

3 season room • 2 gas fireplaces • Newer windows

$2,995,000

4 beds3.5 baths4,522 sq ft

50 Kenyon Ave, East Greenwich, RI 02818

Remarkable privacy • Bluestone terrace • Tennis court

$750,000

4 beds2.5 baths2,988 sq ft

465 Red Chimney Dr, Warwick, RI 02886

Fireplace • Formal dining room • Family room

OPEN SAT, 12PM TO 1PM

$699,900

3 beds2.5 baths1,610 sq ft

28 Hill Top Dr, East Greenwich, RI 02818

In-ground pool • Off-street parking • Distinctive lot

VIDEO TOUR

$474,900

3 beds2 baths1,416 sq ft

85 Shattock Ave, Warwick, RI 02886

Water access • Walking trail • Kayak launch

OPEN SAT, 11AM TO 12PM

$699,000

3 beds2 baths1,724 sq ft

154 Spring Valley Dr, East Greenwich, RI 02818

Renovated kitchen • Quartz countertops • New flooring

New listings for sale in 02886

NEW 12 HRS AGO3D WALKTHROUGH

$649,900

4 beds2.5 baths2,491 sq ft

765 Toll Gate Rd, Warwick, RI 02886

200-amp service • 3.15 acre lot • 6 parking spots

COMING SOON

$399,900

2 beds2 baths1,403 sq ft

662 Orleans Ct, Warwick, RI 02886

End unit • Private patio • Large outdoor pool

OPEN SUN, 1PM TO 2:30PM

$355,000

2 beds1 bath960 sq ft

28 Elmer Ave, Warwick, RI 02886

Modern bathroom • Huge primary bedroom • 6,969 sq ft lot

OPEN SAT, 11:30AM TO 1PM3D WALKTHROUGH

$524,900

6 beds2 baths3,780 sq ft

855 Jefferson Blvd, Warwick, RI 02886

Central air • 0.23 acre lot • 4 parking spots

OPEN SAT, 12PM TO 2PM

$499,000

3 beds2 baths1,732 sq ft

3275 West Shore Rd, Warwick, RI 02888

Attached garage • Upgraded in 2014 • Stainless appliances

OPEN SAT, 10:30AM TO 12PM

$429,000

3 beds2 baths1,425 sq ft

881 Greenwich Ave #12, Warwick, RI 02886

Gas fireplace • Back deck • Near ri's coast

OPEN TODAY, 4:30PM TO 6PM3D WALKTHROUGH

$215,000

1 bed1 bath690 sq ft

3524 W Shore Rd #309, Warwick, RI 02886

New flooring • Walk-in closet • In-building laundry

$379,000

2 beds1 bath960 sq ft

105 Airway Rd, Warwick, RI 02886

Mudroom storage area • Fenced in yard • 5,432 sq ft lot

$355,000

2 beds1 bath1,073 sq ft

882 Halifax Dr, Warwick, RI 02886

First floor condo • Private location • Open floor plan

Home values near 476 Sleepy Hollow Farm Rd

Data from public records.

Address	Redfin Estimate
490 Sleepy Hollow Farm Road, Warwick, RI 4 Beds \| 2.5 Baths \| 2430 Sq. Ft.	$765,379
462 Sleepy Hollow Farm Road, Warwick, RI 4 Beds \| 2.5 Baths \| 2506 Sq. Ft.	$731,590
495 Sleepy Hollow Farm Road, Warwick, RI 4 Beds \| 2.5 Baths \| 2312 Sq. Ft.	$747,810
442 Sleepy Hollow Farm Road, Warwick, RI 4 Beds \| 3.5 Baths \| 3226 Sq. Ft.	$1,004,262
447 Sleepy Hollow Farm Road, Warwick, RI 3 Beds \| 1.5 Baths \| 1680 Sq. Ft.	$592,135
469 Sleepy Hollow Farm Road, Warwick, RI 4 Beds \| 2.5 Baths \| 2346 Sq. Ft.	$817,615
481 Sleepy Hollow Farm Road, Warwick, RI 4 Beds \| 2.5 Baths \| 1856 Sq. Ft.	$658,575

Address	Redfin Estimate
447 Sleepy Hollow Farm Road, Warwick, RI 3 Beds \| 1.5 Baths \| 1680 Sq. Ft.	$602,465
469 Sleepy Hollow Farm Road, Warwick, RI 4 Beds \| 2.5 Baths \| 2926 Sq. Ft.	$840,994
457 Sleepy Hollow Farm Road, Warwick, RI 4 Beds \| 2.5 Baths \| 2370 Sq. Ft.	$731,802
434 Sleepy Hollow Farm Road, Warwick, RI 4 Beds \| 2.5 Baths \| 1880 Sq. Ft.	$727,590
434 Sleepy Hollow Farm Road, Warwick, RI 4 Beds \| 2.5 Baths \| 1880 Sq. Ft.	$669,325
507 Sleepy Hollow Farm Road, Warwick, RI 4 Beds \| 2.5 Baths \| 2768 Sq. Ft.	$837,975
490 Sleepy Hollow Farm Road, Warwick, RI 4 Beds \| 2.5 Baths \| 2430 Sq. Ft.	$774,812

Address	Redfin Estimate
507 Sleepy Hollow Farm Road, Warwick, RI 4 Beds \| 2.5 Baths \| 3468 Sq. Ft.	$860,418
481 Sleepy Hollow Farm Road, Warwick, RI 4 Beds \| 2.5 Baths \| 1856 Sq. Ft.	$693,320
452 Sleepy Hollow Farm Road, Warwick, RI 3 Beds \| 2.5 Baths \| 1800 Sq. Ft.	$707,569
452 Sleepy Hollow Farm Road, Warwick, RI 3 Beds \| 1.5 Baths \| 1756 Sq. Ft.	$641,159
495 Sleepy Hollow Farm Road, Warwick, RI 4 Beds \| 2.5 Baths \| 2312 Sq. Ft.	$744,745
442 Sleepy Hollow Farm Road, Warwick, RI 4 Beds \| 3.5 Baths \| 2626 Sq. Ft.	$958,856
457 Sleepy Hollow Farm Road, Warwick, RI 3 Beds \| 2.5 Baths \| 1870 Sq. Ft.	$690,858

Property information provided by RIS when last listed in 2025. This data may not match . Learn more.

More real estate resources

Neighborhoods
Minor Civil Divisions
Cities
Zip Codes
Popular Searches

Cowesett homes for sale

Download the Redfin App on the Apple App Store

Download the Redfin App from the Google Play Store

Join us

Become an Agent

Get referrals

Careers

Find homes faster

About us

Find us

Subsidiaries

Affiliated Business

Countries

United States

Canada

Updated September 2025: By searching, you agree to the Terms of Use, and Privacy Policy.

Do not sell or share my personal information.

REDFIN and all REDFIN variants, WALK SCORE, and the R logos, are trademarks of Redfin Corporation, registered or pending in the USPTO.

Redfin Brokerage Licenses

California DRE #01521930

Redfin is licensed to do business in New York as Redfin Real Estate. NY Standard Operating Procedures

New Mexico Real Estate Licenses

TREC: Info About Brokerage Services, Consumer Protection Notice

All mortgage lending products and information are provided by Rocket Mortgage, LLC | NMLS #3030; www.NMLSConsumerAccess.org. Licensed in 50 states. This site is not authorized by the New York State Department of Financial Services for mortgage solicitation or loan applications activities related to properties located in the State of New York.

Redfin Corporation is an affiliated business of Rocket Limited Partnership. Each company, and their subsidiaries, are separate legal entities operated and managed through its own management and governance structures.

If you are using a screen reader, or having trouble reading this website, please call Redfin Customer Support for help at 1-844-759-7732.

REDFIN IS COMMITTED TO AND ABIDES BY THE FAIR HOUSING ACT AND EQUAL OPPORTUNITY ACT. READ REDFIN'S FAIR HOUSING POLICY AND THE NEW YORK STATE FAIR HOUSING NOTICE.

GreatSchools Ratings provided by GreatSchools.org.

Plainfield homes for sale
Thompson homes for sale
Killingly homes for sale
Griswold homes for sale
North Stonington homes for sale

02920 homes for sale
02921 homes for sale
02886 homes for sale
02818 homes for sale
02910 homes for sale

Houses for rent in Warwick	Agents near me	Warwick, RI homes for sale	Warwick Housing Market
Houses for sale near me	Providence, RI homes for sale	Barrington, RI homes for sale
Land for sale near me	Newport, RI homes for sale	Lincoln, RI homes for sale
Open Houses near me	Cumberland, RI homes for sale	Warwick Property Records
Condos for sale near me	Cranston, RI homes for sale	RI New Listings

Attleboro homes for sale
Providence homes for sale
Taunton homes for sale