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
    For Sale
    $1,099,000

    MULTI_FAMILY - Portsmouth, RI

    Type:Apartment
    Property size:
    4,552 SF
    Lot size:
    0.11 Acres
    Price / SF:
    $241/SF
    Added:
    May 6, 2026
    Days on Market:
    53
    Last Refresh:
    Jun 27 at 4: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 3, Bathroom 1, Bedroom 1, Bedroom 2, Bedroom 4, Basement
    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
    Basement
    Storage Space, Full, Unfinished
    Appliances
    Tankless Water Heater, Dishwasher, Oven/Range, Refrigerator
    Standard status
    Active
    Size
    4,552 SF
    Lot size
    0.11 Acres

    Taxes and HOA fees

    Tax Year
    2025
    Tax Annual Amount
    12647

    Utilities

    Sewer type
    Septic Tank
    Heating system
    Oil, Baseboard
    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
    Tile - Ceramic, Vinyl, Hardwood, Laminate
    Building materials
    Dry Wall, Plaster, Vinyl Siding

    We can help!

    Contact an agent
    Joy Gilkeson
    Joy Gilkeson

    Listing agent Joy Gilkeson

    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

    • Waterfront property overlooking the Sakonnet River with water views
    • Currently configured as a two‑family investment property
    • Year built: 1919
    • Public water with septic tank; newer 4‑bedroom septic system reported
    • Tankless water heater plus oil baseboard heating; insulated with ceiling, floor, and wall insulation
    • Framed walk‑up attic with stairs to a third floor that includes a deck/balcony; garage parking; balcony exterior feature

    Overview

    This waterfront property offers unobstructed views of the Sakonnet River. Currently configured as a two-family investment property, it features a newer 4-bedroom septic system and low-maintenance siding. A framed walk-up attic provides possibilities for expansion, potentially leading to a third-floor deck or balcony with panoramic river views. The property is set on a street with waterfront residences and offers proximity to restaurants and Newport's downtown area. The property is suitable for a multigenerational retreat, an income-producing investment, or a custom waterfront home. The lot size is 0.1108 acres, and the property size is 4552 square feet. The zoning is R20. Rents are below market values and leases expire 5/31/26, so tenants will be on a month-to-month basis.

    Local Financial Insights For Multifamily LT 5

    Simulate Cap Rate and NOI

    NOI Build-Up
    Vacancy
    income lost from leasable area expected to sit empty during the year — subtracted from gross rent.
    EGI (Effective Gross Income)
    gross rent minus vacancy losses — the realistic income before paying operating costs.
    OpEx (Operating Expenses)
    recurring costs to operate the property (property tax, insurance, utilities, maintenance, management) — excludes financing and capital improvements.
    NOI (Net Operating Income)
    income a property generates after operating costs but before financing and taxes.

    Component $ $/SF
    Gross rent $116.3k $25.56
    − Vacancy −$7.7k −$1.70
    EGI $108.6k $23.86
    − OpEx −$32.6k −$7.16
    NOI $76.0k $16.70
    4,552 SF · lease $25.56/SF/yr · vacancy 6.65% · expense 30.00%

    Alternative Uses

    Best Use
    Multifamily LT 5
    $1.09M
    $950.4K – $1.27M (±1% cap)
    NOI $76,028 @ 7.0% cap · market cap 6.92%
    Second Best
    Apartment 5plus
    $965.9K
    $845.2K – $1.13M (±1% cap)
    NOI $67,615 @ 7.0% cap · market cap 6.15%
    Theoretical Best
    —
    —
    same as Best Use
    Zoning and permitted uses should be independently verified with local authorities.
    Property Profile 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,099,000.
    What are key features of this property?
    This property features: Waterfront property overlooking the Sakonnet River with water views; Currently configured as a two‑family investment property; Year built: 1919
    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