Date
Details
Price
Change
Source
7/25/2026
Listed
$1,249,000
—
MLS
Disclaimer: Historical sales information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
1/36
$1,249,000 Just Listed
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
1/36
Property 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.
Full Property Details
Full Property Details for 247 W Main Rd
General
- Price: $1,249,000
- Taxes: $10,178 (2025)
- Status: Active
- Type: Multi-Family
- Source: STWMLS
- MLS ID: 1418571
- Updated: 7/25/2026
- Added to Site: 1 day(s) ago
Business
- Business Type: Other
Interior
- Number of Rooms: 10
- Interior Features: Attic, Stall Shower, Tub Shower, Cable TV
- Fireplace: Yes
- Number of Fireplaces: 2
- Fireplace(s): Masonry, Marble, Tile
- Appliances: Dishwasher, Electric Water Heater, Oven, Oil Water Heater, Range, Refrigerator, Washer
- Flooring: Carpet, Ceramic Tile, Hardwood, Marble, Vinyl
Rooms
Bathrooms
- Total Bathrooms: 4
- Full Bathrooms: 4
Bedrooms
- Total Bedrooms: 5
Other Rooms
- Laundry: Common Area
Additional Information
- Tennis: Yes
Exterior
- Exterior Features: Deck, Paved Driveway
- Porch/Patio/Deck: Deck, Porch, Screened
Parking
- Garage: Yes
- Garage Spaces: 2
- Covered Spaces: 2
- Total Spaces: 14
- Parking Features: Detached, Garage
Location
- County: Newport
- Subdivision: Two Mile Corner
- Near Highway: Yes
Heating & Cooling
- Cooling Type: None
- Heating Type: Hot Water, Oil
Utilities
- Sewer: Connected, Public Sewer
- Water: Connected, Public
- Utility Description: Sewer Available, Sewer Connected, Water Available
Structural Information
- # Buildings: 2
- Architectural Style: Side By Side
- Detached/Attached: Detached
- Construction: Drywall, Brick, Masonry, Wood Siding
- Basement: Yes
- Basement Desc.: Full, Interior Entry, Unfinished
- Windows: Storm Window(s)
- Doors: Storm Door(s)
- Stories/Levels: 1
- Building Size: 2858
- Finished Total: 2,858 Sq. Ft.
- Finished Above Grnd: 2,858 Sq. Ft.
- Year Built: 1945
Lot Features
- Lot Size (Acres): 0.44
- Lot Size (Sq. Ft.): 19,167
- Lot Size: 19167
- Sidewalks: Yes
Financial Considerations
- Tax Amount: $10,178
- Tax Year: 2025
- Owner Pays: Hot Water
Disclosures and Reports
- Inclusions: Seller's Lead Disclosure
- Property ID: 247249WESTMAINRDMDLT
- Block: NW
- Lot Number: 283
Listed by William Raveis Inspire
We Value Your Privacy
We Value Your Privacy
We Value Your Privacy
Listing agents
— 247 W Main Rd —
William Raveis Inspire
William Raveis Inspire
NMLS#: 1598647Get Pre-Approved Today
Schools
Schools serving 247 W Main Rd
School District:Middletown School District
| Name | Grades | Distance |
|---|---|---|
Joseph Gaudet Academy 1113 Aquidneck Avenue, Middletown, RI 02842 | 4- | 1.3 mi |
Aquidneck School 70 Reservoir Road, Middletown, RI 02842 | PK-3 | 1.5 mi |
Joseph H. Gaudet School 1113 Aquidneck Avenue, Middletown, RI 02842 | 5-8 | 1.3 mi |
Middletown High School 130 Valley Road, Middletown, RI 02842 | 9-12 | 0.9 mi |
Disclaimer:
School attendance boundaries provided by ATTOM Data Solutions and are for reference only. Contact the school directly to verify enrollment eligibility.
Price & Sales History for 247 W Main Rd
Tax History
Tax History for 247 W Main Rd
Year
Property Taxes
Change
Tax Assessment
Change
2025
$5,778
5%
$490,100
—
2024
$5,519
29%
$490,100
44%
2023
$4,278
5%
$339,800
—
2022
$4,084
10%
$339,800
—
2021
$3,708
—
$339,800
6%
2021
$3,708
-16%
$319,800
—
2018
$4,397
7%
$319,800
20%
2016
$4,106
3%
$266,300
—
2015
$4,005
-4%
$266,300
2%
2014
$4,177
2%
$259,900
—
2013
$4,083
—
$259,900
—
Disclaimer: Historical tax information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.
Estimate the Cost
Estimate the Cost for 247 W Main Rd
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
- Single Family
- Active
- Updated 3 days ago
- 5Beds
- 2Total Baths
- 2,335Sq. Ft.
- Single Family
- Active
- Updated 3 days ago
- 4Beds
- 3Total Baths
- 2,175Sq. Ft.
- Single Family
- Active
- Updated 18 hours ago
- 3Beds
- 2Total Baths
- 1,565Sq. Ft.
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
247 West Main Road, Middletown, RI 02842 (MLS# 1418571) is a Multi-Family property with 3 units containing 5 bedrooms and 4 full bathrooms. 247 West Main Road is currently listed for $1,249,000 and was received on July 25, 2026. Want to learn more about 247 West Main Road? Do you have questions about finding other Multi-Family real estate for sale in Middletown? You can browse all Middletown real estate or contact a Coldwell Banker agent to request more information.