OFF MARKET
Google street view image for 174 Sleepy Hollow Farm Rd, Warwick, RI 02886
Off market
$719,033
4
bd
•
2.5 ba
•
2,174
sq ft

174 Sleepy Hollow Farm Rd, Warwick, RI 02886

map-entry

About this home

174 Sleepy Hollow Farm Rd is a 2,174 square foot house on a 0.44 acre lot with 4 bedrooms and 2.5 bathrooms. Based on Redfin's Warwick data, we estimate the home's value is $719,033.
Single-familyProperty Type
1999Year Built
0.44 acresLot Size
$331Est. Price/Sq.Ft.
Source:Public Records

Redfin Estimate

$719,033
$7,000 since October

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

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

Earn from this home

Sell
$675,676
Est. take-home

List your home with Redfin and save $7,190

Rent
$2,070/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
101.3%

0.6% MoM

Median sale price
$425K

$125 MoM

Avg. days on market
28d

3 days MoM

Recently sold homes
121

2 MoM

New listings for sale

Provided by Redfin

Sale history for 174 Sleepy Hollow Farm Rd

As the MLS and public records start to fill up, we'll list the details here.

Tax history for 174 Sleepy Hollow Farm Rd

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

Permits

Feb 14, 2022 • Final
Building

Remove and replace windows. No structural changes are included.

Remodel

Aug 16, 2021 • Final
Building

Replace windows on a building. No structural changes are included.

Remodel

Permit history is from public records and may be incomplete or inaccurate. Redfin and its agents make no representations about the property condition or permit status. Buyers should independently verify all information.

Property details

Around this home

Schools

Scott School

Public K-5 • Assigned • 1.6mi

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

74% 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
$684,000 – $827,000

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

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

Nearby similar homes

OPEN SAT, 12PM TO 1:30PM
$599,900
3 beds1.5 baths1,808 sq ft
49 Chace St, East Greenwich, RI 02818
Granite countertops • High-end appliances • Finished lower level
FOR SALE BY OWNER
$840,000
5 beds3.5 baths2,668 sq ft
80 Preston Dr, Warwick, RI 02886
Spa-caliber bathroom • Private balcony • Chef's kitchen
$750,000
4 beds2.5 baths2,988 sq ft
465 Red Chimney Dr, Warwick, RI 02886
Fireplace • Formal dining room • Family room
$799,900
4 beds2.5 baths2,852 sq ft
22 Gilbert Stuart Dr, East Greenwich, RI 02818
Granite countertops • Hardwood flooring • Ceramic tile
$749,900
3 beds1.5 baths1,234 sq ft
30 Ledge Rd, East Greenwich, RI 02818
Generous lot • Hardwood floors • Custom built-ins
$2,995,000
4 beds3.5 baths4,522 sq ft
50 Kenyon Ave, East Greenwich, RI 02818
Remarkable privacy • Bluestone terrace • Tennis court

New listings for sale in 02886

NEW 19 HRS AGO
$139,900
1 bed1 bath698 sq ft
41 East Andrew Comstock Rd, Warwick, RI 02886
Completely redone • Cozy coastal retreat • Leased land
OPEN SUN, 11AM TO 1PM
$2,195,000
4 beds3 baths3,251 sq ft
1090 Buttonwoods Ave, Warwick, RI 02886
Trex decking • Chef's kitchen • Brookhaven cabinetry
OPEN SAT, 1PM TO 3PM
$589,900
5 beds2.5 baths2,862 sq ft
251 Brian Dr, Warwick, RI 02886
Renovated kitchen • Shaker cabinetry • Quartz countertops
OPEN TODAY, 5PM TO 6:30PM
$350,000
2 beds1 bath1,073 sq ft
1008 Williamsburg Cir, Warwick, RI 02886
End-unit location • Community amenities • $394 HOA
OPEN NOV 11, 3PM TO 5PM
$349,000
2 beds1 bath1,118 sq ft
351 New London Ave #502, Warwick, RI 02886
Private balcony • Open kitchen concept • In-home laundry room
OPEN SAT, 12PM TO 1PM
$415,000
3 beds1 bath1,240 sq ft
171 Capron Farm Dr, Warwick, RI 02886
Spacious backyard • Updated kitchen • Brand new cabinets
OPEN TODAY, 4PM TO 5:30PM
$399,999
3 beds1 bath996 sq ft
67 Flagg Ave, Warwick, RI 02886
Hardwood floors • Year-old kitchen • Stone countertops
OPEN SAT, 12PM TO 1:30PM
$449,900
3 beds1 bath1,320 sq ft
291 Groveland Ave, Warwick, RI 02886
Brand new kitchen • New roof • Updated windows
FOR SALE BY OWNER
$840,000
5 beds3.5 baths2,668 sq ft
80 Preston Dr, Warwick, RI 02886
Spa-caliber bathroom • Private balcony • Chef's kitchen

Home values near 174 Sleepy Hollow Farm Rd

Data from public records.

More real estate resources

02920 homes for sale
02921 homes for sale
02886 homes for sale
02818 homes for sale
02910 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

Download the Redfin App on the Apple App Store
Download the Redfin App from the Google Play Store

About us

Why Redfin?
Community Impact
Inclusion
Culture
Press
Investors
Blog
Real Estate News

Find us

Contact Us
Help Center
Advertise

Subsidiaries

Rent.
ApartmentGuide

Affiliated Business

Rocket Close
Rocket Mortgage

Countries

US flagUnited States

Canadian flagCanada

Copyright: © 2026 Redfin. All rights reserved.

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.