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.
Under contract
$5,750,000
474 Wapping Rd, Portsmouth, RI 02871
6beds
5,968sqft
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
- 100 days
- 370
- 13
Likely to sell faster than
Zillow last checked:
Listing updated:
Listed by:
The Willett Team 401-835-8810,
SERHANT.
Source: StateWide MLS RI,MLS#: 1416464
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
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
$8,327/mo
Price history
| Date | Event | Price |
|---|---|---|
| 8/26/2026 | Contingent | $5,750,000$963/sqft |
Source:  StateWide MLS RI #1416464 Report a problem | ||
| 6/27/2026 | Listed for sale | $5,750,000+185.7%$963/sqft |
Source: StateWide MLS RI #1416464 Report a problem | ||
| 9/17/2020 | Sold | $2,012,750-12.1%$337/sqft |
Source: StateWide MLS RI #1246554 Report a problem | ||
| 5/29/2020 | Price change | $2,290,000-7.5%$384/sqft |
Source: Gustave White Sotheby's Realty #1246554 Report a problem | ||
| 2/5/2020 | Listed for sale | $2,475,000-1%$415/sqft |
Source: Gustave White Sotheby's Realty #1246554 Report a problem | ||
| 8/11/2019 | Listing removed | $2,500,000$419/sqft |
Source: Lila Delman Real Estate #1199380 Report a problem | ||
| 8/10/2018 | Listed for sale | $2,500,000-7.4%$419/sqft |
Source: Lila Delman Real Estate #1199380 Report a problem | ||
| 9/11/2013 | Listing removed | $2,700,000$452/sqft |
Source: Lila Delman Real Estate, Ltd. #1025491 Report a problem | ||
| 9/12/2012 | Listed for sale | $2,700,000-15.6%$452/sqft |
Source: Lila Delman Real Estate, Ltd. #1025491 Report a problem | ||
| 12/4/2010 | Listing removed | $3,200,000$536/sqft |
Source: Prudential Real Estate #950566 Report a problem | ||
| 9/11/2010 | Listed for sale | $3,200,000-7.9%$536/sqft |
Source: Prudential Real Estate #950566 Report a problem | ||
| 10/3/2009 | Listed for sale | $3,475,000$582/sqft |
Source: Prudential Real Estate #950563 Report a problem | ||
Public tax history
| Year | Property taxes | Tax 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.Climate risks
Neighborhood: 02871
Similar homes
- $5,950,0004 bd6 ba6.5k sqft105 Heidi Dr, Portsmouth, RI 02871For Sale
MLS ID #1424513, Christine Tellefsen, Residential Properties Ltd.. StateWide MLS RI - $6,300,0005 bd8 ba7.2k sqft231 Carnegie Harbor Dr, Portsmouth, RI 02871For Sale
MLS ID #1424943, Joseph Costa, Mott & Chace Sotheby's Intl.. StateWide MLS RI - $5,795,0004 bd6 ba7.3k sqft125 Heidi Dr, Portsmouth, RI 02871For Sale
MLS ID #1422034, RoseMarie Clemente, Baron & Clemente Real Estate. StateWide MLS RI - $3,750,0005 bd6 ba6.5k sqft99 Meadowlark Ln, Portsmouth, RI 02871For Sale
MLS ID #1410616, The Hadfield Group, Hogan Associates Christie's. StateWide MLS RI - $4,000,0003 bd6 ba4.8k sqft464 Black Point Ln, Portsmouth, RI 02871For SaleMLS ID #1420461, Alyce Wright, Lila Delman Compass. StateWide MLS RI
- $2,950,0007 bd5 ba6k sqft176 Heidi Dr, Portsmouth, RI 02871For SaleMLS ID #1420579, Kylie McCollough, Mott & Chace Sotheby's Intl.. StateWide MLS RI
- $5,995,0004 bd6 ba5.2k sqft1 Harbor View Dr, Newport, RI 02840For SaleMLS ID #1423476, The Willett Team, SERHANT.. StateWide MLS RI
- $4,995,0004 bd5 ba4.3k sqft517 Tuckerman Ave, Middletown, RI 02842For SaleMLS ID #1423679, Jessica Chase, Gustave White Sotheby's Realty. StateWide MLS RI
- $4,295,0004 bd4 ba5k sqft149 Nanaquaket Rd, Tiverton, RI 02878For SaleMLS ID #1422761, Jessica Chase, Gustave White Sotheby's Realty. StateWide MLS RI
- $3,500,0004 bd4 ba6.5k sqft683 Neck Rd, Tiverton, RI 02878For SaleMLS ID #1423410, James Holland, T. L. Holland Agency. StateWide MLS RI
- $5,800,0005 bd6 ba4.1k sqft190 Ferry Rd, Saunderstown, RI 02874For SaleMLS ID #1419105, Stephanie Basile, SERHANT.. StateWide MLS RI
- $4,999,0004 bd4 ba4.7k sqft10 Ridge Rd, Newport, RI 02840For SaleMLS ID #1415572, Jennifer O'Hora Lawrence, Lila Delman Compass. StateWide MLS RI
- $4,950,0005 bd6 ba4.8k sqft76 Battery Ln, Jamestown, RI 02835For SaleMLS ID #1409358, Lisa Ardente, Compass. StateWide MLS RI
- $6,500,0004 bd5 ba4.5k sqft315 Ocean Ave, Newport, RI 02840For SaleMLS ID #1406341, Tina Wiley, Gustave White Sotheby's Realty. StateWide MLS RI
- $4,650,0005 bd6 ba6.1k sqft29 Reliance Dr, Bristol, RI 02809For SaleMLS ID #1412380, Lynda Terhune, Mott & Chace Sotheby's Intl.. StateWide MLS RI
- $3,195,0005 bd8 ba7.1k sqft165 Poppasquash Rd, Bristol, RI 02809For SaleMLS ID #1423825, Alexandra Thursby, Mott & Chace Sotheby's Intl.. StateWide MLS RI
- $5,000,0005 bd4 ba4.2k sqft250 Rumstick Rd, Barrington, RI 02806For SaleMLS ID #1421815, Stephanie Basile, SERHANT.. StateWide MLS RI
- $6,100,0005 bd5 ba3.4k sqft18 Ledge Rd, Newport, RI 02840For SaleMLS ID #1414589, Quentin Warren, Gustave White Sotheby's Realty. StateWide MLS RI
- $4,150,0003 bd3 ba6k sqft155 D W Main Rd, Little Compton, RI 02837For SaleMLS ID #1384754, Cherry Arnold, Mott & Chace Sotheby's Intl.. StateWide MLS RI
- $4,250,0007 bd8 ba6.2k sqft14 Kay Blvd, Middletown, RI 02842For SaleMLS ID #1422195, The Willett Team, SERHANT.. StateWide MLS RI
