x
Showing 1 of 0
X
Save

247 Hamilton Avenue 3
Stamford CT 06902 US

$4,500

Active Listing ID 24191172
bed icon
3 bed
bath icon
2.00 Bath (2 Full)
home icon
Condominium

$4,500

Active Listing ID 24191172
Save

247 Hamilton Avenue 3 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.

Collapse all

Property Features

  • Facts
  • Property Type: Residential
  • Property Sub-type: Condominium
  • Features
  • Full Bathrooms: 2
  • Cooling System: Central Air

School Information

  • School
  • Julia A. Stark(Elementary)
  • Stamford(HighSchool)

Property

  • propertytype: Residential
  • propertysubtype: Condominium
  • listprice: 4500
  • unparsedaddress: 247 Hamilton Avenue
  • unitnumber: 3
  • postalcity: Stamford
  • stateorprovince: CT
  • country: US
  • postalcode: 06902
  • bathroomsfull: 2
  • bathroomshalf: 0
  • bathroomsonequarter: 0
  • bathroomsthreequarter: 0
  • lotsizeunits: Acres
  • livingarea: 1485
  • livingareaunits: Square Feet
  • latitude: 41.063677
  • longitude: -73.511752
  • listagentfullname: Gedna Jean-Pierre
  • listagentemail: gedna@kw.com
  • listagentkey: 3yd-CTMLS-9234
  • listagentmlsid: 9234
  • listagentpreferredphone: 2039188202
  • listagentofficephone: 2033276700
  • listofficekey: 3yd-CTMLS-3548
  • listofficemlsid: 3548
  • disclaimer: 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.
  • sourcesystemid: CTMLS
  • yearbuilt: 1970
  • listingcontractdate: 2026-07-17
  • listagenturl: http://www.kwcthomes.com
  • countyorparish: Fairfield
  • elementaryschool: Julia A. Stark
  • highschool: Stamford
  • appliances: Electric Range, Microwave, Refrigerator, Dishwasher, Washer, Dryer
  • cooling: Central Air
  • fireplaceyn: False
  • transactiontype: ForRent
  • storiestotal: 0
  • parkingtotal: 2
  • waterfrontyn: False
  • franchiseaffiliation: Keller Williams Realty
  • architecturalstyle: Ranch
  • rooms: Bedroom 1, Bathroom 2, Bathroom 1, Bedroom 3, Bedroom 2
  • dock: False
  • poolprivateyn: False
  • spayn: False
  • internetaddressdisplayyn: True
  • internetautomatedvaluationdisplayyn: True
  • internetconsumercommentyn: True
  • location: -73.51175, 41.06368
  • customfields: {"AdditionalInformation":{}, "AlternatePrices":[], "BrokerName":"Keller Williams Realty", "BuilderEmail":null, "BuilderFax":null, "BuilderPhone":null, "City":null, "Country":null, "CustomSourceId":null, "Expenses":[], "GeocodeOptions":null, "LeadRoutingEmail":"gedna@kw.com", "ListBrokerageCity":"Ridgefield", "ListBrokerageCountry":"US", "ListBrokerageEmail":"rick.scott@kw.com", "ListBrokerageLogoUrl":null, "ListBrokerageName":"Keller Williams Realty", "ListBrokeragePhone":"(203) 438-9494", "ListBrokeragePostalCode":"06877", "ListBrokerageStateOrProvince":"CT", "ListBrokerageUnitNumber":null, "ListBrokerageUnparsedAddress":"404 Main Street", "ListBrokerageWebsiteUrl":"http://www.kwcthomes.com", "ListOfficeAddress1":"2777 Summer Street ", "ListOfficeAddress2":null, "ListOfficeBrokerMlsId":"3548", "ListOfficeCity":"Stamford", "ListOfficeCountry":"US", "ListOfficeEmail":"rick.scott@kw.com", "ListOfficePostalCode":"06905", "ListOfficeStateOrProvince":"CT", "ListPriceCurrencyType":"USD", "ListingTitle":"CONDOS - Stamford, CT", "ListingURL":"https://www.realtor.com/realestateandhomes-detail/247-Hamilton-Ave-Apt-3_Stamford_CT_06902_M37970-40591?f=listhub&s=CTMLS&m=24191172&c=rexren", "MLSModificationTimestamp":"2026-07-17 00:06:48", "Neighborhoods":[{"Description":null, "Name":"Glenbrook"}], "PostalCode":null, "RoomCount":5, "StateOrProvince":null, "Taxes":[], "UnitNumber":null, "UnparsedAddress":null}
Listing Changed: 7/19/2026 11:19:06 AM GMT
Source Updated Date: 7/24/2026 12:47:26 AM GMT

Courtesy of: Gedna Jean-Pierre, Keller Williams Prestige Prop., gedna@kw.com

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.