(518) 466-9700 Cell
Sign Up Login

5 Shamrock Circle, Latham, NY 12110

New - 4 Hours Ago
View Full Photo Gallery

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!

5 Shamrock Circle | MLS# 202616238

This single family home located at 5 Shamrock Circle, Latham, NY 12110 is currently listed for sale with an asking price of $705,000. This property was built in 1993 and has 6 bedrooms and 3 full and 1 partial baths with 3117 sq. ft. Shamrock Circle is located within the North Colonie (including Maplewood) school district. Search Latham real estate on john-mesko.coldwellbankerprime.com today.

Gallery

Property Features

Property Type: Residential - Single Family
Basement: Finished, Interior Entry
Basement: Yes
Cooling: Central Air
Fireplaces: 1
Garage: 2 car attached
Heating: Forced Air, Natural Gas, Zoned
Home Style: Colonial
Lot Size: 0.28 Acres
Roof Type: Shingle, Asphalt
Taxes: $8,127
Year Built: 1993

Feature Descriptions

Appliances: Dishwasher, Gas Oven, Gas Water Heater, Microwave, Range, Range Hood, Refrigerator, Washer/Dryer
Doors: French Doors, Storm Door(s)
Exterior: Vinyl Siding
Exterior: Drive-Paved, Lighting, Storm Door(s)
Fencing: Back Yard, Partial
Fireplace: Family Room, Wood Burning
Flooring: Vinyl, Carpet, Ceramic Tile, Hardwood
Foundation: Block
Interior: High Speed Internet, Solid Surface Counters, Walk-In Closet(s), Built-in Features, Ceramic Tile Bath, Eat-in Kitchen
Laundry: Laundry Room, Main Level
Lot: Level, Landscaped
Lot Dimensions: 76' x 149'
Parcel #: 012689 31.6-3-44
Parking: Off Street, Paved, Attached, Driveway, Garage Door Opener
Parking Total: 6
Parking Total: 6
Patio/Porch: Covered, Deck, Front Porch
Rooms Total: 19
Security: Smoke Detector(s), Carbon Monoxide Detector(s)
Sewer: Public Sewer
SQFT Above Grade Finished: 3117
SQFT Below Grade Finished: 695
Structures: Shed(s)
Utilities: Cable Connected, Underground Utilities
Water: Public
Windows: Insulated Windows

Room Sizes

Living Room: 18.90 X 12.30 Level - First
Foyer: 11.00 X 6.60 Level - First
Kitchen: 12.00 X 20.50 Level - First
Dining Room: 12.00 X 12.00 Level - First
Family Room: 20.30 X 12.30 Level - First
Half Bathroom: 4.75 X 4.50 Level - First
Laundry: 5.90 X 5.40 Level - First
Mud Room: 5.60 X 5.30 Level - First
Bedroom: 15.80 X 10.50 Level - Second
Primary Bedroom: 18.50 X 11.70 Level - Second
Primary Bathroom: 9.30 X 8.50 Level - Second
Other: 9.30 X 5.50 Level - Second
Full Bathroom: 8.40 X 8.30 Level - Second
Game Room: 26.80 X 19.20 Level - Basement

Local Schools

High School: Shaker HS
School District: North Colonie (including Maplewood)

Estimate Your Payment

Estimated Payment

$ 2,451.90 per month $1,569.02 Principal & Interest $677.25 Property Tax $205.63 Homeowner's Insurance

Change Payment Information

%
years/fixed
yearly
yearly (est.)
(Payments are an estimate and may vary by lender)

Demographics

Listed By / Shown By

Listing By

Agency Name: Howard Hanna Capital Inc
Agency Phone: 1 518-489-1000

Shown By

Agent Name: John W. Mesko
Agent Phone: (518) 466-9700 Cell
Agency Title: Coldwell Banker Prime Properties

IDX logo

Disclaimer: All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided for consumers personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information on this site was last updated 05/01/2026. The listing information on this page last changed on 05/01/2026. The data relating to real estate for sale on this website comes in part from the Internet Data Exchange program of Delta Media Group MLS (last updated Fri 05/01/2026 10:42:59 AM EST) or Global MLS (last updated Fri 05/01/2026 10:38:56 AM EST) or New York State Alliance MLS (last updated Fri 05/01/2026 10:36:10 AM EST) or Hudson Valley Catskill Region MLS (last updated Fri 05/01/2026 10:32:00 AM EST) or OneKey MLS (last updated Fri 05/01/2026 10:35:33 AM EST). Real estate listings held by brokerage firms other than Coldwell Banker Prime Properties may be marked with the Internet Data Exchange logo and detailed information about those properties will include the name of the listing broker(s) when required by the MLS. All rights reserved.

C.B. Prime Properties, Inc. fully supports the principles of the Fair Housing Act and the Equal Opportunity Act. Each franchise is independently owned and operated.

Homestead Funding Corp. Company NMLS# 3232. Equal Housing Lender. State Licensing Information

Coldwell BankerĀ®. All rights reserved. The Coldwell Banker System is comprised of company owned offices which are owned by a subsidiary of Anywhere Advisors LLC and franchised offices. Coldwell Banker Real Estate LLC, fully supports the principles of the Fair Housing Act and the Equal Opportunity Act. Any services or products provided by independently owned and operated franchisees are not provided by, affiliated with, or related to Coldwell Banker Real Estate LLC nor any of its affiliated companies.


Privacy Policy / DMCA Notice / ADA Accessibility

Login to My Homefinder

Pixel