Exceptional 6-Bedroom Colonial in Sought-After North Colonie Schools.
Welcome to this beautifully updated Colonial nestled on a peaceful cul-de-sac in the desirable North Colonie School District. This spacious home features six generously sized bedrooms, including two complete primary suites -- perfect for multigenerational living or guests.
Enjoy solid hardwood floors throughout home, complemented by a tiled kitchen and updated baths. The inviting carpeted family room offers a wood-burning fireplace and elegant French doors leading to an oversized deck, ideal for entertaining or relaxing. A covered front porch provides a welcoming space for morning coffee or evening gatherings.
The sun-filled yard offers plenty of space to play, garden, or unwind, including a vegetable garden tucked in the far corner. The finished basement adds valuable living and storage space, while two separate HVAC systems ensure year-round comfort and efficiency.
Truly move-in ready, this exceptional home combines comfort, space, and style -- all in a prime location!
Closed
$710,000
5 Shamrock Circle, Latham, NY 12110
6beds
3,117sqft
Single Family Residence, Residential
Built in 1993
0.28 Acres Lot
$703,500 Zestimate®
$228/sqft
$4,211 Estimated rent
Home value
$703,500
$668,000 - $739,000
$4,211/mo
Zestimate® history
Owner options
List your home for rent
$4,211/mo
Rent Zestimate®
Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.
$4,211/mo
Rent Zestimate®
Refinance and save
$4,780/mo
Est. payment
Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.
$4,780/mo
Est. payment
Explore your selling options
Work with a Zillow partner agent
Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.
Get startedList with your own agent
Get your home in front of millions of buyers by listing it on Zillow.
Learn how to do itSell it yourself
Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).
List your homeWhat's special
Two complete primary suitesWood-burning fireplaceElegant french doorsUpdated bathsInviting carpeted family roomTiled kitchen
Zillow last checked:
Listing updated:
Listed by:
David M Phaff 518-469-8984,
Howard Hanna Capital Inc
Bought with:
Joanne Bongalo, 10301216639
KW Platform
Source: Global MLS,MLS#: 202616238
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 6
- Bathrooms: 4
- Full bathrooms: 3
- 1/2 bathrooms: 1
Primary bedroom
- Description: Hardwood Floors
- Level: Second
- Area: 205.2
- Dimensions: 17.10 x 12.00
Primary bedroom
- Description: Hardwood Floors
- Level: Second
- Area: 216.45
- Dimensions: 18.50 x 11.70
Bedroom
- Description: Hardwood Floors
- Level: Second
- Area: 145.22
- Dimensions: 13.70 x 10.60
Bedroom
- Description: Hardwood Floors
- Level: Second
- Area: 189.04
- Dimensions: 13.90 x 13.60
Bedroom
- Description: Hardwood Floors
- Level: Second
- Area: 168.54
- Dimensions: 15.90 x 10.60
Bedroom
- Description: Hardwood Floors
- Level: Second
- Area: 165.9
- Dimensions: 15.80 x 10.50
Primary bathroom
- Level: Second
- Area: 41.65
- Dimensions: 8.50 x 4.90
Primary bathroom
- Description: Ceramic Tile Floor
- Level: Second
- Area: 79.05
- Dimensions: 9.30 x 8.50
Half bathroom
- Description: Hardwood Parquet Floors
- Level: First
- Area: 21.38
- Dimensions: 4.75 x 4.50
Full bathroom
- Description: Ceramic Tile
- Level: Second
- Area: 69.72
- Dimensions: 8.40 x 8.30
Dining room
- Description: Hardwood Parquet Floors
- Level: First
- Area: 144
- Dimensions: 12.00 x 12.00
Family room
- Description: Carpet
- Level: First
- Area: 249.69
- Dimensions: 20.30 x 12.30
Foyer
- Description: Hardwood Parquet Floors
- Level: First
- Area: 72.6
- Dimensions: 11.00 x 6.60
Game room
- Description: Carpeting
- Level: Basement
- Area: 514.56
- Dimensions: 26.80 x 19.20
Kitchen
- Description: Ceramic Tile
- Level: First
- Area: 246
- Dimensions: 12.00 x 20.50
Laundry
- Description: Vinyl Flooring
- Level: First
- Area: 31.86
- Dimensions: 5.90 x 5.40
Living room
- Description: Hardwood Parquet Floors
- Level: First
- Area: 232.47
- Dimensions: 18.90 x 12.30
Mud room
- Description: Vinyl Flooring
- Level: First
- Area: 29.68
- Dimensions: 5.60 x 5.30
Other
- Description: Walk In Closet - Hardwood
- Level: Second
- Area: 51.15
- Dimensions: 9.30 x 5.50
Heating
- Forced Air, Natural Gas, Zoned
Cooling
- Central Air
Appliances
- Included: Dishwasher, Gas Oven, Gas Water Heater, Microwave, Range, Range Hood, Refrigerator, Washer/Dryer
- Laundry: Laundry Room, Main Level
Features
- High Speed Internet, Solid Surface Counters, Walk-In Closet(s), Built-in Features, Ceramic Tile Bath, Eat-in Kitchen
- Flooring: Vinyl, Carpet, Ceramic Tile, Hardwood
- Doors: French Doors, Storm Door(s)
- Windows: Insulated Windows
- Basement: Finished,Interior Entry
- Number of fireplaces: 1
- Fireplace features: Family Room, Wood Burning
Interior area
- Total structure area: 3,117
- Total interior livable area: 3,117 sqft
- Finished area above ground: 3,117
- Finished area below ground: 695
Property
Parking
- Total spaces: 6
- Parking features: Off Street, Paved, Attached, Driveway, Garage Door Opener
- Attached garage spaces: 2
- Has uncovered spaces: Yes
Features
- Patio & porch: Covered, Deck, Front Porch
- Exterior features: Lighting
- Fencing: Back Yard,Partial
Lot
- Size: 0.28 Acres
- Features: Level, Landscaped
Details
- Additional structures: Shed(s)
- Parcel number: 012689 31.6344
- Zoning description: Single Residence
- Special conditions: Standard
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Colonial
- Property subtype: Single Family Residence, Residential
Materials
- Vinyl Siding
- Foundation: Block
- Roof: Shingle,Asphalt
Condition
- Updated/Remodeled
- New construction: No
- Year built: 1993
Utilities & green energy
- Electric: Underground, Circuit Breakers
- Sewer: Public Sewer
- Water: Public
- Utilities for property: Cable Connected, Underground Utilities
Community & neighborhood
Security
- Security features: Smoke Detector(s), Carbon Monoxide Detector(s)
Location
- Region: Latham
Price history
| Date | Event | Price |
|---|---|---|
| 7/6/2026 | Sold | $710,000+0.7%$228/sqft |
Source:  Global MLS #202616238 Report a problem | ||
| 5/13/2026 | Pending sale | $705,000$226/sqft |
Source: Global MLS #202616238 Report a problem | ||
| 5/1/2026 | Listed for sale | $705,000+2.3%$226/sqft |
Source: Global MLS #202616238 Report a problem | ||
| 12/5/2025 | Listing removed | $688,900$221/sqft |
Source: Global MLS #202527249 Report a problem | ||
| 10/7/2025 | Listed for sale | $688,900+220.4%$221/sqft |
Source: Global MLS #202527249 Report a problem | ||
| 5/25/2018 | Sold | $215,000-33.8%$69/sqft |
Source: Public Record Report a problem | ||
| 7/3/2014 | Sold | $325,000-1.5%$104/sqft |
Source: Global MLS #201407345 Report a problem | ||
| 5/18/2014 | Price change | $330,000-2.7%$106/sqft |
Source: Keller Williams Realty Capital District #201407345 Report a problem | ||
| 4/26/2014 | Listed for sale | $339,000+89.3%$109/sqft |
Source: Keller Williams Realty Capital District #201407345 Report a problem | ||
| 2/18/1994 | Sold | $179,090$57/sqft |
Source: Public Record Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | -- | $206,000 |
| 2024 | -- | $206,000 |
| 2023 | -- | $206,000 |
| 2022 | -- | $206,000 |
| 2021 | -- | $206,000 |
| 2020 | -- | $206,000 |
| 2019 | -- | $206,000 |
| 2018 | -- | $206,000 |
| 2017 | -- | $206,000 |
| 2016 | -- | $206,000 +24.1% |
| 2015 | -- | $166,000 +88.6% |
| 2014 | -- | $88,000 -45% |
| 2013 | -- | $160,000 |
| 2012 | -- | $160,000 |
| 2011 | -- | $160,000 |
| 2010 | -- | $160,000 |
| 2009 | -- | $160,000 |
| 2008 | -- | $160,000 |
| 2007 | -- | $160,000 |
| 2006 | -- | $160,000 |
| 2005 | -- | $160,000 |
| 2004 | -- | $160,000 |
| 2003 | -- | $160,000 |
| 2002 | -- | $160,000 |
| 2001 | -- | $160,000 |
| 2000 | -- | $160,000 |
Find assessor info on the county website
Neighborhood: 12110
Nearby schools
GreatSchools rating
- 6/10Southgate SchoolGrades: K-5Distance: 1.5 mi
- 7/10Shaker Junior High SchoolGrades: 6-8Distance: 1.1 mi
- 8/10Shaker High SchoolGrades: 9-12Distance: 1.2 mi
Schools provided by the listing agent
- High: Shaker HS
Source: Global MLS. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.
Sell for more on Zillow
Get a Zillow Showcase℠ listing at no additional cost and you could sell for .
$703,500
2% more
+$14,070
With Zillow Showcase(estimated)
$717,570
- New York
- Albany County
- Latham
- 12110
- 5 Shamrock Circle
Nearby cities
Nearby zip codes
Other Latham Topics
