$399,900
About this home
CASH ONLY. 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.
Highlights
Property details
- MLS
- Rhode Island Association of REALTORS®
- MLS #
- 1426819
- Property type
- Single Family Residence
- Subdivision
- N/A
- Status
- Active
- Days on market
- 11
- On market date
- October 22, 2026
- Stories
- N/A
- Total bathrooms
- 1.5
- Garage spaces
- 3
- Parking spaces
- 9
- Lot size
- 0.6 acres
Location
Get directions →Nearby schools
Within 10 miles. School directory data from the National Center for Education Statistics (NCES), accessed via the Urban Institute Education Data API. Local Score is calculated by INNOVATE Real Estate; where a state rating is shown, it comes from that state's own official school report card.
- Enrollment
- 353
- Student:teacher ratio
- 15.3:1
- District
- Barrington
- Enrollment
- 684
- Student:teacher ratio
- 12.7:1
- District
- Bristol Warren
- Enrollment
- 346
- Student:teacher ratio
- 10.5:1
- District
- Highlander
Walkability
Blended score for Warren's center, calculated by INNOVATE Real Estate from two sources: the EPA's National Walkability Index (street network, transit, land-use mix) and Google Places amenity data (what's actually reachable on foot from this point). 60% EPA National Walkability Index + 40% nearby-amenity density (Google Places).
Mortgage calculator
Estimate only - actual rate and payment depend on your lender, credit, and loan program.
Adjust tax / insurance estimates
Similar homes you might like
Data source: Listing information provided by Rhode Island Association of REALTORS®. Last updated 1 days ago.
Information herein deemed reliable but not guaranteed; all measurements, school assignments, HOA fees, taxes, and feature lists are approximate and should be independently verified. Equal Housing Opportunity.