5 Shamrock Circle Latham, NY $ 705,000
5 Shamrock Circle
$ 705,000
Recently Listed
Share Save

5 Shamrock Circle

Latham, NY, 12110
$ 705,000
Bedrooms6 Baths3.1 Sq 3,117

Monthly Estimate*

$ 4,341

5 Shamrock Circle, Latham, NY 12110 - Image 1
5 Shamrock Circle, Latham, NY 12110 - Image 2
5 Shamrock Circle, Latham, NY 12110 - Image 3
5 Shamrock Circle, Latham, NY 12110 - Image 4
5 Shamrock Circle, Latham, NY 12110 - Image 5
5 Shamrock Circle, Latham, NY 12110 - Image 6
5 Shamrock Circle, Latham, NY 12110 - Image 7
5 Shamrock Circle, Latham, NY 12110 - Image 8
5 Shamrock Circle, Latham, NY 12110 - Image 9
5 Shamrock Circle, Latham, NY 12110 - Image 10
5 Shamrock Circle, Latham, NY 12110 - Image 11
5 Shamrock Circle, Latham, NY 12110 - Image 12
5 Shamrock Circle, Latham, NY 12110 - Image 13
5 Shamrock Circle, Latham, NY 12110 - Image 14
5 Shamrock Circle, Latham, NY 12110 - Image 15
5 Shamrock Circle, Latham, NY 12110 - Image 16
5 Shamrock Circle, Latham, NY 12110 - Image 17
5 Shamrock Circle, Latham, NY 12110 - Image 18
5 Shamrock Circle, Latham, NY 12110 - Image 19
5 Shamrock Circle, Latham, NY 12110 - Image 20
5 Shamrock Circle, Latham, NY 12110 - Image 21
5 Shamrock Circle, Latham, NY 12110 - Image 22
5 Shamrock Circle, Latham, NY 12110 - Image 23
5 Shamrock Circle, Latham, NY 12110 - Image 24
5 Shamrock Circle, Latham, NY 12110 - Image 25
5 Shamrock Circle, Latham, NY 12110 - Image 26
5 Shamrock Circle, Latham, NY 12110 - Image 27
5 Shamrock Circle, Latham, NY 12110 - Image 28
5 Shamrock Circle, Latham, NY 12110 - Image 29
5 Shamrock Circle, Latham, NY 12110 - Image 30
5 Shamrock Circle, Latham, NY 12110 - Image 31
5 Shamrock Circle, Latham, NY 12110 - Image 32
5 Shamrock Circle, Latham, NY 12110 - Image 33
5 Shamrock Circle, Latham, NY 12110 - Image 34
5 Shamrock Circle, Latham, NY 12110 - Image 35
5 Shamrock Circle, Latham, NY 12110 - Image 36
5 Shamrock Circle, Latham, NY 12110 - Image 37
5 Shamrock Circle, Latham, NY 12110 - Image 38
5 Shamrock Circle, Latham, NY 12110 - Image 39
5 Shamrock Circle, Latham, NY 12110 - Image 40
5 Shamrock Circle, Latham, NY 12110 - Image 41
5 Shamrock Circle, Latham, NY 12110 - Image 42
5 Shamrock Circle, Latham, NY 12110 - Image 43
5 Shamrock Circle, Latham, NY 12110 - Image 44
5 Shamrock Circle, Latham, NY 12110 - Image 45
5 Shamrock Circle, Latham, NY 12110 - Image 46
5 Shamrock Circle, Latham, NY 12110 - Image 47
5 Shamrock Circle, Latham, NY 12110 - Image 48
5 Shamrock Circle, Latham, NY 12110 - Image 49
5 Shamrock Circle, Latham, NY 12110 - Image 50
5 Shamrock Circle, Latham, NY 12110 - Image 51
5 Shamrock Circle, Latham, NY 12110 - Image 52
5 Shamrock Circle, Latham, NY 12110 - Image 53
5 Shamrock Circle, Latham, NY 12110 - Image 54
5 Shamrock Circle, Latham, NY 12110 - Image 55
5 Shamrock Circle, Latham, NY 12110 - Image 56
5 Shamrock Circle, Latham, NY 12110 - Image 57
5 Shamrock Circle, Latham, NY 12110 - Image 58
5 Shamrock Circle, Latham, NY 12110 - Image 59
5 Shamrock Circle, Latham, NY 12110 - Image 60

Single Family Home for sale in Latham, NY

for $705,000 with 6 bedrooms and 3 full baths, 1 half bath. This 3,117 square foot home was built in 1993 on a lot size of 0.28.

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!

See more

Single Family Active

Price

$ 705,000

Bedrooms

6

Full Bath

3

Half Bath

1

Property Type

Single Family

Taxes

$ 8,127

Style

Colonial

Lot Size

0.28

Year Built

1993

Town/City

Latham

County/Region

Albany

MLS | Web ID

202616238

Features
Interior
Interior Amenities High Speed Internet Solid Surface Counters Walk-In Closet(s) Built-in Features Ceramic Tile Bath Eat-in Kitchen
Basement Finished Interior Entry
Flooring Vinyl Carpet Ceramic Tile Hardwood
Total Fireplaces 1
Fireplace Features Family Room Wood Burning
Basement (Y/N) N
Air Conditioning Y/N Y
Heating Y/N Y
Window Features Insulated Windows
Fireplace Y/N Y
Above Grade Finished Area 3117.0
Half Baths 1
Laundry Features Laundry Room Main Level
Total Bedrooms 6
Below Grade Finished Area 695.0
Below Grade Finished Area Source Plans
Above Grade Finished Area Source CRS
Total Baths 4
See more
General
Sewer Public Sewer
Heating Forced Air Natural Gas Zoned
Cooling Central Air
Utilities Cable Connected Underground Utilities
Possession At Closing
Roof Shingle Asphalt
Appliances Dishwasher Gas Oven Gas Water Heater Microwave Range Range Hood Refrigerator Washer/Dryer
Zoning Single Residence
Garage Spaces 2.0
Patio/Porch Features Covered Deck Front Porch
Architectural Style Colonial
Security Features Smoke Detector(s) Carbon Monoxide Detector(s)
Construction Materials Vinyl Siding
Year Built 1993
Electric Underground 200+ Amp Service Circuit Breakers
Property Subtype Single Family Residence
County Albany
New Construction N
Property Type Residential
HOA N
Attached Garage Y
Garage Y/N Y
Other Structures Shed(s)
Total Rooms 19
Full Baths 3
Status Active
Directions I-87 to Exit 5 go towards Rt. 9 on Rt. 155/Watervliet Shaker Rd. Turn left on Doorstone Dr. Next left on Shamrock Circle. House is on right.
High School Shaker HS
City Colonie
High School District North Colonie (including Maplewood)
Lot Size Units Acres
Lot Size Square Feet 12196.8
Carport Y/N N
Land Lease Y/N N
Tax Annual Amount 8127.79
Home Warranty Y/N N
Property Condition Updated/Remodeled
Lease Renewal Y/N N
Additional Parcels Y/N N
Lease Considered Y/N N
Rent Control Y/N N
Standard Status Active
Tax Assessed Value 0
Tax Lot 44.000
See more
Exterior
Exterior Amenities Drive-Paved Lighting Storm Door(s)
Fencing Back Yard Partial
Parking Features Off Street Paved Attached Driveway Garage Door Opener
Lot Features Level Landscaped
Water Source Public
Total Parking 6.0
Lot Size Area 0.28
Foundation Details Block
Spa N
Lot Dimensions 76' x 149'
Lot Size Acres 0.28
Waterfront Y/N N
Door Features French Doors Storm Door(s)
Crops Included Y/N N
Horse Y/N N
Irrigation Water Rights Y/N N
See more
Internal Only
Street Number 1 5
See more
* Excluded Features
List By
David Phaff

Listing Agent

Howard Hanna Capital Inc

Broker

(518) 469-8984

Phone

david@DavidPhaff.com

Email

Affordability Calculator

$5,018
Per Month
87%
13%
0%
Monthly Principal & Interest
$4,341
Monthly Property Taxes
$677
Monthly Home Insurance
--
Default based on a 30-year fixed rate of 6.25% with 20% down. The estimated payment is offered for convenience and is not an offer of credit. Due to market fluctuations, interest rates are subject to change at any time and without notice. Your individual rate may vary. Rates may differ for FHA, VA or jumbo loans.
Learn more about how to save

Discover how much house you can afford

Your dream home may be within reach.

Learn More about how to save

The time to sell is now
THE TIME TO SELL IS NOW! What's my home worth?
Nearby
2591040 Elementary School
2591041 Middle School
Shaker HS High School
Pricing History
DatePricePrice ChangeDescription
5/1/2026$705,000 Listed Price

Map


See all

5 Shamrock Circle, Latham, NY, 12110 is a Single Family Home for sale at $705,000 with 3,117 sqft and a lot size of 0.28. 5 Shamrock Circle has 6 bedrooms, 3.1 baths, and was built in 1993. The property's zip code is 12110 which is in Latham, NY