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. Also being sold separately, please see MLS #1418877 and #1418880.
-
0BEDS
-
0.45ACRES
-
0BATHS
-
01/2 BATHS
-
2,858SQFT
-
$437$/SQFT
School Ratings & Info
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. Also being sold separately, please see MLS #1418877 and #1418880.
© 2026 State-Wide Multiple Listing Service. All rights reserved. The data relating to real estate for sale or lease on this web site comes in part from the Internet Data Exchange (IDX) program of the State-Wide MLS. Real estate listings held by brokerage firms other than Onshore Realtors are marked with the MLS logo or an abbreviated logo and detailed information about them includes the name of the listing broker. Information is deemed reliable but is not guaranteed accurate by the MLS or Onshore Realtors. 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. Data last updated: 2026-08-16T17:37:55.78.