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 Battery Park CityApartments for rent Downtown BrooklynApartments for rent TribecaApartments for rent Midtown EastApartments for rent Murray HillApartments for rent West VillageApartments for rent Lower East SideApartments 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 Lower East SideHouses for rent Theater DistrictHouses for rent Long Island CityHouses for rent West VillageHouses for rent Downtown BrooklynHouses for rent East VillageHouses for rent RiverdaleHouses for rent Turtle BayHouses for rent HobokenHouses 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
Questions about this property’s policies and fees?
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
- 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 the same as the average rent price for 2-bedroom apartments in Stamford.
Median rents as of Nov 15 2025.
Glenbrook
Stamford
| Month | Median Rent |
|---|---|
| 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,407 |
| October 2025 | $3,210 |
| November 2025 | $3,200 |
| Month | Median Rent |
|---|---|
| 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,790 |
| October 2025 | $2,785 |
| November 2025 | $2,800 |
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
$112,000/yr
With your selected rent-to-income ratio, you'd ideally want to make $112,000 annually to afford this 2-bedrooms monthly rent price of $2,800.
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
Neighborhood
Glenbrook | Stamford, CT
NEIGHBORHOOD VIBE
Peaceful and quiet
Noise-canceling headphones not required in this mostly noise free area.
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.
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 #2, Stamford
Groceries
5/10
At least one supermarket within a 20-minute walk
Shopping
6/10
Several shops within walking distance
Cafes
4/10
Some cafés within walking distance
Restaurants
6/10
Variety of restaurants within a few minutes' walk
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
3/10
Some 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,209–$3,399
The price shown is for a 12-month lease and includes base rent plus any required monthly fees listed by the property.- dogs and cats ok
- in-unit laundry
- air conditioning
The Confluence at Norwalk
Our team has verified this companyCentral Norwalk • 26 Belden Ave
1–2 Beds
$2,337–$3,846
The price shown is for a 12-month lease and includes base rent plus any required monthly fees listed by the property.- dogs and cats ok
- in-unit laundry
- air conditioning
Harbourside SoNo
Our team has verified this company123 Water St
1 Bed
$2,514–$3,468
The price shown is for a 12-month lease and includes base rent plus any required monthly fees listed by the property.- dogs and cats ok
- in-unit laundry
- air conditioning
- dogs and cats ok
- in-unit laundry
- air conditioning
- dogs and cats ok
- in-unit laundry
- air conditioning
Newfield - Westover - Turn of River • 27 Emma Road
2 Beds
$3,000
The price shown is for a 12-month lease and includes base rent plus any required monthly fees listed by the property.- dogs and cats ok
- in-unit laundry
- air conditioning
Shippan Point • 62 Lindstrom Rd
2 Beds
$3,050
The price shown is for a 12-month lease. Fees may apply.- dogs and cats ok
- in-unit laundry
- air conditioning
1 Smith St
2 Beds
$3,400
The price shown is for a 12-month lease. Fees may apply.- dogs and cats ok
- in-unit laundry
- air conditioning
The Residences at Bedford
Our team has verified this companyNewfield - Westover - Turn of River • 1425 Bedford St
1–3 Beds
$2,209–$3,399
The price shown is for a 12-month lease and includes base rent plus any required monthly fees listed by the property.- dogs and cats ok
- in-unit laundry
- air conditioning
The Confluence at Norwalk
Our team has verified this companyCentral Norwalk • 26 Belden Ave
1–2 Beds
$2,337–$3,846
The price shown is for a 12-month lease and includes base rent plus any required monthly fees listed by the property.- dogs and cats ok
- in-unit laundry
- air conditioning
Harbourside SoNo
Our team has verified this company123 Water St
1 Bed
$2,514–$3,468
The price shown is for a 12-month lease and includes base rent plus any required monthly fees listed by the property.- dogs and cats ok
- in-unit laundry
- air conditioning
- dogs and cats ok
- in-unit laundry
- air conditioning
- dogs and cats ok
- in-unit laundry
- air conditioning
Newfield - Westover - Turn of River • 27 Emma Road
2 Beds
$3,000
The price shown is for a 12-month lease and includes base rent plus any required monthly fees listed by the property.- dogs and cats ok
- in-unit laundry
- air conditioning
Shippan Point • 62 Lindstrom Rd
2 Beds
$3,050
The price shown is for a 12-month lease. Fees may apply.- dogs and cats ok
- in-unit laundry
- air conditioning
1 Smith St
2 Beds
$3,400
The price shown is for a 12-month lease. Fees may apply.- dogs and cats ok
- in-unit laundry
- air conditioning
Check availability
Advertisement