OFF MARKET

Off Market Oct 2020 for $710K

$1,375,499

•

2,418

sq ft

174 Andrew Comstock Rd, Warwick, RI 02886

About this home

Spectacular Waterfront setting on Greenwich Bay! Shingle style residence in Olde Buttonwoods! If you are looking for a privacy and waterfront, this is your stop. Originally constructed in 1939 on a bluff overlooking the bay, this 2400 sq. ft residence is ready for a new family to celebrate and to potentially update this home. Large open flow floor plan with stone fireplace and walls of glass to the water. Huge wrap around deck. Also the covered porch on the west side is not included in the square footage. 4 Bedrooms and two full baths on the second level. Oversized detached two car garage. Neighborhood was modeled after Oak Bluff on Martha's Vineyard. Lots of open space, nature walking paths, ballfields, beaches. recreation hall(withe stage and duck pin bowling, called The Casino, ) non denominational Chapel, basketball court, clay tennis courts, composition tennis court and pickle ball court.

Single-familyProperty Type

1939Year Built

0.47 acresLot Size

$569Est. Price/Sq.Ft.

2 car garageParking

Listed by The Phipps Team • PHIPPS REALTY

Bought with Linda O'Rourke • HomeSmart Professionals

Redfin checked: 3 minutes ago

•Source:RIS #1253874

Redfin Estimate

$1,375,499

$665K since sold in October 2020$9,000 since August

Recently sold homes
Estimate history
Homes for sale

This home's estimate is 150.2% higher than the average sale price ($550K) of 6 comparable homes.

SOLD NOV 21, 2025
$469,000
A
3 beds2 baths2,090 sq ft
35 Saratoga Rd, Warwick, RI 02886
SOLD AUG 19, 2026
$485,000
B
4 beds2 baths2,052 sq ft
265 Asylum Rd, Warwick, RI 02886
SOLD AUG 28, 2026
$530,000
C
4 beds2 baths2,150 sq ft
262 Pequot Ave, Warwick, RI 02889
SOLD AUG 11, 2026
$630,000
D
3 beds2 baths2,940 sq ft
122 Spring Grove Ave, Warwick, RI 02889
SOLD JUL 29, 2026
$650,000
E
4 beds2 baths1,746 sq ft
12 Silver St, Warwick, RI 02889
SOLD JUN 29, 2026
$535,000
F
4 beds2 baths2,020 sq ft
47 Long St, Warwick, RI 02888

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

Earn from this home

Sell

$792,461

Est. take-home

List your home with Redfin and save $13,755

Rent

$2,251/mo

Redfin rental estimate

List your home for rent

Market trends in 02886, RI

Last updated August 2026

Buyer's Market

Seller's Market

Seller's market

Sale-to-List Price

102.2%

+1.0% MoM

Median sale price

$425K

$5K MoM

Avg. days on market

24d

1 days MoM

Recently sold homes

110

7 MoM

New listings for sale

OPEN TODAY, 10:30AM TO 12PM
$449,900
2 beds1.5 baths1,100 sq ft
81 Cadora Ave, Warwick, RI 02886
OPEN TODAY, 10:30AM TO 12PM
$449,900
2 beds1.5 baths1,130 sq ft
83 Cadora Ave, Warwick, RI 02886
OPEN SUN, 11AM TO 12:30PM
$500,000
3 beds2 baths1,736 sq ft
102 Hillard Ave, Warwick, RI 02886
$525,000
4 beds2 baths2,588 sq ft
65 Hedgegrow Dr, Warwick, RI 02886
$379,900
4 beds2 baths2,284 sq ft
34 Lancaster Ave, Warwick, RI 02886
COMING SOON
$475,000
2 beds2.5 baths1,662 sq ft
724 Centerville Rd #8, Warwick, RI 02886
OPEN TODAY, 11AM TO 12PM
$399,000
3 beds1 bath1,800 sq ft
5 Packard Ave, Warwick, RI 02886
COMING SOON
$389,777
2 beds2 baths1,065 sq ft
982 Brighton Way, Warwick, RI 02886
OPEN TODAY, 11:30AM TO 1PM
$475,000
3 beds2.5 baths1,644 sq ft
2907 Post Rd #1, Warwick, RI 02886
OPEN TODAY, 12PM TO 1:30PM
$499,900
3 beds1 bath1,156 sq ft
56 Fashion Dr, Warwick, RI 02886
See all

Provided by Redfin

Sale history for 174 Andrew Comstock Rd

Year

Property tax

Land + Additions

Assessment*

2025

$13,142 (−0.3%)

$559,100 + $475,700

$1,034,800

2024

$13,178 (+2.0%)

$485,600 + $425,100

$910,700

2023

$12,923 (−7.7%)

$485,600 + $425,100

$910,700

2022

$13,999 (+15.5%)

$459,200 + $288,200

$747,400

2021

$12,124 (−5.5%)

$459,200 + $188,100

$647,300

2020

$12,836

$459,200 + $226,100

$685,300

2019

$12,836 (+0.8%)

$459,200 + $226,100

$685,300

2018

$12,736 (+2.8%)

$435,600 + $176,700

$612,300

2017

$12,393

$435,600 + $176,700

$612,300

2016

$12,393 (+0.7%)

$435,600 + $176,700

$612,300

2015

$12,305 (+3.4%)

$432,300 + $160,700

$593,000

2014

$11,896 (+1.4%)

$432,300 + $160,700

$593,000

2013

$11,735 (−7.5%)

$432,300 + $160,700

$593,000

2012

$12,689

$558,800 + $140,700

$699,500

Tax history for 174 Andrew Comstock Rd

Year

Property tax

Land + Additions

Assessment*

2025

$13,142 (−0.3%)

$559,100 + $475,700

$1,034,800

2024

$13,178 (+2.0%)

$485,600 + $425,100

$910,700

2023

$12,923 (−7.7%)

$485,600 + $425,100

$910,700

2022

$13,999 (+15.5%)

$459,200 + $288,200

$747,400

2021

$12,124 (−5.5%)

$459,200 + $188,100

$647,300

2020

$12,836

$459,200 + $226,100

$685,300

2019

$12,836 (+0.8%)

$459,200 + $226,100

$685,300

2018

$12,736 (+2.8%)

$435,600 + $176,700

$612,300

2017

$12,393

$435,600 + $176,700

$612,300

2016

$12,393 (+0.7%)

$435,600 + $176,700

$612,300

2015

$12,305 (+3.4%)

$432,300 + $160,700

$593,000

2014

$11,896 (+1.4%)

$432,300 + $160,700

$593,000

2013

$11,735 (−7.5%)

$432,300 + $160,700

$593,000

2012

$12,689

$558,800 + $140,700

$699,500

*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

3.5

Stories

Lot width

—

Lot depth

—

Lot size

0.47 Acres

Year renovated

—

Sq. Ft.

2,418

Year built

1939

Style

Single Family Residential

County

Kent County

APN

300170

Parking Spaces

—

Basement

—

Accessible

—

HOA Dues

—

Garage

—

Features

—

Last updated by owner on Jun 22, 2026.

Property details

Parking

Garage/Carport Information
Has Garage
# of Garage Spaces: 2

Parking
Features: Detached, Garage
# of Parking (Total): 10
# 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: Exterior Entry, Full, Interior Entry, Unfinished

Fireplace Information
Has Fireplace
# of Fireplaces: 2
Features: Stone

Equipment
Appliances: Dishwasher, Oven, Oil Water Heater, Range, Refrigerator

Interior Features
Window Features: Thermal Windows
Door Features: Storm Door(s)
Flooring: Carpet, Vinyl, Wood
Other Features: Tub Shower

Exterior

Building Information
Stories: 2
Stories (Total): 2
Construction Details: Shingle Siding, Wood Siding

Exterior Features
Exterior Features: Deck, Porch
Patio And Porch Features: Deck, Porch

Lot Information
Lot Size Area: 20,440
Lot Size Acres: 0.4692
Lot Features: Private, Secluded
Waterfront Features: Beach Access, Beach Front, Water Access, Walk to Water

Property Information
Has View
Above Grade Finished Area: 2,418
Foundation Details: Concrete Perimeter

Financial

Assessments and Fees
Assessed Value: $685,300

Tax Information
Annual Tax Amount: $12,836
Tax Year: 2019

Utilities

Utility Information
Utilities: Sewer Connected
Electric: 150 Amp Service
Sewer: Connected, Sewer Assessment(s)
Water Source: Connected

Heating & Cooling
Has Heating
Heating: Baseboard, Oil

Location

Community Information
Community Features: Recreation Area, Tennis Court(s)

Public facts

Beds: 4
Baths: 3.5
Sq. Ft.: 2,418
Stories: 2.0
Lot Size: 0.47 acres
Style: Single Family Residential
Year Built: 1939
Year Renovated: —
County: Kent County
APN: 300170

Home facts updated by county records on Jun 22, 2026

Around this home

Schools

Park School

Public K-5 • Assigned • 0.5mi

8/10

Winman Junior High School

Public 6-8 • Assigned • 3.3mi

5/10

Toll Gate High School

Public 9-12 • Assigned • 3.3mi

5/10

Provided by GreatSchools

Lifestyle

Provided by Walk Score and Local Logic

Climate risks

5/10 Flood Factor

Estimated 45-55% chance 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, 15 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

$1.31M – $1.58M

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

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

Nearby similar homes

OPEN SUN, 11AM TO 12:30PM

$219,925

2 beds1 bath614 sq ft

165 Canfield Ave, Warwick, RI 02889

FOR SALE BY OWNER

$259,000

3 beds1 bath944 sq ft

77 Huron St, Warwick, RI 02889

$550,000

5 beds2 baths2,756 sq ft

20 Stewart St, Warwick, RI 02889

$860,000

5 beds3.5 baths2,668 sq ft

80 Preston Dr, Warwick, RI 02886

$2,200,000

3 beds2.5 baths2,613 sq ft

139 Hemlock Ave, Warwick, RI 02886

OPEN TODAY, 11:30AM TO 1:30PM

$1,500,000

4 beds2.5 baths3,034 sq ft

127 Beacon Ave, Warwick, RI 02889

New listings for sale in 02886

OPEN TODAY, 10:30AM TO 12PM

$449,900

2 beds1.5 baths1,100 sq ft

81 Cadora Ave, Warwick, RI 02886

OPEN TODAY, 10:30AM TO 12PM

$449,900

2 beds1.5 baths1,130 sq ft

83 Cadora Ave, Warwick, RI 02886

OPEN SUN, 11AM TO 12:30PM

$500,000

3 beds2 baths1,736 sq ft

102 Hillard Ave, Warwick, RI 02886

$525,000

4 beds2 baths2,588 sq ft

65 Hedgegrow Dr, Warwick, RI 02886

$379,900

4 beds2 baths2,284 sq ft

34 Lancaster Ave, Warwick, RI 02886

COMING SOON3D WALKTHROUGH

$475,000

2 beds2.5 baths1,662 sq ft

724 Centerville Rd #8, Warwick, RI 02886

OPEN TODAY, 11AM TO 12PM

$399,000

3 beds1 bath1,800 sq ft

5 Packard Ave, Warwick, RI 02886

COMING SOON

$389,777

2 beds2 baths1,065 sq ft

982 Brighton Way, Warwick, RI 02886

OPEN TODAY, 11:30AM TO 1PM

$475,000

3 beds2.5 baths1,644 sq ft

2907 Post Rd #1, Warwick, RI 02886

Home values near 174 Andrew Comstock Rd

Data from public records.

Address	Redfin Estimate
154 Andrew Comstock Rd, Warwick, RI 3 Beds \| 2 Baths \| 1503 Sq. Ft.	$552,636
17 Andrew Comstock Rd, Warwick, RI 2 Beds \| 1 Baths \| 738 Sq. Ft.	$246,491

Address	Redfin Estimate
148 Andrew Comstock Rd, Warwick, RI 3 Beds \| 1.5 Baths \| 2250 Sq. Ft.	$868,407
5 Andrew Comstock Rd, Warwick, RI 2 Beds \| 1 Baths \| 600 Sq. Ft.	$238,238

Address	Redfin Estimate
10 Andrew Comstock Rd, Warwick, RI 2 Beds \| 1 Baths \| 688 Sq. Ft.	$155,493
154 Andrew Comstock Rd, Warwick, RI 3 Beds \| 2 Baths \| 1503 Sq. Ft.	$653,024

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

More real estate resources

Cities
Minor Civil Divisions
Neighborhoods
Zip Codes
Popular Searches

Attleboro homes for sale
Providence homes for sale
Newport 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.

Plainfield homes for sale
Thompson homes for sale
Killingly homes for sale
Griswold homes for sale
North Stonington homes for sale

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