$4,500
Total Monthly Price
247 Hamilton Ave Unit 3
Stamford, CT 06902
Favorites
203-918-8202
-
Bedrooms
3
-
Bathrooms
2
-
Square Feet
1,485 sq ft
-
Available
Available Now
Highlight
- Pets Allowed
247 Hamilton Ave Unit 3
Favorites
About This Home
Available Now
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 a condo located in Fairfield County and the 06902 ZIP Code.
* 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. Price, availability, fees, and any applicable rent special are subject to change without notice.
* Square footage definitions vary. Displayed square footage is approximate.
Fees and Policies
The fees listed below are community-provided and may exclude utilities or add-ons. All payments are made directly to the property and are non-refundable unless otherwise specified.
-
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.
Contact
- Listed by Gedna Jean-Pierre | Keller Williams Prestige Prop.
- Phone Number
- Contact
-
Source
Smart MLS
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.
Location
Get Directions
Located a mile east of Downtown Stamford, Glenbrook is a large neighborhood that embodies the feel of a small town. Along with locally owned shops and diverse eateries, Glenbrook has its own train station and multiple parks. Residents also enjoy living just a few miles north of waterfront parks and beaches along the Long Island Sound, including West Beach, Cummings Park, and Cove Island. Complemented by tree-lined streets, Glenbrook features a wide range of architectural styles, such as Victorian and modern single-family houses, but there are apartments and condos available for rent as well. Between its great schools and a strong sense of community, Glenbrook is a family-friendly neighborhood anyone can enjoy.
Learn more about living in Glenbrook
Education
| Colleges & Universities | Distance | ||
|---|---|---|---|
| Colleges & Universities | Distance | ||
| Drive: | 5 min | 2.2 mi | |
| Drive: | 24 min | 13.4 mi | |
| Drive: | 26 min | 15.2 mi | |
| Drive: | 25 min | 17.4 mi |
247 Hamilton Ave Unit 3 is within 5 minutes or 2.2 miles from University of Connecticut. It is also near Purchase College and Manhattanville College.
Getting Around
What do Walkability, Transit, Drivability, and Bikeability mean?
Walkability measures the walking distance to day-to-day needs.
Transit measures access to public transportation.
Drivability measures congestion, parking availability, and access to major roads.
Bikeability measures the suitability for cycling.
How It Works
Fairly Walkable
Walkability
50
/ 100
Some Public Transit
Transit
50
/ 100
Exceptionally Drivable
Drivability
90
/ 100
Fairly Bikeable
Bikeability
40
/ 100
Scores provided by
What do Walkability, Transit, Drivability, and Bikeability mean?
Walkability measures the walking distance to day-to-day needs.
Transit measures access to public transportation.
Drivability measures congestion, parking availability, and access to major roads.
Bikeability measures the suitability for cycling.
How It Works
-
Soundscore™
-
/ 100
Traffic
-Airport
-Businesses
-Scores provided by
HowLoud What is a Sound Score Rating? A Sound Score Rating aggregates noise caused by vehicle traffic, airplane traffic and local sources. How It WorksYou May Also Like
Similar Rentals Nearby
-
-
-
-
-
-
-
-
-
-
3 Beds, 3 Baths, 2,350 sq ft$4,600Total Monthly Price12 Month LeaseTotal Monthly Price NewPrices include all required monthly fees.24 Hollow Wood Ln Unit 2
247 Hamilton Ave
Stamford, CT 06902