247 W Main Road

Property feature image
Property gallery image
Property gallery image
Property gallery image
Property gallery image
Property gallery image
Property gallery image
Property gallery image
Property gallery image
Property gallery image
Property gallery image
Property gallery image
Property gallery image
Property gallery image
Property gallery image
Property gallery image
Property gallery image
Property gallery image
Property gallery image
Property gallery image
Property gallery image
Property gallery image
Property gallery image
Property gallery image
Property gallery image
Property gallery image
Property gallery image
Property gallery image
Property gallery image
Property gallery image
Property gallery image
Property gallery image
Property gallery image
Property gallery image
Property gallery image
Property gallery image
Property gallery image
Address: 247 W Main Rd, Middletown, RI 02842, USA
Boston & New England + 2-4 Units
Created date: July 30, 2026
Date last updated: September 27, 2026
Price: $1,249,000Investment Analyzer NEW!

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.

Key Property Information

Listing Status: Under Contract
Listing Type: Call for offers
Property Types: 2-4 Units
Price: $1,249,000
No. of Units: 3
Year Built: 1945
Lot Size: 2,858.00 Sq ft
Opportunity Zone: No
Price per unit: $416,333
Property Website Click Here
Number of Bedrooms: 5
Number of Bathrooms: 4
Address: 247 W Main Road, Middletown, RI 02842, USA
Provided by:

Investment Analyzer

Step 1Financing Calculation

$
$
%
$
%
$
$

Step 2Gross Rent Analysis

Please enter annual amounts.

$
$
%
$
%
$
%
$
%
$
%
$
%
$
%
$
$

Step 3Final Deal Analysis

$
$
%
%
$
$

Similar Properties in the Area

73 Arch Street

Pawtucket, Rhode Island
Boston & New England + 2-4 Units
Units: 3
Price: $754,900

95 Thomas Avenue

Pawtucket, Rhode Island
Boston & New England + 2-4 Units
Units: 3
Price: $600,000

7 Broad Street

Warwick, Rhode Island
Boston & New England + 2-4 Units
Units: 3
Price: $599,900

Brokers

View All

Lenders

View All