Welcome to 590 Turner Road a two-unit duplex set back on a private 0.62-acre lot in Middletown. With four bedrooms, two full baths, and about 1,680 square feet of living space, the property works equally well as a cash-flowing rental or an owner-occupant duplex. Hardwood floors, a partial unfinished basement, and off-street parking are already in place. The setting is quiet and residential, yet close to Newport, beaches, local schools, and everyday shopping. What sets this listing apart is the work already done on the next improvement. The seller commissioned a licensed engineer and an architect and has now completed site plans and architectural drawings for a 3-car garage. The package includes the survey, engineered site plan, and architectural drawings; renderings can be provided upon request. A buyer can review the plans immediately rather than spending months and thousands of dollars to find out whether a garage will fit.This is a practical Aquidneck Island property with income in place and a defined value-add already designed.
Set on a quiet cul-de-sac in a highly convenient Middletown location, 29 Sherwood Road offers a versatile two-family opportunity ideal for investors, multigenerational living, or an owner-occupied arrangement with supplemental rental income. Each well-maintained unit features two bedrooms, one full bathroom, comfortable living spaces, and off-street parking. The property is located just minutes from Easton's Beach, downtown Newport, local restaurants, shopping, schools, and everyday amenities, with convenient access to the Newport Naval Station and destinations throughout Aquidneck Island. Whether used for year-round rentals, seasonal housing, or a combination of personal and income-producing use, this property offers flexibility in an area with strong rental demand. Enjoy easy access to the shoreline, Newport's celebrated dining and entertainment, and the relaxed coastal lifestyle that makes Middletown such a desirable place to live and invest.
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.
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.