Great opportunity for affordable property on Aquidneck Island. Side by Side 2 family. 3 bedroom in Unit B is just about move in ready. Fresh paint, wide pine floors, easy layout with open kitchen and laundry area. Private backyard area with storage shed and deck. Unit A is two bedroom and it is ready for your own ideas on the best way to show its potential. Endless possibilities to open it up to single family living, or live in one side and gain income from the other. Exterior is easy care vinyl siding and the roof is less than 10 years old. Both units have their own front gated yards and private spaces outside. Shared driveway for two cars total, or dedicate the parking to one of the units as street parking is easily accessible.
This is a rare opportunity to own a two unit property on the Middletown/Newport line. This side-by-side duplex offers two, 2 bedroom units, with off street parking on a quiet dead end street. This home is an opportunity for an investor or someone looking to buy on the Island and have some of your mortgage paid by a tenant, giving you the opportunity to have someone else building equity for you. Both units have had light updating in the past four years. Each unit features 4 rooms, full baths, and laundry in units. The property also features a large yard to enjoy outdoor activities and gatherings.
Calling all investors! Lots of potential in this 2-unit property. Excellent investment opportunity in the heart of Middletown! This side-by-side duplex features two one-bedroom, one-bath units, making it an ideal property for investors or owner-occupants seeking rental income. Each unit offers a functional layout with private entrances and comfortable living spaces. Perfectly situated on the Newport line, this property offers exceptional convenience to everyday amenities, including grocery stores, department stores, home d cor retailers, and a wide variety of popular restaurants. Just minutes from Newport's vibrant waterfront, historic attractions, and renowned beaches, residents can enjoy the best of Aquidneck Island living. Whether heading to Second Beach, Easton's Beach, downtown Newport, or nearby parks and recreation, everything is within easy reach. With its prime location, strong rental appeal, and proximity to shopping, dining, beaches, and all that Newport has to offer, this duplex presents an outstanding opportunity for both investment and owner. Property is also being sold as a package with 247 West Main, MLS # 1418571.
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.
WATERFRONT on INDIAN AVENUE. C ad M le F ilte, One Hundred Thousand Welcomes. An extraordinary waterfront compound located on the historic grounds of Stonybrook Estate. The property features a 4,609 square foot Manor House built in 1988, a historically significant 1,522 square foot Horace Trumbauer Gate House constructed in 1935, and a gunite pool with cabana overlooking the Sakonnet River. This gracious contemporary home was custom-designed with traditional elements including a steeply pitched slate roof, tall gables and half-timbering. Through the front door is a comfortable, open floor plan with stunning water views from nearly every room. The kitchen, living, dining and primary bedrooms all provide access to stone terraces around the pool and lush gardens with opportunities for a relaxing indoor-outdoor lifestyle. Enjoy expansive water views and meticulously landscaped grounds with specimen trees and an English Garden. This bucolic setting is on the rural and much-loved Indian Avenue, just 1.5 miles from beautiful Second and Third Beaches and 15 minutes to downtown Newport.
ATTENTION BUYERS - GREAT OPPORTUNITY TO PURCHASE A PROPERTY AS A FAMILY COMPOUND OR FOR AN INVESTMENT - Turnkey two-family home has been completely upgraded and sits on Easton's Point within walking distance to the beach! You'll find 8 bedrooms (2 are ensuite) and 6 bathrooms with everything updated - bathrooms, central A/C, two kitchens, floors, two laundry washers/dryers, with all furniture included in the sale. Other highlights include an attached garage, deck, private and flat backyard, and parking for at least 8 cars. Floor plans allow for flexibility of customizing the size of each rental unit or splitting the space to your configuration preference for personal use and a rental unit. A large unfinished basement provides tons of storage space which may allow the adding of a finished living space/rec room. The property maybe converted back to single-family use and is currently rented seasonally until May 2026. No bookings exist beyond May 2026. There is a current short term rental(SRT) registration and Airbnb summer rentals have been highly successful. Note: this listing is also shown as a single-family listing under MLS listing #1395808.

Middletown is located in Rhode Island. Middletown, Rhode Island has a population of 16,983. Middletown is less family-centric than the surrounding county with 24.25% of the households containing married families with children. The county average for households married with children is 27.01%.
The median household income in Middletown, Rhode Island is $88,211. The median household income for the surrounding county is $90,435 compared to the national median of $69,021. The median age of people living in Middletown is 44.8 years.
The average high temperature in July is 80 degrees, with an average low temperature in January of 22.9 degrees. The average rainfall is approximately 47.7 inches per year, with 30.7 inches of snow per year.