Prime Investment Opportunity – Three Single-Family Homes on One Lot in Middletown, RI! Nestled just minutes from Newport and the beautiful beaches, this unique property offers three single-family homes on one lot, providing endless possibilities and grand fathered short term rental permits! Currently utilized as summer Airbnb rentals and winter leases with strong income on the back two houses, this versatile setup is ideal for a variety of uses—whether you're looking for an income-producing property, a family compound, or an owner-occupied residence with additional rental income. Each home boasts its own charm, offering comfortable living spaces, amenities, and plenty of privacy. The front house was built in 2020 with upscale finishes (which has not been rented). Great opportunity in a vibrant neighborhood.
Sold for $2,100,000 on 02/03/25
$2,100,000
17-21 Warren Ave, Middletown, RI 02842
8beds
3,700sqft
Multi Family
Built in 1970
-- sqft lot
$-- Zestimate®
$568/sqft
$4,917 Estimated rent
Home value
Not available
Estimated sales range
Not available
$4,917/mo
Zestimate® history
Loading...
Owner options
Explore your selling options
What's special
Zillow last checked: 8 hours ago
Listing updated: February 03, 2025 at 06:56am
Listed by:
The Hadfield Group 401-965-1927,
Hogan Associates Christie's
Bought with:
Hillary Olinger, RES.0040619
Hogan Associates Christie's
Source: StateWide MLS RI,MLS#: 1374680
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 8
- Bathrooms: 6
- Full bathrooms: 6
Bathroom
- Features: Bath w Shower Stall, Bath w Tub & Shower
Heating
- Electric, Natural Gas, Forced Water, Heat Pump
Cooling
- Heat Pump
Appliances
- Included: Gas Water Heater, Dishwasher, Dryer, Range Hood, Microwave, Oven/Range, Refrigerator, Washer
- Laundry: In Unit
Features
- Wall (Cermaic), Wall (Dry Wall), Stairs, Insulation (Ceiling), Insulation (Floors), Insulation (Walls), Ceiling Fan(s)
- Flooring: Ceramic Tile, Hardwood
- Basement: Full,Interior and Exterior,Unfinished
- Number of fireplaces: 3
Interior area
- Total structure area: 3,700
- Total interior livable area: 3,700 sqft
Property
Parking
- Total spaces: 10
- Parking features: No Garage
Features
- Stories: 2
- Patio & porch: Patio, Porch
- Waterfront features: Walk to Salt Water
Lot
- Size: 9,583 sqft
Details
- Parcel number: MIDDM0115BSEL170
- Zoning: r-10
- Special conditions: Conventional/Market Value
Construction
Type & style
- Home type: MultiFamily
- Property subtype: Multi Family
Materials
- Ceramic, Dry Wall, Shingles, Vinyl Siding, Wood
- Foundation: Concrete Perimeter
Condition
- New construction: No
- Year built: 1970
Utilities & green energy
- Electric: 150 Amp Service
- Sewer: Public Sewer
- Water: Municipal, Public
Community & neighborhood
Community
- Community features: Golf, Hospital, Marina, Private School, Public School, Recreational Facilities, Restaurants, Schools, Near Shopping, Near Swimming, Tennis
Location
- Region: Middletown
- Subdivision: Easton's Point Beaches
HOA & financial
Other financial information
- Total actual rent: 0
Price history
| Date | Event | Price |
|---|---|---|
| 2/3/2025 | Sold | $2,100,000$568/sqft |
Source:  StateWide MLS RI #1374680 | ||
| 12/28/2024 | Pending sale | $2,100,000$568/sqft |
Source: StateWide MLS RI #1374680 | ||
| 12/16/2024 | Listed for sale | $2,100,000+324.2%$568/sqft |
Source: StateWide MLS RI #1374680 | ||
| 4/13/2010 | Sold | $495,000+167.6%$134/sqft |
Source: Public Record | ||
| 7/30/1998 | Sold | $185,000$50/sqft |
Source: Public Record | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | $15,913 | $1,413,200 |
| 2024 | $15,913 +49% | $1,413,200 +59% |
| 2023 | $10,682 | $888,700 |
Find assessor info on the county website
Neighborhood: 02842
Nearby schools
GreatSchools rating
- 6/10Aquidneck SchoolGrades: PK-3Distance: 0.4 mi
- 8/10Joseph H. Gaudet SchoolGrades: 6-8Distance: 1.9 mi
- 5/10Middletown High SchoolGrades: 9-12Distance: 1.8 mi