Listed by Shaunna Carreiro of The Q Group Realty
Welcome to Esmond! This charming second-floor apartment is ready for immediate occupancy and offers a bright, comfortable place to call home. Featuring one bedroom and one full bath, the unit is filled with character, including beautiful original hardwood flooring and a private balcony perfect for enjoying your morning coffee or unwinding at the end of the day. Hot water is included for added convenience. Ideally located just minutes from Mineral Spring Avenue, Putnam Pike, Smithfield Crossings, Route 44, and I-295, with easy access to shopping, dining, everyday amenities, and major commuter routes. Clean, charming, conveniently located, and move-in ready-schedule your private showing today!

Listing Tools

Property Details of 274 Waterman Avenue, Unit 4, Esmond

Property Details

Interior Features

Exterior Features

Community

Map Location

 IDX information is provided exclusively for consumers’ 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 is not guaranteed.  ©  2026 State-Wide Multiple Listing Service. All rights reserved.

Hi there! How can we help you?

Contact us using the form below or give us a call.

Send Us A Message:

I agree to receive marketing and customer service calls and text messages from Costello Realty. To opt out, you can reply 'stop' at any time or click the unsubscribe link in the emails. Consent is not a condition of purchase. Msg/data rates may apply. Msg frequency varies. Privacy Policy.

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Hi there! How can we help you?

Contact us using the form below or give us a call.

Send Us A Message:

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Hi there! How can we help you?

Contact us using the form below or give us a call.

Send Us A Message:

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

$

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.