Skip main navigation
For sale
    • Price cut: $201K (5/30)
    $1,099,000

    38 Aquidneck Ave, Portsmouth, RI 02871

    4beds
    2,010sqft
    : 
    $6,927/mo
    Get pre-qualified
    Single Family Residence
    Built in 1919
    4,826 Square Feet Lot
    $1,059,900 Zestimate®
    $547/sqft
    $-- HOA

    What's special

    Wake up to golden sunrises and refreshing sea breezes in this rare waterfront opportunity overlooking the Sakonnet River. Currently configured as a two-family investment property, the property offers sweeping, unobstructed water views, a newer 4-bedroom septic system, low maintenance siding. With potential for a dock just steps from your door, this is coastal living at its finest. Inside, a framed walk-up attic provides exciting possibilities for expansion and leads to a third-floor balcony with breathtaking panoramic river views. Whether you envision a multigenerational retreat, an income-producing investment, or a custom waterfront dream home, the flexibility here is unmatched. Set on a highly sought after street lined with elegant waterfront residences, this property blends charm, location and OPPORTUNITY. Enjoy close proximity to great restaurants, weekend polo matches, or take a short drive to Newport for its vibrant downtown and lively harbor front. Bring your vision and transform this unique property into the coastal sanctuary you've always dreamed of. Seller will consider private financing for qualified buyer.
    84 days
    |
    1,039
    |
    39
    |

    Zillow last checked:

    Listing updated:

    Listed by:

    Joy Gilkeson 401-525-1714,

    Keller Williams Coastal,

    Lisa Davis 401-418-2525,

    Keller Williams Coastal

    Source: StateWide MLS RI,MLS#: 1411595MLS Logo

      Facts & features

      Interior

      Bedrooms & bathrooms
      • Bedrooms: 4
      • Bathrooms: 2
      • Full bathrooms: 2
      Heating
      • Oil, Baseboard, Forced Water
      Cooling
      • None
      Appliances
      • Included: Tankless Water Heater, Dishwasher, Oven/Range, Refrigerator
      Features
      • Wall (Dry Wall), Wall (Plaster), Internal Expansion, Stairs, Plumbing (Mixed), Insulation (Ceiling), Insulation (Floors), Insulation (Unknown), Insulation (Walls), Ceiling Fan(s)
      • Flooring: Ceramic Tile, Hardwood, Vinyl
      • Basement: Full,Walk-Out Access,Unfinished,Laundry,Storage Space
      • Attic: Attic Stairs, Attic Storage
      • Has fireplace: No
      • Fireplace features: None
      Interior area
      • Total structure area: 2,010
      • Total interior livable area: 2,010 sqft
      • Finished area above ground: 2,010
      • Finished area below ground: 0
      Video & virtual tour

      Property

      Parking
      • Total spaces: 3
      • Parking features: No Garage, Driveway
      • Has uncovered spaces: Yes
      Features
      • Exterior features: Balcony
      • On waterfront: Yes
      • Waterfront features: Waterfront, Flood Insurance, Saltwater Front
      Lot
      • Size: 4,826 Square Feet
      Details
      • Foundation area: 720
      • Parcel number: PORTM024B0167
      • Zoning: R20

      Construction

      Type & style
      • Home type: SingleFamily
      • Property subtype: Single Family Residence
      Materials
      • Dry Wall, Plaster, Vinyl Siding
      • Foundation: Block, Slab
      Condition
      • New construction: No
      • Year built: 1919

      Utilities & green energy

      • Electric: Circuit Breakers, Common Meter, Individual Meter
      • Sewer: Septic Tank
      • Water: Municipal, Public
      • Utilities for property: Water Connected

      Community & HOA

      Community
      • Features: Golf, Highway Access, Marina, Schools, Near Shopping, Near Swimming
      • Subdivision: Portsmouth Park Waterfront
      HOA
      • Has HOA: No
      Location
      • Region: Portsmouth

      Financial & listing details

      • Price per square foot: $547/sqft
      • Tax assessed value: $708,700
      • Annual tax amount: $12,647
      • Date on market: 5/6/2026
      • Inclusions: Leases expire 5/31/26. Tenants will then be on a month-to-month basis. Rents currently below market value

        Estimated market value

        $1,059,900

        $1.01M - $1.11M

        $3,644/mo

        Price history

        DateEventPrice
        5/30/2026Price change$1,099,000-15.5%$547/sqft
        Source: MLS PIN #73513528 Report a problem
        5/28/2026Listed for sale$1,300,000$647/sqft
        Source: MLS PIN #73513528 Report a problem
        5/20/2026Contingent$1,300,000$647/sqft
        Source: StateWide MLS RI #1411595 Report a problem
        5/6/2026Listed for sale$1,300,000$647/sqft
        Source: StateWide MLS RI #1411595 Report a problem
        12/22/2025Listing removed$1,300,000$647/sqft
        Source: MLS PIN #73432479 Report a problem
        9/22/2025Price change$1,300,000-18.8%$647/sqft
        Source: MLS PIN #73432479 Report a problem
        9/18/2025Listed for sale$1,600,000+1500%$796/sqft
        Source: StateWide MLS RI #1395242 Report a problem
        8/30/2018Listing removed$1,300$1/sqft
        Source: East Shore Properties Report a problem
        8/7/2018Listed for rent$1,300$1/sqft
        Source: East Shore Properties Report a problem
        4/4/2016Sold$100,000-55.6%$50/sqft
        Source: Agent Provided Report a problem
        1/5/2016Price change$225,000-10%$112/sqft
        Source: BerkshireHathaway HomeServices #1110535 Report a problem
        11/19/2015Listed for sale$249,900$124/sqft
        Source: BerkshireHathaway HomeServices #1110535 Report a problem
        11/16/2015Pending sale$249,900$124/sqft
        Source: BerkshireHathaway HomeServices #1110535 Report a problem
        11/16/2015Price change$249,900-24.2%$124/sqft
        Source: BerkshireHathaway HomeServices #1110535 Report a problem
        10/17/2015Listed for sale$329,900$164/sqft
        Source: BerkshireHathaway HomeServices #1110535 Report a problem

        Public tax history

        YearProperty taxesTax assessment
        2025$9,412 +0.8%$708,700
        2024$9,341 +21%$708,700 +42.9%
        2023$7,718 $496,000
        2022$7,718 +1.6%$496,000
        2021$7,594 +1.6%$496,000
        2020$7,475 +10.4%$496,000 +20.1%
        2019$6,772 +2.7%$412,900
        2018$6,594 +3.6%$412,900
        2017$6,367 +7.9%$412,900 +12%
        2016$5,899 +1.3%$368,700
        2015$5,825 $368,700
        2014$5,825 -3.8%$368,700 -11.5%
        2013$6,055 +2%$416,700
        2012$5,934 +2.4%$416,700
        2011$5,796 +2%$416,700 -17.1%
        2010$5,682 +0.4%$502,800
        2009$5,662 +3.9%$502,800
        2008$5,450 -3.7%$502,800 +1.1%
        2007$5,660 +5.9%$497,400
        2006$5,347 +3.9%$497,400
        2005$5,148 +15.3%$497,400 +80.5%
        2004$4,465 -1.6%$275,600
        2003$4,536 $275,600
        Find assessor info on the county website

        Monthly payment

        Est. payment

        Payment breakdown

        Explore the cost of this home by adjusting the details. Changes won't be saved.
        All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
        HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
        Mortgage interest rates are dependent on a number of factors, including credit score, down payment, and repayment length. Interest rate data provided by Zillow Group Marketplace, Inc. as of 1/1/1970 from various mortgage lenders with which we have lead or other similar arrangements; the Estimated Payment is an average of those rates.
        See how much you could borrow to make a competitive offer.
        Get pre-qualified

        Climate risks

        Neighborhood: 02871

        Getting around

        32 / 100
        Car-Dependent
        33 / 100
        Somewhat Bikeable

        Nearby schools

        GreatSchools rating

        A local agent can set up tours, give advice and negotiate with sellers.

        A local lender can help you make sure your offer is ready when you are.

        Browse local experts

        Similar homes

              Nearby cities

              Nearby zip codes

              Other Portsmouth Topics

                Search
                Updates
                Favorites
                Plan
                Inbox