OFF MARKET

Off Market Jun 2022 for $620K

$699,884

•

1,700

sq ft

600 A23 Cole Farm Rd, Warwick, RI 02889

About this home

Beautiful views from this Waterfront oasis in the quaint seaside community of Cole Farm. Great location at the end of a cul-de-sac. This 3 bedroom 2 bath home features a open and bright layout to optimize the sweeping water views. First floor consists of kitchen which opens to dining area with sliders to the deck, full bath, living room with soaring ceilings and gas fireplace and bedroom currently used as a office/den and laundry area. Second floor has the master which is bright and spacious with it's own private deck and sliders, super sized walk in closet and full bath with walk-in shower. Third bedroom is also on second level and very spacious. This home has gas heat and central AC. Your private oasis just steps to the water. Association has its own beach, private dock and club house. The property owners are stock holders in the land and should meet conforming standards for conventional financing. This beautiful hidden gem of Warwick where homes like this rarely come on the market! Welcome Home! Back on Market due to buyers financing.

Single-familyProperty Type

1986Year Built

$412Est. Price/Sq.Ft.

Listed by Cathi LEARY • Keller Williams Coastal

Bought with Paul Merlino • RE/MAX 1st Choice

Redfin checked: 2 minutes ago

•Source:RIS #1303269

Redfin Estimate

$699,884

$80K since sold in June 2022$5,000 since August

Recently sold homes
Estimate history
Homes for sale

This home's estimate is 106.7% higher than the average sale price ($339K) of 5 comparable homes.

SOLD JUL 2, 2026
$501,000
A
2 beds2.5 baths1,339 sq ft
858 Bullocks Point Ave, Riverside, RI 02915
SOLD JUN 26, 2026
$320,000
B
2 beds1.5 baths1,226 sq ft
1 Willow Glen Cir #25, Warwick, RI 02889
SOLD MAY 6, 2026
$320,000
C
2 beds1.5 baths1,200 sq ft
222 Killey Ave #5, Warwick, RI 02889
SOLD FEB 15, 2023
$265,000
D
2 beds1.5 baths1,085 sq ft
161 West Shore Rd Unit B4, Warwick, RI 02889
SOLD JUL 7, 2026
$287,000
E
2 beds1.5 baths1,134 sq ft
1 Willow Glen Cir #27, Warwick, RI 02889

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

Earn from this home

Sell

$201,626

Est. take-home

List your home with Redfin and save $6,999

Rent

$2,612/mo

Redfin rental estimate

List your home for rent

Market trends in 02889, RI

Last updated August 2026

Buyer's Market

Seller's Market

Seller's market

Sale-to-List Price

101.9%

+0.6% MoM

Median sale price

$450K

$5K MoM

Avg. days on market

26d

2 days MoM

Recently sold homes

122

7 MoM

New listings for sale

OPEN SAT, 12PM TO 2PM
$399,000
4 beds1 bath1,368 sq ft
91 Cavalcade Blvd, Warwick, RI 02889
OPEN SAT, 12PM TO 2PM
$434,900
2 beds1 bath1,214 sq ft
35 Bellman Ave, Warwick, RI 02886
NEW 10 HRS AGO
$350,000
2 beds1 bath1,008 sq ft
321 Church Ave, Warwick, RI 02889
OPEN SAT, 11AM TO 1PM
$219,925
2 beds1 bath614 sq ft
165 Canfield Ave, Warwick, RI 02889
NEW 25 HRS AGO
$329,900
3 beds1 bath960 sq ft
102 Community Rd, Warwick, RI 02889
COMING SOON
$374,900
2 beds1 bath890 sq ft
56 Chesterfield Ave, Warwick, RI 02889
$3,250,000
5 beds4.5 baths4,661 sq ft
140 Aldrich Ave, Warwick, RI 02889
OPEN TODAY, 5PM TO 6PM
$389,900
3 beds1 bath1,560 sq ft
197 Glen Dr, Warwick, RI 02889
OPEN SAT, 1PM TO 3PM
$415,000
3 beds1 bath1,344 sq ft
16 Marigold Dr, Warwick, RI 02889
3D WALKTHROUGH
$450,000
2 beds1 bath800 sq ft
34 Wuddall Ave, Warwick, RI 02889
See all

Provided by Redfin

Sale history for 600 A23 Cole Farm Rd

Date

Event

Price

RIS #1303269

Jun 23, 2022

Sold

$620,000

$365/sq ft

May 1, 2022

Contingent

—

Apr 9, 2022

Relisted

—

Mar 9, 2022

Pending

—

Feb 22, 2022

Contingent

—

Feb 14, 2022

Listed

$639,000

$376/sq ft

RIS #1292308

Aug 29, 2021

Listing Removed

—

Aug 28, 2021

Listed

$625,000

$368/sq ft

RIS #993479

Jul 11, 2011

Listing Removed

—

May 27, 2011

Listed

$445,000

$262/sq ft

RIS #984099

May 20, 2011

Listing Removed

—

Feb 3, 2011

Listed

$475,000

$279/sq ft

RIS #215552

Mar 11, 2003

Listing Removed

—

Oct 10, 2002

Listed

$549,900

$323/sq ft

Tax history for 600 A23 Cole Farm Rd

*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

Stories

Lot width

—

Lot depth

—

Lot size

—

Year renovated

—

Sq. Ft.

1,658

Year built

1986

Style

Condo/Co-op

County

Kent County

APN

519695

Parking Spaces

—

Basement

—

Accessible

—

HOA Dues

—

Garage

—

Features

—

Last updated by owner on Jun 22, 2026.

Property details

Parking

Parking
Features: No Garage

Interior

Virtual Tour

Bathroom Information
# of Full Bathrooms: 2

Room Information
# of Rooms (Total): 6
Has Basement
Basement Information: Full, Unfinished

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

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

Interior Features
Window Features: Storm Window(s), Thermal Windows
Door Features: Storm Door(s)
Flooring: Ceramic Tile, Hardwood, Laminate, Carpet
Other Features: Bathtub, Cathedral Ceiling(s), Tub Shower

Exterior

Building Information
Stories: 2
Stories (Total): 2
Construction Details: Drywall, Clapboard

Exterior Features
Exterior Features: Deck, Porch
Patio And Porch Features: Deck, Porch
Security Features: Security System Owned

Lot Information
Lot Features: Waterfront
Has Waterfront
Waterfront Features: Beach Access, Beach Front, Dock Access, Water Access, Waterfront

Property Information
Above Grade Finished Area: 1,700
Foundation Details: Concrete Perimeter

Financial

Assessments and Fees
Assessed Value: $460,000

Tax Information
Annual Tax Amount: $8,616
Tax Year: 2020

Land Lease Information
Has Land Lease

Utilities

Utility Information
Electric: 200+ Amp Service
Sewer: Septic Tank
Water Source: Connected, Public

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

Location

HOA Information
Association Fee: $1,500
Annually

Community Information
Community Features: Marina, Near Schools, Public Transportation, Shopping

Public facts

Beds: 3
Baths: 2.0
Sq. Ft.: 1,658
Stories: 2.0
Lot Size: —
Style: Condo/Co-op
Year Built: 1986
Year Renovated: —
County: Kent County
APN: 519695

Home facts updated by county records on Jun 22, 2026

About this building

Sorry, but there are no photos available for the building.

No units for sale

600 Cole Farm Rd, Warwick, RI 02889

See photos & sale trends

Photo not available

Units for sale

Unit Information Not Available

There aren't any units for sale in this building.

Around this home

Schools

Hoxsie School

Public K-5 • Assigned • 0.8mi

5/10

Warwick Veterans Jr. High School

Public 6-8 • Assigned • 2.1mi

5/10

Pilgrim High School

Public 9-12 • Assigned • 1.9mi

7/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 96° 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 • 02889

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

$665,000 – $805,000

Reach more buyers when you sell with Redfin. Save up to $6,999 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 2PM

$434,900

2 beds1 bath1,214 sq ft

35 Bellman Ave, Warwick, RI 02886

$489,900

2 beds1 bath784 sq ft

135 Namquid Dr, Warwick, RI 02888

$399,900

3 beds1.5 baths1,344 sq ft

1349 West Shore Rd, Warwick, RI 02889

$439,900

2 beds1 bath1,859 sq ft

51 Terrace Ave, Warwick, RI 02889

$329,900

2 beds1 bath1,030 sq ft

329 Namquid Dr, Warwick, RI 02888

3D WALKTHROUGH

$640,000

4 beds2.5 baths2,100 sq ft

5 Recess Ln, Warwick, RI 02889

New listings for sale in 02889

OPEN SAT, 12PM TO 2PM

$399,000

4 beds1 bath1,368 sq ft

91 Cavalcade Blvd, Warwick, RI 02889

OPEN SAT, 12PM TO 2PM

$434,900

2 beds1 bath1,214 sq ft

35 Bellman Ave, Warwick, RI 02886

NEW 10 HRS AGO

$350,000

2 beds1 bath1,008 sq ft

321 Church Ave, Warwick, RI 02889

OPEN SAT, 11AM TO 1PM

$219,925

2 beds1 bath614 sq ft

165 Canfield Ave, Warwick, RI 02889

NEW 25 HRS AGO

$329,900

3 beds1 bath960 sq ft

102 Community Rd, Warwick, RI 02889

COMING SOON

$374,900

2 beds1 bath890 sq ft

56 Chesterfield Ave, Warwick, RI 02889

$3,250,000

5 beds4.5 baths4,661 sq ft

140 Aldrich Ave, Warwick, RI 02889

OPEN TODAY, 5PM TO 6PM

$389,900

3 beds1 bath1,560 sq ft

197 Glen Dr, Warwick, RI 02889

OPEN SAT, 1PM TO 3PM

$415,000

3 beds1 bath1,344 sq ft

16 Marigold Dr, Warwick, RI 02889

Home values near 600 A23 Cole Farm Rd

Data from public records.

Address	Redfin Estimate
600 Cole Farm Rd Apartment A38, Warwick, RI 2 Beds \| 1 Baths \| 816 Sq. Ft.	$363,904
600 Cole Farm Rd Apartment B10, Warwick, RI 3 Beds \| 1 Baths \| 1035 Sq. Ft.	$269,843

Address	Redfin Estimate
600 Cole Farm Rd Apartment A47, Warwick, RI 1 Beds \| 1.5 Baths \| 1620 Sq. Ft.	$408,002
600 Cole Farm Rd Apartment A12, Warwick, RI 2 Beds \| 1 Baths \| 1113 Sq. Ft.	$366,735

Address	Redfin Estimate
600 Cole Farm Rd Apartment A5, Warwick, RI 3 Beds \| 1.5 Baths \| 1393 Sq. Ft.	$353,056
600 Cole Farm Rd Apartment A22, Warwick, RI 2 Beds \| 1 Baths \| 640 Sq. Ft.	$204,090

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

More real estate resources

Neighborhoods
Cities
Zip Codes
Minor Civil Divisions
Popular Searches

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

02920 homes for sale
02921 homes for sale
02886 homes for sale
02818 homes for sale
02910 homes for sale

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