This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
1/36
$1,249,000 Just Listed
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
1/36
Property Description
Rare Multi-Property Investment Opportunity! Exceptional offering of 247 and 249-251 West Main Road featuring two contiguous properties with outstanding income and investment potential in the heart of Middletown. Whether you're looking to expand your investment portfolio, generate rental income, or occupy one residence while leasing the others, this unique property offers exceptional flexibility. Ideal for year-round rentals, furnished seasonal rentals, or short-term vacation rentals where permitted by local regulations. The prime location, just minutes from Newport, area beaches, shopping, restaurants, marinas, and Naval Station Newport, provides strong rental demand throughout the year. The property also presents an excellent opportunity for a primary residence with supplemental income or future redevelopment potential, subject to municipal approvals. Rarely do three adjacent properties become available as a single offering, creating possibilities for investors, developers, and owner-occupants alike. A truly unique opportunity to own a versatile income-producing property on Aquidneck Island with exceptional long-term appreciation potential. This single-family property is set back from road with a delightful private yard and mature shrubbery . The spacious 2 car garage and plenty of parking add exceptional value. Also being sold separately, please see MLS #1418877 and #1418880.
Full Property Details
Full Property Details for 247 W Main Rd
General
- Price: $1,249,000
- Taxes: $10,178 (2025)
- Status: Active
- Type: Office
- Source: STWMLS
- MLS ID: 1418856
- Updated: 7/26/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
- Tennis: Yes
- Security/Safety: Carbon Monoxide Detector(s), Smoke Detector(s)
Parking
- Garage: Yes
- Total Spaces: 14
Location
- County: Newport
- Subdivision: Two Mile Corner
- Near Highway: Yes
Community
- Units Assoc/Comm: 3
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, Municipal Utilities, Water Connected, Sewer Available, Sewer Connected, Water Available
Structural Information
- # Buildings: 2
- Structure Type: Apartment
- Detached/Attached: Attached
- Construction: Masonry
- Basement: Yes
- Basement Desc.: Full
- Stories/Levels: 1
- Building Size: 2858
- Finished Total: 2,858 Sq. Ft.
- Finished Above Grnd: 2,858 Sq. Ft.
- Year Built: 1945
Lot Features
- Lot Size (Acres): 0.45
- Lot Size (Sq. Ft.): 19,167
- Lot Size: 19167
- Sidewalks: Yes
- Potential Use: Mixed Use, Office, Other, Residential, Single Family
Financial Considerations
- Tax Amount: $10,178
- Tax Year: 2025
- Owner Pays: Heat, Hot Water
- Tenant Pays: Cable TV, Electricity
Disclosures and Reports
- Inclusions: Fireplace
- Property ID: 247249WESTMAINRDMDLT
- Block: NW
- Lot Number: 283
Listed by William Raveis Inspire
Get 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
Date
Details
Price
Change
Source
7/25/2026
Listed
$1,249,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.
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
247 West Main Road, Middletown, RI 02842 (MLS# 1418856) is a Office property. 247 West Main Road is currently listed for $1,249,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.

