5 Shamrock Cir
$3,100
Price
6
Beds
4
Baths
3,117 Sq. Ft.
$12 / Sq. Ft.
3,117
Sq. Ft.
$12
per Sq. Ft.
Cancelled
Cancelled
Description
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...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!
- Listed by David M Phaff • Howard Hanna Capital IncP: (518)-469-8984 david@DavidPhaff.com
Property Details for 5 Shamrock Circle
Architectural Style
Single Family
Zoning02
WaterfrontNo
Parking Total6.00
LISTING UPDATED: 12/05/2025 08:18 AM
Property Details for 5 Shamrock Circle
| Status | Cancelled |
|---|---|
| MLS # | 202529313 |
| Days on Market | 26 |
| Rental Incentives | - |
| Available Date | 11/10/2025 |
| Lease Term | 6 Months |
| Furnished | - |
| Compass Type | Rental |
| MLS Type | Residential Lease / Single Family Residence |
| Year Built | 1993 |
| Lot Size | 0.28 AC / 12,196 SF |
| County | Albany County |
Location
Listing Courtesy of Howard Hanna Capital Inc
Add your commute
Building Information for 5 Shamrock Circle
Building/Complex5 Shamrock CirFloor-Stories-Pet Policy-Pet Policy DetailsNoYear Built1993Building Size-Lot Size0.28 AC / 12,196 SF
Property Information for 5 Shamrock Circle
Summary
Location and General Information
- Postal City: Latham
- 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.
- City: Colonie
- State Or Province: NY
- Postal Code: 12110
- County Or Parish: Albany
- Latitude: 42.74
- Longitude: -73.77
Taxes and HOA
- Association Fee: $.00
- Association: No
- Parcel Number: 012689 31.6-3-44
Parking
- GarageSpaces: 2.00
- Attached Garage: Yes
- Parking Features: Off Street, Paved, Attached, Driveway, Garage Door Opener
School Information
- School District: North Colonie (including Maplewood)
- High School: Shaker HS
Property
Property and Assessments
- Property Type: Residential Lease
- Property Type Label: Residential Lease
Lot Information
- Lot Features: Level, Landscaped
- Year Built: 1993
- Lot Size Dimensions: 76' x 149'
- Above Grade Finished Area: 3117.0
- Above Grade Finished Area Source: CRS
- Below Grade Finished Area: 695.0
- Below Grade Finished Area Source: See Remarks
- Lot Size Acres: 0.28
- Lot Size Area: 0.28
- Lot Size Units: Acres
- Lot Size Square Feet: 12196.8
Building Information
- Living Area: 3117.0
Utilities
- Utilities: Cable Connected, Underground Utilities
- Separate Utilities : Gas: Yes
Interior and Exterior Features
Exterior Features
- Security Features: Smoke Detector(s), Carbon Monoxide Detector(s)
- Window Features: Insulated Windows
- Patio And Porch Features: Covered, Deck, Front Porch
- Other Structures: Shed(s)
- Exterior Features: Lighting
- Fencing: Back Yard, Partial
Interior Features
- Interior Features: Walk-In Closet(s), High Speed Internet, Solid Surface Counters, Built-in Features, Ceramic Tile Bath
- Heating: Forced Air
- Flooring: Vinyl, Carpet, Ceramic Tile, Hardwood
- Electric: Underground, 200+ Amp Service, Circuit Breakers
- Construction Materials: Vinyl Siding
- Cooling: Central Air
- Door Features: French Doors, Storm Door(s)
- Cooling: Yes
- Heating: Yes
- Fireplace: Yes
- Appliances: Dishwasher, Gas Oven, Gas Water Heater, Microwave, Range, Range Hood, Refrigerator, Washer/Dryer
- Fireplace Features: Wood Burning, Family Room
- Fireplaces Total: 1
- Dining Room Type : Formal Dining Room: Yes
Room Information
Room Information
- Rooms Total: 19
- Room Type: Living Room, Foyer, Kitchen, Dining Room, Family Room, Half Bathroom, Laundry, Mud Room, Bedroom, Primary Bathroom, Primary Bedroom, Other, Full Bathroom, Game Room
Bathrooms
- Bathrooms Total Integer: 4
- Bathrooms Total Decimal: 3.50
- Bathrooms Total Notational: 3.10
- Bedrooms Total: 6
- Bathrooms Full: 3
- Bathrooms Half: 1
Room 1
- RoomType: Living Room
- RoomLevel: First
- RoomLength: 18.90
- RoomWidth: 12.30
- RoomDescription: Hardwood Parquet Floors
Room 2
- RoomType: Foyer
- RoomLevel: First
- RoomLength: 11.00
- RoomWidth: 6.60
- RoomDescription: Hardwood Parquet Floors
Room 3
- RoomType: Kitchen
- RoomLevel: First
- RoomLength: 12.00
- RoomWidth: 20.50
- RoomDescription: Ceramic Tile
Room 4
- RoomType: Dining Room
- RoomLevel: First
- RoomLength: 12.00
- RoomWidth: 12.00
- RoomDescription: Hardwood Parquet Floors
Room 5
- RoomType: Family Room
- RoomLevel: First
- RoomLength: 20.30
- RoomWidth: 12.30
- RoomDescription: Carpet
Room 6
- RoomType: Half Bathroom
- RoomLevel: First
- RoomLength: 4.75
- RoomWidth: 4.50
- RoomDescription: Hardwood Parquet Floors
Room 7
- RoomType: Laundry
- RoomLevel: First
- RoomLength: 5.90
- RoomWidth: 5.40
- RoomDescription: Vinyl Flooring
Room 8
- RoomType: Mud Room
- RoomLevel: First
- RoomLength: 5.60
- RoomWidth: 5.30
- RoomDescription: Vinyl Flooring
Room 9
- RoomType: Bedroom
- RoomLevel: Second
- RoomLength: 13.70
- RoomWidth: 10.60
- RoomDescription: Hardwood Floors
Room 10
- RoomType: Bedroom
- RoomLevel: Second
- RoomLength: 13.90
- RoomWidth: 13.6
- RoomDescription: Hardwood Floors
Room 11
- RoomType: Primary Bathroom
- RoomLevel: Second
- RoomLength: 17.10
- RoomWidth: 12.00
- RoomDescription: Hardwood Floors
Room 12
- RoomType: Primary Bedroom
- RoomLevel: Second
- RoomLength: 8.50
- RoomWidth: 4.90
Room 13
- RoomType: Primary Bathroom
- RoomLevel: Second
- RoomLength: 18.50
- RoomWidth: 11.70
- RoomDescription: Hardwood Floors
Room 14
- RoomType: Primary Bedroom
- RoomLevel: Second
- RoomLength: 9.30
- RoomWidth: 8.50
- RoomDescription: Ceramic Tile Floor
Room 15
- RoomType: Other
- RoomLevel: Second
- RoomLength: 9.30
- RoomWidth: 5.5
- RoomDescription: Walk In Closet - Hardwood
Room 16
- RoomType: Full Bathroom
- RoomLevel: Second
- RoomLength: 8.40
- RoomWidth: 8.30
- RoomDescription: Ceramic Tile
Room 17
- RoomType: Bedroom
- RoomLevel: Second
- RoomLength: 15.90
- RoomWidth: 10.60
- RoomDescription: Hardwood Floors
Room 18
- RoomType: Bedroom
- RoomLevel: Second
- RoomLength: 15.80
- RoomWidth: 10.50
- RoomDescription: Hardwood Floors
Room 19
- RoomType: Game Room
- RoomLevel: Basement
- RoomLength: 26.80
- RoomWidth: 19.20
- RoomDescription: Carpeting
Unit Information
Unit 1
- Unit Detail : Kitchen: True
Rental
Rental Information
- Pets Allowed: No
- Pets Allowed : No: Yes
Property History for 5 Shamrock Circle
| Date | Event & Source | Price | Appreciation |
|---|---|---|---|
| Nov 8, 2025 | Listed (Active) GLOBAL MLS #202529313 | $3,100 | — |
| Date | Event & Source | Price |
|---|---|---|
| 11/08/2025 | Listed (Active) GLOBAL MLS #202529313 | $3,100 |
For completeness, Compass often displays two records for one sale: the MLS record and the public record.
Schools near 5 Shamrock Circle
This home is within North Colonie Central School District.
Rating | School | Type | Grades | Distance |
|---|---|---|---|---|
| Public - | K to 5 | |||
| Public - | 6 to 8 | |||
| Public - | 9 to 12 | |||
| Private - | PK to 12 |
Rating | School | Distance |
|---|---|---|
Southgate School PublicK to 5 | ||
Shaker Junior High School Public6 to 8 | ||
Shaker High School Public9 to 12 | ||
Latham Christian Academy PrivatePK to 12 |
School ratings and boundaries are provided by GreatSchools.org and Pitney Bowes. This information should only be used as a reference. Proximity or boundaries shown here are not a guarantee of enrollment. Please reach out to schools directly to verify all information and enrollment eligibility.
No guarantee, warranty or representation of any kind is made regarding the completeness or accuracy of descriptions or measurements (including square footage measurements and property condition), such should be independently verified, and Compass expressly disclaims any liability in connection therewith. Photos may be virtually staged or digitally enhanced and may not reflect actual property conditions. Offers of compensation are subject to change at the discretion of the owner. No financial or legal advice provided. Equal Housing Opportunity.
Listing Courtesy of Howard Hanna Capital Inc
©2025 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.
