5 beds2,858 sqft$437/sqft
247 W Main Rd, Middletown, RI 02842
Est: $7,197/moGet pre-approved

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...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.
LISTING UPDATED: 08/10/2026 01:00 AM

  1. Listed by Jeanne Allen • Brokerage DRE #REB.0019029 • William Raveis Inspire
    P: (401)-864-2752 jeanne.allen@raveis.com
  2. Listed by Arthur Chapman • Brokerage DRE #REB.0019029 • William Raveis Inspire
    P: (401)-640-0807 C: (401)-640-0807 arthur.chapman@raveis.com

Property Details for 247 West Main Road

Status
MLS #
1418571
Days on Market
15
Taxes
$10,178 / year
HOA Fees
-
Condo/Co-op Fees
-
Property Type
MLS Type
Residential Income / Multi Family
Year Built
1945
Lot Size
0.44 AC / 19,167 SF
Subdivision Name
Two Mile Corner
Architectural Style
Side By Side

Location

Listing Courtesy of William Raveis Inspire
Add your commute

Building Information for 247 West Main Road

Stories1Residences3Year Built1945Building Size-Lot Size0.44 AC / 19,167 SF

Payment Calculator

$7,197 per month

30 year fixed, 6.55% Interest

Principal and Interest

$6,349

Property Taxes

$848

HOA Dues

$0

The Payment Calculator is for illustrative purposes only.

Know your buying power with a preapproval and custom rate in minutes

Rocket Mortgage1

Property Information for 247 West Main Road

Summary
Location and General Information
  • City: Middletown
  • Community Features: Golf, Highway Access, Marina, Near Hospital, Near Schools, Other, Pool, Public Transportation, Recreation Area, Restaurant, Shopping, See Remarks, Tennis Courts, Sidewalks
  • Postal City: Middletown
  • Postal Code: 02842
  • State Or Province: RI
  • Zoning: OBA
  • Human Modified Y N: No
Parking
  • Attached Garage Y N: No
  • Covered Spaces: 2
  • Garage Spaces: 2
  • Garage Y N: Yes
  • Parking Features: Detached, Garage
  • Parking Total: 14
Taxes and HOA Information
  • Tax Annual Amount: $10,178.00
  • Tax Assessed Value: 868300
  • Tax Block: NW
  • Tax Lot: 283
  • Tax Map Number: 103
  • Tax Year: 2025
Property
Lot Information
  • Above Grade Fin SQFT: 2858.0
  • Building Area Total: 2858.0
  • Living Area Source: Appraiser
  • Lot Size Acres: 0.44
  • Lot Size Area: 19167.0
  • Lot Size Square Feet: 19167.0
  • Lot Size Units: Square Feet
  • Number Of Buildings: 2
  • Parcel Number: 247249WESTMAINRDMDLT
  • Stories Total: 1
Property and Assessments
  • Business Type: Other
  • New Construction Y N: No
  • Number Of Units Total: 3
  • Property Sub Type: Multi Family
  • Property Type: Residential Income
  • Senior Community Y N: No
  • Year Built: 1945
  • C L I P: 3,253,203,870
Utilities
  • Electric: Amps100
  • Sewer: Connected, Public Sewer
  • Utilities: Sewer Available, Sewer Connected, Water Available
  • Water Source: Connected, Public
Interior and Exterior Features
Exterior Features
  • Exterior Features: Deck, Paved Driveway
  • Foundation Details: Concrete Perimeter
Interior Features
  • Appliances: Dishwasher, Electric Water Heater, Oven, Oil Water Heater, Range, Refrigerator, Washer
  • Basement: Full, Interior Entry, Unfinished
  • Basement Y N: Yes
  • Bathrooms Full: 4
  • Bathrooms Total Integer: 4
  • Bedrooms Total: 5
  • Cooling: None
  • Cooling Y N: No
  • Door Features: Storm Doors
  • Fireplace Features: Masonry, Marble, Tile
  • Fireplaces Total: 2
  • Fireplace Y N: Yes
  • Flooring: Carpet, Ceramic Tile, Hardwood, Marble, Vinyl
  • Heating: Hot Water, Oil
  • Heating Y N: Yes
  • Interior Features: Attic, Stall Shower, Tub Shower, Cable Tv
  • Laundry Features: Common Area
  • Levels: One
  • Patio And Porch Features: Deck, Porch, Screened
  • Rooms Total: 10
  • Window Features: Storm Windows
Multi Family
Unit 1 Information
  • Description: Duplex
  • Type: One Bedroom
  • Occupant Type: Vacant
  • Unit Type Area: 530.0
  • Baths Total: 1
  • Beds Total: 1
  • Num of Full Baths: 1
Unit 2 Information
  • Description: Duplex
  • Type: One Bedroom
  • Occupant Type: Vacant
  • Unit Type Area: 530.0
  • Baths Total: 1
  • Beds Total: 1
  • Num of Full Baths: 1
Unit 3 Information
  • Description: House
  • Type: Three Bedroom
  • Occupant Type: Vacant
  • Unit Type Area: 1798.0
  • Baths Total: 2
  • Beds Total: 3
  • Num of Full Baths: 2
Rental
Rental Information
  • Land Lease Y N: No

Property History for 247 West Main Road

DateEvent & SourcePriceAppreciation
Jul 25, 2026

Listed (Active)

Rhode Island Association of REALTORS® #1418643

$799,000
Jul 25, 2026

Listed (Active)

Rhode Island Association of REALTORS® #1418571

$1,249,000
DateEvent & SourcePrice
07/25/2026

Listed (Active)

Rhode Island Association of REALTORS® #1418643

$799,000
07/25/2026

Listed (Active)

Rhode Island Association of REALTORS® #1418571

$1,249,000

For completeness, we often displays two records for one sale: the MLS record and the public record.

Public Records for 247 West Main Road

Taxable ValueLand$269,100Additions$221,000Total$490,100
Tax Record2025$5,778 ($482 / month)
Home Facts
Beds3Baths2Total Finished SqFt1,798 SqFtAbove Grade Finished SqFt1,798 SqFtUnfinished Basement SqFt1,798 SqFtStories1Lot Size13,504 SqFtStyleSingle Family ResidenceYear Built1945Year Renovated1945ZoningOBACountyNEWPORTAPNMIDD M:0108 B:NW L:283

Schools near 247 West Main Road

This home is within Middletown School District.
Rating
School
Type
Grades
Distance
Public - K to 3
Public - 6 to 8
Public - 9 to 12
Public - 4 to 5
Rating
School
Distance
Forest Avenue School
PublicK to 3

Joseph H. Gaudet School
Public6 to 8

Middletown High School
Public9 to 12

Joseph Gaudet Academy
Public4 to 5

School ratings and boundaries are provided by GreatSchools.org and Pitney Bowes. This information should only be used as a reference. Proximity or boundaries shown here are not a guarantee of enrollment. Please reach out to schools directly to verify all information and enrollment eligibility.

Similar Homes

New listings in 02842

$590,000 | 28 Ludlow Road, Middletown, RI 02842
1/13

$590,000

5
Bedrooms
1,587
Square Feet
0.17
Acres
$1,745,000 | 27 Oceanview Drive, Middletown, RI 02842
1/49
Listed By Compass

$1,745,000

5
Bedrooms
4,008
Square Feet
0.52
Acres
$5,100,000 | 216 Gray Craig Road, Middletown, RI 02842
1/46
Listed By Compass

$5,100,000

5
Bedrooms
10,263
Square Feet
2.76
Acres
$5,300,000 | 517 Tuckerman Avenue, Middletown, RI 02842
1/50
Virtual Tour

$5,300,000

4
Bedrooms
4,446
Square Feet
0.7
Acres
$724,900 | 19 Vincent Street, Middletown, RI 02842
1/34

$724,900

4
Bedrooms
1,555
Square Feet
0.57
Acres
$190,000 | 23 Bayview Park, Middletown, RI 02842
1/15

$190,000

2
Bedrooms
924
Square Feet
9.24
Acres
$1,400,000 | 58 Allston Avenue, Middletown, RI 02842
1/50

$1,400,000

4
Bedrooms
2,142
Square Feet
0.14
Acres
$739,900 | 278 Green End Avenue, Middletown, RI 02842
1/28

$739,900

4
Bedrooms
2,073
Square Feet
0.26
Acres
$1,650,000 | 1079 Aquidneck Avenue, Unit 2B, Middletown, RI 02842
1/24

$1,650,000

Unavailable
Bedrooms
3,412
Square Feet

247 West Main Road is a multi-family home for sale in Middletown, RI 02842. This property was listed for sale on July 25, 2026 by William Raveis Inspire, it's currently listed at $1,249,000. This listing's school district is Middletown School District. Nearby schools include Forest Avenue School, Joseph H. Gaudet School and Middletown High School. 247 West Main Road is a 5-bed, 4-bath, 2,858 sqft multi-family home built in 1945.

No guarantee, warranty or representation of any kind is made regarding the completeness or accuracy of any information, descriptions or measurements (including square footage measurements and property condition), such should be independently verified through appropriate means, including, but not limited to, in person inspection and public records, and Compass International Holdings, its subsidiaries, affiliates and independently owned and operated franchisees, and their affiliated agents and associated third parties expressly disclaim any liability in connection therewith. Photos may be virtually staged or digitally enhanced and may not reflect actual property conditions. Offers of compensation are subject to change at the seller's discretion. No financial or legal advice provided. Equal Housing Opportunity.

Listing Courtesy of William Raveis Inspire

Based on information from one of the following Multiple Listing Services: Rhode Island Association of REALTORS®. Information being provided is for the visitor’s personal, noncommercial use and may not be used for any purpose other than to identify prospective properties visitor may be interested in purchasing. The data contained herein is copyrighted by Rhode Island Association of REALTORS® is protected by all applicable copyright laws. Any dissemination of this information is in violation of copyright laws and is strictly prohibited. Property information referenced on this web site comes from the Internet Data Exchange (IDX) program of the MLS. This web site may reference real estate listing(s) held by a brokerage firm other than the broker and/or agent who owns this web site. For the avoidance of doubt, the accuracy of all information, regardless of source, is deemed reliable but not guaranteed and should be personally verified through personal inspection by and/or with the appropriate professionals.