Fully renovated side-by-side duplex offering modern coastal living and strong rental income potential. Ideally located just off Aquidneck Ave and less than 2.5 miles to First and Second Beach, this turnkey property is perfect for owner-occupants or investors in one of Aquidneck Island’s most desirable areas. Each townhouse-style unit features 2 bedrooms, 1.5 baths, open-concept living, and contemporary finishes, including luxury vinyl plank flooring, granite countertops, and stainless steel appliances. Additional features include electric fireplaces, Mitsubishi heat pump systems with central air/heat & in-unit laundry. Private bluestone patios extend the living space outdoors. Exterior upgrades enhance curb appeal with white cedar shingle siding, board-and-batten details, a custom bluestone walkway, updated gutters/soffits, and new landscapingwith arborvitae for privacy. Set on a 15,000+ sq ft lot with parking for 6–8 vehicles. Minutes to downtown Newport, beaches, shops, restaurants, marinas, golf, and Naval Station Newport. Ideal for primary residence, long-term rental, seasonal rental (where permitted), or multi-generational living. Truly move-in ready.
For sale
Price cut: $50K (11/6)
$1,099,000
476 Green End Ave, Middletown, RI 02842
4beds
2,196sqft
Est.:
Multi Family
Built in 1974
-- sqft lot
$1,073,200 Zestimate®
$500/sqft
$-- HOA
What's special
Townhouse-style unitModern coastal livingCustom bluestone walkwayIn-unit laundryNew landscapingElectric fireplacesGranite countertops
- 127 days |
- 701 |
- 22 |
Zillow last checked: 8 hours ago
Listing updated: November 22, 2025 at 10:02pm
Listed by:
The RR&A Team 617-796-6084,
Coldwell Banker Realty,
Bethany Eddy 401-580-8014,
Coldwell Banker Realty
Source: StateWide MLS RI,MLS#: 1391050
Tour with a local agent
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 4
- Full bathrooms: 2
- 1/2 bathrooms: 2
Heating
- Electric, Forced Air, Heat Pump, Zoned
Cooling
- Central Air
Appliances
- Included: Electric Water Heater, Dryer, Oven/Range, Refrigerator, Washer
- Laundry: In Unit
Features
- Plumbing (Mixed), Insulation (Unknown)
- Flooring: Vinyl
- Basement: None
- Number of fireplaces: 2
Interior area
- Total structure area: 2,196
- Total interior livable area: 2,196 sqft
Video & virtual tour
Property
Parking
- Total spaces: 6
- Parking features: No Garage
Features
- Stories: 2
Lot
- Size: 0.35 Acres
Details
- Parcel number: MIDDM0114B00L516
Construction
Type & style
- Home type: MultiFamily
- Property subtype: Multi Family
- Attached to another structure: Yes
Materials
- Other Siding, Shingles
- Foundation: Slab
Condition
- New construction: No
- Year built: 1974
Utilities & green energy
- Electric: Circuit Breakers
- Water: Well
- Utilities for property: Sewer Connected
Community & HOA
HOA
- Has HOA: No
Location
- Region: Middletown
Financial & listing details
- Price per square foot: $500/sqft
- Tax assessed value: $824,600
- Annual tax amount: $9,285
- Date on market: 8/6/2025
- Total actual rent: 0
- Tenant pays: Heat
Estimated market value
$1,073,200
$1.02M - $1.13M
$2,684/mo
Price history
Price history
| Date | Event | Price |
|---|---|---|
| 11/6/2025 | Price change | $1,099,000-4.4%$500/sqft |
Source: | ||
| 9/24/2025 | Price change | $1,149,000-4.2%$523/sqft |
Source: | ||
| 9/5/2025 | Price change | $1,199,000-4.1%$546/sqft |
Source: | ||
| 8/6/2025 | Listed for sale | $1,250,000$569/sqft |
Source: | ||
| 7/8/2025 | Listing removed | $1,250,000$569/sqft |
Source: | ||
Public tax history
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | $9,285 | $824,600 |
| 2024 | $9,285 +122.8% | $824,600 +137.8% |
| 2023 | $4,167 | $346,700 |
Find assessor info on the county website
BuyAbility℠ payment
Est. payment
$5,380/mo
Principal & interest
$4262
Property taxes
$733
Home insurance
$385
Climate risks
Neighborhood: 02842
Nearby schools
GreatSchools rating
- 6/10Aquidneck SchoolGrades: PK-3Distance: 0.8 mi
- 8/10Joseph H. Gaudet SchoolGrades: 6-8Distance: 0.8 mi
- 5/10Middletown High SchoolGrades: 9-12Distance: 0.7 mi
- Loading
- Loading






