Recently Viewed Properties
See This Home
Save This Listing
Close

$2,700

  • Sold
  • Closed
  • Condo
  • 2 Beds
  • 1 Full Bath
  • 1,095 Sq. Ft.
  • 1 Car Garage
See This Home
Save This Home
See This Home
Save This Home
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.

Full Property Details for 247 Hamilton Ave #APT 2

General

  • Rent: $2,700
  • Status: Closed
  • Type: Condo
  • Source: SMARTMLS
  • MLS ID: 24125355
  • Added to Site: 129 day(s) ago

Rental Information

  • Rental Type: Yearly Unfurnished, Two Years, Three Years
  • Lease Terms: Per Month

Interior

  • Number of Rooms: 4
  • Appliances: Oven/Range, Refrigerator, Dishwasher, Washer, Dryer

Rooms

Bathrooms

  • Total Bathrooms: 1
  • Full Bathrooms: 1

Bedrooms

  • Total Bedrooms: 2
  • Primary Bedroom: Primary Bedroom, Main
  • Bedroom 1: Bedroom, Main

Other Rooms

  • Living Room: Living Room, Main
  • Dining Room: Dining Room, Main
  • Laundry: Main Level

Additional Information

  • Pool: Yes
  • Pool Description: Pool House, In Ground Pool

Parking

  • Garage: Yes
  • Garage Spaces: 1
  • Parking: Carport

Location

  • County: Fairfield
  • Neighborhood: Glenbrook
  • Complex: Heywood Heights
  • Driving Directions: Exit 9 off of I-95 Courtland Ave Heywood Heights on right side.

School Information

  • Elementary School: Julia A. Stark
  • Middle School: Dolan
  • High School: Stamford

Community

  • Community Name: Glenbrook
  • Pet Restrictions: One cat allowed.

Heating & Cooling

  • Cooling Type: Central Air
  • Heating Type: Hot Air, Electric
  • Heating Fuel: Electric
  • Water Heater: Electric, Tank Size Unknown

Utilities

  • Sewer: Public Sewer Connected
  • Water: Public Water Connected

Structural Information

  • Architectural Style: Ranch
  • Construction Status: No/Resale
  • Exterior Const.: Brick
  • Basement Desc.: None
  • Unit on End: Yes
  • Square Feet: 1,095
  • Above Ground: 1,095 Sq. Ft.
  • Year Built: 1970

Lot Features

  • Zoning: R5
  • Lot Description: Corner Lot, Treed, Level Lot, Professionally Landscaped

Financial Considerations

  • Tenant Pays: All Utilities, Credit Check, Liability Insurance

Disclosures and Reports

  • Property ID: 323229

Listed by William Pitt Sotheby's Int'l, Demetrios Frazis
Sold by Houlihan Lawrence, Alec Ciambriello

Listing agent

— 247 Hamilton Ave #APT 2 —

  • Demetrios Frazis

    William Pitt Sotheby's Int'l

Agent Contact: (203) 252-8899 Office Contact: (203) 968-1500

Schools serving 247 Hamilton Ave #APT 2

School District:Stamford School District
NameGradesDistance
Julia A. Stark School
398 Glenbrook Road, Stamford, CT 06906
K-50.6 mi
Dolan School
51 Toms Road, Stamford, CT 06906
6-81.2 mi
Stamford High School
55 Strawberry Hill Avenue, Stamford, CT 06902
9-121 mi
Disclaimer: School attendance boundaries provided by Pitney Bowes and are for reference only. Contact the school directly to verify enrollment eligibility.

Price History for 247 Hamilton Ave #APT 2

Date
Details
Price
Change
Source
11/26/2025
Sold
$2,700
-3.57%
MLS
11/07/2025
Price Reduced
$2,800
-5.08%
MLS
10/06/2025
Price Reduced
$2,950
-7.81%
MLS
9/09/2025
Listed
$3,200
—
MLS
Disclaimer: Historical sales information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.

Listed by William Pitt Sotheby's Int'l, Demetrios Frazis
Sold by Houlihan Lawrence, Alec Ciambriello

Just Listed near 247 Hamilton Ave #APT 2

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

757 Post Rd, Darien, CT 06820 - Photo 1 Just Listed
$45

757 Post Rd  Darien, CT 06820

  • Commercial Lease
  • Active
Listed by DVB Commercial Realty LLC
85 Stephen Mather Rd, Darien, CT 06820 - Photo 1 Just Listed
$1,895,000

85 Stephen Mather Rd  Darien, CT 06820

  • Single Family
  • Active
  • Updated 3 days ago
  • 4
    Beds
  • 3
    Total Baths
  • 2,139
    Sq. Ft.
Listed by Compass Connecticut, LLC
45 Sound Beach Ave Ext, Greenwich, CT 06878 - Photo 1 Just Listed
$1,595,000
Open House

45 Sound Beach Ave Ext  Greenwich, CT 06878

  • Single Family
  • Active
  • Updated 11 hours ago
  • 3
    Beds
  • 2
    Total Baths
  • 1,344
    Sq. Ft.
Listed by Susan Isaak (917) 575-4843
0 Doverton Dr, Greenwich, CT 06831 - Photo 1 Just Listed
$3,500,000

0 Doverton Dr  Greenwich, CT 06831

  • Lots/Land
  • Active
  • Updated 16 hours ago
  • 9.3
    Acres
Listed by Ben Cohen (203) 249-1346

Price Reduced near 247 Hamilton Ave #APT 2

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

33 Halsey Dr, Old Greenwich, CT 06870 - Photo 1 Price Reduced
-$30,000 (-2.01%)
$1,465,000

33 Halsey Dr  Old Greenwich, CT 06870

  • Single Family
  • Active
  • Updated 9 hours ago
  • 3
    Beds
  • 2
    Total Baths
  • 1,655
    Sq. Ft.
Listed by William Raveis Real Estate
33 Halsey Dr, Old Greenwich, CT 06870 - Photo 1 Price Reduced
-$30,000 (-2.01%)
$1,465,000

33 Halsey Dr  Old Greenwich, CT 06870

  • Lots/Land
  • Active
  • Updated 9 hours ago
  • 0.17
    Acres
Listed by William Raveis Real Estate
38 Alexander St, Greenwich, CT 06830 - Photo 1 Price Reduced
-$30,000 (-2.45%)
$1,195,000

38 Alexander St  Greenwich, CT 06830

  • Multi-Family
  • Active
  • Updated 2 days ago
Listed by Barbara Zaccagnini (203) 618-0172 and Steven Zaccagnini (203) 618-0172
50 Church St, Greenwich, CT 06830 - Photo 1 Price Reduced
-$50,000 (-3.13%)
$1,550,000

50 Church St  #5  Greenwich, CT 06830

  • Condo
  • Active
  • Updated 1 day ago
  • 3
    Beds
  • 3
    Total Baths
  • 1,940
    Sq. Ft.
Listed by Barbara Zaccagnini (203) 618-0172 and Steven Zaccagnini (203) 618-0172

Recent Sales near 247 Hamilton Ave #APT 2

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

249 Hamilton Ave, Stamford, CT 06902 - Photo 1 Sold
$2,600

249 Hamilton Ave  #3  Stamford, CT 06902

  • Apartment
  • Closed
  • 2
    Beds
  • 2
    Total Baths
  • 1,173
    Sq. Ft.
Listed and Sold by The Rosato Team
17 Hamilton Ct, Stamford, CT 06902 - Photo 1 Sold
$2,295

17 Hamilton Ct  #C  Stamford, CT 06902

  • Rental
  • Closed
  • 1
    Bed
  • 1
    Total Bath
  • 825
    Sq. Ft.
Listed and Sold by Mary Jane Pastor Realty
59 Courtland Ave, Stamford, CT 06902 - Photo 1 Sold
$3,000

59 Courtland Ave  #APT 3K  Stamford, CT 06902

  • Condo
  • Closed
  • 2
    Beds
  • 2
    Total Baths
  • 1,140
    Sq. Ft.
Listed by Independent Realtors
Sold by Keller Williams Realty
59 Courtland Ave, Stamford, CT 06902 - Photo 1 Sold
$2,450

59 Courtland Ave  #APT 3I  Stamford, CT 06902

  • Condo
  • Closed
  • 1
    Bed
  • 2
    Total Baths
  • 938
    Sq. Ft.
Listed and Sold by William Raveis Real Estate

247 Hamilton Avenue #APT 2, Stamford, CT 06902 (MLS# 24125355) is a Condo property that was sold at $2,700 on November 26, 2025. Want to learn more about 247 Hamilton Avenue #APT 2? 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.