Save
Ask
Tour
Hide
Share
$1,249,000
2 Days On Site

247 West Main Road 249
Middletown, RI 02842

For Sale|Office|Active
0
Beds
0
Total Baths
2,858
SqFt
$437
/SqFt
1945
Built
Subdivision:
Two Mile Corner
County:
Newport
247 West Main Road 249247 West Main Road 249247 West Main Road 249247 West Main Road 249
Save
Ask
Tour
Hide
Share

Mortgage Calculator

Monthly Payment (Est.)

$5,698
Calculator powered by Showcase IDX, a Constellation1 Company. Copyright ©2026 Information is deemed reliable but not guaranteed.

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.

Save
Ask
Tour
Hide
Share
Listing Snapshot
Price 
$1,249,000
Days On Site 
2 Days
Bedrooms 
N/A
Inside Area (SqFt) 
2,858 sqft
Total Baths 
N/A
Full Baths 
N/A
Partial Baths 
N/A
Lot Size 
0.45 Acres
Year Built 
1945
MLS® Number 
1418856
Status 
Active
Property Tax 
$10,178
HOA/Condo/Coop Fees 
N/A
Sq Ft Source 
N/A
Friends & Family
Recent Activity
yesterdayStatus changed to Active
yesterdayListing updated with changes from the MLS®
3 days agoListing first seen on site
General Features
Acres 
0.45
Additional Property Use 
Mixed UseOfficeOtherResidentialSingle Family
Foundation 
Concrete Perimeter
Garage 
Yes
Land Lease 
No
Levels 
One
Number Of Stories 
1
Parking Spaces 
14
Property Sub Type 
Office
Security 
Carbon Monoxide Detector(s)Smoke Detector(s)
Sewer 
Public Sewer
SqFt Above 
2858
SqFt Total 
2858
Utilities 
Cable AvailableElectricity AvailableNatural Gas Not AvailableWater ConnectedSewer AvailableSewer ConnectedWater Available
Water Source 
Public
Zoning 
OBA
Interior Features
Basement 
Full
Electric 
100 Amp Service
Furnished 
Unfurnished
Heating 
Hot Water
Laundry Features 
Common Area
Save
Ask
Tour
Hide
Share
Community Features
Community Features 
GolfOtherPoolRestaurantTennis Court(s)Sidewalks
Roads 
NonePaved
Listing courtesy of Jeanne Allen of William Raveis Inspire (401) 864-2752



Listing information is provided by Participants of the State-Wide MLS of Rhode Island, Inc. IDX information is provided exclusively for personal, non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information is deemed reliable but not guaranteed. Copyright 2026, State-Wide MLS of Rhode Island, Inc.
Last checked: 2026-07-27 12:46 PM UTC

Neighborhood & Commute
Source: Walkscore
Save
Ask
Tour
Hide
Share