247 W Main Rd Middletown, RI 02842

Price
$1,249,000
Listed On
Type
For Sale
Status
Active
247 W Main Rd, Middletown, RI 02842
247 W Main Rd, Middletown, RI 02842
247 W Main Rd, Middletown, RI 02842
247 W Main Rd, Middletown, RI 02842
247 W Main Rd, Middletown, RI 02842
247 W Main Rd, Middletown, RI 02842
247 W Main Rd, Middletown, RI 02842
247 W Main Rd, Middletown, RI 02842
247 W Main Rd, Middletown, RI 02842
247 W Main Rd, Middletown, RI 02842
247 W Main Rd, Middletown, RI 02842
247 W Main Rd, Middletown, RI 02842
247 W Main Rd, Middletown, RI 02842
247 W Main Rd, Middletown, RI 02842
247 W Main Rd, Middletown, RI 02842
247 W Main Rd, Middletown, RI 02842
247 W Main Rd, Middletown, RI 02842
247 W Main Rd, Middletown, RI 02842
247 W Main Rd, Middletown, RI 02842
247 W Main Rd, Middletown, RI 02842
247 W Main Rd, Middletown, RI 02842
247 W Main Rd, Middletown, RI 02842
247 W Main Rd, Middletown, RI 02842
247 W Main Rd, Middletown, RI 02842
247 W Main Rd, Middletown, RI 02842
247 W Main Rd, Middletown, RI 02842
247 W Main Rd, Middletown, RI 02842
247 W Main Rd, Middletown, RI 02842
247 W Main Rd, Middletown, RI 02842
247 W Main Rd, Middletown, RI 02842
247 W Main Rd, Middletown, RI 02842
247 W Main Rd, Middletown, RI 02842
247 W Main Rd, Middletown, RI 02842
247 W Main Rd, Middletown, RI 02842
247 W Main Rd, Middletown, RI 02842
247 W Main Rd, Middletown, RI 02842
247 W Main Rd, Middletown, RI 02842
5 Beds
4 Bath
2858 sqft
Asking  $1,249,000

Snapshot

Type
For Sale
Category
Purchase
Property Type
Residential Multi Family
Property Subtype
Other
MLS Number
1418571
Parcel Number
Property Sqft
2,858 sqft
Lot Size
0.44 acres
Year Built
1945
Year Updated
Bedrooms
5
Bathrooms
4
Full Bathrooms
4
3/4 Bathrooms
0
Half Bathrooms
0
Quarter Bathrooms
0
Lot Size (in sqft)
19,166.4
Price Low
-
Room Count
10
Building Unit Count
3
Condo Floor Number
-
Number of Buildings
-
Number of Floors
1
Parking Spaces
14
Subdivision Name
Two Mile Corner
Franchise Affiliation
None
Special Listing Conditions
Auction
Auction
Bankruptcy Property
Bankruptcy Property
HUD Owned
HUD Owned
In Foreclosure
In Foreclosure
Notice Of Default
Notice Of Default
Probate Listing
Probate Listing
Real Estate Owned
Real Estate Owned
Short Sale
Short Sale
Third Party Approval
Third Party Approval

Description

Rare Multi-Property Investment Opportunity! Exceptional offering of 247 and 249-251 West Main Road featuring two contiguous properties with outstanding income and investment potential in the heart of Middletown. Whether you're looking to expand your investment portfolio, generate rental income, or occupy one residence while leasing the others, this unique property offers exceptional flexibility. Ideal for year-round rentals, furnished seasonal rentals, or short-term vacation rentals where permitted by local regulations. The prime location, just minutes from Newport, area beaches, shopping, restaurants, marinas, and Naval Station Newport, provides strong rental demand throughout the year. The property also presents an excellent opportunity for a primary residence with supplemental income or future redevelopment potential, subject to municipal approvals. Rarely do three adjacent properties become available as a single offering, creating possibilities for investors, developers, and owner-occupants alike. A truly unique opportunity to own a versatile income-producing property on Aquidneck Island with exceptional long-term appreciation potential. This single-family property is set back from road with a delightful private yard and mature shrubbery. The spacious 2 car garage and plenty of parking add exceptional value. House and duplex are also being listed separately, please see MLS #s 1418769 and 1418643.

Open House Showings

Start TimeEnd TimeAppointment Required?
No

More Details

MLS Name
State Wide MLS of Rhode Island, Inc.
Source
ListHub
MLS Number
1418571
MLS ID
SWMLSRI
Virtual Tour
PARTICIPANT
Name
Jeanne Allen
Primary Phone
(401) 864-2752
Key
3YD-SWMLSRI-3015
Email
jeanne.allen@raveis.com
BROKER
Name
William Raveis
Phone
(401) 207-3329
OFFICE
Name
William Raveis Inspire
Phone
(401) 846-3800
Copyright © 2026 State Wide MLS of Rhode Island, Inc. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.

Features

Basement
Basement
Dock
Dock
Elevator
Elevator
Fireplace
Fireplace
Greenhouse
Greenhouse
Hot Tub Spa
Hot Tub Spa
New Construction
New Construction
Pool
Pool
Sauna
Sauna
Sports Court
Sports Court
Waterfront
Waterfront
Appliances
Electric Water Heater
Electric Water Heater
Dishwasher
Dishwasher
Oven/Range
Oven/Range
Refrigerator
Refrigerator
Washer
Washer
Construction Materials
Dry Wall
Dry Wall
 Brick
Brick
 Masonry
Masonry
 Wood
Wood
Exterior
Deck
Deck
Screened Pch/Patio/Dck/Brzwy
Screened Pch/Patio/Dck/Brzwy
Flooring
Tile - Ceramic
Tile - Ceramic
Marble
Marble
Carpet
Carpet
Hardwood
Hardwood
Vinyl
Vinyl
Heating
Oil
Oil
Interior
Wall (Dry Wall)
Wall (Dry Wall)
Attic
Attic
Plumbing (Mixed)
Plumbing (Mixed)
Insulation (Floors)
Insulation (Floors)
Insulation (Unknown)
Insulation (Unknown)
Insulation (Walls)
Insulation (Walls)
Patio and Porch
Deck
Deck
Patio
Patio
Rooms
Bathroom 1
Bathroom 1
Bedroom 3
Bedroom 3
Basement
Basement
Bathroom 2
Bathroom 2
Bedroom 2
Bedroom 2
Bathroom 4
Bathroom 4
Bedroom 1
Bedroom 1
Bedroom 5
Bedroom 5
Bathroom 3
Bathroom 3
Bedroom 4
Bedroom 4
Utilities
Water Available
Water Available
Window
Storm Window(s)
Storm Window(s)

History

DateEventPrice$/SqftSource
Listed For Sale
MultiFamily
$1,249,000$437William Raveis Inspire
Report issue with price history

Taxes

YearAnnual AmountDescription
2025$10,178

Nearby Schools

High School

Middletown High School

0.6 miles away09 - 12

Elementary School

John F. Kennedy School

0.8 miles awayKG - 04

Middle School

Joseph H. Gaudet School

1 miles away05 - 08
Show more
Get more info on 247 W Main Rd, Middletown, RI 02842
Profile
Jeanne Allen
Listing Agent
(401) 864-2752
By pressing request info, you agree that Residential and real estate professionals may contact you via phone/text about your inquiry, which may involve the use of automated means.
Profile
Jeanne Allen
Listing Agent
(401) 864-2752
By pressing request info, you agree that Residential and real estate professionals may contact you via phone/text about your inquiry, which may involve the use of automated means.