Save
Ask
Tour
Hide
Share
$1,249,000
1 Day 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
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. 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 
1 Day
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
yesterdayStatus changed to Active
yesterdayListing updated with changes from the MLS®
yesterdayListing 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-26 10:04 PM UTC

Neighborhood & Commute
Source: Walkscore
Save
Ask
Tour
Hide
Share