Skip main navigation
Sold
  • $5,400,000

    474 Wapping Rd, Portsmouth, RI 02871

    6beds
    5,968sqft
    Single Family Residence
    Built in 2006
    11.63 Acres Lot
    $-- Zestimate®
    $905/sqft
    $7,691 Estimated rent

    Home value

    Not available

    Estimated sales range

    Not available

    $7,691/mo

    Zestimate® history
    Loading
    Loading...

    Owner options

    List your home for rent

    $7,691/mo

    Rent Zestimate®

    Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.

    Learn more

    $7,691/mo

    Rent Zestimate®

    Refinance and save

    $26,204/mo

    Est. payment

    Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.

    See today's rates

    $26,204/mo

    Est. payment

    Explore your selling options

    Work with a Zillow partner agent

    Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.

    Get started

    List with your own agent

    Get your home in front of millions of buyers by listing it on Zillow.

    Learn how to do it

    Sell it yourself

    Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).

    List your home

    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.

    Zillow last checked:

    Listing updated:

    Listed by:

    The Willett Team 401-835-8810,

    SERHANT.

    Bought with:

    The Willett Team

    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: Dishwasher, Dryer, Exhaust Fan, Disposal, Microwave, Refrigerator, Washer, Gas Water Heater
    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
    Details
    • Additional structures: Guest House, Barn(s), Outbuilding
    • Parcel number: PORTM065B0003
    • Special conditions: Conventional/Market Value
    • 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: $905/sqft
    • Tax assessed value: $2,671,600
    • Annual tax amount: $49,505
    • Date on market: 6/27/2026

    Price history

    DateEventPrice
    10/30/2026Sold$5,400,000-6.1%$905/sqft
    Source: StateWide MLS RI #1416464 Report a problem
    10/21/2026Pending sale$5,750,000$963/sqft
    Source: StateWide MLS RI #1416464 Report a problem
    8/26/2026Contingent$5,750,000$963/sqft
    Source: StateWide MLS RI #1416464 Report a problem
    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/2010Listed for sale$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

    Neighborhood: 02871

    Nearby schools

    GreatSchools rating