Sold
Last Sold Price
4 beds3,468 sqft$125/sqft
507 Sleepy Hollow Farm Rd, Warwick, RI 02886
Single FamilyProperty Type
0.40 acresLot Size
1999Year Built
$125/sq ftPrice per sq ft
$250/yrHOA Fees
8 carsParking Spaces

Description

Beautifully maintained Colonial, first floor den, formal dining & living rooms, oversized great room with fireplace, huge master suite, second floor laundry room, air, sprinklers, 2 car garage.Beautifully maintained Colonial, first floor den, formal dining & living rooms, oversized great room with fireplace, huge master suite, second floor laundry room, air, sprinklers, 2 car garage.
  • Listed by: Jean Marzilli 401.864.2151 jmarzilli@sellri.com Brokerage DRE #REC.0005668 • RE/MAX Professionals
Listing closed: 06/22/2012 12:00 AM • Source: Rhode Island Association of REALTORS®, MLS#: 1008858

Recent comparable sales

Median sold price

$845,000

Avg days on market

40

Sale-to-list ratio

98.8%

Warwick, RI

9 comparable properties found

$530,000 | 749 Commonwealth Avenue, Warwick, RI 02886
1/46
1

$530,000

Sold 07/18/25

4
Bedrooms
3,593
Square Feet
1.35
Acres
$495,000 | 192 Midget Avenue, Warwick, RI 02886
1/18
2

$495,000

Sold 09/24/24

4
Bedrooms
3,028
Square Feet
0.17
Acres
$580,000 | 24 Superior Street, Warwick, RI 02886
1/51
3

$580,000

Sold 02/14/25

4
Bedrooms
3,416
Square Feet
0.49
Acres
$923,000 | 283 Castle Rocks Road, Warwick, RI 02886
1/49
4

$923,000

Sold 07/14/26

4
Bedrooms
3,229
Square Feet
0.4
Acres
$845,000 | 36 Anne C. Holst Court, Warwick, RI 02886
1/45
5

$845,000

Sold 06/25/25

4
Bedrooms
3,296
Square Feet
0.44
Acres
$920,000 | 105 Castle Rocks Road, Warwick, RI 02886
1/45
6

$920,000

Sold 06/02/26

4
Bedrooms
3,534
Square Feet
0.4
Acres
$858,000 | 24 Michelle Circle, Warwick, RI 02886
1/43
7

$858,000

Sold 01/16/25

4
Bedrooms
3,321
Square Feet
0.51
Acres
$630,000 | 41 Bruce Lane, Warwick, RI 02886
1/31
8

$630,000

Sold 06/30/26

4
Bedrooms
3,249
Square Feet
0.34
Acres
$1,060,000 | 237 Highland Avenue, Warwick, RI 02886
1/50
9

$1,060,000

Sold 09/29/25

4
Bedrooms
3,068
Square Feet
0.69
Acres

Location

Listing Courtesy of RE/MAX Professionals

Sold By RE/MAX Professionals

Add your commute

Payment Calculator

$2,830 per month

30 year fixed, 6.55% Interest

Principal and Interest

$2,211

Property Taxes

$598

HOA Dues

$21

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 507 Sleepy Hollow Farm Road

Property Details
  • Taxes: $7,172 / year
  • MLS Type: Residential / Single Family Residence
  • County: Kent County
  • Subdivision Name: SEVENTEEN FARMS
  • Architectural Style: Colonial
Building Information
  • Stories: 2
  • Year Built: 1999
  • Lot Size: 0.40 AC / 17,406 SF
Summary
Location and General Information
  • City: Warwick
  • Community Features: Golf, Highway Access, Marina, Near Hospital, Near Schools, Public Transportation, Shopping, Tennis Courts, Sidewalks
  • Postal City: Warwick
  • Postal Code: 02886
  • State Or Province: RI
  • Human Modified Y N: No
Parking
  • Attached Garage Y N: Yes
  • Covered Spaces: 2
  • Garage Spaces: 2
  • Garage Y N: Yes
  • Parking Features: Attached, Garage, Garage Door Opener
  • Parking Total: 8
Taxes and HOA Information
  • Association Fee: $250.00
  • Association Fee Frequency: Annually
  • Tax Annual Amount: $7,172.00
  • Tax Assessed Value: 405400
  • Tax Lot: 0074
  • Tax Map Number: 229
  • Tax Year: 2011
Property
Lot Information
  • Above Grade Fin SQFT: 2768.0
  • Below Grade Finished Area: 700.0
  • Building Area Total: 3468.0
  • Living Area: 3,468.00
  • Living Area Source: Public Records
  • Lot Features: Corner Lot, Sprinkler System
  • Lot Size Acres: 0.3996
  • Lot Size Area: 17406.0
  • Lot Size Square Feet: 17406.0
  • Lot Size Units: Square Feet
  • Parcel Number: 507SLEEPYHOLLOWFARMRDWARW
  • Stories: 2
  • Stories Total: 2
  • Property Sub Type Additional: Single Family Residence
Property and Assessments
  • Buyer Financing: Conventional
  • New Construction Y N: No
  • Number Of Units Total: 0
  • Property Sub Type: Single Family Residence
  • Property Type: Residential
  • Senior Community Y N: No
  • Year Built: 1999
  • C L I P: 3,758,417,350
Utilities
  • Electric: Amps200Or More, Circuit Breakers
  • Sewer: Septic Tank
  • Water Source: Connected
Interior and Exterior Features
Exterior Features
  • Exterior Features: Deck, Sprinkler Irrigation, Paved Driveway
  • Fencing: Electric
Interior Features
  • Appliances: Dryer, Dishwasher, Disposal, Gas Water Heater, Oven, Range, Refrigerator, Range Hood, Water Heater, Washer
  • Basement: Full, Finished
  • Basement Y N: Yes
  • Bathrooms Full: 2
  • Bathrooms Half: 1
  • Bathrooms Total Integer: 3
  • Bedrooms Total: 4
  • Cooling: Central Air
  • Cooling Y N: Yes
  • Door Features: Storm Doors
  • Fireplace Features: Marble
  • Fireplaces Total: 1
  • Fireplace Y N: Yes
  • Flooring: Carpet, Ceramic Tile, Hardwood, Vinyl
  • Heating: Forced Air, Gas
  • Heating Y N: Yes
  • Interior Features: Cathedral Ceilings, High Ceilings, Vaulted Ceilings, Cable Tv
  • Levels: Two
  • Patio And Porch Features: Deck
  • Rooms Total: 9
  • Window Features: Storm Windows
Room 1
  • Room Type 1: Living Room
Room 2
  • Room Type 2: Recreation
Room 3
  • Room Type 3: Laundry
Room 4
  • Room Type 4: Primary Bedroom
Room 5
  • Room Type 5: Foyer
Room 6
  • Room Type 6: Family Room
Room 7
  • Room Type 7: Kitchen
  • Room Features 7: Eat In Kitchen
Room 8
  • Room Type 8: Dining Room
Room 9
  • Room Type 9: Dining Room
Room 10
  • Room Type 10: Den
Room 11
  • Room Type 11: Workshop
Room 30
  • Room List: Living Room, Recreation, Laundry, Primary Bedroom, Foyer, Family Room, Kitchen, Dining Room, Den, Workshop

Property History for 507 Sleepy Hollow Farm Road

DateEvent & SourcePriceAppreciation
Jun 22, 2012

Sold (Public Record)

Public Record #333919849

$435,000

-0.9% / yr

Jun 22, 2012

Sold

Rhode Island Association of REALTORS® #1008858

$435,000
May 24, 2012

Contract Signed

Rhode Island Association of REALTORS® #1008858

DateEvent & SourcePrice
06/22/2012

Sold (Public Record)

Public Record #333919849

$435,000

-0.9% / yr

06/22/2012

Sold

Rhode Island Association of REALTORS® #1008858

$435,000
05/24/2012

Contract Signed

Rhode Island Association of REALTORS® #1008858

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

Public Records for 507 Sleepy Hollow Farm Road

Taxable ValueLand$156,300Additions$457,100Total$613,400
Tax Record2025$7,790 ($649 / month)
Home Facts
Beds4Baths2.5Total Finished SqFt2,768 SqFtAbove Grade Finished SqFt2,768 SqFtUnfinished Basement SqFt1,269 SqFtStories2Lot Size17,406 SqFtStyleSingle Family ResidenceYear Built1999Year Renovated1999ZoningA40CountyKENTAPNWARW M:229 B:0074 L:0000

Schools near 507 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

$449,900 | 83 Cadora Avenue, Warwick, RI 02886
1/21

$449,900

2
Bedrooms
1,130
Square Feet
$899,900 | 81 Cadora Avenue, Warwick, RI 02886
1/49

$899,900

4
Bedrooms
2,260
Square Feet
0.24
Acres
$525,000 | 65 Hedgerow Drive, Warwick, RI 02886
1/9

$525,000

4
Bedrooms
2,588
Square Feet
0.38
Acres
$379,900 | 34 Lancaster Avenue, Warwick, RI 02886
1/2

$379,900

4
Bedrooms
2,284
Square Feet
0.17
Acres
$399,000 | 5 Packard Avenue, Warwick, RI 02886
1/36

$399,000

3
Bedrooms
1,800
Square Feet
0.18
Acres
$389,777 | 982 Brighton Way, Warwick, RI 02886
1/38
Open: 9/12 12:00PM - 02:00PM

$389,777

2
Bedrooms
1,065
Square Feet
$475,000 | 2907 Post Road, Unit 1, Warwick, RI 02886
1/31

$475,000

3
Bedrooms
1,644
Square Feet
$499,900 | 56 Fashion Drive, Warwick, RI 02886
1/40

$499,900

3
Bedrooms
1,156
Square Feet
0.23
Acres
$449,900 | 11 College Hill Road, Unit 5B, Warwick, RI 02886
1/39

$449,900

2
Bedrooms
1,650
Square Feet

Nearby home values

AddressSold priceBedsBathsSqftLot (Sqft)
This home: 507 Sleepy Hollow Farm Road, Warwick, RI 02886
$435,000
4
3,468
17,406
$392,500
4
2,312
18,363
$540,000
4
2,430
17,294
$380,000
4
1,856
18,997
$830,000
4
2,705
18,730
4
2.5
1,868
19,464

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 RE/MAX Professionals

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.