5 Beds, 5 Baths, 3,600 sq ft
465 Union St
Portsmouth, RI 02871
Check Back Soon for Upcoming Availability
| Beds | Baths | Average SF |
|---|---|---|
| 4 Bedrooms 4 Bedrooms 4 Br | 6.1 Baths 6.1 Baths 6.1 Ba | 5,580 SF |
Fees and Policies
The fees listed below are community-provided and may exclude utilities or add-ons. All payments are made directly to the property and are non-refundable unless otherwise specified.
About This Property
Welcome to Shamrock Farm, a fully restored New England Farm located just a short commute to the Naval Base and Coast Guard Station Newport. The main level has a dramatic entry area with radiant heated floors, cozy living room with fireplace, t.v. room, chef’s kitchen& open space for dining. The second & third levels are home to four plus bedrooms, several sitting areas & a large second living room with gas fireplace which looks out onto the compound’s diverse grounds including sitting areas, a koi pond, lawns & more. Each bedroom has an en-suite bathroom and plentiful storage. Enjoy these grounds without having to lift a finger as all landscaping & snow removal are taken care of by the property owner. This residence was formerly a popular bed & breakfast, and attention to detail was paramount in the restoration & renovation of this building including high efficiency windows, excellent insulation and quality of craftsmanship throughout. Ideally situated to get everywhere on the island, Shamrock Farm is located in southern Portsmouth close to Green Valley Country Club (adjacent to the property), Portsmouth’s Sandy Point & McCorrie Beaches & Middletown’s Sachuest Beach, polo grounds for summer entertainment, athletic fields, Portsmouth schools & so much more. Just short drive to downtown Newport’s restaurant & shopping scene as well as a quick trip over any of Aquidneck Island’s three bridges, this home could not be any more centrally located.
465 Union St is a house located in Newport County and the 02871 ZIP Code. This area is served by the Portsmouth School District attendance zone.
House Features
Dishwasher
Hardwood Floors
Microwave
Refrigerator
- Security System
- Fireplace
- Dishwasher
- Microwave
- Range
- Refrigerator
- Hardwood Floors
- Attic
- Views
- Pool
- Balcony
- Patio
Portsmouth sits on the northern end of Aquidneck Island in Newport County, sharing that landmass with Middletown and the well-known city of Newport to the south. As the second-oldest municipality in Rhode Island, it carries genuine historical weight — the town was one of four original settlements that formed the Colony of Rhode Island and Providence Plantations in the 17th century. Today it operates as a quiet, coastal community spread across roughly 39 square miles of land, with Narragansett Bay defining much of its character and geography.
Life here moves at a measured pace. Residents have easy access to the energy of Newport without being absorbed by it, and Providence sits within about 30 miles to the northwest. The housing mix reflects the town's suburban scale — single-family homes dominate, but apartment communities and smaller multi-unit rentals provide options for those seeking lower-maintenance living.
Learn more about living in Portsmouth- Security System
- Fireplace
- Dishwasher
- Microwave
- Range
- Refrigerator
- Hardwood Floors
- Attic
- Views
- Balcony
- Patio
- Pool
| Colleges & Universities | Distance | ||
|---|---|---|---|
| Colleges & Universities | Distance | ||
| Drive: | 11 min | 4.7 mi | |
| Drive: | 15 min | 8.1 mi | |
| Drive: | 18 min | 8.5 mi | |
| Drive: | 31 min | 16.4 mi |
The GreatSchools Rating helps parents compare schools within a state based on a variety of school quality indicators and provides a helpful picture of how effectively each school serves all of its students. Ratings are on a scale of 1 (below average) to 10 (above average) and can include test scores, college readiness, academic progress, advanced courses, equity, discipline and attendance data. We also advise parents to visit schools, consider other information on school performance and programs, and consider family needs as part of the school selection process.
View GreatSchools Rating Methodology
Data provided by GreatSchools.org © 2026. All rights reserved.
You May Also Like
Similar Rentals Nearby
-
$6,800Total Monthly PriceTotal Monthly Price NewPrices include all required monthly fees.9 Month LeaseHouse for Rent
-
4 Beds, 2 Baths, 1,600 sq ft$4,600Total Monthly Price9 Month LeaseTotal Monthly Price NewPrices include all required monthly fees.4 Webster St
-
4 Beds, 2 Baths, 1,800 sq ft$5,250Total Monthly Price6 Month LeaseTotal Monthly Price NewPrices include all required monthly fees.29 Lion St
-
-
-
-
-
-
-
6 Beds, 4 Baths, 3,785 sq ft$25,000Total Monthly PriceTotal Monthly Price NewPrices include all required monthly fees.21 Bedlow Ave
What Are Walk Score®, Transit Score®, and Bike Score® Ratings?
Walk Score® measures the walkability of any address. Transit Score® measures access to public transit. Bike Score® measures the bikeability of any address.
What is a Sound Score Rating?
A Sound Score Rating aggregates noise caused by vehicle traffic, airplane traffic and local sources.