5+ Days Ago
Highlights
- Custom cabinetry
- Plush carpeting
- Private deck
- Modern comfort
- Lushly landscaped grounds
- Thoughtfully designed open floor plan
Location
247 Hamilton Ave #2, Stamford, CT 06902, USA|Glenbrook
Tour 247 Hamilton Ave #2
Contact
Nearby rentals
Renter hub
Property management
Apartments for rent New YorkApartments for rent Financial DistrictApartments for rent Upper West SideApartments for rent Hell's KitchenApartments for rent ChelseaApartments for rent Upper East SideApartments for rent East VillageApartments for rent Midtown EastApartments for rent West VillageApartments for rent Battery Park CityApartments for rent Lower East SideApartments for rent TribecaApartments for rent Murray HillApartments for rent Downtown BrooklynApartments for rent WilliamsburgApartments Near Me
Houses for rent New YorkHouses for rent Financial DistrictHouses for rent ChelseaHouses for rent Upper East SideHouses for rent Hell's KitchenHouses for rent Murray HillHouses for rent Theater DistrictHouses for rent Lower East SideHouses for rent Long Island CityHouses for rent West VillageHouses for rent East VillageHouses for rent Turtle BayHouses for rent RiverdaleHouses for rent Downtown BrooklynHouses for rent Kips BayHouses for rent near me
Amenities for 247 Hamilton Ave #2, Glenbrook
Apartment Amenities
| Carpet | Central Air |
| Electric Heating |
Appliances
| Dishwasher | In-Unit Laundry |
Building
| Exterior Type: Brick |
Grounds
| Assigned Parking | Storage |
| Swimming Pool |
Other
| Architecture Style: Ranch |
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
Contact for more information on pet policy.
Parking
| Assigned Parking | Contact for Price |
|---|
Advertisement
About 247 Hamilton Ave #2
Property Status: Active Welcome to the highly sought-after Heywood Heights community, where lushly landscaped grounds, a welcoming clubhouse, and a sparkling in-ground pool set the tone for resort-style living. This spacious two-bedroom, one-bath condominium offers a thoughtfully designed open floor plan, ideal for both everyday living and effortless entertaining. Step out onto your private deck and take in serene, wooded views-your own tranquil retreat. Inside, recent updates shine throughout: brand-new custom cabinetry, complemented by sleek new appliances, plush carpeting, and a fresh coat of paint that enhances the home's bright and inviting atmosphere. A full-size washer and dryer are conveniently located in-unit, while additional storage space is available in the basement. Parking is never an issue, with abundant spaces for residents and guests in addition to your dedicated parking spot. Perfectly positioned near the Stamford train station and just minutes from local beaches-including scenic Cove Island Park-this residence blends modern comfort with an unbeatable location. Welcome home to Heywood Heights. Office Phone: (203) 968-1500 Copyright © 2025 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 #2 compares to other nearby properties.
Positives
- Middle school nearby
- There is a middle school 1 mile away
- Images Available
- There are at least 10 photos of this address
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
2-bedroom apartments at 247 Hamilton Ave #2 cost about 14% more than the average rent price for 2-bedroom apartments in Stamford.
Median rents as of Sep 20 2025.
Glenbrook
Stamford
| Month | Median Rent |
|---|---|
| October 2023 | $3,350 |
| November 2023 | $3,412 |
| December 2023 | $3,390 |
| January 2024 | $3,338 |
| February 2024 | $3,435 |
| March 2024 | $3,381 |
| April 2024 | $3,303 |
| May 2024 | $3,199 |
| June 2024 | $3,284 |
| July 2024 | $3,514 |
| August 2024 | $3,495 |
| September 2024 | $3,410 |
| October 2024 | $3,360 |
| November 2024 | $3,368 |
| December 2024 | $3,493 |
| January 2025 | $3,331 |
| February 2025 | $3,266 |
| March 2025 | $3,261 |
| April 2025 | $3,268 |
| May 2025 | $3,410 |
| June 2025 | $3,309 |
| July 2025 | $3,250 |
| August 2025 | $3,295 |
| September 2025 | $3,416 |
| Month | Median Rent |
|---|---|
| October 2023 | $2,929 |
| November 2023 | $2,893 |
| December 2023 | $2,765 |
| January 2024 | $2,725 |
| February 2024 | $2,900 |
| March 2024 | $2,925 |
| April 2024 | $2,800 |
| May 2024 | $2,791 |
| June 2024 | $2,780 |
| July 2024 | $2,647 |
| August 2024 | $2,780 |
| September 2024 | $2,637 |
| October 2024 | $2,618 |
| November 2024 | $2,680 |
| December 2024 | $2,875 |
| January 2025 | $3,087 |
| February 2025 | $2,987 |
| March 2025 | $2,900 |
| April 2025 | $2,950 |
| May 2025 | $2,970 |
| June 2025 | $2,900 |
| July 2025 | $2,870 |
| August 2025 | $2,832 |
| September 2025 | $2,792 |
Affordability calculator
Can I afford to live at 247 Hamilton Ave #2?
Bedrooms
2 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
$128,000/yr
With your selected rent-to-income ratio, you'd ideally want to make $128,000 annually to afford this 2-bedrooms monthly rent price of $3,200.
For more information on rent affordability, visit our rent calculator.
Schools near 247 Hamilton Ave #2
Julia A. Stark Elementary School
398 glenbrook rd
stamford, CT, 6906
K-5Public
B-
Advertisement
Internet available near 247 Hamilton Ave #2
Getting around Stamford near 247 Hamilton Ave #2
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.
Transit
4/10
Frequent public transit options are within walking distance.
Points of interest for 247 Hamilton Ave #2, Stamford
Groceries
6/10
At least one grocery store within a 15-minute walk
Shopping
6/10
Variety of shops within walking distance
Cafes
4/10
Few or no cafés within walking distance
Restaurants
7/10
Variety of restaurants within walking distance
Primary schools
4/10
No elementary schools within a 30-minute walk
High schools
3/10
No high schools within a 30-minute walk
Parks
7/10
Moderate amount of park space nearby
Nightlife
3/10
Few or no bars within walking distance
Compare similar properties nearby
The Residences at Bedford
Our team has verified this companyNewfield - Westover - Turn of River • 1425 Bedford St
1–3 Beds
$2,050–$3,350
- dogs and cats ok
- in-unit laundry
- dishwasher
The Confluence at Norwalk
Our team has verified this companyCentral Norwalk • 26 Belden Ave
1–2 Beds
$2,432–$4,716
- dogs and cats ok
- in-unit laundry
- dishwasher
- dogs and cats ok
- in-unit laundry
- dishwasher
- dogs and cats ok
- in-unit laundry
- dishwasher
5 Bridge St #1, Norwalk, CT, 06855
Our team has verified this companyEast Norwalk • 5 Bridge St #1
2 Beds
$3,850
- dogs and cats ok
- in-unit laundry
- dishwasher
- dogs and cats ok
- in-unit laundry
- dishwasher
Cottage - 37 A Green Acre Lane, Westport, CT, 06880
Our team has verified this companyCottage - 37 A Green Acre Lane
1 Bed
$2,650
- dogs and cats ok
- in-unit laundry
- dishwasher
- dogs and cats ok
- in-unit laundry
- dishwasher
The Residences at Bedford
Our team has verified this companyNewfield - Westover - Turn of River • 1425 Bedford St
1–3 Beds
$2,050–$3,350
- dogs and cats ok
- in-unit laundry
- dishwasher
The Confluence at Norwalk
Our team has verified this companyCentral Norwalk • 26 Belden Ave
1–2 Beds
$2,432–$4,716
- dogs and cats ok
- in-unit laundry
- dishwasher
- dogs and cats ok
- in-unit laundry
- dishwasher
- dogs and cats ok
- in-unit laundry
- dishwasher
5 Bridge St #1, Norwalk, CT, 06855
Our team has verified this companyEast Norwalk • 5 Bridge St #1
2 Beds
$3,850
- dogs and cats ok
- in-unit laundry
- dishwasher
- dogs and cats ok
- in-unit laundry
- dishwasher
Cottage - 37 A Green Acre Lane, Westport, CT, 06880
Our team has verified this companyCottage - 37 A Green Acre Lane
1 Bed
$2,650
- dogs and cats ok
- in-unit laundry
- dishwasher
- dogs and cats ok
- in-unit laundry
- dishwasher
Check availability
Advertisement