Skip To Content

5 Shamrock Circle

Latham, NY 12110
  • $705,000
  • STATUS: Pending
  • MLS #: 202616238
Pending
UPDATED: 66 min ago
$705,000
  • 6
    BEDS
  • 0.28
    ACRES
  • 3
    BATHS
  • 1
    1/2 BATHS
  • 3,117
    SQFT
  • $226
    $/SQFT
Type:
Single-Family Home
Built:
1993
County:
Area:

School Information

High School:

Description

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!

Monthly Payment Calculator



© 2026 Global Multiple Listing Service, Inc. The data relating to real estate on this website comes in part from the Internet Data Exchange program of the GMLS. All information is deemed reliable but not guaranteed and should be independently verified. All properties subject to prior sale, change, or withdrawal. Neither listing broker(s), GMLS shall be responsible for any typographical errors, misinformation, or misprints, and shall be held totally harmless from any damages arising from reliance upon these data. IDX information is provided exclusively for consumers’ personal, non-commercial use and may not be used for any purpose other than to identify prospective properties they may be interested in purchasing. Data last updated 2026-05-13T23:12:08.947.
www.518realty.com/homes/176009887
Print Image

5 Shamrock Circle Latham, NY 12110

  • Price: $705,000
  • Status: Pending
  • On Site: Days
  • Updated: 66 min ago
  • MLS #: 202616238
6
Beds
3
Baths
1
½ Baths
0.28
Acres
3,117
SQFT
$226
$/SQFT
1993
Built
County:
Albany
Area:
Albany
High School:
Shaker Hs
School District:
North Colonie (Including Maplewood)
Property Description
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!
Exterior Features

Architectural Style Colonial Attached Garage YN Yes Construction Materials Vinyl Siding Door Features French DoorsStorm Door(s) Exterior Features Drive-PavedLightingStorm Door(s) Fencing Back YardPartial Foundation Details Block Garage YN Yes Lot Features LevelLandscaped Other Structures Shed(s) Parking Features Off StreetPavedAttachedDrivewayGarage Door Opener Parking Total 6 Patio And Porch Features CoveredDeckFront Porch Pool Features [] Roof ShingleAsphalt View [] Waterfront Features [] Waterfront YN No Window Features Insulated Windows

Interior Features

Appliances DishwasherGas OvenGas Water HeaterMicrowaveRangeRange HoodRefrigeratorWasher/Dryer Basement FinishedInterior Entry Cooling Central Air Cooling YN Yes Fireplace Features Family RoomWood Burning Fireplace YN Yes Fireplaces Total 1 Flooring VinylCarpetCeramic TileHardwood Formal Dining Room Yes Heating Forced AirNatural GasZoned Heating YN Yes Interior Features High Speed InternetSolid Surface CountersWalk-In Closet(s)Built-in FeaturesCeramic Tile BathEat-in Kitchen Laundry Features Laundry RoomMain Level Rooms Living Room (First Level) Foyer (First Level) Kitchen (First Level) Dining Room (First Level) Family Room (First Level) Half Bathroom (First Level) Laundry (First Level) Mud Room (First Level) Bedroom (Second Level) Bedroom (Second Level) Primary Bedroom (Second Level) Primary Bathroom (Second Level) Primary Bedroom (Second Level) Primary Bathroom (Second Level) Other (Second Level) Full Bathroom (Second Level) Bedroom (Second Level) Bedroom (Second Level) Game Room (Basement L

Property Features

Accessibility Features [] Association Amenities [] Association Fee Includes [] Association YN No Current Use [] Electric Underground200+ Amp ServiceCircuit Breakers Green Energy Efficient [] Green Energy Generation [] Green Indoor Air Quality [] Horse Amenities [] Listing Terms [] New Construction YN No Other Equipment [] Property Condition Updated/Remodeled Property Sub Type Single Family Residence Security Features Smoke Detector(s)Carbon Monoxide Detector(s) Sewer Public Sewer Special Listing Conditions Standard Utilities Cable ConnectedUnderground Utilities Water Source Public Zoning Single Residence

Listing information © 2026 Global MLS.
Listing provided courtesy of David Phaff of Howard Hanna Capital Inc: 518-489-1000.



© 2026 Global Multiple Listing Service, Inc. The data relating to real estate on this website comes in part from the Internet Data Exchange program of the GMLS. All information is deemed reliable but not guaranteed and should be independently verified. All properties subject to prior sale, change, or withdrawal. Neither listing broker(s), GMLS shall be responsible for any typographical errors, misinformation, or misprints, and shall be held totally harmless from any damages arising from reliance upon these data. IDX information is provided exclusively for consumers’ personal, non-commercial use and may not be used for any purpose other than to identify prospective properties they may be interested in purchasing. Data last updated 2026-05-13T23:12:08.947.
 
https://bt-photos.global.ssl.fastly.net/capital/1280_boomver_1_202616238-2.jpg https://bt-photos.global.ssl.fastly.net/capital/1280_boomver_1_202616238-2.jpg https://bt-photos.global.ssl.fastly.net/capital/1280_boomver_1_202616238-2.jpg
Logo
518Realty.com Inc.
1571 Central Ave.
Albany NY, 12205