It's in the top 10% of views. Tour it before it's gone!
Tomorrow:
About this home
CASH ONLY. MUST CLOSE ON OR BEFORE 11/6. SHOWINGS ONLY SUN 10/25, 2:30-4:30PM & MON 10/26, 3:30-5:30PM. Rare opportunity to unlock serious value in one of Warren's most desirable locations. Set on a . 6-acre lot that stretches directly back to the East Bay Bike Path and sits right behind Burr's Hill Park and Warren Town Beach, the location alone makes this a standout for investors, builders, or renovation-minded buyers. Known historically as the Cole-Howland Farmhouse, this circa 1740 home is believed to pre-date the Revolutionary War and carries deep ties to Warren's early shipbuilding history. Today, it's ready for its next chapter. The home offers 3 bedrooms and 1.5 baths and does need work. This is a true project, not for the faint of heart, but the upside is clear for those willing to take it on. A major value driver is the massive 3-car garage with living space above, presenting strong potential for an ADU, in-law setup, rental income, studio, or workshop. The depth and layout of the lot create additional flexibility rarely found this close to the water, and the property features an in-ground pool ready to be brought back to life. For investors, flippers, or end users looking to build equity, this is a location-driven opportunity with multiple paths to value. Properties with this kind of lot size, positioning, and direct proximity to the bike path, park, and beach are extremely hard to find. Bring your vision and capitalize on the potential at 803 Main Street.
Beach Terrace, located between the Warren River waterfront and Kickemuit River, is a residential and coastal Warren neighborhood with salt-marsh edges and pocket beaches. The neighborhood’s character concentrates along Water Street near the Warren Town Wharf, where marinas, small galleries, and sidewalk dining set a working-waterfront tone. Housing reads as classic coastal New England—compact capes, shingled cottages, and updated colonials—on quiet streets that bend toward the shoreline. The East Bay Bike Path threads nearby, linking daily routines to river views and breezy rides. Community pillars include The Square Peg, The Guild Warren, and the Warren Performing Arts Center, each adding a distinct local cadence. Sunsets and boat traffic shape the soundtrack, with public access points keeping the water close.
Provided by Walk Score and Local Logic
Market insights
803 Main St · $399,900
DAYS ON MARKET
4 days
The average home goes pending in 25 days.
SALE-TO-LIST
100.0%
Most homes are selling 0% below list price.
LIST PRICE
$399,900
Median list price in this area is $638,044. (60% higher than this home)
PRICE DROP
0 price drops
18% of homes in this area have had a price drop in the past month.
Property details
Interior
Exterior
Finance
Kitchen
Bathroom
Bedroom
Living
Interior features
Two masonry fireplaces
Tub and shower
Full, unfinished basement with interior entry
Bathrooms
1 full bathroom
1 half bathroom
Kitchen
Oven, range, refrigerator
Laundry & utility
Washer, dryer, electric water heater
Flooring
Hardwood flooring
Heating & cooling
Forced-air heating fueled by oil
Exterior features
Porch
Fenced yard
In-ground pool
Water view
Walk to water
Home design
Two stories
Parking
Attached garage with 3 spaces
9 total parking spaces
Construction
Clapboard and wood siding
Combination and stone foundation
Utilities
Public water
Public sewer
100-amp electrical service
HOA & community
Annual association fee
Community features include a pool, tennis courts, public transportation, restaurants, and nearby schools
Electricity and solar
View estimated energy costs and solar savings for this home
Permit history is from public records and may be incomplete or inaccurate. Redfin and its agents make no representations about the property condition or permit status. Buyers should independently verify all information.
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 97° 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
Warren, RI • 02885
Average low and high temperatures (°F)
35
22
37
22
50
33
59
41
68
52
80
62
84
66
80
60
75
57
65
48
54
38
40
26
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Sun exposure
93/ 100
Exceptional sunlight
Sunscore
This home ranks in the top 11% for direct sun exposure in Warren. There appears to be minimal shading by surrounding buildings, terrain, and vegetation.
9.2 hrs
5.3 hrs
JuneDecember
Provided by Shadowmap
Redfin Estimate for 803 Main St
$408,471
$8,571 over list price of $400K
Nearby comparable homes
The Redfin Estimate uses 6 recent nearby sales, priced between $310K to $540K.