$3,100 per month

5 Shamrock Cir Latham, NY 12110

6 Beds
3.5 Baths
3,117 Sq Ft
0.28 Acres

Highlights

  • Deck
  • Wood Flooring
  • Solid Surface Countertops
  • Southgate School Rated A-
  • Mud Room
  • No HOA

About This Home

FOR RENT, SALE or Rent with option!! 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!

Listing Agent

David Phaff

Howard Hanna Capital Inc License #30PH0944178 Listed on: 11/10/2025

Howard Hanna Capital Inc

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $8,575

Year Built

  • Built in 1993 | Remodeled

Lot Details

  • 0.28 Acre Lot
  • Lot Dimensions are 76' x 149'
  • Back Yard Fenced
  • Landscaped
  • Level Lot
  • Property is zoned 02

Parking

  • 2 Car Attached Garage
  • Garage Door Opener
  • Driveway
  • Off-Street Parking

Home Design

  • Vinyl Siding

Interior Spaces

  • Partially Furnished
  • Built-In Features
  • Wood Burning Fireplace
  • Insulated Windows
  • French Doors
  • Mud Room
  • Entrance Foyer
  • Family Room
  • Living Room
  • Dining Room
  • Game Room
  • Basement

Kitchen

  • Gas Oven
  • Range with Range Hood
  • Microwave
  • Dishwasher
  • Solid Surface Countertops

Flooring

  • Wood
  • Carpet
  • Ceramic Tile
  • Vinyl

Bedrooms and Bathrooms

  • 6 Bedrooms
  • Primary bedroom located on second floor
  • Walk-In Closet
  • Bathroom on Main Level
  • Ceramic Tile in Bathrooms

Laundry

  • Laundry Room
  • Washer and Dryer

Home Security

  • Storm Doors
  • Carbon Monoxide Detectors
  • Fire and Smoke Detector

Outdoor Features

  • Deck
  • Covered Patio or Porch
  • Exterior Lighting
  • Shed

Schools

  • Shaker High School

Utilities

  • Forced Air Heating and Cooling System
  • Underground Utilities
  • 200+ Amp Service
  • Gas Water Heater
  • High Speed Internet
  • Cable TV Available

Community Details

  • No Home Owners Association

Listing and Financial Details

  • Assessor Parcel Number 012689 31.6-3-44

Home Details

Home Type

Single Family

Est. Annual Taxes

$8,575

Year Built

Built in 1993 | Remodeled

Lot Details

0

Parking

2

Rental Info

  • Furnished: Partially
  • Available Date: 2025-11-10

Listing Details

  • Property Type: Residential Lease
  • Property Sub Type: Single Family Residence
  • Zoning: 02
  • Year Built: 1993
  • Directions: I-87 to Exit 5, Rt 155/Watervliet Shaker Rd. Head towards Rt. 9 (east). Turn left on Doorstone Ct (South). Left on Shamrock.
  • Above Grade Finished Sq Ft: 3117.0
  • Architectural Style: Single Family
  • Lot Size Acres: 0.28
  • Lot Size: 76' x 149'
  • Parking Features Parking Total: 6.0
  • Full Bathroom Level: Second
  • Half Bathroom Level: First
  • Laundry Room Level: First
  • Other Room Level: Second
  • Primary Bathrooms Level: Second
  • Primary Bedroom Level: Second
  • Garage Yn: Yes
  • Appliances Refrigerators: Yes
  • Flooring:Carpet: Yes
  • Fencing:Back Yard: Yes
  • Flooring:Hardwood: Yes
  • Cooling:Central Air: Yes
  • Appliances Microwave: Yes
  • Flooring:Ceramic Tile: Yes
  • Flooring:Vinyl: Yes
  • Electric:Circuit Breakers: Yes
  • Fencing:Partial2: Yes
  • Special Features: None

Interior Features

  • Flooring: Vinyl, Carpet, Ceramic Tile, Hardwood
  • Interior Amenities: Walk-In Closet(s), High Speed Internet, Solid Surface Counters, Built-in Features, Ceramic Tile Bath
  • Appliances: Dishwasher, Gas Oven, Gas Water Heater, Microwave, Range, Range Hood, Refrigerator, Washer/Dryer
  • Full Bathrooms: 3
  • Half Bathrooms: 1
  • Total Bedrooms: 6
  • Below Grade Sq Ft: 695.0
  • Door Features: French Doors, Storm Door(s)
  • Fireplace Features: Wood Burning, Family Room
  • Fireplaces: 1
  • Living Area: 3117.0
  • Bedroom Level: Second
  • Dining Room Level: First
  • Family Room Level: First
  • Foyer Level: First
  • Kitchen Level: First
  • Living Room Level: First
  • Mud Room Level: First
  • Window Features: Insulated Windows
  • Bathroom Levels Full Bathroom 1: 2nd
  • Bathroom Levels Full Bathroom 2: 2nd
  • Bathroom Levels Full Bathroom 3: 2nd
  • Bathroom Levels Half Bathroom 1: 1st
  • Fireplace: Yes
  • Appliances Dishwasher: Yes
  • Appliances:Gas Oven: Yes
  • Fireplace Features:Wood Burning: Yes
  • Interior Features:High Speed Internet: Yes
  • Appliances:Gas Water Heater: Yes
  • Appliances:Range Hood: Yes
  • Appliances:WasherDryer: Yes
  • Interior Features:Walk-In Closet(s): Yes
  • Interior Features:Ceramic Tile Bath: Yes
  • Interior Features:Solid Surface Counters: Yes
  • Appliances Range: Yes
  • Interior Features:Built-in Features: Yes
  • Fireplace Features:Family Room: Yes

Exterior Features

  • Exterior Features: Lighting
  • Construction Type: Vinyl Siding
  • Fencing: Back Yard, Partial
  • Other Structures: Shed(s)
  • Patio And Porch Features: Covered, Deck, Front Porch
  • Waterfront: No
  • Property Condition: Updated/Remodeled
  • Construction Materials:Vinyl Siding: Yes
  • Patio And Porch Features:Deck: Yes
  • Window Features:Insulated Windows: Yes
  • Lot Features:Landscaped: Yes
  • Lot Features:Level: Yes
  • Door Features:French Doors: Yes
  • Exterior Features:Lighting: Yes
  • Patio And Porch Features:Front Porch: Yes
  • Door Features:Storm Door(s)2: Yes
  • Patio And Porch Features:Covered: Yes

Garage/Parking

  • Garage Spaces: 2.0
  • Parking Features: Off Street, Paved, Attached, Driveway, Garage Door Opener
  • Attached Garage: Yes
  • Total Parking Spaces: 6.0
  • Property Detail:Garage Spaces: 2.0
  • Parking Features:Off Street: Yes
  • Property Detail:Parking YN: Yes
  • Parking Features:Attached: Yes
  • Parking Features:Driveway: Yes
  • Parking Features:Paved: Yes
  • Parking Features:Garage: Yes
  • Parking Features:Garage Door Opener: Yes

Utilities

  • Utilities: Cable Connected, Underground Utilities
  • Cooling: Central Air
  • Electric: Underground, 200+ Amp Service, Circuit Breakers
  • Heating: Forced Air
  • Security: Smoke Detector(s), Carbon Monoxide Detector(s)
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Heating:Forced Air: Yes

Condo/Co-op/Association

  • Association: No
  • Pets Allowed: No

Association/Amenities

  • Parcel Tax HOA:Association YN: No

Schools

  • Junior High Dist: North Colonie (including Maplewood)

Lot Info

  • Lot Features: Level, Landscaped
  • Parcel #: 012689 31.6-3-44
  • Lot Size Sq Ft: 12196.8

MLS Schools

  • HighSchool: Shaker HS

Map

Source: Global MLS

MLS Number: 202529313

Global MLS

APN: 012689-031-006-0003-044-000-0000

New York Albany County Latham 12110

5 Shamrock Cir, Latham, NY

For Rent

Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.

Global MLS IDX information is provided exclusively for 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 is deemed reliable but not guaranteed.



Local REALTOR® - Todd Siegel, Broker - (888)-952-6393

Nearby Homes
David Phaff
Listing Agent
David Phaff
Section Image
Howard Hanna Capital Inc
(518) 675-8378