- Overview
- Description
- Property Details
- Location
- Facts & Features
- Getting Around
- Nearby Homes





Street View
$5,750,000
Monthly Est:$28,620
6 Beds
- 6 Baths
5 full baths + 1 half bath
5,968sqft
474 Wapping Rd, Portsmouth, RI 02871
$5,750,000
$28,620/moEst:
Get Pre-Approved
Single Family Residence
Built in 2006
$-- HOA
11.63 acres lot
$963/sq.ft
Description
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.
- Houzeo last checked: 7 minutes ago
- Listing updated: August 26, 2026 at 5:51 pm
- Listing Provided by: The Willett Team (401) 835-8810 | SERHANT. (401) 382-0600
- Source: RI StateWide MLS-RI | MLS#: 1416464

Property Details
Status
Active Under Contract
Type
Single Family Residence
No. of Stories
3
County
City
Neighborhood
--
Year Built
2006
HOA Fees
-
Finished Area
5,968 sqft
Lot Size
11.63 acres lot
Basement Area
- sqft
MLS Name
RI StateWide MLS
MLS Number
1416464
MLS Status
ActiveUnderContract
Days on Market
105

Continue Your Journey in App
Find your dream home, receive real-time updates, and many more!
Download App
Continue Your Journey in App
Find your dream home, receive real-time updates, and many more!
Location
Facts & Features
Rooms
Bedrooms & bathrooms
Bedrooms: 6
Bathrooms: 6
Interior
Sewer
Septic Tank
Interior Features
Bathtub, Cathedral Ceilings, High Ceilings, Interior Steps, Stall Shower, Tub Shower, Vaulted Ceilings, Central Vacuum
Cooling
Central Air, Ductless
Flooring
Ceramic Tile, Hardwood, Marble
Heating
Forced Air, Gas, Hot Water, Zoned
Exterior Features
Balcony, Deck, Porch
Appliances
Dryer, Dishwasher, Exhaust Fan, Disposal, Gas Water Heater, Microwave, Oven, Range, Refrigerator, Washer
Construction
Year Built
Year Built: 2006
Home type
Single Family Residence
Architectural Style
Cabin
Foundation Details
Concrete Perimeter
Construction Materials
Drywall, Masonry, Shingle Siding, Wood Siding
Utilities & Energy
Water Source
Connected
Basement
Full, Interior Entry, Unfinished
Utilities
Underground Utilities
Security Features
Security System Owned
Electric
Amps200or More
Fireplace Features
Stone
Parking Features
Attached, Garage
Other Features
Subdivision Name
Farmlands
Lot Features
Private, Secluded
Patio And Porch Features
Balcony, Deck, Porch
Community Features
Golf, Near Schools, Pool
Price History
| Date | Event | Price |
|---|---|---|
08/26/2026 Source: | Contingent (Active Under Contract) | $5,750,000 $963/sqft |
06/27/2026 Source: | Listed for Sale | $5,750,000 +191566.67% $963/sqft |
11/06/2023 Source: | Listing Removed | $3,000 -99.85% $1/sqft |
09/17/2020 Source: | Price Decreased | $2,012,750 -12.11% $337/sqft |
05/29/2020 Source: | Sold | $2,290,000 -8.40% $384/sqft |
Show more
Nearby Homes
Find Homes by Property Features in Portsmouth, RI
Nearby New Homes For Sale
Based on information from State-Wide MLS through Oct 10, 2026, 07:15PM. Information is provided exclusively for consumers’ personal, non-commercial use. It may not be used for any purpose other than to identify prospective properties that consumers may be interested in purchasing. Data is deemed reliable but is not guaranteed accurate by the MLS. This website may not include listings or property addresses of sellers who have directed their listing brokers to withhold their listing or their property address from display on the Internet. © 2026 State-Wide MLS, Inc. All rights reserved.
Advertising Broker: Derek Greene | The Greene Realty Group
