LKV Realty
Logo
$1,249,000
$6,000Reward *
247 West Main Road 249, Middletown, RI 02842Listing ID 1418571

247 West Main Road 249, Middletown, RI 02842

Active
Two Mile Corner
Time on site: 17 daysLast updated: 1 day ago
Property Type
Property Type
Residential Income
Property Sub Type
Property Sub Type
Multi Family
Bedrooms
Bedrooms
5
Bathrooms
Bathrooms
4
Square Feet
Square Feet
2,858
Acres
Acres
0.44
Days on Site
Days on Site
16
Cooling
Cooling
None
Heating
Heating
Hot Water, Oil
Year Built
Year Built
1945
Garages
Garages
2
Parking
Parking
Detached, Garage

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.

Property Information

Property Details

Location

Address
247 West Main Road 249
County
Newport
City
Middletown
Zip Code
02842
Subdivision
Two Mile Corner

Interior Features

Beds and Baths

Bedrooms
5
Full Bathrooms
4

Building

Building Information

Square Feet
2,858
Year Built
1945
Construction
Drywall, Brick, Masonry, Wood Siding
Foundation
Concrete Perimeter

Property Taxes

Tax Annual Amount
$10,178
Tax Year
2025
William Raveis Inspire, (401) 846-3800

Market Report for 02842

* The market data shown is based on available information from Multiple Listing Service (MLS) and/or public records. Data provided is for informational and educational purposes only and may not represent the full housing market. For more accurate information, consumers should consult a certified appraiser or licensed real estate agent.

*Average of $2,150 in rewards is calculated based on the purchase or sale of a home between $400,000 to $449,000. The median home price for all housing types is in the United States is $405,400 as of 2025 as reported by the National Association of Realtors® (NAR). The actual reward amount may vary depending on the purchase or sales price of the home. Please see the Lakeview Home Rewards program terms and conditions for more details. The National Association of Realtors® is a registered trademark of the National Association of Realtors®.

Source: State-Wide MLS, Inc
State-Wide MLS, Inc logo

IDX information is provided exclusively for consumers’ personal, non-commercial use and maynot be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information is deemed reliable but is not guaranteed.© 2026 State-Wide Multiple Listing Service. All rights reserved.

For corrections to this data please contact Brytecore MLS Support.

3015 • 10866