Skip main navigation
For sale
    • $1,249,000

    247-249 W Main Rd, Middletown, RI 02842

    5beds
    2,858sqft
    : 
    $7,920/mo
    Get pre-qualified
    Multi Family
    Built in 1945
    -- sqft lot
    $-- Zestimate®
    $437/sqft
    $-- HOA

    What's special

    Delightful private yardPlenty of parkingMature shrubbery
    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.
    2 days
    |
    318
    |
    10
    |

    Zillow last checked:

    Listing updated:

    Listed by:

    Jeanne Allen 401-864-2752,

    William Raveis Inspire,

    Arthur Chapman 401-640-0807,

    William Raveis Inspire

    Source: StateWide MLS RI,MLS#: 1418571MLS Logo

      Facts & features

      Interior

      Bedrooms & bathrooms
      • Bedrooms: 5
      • Bathrooms: 4
      • Full bathrooms: 4
      Bathroom
      • Features: Bath w Shower Stall, Bath w Tub & Shower
      Heating
      • Oil, Forced Water
      Cooling
      • None
      Appliances
      • Included: Electric Water Heater, Dishwasher, Oven/Range, Refrigerator, Washer
      • Laundry: In Building, Off Site
      Features
      • Wall (Dry Wall), Plumbing (Mixed), Insulation (Floors), Insulation (Unknown), Insulation (Walls)
      • Flooring: Ceramic Tile, Hardwood, Marble, Vinyl, Carpet
      • Doors: Storm Door(s)
      • Windows: Storm Window(s)
      • Basement: Full,Interior Entry,Unfinished,Playroom,Storage Space,Work Shop
      • Number of fireplaces: 2
      • Fireplace features: Brick, Marble, Tile
      Interior area
      • Total structure area: 2,858
      • Total interior livable area: 2,858 sqft

      Property

      Parking
      • Total spaces: 14
      • Parking features: Detached, Driveway
      • Garage spaces: 2
      • Has uncovered spaces: Yes
      Accessibility
      • Accessibility features: One Level
      Features
      • Stories: 1
      • Patio & porch: Deck, Screened
      Lot
      • Size: 0.44 Acres
      • Features: Sidewalks
      Details
      • Zoning: OBA
      • Other equipment: Cable TV

      Construction

      Type & style
      • Home type: MultiFamily
      • Property subtype: Multi Family
      • Attached to another structure: Yes
      Materials
      • Dry Wall, Brick, Masonry, Wood
      • Foundation: Concrete Perimeter
      Condition
      • New construction: No
      • Year built: 1945

      Utilities & green energy

      • Electric: 100 Amp Service
      • Sewer: Public Sewer
      • Water: Municipal
      • Utilities for property: Sewer Connected, Water Available, Water Connected, Sewer Available

      Community & HOA

      Community
      • Features: Near Public Transport, Commuter Bus, Golf, Highway Access, Hospital, Interstate, Marina, Private School, Public School, Railroad, Recreational Facilities, Restaurants, Schools, Near Shopping, Near Swimming, Tennis
      • Subdivision: Two Mile Corner
      HOA
      • Has HOA: No
      Location
      • Region: Middletown

      Financial & listing details

      • Price per square foot: $437/sqft
      • Annual tax amount: $10,178
      • Date on market: 7/26/2026
      • Inclusions: Seller's Lead Disclosure
      • Total actual rent: 0

        Estimated market value

        Not available

        Estimated sales range

        Not available

        Not available

        Price history

        DateEventPrice
        7/26/2026Listed for sale$1,249,000$437/sqft
        Source: StateWide MLS RI #1418571 Report a problem

        Public tax history

        Tax history is unavailable.

        Monthly payment

        Est. payment

        Payment breakdown

        Explore the cost of this home by adjusting the details. Changes won't be saved.
        All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
        HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
        Mortgage interest rates are dependent on a number of factors, including credit score, down payment, and repayment length. Interest rate data provided by Zillow Group Marketplace, Inc. as of 1/1/1970 from various mortgage lenders with which we have lead or other similar arrangements; the Estimated Payment is an average of those rates.
        See how much you could borrow to make a competitive offer.
        Get pre-qualified

        Climate risks

        Neighborhood: 02842

        Getting around

        76 / 100
        Very Walkable
        52 / 100
        Bikeable

        Nearby schools

        GreatSchools rating

        A local agent can set up tours, give advice and negotiate with sellers.

        Browse local experts

        Similar homes

              Nearby cities

              Nearby zip codes

              Other Middletown Topics

                Search
                Updates
                Favorites
                Plan
                Inbox