We found 0 results. View results

Overview

  • Updated On:
  • July 26, 2026
  • 4
  • Bathrooms
  • 10
  • Rooms
  • 5
  • Bedrooms
  • 0 ac
  • Property Lot Size

247 249 West Main Road, Middletown, Residential Income

$ 1,249,000
247 249 West Main Road, Middletown

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.

Property Id: 1193697
Price: $ 1,249,000
Property Lot Size: 0 ac
Rooms: 10
Bedrooms: 5
Bathrooms: 4
Accessibility Features: One Level
Basement: Full, Interior Only, Unfinished, Playroom, Storage Space, Work Shop
Bathrooms Full: 4
Building Area Total (sqft): 2858
Inclusions: Seller's Lead Disclosure
Community Features: Bus, Commuter Bus, Golf, Highway Access, Hospital, Interstate, Marina, Private School, Public School, Railroad, Recreational Facilities, Restaurants, Schools, Shopping, Near Swimming, Tennis
Construction Materials: Dry Wall, Brick, Masonry, Wood
Cooling: None
Other Equipment: Cable TV
Owner Pays: Hot Water, Heat
Parking Total: 14
Electric: 100 Amp Service
Fireplace Features: Brick, Marble, Tile
Fireplaces Total: 2
Flooring: Ceramic Tile, Hardwood, Marble, Vinyl, Carpet
Foundation Details: Concrete Perimeter
Garage Spaces: 2
Heating: Oil, Forced Water
Laundry Features: In Building, Off Site
MLS Listing #: 1418571
Living Area Source: Appraiser
Living Area Units: Square Feet
Lot Features: Paved Driveway, Sidewalks
Lot Size SQFT: 19167
MLS Status: Active
Number Of Units Total: 3
Parking Features: Detached
Bathroom Features: Bath w Shower Stall, Bath w Tub & Shower
Sewer: Available, Public Sewer
State: RI
Stories: 1
Street Additional Info: 249
Street Name: West Main
Street Number: 247
StreetNumberNumeric: 247
Street Suffix: Road
Structure Type: Side/Side
Annual Taxes: 10178
Utilities: Sewer Connected, Water Available, Water Connected
Water Source: Municipal
Window Features: Storm Window(s)
Year Built: 1945
Zoning: OBA

Address: 247 249 West Main Road
State/County:
Zip: 02842
Country: US

Other Features
Attic
Deck
Dishwasher
Electric Water Heater
Has Fireplace
Has Garage
Has Heating System
Insulation (Floors)
Insulation (Unknown)
Insulation (Walls)
Open Parking
Oven/Range
Plumbing (Mixed)
Property Attached
Refrigerator
Screened Pch/Patio/Dck/Brzwy
Wall (Dry Wall)
Washer

yelp logo

$ 7,392.31
per month
  • Principal and Interest
  • Property Tax
  • HOA fee
$ 5,831.06

Sun 26 Jul
Mon 27 Jul
Tue 28 Jul
Wed 29 Jul
Thu 30 Jul
Fri 31 Jul
Sat 01 Aug
Sun 02 Aug
Mon 03 Aug
Tue 04 Aug
In Person
Video Chat

Contact Me

Schedule a showing?

Similar Listings

Residential Income
Active
Residential Income
Active
Residential Income
Active
DISCLAIMER TEXT: 247 249 West Main Road | 1193697 : 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. © 2024 State-Wide Multiple Listing Service. All rights reserved.

Compare Listings