Skip To Content

247 West Main Road

Middletown, RI 02842
  • $1,249,000
  • STATUS: Active
  • ON SITE: 21 Days
  • MLS #: 1418856
UPDATED: 28 min ago
$1,249,000
  • 0
    BEDS
  • 0.45
    ACRES
  • 0
    BATHS
  • 0
    1/2 BATHS
  • 2,858
    SQFT
  • $437
    $/SQFT
Neighborhood:
Type:
Commercial
Built:
1945
County:
Area:

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.

Monthly Payment Calculator



[Rhode Island Statewide MLS] logo

© 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.
www.onshorerealtors.com/homes/179245121
Print Image

247 West Main Road Middletown, RI 02842

  • Price: $1,249,000
  • Status: Active
  • On Site: 21 Days
  • Updated: 28 min ago
  • MLS #: 1418856
0
Beds
0
Baths
0
½ Baths
0.45
Acres
2,858
SQFT
$437
$/SQFT
1945
Built
Neighborhood:
Two Mile Corner
County:
Newport
Area:
Middletown
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. Also being sold separately, please see MLS #1418877 and #1418880.
Exterior Features

Construction Materials Masonry Foundation Details Concrete Perimeter Garage YN Yes Levels One Parking Total 14

Interior Features

Basement Full Basement YN Yes Cooling None Cooling YN No Furnished Unfurnished Heating Hot Water Heating YN Yes

Property Features

Business Type Barber / Beauty Professional / Office Professional Service Real Estate Community Features Golf Highway Access Marina Near Hospital Near Schools Other Pool Public Transportation Recreation Area Restaurant Shopping See Remarks Tennis Court(s) Sidewalks Electric 100 Amp Service Separate Meters Human Modified YN No Inclusions Fireplace Land Lease YN No Laundry Features Common Area New Construction YN No Owner Pays Heat Hot Water Possible Use Mixed Use Office Other Residential Single Family Property Sub Type Commercial Road Surface Type None Paved Security Features Carbon Monoxide Detector(s) Smoke Detector(s) Sewer Connected Public Sewer Structure Type Apartment Tax Annual Amount 10178 Tax Assessed Value 863300 Tax Lot 283 Tax Year 2025 Tenant Pays Cable TV Electricity Utilities Cable Available Electricity Available Natural Gas Not Available Municipal Utilities Water Connected Sewer Available Sewer Connected Water Available Water Source Connected Public Zoning OBA

[Rhode Island Statewide MLS] logo Listing information © 2026 State-Wide Multiple Listing Service.
Listing provided courtesy of William Raveis Inspire: .



[Rhode Island Statewide MLS] logo

© 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.
 
https://bt-photos.global.ssl.fastly.net/rhodeisland/orig_boomver_1_1418856-2.jpg https://bt-photos.global.ssl.fastly.net/rhodeisland/orig_boomver_1_1418856-2.jpg https://bt-photos.global.ssl.fastly.net/rhodeisland/orig_boomver_1_1418856-2.jpg
Logo
Onshore Realtors
57 Shore Rd, Suite B
Westerly RI, 02891