Waterfront

275 depot avenue

Portsmouth, RI 02871

$495,000

1 BED 1 BATH
550 SQFT
Residential - Condominium
Waterfront
Image 1
Image 2
Image 3: Great Hall Entry of TAC Clubhouse
Image 4
Bedrooms 1
Total Baths 1
Full Baths 1
Square Feet 550
Status Active
MLS # 1417976
County Newport
More Info
Category Residential - Condominium
Status Active
Square Feet 550
MLS # 1417976
County Newport
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.

Exterior Features

  • Construction Condo
  • Siding Plaster, ShingleSiding, WoodSiding
  • Exterior Porch, SprinklerIrrigation, TennisCourts
  • Garage No
  • Garage Description Assigned, NoGarage
  • Water Connected, Public, WaterTapFee
  • Sewer Other, PrivateSewer
  • Lot Description Private, Secluded, SprinklerSystem, Waterfront

Interior Features

  • Appliances Dishwasher, Microwave, Refrigerator
  • Heating ForcedAir, Gas, Zoned
  • Cooling CentralAir
  • Basement None
  • Fireplaces 1
  • Fireplaces Description Gas, Stone
  • Living Area 550 SQFT
  • Year Built 2003

Neighborhood & Schools

  • Subdivision The Aquidneck Club

Financial Information

  • Parcel ID 275DEPOTAVReliancePORT
  • Zoning RES

Listing Information

Listing Provided Courtesy of Vanderbilt International Prop.
The data for this listing came from the Rhode Island MLS.
Listing data is current as of 09/03/2026.

Contact Our Agent

By clicking “Submit,” I agree to be contacted by Lake Homes Realty, LLC, its affiliates, and real estate professionals via call, text, and email for real estate services. This includes by automated means, even if your number is on a federal, state, or our internal Do Not Call list. To opt out, you can reply "stop" at any time or reply "help" for assistance. You can also click the unsubscribe link in the emails. Message and data rates may apply. Message frequency may vary. You also agree to our Terms of Use and Privacy Policy.