Refine Search
Sort by
$590,000
5 Beds 2 Baths
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.

28 Ludlow Road, Middletown

Listing courtesy of First Resort, LLC. Contact:

$1,249,000
5 Beds 4 Baths
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.

247 West Main Road 249, Middletown

Listing courtesy of William Raveis Inspire. Contact:

$499,000
2 Beds 2 Baths
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.

249 West Main Road 251, Middletown

Listing courtesy of William Raveis Inspire. Contact:

$8,295,000
4 Beds 6 Baths
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.

515 Indian Avenue, Middletown

Listing courtesy of Mott & Chace Sotheby's Intl.. Contact:

$1,800,000
7 Beds 6 Baths
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.

4 James Street, Middletown

Listing courtesy of Teri Degnan RE & Consulting. Contact:

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. © 2026 State-Wide Multiple Listing Service. All rights reserved. Data Last Updated: