Skip main navigation
For sale
    • $5,750,000

    474 Wapping Rd, Portsmouth, RI 02871

    6beds
    5,968sqft
    : 
    $38,391/mo
    Get pre-qualified
    Single Family Residence
    Built in 2006
    11.63 Acres Lot
    $-- Zestimate®
    $963/sqft
    $-- HOA

    What's special

    Tranquil water viewsLarge private gymEntertainment roomSurrounded by rolling pastures
    Set behind the gates of one of South Portsmouth's most exclusive private communities, this extraordinary 11.6-acre estate offers a rare opportunity to own a true New England compound where privacy, natural beauty, and exceptional amenities come together in perfect harmony. Surrounded by rolling pastures, tranquil water views, and acres of protected open space, this custom-built residence embodies the peaceful coastal lifestyle that makes this corner of Aquidneck Island so coveted. Designed for both grand entertaining and everyday living, the property includes a beautifully crafted four-bedroom main residence with office, den and entertainment room, a separate two-bedroom guest house ideal for extended family or visitors, an expansive barn with horse stables and paddocks, a large private gym, and multiple outbuildings offering endless possibilities for collectors, artisans, equestrians, boating enthusiasts, or those seeking exceptional workshop or studio space. Farmlands is an intimate 64-acre gated community where residents enjoy an unmatched sense of serenity just minutes from Newport's renowned waterfront, championship golf, marinas, beaches, and fine dining. Whether envisioned as a private family retreat, an equestrian estate, or a legacy property to be enjoyed for generations, opportunities of this caliber and setting are exceptionally rare. This property is ICONIC.
    42 days
    |
    1,475
    |
    76
    |

    Zillow last checked:

    Listing updated:

    Listed by:

    The Willett Team 401-835-8810,

    SERHANT.

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

      Facts & features

      Interior

      Bedrooms & bathrooms
      • Bedrooms: 6
      • Bathrooms: 6
      • Full bathrooms: 5
      • 1/2 bathrooms: 1
      Bathroom
      • Features: Bath w Tub, Bath w Shower Stall
      Heating
      • Natural Gas, Forced Air, Forced Water, Zoned
      Cooling
      • Central Air
      Appliances
      • Included: Gas Water Heater, Dishwasher, Dryer, Exhaust Fan, Disposal, Microwave, Oven/Range, Refrigerator, Washer
      Features
      • Wall (Cermaic), Wall (Dry Wall), Wall (Wood), Cathedral Ceiling(s), Stairs, Plumbing (Copper), Plumbing (PVC), Insulation (Ceiling), Insulation (Floors), Insulation (Walls), Central Vacuum
      • Flooring: Ceramic Tile, Hardwood, Marble
      • Basement: Full,Interior Entry,Unfinished
      • Number of fireplaces: 2
      • Fireplace features: Stone, Wood Burning
      Interior area
      • Total structure area: 5,968
      • Total interior livable area: 5,968 sqft
      • Finished area above ground: 5,968
      • Finished area below ground: 0

      Property

      Parking
      • Total spaces: 12
      • Parking features: Attached
      • Attached garage spaces: 2
      Features
      • Patio & porch: Deck, Porch
      • Exterior features: Balcony
      • Fencing: Fenced
      • Has view: Yes
      • View description: Water
      • Has water view: Yes
      • Water view: Water
      Lot
      • Size: 11.63 Acres
      • Features: Horse Permitted, Secluded
      Details
      • Additional structures: Guest House, Barn(s), Outbuilding
      • Parcel number: PORTM065B0003
      • Horses can be raised: Yes

      Construction

      Type & style
      • Home type: SingleFamily
      • Architectural style: Cottage
      • Property subtype: Single Family Residence
      Materials
      • Ceramic, Dry Wall, Wood Wall(s), Masonry, Shingles, Wood
      • Foundation: Concrete Perimeter
      Condition
      • New construction: No
      • Year built: 2006

      Utilities & green energy

      • Electric: 200+ Amp Service
      • Sewer: Septic Tank
      • Utilities for property: Water Connected, Underground Utilities

      Community & HOA

      Community
      • Features: Golf, Private School, Near Swimming
      • Security: Security System Owned
      • Subdivision: Farmlands
      HOA
      • Has HOA: No
      Location
      • Region: Portsmouth

      Financial & listing details

      • Price per square foot: $963/sqft
      • Tax assessed value: $2,671,600
      • Annual tax amount: $49,505
      • Date on market: 6/27/2026

        Estimated market value

        Not available

        Estimated sales range

        Not available

        $6,657/mo

        Price history

        DateEventPrice
        6/27/2026Listed for sale$5,750,000+185.7%$963/sqft
        Source: StateWide MLS RI #1416464 Report a problem
        9/17/2020Sold$2,012,750-12.1%$337/sqft
        Source: StateWide MLS RI #1246554 Report a problem
        5/29/2020Price change$2,290,000-7.5%$384/sqft
        Source: Gustave White Sotheby's Realty #1246554 Report a problem
        2/5/2020Listed for sale$2,475,000-1%$415/sqft
        Source: Gustave White Sotheby's Realty #1246554 Report a problem
        8/11/2019Listing removed$2,500,000$419/sqft
        Source: Lila Delman Real Estate #1199380 Report a problem
        8/10/2018Listed for sale$2,500,000-7.4%$419/sqft
        Source: Lila Delman Real Estate #1199380 Report a problem
        9/11/2013Listing removed$2,700,000$452/sqft
        Source: Lila Delman Real Estate, Ltd. #1025491 Report a problem
        9/12/2012Listed for sale$2,700,000-15.6%$452/sqft
        Source: Lila Delman Real Estate, Ltd. #1025491 Report a problem
        12/4/2010Listing removed$3,200,000$536/sqft
        Source: Prudential Real Estate #950566 Report a problem
        9/11/2010Price change$3,200,000-7.9%$536/sqft
        Source: Prudential Real Estate #950566 Report a problem
        10/3/2009Listed for sale$3,475,000$582/sqft
        Source: Prudential Real Estate #950563 Report a problem

        Public tax history

        YearProperty taxesTax assessment
        2025$35,479 +0.8%$2,671,600
        2024$35,212 -5.4%$2,671,600 +11.6%
        2023$37,238 $2,393,200
        2022$37,238 +1.6%$2,393,200
        2021$36,640 +25.3%$2,393,200
        2020$29,235 -3.7%$2,393,200 +1.2%
        2019$30,361 -19.6%$2,364,400
        2018$37,759 +3.6%$2,364,400
        2017$36,459 +12.3%$2,364,400 +16.6%
        2016$32,454 +1.3%$2,028,400
        2015$32,049 $2,028,400
        2014$32,049 +11.8%$2,028,400 +2.8%
        2013$28,666 +2%$1,972,900
        2012$28,094 +2.4%$1,972,900
        2011$27,443 +2.4%$1,972,900 -16.8%
        2010$26,790 +0.4%$2,370,800
        2009$26,695 +3.9%$2,370,800
        2008$25,699 +33.8%$2,370,800 +40.5%
        2007$19,203 +100.1%$1,687,400 +89%
        2006$9,598 +5.1%$892,800 +1.2%
        2005$9,131 -8.6%$882,200 +43.1%
        2004$9,989 -1.6%$616,600
        2003$10,149 $616,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

        5 / 100
        Car-Dependent
        23 / 100
        Somewhat Bikeable

        Nearby schools

        GreatSchools rating

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

        Browse local experts

        Similar homes

              Nearby cities

              Nearby zip codes

              Other Portsmouth Topics

                Search
                Updates
                Favorites
                Plan
                Inbox