$980,000
About this home
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.
Property details
- MLS #
- 1424285
- Property type
- Multi Family
- Subdivision
- Green End / Turner
- Status
- Active
- Days on market
- N/A
- On market date
- September 24, 2026
- Stories
- 1
- Total bathrooms
- 2
- Garage spaces
- N/A
- Parking spaces
- 4
- Lot size
- 0.62 acres
Location
Get directions →Nearby schools
Within 10 miles · public school directory data (NCES)
- Enrollment
- 317
- Student:teacher ratio
- 13.2:1
- District
- Middletown
- Enrollment
- 463
- Student:teacher ratio
- 11.3:1
- District
- Middletown
- Enrollment
- 620
- Student:teacher ratio
- 11.9:1
- District
- Middletown
Walkability
Blended score for Middletown's center: EPA's National Walkability Index (street network, transit, land-use mix) combined with nearby-amenity density. 60% EPA National Walkability Index + 40% nearby-amenity density (Google Places).
Market position
How this listing compares to current activity in Middletown, from live MLS data.
Mortgage calculator
Estimate only - actual rate and payment depend on your lender, credit, and loan program.
Adjust tax / insurance estimates
Similar homes you might like
Data source: Listing information provided by Rhode Island Association of REALTORS via Trestle/CoreLogic. Last updated 23 hr ago.
Information herein deemed reliable but not guaranteed; all measurements, school assignments, HOA fees, taxes, and feature lists are approximate and should be independently verified. Equal Housing Opportunity.