Date
Details
Price
Change
Source
7/25/2026
Listed
$799,000
—
MLS
Disclaimer: Historical sales information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
1/28
$799,000 Just Listed
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
1/28
Property Description
Welcome to 247 West Main Road in Middletown RI, a charming three-bedroom, two bath home offering comfort, space and an unbeatable location Just minutes from beautiful beaches, the renowned attractions of Newport and a wide variety of shopping, dining and everyday conveniences, this home provides the perfect blend of coastal living and practicality. Owned by the same family since it was built in 1935, inside features generous sized rooms filled with light from ample windows, creating a warm and inviting atmosphere throughout. The thoughtfully designed layout offers plenty of space for both everyday living and entertaining. The expansive basement presents endless possibilities, whether you envision a workshop, hobby space, home gym or additional storage. In addition to TWO patios off the house, there is also a detached garage with its own unique three season retreat overlooking the pretty backyard and gardens. Outside the property is enhanced by an abundance of mature trees, vibrant flowering garden and attractive landscaping that create a private, picturesque setting throughout the seasons. Also being sold as a package with 249-251 West Main see MLS #1418856.
Full Property Details
Full Property Details for 247 W Main Rd
General
- Price: $799,000
- Taxes: $5,778 (2025)
- Status: Active
- Type: Office
- Source: STWMLS
- MLS ID: 1418877
- Updated: 7/25/2026
- Added to Site: 1 day(s) ago
Business
- Business Type: Barber/Beauty, Professional/Office, Professional Ser
Interior
- Furnishings: Unfurnished
Rooms
Other Rooms
- Laundry: Common Area
Additional Information
- Security/Safety: Carbon Monoxide Detector(s), Smoke Detector(s)
Parking
- Garage: Yes
- Total Spaces: 10
Location
- County: Newport
- Subdivision: Two Mile Corner
- Near Highway: Yes
Community
- Units Assoc/Comm: 1
Heating & Cooling
- Cooling Type: None
- Heating Type: Hot Water
Utilities
- Sewer: Connected, Public Sewer
- Water: Connected, Public
- Cable Available: Yes
- Utility Description: Cable Available, Electricity Available, Natural Gas Not Available, Sewer Available, Sewer Connected, Water Available
Structural Information
- # Buildings: 1
- Structure Type: Apartment
- Detached/Attached: Attached
- Construction: Masonry
- Basement: Yes
- Basement Desc.: Full
- Stories/Levels: 1
- Building Size: 1798
- Finished Total: 1,798 Sq. Ft.
- Finished Above Grnd: 1,798 Sq. Ft.
- Year Built: 1945
Lot Features
- Lot Size (Acres): 0.31
- Lot Size (Sq. Ft.): 13,504
- Lot Size: 13504
- Sidewalks: Yes
- Potential Use: Mixed Use, Office, Other, Residential, Single Family
Financial Considerations
- Tax Amount: $5,778
- Tax Year: 2025
Disclosures and Reports
- Property ID: 247WESTMAINRDMDLT
- Block: NW
- Lot Number: 283
Listed by William Raveis Inspire
We Value Your Privacy
We Value Your Privacy
We Value Your Privacy
Listing agents
— 247 W Main Rd —
William Raveis Inspire
William Raveis Inspire
NMLS#: 1598647Get Pre-Approved Today
Schools
Schools serving 247 W Main Rd
School District:Middletown School District
| Name | Grades | Distance |
|---|---|---|
Joseph Gaudet Academy 1113 Aquidneck Avenue, Middletown, RI 02842 | 4- | 1.3 mi |
Aquidneck School 70 Reservoir Road, Middletown, RI 02842 | PK-3 | 1.5 mi |
Joseph H. Gaudet School 1113 Aquidneck Avenue, Middletown, RI 02842 | 5-8 | 1.3 mi |
Middletown High School 130 Valley Road, Middletown, RI 02842 | 9-12 | 0.9 mi |
Disclaimer:
School attendance boundaries provided by ATTOM Data Solutions and are for reference only. Contact the school directly to verify enrollment eligibility.
Price & Sales History for 247 W Main Rd
Tax History
Tax History for 247 W Main Rd
Year
Property Taxes
Change
Tax Assessment
Change
2025
$5,778
5%
$490,100
—
2024
$5,519
29%
$490,100
44%
2023
$4,278
5%
$339,800
—
2022
$4,084
10%
$339,800
—
2021
$3,708
—
$339,800
6%
2021
$3,708
-16%
$319,800
—
2018
$4,397
7%
$319,800
20%
2016
$4,106
3%
$266,300
—
2015
$4,005
-4%
$266,300
2%
2014
$4,177
2%
$259,900
—
2013
$4,083
—
$259,900
—
Disclaimer: Historical tax information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.
Estimate the Cost
Estimate the Cost for 247 W Main Rd
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
- Single Family
- Active
- Updated 3 days ago
- 4Beds
- 3Total Baths
- 2,175Sq. Ft.
- Single Family
- Active
- Updated 4 days ago
- 4Beds
- 3Total Baths
- 2,040Sq. Ft.
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
247 West Main Road, Middletown, RI 02842 (MLS# 1418877) is a Office property. 247 West Main Road is currently listed for $799,000 and was received on July 25, 2026. Want to learn more about 247 West Main Road? Do you have questions about finding other Office real estate for sale in Middletown? You can browse all Middletown real estate or contact a Coldwell Banker agent to request more information.