Google street view image for 174 Andrew Comstock Rd, Warwick, RI 02886

Off Market Nov 2020 for $710K

$1,246,194

Est. refi paymentEst. refi $4,613/mo

•

3.5 ba

•

2,418

sq ft

174 Andrew Comstock Rd, Warwick, RI 02886

About this home

174 Andrew Comstock Rd is a 2,418 square foot house on a 0.47 acre lot with 4 bedrooms and 3.5 bathrooms. - it last sold on November 05, 2020 for $710,000. Based on Redfin's Warwick data, we estimate the home's value is $1,246,194.

Single-familyProperty Type

1939Year Built

0.47 acresLot Size

$515Est. Price/Sq.Ft.

Source:Public Records

Redfin Estimate

$1,246,194

$536K since sold in November 2020$43K since August

Recently sold homes
Estimate history
Homes for sale

This home's estimate is 120.3% higher than the average sale price ($566K) 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 DEC 1, 2025
$629,999
D
4 beds3.5 baths3,489 sq ft
110 Wethersfield Dr, Warwick, RI 02886
SOLD JUL 29, 2026
$650,000
E
4 beds2 baths1,746 sq ft
12 Silver St, Warwick, RI 02889
SOLD AUG 11, 2026
$630,000
F
3 beds2 baths2,940 sq ft
122 Spring Grove Ave, Warwick, RI 02889

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

Earn from this home

Sell

$669,578

Est. take-home

List your home with Redfin and save $12,462

Refinance

Est. cash available

Get cash now or lower your monthly rate

Rent

$2,230/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
OPEN SUN, 11AM TO 1PM
$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

Tax history for 174 Andrew Comstock Rd

*Taxable value of land and structures on it ("additions") is determined regularly by local assessors and does not affect market price.

Property details

Interior

Basement Information
Basement Sq. Ft: 1,118
Basement Type: Partial

Bathroom Information
# of Full Baths: 3
# of 1/2 Baths: 1

Heating & Cooling
Heating Type: Forced Hot Water

Fireplace Information
# of Fireplaces: 2
Has Fireplace

Room Information
# of Rooms: 8

Exterior

Exterior Information
Physical Condition: Average
Building Style Type: Colonial
Exterior Wall: Vinyl
Roof Shape Type: Gable

Property Information
Living Sq. Ft: 2,418
Gross Sq. Ft: 4,726
Ground Floor Sq. Ft: 1,209
# of Units: 1
# of Stories: 2
Legal Description: 000373 - 000000 - 320000 - 000000

Lot Information
# of Buildings: 1
Land Sq. Ft: 20,473
Municipality Name: WARWICK
Acres: 0.47
Zoning Code: A15
State Use Description: 1-FAMILY RESIDENCE

Financial

Assessor Information
Assessment Year: 2025

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: 9521625S

Home facts updated by county records on Jul 15, 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

Try the sun simulator tool to see how light moves across the property at different times of day and year.

Provided by Shadowmap

Estimated sale price

$1.18M – $1.43M

Reach more buyers when you sell with Redfin. Save up to $12,462 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

$434,900

4 beds2 baths1,308 sq ft

131 Canfield Ave, Warwick, RI 02889

$2,200,000

3 beds2.5 baths2,613 sq ft

139 Hemlock Ave, Warwick, RI 02886

OPEN TODAY, 11AM TO 1PM3D WALKTHROUGH

$799,900

4 beds2 baths1,900 sq ft

18 Pevear Ave, Warwick, RI 02886

FOR SALE BY OWNER

$259,000

3 beds1 bath944 sq ft

77 Huron St, Warwick, RI 02889

$299,900

3 beds1 bath980 sq ft

113 Canfield 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

OPEN SUN, 11AM TO 1PM

$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

More real estate resources

Zip Codes
Neighborhoods
Cities
Minor Civil Divisions
Popular Searches

02920 homes for sale
02921 homes for sale
02886 homes for sale
02818 homes for sale
02910 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

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