This home's estimate is 31% lower than the average sale price ($556K) of 6 comparable homes.
Search- Overview
- Sale & tax history
- Property details
- Neighborhood

























174 Ridgewood Rd, Middletown, RI 02842
About this home
Unique two bedroom condo, only two units in the building, and located in a quiet residential neighborhood, and NO pet restrictions! Shared fully fenced in backyard, fencing replaced 2021. First floor has a living room and an eat in kitchen, second floor has two bedrooms and a full bath with a Jacuzzi tub. Full basement has two rooms, one with the washer/dryer, new boiler (replaced 2021), oil tank and bulkhead access to the back yard. The second room could easily be converted to more living space. Love camping? This condo comes with room for parking a 40 foot camper with an electric hook up. The condo is wired for a generator with an easy access plug on the back deck. Other updates include a new dishwasher in 2021, the bulkhead is about 5 years old, the sump pump about 3 years old, the garbage disposal is about 4 years old. The roof was replaced about 10 years ago with 30 year shingles. This is a two unit condo association with no condo fees. Shared expenses include the lawn maintenance and insurance. All other fees are separate (taxes, oil, electric, water, sewer, etc). This sale is subject to Seller securing suitable housing; currently under contract.
Redfin Estimate
Earn from this home
List your home with Redfin and save $3,840
List your home for rent
Market trends in 02842, RI
Last updated July 2026
Buyer's Market
Seller's Market
Balanced market
See all
Provided by Redfin
Sale history for 174 Ridgewood Rd
$325/sq ft
$325/sq ft
Tax history for 174 Ridgewood Rd
*Taxable value of land and structures on it ("additions") is determined regularly by local assessors and does not affect market price.
Public record
Property details
Parking
- Parking
- Features: Assigned, No Garage
- # of Parking (Total): 4
Interior
- Virtual Tour
- Bathroom Information
- # of Full Bathrooms: 1
- Room Information
- # of Rooms (Total): 4
- Has Basement
- Basement Information: Exterior Entry, Full, Interior Entry, Unfinished
- Laundry Information
- Features: In Unit
- Equipment
- Appliances: Dryer, Dishwasher, Exhaust Fan, Disposal, Microwave, Oven, Oil Water Heater, Range, Refrigerator, Washer
- Interior Features
- Flooring: Ceramic Tile, Laminate, Carpet
- Other Features: Attic, Tub Shower, Cable TV
Exterior
- Building Information
- Stories: 2
- Stories (Total): 2
- Building Name: Ridgewood Road Condo Association
- Construction Details: Drywall, Vinyl Siding
- Exterior Features
- Exterior Features: Paved Driveway, TV Antenna
- Fencing: Fenced
- Green Features
- Green Location: Public Transportation, Walkability
- Lot Information
- Zoning: R10
- Property Information
- Above Grade Finished Area: 1,000
- Entry Location: Private Entry
- Entry Level: 1
- Foundation Details: Concrete Perimeter
Financial
- Assessments and Fees
- Assessed Value: $217,000
- Tax Information
- Annual Tax Amount: $2,210
- Tax Year: 2021
- Rental Information
- Tenant Pays: Hot Water
- Pets Allowed Details: No Pet Restrictions, Yes
Utilities
- Utility Information
- Utilities: Sewer Connected
- Electric: 200+ Amp Service
- Sewer: Connected, Public Sewer
- Water Source: Connected, Public
- Heating & Cooling
- Has Heating
- Heating: Baseboard, Oil
Location
- Multi Unit Information
- # Of Units In Community: 2
- HOA Information
- Annually
- Community Information
- Community Features: Golf, Highway Access, Near Hospital, Near Schools, Public Transportation, Recreation Area, Shopping, Tennis Court(s)
Public facts
- Beds: 2
- Baths: 1.0
- Sq. Ft.: 1,000
- Stories: 2.0
- Lot Size: —
- Style: Condo/Co-op
- Year Built: 1983
- Year Renovated: —
- County: Newport County
- APN: 523161
Around this home
Schools
Public K-3 • Assigned • 0.6mi
Public 6-8 • Assigned • 0.9mi
Public 9-12 • Assigned • 0.6mi
Lifestyle
Provided by Walk Score and Local Logic
Sun exposure
In this area, properties receive around 9 hours in June and 4.6 hours in December, which is comparable to the U.S. average for solar exposure.
Nearby similar homes
New listings for sale in 02842
Home values near 174 Ridgewood Rd
| Address | Redfin Estimate |
|---|---|
3 Beds | 2.5 Baths | 3014 Sq. Ft. | $741,296 |
2 Beds | 1 Baths | 1196 Sq. Ft. | $515,363 |
| Address | Redfin Estimate |
|---|---|
5 Beds | 2.5 Baths | 2854 Sq. Ft. | $752,649 |
2 Beds | 1 Baths | 884 Sq. Ft. | $433,021 |
| Address | Redfin Estimate |
|---|---|
2 Beds | 2 Baths | 2400 Sq. Ft. | $664,945 |
3 Beds | 2 Baths | 2490 Sq. Ft. | $688,237 |
More real estate resources
- Neighborhoods
- Zip Codes
- Cities
- Popular Searches
| Downtown Middletown homes for sale |
| 02842 homes for sale | |||
| 02835 homes for sale | |||
| 02871 homes for sale | |||
| 02840 homes for sale |
| Providence homes for sale | |||
| Middletown homes for sale | |||
| Newport homes for sale |
Find us
Subsidiaries
Affiliated Business
Copyright: © 2026 Redfin. All rights reserved.
Updated September 2025: By searching, you agree to the Terms of Use, and Privacy Policy.
Do not sell or share my personal information.
REDFIN and all REDFIN variants, WALK SCORE, and the R logos, are trademarks of Redfin Corporation, registered or pending in the USPTO.
California DRE #01521930
Redfin is licensed to do business in New York as Redfin Real Estate. NY Standard Operating Procedures
New Mexico Real Estate Licenses
TREC: Info About Brokerage Services, Consumer Protection Notice
All mortgage lending products and information are provided by Rocket Mortgage, LLC | NMLS #3030; www.NMLSConsumerAccess.org. Licensed in 50 states. This site is not authorized by the New York State Department of Financial Services for mortgage solicitation or loan applications activities related to properties located in the State of New York.
Redfin Corporation is an affiliated business of Rocket Limited Partnership. Each company, and their subsidiaries, are separate legal entities operated and managed through its own management and governance structures.
If you are using a screen reader, or having trouble reading this website, please call Redfin Customer Support for help at 1-844-759-7732.
REDFIN IS COMMITTED TO AND ABIDES BY THE FAIR HOUSING ACT AND EQUAL OPPORTUNITY ACT. READ REDFIN'S FAIR HOUSING POLICY AND THE NEW YORK STATE FAIR HOUSING NOTICE.












































United States
Canada