OFF MARKET

Off Market May 2025 for $940K

$892,374

•

2,558

sq ft

152 Sleepy Hollow Farm Rd, Warwick, RI 02886

About this home

Arguably the best lot in Seventeen Farms. The nearly half acre lot offers tree lined privacy on all sides. Step inside to this thoughtfully designed, and completely remodeled home. Not one builder grade finish. Beautifully updated kitchen with soft close cabinets, quartz countertops and high end stainless steel appliances. Gas fireplace and mantle in your double height family room. Fully finished Sunporch with hardwoods and gas stove heat. Hardwoods throughout the first and second floors. Primary suite being its own oasis overlooks the trees, and pool, featuring a walk in closet and a gorgeous recently remodeled bathroom with a walk in shower, bath tub and heated floors. Huge basement space with potential to be finished. Stepping down to the secluded backyard featuring a gunite and heated pool completely fenced and surrounded by native grasses and hydrangeas, as well as a pool cabana and an outdoor shower. Truly a must see to take in.

Single-familyProperty Type

2000Year Built

0.44 acresLot Size

$349Est. Price/Sq.Ft.

2 car garageParking

Listed by Michael Brennan • Keller Williams Coastal

Bought with Fitzpatrick Team • RE/MAX Results

Bought with Jessica Cameron • RE/MAX Results

Redfin checked: 29 minutes ago

•Source:RIS #1379173

Redfin Estimate

$892,374

$48K since sold in May 2025$8,000 since August

Recently sold homes
Estimate history
Homes for sale

This home's estimate is 10.9% higher than the average sale price ($805K) of 6 comparable homes.

SOLD JUL 24, 2026
$785,000
A
4 beds2.5 baths2,754 sq ft
193 Sleepy Hollow Farm Rd, Warwick, RI 02886
SOLD JUL 22, 2026
$814,000
B
4 beds2.5 baths2,724 sq ft
115 Castle Rock 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 MAR 23, 2026
$700,000
E
4 beds2.5 baths2,539 sq ft
48 Patrick Way, Warwick, RI 02886
SOLD APR 24, 2026
$675,000
F
4 beds3 baths2,328 sq ft
10 Arrowhead Way, Warwick, RI 02886

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

Earn from this home

Sell

$105,067

Est. take-home

List your home with Redfin and save $8,924

Rent

$2,171/mo

Redfin rental estimate

List your home for rent

Market trends in 02886, RI

Last updated August 2026

Buyer's Market

Seller's Market

Seller's market

Sale-to-List Price

101.9%

0.3% MoM

Median sale price

$426K

$4K MoM

Avg. days on market

26d

2 days MoM

Recently sold homes

125

14 MoM

New listings for sale

$425,000
2 beds2 baths1,095 sq ft
311 Chatham Cir, Warwick, RI 02886
VIDEO TOUR
$649,900
2 beds2 baths1,374 sq ft
148 Grand View Dr, Warwick, RI 02886
$499,000
3 beds2 baths1,416 sq ft
85 Shattock Ave, Warwick, RI 02886
$419,000
2 beds2 baths1,095 sq ft
151 Edaville Ct, Warwick, RI 02886
$239,900
1 bed1 bath720 sq ft
3524 West Shore Rd Unit C-707, Warwick, RI 02886
$450,000
3 beds2.5 baths1,644 sq ft
2907 Post Rd #1, Warwick, RI 02886
VIDEO TOUR
$734,900
4 beds2.5 baths3,228 sq ft
160 Windermere Way, Warwick, RI 02886
$434,900
3 beds1 bath1,814 sq ft
37 Vera St, Warwick, RI 02886
$309,900
2 beds1.5 baths926 sq ft
23 Benefit St #17, Warwick, RI 02886
$335,000
2 beds2 baths1,180 sq ft
70 Turner St Unit E-4, Warwick, RI 02886
See all

Provided by Redfin

Sale history for 152 Sleepy Hollow Farm Rd

Year

Property tax

Land + Additions

Assessment*

2025

$7,630 (−8.3%)

$151,100 + $449,700

$600,800

2024

$8,323 (+2.0%)

$131,300 + $443,900

$575,200

2023

$8,162 (−2.9%)

$131,300 + $443,900

$575,200

2022

$8,406

$101,500 + $347,300

$448,800

2021

$8,406

$101,500 + $347,300

$448,800

2020

$8,406

$101,500 + $347,300

$448,800

2019

$8,406 (−3.3%)

$101,500 + $347,300

$448,800

2018

$8,696 (+2.8%)

$101,500 + $316,600

$418,100

2017

$8,462

$101,500 + $316,600

$418,100

2016

$8,462 (+11.9%)

$101,500 + $316,600

$418,100

2015

$7,563 (+3.4%)

$100,300 + $264,200

$364,500

2014

$7,312 (+1.4%)

$100,300 + $264,200

$364,500

2013

$7,213 (+1.8%)

$100,300 + $264,200

$364,500

2012

$7,084

$117,900 + $272,600

$390,500

Tax history for 152 Sleepy Hollow Farm Rd

Year

Property tax

Land + Additions

Assessment*

2025

$7,630 (−8.3%)

$151,100 + $449,700

$600,800

2024

$8,323 (+2.0%)

$131,300 + $443,900

$575,200

2023

$8,162 (−2.9%)

$131,300 + $443,900

$575,200

2022

$8,406

$101,500 + $347,300

$448,800

2021

$8,406

$101,500 + $347,300

$448,800

2020

$8,406

$101,500 + $347,300

$448,800

2019

$8,406 (−3.3%)

$101,500 + $347,300

$448,800

2018

$8,696 (+2.8%)

$101,500 + $316,600

$418,100

2017

$8,462

$101,500 + $316,600

$418,100

2016

$8,462 (+11.9%)

$101,500 + $316,600

$418,100

2015

$7,563 (+3.4%)

$100,300 + $264,200

$364,500

2014

$7,312 (+1.4%)

$100,300 + $264,200

$364,500

2013

$7,213 (+1.8%)

$100,300 + $264,200

$364,500

2012

$7,084

$117,900 + $272,600

$390,500

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

Public record

Beds

Baths

2.5

Stories

Lot width

—

Lot depth

—

Lot size

0.44 Acres

Year renovated

—

Sq. Ft.

2,366

Year built

2000

Style

Single Family Residential

County

Kent County

APN

266792

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
# of Parking (Total): 8
# of Covered Spaces: 2

Interior

Virtual Tour

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

Room Information
# of Rooms (Total): 8
Has Basement
Basement Information: Full, Interior Entry, Unfinished

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
Other Features: Bathtub, Tub Shower

Exterior

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

Exterior Features
Exterior Features: Porch, Paved Driveway
Patio And Porch Features: Porch

Pool and Spa Information
Pool Features: In Ground

Lot Information
Lot Size Area: 19,166
Lot Size Acres: 0.44
Lot Features: Wooded

Property Information
Above Grade Finished Area: 2,558
Foundation Details: Concrete Perimeter

Financial

Assessments and Fees
Assessed Value: $575,200

Tax Information
Annual Tax Amount: $8,323
Tax Year: 2025

Utilities

Utility Information
Electric: Circuit Breakers
Sewer: Septic Tank
Water Source: Connected, Public

Heating & Cooling
Has Cooling
Cooling: Central Air
Has Heating
Heating: Central, Forced Air, Gas

Location

HOA Information
Association Fee: $325
Annually

Community Information
Community Features: Golf, Highway Access, Marina, Near Hospital, Near Schools, Public Transportation, Recreation Area, Restaurant, Shopping, Tennis Court(s), Sidewalks

Public facts

Beds: 4
Baths: 2.5
Sq. Ft.: 2,366
Stories: 2.0
Lot Size: 0.44 acres
Style: Single Family Residential
Year Built: 2000
Year Renovated: —
County: Kent County
APN: 266792

Home facts updated by county records on Jun 22, 2026

Around this home

Schools

Scott School

Public K-5 • Assigned • 1.5mi

7/10

Winman Junior High School

Public 6-8 • Assigned • 1.4mi

5/10

Toll Gate High School

Public 9-12 • Assigned • 1.4mi

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

4/10 Heat Factor

7 days above 95° expected this year, 15 days in 30 years

6/10 Wind Factor

75% 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)

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

$848,000 – $1.03M

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

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

Nearby similar homes

$499,000

3 beds2 baths1,416 sq ft

85 Shattock Ave, Warwick, RI 02886

$799,950

3 beds2.5 baths1,610 sq ft

28 Hill Top Dr, East Greenwich, RI 02818

3D WALKTHROUGH

$950,000

3 beds2.5 baths3,087 sq ft

67 Love Ln, Warwick, RI 02886

3D WALKTHROUGH

$409,900

3 beds1 bath1,489 sq ft

140 Tanner Ave, Warwick, RI 02886

$489,900

4 beds1.5 baths1,669 sq ft

4196 Post Rd, East Greenwich, RI 02818

$750,000

4 beds2.5 baths2,988 sq ft

465 Red Chimney Dr, Warwick, RI 02886

New listings for sale in 02886

$425,000

2 beds2 baths1,095 sq ft

311 Chatham Cir, Warwick, RI 02886

VIDEO TOUR

$649,900

2 beds2 baths1,374 sq ft

148 Grand View Dr, Warwick, RI 02886

$499,000

3 beds2 baths1,416 sq ft

85 Shattock Ave, Warwick, RI 02886

$419,000

2 beds2 baths1,095 sq ft

151 Edaville Ct, Warwick, RI 02886

$239,900

1 bed1 bath720 sq ft

3524 West Shore Rd Unit C-707, Warwick, RI 02886

$450,000

3 beds2.5 baths1,644 sq ft

2907 Post Rd #1, Warwick, RI 02886

VIDEO TOUR

$734,900

4 beds2.5 baths3,228 sq ft

160 Windermere Way, Warwick, RI 02886

$434,900

3 beds1 bath1,814 sq ft

37 Vera St, Warwick, RI 02886

$309,900

2 beds1.5 baths926 sq ft

23 Benefit St #17, Warwick, RI 02886

Home values near 152 Sleepy Hollow Farm Rd

Data from public records.

Address	Redfin Estimate
171 Sleepy Hollow Farm Road, Warwick, RI 3 Beds \| 2.5 Baths \| 2180 Sq. Ft.	$683,937
193 Sleepy Hollow Farm Road, Warwick, RI 4 Beds \| 2.5 Baths \| 2754 Sq. Ft.	$812,086

Address	Redfin Estimate
161 Sleepy Hollow Farm Road, Warwick, RI 4 Beds \| 2.5 Baths \| 3222 Sq. Ft.	$817,294
186 Sleepy Hollow Farm Road, Warwick, RI 4 Beds \| 2.5 Baths \| 2670 Sq. Ft.	$770,652

Address	Redfin Estimate
181 Sleepy Hollow Farm Road, Warwick, RI 4 Beds \| 2.5 Baths \| 2360 Sq. Ft.	$856,369
162 Sleepy Hollow Farm Road, Warwick, RI 4 Beds \| 2.5 Baths \| 2500 Sq. Ft.	$776,803

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

More real estate resources

Cities
Zip Codes
Minor Civil Divisions
Neighborhoods
Popular Searches

Providence homes for sale
Newport homes for sale
Fall River 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.

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.

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

Plainfield homes for sale
Thompson homes for sale
Killingly homes for sale
Griswold homes for sale
North Stonington 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