247 West Main Road 249, Middletown, RI 02842

Show Photos

Verify your account to unlock exclusive photos, mortgage tools, and more.

Sold Price
$1,150,000
List Price
$1,249,000
Status
CLOSED
MLS#
1418571
Closing Date
Oct 08, 2026
Year Built
1945
Levels
One
Style
Side By Side
Bedrooms
5
Bathrooms
4
Acres
0.44
Subdivision
Two Mile Corner

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

Additional Information

Taxes
$10,178
Lot Size
19,167
Interior Features
Attic, Stall Shower, Tub Shower, Cable TV
Flooring
Carpet, Ceramic Tile, Hardwood, Marble, Vinyl
Heating
Hot Water, Oil
Cooling System Type
None
Sewer
Connected, Public Sewer
Water Source
Connected, Public
Appliances
Dishwasher, Electric Water Heater, Oven, Oil Water Heater, Range, Refrigerator, Washer
Fireplaces
2
Basement
Full, Interior Entry, Unfinished
Exterior Features
Deck, Paved Driveway
Garage Spaces
2
Parking Spaces
14

How much is your home worth?

...get instant property value now!

Mortgage Calculator

Amount of Loan
Annual Interest Rate
%
Term of Loan
Years

Does not include any taxes or fees.
Please consult a financial professional.
Calculator source: Real Geeks

Listing courtesy of William Raveis Inspire. Contact:

Selling Office: William Raveis Inspire.

IDX information is provided exclusively for consumers’ 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 is not guaranteed. © 2026 State-Wide Multiple Listing Service. All rights reserved. Data Last Updated: