P
Landlord's Agent in 2026
Pauline Campbell
Envious Properties LLC
(401) 450-9686
1 in this area
19 Total Sales
237 Pequot Ave Warwick, RI 02889
Oakland Beach Neighborhood
2
Beds
1.5
Baths
1,200
Sq Ft
11,326
Sq Ft Lot
Highlights
- Marina
- Deck
- Recreation Facilities
- Golf Course Community
- No HOA
- Walking Distance to Water
About This Home
As of February 2026New construction rental. Unit 237. Bright, two-story unit offering 2 bedrooms and 2 bathrooms, along with additional basement storage. Features include LVP floors throughout, modern and thoughtfully designed finishes, and a modern kitchen equipped with stainless steel appliances, quartz countertops, and custom cabinetry.
Enjoy year-round comfort with central air conditioning and gas heat. Both front and rear entrances, a private deck, and a charming farmers porch. Private off-street parking included. Washer and dryer hookups in basement.
Ideally located near marinas, dining, shopping, and parks, providing both convenience and lifestyle appeal.
Last Agent to Rent the Property
Envious Properties LLC License #RES.0046025 Listed on: 02/28/2026
Last Renter's Agent
Envious Properties LLC License #RES.0046025 Listed on: 02/28/2026
Home Details
Home Type
- Single Family
Year Built
- Built in 2025
Lot Details
- 0.26 Acre Lot
- Sprinkler System
Home Design
- Vinyl Siding
Interior Spaces
- 1,200 Sq Ft Home
- 3-Story Property
- Storage Room
- Laundry in unit
- Utility Room
Kitchen
- Oven
- Range
- Microwave
- Dishwasher
Flooring
- Laminate
- Ceramic Tile
Bedrooms and Bathrooms
- 2 Bedrooms
- Bathtub with Shower
Unfinished Basement
- Basement Fills Entire Space Under The House
- Interior Basement Entry
Parking
- 2 Parking Spaces
- No Garage
- Driveway
- Assigned Parking
Outdoor Features
- Walking Distance to Water
- Deck
- Porch
Utilities
- Forced Air Heating and Cooling System
- Heating System Uses Gas
- Electric Water Heater
Listing and Financial Details
- Property Available on 2/28/26
- 12 Month Lease Term
- Assessor Parcel Number 237235PEQUOTAV237WARW
Community Details
Overview
- No Home Owners Association
- Oakland Beach Subdivision
Amenities
- Shops
- Restaurant
- Public Transportation
Recreation
- Marina
- Golf Course Community
- Recreation Facilities
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area
Home Values in the Area
Average Home Value in this Area
Property History
| Date | Event | Price | List to Sale | Price per Sq Ft |
|---|---|---|---|---|
| 02/28/2026 02/28/26 | Rented | $2,600 | 0.0% | -- |
| 02/28/2026 02/28/26 | For Rent | $2,600 | -- | -- |
Source: State-Wide MLS
Agents Affiliated with this Home
-
Pauline Campbell
Map
Source: State-Wide MLS
MLS Number: 1405578
Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.
IDX information is provided exclusively for personal, non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information is deemed reliable but not guaranteed.
Copyright © 2026 State-Wide MLS, Inc. All rights reserved.
Nearby Homes
- 107 Coburn St
- 75 Northup St
- 357 Pequot Ave
- 73 Pinehurst Ave
- 71 Pinehurst Ave
- 83 Ottawa Ave
- 79 Pinehurst Ave
- 81 Pinehurst Ave
- 52 Hazard Ave
- 188 Wood St
- 0 Sea View Dr
- 90 Huron St
- 79 Suburban Pkwy
- 176 Canfield Ave
- 585 Meadow View Ave
- 165 Canfield Ave
- 21 Hampton Ave
- 195 Oakland Beach Ave
- 9 Kenneth Ave
- 43 Beaver Ave
Your Personal Tour Guide
Ask me questions while you tour the home.