* Price shown is total price based on community-supplied monthly required fees. Excludes user-selected optional fees and variable or usage-based fees and required charges due at or prior to move-in or at move-out. View Fees and Policies for details. Price, availability, fees, and any applicable rent special are subject to change without notice.
Note: Prices and availability subject to change without notice.
Lease Terms
Contact office for Lease Terms
Fees and Policies
The fees below are based on community-supplied data and may exclude additional fees and utilities. Use the calculator to add these fees to the base rent.
Dogs
Allowed
Cats
Allowed
Property Fee Disclaimer:
Based on community-supplied data and independent market research. Subject to change without notice. May exclude fees for mandatory or optional services and usage-based utilities.
About 247 Hamilton Ave
Call for Availability - 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. MLS# 24191172
247 Hamilton Ave is located in
Stamford, Connecticut
in the 06902 zip code.
SmartMLS#CTThe 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.
Protect yourself from fraud. Do not send money to anyone you don't know.
