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
Days on Market
76
Closing Date
Oct 08, 2026
MLS#
1418571
Subtype
Residential Income
Style
Side By Side
Architectural Style
Side By Side
Year Built
1945
Bedrooms
5
Bathrooms
4
Full Baths
4
Lot Size
19,167
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

Interior Features
Attic, Stall Shower, Tub Shower, Cable TV
Exterior Features
Deck, Paved Driveway
Taxes
$10,178
Property Description
Side By Side
Flooring
Carpet, Ceramic Tile, Hardwood, Marble, Vinyl
Appliances
Dishwasher, Electric Water Heater, Oven, Oil Water Heater, Range, Refrigerator, Washer
Heating
Hot Water, Oil
Air Conditioning
None
Exterior Construction
Drywall, Brick, Masonry, Wood Siding
Levels
One
Foundation
Concrete Perimeter
Parking Features
Detached, Garage
Garage Spaces
2

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: