Date
Details
Price
Change
Source
7/16/2026
Listed
$4,500
—
MLS
Disclaimer: Historical sales information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
1/20
$4,500
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
1/20
Property Description
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.
Full Property Details
Full Property Details for 247 Hamilton Ave #3
General
- Rent: $4,500
- Status: Active
- Type: Condo
- Source: SMARTMLS
- MLS ID: 24191172
- Updated: 7/16/2026
- Added to Site: 7 day(s) ago
Rental Information
- Rental Type: Yearly Unfurnished
- Lease Terms: Per Month
Interior
- Number of Rooms: 5
- Appliances: Electric Range, Microwave, Refrigerator, Dishwasher, Washer, Dryer
Rooms
Bathrooms
- Total Bathrooms: 2
- Full Bathrooms: 2
- Full Bath: Tile Floor, Main
Bedrooms
- Total Bedrooms: 3
- Primary Bedroom: Primary Bedroom - Remodeled, Bedroom Suite, Ceiling Fan, Full Bath, Walk-In Closet, Hardwood Floor, Main
- Bedroom 1: Bedroom - Remodeled, Ceiling Fan, Hardwood Floor, Main
- Bedroom 2: Bedroom - Remodeled, Ceiling Fan, Hardwood Floor, Main
Other Rooms
- Living Room: Living Room - Remodeled, Combination Liv/Din Rm, Sliders, Hardwood Floor, Main
- Dining Room: Dining Room - Remodeled, Hardwood Floor, Main
Additional Information
- Pool: Yes
- Pool Description: In Ground Pool
Parking
- Total Spaces: 2
- Parking: Paved, Off Street Parking, Parking Lot
Location
- County: Fairfield
- Neighborhood: Glenbrook
- Complex: Heywood Heights
- Driving Directions: Enter Heywood Heights from Courtland Ave. 2 stone pillars and sign state Heywood Heights West Entrance. Driveway is ONE WAY. Follow to the last building and unit 247-03 just before exiting to Hamilton Ave.
School Information
- Elementary School: Julia A. Stark
- Middle School: Dolan
- High School: Stamford
Community
- Community Name: Glenbrook
- Pets Allowed: Yes
- Pet Restrictions: Size matters. Ask agent
Heating & Cooling
- Cooling Type: Central Air
- Heating Type: Hot Air, Electric
- Heating Fuel: Electric
- Water Heater: Electric, 50 Gallon Tank
Utilities
- Sewer: Public Sewer Connected
- Water: Public Water Connected
Structural Information
- Architectural Style: Ranch
- Construction Status: No/Resale
- Exterior Const.: Brick
- Basement Desc.: None
- Square Feet: 1,485
- Above Ground: 1,485 Sq. Ft.
- Year Built: 1970
Lot Features
- Zoning: R5
- Lot Description: Level Lot
Financial Considerations
- Tenant Pays: All Utilities, Credit Check, Heat, Hot Water, Liability Insurance
Disclosures and Reports
- Property ID: 319808
Listed by Keller Williams Prestige Prop., Gedna Jean-Pierre
Schools
Schools serving 247 Hamilton Ave #3
School District:Stamford School District
| Name | Grades | Distance |
|---|---|---|
Julia A. Stark School 398 Glenbrook Road, Stamford, CT 06906 | K-5 | 0.6 mi |
Dolan School 51 Toms Road, Stamford, CT 06906 | 6-8 | 1.2 mi |
Stamford High School 55 Strawberry Hill Avenue, Stamford, CT 06902 | 9-12 | 1 mi |
Disclaimer:
School attendance boundaries provided by ATTOM Data Solutions and are for reference only. Contact the school directly to verify enrollment eligibility.
Price History for 247 Hamilton Ave #3
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
- Condo
- Active
- Updated 21 hours ago
- 2Beds
- 1Total Bath
- 1,000Sq. Ft.
- Condo
- Active
- 2Beds
- 2Total Baths
- 1,179Sq. Ft.
Listed by BHHS New England Properties
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
- Condo
- Active
- Updated 3 days ago
- 1Bed
- 2Total Baths
- 960Sq. Ft.
Listed by William Raveis Real Estate
- Single Family
- Active
- Updated 5 days ago
- 6Beds
- 4Total Baths
- 3,731Sq. Ft.
Listed by BHHS New England Properties
- Apartment
- Active
- Updated 1 day ago
- 2Beds
- 1Total Bath
Listed by BHHS New England Properties
- Single Family
- Active
- Updated 1 day ago
- 4Beds
- 3Total Baths
- 2,064Sq. Ft.
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
- Single Family
- Active
- Updated 3 days ago
- 4Beds
- 4Total Baths
- 2,321Sq. Ft.
Listed by Sotheby's International Realty
- Multi-Family
- Active
- Updated 2 days ago
- 4Total Beds
- Single Family
- Active
- Updated 2 days ago
- 5Beds
- 2Total Baths
- 2,047Sq. Ft.
Listed by Kelly Feda (203) 536-0361
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
- Townhouse
- Closed
- Updated 6 days ago
- 2Beds
- 4Total Baths
- 2,398Sq. Ft.
- Townhouse
- Closed
- Updated 9 hours ago
- 3Beds
- 3Total Baths
- 1,635Sq. Ft.
247 Hamilton Avenue #3, Stamford, CT 06902 (MLS# 24191172) is a Condo property with 3 bedrooms and 2 full bathrooms. 247 Hamilton Avenue #3 is currently listed for rent at $4,500 and was received on July 16, 2026. Want to learn more about 247 Hamilton Avenue #3? Do you have questions about finding other real estate for sale or rent in Stamford? You can browse all Stamford rentals or contact a Coldwell Banker agent to request more information.