Updated 2 Days Ago
Highlights
- Private patio
- Spacious living room
- Professionally maintained grounds
- Abundant parking
Location
247 Hamilton Ave #3, Stamford, CT 06902, USA|Glenbrook
Tour 247 Hamilton Ave #3
Contact
Nearby rentals
Property management
Apartments for rent New YorkApartments for rent Financial DistrictApartments for rent Upper West SideApartments for rent ChelseaApartments for rent Hell's KitchenApartments for rent Upper East SideApartments for rent East VillageApartments for rent Midtown EastApartments for rent Battery Park CityApartments for rent Murray HillApartments for rent Downtown BrooklynApartments for rent West VillageApartments for rent WilliamsburgApartments for rent TribecaApartments for rent Long Island CityApartments Near Me
Houses for rent New YorkHouses for rent NewarkHouses for rent StamfordHouses for rent West New YorkHouses for rent StratfordHouses for rent HamdenHouses for rent Jersey CityHouses for rent HobokenHouses for rent North BergenHouses for rent Long BeachHouses for rent White PlainsHouses for rent BridgeportHouses for rent EdgewaterHouses for rent Fort LeeHouses for rent Union CityHouses for rent near me
Amenities for 247 Hamilton Ave #3, Glenbrook
Features
| Central Air | Hardwood Floor |
| Walk-in Closet |
Appliances
| Dishwasher | In-Unit Laundry |
Grounds
| 2 Parking Spaces | Outdoor Space |
| Storage | Swimming Pool |
Other
| Architecture Style: Ranch | Five Rooms |
Units, floor plans, amenities, dimensions, details, availability, and prices may be approximate and subject to change. Please contact a community representative for more information.
Policies and fees
Applicants
Applicants
One-time.
Contact Property
REQUIRED FEES
Security Deposit
One-time. Refundable.
Contact Property
Advertisement
About 247 Hamilton Ave #3
Property Status: Active 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. Office Phone: (203) 327-6700 Copyright © 2026 SmartMLS, Inc. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.
Property highlights
We compared every listing in the surrounding area to determine which amenities are most common. If a building lacks an amenity that most others in the area have, it is a con. If a building has an amenity most others in the area do not, it is a pro. Similarly, price, schools, and size are calculated relative to the size, price, and distance to schools of the other properties nearby.How 247 Hamilton Ave #3 compares to other nearby properties.
Positives
- Extra Storage
- Upgraded in-unit features
- Images available
- There are at least 10 photos of this address
- Walk-in closet
- Rentals here may include more closet space than average
Address details
| Neighborhood | Glenbrook |
|---|---|
| Zip code | 06902 |
| Type | Condo for rent |
Get the latest listings anytime, anywhere
Receive similar listings in the area, download our app, and more.
Rent trends in Glenbrook
3-bedroom apartments at 247 Hamilton Ave #3 cost about the same as the average rent price for 3-bedroom apartments in Stamford.
Median rents as of Aug 29 2026.
Glenbrook
Stamford
| Month | Median Rent |
|---|---|
| September 2024 | $4,166 |
| October 2024 | $4,237 |
| November 2024 | $4,400 |
| December 2024 | $4,375 |
| January 2025 | $4,299 |
| February 2025 | $4,331 |
| March 2025 | $4,180 |
| April 2025 | $4,025 |
| May 2025 | $4,209 |
| June 2025 | $4,212 |
| July 2025 | $3,920 |
| August 2025 | $4,425 |
| September 2025 | $4,620 |
| October 2025 | $4,292 |
| November 2025 | $4,104 |
| December 2025 | $4,152 |
| January 2026 | $4,257 |
| February 2026 | $4,002 |
| March 2026 | $3,612 |
| April 2026 | $3,536 |
| May 2026 | $3,655 |
| June 2026 | $3,886 |
| July 2026 | $3,803 |
| August 2026 | $3,901 |
| Month | Median Rent |
|---|---|
| September 2024 | $3,366 |
| October 2024 | $3,412 |
| November 2024 | $3,681 |
| December 2024 | $3,400 |
| January 2025 | $3,400 |
| February 2025 | $3,400 |
| March 2025 | $3,180 |
| April 2025 | $3,162 |
| May 2025 | $3,200 |
| June 2025 | $3,200 |
| August 2025 | $3,308 |
| September 2025 | $3,250 |
| October 2025 | $3,471 |
| November 2025 | $3,397 |
| December 2025 | $3,625 |
| January 2026 | $4,126 |
| February 2026 | $4,024 |
| March 2026 | $3,747 |
| May 2026 | $3,625 |
| June 2026 | $3,925 |
| July 2026 | $4,283 |
| August 2026 | $4,320 |
Affordability calculator
Can I afford to live at 247 Hamilton Ave #3?
Bedrooms
3 bedroomsRent-to-income ratio
30%
Slide to adjust the percentage of your monthly income you are willing to spend on rent.
The general rule of thumb is to spend around 30% or less of your income on rent.
Recommended income
$172,000/yr
With your selected rent-to-income ratio, you'd ideally want to make $172,000 annually to afford this 3-bedrooms monthly rent price of $4,300.
For more information on rent affordability, visit our rent calculator.
Schools near 247 Hamilton Ave #3
Julia A. Stark Elementary School
398 glenbrook rd
stamford, CT, 6906
K-5Public
B-
CLC Lathon Wider
137 henry st
stamford, CT, 6902
PKPublic
CLC Westover
412 stillwater ave
stamford, CT, 6902
PKPublic
Norwalk Early Childhood Center
11 allen rd
norwalk, CT, 6851
PKPublic
Westchester Boces
17 berkley dr
rye brook, NY, 10573
K-12Public
Advertisement
Internet available near 247 Hamilton Ave #3
Neighborhood
Glenbrook | Stamford, CT
Getting around Stamford near 247 Hamilton Ave #3
Walking
5/10
Some shops and stores are within a few minutes.
Driving
9/10
Commuting is easy with multiple accessible routes and plenty of parking.
Cycling
4/10
More spots are within biking distance and some roads are cyclist-friendly.
Transit
5/10
Frequent public transit options are within walking distance.
Points of interest for 247 Hamilton Ave #3, Stamford
Groceries
7/10
Wide variety of groceries within a short drive, including some within walking distance
Shopping
7/10
Wide variety of shops within a short drive, including some within walking distance
Cafes
6/10
Variety of cafés within a short drive
Restaurants
8/10
Wide variety of restaurants within a short drive, including some within walking distance
Primary schools
5/10
At least one elementary school within a 20-minute walk
High schools
2/10
At least one high school within a 30-minute walk
Parks
7/10
Large amount of park space nearby
Nightlife
7/10
Wide variety of bars within a short drive, including some within walking distance
Compare similar properties nearby
Residences on Bedford
Our team has verified this companyNewfield - Westover - Turn of River • 1425 Bedford St
2–3 Beds
$2,534–$3,533
The price shown reflects a 12-month lease and includes base rent plus all required monthly fees provided by the property.- dogs ok
- dishwasher
- on-site laundry
Southwood Square Apartments
Our team has verified this company14 Southwood Dr
2–3 Beds
$2,560–$5,125
The price shown reflects a 12-month lease. Fees may apply.- dogs ok
- dishwasher
- on-site laundry
- dogs ok
- dishwasher
- on-site laundry
Wolfpit • 41 Wolfpit Ave
3 Beds
$3,325
The price shown reflects a 12-month lease. Fees may apply.- dogs ok
- dishwasher
- on-site laundry
41 N Main St
2 Beds
$3,650
The price shown reflects a 12-month lease. Fees may apply.- dogs ok
- dishwasher
- on-site laundry
9 Cove Ave #2, Norwalk, CT, 06855
Our team has verified this companyEast Norwalk • 9 Cove Ave #2
3 Beds
$3,900
The price shown reflects a 12-month lease and includes base rent plus all required monthly fees provided by the property.- dogs ok
- dishwasher
- on-site laundry
18 Berrian Pl #B, Greenwich, CT, 06830
Our team has verified this company18 Berrian Pl #B
3 Beds
$4,500
The price shown reflects a 12-month lease and includes base rent plus all required monthly fees provided by the property.- dogs ok
- dishwasher
- on-site laundry
1286 Long Ridge Rd #MAIN, Stamford, CT, 06903
Our team has verified this company1286 Long Ridge Rd #MAIN
3 Beds
$4,550
The price shown reflects a 12-month lease and includes base rent plus all required monthly fees provided by the property.- dogs ok
- dishwasher
- on-site laundry
Residences on Bedford
Our team has verified this companyNewfield - Westover - Turn of River • 1425 Bedford St
2–3 Beds
$2,534–$3,533
The price shown reflects a 12-month lease and includes base rent plus all required monthly fees provided by the property.- dogs ok
- dishwasher
- on-site laundry
Southwood Square Apartments
Our team has verified this company14 Southwood Dr
2–3 Beds
$2,560–$5,125
The price shown reflects a 12-month lease. Fees may apply.- dogs ok
- dishwasher
- on-site laundry
- dogs ok
- dishwasher
- on-site laundry
Wolfpit • 41 Wolfpit Ave
3 Beds
$3,325
The price shown reflects a 12-month lease. Fees may apply.- dogs ok
- dishwasher
- on-site laundry
41 N Main St
2 Beds
$3,650
The price shown reflects a 12-month lease. Fees may apply.- dogs ok
- dishwasher
- on-site laundry
9 Cove Ave #2, Norwalk, CT, 06855
Our team has verified this companyEast Norwalk • 9 Cove Ave #2
3 Beds
$3,900
The price shown reflects a 12-month lease and includes base rent plus all required monthly fees provided by the property.- dogs ok
- dishwasher
- on-site laundry
18 Berrian Pl #B, Greenwich, CT, 06830
Our team has verified this company18 Berrian Pl #B
3 Beds
$4,500
The price shown reflects a 12-month lease and includes base rent plus all required monthly fees provided by the property.- dogs ok
- dishwasher
- on-site laundry
1286 Long Ridge Rd #MAIN, Stamford, CT, 06903
Our team has verified this company1286 Long Ridge Rd #MAIN
3 Beds
$4,550
The price shown reflects a 12-month lease and includes base rent plus all required monthly fees provided by the property.- dogs ok
- dishwasher
- on-site laundry
Check availability
Advertisement