For Rent

Listing Tools

Welcome to this beautifully updated 3-bedroom, 2-bath condominium in the highly sought-after Heywood Heights community in Stamford's desirable Glenbrook neighborhood. This unit combines comfort, style, and functionality with a floor plan designed for today's lifestyle. Freshly painted throughout and featuring brand-new hardwood floors. This inviting residence offers a spacious living room with sliding doors leading to a private patio overlooking the beautifully maintained courtyard. The well-appointed kitchen opens seamlessly to the dining area, creating an ideal space for both everyday living and entertaining. The generous primary suite features a private full bath and a walk-in closet, while two additional bedrooms offer ample space for family, guests, or a home office. Residents can enjoy exceptional community amenities, including an in-ground swimming pool, abundant parking, assigned storage, and professionally maintained grounds. Conveniently located near shopping, restaurants, parks, and major commuting routes, this is an outstanding rental opportunity in one of Stamford's most desirable communities.

Property Details of 247 Hamilton Avenue, Unit 3, Glenbrook

Map Location

Driving Directions

Listed by Gedna Jean-Pierre of Keller Williams Prestige Prop. ((203) 918-8202)

The data relating to real estate for sale on this website appears in part through the SmartMLS Internet Data Exchange program, a voluntary cooperative exchange of property listing data between licensed real estate brokerage firms, and is provided by SmartMLS through a licensing agreement. Listing information is from various brokers who participate in the SmartMLS IDX program and not all listings may be visible on the site. The property information being provided on or through the website is for the personal, non-commercial use of consumers and such information may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Some properties which appear for sale on the website may no longer be available because they are for instance, under contract, sold or are no longer being offered for sale. Property information displayed is deemed reliable but is not guaranteed. Copyright 2026 SmartMLS, Inc.

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 Ferrigno-Storrs, REALTORS LLC.. 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.