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

247 West Main Road 249
Middletown, RI 02842

For Sale|Multi Family|Active
5
Beds
4
Total Baths
4
Full Baths
2,858
SqFt
$437
/SqFt
1945
Built
Subdivision:
Two Mile Corner
County:
Newport

Due to the health concerns created by Coronavirus we are offering personal 1-1 online video walkthough tours where possible.

Call Now: ​401-559-7674
Is this the listing for you? We can help make it yours.
​401-559-7674
Upcoming Open Houses
Due to COVID-19, we recommend you verify Open Houses before attending.
Sun, Aug 2, 11:00 AM - 1:00 PM
247 West Main Road 249247 West Main Road 249247 West Main Road 249247 West Main Road 249
Save
Ask
Tour
Hide
Share

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. House and duplex are also being listed separately, please see MLS #s 1418769 and 1418643.

Save
Ask
Tour
Hide
Share
Listing Snapshot
Price 
$1,249,000
Days On Site 
3 Days
Bedrooms 
5
Inside Area (SqFt) 
2,858 sqft
Total Baths 
4
Full Baths 
4
Partial Baths 
N/A
Lot Size 
0.44 Acres
Year Built 
1945
MLS® Number 
1418571
Status 
Active
Property Tax 
$10,178
HOA/Condo/Coop Fees 
N/A
Sq Ft Source 
Appraiser
Friends & Family
Recent Activity
2 days agoStatus changed to Active
2 days agoListing updated with changes from the MLS®
3 days agoListing first seen on site
General Features
Acres 
0.44
Foundation 
Concrete Perimeter
Garage 
Yes
Garage Spaces 
2
Land Lease 
No
Levels 
One
Number Of Stories 
1
Parking 
PavedDetachedGarage
Parking Spaces 
14
Property Sub Type 
Multi Family
Sewer 
Public Sewer
SqFt Above 
2858
SqFt Total 
2858
Style 
Side By Side
Utilities 
Cable AvailableSewer AvailableSewer ConnectedWater AvailableWater Connected
Water Source 
Public
Zoning 
OBA
Interior Features
Appliances 
DishwasherElectric Water HeaterOvenRangeRefrigeratorWasherWater Heater
Basement 
FullInterior EntryUnfinished
Electric 
100 Amp Service
Fireplace 
Yes
Fireplace Features 
Masonry
Fireplaces 
2
Flooring 
CarpetCeramic TileHardwoodMarbleVinyl
Heating 
Hot WaterOil
Laundry Features 
Common Area
Window Features 
Storm Window(s)
Save
Ask
Tour
Hide
Share
Exterior Features
Construction Details 
BrickWood Siding
Other Structures 
Workshop
Patio And Porch 
DeckPorchScreened
Windows/Doors 
Storm Window(s)
Community Features
Community Features 
GolfOtherPoolRestaurantTennis Court(s)Sidewalks
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-28 12:09 AM UTC

Neighborhood & Commute
Source: Walkscore
Disclosure: Community information and market data powered by Constellation Data Labs. Information is deemed reliable but not guaranteed.
Save
Ask
Tour
Hide
Share