OFF MARKET

Off market jun 2022 for $677K

—

•

6,700

sq ft

49 51 Water St, Warren, RI 02885

About this home

Great opportunity to be a part of Warren's trendy Water St. and among its many antique/vintage shops, restaurants, gift, clothing boutiques, neighboring flower shop, jewelry store, and acupuncturist. This interesting 4 unit mixed-use property was believed to be 2 early buildings built in abt 1830 that were combined around 1939 to be one building. It has many possibilities offering 2 Apts. & 2 highly visible storefronts. If your looking for the perfect live/work situation, investment or an opportunity for your own business this could be it! Commercial unit 1S is vacant, previously a retail store and restaurant and will need a complete update to include a heating system. It has great light from lg. shop windows, HWD Fl, vintage tin ceilings & back storage area giving it lots of space for a multitude of uses. Endless permitted use possibilities in the VB zone for commercial space. Commercial unit 1N is occupied by Ananda Hair Salon. Apt. 2S has 3 BRS w/ Primary Suite & skylight, 2 FBTHS, FR DRS to deck off updated kitchen. Apt. 2N has EK, LR and 2 BR, 1FBTH. This property backs up to the American Tourister Development with 290 units and The Guild Brewery on the waterfront, also giving it lots of foot traffic nearby. Also, a couple of blocks to the East Bay Bikepath where you can bike to Prov or Bristol. Located 15 min. from Prov. , 20 to Fall River, 30 min to New Bedford Ferry and the Islands and only 1.25 hrs to Boston. Property is Sold "As Is" .

Multi-familyProperty Type

1830Year Built

4,182 sq ftLot Size

$101Price/Sq.Ft.

1 spaceParking

Listed by Paula Silva • Residential Properties Ltd.

Bought with The Blackstone Team • Mott & Chace Sotheby's Intl.

Redfin checked: 2 minutes ago

•Source:RIS #1307670

Redfin Estimate

Unfortunately, we don't have enough data to generate an accurate Estimate at this time.

Market trends in 02885, RI

Last updated September 2026

Buyer's Market

Seller's Market

Seller's market

Sale-to-list price

101.8%

1.4% MoM

Median sale price

$525K

$33K MoM

Avg. days on market

25d

0 days MoM

Recently sold homes

2 MoM

New listings for sale

COMING SOON
172 Franklin St, Warren, RI 02885
$575,000
4 beds2 baths1,377 sq ft
172 Franklin St, Warren, RI 02885
OPEN TODAY, 11:30AM TO 1PM
$779,900
3 beds2.5 baths1,946 sq ft
22 Bagy Wrinkle Cv, Warren, RI 02885
OPEN OCT 29, 5PM TO 6:30PM
$580,500
4 beds3 baths3,018 sq ft
24 Seymour St, Warren, RI 02885
OPEN TODAY, 11:30AM TO 1PM
$849,000
3 beds2.5 baths1,939 sq ft
40 Bagy Wrinkle Cv #40, Warren, RI 02885
OPEN TODAY, 2:30PM TO 4:30PM
$399,900
3 beds1.5 baths1,631 sq ft
803 Main St, Warren, RI 02885
$749,999
3 beds2 baths1,731 sq ft
8 Emery Rd, Warren, RI 02885
$709,000
4 beds2 baths2,363 sq ft
614 Child St, Warren, RI 02885
See all

Provided by Redfin

Sale history for 49 51 Water St

Date

Event

Price

RIS #1307670

Jun 29, 2022

Sold

$677,500

$101/sq ft

May 6, 2022

Pending

—

Apr 13, 2022

Listed

$649,000

$97/sq ft

RIS #1303563

Apr 13, 2022

Listing Removed

—

Apr 4, 2022

Contingent

—

Mar 2, 2022

Listed

$699,000

$104/sq ft

RIS #1156002

Apr 26, 2017

Listing Removed

—

Apr 7, 2017

Listed

$415,000

$62/sq ft

RIS #1109476

Oct 2, 2016

Listing Removed

—

Apr 6, 2016

Price Changed

$439,900

$66/sq ft

Oct 4, 2015

Listed

$449,900

$67/sq ft

Year

Property tax

Land + Additions

Assessment*

2025

$8,941 (+3.1%)

$111,500 + $489,000

$600,500

2024

$8,671 (+5.7%)

$111,500 + $489,000

$600,500

2023

$8,203 (+28.2%)

$111,500 + $489,000

$600,500

2022

$6,397 (+1.6%)

$97,600 + $257,600

$355,200

2021

$6,294 (+2.1%)

$97,600 + $257,600

$355,200

2020

$6,166 (−5.8%)

$97,600 + $257,600

$355,200

2019

$6,545 (+1.3%)

$95,600 + $246,900

$342,500

2018

$6,460 (+0.3%)

$95,600 + $246,900

$342,500

2017

$6,442 (−1.0%)

$95,600 + $246,900

$342,500

2016

$6,510

$91,600 + $234,400

$326,000

2015

$6,510 (−0.5%)

$91,600 + $234,400

$326,000

2014

$6,543

$91,600 + $234,400

$326,000

Tax history for 49 51 Water St

Year

Property tax

Land + Additions

Assessment*

2025

$8,941 (+3.1%)

$111,500 + $489,000

$600,500

2024

$8,671 (+5.7%)

$111,500 + $489,000

$600,500

2023

$8,203 (+28.2%)

$111,500 + $489,000

$600,500

2022

$6,397 (+1.6%)

$97,600 + $257,600

$355,200

2021

$6,294 (+2.1%)

$97,600 + $257,600

$355,200

2020

$6,166 (−5.8%)

$97,600 + $257,600

$355,200

2019

$6,545 (+1.3%)

$95,600 + $246,900

$342,500

2018

$6,460 (+0.3%)

$95,600 + $246,900

$342,500

2017

$6,442 (−1.0%)

$95,600 + $246,900

$342,500

2016

$6,510

$91,600 + $234,400

$326,000

2015

$6,510 (−0.5%)

$91,600 + $234,400

$326,000

2014

$6,543

$91,600 + $234,400

$326,000

*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

Stories

Lot width

—

Lot depth

—

Lot size

4,356 Sq. Ft.

Year renovated

—

Sq. Ft.

5,573

Year built

1830

Style

Other

County

Bristol County

APN

540869

Parking Spaces

—

Basement

—

Accessible

—

HOA Dues

—

Garage

—

Features

—

Last updated by owner on Jun 22, 2026.

Property details

Parking

Parking
Features: No Garage
# of Parking (Total): 1

Interior

Bathroom Information
# of Full Bathrooms: 3
# of Half Bathrooms: 3

Room Information
# of Rooms (Total): 15
Has Basement
Basement Information: Interior Entry, Partial, Unfinished

Laundry Information
Features: In Unit

Equipment
Appliances: Dryer, Dishwasher, Exhaust Fan, Gas Water Heater, Oven, Range

Interior Features
Window Features: Skylight(s)
Flooring: Ceramic Tile, Hardwood, Wood
Other Features: Skylights, Tub Shower

Exterior

Building Information
Stories (Total): 3
Construction Details: Drywall, Plaster, Brick, Shingle Siding, Wood Siding

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

Green Features
Green Location: Public Transportation, Walkability
Green Sustainability: Renewable Materials

Lot Information
Lot Size Area: 4,182
Lot Size Acres: 0.096
Waterfront Features: Beach Access, River Access, Water Access, Walk to Water
Zoning: VB

Property Information
Above Grade Finished Area: 6,700
Foundation Details: Brick/Mortar, Combination

Financial

Assessments and Fees
Assessed Value: $355,200

Tax Information
Annual Tax Amount: $6,294
Tax Year: 2022

Utilities

Utility Information
Utilities: Sewer Connected
Electric: 100 Amp Service, Circuit Breakers
Sewer: Connected, Public Sewer
Water Source: Connected, Multiple Meters, Public

Heating & Cooling
Has Cooling
Cooling: 1 Unit, Window Unit(s)
Has Heating
Heating: Baseboard, Gas, Hot Water

Location

Multi Unit Information
# Of Units Total: 4
# Of Buildings: 1

Multi Unit Financial Information
Operating Expense: $10,728

Community Information
Community Features: Golf, Highway Access, Marina, Near Hospital, Near Schools, Public Transportation, Recreation Area, Shopping, Tennis Court(s), Sidewalks

Public facts

Beds: 4
Baths: 3.0
Sq. Ft.: 5,573
Stories: 2.0
Lot Size: 4,356 square feet
Style: Other
Year Built: 1830
Year Renovated: —
County: Bristol County
APN: 540869

Home facts updated by county records on Jun 22, 2026

Around this home

Schools

Hugh Cole School

Public PreK-5 • Assigned • 1.7mi

8/10

Kickemuit Middle School

Public 6-8 • Assigned • 1.4mi

7/10

Mt. Hope High School

Public 9-12 • Assigned • 3.3mi

8/10

Provided by GreatSchools

Lifestyle

Provided by Walk Score and Local Logic

Climate risks

Flood Factor

We're working on getting current and accurate flood risk information for this home.

Fire Factor

We're working on getting current and accurate fire risk information for this home.

5/10 Heat Factor

7 hot days expected this year, 15 days in 30 years

Wind Factor

We're working on getting current and accurate wind risk information for this home.

2/10 Air Factor

2 unhealthy days expected this year, 2 days in 30 years

Provided by First Street

Historical weather

Warren, RI • 02885

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

Work with an experienced agent and save on fees. 3 minutes to get started.

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

Nearby similar homes

$735,000

7 beds4 baths3,468 sq ft

49 Arnold St, Riverside, RI 02915

OPEN TODAY, 11AM TO 12:30PM

$965,000

6 beds3.5 baths4,144 sq ft

36 Kinnicutt Ave, Warren, RI 02885

$449,000

5 beds2.5 baths1,783 sq ft

6 Shore Rd, Riverside, RI 02915

$390,000

2 beds2 baths2,430 sq ft

17 Padelford Ave, Riverside, RI 02915

$499,900

5 beds2 baths2,676 sq ft

319 Main St, Warren, RI 02885

$749,000

4 beds2 baths2,712 sq ft

75 Dewolf Ave, Bristol, RI 02809

New listings for sale in 02885

COMING SOON

$575,000

4 beds2 baths1,377 sq ft

172 Franklin St, Warren, RI 02885

OPEN TODAY, 11:30AM TO 1PM

$779,900

3 beds2.5 baths1,946 sq ft

22 Bagy Wrinkle Cv, Warren, RI 02885

OPEN OCT 29, 5PM TO 6:30PM

$580,500

4 beds3 baths3,018 sq ft

24 Seymour St, Warren, RI 02885

OPEN TODAY, 11:30AM TO 1PM

$849,000

3 beds2.5 baths1,939 sq ft

40 Bagy Wrinkle Cv #40, Warren, RI 02885

OPEN TODAY, 2:30PM TO 4:30PM

$399,900

3 beds1.5 baths1,631 sq ft

803 Main St, Warren, RI 02885

$749,999

3 beds2 baths1,731 sq ft

8 Emery Rd, Warren, RI 02885

$709,000

4 beds2 baths2,363 sq ft

614 Child St, Warren, RI 02885

Home values near 49 51 Water St

Data from public records.

Address	Redfin Estimate
64 Water Street, Warren, RI 4 Beds \| 2 Baths \| 2990 Sq. Ft.	$790,561
54 Water Street, Warren, RI 6 Beds \| 2 Baths \| 3254 Sq. Ft.	—

Address	Redfin Estimate
38 Water Street, Warren, RI 6 Beds \| 2 Baths \| 3034 Sq. Ft.	—
67 Water Street, Warren, RI 5 Beds \| 3 Baths \| 3150 Sq. Ft.	—

Address	Redfin Estimate
48 Water Street, Warren, RI 3 Beds \| 2.5 Baths \| 2580 Sq. Ft.	$599,880
77 Water Street, Warren, RI 6 Beds \| 4 Baths \| 4294 Sq. Ft.	—

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

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.

02806 homes for sale
02809 homes for sale
02777 homes for sale
02885 homes for sale

Houses for rent in Warren	Agents near me	Warwick, RI homes for sale	Warren 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	Warren Property Records
Condos for sale near me	Cranston, RI homes for sale	RI New Listings

Downton Warren homes for sale
Warren Historic District homes for sale

Easton homes for sale
Attleboro homes for sale
Providence homes for sale

About this home

Redfin Estimate

Market trends in 02885, RI

Sale history for 49 51 Water St

Tax history for 49 51 Water St

Public record

Property details

Around this home

Schools

Lifestyle

Climate risks

Historical weather

Sun exposure

Nearby similar homes

New listings for sale in 02885

Home values near 49 51 Water St

More real estate resources