One-of-a-kind pied-a terre overlooking Narragansett Bay and the signature 18th golf hole of The Aquidneck Club. Fully furnished and equipped for immediate occupancy. Great rental history club members and their guests. Located in the stunning Clubhouse with access to fine and casual dining, indoor and outdoor bar/grill, inground swimming pool, fitness center and spa. Club membership includes access to the championship Link-style golf course (golf membership only) tennis and marina opportunities. Social or golf membership is required for ownership. Sale is subject to the club's long-term ground lease. Please note association fee is quarterly and includes property taxes, insurance, electric, heat (gas), water, sewer, security, general maintenance and repairs and concierge. The Seller has a contractual interest in this property but is not the legal owner.
For sale
$495,000
275 Depot Ave, Portsmouth, RI 02871
1beds
550sqft
:
Get pre-qualified$4,042/mo
Condominium
Built in 2003
-- sqft lot
$493,400 Zestimate®
$900/sqft
$761/mo HOA
What's special
Inground swimming poolOverlooking narragansett bay
- 9 days |
- 717 |
- 22 |
Likely to sell faster than
Zillow last checked:
Listing updated:
Listed by:
Stacie Mills 401-862-2793,
Vanderbilt International Prop.
Source: StateWide MLS RI,MLS#: 1417976
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 1
- Bathrooms: 1
- Full bathrooms: 1
Primary bedroom
- Level: Second
Dining area
- Level: First
Kitchen
- Level: First
Living room
- Level: First
Heating
- Natural Gas, Forced Air, Gas Connected, Zoned
Cooling
- Central Air
Appliances
- Included: Dishwasher, Microwave, Refrigerator
- Laundry: In Building
Features
- Wall (Plaster), Cathedral Ceiling(s), Stairs, Plumbing (Mixed), Insulation (Ceiling), Insulation (Floors), Insulation (Walls)
- Flooring: Hardwood, Other
- Basement: None
- Number of fireplaces: 1
- Fireplace features: Gas, Stone
Interior area
- Total structure area: 550
- Total interior livable area: 550 sqft
- Finished area above ground: 550
- Finished area below ground: 0
Property
Parking
- Total spaces: 1
- Parking features: No Garage, Assigned
Features
- Stories: 2
- Entry location: Elevator,Second Floor Access
- Patio & porch: Porch
- Pool features: In Ground
- Has view: Yes
- View description: Water
- Has water view: Yes
- Water view: Water
- Waterfront features: Waterfront, Access, Walk to Salt Water, Walk To Water
Lot
- Features: Close to Clubhouse, Secluded, Security, Sprinklers, Tennis
Details
- Zoning: RES
- Other equipment: Cable TV
Construction
Type & style
- Home type: Condo
- Property subtype: Condominium
Materials
- Plaster, Shingles, Wood
- Foundation: Concrete Perimeter
Condition
- New construction: No
- Year built: 2003
Utilities & green energy
- Electric: 200+ Amp Service
- Sewer: In Fee, Private Sewer
- Water: In Fee, Municipal
- Utilities for property: Water Connected
Community & HOA
Community
- Features: Golf, Highway Access, Hospital, Marina, Private School, Public School, Railroad, Recreational Facilities, Restaurants, Schools, Near Shopping, Near Swimming, Tennis, Business Center, Concierge, On-Site Maintenance, Restaurant, Sauna, Tennis Court(s)
- Subdivision: The Aquidneck Club
HOA
- Has HOA: No
- HOA fee: $2,283 quarterly
Location
- Region: Portsmouth
Financial & listing details
- Price per square foot: $900/sqft
- Date on market: 7/16/2026
Estimated market value
$493,400
$469,000 - $518,000
$2,242/mo
Price history
| Date | Event | Price |
|---|---|---|
| 7/16/2026 | Listed for sale | $495,000+17.6%$900/sqft |
Source:  StateWide MLS RI #1417976 Report a problem | ||
| 1/10/2022 | Sold | $420,923-1%$765/sqft |
Source: StateWide MLS RI #1256772 Report a problem | ||
| 12/13/2021 | Pending sale | $425,000$773/sqft |
Source: StateWide MLS RI #1256772 Report a problem | ||
| 11/1/2021 | Contingent | $425,000$773/sqft |
Source: StateWide MLS RI #1256772 Report a problem | ||
| 7/30/2020 | Price change | $425,000-14.1%$773/sqft |
Source: Vanderbilt International Prop. #1256772 Report a problem | ||
| 6/19/2020 | Listed for sale | $495,000$900/sqft |
Source: Vanderbilt International Prop. #1256772 Report a problem | ||
Public tax history
Tax history is unavailable.
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
Nearby schools
GreatSchools rating
- 10/10Howard Hathaway SchoolGrades: K-4Distance: 1.5 mi
- 8/10Portsmouth Middle SchoolGrades: 5-8Distance: 3.8 mi
- 9/10Portsmouth High SchoolGrades: 9-12Distance: 1.1 mi
- $971,8003 bd3 ba1.4k sqft125 Corys #AMERICA3, Portsmouth, RI 02871Off Market
- $915,6002 bd3 ba2.5k sqft225 Depot Ave APT 2, Portsmouth, RI 02871Off Market
- $804,3002 bd3 ba2.1k sqft225 Depot Ave APT 4, Portsmouth, RI 02871Off Market
- $3,367,4003 bd5 ba5.2k sqft120 Carnegie Harbor Dr, Portsmouth, RI 02871Off Market
- $3,586,2005 bd8 ba7.9k sqft106 Carnegie Harbor Dr, Portsmouth, RI 02871Off Market
- $4,796,7004 bd4 ba6.3k sqft150 Carnegie Harbor Dr, Portsmouth, RI 02871Off Market
- $4,997,8006 bd9 ba6.3k sqft99 Carnegie Harbor Dr, Portsmouth, RI 02871Off Market
- $6,383,8005 bd6 ba5.8k sqft162 Carnegie Harbor Dr, Portsmouth, RI 02871Off Market
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.
Similar homes
- $495,0002 bd1 ba784 sqft65 King Phillip St, Portsmouth, RI 02871For Sale
MLS ID #1415036, Bill Sizeland, Lila Delman Compass. StateWide MLS RI - $699,0002 bd1 ba748 sqft15 N Water St, Portsmouth, RI 02871For Sale By Owner
- $649,9002 bd1 ba780 sqft345 Riverside St, Portsmouth, RI 02871For Sale
MLS ID #1417225, Robert Jackvony, Coldwell Banker Realty. StateWide MLS RI - $499,0001 bd1 ba665 sqftOcean Manor, Newport, RI 02840For Sale
MLS ID #1398503, Belinda Nattress, Keller Williams Coastal. StateWide MLS RI - $405,0001 bd1 ba792 sqft381 Wood St, Bristol, RI 02809For SaleMLS ID #1418153, Benjamin Modica, Revolv Real Estate. StateWide MLS RI
- $520,0002 bd1 ba808 sqft1500 Crandall Rd, Tiverton, RI 02878For SaleMLS ID #1416057, Kelly Lewis, Kelly Lewis Realty. StateWide MLS RI
- $449,9002 bd1 ba820 sqft51 Priscilla Ave, Warwick, RI 02889For SaleMLS ID #1417272, Shaun Branch, Greco Real Estate. StateWide MLS RI
- $699,0002 bd1 ba763 sqft67 Cedar Ave, Portsmouth, RI 02871For SaleMLS ID #1414381, Paige Kane, Warner Realty Group. StateWide MLS RI
- $389,9002 bd1 ba708 sqftOceans Way, Newport, RI 02840For SaleMLS ID #1417863, Lee Caouette, RI Real Estate Services. StateWide MLS RI
- $475,0002 bd1 ba740 sqft50 Plum Point Rd, Saunderstown, RI 02874For SaleMLS ID #1417367, Heather Cawley, RE/MAX Profnl. Newport, Inc.. StateWide MLS RI
- $439,9001 bd1 ba786 sqftThe Court At Rope Walk Hill, East Greenwich, RI 02818For SaleMLS ID #1418806, Melissa Perdikakis, Weichert REALTORS-Atlantic Prp. StateWide MLS RI
- $469,9001 bd1 ba750 sqft11 N Shore St, Warwick, RI 02889For SaleMLS ID #1416656, Dan Saffer, PVD Properties. StateWide MLS RI
- $499,9001 bd1 ba756 sqftThe Court At Rope Walk Hill, East Greenwich, RI 02818New ConstructionMLS ID #1416570, Melissa Perdikakis, Weichert REALTORS-Atlantic Prp. StateWide MLS RI
- $425,0002 bd1 ba818 sqftBush-Updike House, Providence, RI 02903For SaleMLS ID #1418386, Amy Doorley-Lucas, Mott & Chace Sotheby's Intl.. StateWide MLS RI
- $249,9002 bd1 ba784 sqftRemington Village Pond, West Warwick, RI 02893For SaleMLS ID #1418367, Victoria Calabro, JPAR Prime Real Estate. StateWide MLS RI
- $339,9002 bd1 ba680 sqft68 Uncas St, Warwick, RI 02889For SaleMLS ID #1418505, Matt Mandeville, eXp Realty LLC. StateWide MLS RI
- $499,9002 bd1 ba784 sqft135 Namquid Dr, Warwick, RI 02888For SaleMLS ID #1411576, Cynthia Carlson, Regal Realty. StateWide MLS RI
- $424,9002 bd1 ba750 sqft22 3rd St, Westport, MA 02790For SaleMLS ID #11883335, Rachel Sanville, Your Home Sold Guaranteed Realty, The Nathan Clark Team. My State MLS
- $279,9001 bd1 ba688 sqftNarragansett Village Condominiums, Warwick, RI 02888For SaleMLS ID #1412120, Barry Rafanelli, Williams & Stuart Real Estate. StateWide MLS RI
- $449,9001 bd1 ba760 sqftThe Court At Rope Walk Hill, East Greenwich, RI 02818New ConstructionMLS ID #1415242, Melissa Perdikakis, Weichert REALTORS-Atlantic Prp. StateWide MLS RI
