SOLD SEP 30, 2025

Off Market Sep 2025 for $779K

$854,789

Est. refi paymentEst. refi $5,131/mo

•

2,908

sq ft

123 Castle Rocks Rd, Warwick, RI 02886

About this home

Welcome to your dream home in the coveted Seventeen Farms community, this exquisite center hall Colonial offers everything you've been searching for. . With 4 spacious bedrooms, 2 full and a half baths, this meticulously maintained residence provides ample space for both relaxation and entertainment. As you approach the home, you'll be greeted by a charming Farmers porch. Step inside to discover a thoughtfully designed layout featuring hardwood floors that flow seamlessly throughout the downstairs area. The heart of this home is the chef's eat-in kitchen, equipped with top-of-the-line Bosch appliances. Whether you're preparing a family meal or hosting a dinner party, this kitchen is a culinary dream. The primary suite is a sanctuary, featuring a California walk-in closet that will make organizing your wardrobe a breeze. Unwind in your private space after a long day. A home office provides the perfect environment for remote work or study. Venture downstairs to find a finished walkout basement that opens up to your beautifull backyard, where you can entertain guests. The outdoor space is complete with a deck, patio, and firepit ideal for summer barbecues and fall gatherings. The lush, wooded backdrop offers privacy and tranquility. Seventeen Farms Development is known for its friendly atmosphere, proximity to amenities, and excellent schools, making it a wonderful place to call home. Don't miss this opportunity to own a slice of paradise in a highly sought-after neighborhood

Single-familyProperty Type

1999Year Built

0.58 acresLot Size

$294Est. Price/Sq.Ft.

2 car garageParking

Listed by Belinda Nattress • Keller Williams Coastal

Bought with Wendy Bowen • Greenwich Bay Brokers

Redfin checked: a minute ago

•Source:RIS #1387429

Redfin Estimate

$854,789

$76K since sold in September 2025$6,000 since July

Recently sold homes
Estimate history
Homes for sale

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

SOLD JUL 22, 2026
$814,000
A
4 beds2.5 baths2,724 sq ft
115 Castle Rock Rd, Warwick, RI 02886
SOLD JUL 14, 2026
$923,000
B
4 beds2.5 baths3,229 sq ft
283 Castle Rocks Rd, Warwick, RI 02886
SOLD JUL 24, 2026
$785,000
C
4 beds2.5 baths2,754 sq ft
193 Sleepy Hollow Farm Rd, Warwick, RI 02886
SOLD JUN 2, 2026
$930,000
D
4 beds2.5 baths2,722 sq ft
94 Castle Rocks Rd, Warwick, RI 02886
SOLD JUL 31, 2026
$815,000
E
4 beds2.5 baths2,564 sq ft
30 Abigail St, Warwick, RI 02886
SOLD JUN 2, 2026
$920,000
F
4 beds2.5 baths3,534 sq ft
105 Castle Rocks Rd, Warwick, RI 02886

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

Earn from this home

Sell

$189,639

Est. take-home

List your home with Redfin and save $8,548

Refinance

Est. cash available

Get cash now or lower your monthly rate

Rent

$2,096/mo

Redfin rental estimate

List your home for rent

Market trends in 02886, RI

Last updated July 2026

Buyer's Market

Seller's Market

Seller's market

Sale-to-List Price

100.8%

+0.6% MoM

Median sale price

$430K

$3K MoM

Avg. days on market

26d

3 days MoM

Recently sold homes

107

11 MoM

New listings for sale

COMING SOON
27 Centennial St, Warwick, RI 02886
$499,999
3 beds1.5 baths1,570 sq ft
27 Centennial St, Warwick, RI 02886
NEW 12 HRS AGO
$499,900
3 beds2.5 baths2,260 sq ft
61 Cactus St, Warwick, RI 02886
COMING SOON
$479,900
3 beds2 baths1,313 sq ft
464 Nausauket Rd, Warwick, RI 02886
979 #23 Toll Gate Rd, Warwick, RI 02886
$149,900
2 beds1.5 baths784 sq ft
979 #23 Toll Gate Rd, Warwick, RI 02886
OPEN TODAY, 10:30AM TO 12PM
$950,000
3 beds2.5 baths3,087 sq ft
67 Love Ln, Warwick, RI 02886
OPEN TODAY, 1PM TO 3PM
$374,900
3 beds2 baths1,872 sq ft
760 Fairfa Strawberry Field Rd, Warwick, RI 02886
$150,000
2 beds1 bath737 sq ft
29 E Andrew Comstock Rd, Warwick, RI 02886
OPEN TODAY, 11AM TO 12:30PM
$279,900
2 beds1.5 baths1,354 sq ft
479 Providence St Unit C2, Warwick, RI 02886
$680,000
4 beds2.5 baths2,200 sq ft
75 Child Ln, Warwick, RI 02889
OPEN TODAY, 12PM TO 2PM
$489,900
4 beds2 baths1,507 sq ft
1149 Greenwich Ave, Warwick, RI 02886
See all

Provided by Redfin

Sale history for 123 Castle Rocks Rd

Date

Event

Price

Public Records

Sep 30, 2025

Sold

$799,000

$275/sq ft

RIS #1387429

Sep 30, 2025

Sold

$779,000

$268/sq ft

Jul 20, 2025

Pending

—

Jul 2, 2025

Contingent

—

Jun 16, 2025

Listed

$799,000

$275/sq ft

RIS #1265646

Nov 23, 2020

Sold

$555,000

$191/sq ft

Oct 8, 2020

Pending

—

Sep 29, 2020

Listed

$549,000

$189/sq ft

Sep 24, 2020

Coming Soon

$549,000

$189/sq ft

+26

Stunning colonial with farmer's porch in Seventeen Farms. Major remodel including gorgeous chef's kitchen with huge granite island, soft close cabinetry, stainless steel appliances and loads of storage. Nice open concept to family room with gas fireplace and wall of windows overlooking the back yard. First floor: eat in kitchen, family room, dining room, formal sitting room, home office, powder room and laundry room. Second level: Master suite with walk in closet, remodeled bathroom complete with soaking tub and walk in shower, three additional bedrooms and full bathroom. Walkout lower level allows plenty of natural light and is partially finished with a family room and home gym. Comfortable deck off the kitchen leads down to patio area with fire pit. Natural gas heat, central a/c, town water, electric pet fence, close to highway, restaurants and shopping.

Year

Property tax

Land + Additions

Assessment*

2025

$8,176 (−1.4%)

$170,100 + $473,700

$643,800

2024

$8,296 (+2.0%)

$147,800 + $425,500

$573,300

2023

$8,135 (+3.7%)

$147,800 + $425,500

$573,300

2022

$7,842

$112,500 + $306,200

$418,700

2021

$7,842

$112,500 + $306,200

$418,700

2020

$7,835

$112,500 + $305,800

$418,300

2019

$7,835 (−0.9%)

$112,500 + $305,800

$418,300

2018

$7,906 (+2.8%)

$127,900 + $252,200

$380,100

2017

$7,693

$127,900 + $252,200

$380,100

2016

$7,693 (+4.7%)

$127,900 + $252,200

$380,100

2015

$7,350 (+3.4%)

$111,500 + $242,700

$354,200

2014

$7,105 (+1.4%)

$111,500 + $242,700

$354,200

2013

$7,010 (+2.0%)

$111,500 + $242,700

$354,200

2012

$6,873

$131,000 + $247,900

$378,900

Tax history for 123 Castle Rocks Rd

Year

Property tax

Land + Additions

Assessment*

2025

$8,176 (−1.4%)

$170,100 + $473,700

$643,800

2024

$8,296 (+2.0%)

$147,800 + $425,500

$573,300

2023

$8,135 (+3.7%)

$147,800 + $425,500

$573,300

2022

$7,842

$112,500 + $306,200

$418,700

2021

$7,842

$112,500 + $306,200

$418,700

2020

$7,835

$112,500 + $305,800

$418,300

2019

$7,835 (−0.9%)

$112,500 + $305,800

$418,300

2018

$7,906 (+2.8%)

$127,900 + $252,200

$380,100

2017

$7,693

$127,900 + $252,200

$380,100

2016

$7,693 (+4.7%)

$127,900 + $252,200

$380,100

2015

$7,350 (+3.4%)

$111,500 + $242,700

$354,200

2014

$7,105 (+1.4%)

$111,500 + $242,700

$354,200

2013

$7,010 (+2.0%)

$111,500 + $242,700

$354,200

2012

$6,873

$131,000 + $247,900

$378,900

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

Year renovated

—

Sq. Ft.

2,112

Year built

1999

Style

Single Family Residential

County

Kent County

APN

258622

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

Interior

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

Room Information
# of Rooms (Total): 11
Has Basement
Basement Information: Full, Partially Finished, Walk-Out Access

Fireplace Information
Has Fireplace
# of Fireplaces: 1
Features: Tile

Equipment
Appliances: Dryer, Dishwasher, Disposal, Gas Water Heater, Microwave, Oven, Range, Refrigerator, Range Hood, Washer

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

Exterior

Building Information
Stories: 3
Stories (Total): 3
Construction Details: Drywall, Vinyl Siding

Exterior Features
Exterior Features: Deck, Patio, Sprinkler/Irrigation, Paved Driveway
Patio And Porch Features: Deck, Patio
Other Structures: Outbuilding
Security Features: Security System Leased
Fencing: Electric

Lot Information
Lot Size Area: 25,265
Lot Size Acres: 0.58
Lot Features: Cul-De-Sac, Sprinkler System, Wooded

Property Information
Below Grade Finished Area: 722
Above Grade Finished Area: 2,186
Foundation Details: Concrete Perimeter

Financial

Assessments and Fees
Assessed Value: $643,800

Tax Information
Annual Tax Amount: $9,315
Tax Year: 2025

Utilities

Utility Information
Utilities: Underground Utilities
Sewer: Septic Tank
Water Source: Connected, Multiple Meters, Public

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

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)

Public facts

Beds: 4
Baths: 2.5
Sq. Ft.: 2,112
Stories: 2.0
Lot Size: 0.58 acres
Style: Single Family Residential
Year Built: 1999
Year Renovated: —
County: Kent County
APN: 258622

Home facts updated by county records on Jun 22, 2026

Around this home

Schools

Scott School

Public K-5 • Assigned • 2.1mi

7/10

Winman Junior High School

Public 6-8 • Assigned • 2.1mi

5/10

Toll Gate High School

Public 9-12 • Assigned • 2.1mi

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

5/10 Heat Factor

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

8/10 Wind Factor

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

$813,000 – $984,000

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

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

Nearby similar homes

$750,000

4 beds2.5 baths2,988 sq ft

465 Red Chimney Dr, Warwick, RI 02886

$459,900

3 beds1.5 baths1,803 sq ft

69 Douglas Rd, Warwick, RI 02886

$679,000

3 beds1 bath1,386 sq ft

12 Manton St, East Greenwich, RI 02818

$899,000

5 beds3.5 baths2,783 sq ft

1 Gladridge Dr, East Greenwich, RI 02818

$2,985,000

6 beds5 baths5,095 sq ft

57 Old Forge Rd, East Greenwich, RI 02818

NEW CONSTRUCTION

$1,469,500

3 beds2.5 baths2,193 sq ft

02 Venus Dr, East Greenwich, RI 02818

New listings for sale in 02886

COMING SOON

$499,999

3 beds1.5 baths1,570 sq ft

27 Centennial St, Warwick, RI 02886

NEW 12 HRS AGO

$499,900

3 beds2.5 baths2,260 sq ft

61 Cactus St, Warwick, RI 02886

COMING SOON

$479,900

3 beds2 baths1,313 sq ft

464 Nausauket Rd, Warwick, RI 02886

$149,900

2 beds1.5 baths784 sq ft

979 #23 Toll Gate Rd, Warwick, RI 02886

OPEN TODAY, 10:30AM TO 12PM3D WALKTHROUGH

$950,000

3 beds2.5 baths3,087 sq ft

67 Love Ln, Warwick, RI 02886

OPEN TODAY, 1PM TO 3PM

$374,900

3 beds2 baths1,872 sq ft

760 Fairfa Strawberry Field Rd, Warwick, RI 02886

$150,000

2 beds1 bath737 sq ft

29 E Andrew Comstock Rd, Warwick, RI 02886

OPEN TODAY, 11AM TO 12:30PM

$279,900

2 beds1.5 baths1,354 sq ft

479 Providence St Unit C2, Warwick, RI 02886

$680,000

4 beds2.5 baths2,200 sq ft

75 Child Ln, Warwick, RI 02889

Home values near 123 Castle Rocks Rd

Data from public records.

Address	Redfin Estimate
83 Castle Rocks Road, Warwick, RI 4 Beds \| 3.5 Baths \| 3464 Sq. Ft.	$762,961
105 Castle Rocks Road, Warwick, RI 4 Beds \| 2.5 Baths \| 3534 Sq. Ft.	$963,243

Address	Redfin Estimate
110 Castle Rocks Road, Warwick, RI 4 Beds \| 2.5 Baths \| 2941 Sq. Ft.	$870,440
150 Castle Rocks Road, Warwick, RI 4 Beds \| 2.5 Baths \| 3350 Sq. Ft.	$907,963

Address	Redfin Estimate
133 Castle Rocks Road, Warwick, RI 4 Beds \| 2.5 Baths \| 3511 Sq. Ft.	$967,226
95 Castle Rocks Road, Warwick, RI 3 Beds \| 2 Baths \| 2044 Sq. Ft.	$799,806

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

More real estate resources

Neighborhoods
Zip Codes
Minor Civil Divisions
Cities
Popular Searches

Cowesett 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.

02852 homes for sale
02920 homes for sale
02921 homes for sale
02886 homes for sale
02818 homes for sale

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

Attleboro homes for sale
Providence homes for sale
Newport homes for sale