Last Sold Price
4 beds2,558 sqft$367/sqft
152 Sleepy Hollow Farm Rd, Warwick, RI 02886

Description

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...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.
LISTING CLOSED: 05/02/2025 12:00 AM

  1. Listed by Michael Brennan • Brokerage DRE #REB.0016699 • Keller Williams Coastal
    P: (401) 632-1742 MichaelBrennanRE@Gmail.com

Property Details for 152 Sleepy Hollow Farm Road

Status
MLS #
1379173
Days on Market
17
Taxes
$8,323 / year
HOA Fees
$325 / year
Condo/Co-op Fees
-
Property Type
MLS Type
Residential / Single Family Residence
Year Built
2000
Lot Size
0.44 AC / 19,166 SF
Subdivision Name
Seventeen Farms
Architectural Style
Colonial

Recent comparable sales

Median sold price

$860,000

Avg days on market

34

Sale-to-list ratio

100.1%

Warwick, RI

9 comparable properties found

$830,000 | 476 Sleepy Hollow Farm Road, Warwick, RI 02886
1/44
1

$830,000

Sold 06/20/25

4
Bedrooms
2,705
Square Feet
0.43
Acres
$930,000 | 94 Castle Rocks Road, Warwick, RI 02886
1/33
2

$930,000

Sold 06/02/26

4
Bedrooms
2,722
Square Feet
0.39
Acres
$814,000 | 115 Castle Rocks Road, Warwick, RI 02886
1/41
3

$814,000

Sold 07/22/26

4
Bedrooms
2,724
Square Feet
0.39
Acres
$939,000 | 52 Bruce Lane, Warwick, RI 02886
1/50
4

$939,000

Sold 04/30/26

4
Bedrooms
2,408
Square Feet
0.34
Acres
$850,000 | 211 Love Lane, Warwick, RI 02886
1/48
5

$850,000

Sold 06/03/26

4
Bedrooms
2,376
Square Feet
0.34
Acres
$785,000 | 193 Sleepy Hollow Farm Road, Warwick, RI 02886
1/40
6

$785,000

Sold 07/24/26

4
Bedrooms
2,754
Square Feet
0.39
Acres
$861,000 | 161 South Cobble Hill Road, Warwick, RI 02886
1/37
7

$861,000

Sold 06/20/25

4
Bedrooms
2,880
Square Feet
1.04
Acres
$905,500 | 451 Greenbush Road, Warwick, RI 02818
1/48
8

$905,500

Sold 11/14/25

4
Bedrooms
2,518
Square Feet
0.92
Acres
$860,000 | 121 Hedgerow Drive, Warwick, RI 02886
1/50
9

$860,000

Sold 12/09/25

4
Bedrooms
2,832
Square Feet
0.36
Acres

Location

Listing Courtesy of Keller Williams Coastal

Sold By RE/MAX Results

Add your commute

Building Information for 152 Sleepy Hollow Farm Road

Stories2Year Built2000Building Size-Lot Size0.44 AC / 19,166 SF

Payment Calculator

$5,499 per month

30 year fixed, 6.55% Interest

Principal and Interest

$4,778

Property Taxes

$694

HOA Dues

$27

The Payment Calculator is for illustrative purposes only.

Know your buying power with a preapproval and custom rate in minutes

Rocket Mortgage1

Property Information for 152 Sleepy Hollow Farm Road

Summary
Location and General Information
  • City: Warwick
  • Community Features: Golf, Highway Access, Marina, Near Hospital, Near Schools, Other, Public Transportation, Recreation Area, Restaurant, Shopping, See Remarks, Tennis Courts, Sidewalks
  • Postal City: Warwick
  • Postal Code: 02886
  • State Or Province: RI
  • Human Modified Y N: Yes
Parking
  • Attached Garage Y N: Yes
  • Covered Spaces: 2
  • Garage Spaces: 2
  • Garage Y N: Yes
  • Parking Features: Attached, Built In, Garage
  • Parking Total: 8
Taxes and HOA Information
  • Association Fee: $325.00
  • Association Fee Frequency: Annually
  • Tax Annual Amount: $8,323.00
  • Tax Assessed Value: 575200
  • Tax Lot: 0062
  • Tax Map Number: 232
  • Tax Year: 2025
Property
Lot Information
  • Above Grade Fin SQFT: 2558.0
  • Below Grade Finished Area: 0.0
  • Building Area Total: 2558.0
  • Living Area: 2,558.00
  • Living Area Source: Listing Agent
  • Lot Features: Wooded
  • Lot Size Acres: 0.44
  • Lot Size Area: 19166.0
  • Lot Size Square Feet: 19166.0
  • Lot Size Units: Square Feet
  • Parcel Number: 152SLEEPYHOLLOWFARMRDWARW
  • Stories: 2
  • Stories Total: 2
  • Property Sub Type Additional: Single Family Residence
Property and Assessments
  • Buyer Financing: Conventional
  • New Construction Y N: No
  • Property Sub Type: Single Family Residence
  • Property Type: Residential
  • Senior Community Y N: No
  • Year Built: 2000
  • C L I P: 2,261,140,316
Utilities
  • Electric: Amps150, Circuit Breakers
  • Sewer: Septic Tank
  • Water Source: Connected, Public
Interior and Exterior Features
Exterior Features
  • Exterior Features: Porch, Paved Driveway
  • Foundation Details: Concrete Perimeter
  • Pool Features: In-ground Pool
Interior Features
  • Appliances: Dryer, Dishwasher, Gas Water Heater, Microwave, Oven, Range, Refrigerator, Water Heater, Washer
  • Basement: Full, Interior Entry, Unfinished
  • Basement Y N: Yes
  • Bathrooms Full: 2
  • Bathrooms Half: 1
  • Bathrooms Total Integer: 3
  • Bedrooms Total: 4
  • Cooling: Central Air
  • Cooling Y N: Yes
  • Fireplace Features: Gas
  • Fireplaces Total: 1
  • Fireplace Y N: Yes
  • Flooring: Ceramic Tile, Hardwood
  • Heating: Central, Forced Air, Gas
  • Heating Y N: Yes
  • Interior Features: Bathtub, Stall Shower, Tub Shower
  • Levels: Two
  • Patio And Porch Features: Porch
  • Rooms Total: 8
  • Window Features: Thermal Windows
Rental
Rental Information
  • Lease Amount Per Area Unit: DollarsPerSquareFoot
  • Land Lease Y N: No

Property History for 152 Sleepy Hollow Farm Road

DateEvent & SourcePriceAppreciation
May 2, 2025

Sold

Rhode Island Association of REALTORS® #1379173

$940,000
May 1, 2025

Sold (Public Record)

Public Record #1557685352

$940,000

+5.1% / yr

Apr 10, 2025

Contract Signed

Rhode Island Association of REALTORS® #1379173

DateEvent & SourcePrice
05/02/2025

Sold

Rhode Island Association of REALTORS® #1379173

$940,000
05/01/2025

Sold (Public Record)

Public Record #1557685352

$940,000

+5.1% / yr

04/10/2025

Contract Signed

Rhode Island Association of REALTORS® #1379173

For completeness, we often displays two records for one sale: the MLS record and the public record.

Public Records for 152 Sleepy Hollow Farm Road

Taxable ValueLand$151,100Additions$449,700Total$600,800
Tax Record2025$7,630 ($636 / month)
Home Facts
Beds4Baths2.5Total Finished SqFt2,366 SqFtAbove Grade Finished SqFt2,366 SqFtUnfinished Basement SqFt1,047 SqFtStories2Lot Size19,136 SqFtStyleSingle Family ResidenceYear Built2000Year Renovated2000ZoningA40CountyKENTAPNWARW M:232 B:0062 L:0000

Schools near 152 Sleepy Hollow Farm Road

This home is within Warwick School District.
Rating
School
Type
Grades
Distance
Public - K to 5
Public - 6 to 8
Public - 10 to 12
Public - K to 5
Rating
School
Distance
Cedar Hill School
PublicK to 5

Winman Junior High School
Public6 to 8

Warwick Career And Tech Center
Public10 to 12

Scott School
PublicK to 5

School ratings and boundaries are provided by GreatSchools.org and Pitney Bowes. This information should only be used as a reference. Proximity or boundaries shown here are not a guarantee of enrollment. Please reach out to schools directly to verify all information and enrollment eligibility.

Similar Homes

New listings in 02886

$1,300,000 | 68 Castle Rocks Road, Warwick, RI 02886
1/48
Open: 8/29 11:00AM - 12:30PMNew

$1,300,000

4
Bedrooms
4,508
Square Feet
0.4
Acres
$239,900 | 3524 West Shore Road, Unit 807, Warwick, RI 02886
1/9

$239,900

1
Bedrooms
720
Square Feet
$499,900 | 61 Cactus Street, Warwick, RI 02886
1/26

$499,900

3
Bedrooms
2,260
Square Feet
0.23
Acres
$950,000 | 67 Love Lane, Warwick, RI 02886
1/44

$950,000

3
Bedrooms
3,087
Square Feet
0.35
Acres
$374,900 | 760 Strawberry Field Road, Warwick, RI 02886
1/13

$374,900

3
Bedrooms
1,872
Square Feet
0.16
Acres
$150,000 | 29 Andrew Comstock Road, Warwick, RI 02886
1/45

$150,000

2
Bedrooms
737
Square Feet
Unavailable
Acres
$279,900 | 479 Providence Street, Unit C2, Warwick, RI 02886
1/36
Active Under Contract

$279,900

2
Bedrooms
1,354
Square Feet
$680,000 | 75 Child Lane, Warwick, RI 02886
1/25

$680,000

4
Bedrooms
2,200
Square Feet
0.17
Acres
$425,000 | 140 Tanner Avenue, Warwick, RI 02886
1/37
Virtual Tour

$425,000

3
Bedrooms
1,489
Square Feet
0.23
Acres

Nearby home values

AddressSold priceBedsBathsSqftLot (Sqft)
This home: 152 Sleepy Hollow Farm Road, Warwick, RI 02886
$940,000
4
2,558
19,166
$270,245
4
2,300
19,136
$224,900
4
2,306
15,000
$475,000
4
2,500
19,203
$244,542
4
2,076
19,163
$268,049
4
2,200
19,107

No guarantee, warranty or representation of any kind is made regarding the completeness or accuracy of any information, descriptions or measurements (including square footage measurements and property condition), such should be independently verified through appropriate means, including, but not limited to, in person inspection and public records, and Compass International Holdings, its subsidiaries, affiliates and independently owned and operated franchisees, and their affiliated agents and associated third parties expressly disclaim any liability in connection therewith. Photos may be virtually staged or digitally enhanced and may not reflect actual property conditions. Offers of compensation are subject to change at the seller's discretion. No financial or legal advice provided. Equal Housing Opportunity.

Listing Courtesy of Keller Williams Coastal

Based on information from one of the following Multiple Listing Services: Rhode Island Association of REALTORS®. Information being provided is for the visitor’s personal, noncommercial use and may not be used for any purpose other than to identify prospective properties visitor may be interested in purchasing. The data contained herein is copyrighted by Rhode Island Association of REALTORS® is protected by all applicable copyright laws. Any dissemination of this information is in violation of copyright laws and is strictly prohibited. Property information referenced on this web site comes from the Internet Data Exchange (IDX) program of the MLS. This web site may reference real estate listing(s) held by a brokerage firm other than the broker and/or agent who owns this web site. For the avoidance of doubt, the accuracy of all information, regardless of source, is deemed reliable but not guaranteed and should be personally verified through personal inspection by and/or with the appropriate professionals.