Skip main navigation
Off market
Street View
  • $679,800

    247 W Main Rd, Middletown, RI 02842

    2beds
    2baths
    1,798sqft
    SingleFamily
    Built in 1943
    0.31 Acres Lot
    $679,800 Zestimate®
    $378/sqft
    $2,994 Estimated rent

    Home value

    $679,800

    $591,000 - $775,000

    $2,994/mo

    Zestimate® history
    Loading...

    Owner options

    List your home for rent

    $2,994/mo

    Rent Zestimate®

    Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.

    Learn more

    $2,994/mo

    Rent Zestimate®

    Refinance and save

    $3,955/mo

    Est. payment

    Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.

    See today's rates

    $3,955/mo

    Est. payment

    Explore your selling options

    Work with a Zillow partner agent

    Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.

    Get started

    List with your own agent

    Get your home in front of millions of buyers by listing it on Zillow.

    Learn how to do it

    Sell it yourself

    Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).

    List your home

    What's special

    Looking for a one level living in Middletown, yearly lease terms, and on the bus line? This lovingly built Spanish bungalow offers lots of light, fresh paint and large living areas. A well maintained gem with a huge eat in kitchen, a dining room, large living area, two big bedrooms, 2 full baths with tubs and showers, plus a bonus laundry/office room. Enjoy a seasonal outside indoor porch area "La Stanza" as well as use of one bay garage. Home includes washer and dryer, dishwasher, microwave, many closets, extra storage space in basement. Within two miles of the Naval Base or downtown Newport, the central location makes island living that much easier, you can walk to shopping, restaurants and a new gym to workout...bike to downtown Newport and the beaches, jump on the bus and head to Providence in less than an hour. This charming home is available now and easy to show.

    This property is off market, which means it's not currently listed for sale or rent on Zillow. This may be different from what's available on other websites or public sources.

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 2
    • Bathrooms: 2
    Heating
    • Baseboard, Oil
    Cooling
    • Other
    Appliances
    • Included: Dishwasher, Dryer, Garbage disposal, Microwave, Range / Oven, Refrigerator, Washer
    • Laundry: In Unit
    Features
    • Flooring: Carpet, Hardwood
    • Basement: Partially finished
    • Has fireplace: Yes
    Interior area
    • Total interior livable area: 1,798 sqft

    Property

    Parking
    • Total spaces: 1
    • Parking features: Garage - Detached
    Features
    • Exterior features: Brick
    Lot
    • Size: 0.31 Acres
    Details
    • Parcel number: MIDDM0108BNWL283

    Construction

    Type & style
    • Home type: SingleFamily
    Materials
    • Roof: Tile
    Condition
    • Year built: 1943

    Community & neighborhood

    Location
    • Region: Middletown

    Other

    Other facts
    • Access \ First Floor Access
    • Accessibility \ HandicapAccess \ One Level
    • Appliances \ Laundry \ In Building
    • ApxHeatCost \ Undetermined
    • Basement \ BasementAccess \ Interior Only
    • Basement \ BasementFinish \ Unfinished
    • Basement \ BasementRoomsType \ Storage Area
    • Basement \ BasementRoomsType \ Utility
    • Basement \ BasementType \ Full
    • BasementRoomsType \ Storage Area
    • BasementRoomsType \ Utility
    • Cooling System: Window Mounted Air Conditioning
    • Equipment \ Carpeting
    • Exterior Type: Brick
    • FeeFrequency \ Monthly
    • FinishedFloor \ Ceramic
    • FireplaceUsageAllowed \ 0
    • Flooring \ FinishedFloor \ Ceramic
    • Flooring \ FinishedFloor \ Hardwood
    • Flooring \ FinishedFloor \ Vinyl
    • Flooring \ FinishedFloor \ Wall to Wall Carpet
    • Furnished \ 0
    • HandicapAccess \ One Level
    • Heating and Cooling \ ApxHeatCost \ Undetermined
    • Heating and Cooling \ Cooling \ Window Units
    • Heating and Cooling \ HeatingFuel \ Oil
    • Heating and Cooling \ HeatingSystem \ Baseboard
    • Heating system: Baseboard
    • Heating: Oil
    • HotWater \ Oil
    • HotWater \ Tenant Pays
    • Insulation \ Ceiling
    • Insulation \ Walls
    • InsuranceRequired \ 0
    • Laundry \ In Building
    • Laundry: In Unit
    • Location \ Near \ Bus
    • Location \ Near \ Commuter Bus
    • Location \ Near \ Highway Access
    • Location \ Near \ Hospital
    • Location \ Near \ Public School
    • Location \ Near \ Shopping
    • Lot \ LotDescription \ Out Building
    • Lot \ LotDescription \ Paved Driveway
    • LotDescription \ Out Building
    • LotDescription \ Paved Driveway
    • MLS Listing ID: 1260795
    • MLS Name: Statewide MLS RI ZDD (Statewide MLS RI ZDD)
    • Materials \ Insulation \ Ceiling
    • Materials \ Insulation \ Walls
    • Near \ Bus
    • Near \ Commuter Bus
    • Near \ Highway Access
    • Near \ Hospital
    • Near \ Public School
    • Near \ Shopping
    • Other Building Features \ PetsAllowed \ 0
    • Other Building Features \ SmokingAllowed \ 0
    • Other Exterior Features \ Exterior \ Brick
    • Other Fees \ FeeFrequency \ Monthly
    • Other Fees \ RentFeesInclude \ Grounds Maintenance
    • Other Fees \ RentFeesInclude \ Occupancy
    • Other Fees \ SecurityDepositAmt \ 2000.00
    • Other Fees \ SecurityDepositRequiredYN \ 1
    • Other Interior Features \ FireplaceUsageAllowed \ 0
    • Other Interior Features \ Furnished \ 0
    • Other \ Access \ First Floor Access
    • Other \ Equipment \ Carpeting
    • Other \ Equipment \ Ceiling Fan
    • Other \ Equipment \ Dishwasher
    • Other \ Equipment \ Dryer
    • Other \ Equipment \ Garbage Disposal
    • Other \ Equipment \ Microwave
    • Other \ Equipment \ Oven/Range
    • Other \ Equipment \ Refrigerator
    • Other \ Equipment \ Washer
    • Other \ InsuranceRequired \ 0
    • Other \ RentTerms \ Lease
    • Parking \ GarageDesc \ Detached
    • PetsAllowed \ 0
    • PropertyType \ Rental
    • RentFeesInclude \ Grounds Maintenance
    • RentFeesInclude \ Occupancy
    • RentTerms \ Lease
    • SecurityDepositAmt \ 2000.00
    • SecurityDepositRequiredYN \ 1
    • Sewer \ Public Connected
    • SmokingAllowed \ 0
    • TimeShareYN \ 0
    • Type \ Ranch
    • Type and Style \ PropertyType \ Rental
    • Type and Style \ Type \ Ranch
    • Utilities \ HotWater \ Oil
    • Utilities \ HotWater \ Tenant Pays
    • Utilities \ Sewer \ Public Connected
    • Utilities \ WaterSupply \ Connected
    • WaterSupply \ Connected

    Price history

    DateEventPrice
    8/29/2020Listing removed$2,000$1/sqft
    Source: BHHS Commonwealth Real Estate #1260795
    8/5/2020Listed for rent$2,000$1/sqft
    Source: BHHS Commonwealth Real Estate #1260795
    3/27/2020Listing removed$2,000$1/sqft
    Source: Berkshire Hathaway Home Services N.E. Prime Properties #1242491
    12/4/2019Listed for rent$2,000+5.3%$1/sqft
    Source: BerkshireHathaway HomeServices #1242491
    2/17/2019Listing removed$1,900$1/sqft
    Source: BerkshireHathaway HomeServices #1211810

    Public tax history

    YearProperty taxesTax assessment
    2025$5,519 $490,100
    2024$5,519 +35.1%$490,100 +44.2%
    2023$4,084 $339,800

    Find assessor info on the county website

    Neighborhood: 02842

    Nearby schools

    GreatSchools rating
    Get pre-qualified for a loan
    At Zillow Home Loans, we can pre-qualify you in as little as 5 minutes with no impact to your credit score.

    An equal housing lender. NMLS #10287.

    Sell for more on Zillow
    Get a free Zillow Showcase℠ listing and you could sell for .
    $679,800
    2% more+ $13,596
    With Zillow Showcase(estimated)
    $693,396