370 ft
Distance
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
quiet neighborhood off East and West Main Roads
Explore the local neighborhood highlights and top-rated schools near 02842 in Middletown, RI.
Source: School Digger
Public • PK - PK • Serves this home
0.31 mi
Distance
Public • 6 - 8 • Serves this home
1.33 mi
Distance
Public • 9 - 12 • Serves this home
0.56 mi
Distance
Public • PK - PK • Serves this home
0.31 mi
Distance
Claiborne Pell Elementary School
Public • PK - 4
1.29 mi
Distance
Public • PK - 3
2.63 mi
Distance
Public • PK - 4
6.09 mi
Distance
Public • PK - 4
6.61 mi
Distance
Public • 6 - 8 • Serves this home
1.33 mi
Distance
Public • 4 - 5
1.33 mi
Distance
Frank E. Thompson Middle School
Public • 5 - 8
3.42 mi
Distance
Public • 5 - 8
3.95 mi
Distance
Public • 5 - 8
6.61 mi
Distance
Public • 9 - 12 • Serves this home
0.56 mi
Distance
Newport Area Career And Technical Center
Public • 9 - 12
5.55 mi
Distance
Public • 9 - 12
5.55 mi
Distance
Private • 09 - 12
3.87 mi
Distance
Source: Public Records
| Date | Event | Price |
|---|---|---|
| 06/19/2022 | Sold | $325,000.00 |
| 05/20/2022 | Pending | $325,000.00 |
| 05/19/2022 | Active | $325,000.00 |
| Street Address | Beds | Baths | Sold Date | List Price | Valuation Date | Valuation Price |
|---|---|---|---|---|---|---|
| 108 Sundance View PT | Listing | 4 | 3 | Jun 25, 2026 | $950,000 | Mar 21, 2024 | $1,143,868 |
| 155 West Main Road | 3 | 3 | Jul 03, 2026 | $4,150,000 | Aug 18, 2026 | - |
| 124 Heidi Drive | 4 | 3 | Jun 22, 2026 | $719,000 | Aug 18, 2026 | - |
| 74 Third Street | 6 | 4 | Aug 13, 2026 | $1,400,000 | Aug 18, 2026 | - |
| 78 Ellery Road | 3 | 2 | Jun 18, 2026 | $1,195,000 | Aug 18, 2026 | - |
| 118 Wolcott Avenue | 3 | 2 | Aug 06, 2026 | $1,149,500 | Aug 18, 2026 | - |
| 8 Starboard Avenue | 2 | 1 | Jun 26, 2026 | $700,000 | Aug 18, 2026 | - |
| 6 Price's Cove Avenue | 7 | 5 | Aug 03, 2026 | $17,900,000 | Aug 18, 2026 | - |
| 11 O'Donnell Road | 4 | 2 | Jun 26, 2026 | $1,400,000 | Aug 18, 2026 | - |
| 142 Ferreira Avenue | 3 | 4 | Jul 23, 2026 | $1,395,000 | Aug 18, 2026 | - |
Discover key demographics, population statistics, and environmental insights for the Middletown, RI area.
Source: Sperling's Best Places
| Zip | City | County | National | |
|---|---|---|---|---|
| Population | 16,315 | 16,326 | 85,887 | 335,858,263 |
| Population Density | 1,298 | 1,284 | 839 | 95 |
| People per Household | 2.3 | 2.3 | 2.3 | 2.6 |
| Median Age | 45.1 | 45.1 | 45.5 | 39.1 |
| Median Income | $77,223 | $77,253 | $84,536 | $66,222 |
| Average Income | $42,117 | $42,094 | $49,569 | $35,475 |
| Cost of Living Index | 99 | 99 | 99 | 100 |
| Zip | City | County | National | |
|---|---|---|---|---|
| January Avg. High Temp | 22.6°F | 22.6°F | 22.6°F | 22.6°F |
| July Avg. High Temp | 77.6°F | 77.6°F | 77.6°F | 86.2°F |
| Annual Precipitation | 46" | 46" | 46" | 38" |
76/100
Very Walkable
Walk Score ®
0/100
Minimal Transit
Transit Score ®
57/100
Bikable
Bike Score ®
Most errands can be accomplished on foot. It is possible to get on a bus. Some bike infrastructure.
The average walkability score in the surrounding area is Walk Score: 28/100, Transit Score: 6/100, Bike Score: 35/100.
370 ft
Distance
370 ft
Distance
422 ft
Distance
528 ft
Distance
528 ft
Distance
581 ft
Distance
792 ft
Distance
792 ft
Distance
264 ft
Distance
264 ft
Distance
264 ft
Distance
317 ft
Distance
634 ft
Distance
634 ft
Distance
686 ft
Distance
739 ft
Distance
264 ft
Distance
739 ft
Distance
739 ft
Distance
581 ft
Distance
739 ft
Distance
422 ft
Distance
634 ft
Distance
739 ft
Distance
739 ft
Distance
739 ft
Distance
422 ft
Distance
2 bds • 1 ba • 902 sqft
21 Holbrook Avenue, Portsmouth, RI 02872
2 bds • 1 ba • 1,039 sqft
486 King Street, Fall River, MA 02724
1 bds • 1 ba • 962 sqft
415 Anthony St, Fall River, MA 02720
2 bds • 1 ba • 900 sqft
4430 Post Road E65, East Greenwich, RI 02818
3 bds • 1 ba • 1,015 sqft
15 Allen St, Fall River, MA 02724
2 bds • 1 ba • 1,094 sqft
4160 Post Road 28, Warwick, RI 02818
3 bds • 2 ba • 1,001 sqft
12 Sachem Street, Fall River, MA 02724
2 bds • 1 ba • 930 sqft
750 Davol St 321, Fall River, MA 02720
2 bds • 1 ba • 1,100 sqft
510 Child Street 106C, Warren, RI 02885
2 bds • 2 ba • 1,102 sqft
149 Franklin St, Fall River, MA 02720
2 bds • 3 ba • 990 sqft
3399 Post Road 13, Warwick, RI 02886
2 bds • 2 ba • 992 sqft
3399 Post Road 14, Warwick, RI 02886
3 bds • 1 ba • 1,124 sqft
346 Durfee St #3, Fall River, MA 02720
3 bds • 1 ba • 1,068 sqft
27 Johnson St, Fall River, MA 02723
2 bds • 2 ba • 1,148 sqft
650 East Greenwich Avenue 6-204, West Warwick, RI 02893
2 bds • 1 ba • 854 sqft
615 Robeson St, Fall River, MA 02720
3 bds • 1 ba • 1,004 sqft
51 Morse Avenue, Warwick, RI 02886
2 bds • 1 ba • 928 sqft
24 Magnolia Street, Warwick, RI 02889
2 bds • 2 ba • 1,085 sqft
161 West Shore Road C5, Warwick, RI 02889
3 bds • 1 ba • 856 sqft
1244 Presidents Ave, Fall River, MA 02720
Source: Realty.com
174 Ridgewood Rd 174, Middletown, RI 02842 in Middletown, RI 02842 is a condominium listed at $325,000. Highlights include 2 bedrooms, 1 bathroom, 1,000 sq. ft., built in 1983, 0.20 acre lot, $325 per sq. ft.. Realty.com has 26 photos, sales history, school insights, and mortgage tools for this listing.
Realty.com has 26 photos of 174 Ridgewood RD 174.
Our records indicate that 174 Ridgewood RD 174 was built in 1983.
The full address for this home is 174 Ridgewood Rd 174, Middletown, RI 02842.
174 Ridgewood RD 174 has been listed on Realty.com since Thu May 19, 2022
Most errands can be accomplished on foot. It is possible to get on a bus. Some bike infrastructure.
The average walkability score in the surrounding area is Walk Score: 28/100, Transit Score: 6/100, Bike Score: 35/100.
There are 3 schools assigned to this home. Check out the schools near 174 Ridgewood RD 174. The Pell @ Rogers High School (Grades: PK - PK), Joseph H. Gaudet School (Grades: 6 - 8), Middletown High School (Grades: 9 - 12)
Listing provided courtesy of:
Hearth & Harbor Realty
(tel: 401-816-5187)
Listing agent:
Kristin Silveira
(#CN242421)
This content last refreshed on 2026-08-18 17:52:45. Some properties which appear for sale on this web site may subsequently have sold or may no longer be available.