OFF MARKET

Off market jun 2019 for $500K

$839,077

•

2,400

sq ft

340 Sleepy Hollow Farm Rd, Warwick, RI 02886

About this home

Pride of ownership is reflected in this pristine 8 room, 4 Bed, 2.5 Bath open Colonial in Seventeen Farms, set on almost 1/2 acre of manicured grounds with private rear yard. Upon entering you are greeted by the gracious 2 story entry that opens to the bright formal living/dining room combination with bay windows. Enjoy your eat in kitchen with center island, granite counters and breakfast area with sliders to the rear deck. The fireplaced family room has great space and is also open to the kitchen. The second level features a large master suite with tray ceiling, hardwood floors, walk in closet and a large master bath with double vanity, shower stall and tub. 3 additional bedrooms, another full bath and laundry room finish out this space. Amenities include central air, central vac, underground sprinklers, security, trex deck, and a 2 car garage with openers. Don't miss this must see offering!

Single-familyProperty Type

1998Year Built

0.39 acresLot Size

$350Est. Price/Sq.Ft.

2 car garageParking

Listed by Robert Cressman • Weichert Realtors-Cress & Co.

Bought with Michael Russo • RI Real Estate Services

Redfin checked: 2 minutes ago

•Source:RIS #1223327

Redfin Estimate

$839,077

$339K since sold in June 2019$15K since October

Recently sold homes
Estimate history
Homes for sale

This home's estimate is 9.5% higher than the average sale price ($766K) 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 OCT 22, 2026
$645,000
E
4 beds2.5 baths3,020 sq ft
33 Old Oak Dr, Warwick, RI 02886
SOLD SEP 30, 2026
$500,000
F
4 beds2 baths2,588 sq ft
65 Hedgegrow Dr, Warwick, RI 02886

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

Earn from this home

Sell

$448,829

Est. take-home

List your home with Redfin and save $8,391

Rent

$2,193/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

NEW 17 HRS AGO
$139,900
1 bed1 bath698 sq ft
41 East Andrew Comstock Rd, Warwick, RI 02886
OPEN SUN, 11AM TO 1PM
$2,195,000
4 beds3 baths3,251 sq ft
1090 Buttonwoods Ave, Warwick, RI 02886
OPEN SAT, 1PM TO 3PM
$589,900
5 beds2.5 baths2,862 sq ft
251 Brian Dr, Warwick, RI 02886
OPEN TODAY, 5PM TO 6:30PM
$350,000
2 beds1 bath1,073 sq ft
1008 Williamsburg Cir, Warwick, RI 02886
OPEN NOV 11, 3PM TO 5PM
$349,000
2 beds1 bath1,118 sq ft
351 New London Ave #502, Warwick, RI 02886
OPEN SAT, 12PM TO 1PM
$415,000
3 beds1 bath1,240 sq ft
171 Capron Farm Dr, Warwick, RI 02886
OPEN TODAY, 4PM TO 5:30PM
$399,999
3 beds1 bath996 sq ft
67 Flagg Ave, Warwick, RI 02886
OPEN SAT, 12PM TO 1:30PM
$449,900
3 beds1 bath1,320 sq ft
291 Groveland Ave, Warwick, RI 02886
FOR SALE BY OWNER
$840,000
5 beds3.5 baths2,668 sq ft
80 Preston Dr, Warwick, RI 02886
$389,900
2 beds1 bath909 sq ft
111 Edaville Ct, Warwick, RI 02886
See all

Provided by Redfin

Sale history for 340 Sleepy Hollow Farm Rd

Year

Property tax

Land + Additions

Assessment*

2025

$8,171 (+1.7%)

$155,700 + $487,700

$643,400

2024

$8,031 (+2.0%)

$135,300 + $419,700

$555,000

2023

$7,875 (−1.2%)

$135,300 + $419,700

$555,000

2022

$7,968

$98,300 + $327,100

$425,400

2021

$7,968

$98,300 + $327,100

$425,400

2020

$7,968

$98,300 + $327,100

$425,400

2019

$7,968 (−3.4%)

$98,300 + $327,100

$425,400

2018

$8,249 (+2.8%)

$98,300 + $298,300

$396,600

2017

$8,027

$98,300 + $298,300

$396,600

2016

$8,027 (+10.2%)

$98,300 + $298,300

$396,600

2015

$7,285 (+3.4%)

$101,500 + $249,600

$351,100

2014

$7,043 (+1.4%)

$101,500 + $249,600

$351,100

2013

$6,948 (+1.5%)

$101,500 + $249,600

$351,100

2012

$6,844

$119,300 + $258,000

$377,300

Tax history for 340 Sleepy Hollow Farm Rd

Year

Property tax

Land + Additions

Assessment*

2025

$8,171 (+1.7%)

$155,700 + $487,700

$643,400

2024

$8,031 (+2.0%)

$135,300 + $419,700

$555,000

2023

$7,875 (−1.2%)

$135,300 + $419,700

$555,000

2022

$7,968

$98,300 + $327,100

$425,400

2021

$7,968

$98,300 + $327,100

$425,400

2020

$7,968

$98,300 + $327,100

$425,400

2019

$7,968 (−3.4%)

$98,300 + $327,100

$425,400

2018

$8,249 (+2.8%)

$98,300 + $298,300

$396,600

2017

$8,027

$98,300 + $298,300

$396,600

2016

$8,027 (+10.2%)

$98,300 + $298,300

$396,600

2015

$7,285 (+3.4%)

$101,500 + $249,600

$351,100

2014

$7,043 (+1.4%)

$101,500 + $249,600

$351,100

2013

$6,948 (+1.5%)

$101,500 + $249,600

$351,100

2012

$6,844

$119,300 + $258,000

$377,300

*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.39 Acres

Year renovated

—

Sq. Ft.

2,404

Year built

1998

Style

Single Family Residential

County

Kent County

APN

492394

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, Garage, Garage Door Opener
# of Parking (Total): 4
# 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: Zero Clearance

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

Interior Features
Window Features: Thermal Windows
Door Features: Storm Door(s)
Flooring: Ceramic Tile, Hardwood, Carpet
Other Features: Bathtub, Tub Shower, Central Vacuum, Cable TV

Exterior

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

Exterior Features
Exterior Features: Deck, Sprinkler/Irrigation, Paved Driveway
Patio And Porch Features: Deck
Security Features: Security System Owned

Lot Information
Lot Size Area: 16,998
Lot Size Acres: 0.3902
Lot Features: Sprinkler System
Zoning: RES

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

Financial

Assessments and Fees
Assessed Value: $425,400

Tax Information
Annual Tax Amount: $8,250
Tax Year: 2018

Utilities

Utility Information
Utilities: Underground Utilities
Electric: 150 Amp Service, Circuit Breakers
Sewer: Septic Tank
Water Source: Connected, Public

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

Location

HOA Information
Association Fee: $250
Annually

Community Information
Community Features: Marina, Near Hospital, Near Schools, Shopping, Tennis Court(s)

Public facts

Beds: 4
Baths: 2.5
Sq. Ft.: 2,404
Stories: 2.0
Lot Size: 0.39 acres
Style: Single Family Residential
Year Built: 1998
Year Renovated: —
County: Kent County
APN: 492394

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.8mi

7/10

Winman Junior High School

Public 6-8 • Assigned • 1.7mi

5/10

Toll Gate High School

Public 9-12 • Assigned • 1.7mi

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 96° expected this year, 15 days in 30 years

7/10 Wind Factor

78% 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

$798,000 – $965,000

Reach more buyers when you sell with Redfin. Save up to $8,391 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

NEW CONSTRUCTION

$1,469,500

3 beds2.5 baths2,193 sq ft

02 Venus Dr, East Greenwich, RI 02818

Coastal architecture • Luxury finishes • Open-concept living

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

NEW CONSTRUCTION

$1,579,500

4 beds2.5 baths3,128 sq ft

01 Chace St, East Greenwich, RI 02818

Custom homes • Coastal architecture • Luxury finishes

$699,000

3 beds2 baths1,724 sq ft

154 Spring Valley Dr, East Greenwich, RI 02818

Renovated kitchen • Quartz countertops • New flooring

NEW CONSTRUCTION

$1,489,500

3 beds2 baths2,333 sq ft

01 Venus Dr, East Greenwich, RI 02818

Coastal architecture • Luxury finishes • Open-concept living

New listings for sale in 02886

NEW 17 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 340 Sleepy Hollow Farm Rd

Data from public records.

Address	Redfin Estimate
299 Sleepy Hollow Farm Rd, Warwick, RI 4 Beds \| 3.5 Baths \| 2448 Sq. Ft.	$845,496
390 Sleepy Hollow Farm Rd, Warwick, RI 4 Beds \| 2.5 Baths \| 2800 Sq. Ft.	$843,473

Address	Redfin Estimate
370 Sleepy Hollow Farm Rd, Warwick, RI 4 Beds \| 2.5 Baths \| 2824 Sq. Ft.	$859,622
395 Sleepy Hollow Farm Rd, Warwick, RI 3 Beds \| 2 Baths \| 2056 Sq. Ft.	$717,159

Address	Redfin Estimate
329 Sleepy Hollow Farm Rd, Warwick, RI 4 Beds \| 2.5 Baths \| 2538 Sq. Ft.	$796,534
310 Sleepy Hollow Farm Rd, Warwick, RI 4 Beds \| 2.5 Baths \| 2696 Sq. Ft.	$804,790

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

More real estate resources

Minor Civil Divisions
Zip Codes
Neighborhoods
Cities
Popular Searches

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

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