For Sale
    • For Sale
    • For Lease
    • Recently Sold
    • Property Lookup
    • Brokers
    Back to Search
    Waterfront Duplex with Expansion Potential Title is generated by Realmo AI

    38 Aquidneck Avenue, Portsmouth, RI 02871

    View on Map
    Claim this Listing
    New
    For Sale
    $1,300,000

    MULTI_FAMILY - Portsmouth, RI

    Type:Apartment
    Lot size:
    0.11 Acres
    Added:
    May 6, 2026
    Days on Market:
    3
    Last Refresh:
    May 8 at 8:06 pm

    Property Features for 38 Aquidneck Avenue

    General Information

    Property type
    Residential Multi Family
    Property subtype
    Apartment
    Zoning
    R20
    Bedrooms
    4
    Bathrooms
    2
    Rooms
    Bathroom 2, Bedroom 1, Bathroom 1, Bedroom 4, Bedroom 2, Basement, Bedroom 3
    Parking
    3
    Parking features
    Garage
    Interior features
    Wall (Dry Wall), Wall (Plaster), Attic, Attic Stairs, Stairs, Plumbing (Mixed), Insulation (Ceiling), Insulation (Floors), Insulation (Unknown), Insulation (Walls)
    Exterior features
    Balcony
    Appliances
    Tankless Water Heater, Dishwasher, Oven/Range, Refrigerator
    Standard status
    Active
    Lot size
    0.11 Acres

    Taxes and HOA fees

    Tax Year
    2025
    Tax Annual Amount
    12647

    Utilities

    Sewer type
    Septic Tank
    Heating system
    Baseboard, Oil
    Water source
    Public
    Water front features
    Waterfront
    Water front
    1

    Building Details

    Year built
    1919
    Floors in Building
    2
    Number of units
    2
    Flooring type
    Vinyl, Hardwood, Tile - Ceramic, Laminate
    Building materials
    Dry Wall, Plaster, Vinyl Siding

    We can help!

    Listing Contact
    Lisa Davis
    Lisa Davis

    Listing agent Lisa Davis

    Listing office Keller Williams Coastal 501 Centerville Rd- Suite 201, Middletown, RI

    Listing date May 6, 2026

    MLS# 1411598 Listing URL

    Copyright © 2026 State Wide MLS of Rhode Island, Inc. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.

    HighLights

    • Rare waterfront property with unobstructed Sakonnet River views and potential for a private dock.
    • Flexible property suitable for a multigenerational home, investment property, or custom waterfront residence.
    • Located on a desirable street with elegant waterfront homes, close to restaurants, polo matches, and a short drive to Newport.
    • Features a newer 4‑bedroom septic system and low‑maintenance vinyl siding.
    • Framed walk‑up attic with potential for expansion and access to a third‑floor balcony with panoramic river views.
    • Currently configured as a two‑family property with below‑market rents and leases expiring 5/31/26, transitioning to month‑to‑month.

    Overview

    This waterfront property, currently configured as a two-family investment, offers unobstructed views of the Sakonnet River. It features a newer 4-bedroom septic system and low-maintenance siding. The property presents the potential for a dock. Inside, a framed walk-up attic offers possibilities for expansion, leading to a third-floor deck or balcony with panoramic river views. The property is located on a street with waterfront residences, offering proximity to restaurants and a short drive to Newport. The property is zoned R20 and sits on a lot of 0.1108 acres. The property is suitable for a multi-generational retreat, an income-producing investment, or a custom waterfront home. The current leases expire on 5/31/26, after which tenants will be on a month-to-month basis.
    Property Profile Insight Report Location Intelligence

    Current Use by Public Records

    Duplexes

    Suggested Use

    Real Estate Agency Restaurant Law Firm Spa & Massage Center Dental Office Hair Salon Nail Salon Building Supply Auto Repair Shop Pharmacy

    Zoning and permitted uses should be independently verified with local authorities.

    Location Insight

    • Map
    • Local Demand
    City
    Portsmouth
    County
    Newport
    State
    Rhode Island
    Longitude
    -71.240703
    Latitude
    41.618823

    FAQs

    What type of property is this?
    Duplex - Rare waterfront duplex with expansion potential and stunning river views.
    Where is this duplex located?
    The property is located at 38 Aquidneck Avenue Portsmouth, RI.
    What is the asking price?
    The asking price for this property is $1,300,000.
    What are key features of this property?
    This property features: Rare waterfront property with unobstructed Sakonnet River views and potential for a private dock.; Flexible property suitable for a multigenerational home, investment property, or custom waterfront residence.; Located on a desirable street with elegant waterfront homes, close to restaurants, polo matches, and a short drive to Newport.
    More about this property
    Thanks! Your message was sent.
    Error! Your message wasn't sent.
    Please enter your name
    Please enter email
    Please enter the email in the correct format
    Please enter phone
    Please enter the number in the correct format
    Please enter message