247 West Main Road, Middletown, RI 02842

• 5 beds |
• 4 baths |
• 2,858 sqft

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.

Listing Status:

Active

Date Added:

July 25, 2026

Data Last Updated:

July 30, 2026 at 11:15PM

Listing Office:

William Raveis Inspire : 401-846-3800

MLS ID:

1418571

Interior

• General: AtticStall ShowerTub ShowerCable TV
• Appliances: DishwasherElectric Water HeaterOvenOil Water HeaterRangeRefrigeratorWasher
• Laundry: Common Area
• Basement: FullInterior EntryUnfinished
• Flooring: CarpetCeramic TileHardwoodMarbleVinyl
• A/C: None
• Heating: Hot WaterOil
• Fireplace: MasonryMarbleTileFireplaceFireplaces: 2

Exterior

• General: DeckPaved Driveway
• Style: Side By Side
• Other Structures: PorchDeckScreened
• Parking: DetachedGarageParking spaces: 14

Construction

• Windows: Storm Window(s)
• General: DrywallBrickMasonryWood Siding1Concrete Perimeter

Location

• Originating MLS: RIS_RIS
• County: Newport

Lot

• Zoning: OBA247249WESTMAINRDMDLT

Utilities

• Utilities: Sewer AvailableSewer ConnectedWater Available100 Amp Service
• Water: ConnectedPublic
• Sewer: ConnectedPublic Sewer

Financial

• Source: RIS_RIS