$524,999
PENDING

6 Shamrock Cir Latham, NY 12110

Estimated payment $3,447/month

Total Views 2,795
3 Beds
2.5 Baths
2,130 Sq Ft
$246 Price per Sq Ft

Highlights

  • In Ground Pool
  • Colonial Architecture
  • Mud Room
  • Southgate School Rated A-
  • Wood Flooring
  • Stone Countertops

About This Home

BEST & FINAL DUE JULY 1ST BY 8 AM. Pride of ownership shines in this well-maintained Colonial on a .40-acre homesite. The main level features a living room, formal dining room, and a cozy family room with gas fireplace. The kitchen offers great space to cook and gather, with newer stainless steel appliances. Hardwood floors were added in 2 bedrooms, dining room, hallway, and stairs. Step outside to your private backyard oasis with an in-ground pool—ideal for summer fun. Updates include a high-efficiency furnace, water heater, garage doors, and pool with newer liner, pump, filter, and safety cover. Prior day notice. Showings start Saturday at 12.

Listing Agent

Angela Boisvert

Sterling Real Estate Group License #10401329341 Listed on: 06/27/2025

Co-Listing Agent

Lisa Licata

Sterling Real Estate Group License #30LI1114915

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $6,864

Year Built

  • Built in 1994

Lot Details

  • 0.4 Acre Lot
  • Property fronts a private road
  • Cul-De-Sac
  • Wood Fence
  • Back Yard Fenced
  • Landscaped
  • Level Lot
  • Front and Back Yard Sprinklers
  • Cleared Lot

Parking

  • 2 Car Attached Garage
  • Garage Door Opener
  • Driveway

Home Design

  • Colonial Architecture
  • Brick Exterior Construction
  • Block Foundation
  • Vinyl Siding
  • Asphalt

Interior Spaces

  • 2,130 Sq Ft Home
  • 2-Story Property
  • Paddle Fans
  • Gas Fireplace
  • Shutters
  • Sliding Doors
  • Mud Room
  • Entrance Foyer
  • Family Room
  • Living Room
  • Dining Room

Kitchen

  • Eat-In Kitchen
  • Electric Oven
  • Microwave
  • Ice Maker
  • Dishwasher
  • Stone Countertops
  • Disposal

Flooring

  • Wood
  • Carpet
  • Ceramic Tile

Bedrooms and Bathrooms

  • 3 Bedrooms
  • Primary bedroom located on second floor
  • Bathroom on Main Level

Laundry

  • Laundry Room
  • Laundry on main level
  • Washer and Dryer

Unfinished Basement

  • Basement Fills Entire Space Under The House
  • Sump Pump

Home Security

  • Carbon Monoxide Detectors
  • Fire and Smoke Detector

Outdoor Features

  • In Ground Pool
  • Covered Patio or Porch
  • Exterior Lighting

Schools

  • Southgate Elementary School
  • Shaker High School

Utilities

  • Forced Air Heating and Cooling System
  • Heating System Uses Natural Gas
  • 200+ Amp Service
  • Gas Water Heater
  • Cable TV Available

Community Details

  • No Home Owners Association

Listing and Financial Details

  • Legal Lot and Block 39.000 / 3
  • Assessor Parcel Number 012689 31.6-3-39

Home Details

Home Type

Single Family

Est. Annual Taxes

$6,864

Year Built

Built in 1994

Lot Details

0

Parking

2

Listing Details

  • Property Type: Residential
  • Property Sub Type: Single Family Residence
  • Year Built: 1994
  • Directions: Rt 155 East to Doorstone Dr South, left on Shamrock Circle.
  • Above Grade Finished Sq Ft: 2130.0
  • Architectural Style: Colonial
  • Financial Details General Taxes: 2349.33
  • General Taxes Description: Estimated
  • Financial Details School Taxes: 4515.0
  • School Taxes Description: Estimated
  • Lot Size Acres: 0.4
  • New Construction: No
  • Parking Features Parking Total: 4.0
  • Full Bathroom Level: Second
  • Half Bathroom Level: First
  • Laundry Room Level: First
  • Primary Bathrooms Level: Second
  • Primary Bedroom Level: Second
  • Sale Detail Buyer Zip Code: 12205
  • Co List Office Mls Id: o116A
  • Co List Office Phone: 518-688-2211
  • Garage Yn: Yes
  • Appliances Refrigerators: Yes
  • Flooring:Carpet: Yes
  • Laundry Features:Main Level: Yes
  • Architectural Style:Colonial: Yes
  • Fencing:Back Yard: Yes
  • Flooring:Hardwood: Yes
  • Cooling:Central Air: Yes
  • Appliances Microwave: Yes
  • Flooring:Ceramic Tile: Yes
  • Fencing:Fenced: Yes
  • Foundation Details:Block2: Yes
  • Fencing:Wood4: Yes
  • Levels Two: Yes
  • Special Features: None

Interior Features

  • Flooring: Carpet, Ceramic Tile, Hardwood
  • Basement: Full, Sump Pump, Unfinished
  • Interior Amenities: Paddle Fan, Eat-in Kitchen
  • Appliances: Ice Maker, Dishwasher, Disposal, Electric Oven, Gas Water Heater, Microwave, Refrigerator, Washer/Dryer
  • Full Bathrooms: 2
  • Half Bathrooms: 1
  • Total Bedrooms: 3
  • Door Features: Sliding Doors
  • Fireplace Features: Family Room, Gas
  • Fireplaces: 1
  • Living Area: 2130.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: Shutters
  • Bathroom Levels Full Bathroom 1: 2nd
  • Bathroom Levels Full Bathroom 2: 2nd
  • Bathroom Levels Half Bathroom 1: 1st
  • Fireplace: Yes
  • Appliances Dishwasher: Yes
  • Interior Features:Paddle Fan: Yes
  • Appliances:Gas Water Heater: Yes
  • Full Basement: Yes
  • Kitchen Features:Eat-in Kitchen: Yes
  • Appliances:WasherDryer: Yes
  • Basement:Sump Pump: Yes
  • Appliances:Electric Oven: Yes
  • Kitchen Features:Modern Kitchen: Yes
  • Attic Features:Hatch: Yes
  • Fireplace Features:Gas2: Yes
  • Basement:Unfinished: Yes
  • Fireplace Features:Family Room: Yes
  • Appliances:Icemaker: Yes
  • Kitchen Features:Gourmet Kitchen: Yes
  • Interior Features:Stone Countertops: Yes

Exterior Features

  • Exterior Features: Drive-Paved, Lighting
  • Roof: Asphalt
  • Construction Type: Brick, Vinyl Siding
  • Fencing: Wood, Back Yard, Fenced
  • Foundation Details: Block
  • Patio And Porch Features: Covered, Front Porch, Patio
  • Pool Features: In Ground, Outdoor Pool
  • Waterfront: No
  • Construction Materials:Vinyl Siding: Yes
  • Door Features:Sliding Doors: Yes
  • Exterior Features:Drive-Paved: Yes
  • Lot Features:Cul-De-Sac: Yes
  • Patio And Porch Features:Patio: Yes
  • Lot Features:Landscaped: Yes
  • Lot Features:Level: Yes
  • Construction Materials:Brick: Yes
  • Lot Features:Road Frontage: Yes
  • Lot Features:Cleared: Yes
  • Lot Features:Sprinklers In Front: Yes
  • Lot Features:Sprinklers In Rear: Yes
  • Exterior Features:Lighting: Yes
  • Patio And Porch Features:Front Porch: Yes
  • Patio And Porch Features:Covered: Yes
  • Window Features:Shutters: Yes
  • Pool Features:Outdoor Pool: Yes

Garage/Parking

  • Garage Spaces: 2.0
  • Parking Features: Paved, Attached, Driveway, Garage Door Opener
  • Attached Garage: Yes
  • Total Parking Spaces: 4.0
  • Property Detail:Garage Spaces: 2.0
  • 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 Available
  • Sewer: Public Sewer
  • Cooling: Central Air
  • Electric: 200+ Amp Service
  • Heating: Forced Air, Natural Gas
  • Laundry Features: Laundry Room, Main Level
  • Security: Smoke Detector(s), Carbon Monoxide Detector(s)
  • Water Source: Public
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Heating:Forced Air: Yes
  • Heating:Natural Gas: Yes

Condo/Co-op/Association

  • Association: No

Association/Amenities

  • Parcel Tax HOA:Association YN: No

Schools

  • Junior High Dist: North Colonie (including Maplewood)

Lot Info

  • Lot Features: Level, Road Frontage, Sprinklers In Front, Sprinklers In Rear, Cleared, Cul-De-Sac, Landscaped
  • Parcel #: 012689 31.6-3-39
  • Lot Size Sq Ft: 17424.0

Tax Info

  • Tax Annual Amount: 6864.0
  • Tax Block: 3
  • Tax Lot: 39.000
  • Tax Tract: 31.06

MLS Schools

  • Elementary School: Southgate ES
  • HighSchool: Shaker HS

Map

Range of Values:

Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Tax History

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2024 $6,801 $163,000 $40,800 $122,200
2023 $6,710 $163,000 $40,800 $122,200
2022 $6,580 $163,000 $40,800 $122,200
2021 $6,551 $163,000 $40,800 $122,200
2020 $5,944 $163,000 $40,800 $122,200
2019 $3,307 $163,000 $40,800 $122,200
2018 $5,836 $163,000 $40,800 $122,200
2017 $0 $163,000 $40,800 $122,200
2016 $5,645 $163,000 $40,800 $122,200
2015 -- $163,000 $40,800 $122,200
2014 -- $163,000 $40,800 $122,200
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
07/01/2025 07/01/25 Pending -- -- --
06/27/2025 06/27/25 For Sale $524,999 +59.1% $246 / Sq Ft
05/15/2012 05/15/12 Sold $330,000 0.0% $155 / Sq Ft
02/26/2012 02/26/12 Pending -- -- --
02/26/2012 02/26/12 For Sale $330,000 -- $155 / Sq Ft
Source: Global MLS

Purchase History

Date Type Sale Price Title Company
Warranty Deed $239,000 None Available
Warranty Deed $330,000 Chicago Title Insurance Co
Interfamily Deed Transfer -- --
Deed -- --
Deed $162,000 --
Source: Public Records

Mortgage History

Date Status Loan Amount Loan Type
Open $234,671 FHA
Previous Owner $264,000 New Conventional
Previous Owner $25,000 Credit Line Revolving
Source: Public Records

Similar Homes in the area

  • 14 Beechwood Dr, Latham, NY 12110

    $465,000

    • 4 Beds
    • 2.5 Baths
    • 2,096 Sq Ft
    • 14 Beechwood Dr
    • Latham, NY

    The owners have lovingly and meticulously maintained this home for the last 40 years. The kitchen has been updated with custom, quality cherry Kraftsmade cabinets and granite countertops. Plenty of room to entertain with 2 living rooms, one which seamlessly flows into the dining area and offers a gas fp. with built-ins. There are 4 bedrooms, one primary with an en suite, and 2.5 baths. Gorgeous

    Kellie Kieley Kellie Kieley Realty LLC

    Section Image
  • 44 Waterford Ave, Latham, NY 12110

    $465,900

    • 4 Beds
    • 2.5 Baths
    • 2,450 Sq Ft
    • 44 Waterford Ave
    • Latham, NY

    Hodorowski Homes offers 2450 sq ft TBB 4 bedroom, 2.5 bed colonial with 2 story foyer in convenient Latham location (Other plans to choose from as well). Same signature upscale amenities! Including 9' first floor ceilings, granite kitchen counters, maple cabinetry w/self close, hardwd flrs, ceramic baths, stainless appls, inground sprinklers, sod front yard and more. Decorator assistance and

    John Mesko Coldwell Banker Prime Properties

    Section Image
  • 42 Waterford Ave, Latham, NY 12110

    $445,900

    • 4 Beds
    • 2.5 Baths
    • 2,300 Sq Ft
    • 42 Waterford Ave
    • Latham, NY

    Hodorowski Homes offers 2300 sq ft TBB 4 bedroom, 2.5 bed colonial in convenient Latham location (Other plans to choose from as well). Same signature upscale amenities! Including 9' first floor ceilings, granite kitchen counters, maple cabinetry w/self close, hardwd flrs, ceramic baths, stainless appls, inground sprinklers, sod front yard and more. Decorator assistance and builder team

    John Mesko Coldwell Banker Prime Properties

    Section Image
  • 24 Utica Ave, Latham, NY 12110

    $579,900

    • 4 Beds
    • 2.5 Baths
    • 1,850 Sq Ft
    • 24 Utica Ave
    • Latham, NY

    Beautifully maintained 4-year-young colonial in the heart of Latham, located within the highly desirable North Colonie School District. This charming home offers 4 spacious bedrooms, 2.5 baths, and a finished walkout basement (~700 sqft) featuring an office, entertainment room and more. The modern kitchen is equipped with stainless steel appliances, quartz countertops, a large island and a

    Binglin Li KW Platform

    Section Image
  • 4 Orbit Cir, Latham, NY 12110

    $425,000

    • 5 Beds
    • 1,750 Sq Ft
    • 4 Orbit Cir
    • Latham, NY

    Nestled in a prime Latham cul-de-sac lot in North Colonie school district. Sunlight floods the spacious living room, creating a warm and inviting atmosphere. Chef's dream modern kitchen, featuring granite countertops, a stunning backsplash, stainless steel appliances, and soft-close cabinetry. Sliding glass doors to a large, fenced-in backyard, perfect for gatherings. A convenient half bath

    Dawn McCurdy MCCURDY REAL ESTATE GROUP INC

    Section Image
  • 20 Hillard Ln, Latham, NY 12110

    $559,000

    • 3 Beds
    • 2 Baths
    • 1,531 Sq Ft
    • 20 Hillard Ln
    • Latham, NY

    Welcome to Meadowdale Estate! MAINTENANCE FREE COMMUNITY. This ranch was built by Bonaccio Builder in 2020 designed with 100% ADA standards. It features 3BEDS, 2 Full Beds, 1 elevator, open concept, granite countertops, SS appliances, HW floors, gas FP, custom blinds, full basement that can easily be finished for more space. WC Ramps (front/back), concrete walkway around the house, oversized

    Mariana DeLuca Howard Hanna Capital Inc

    Section Image
  • 7 Old Mohawk Place, Latham, NY 12110

    $425,000

    • 3 Beds
    • 2 Baths
    • 2,200 Sq Ft
    • 7 Old Mohawk Place
    • Latham, NY

    Welcome to this conveniently located ranch in the award-winning North Colonie school district. The sun-drenched 4-season room adds year-round enjoyment and extra living space. You will find storage galore in the eat-in-kitchen, perfect for large gatherings. The inviting family room showcases a dramatic wall of oversized windows, perfectly framing views of the sweeping circular driveway and

    Carol Steven Miranda Real Estate Group, Inc

    Section Image
  • 63 Priddle Place, Colonie, NY 12110

    $506,400

    • 3 Beds
    • 2.5 Baths
    • 1,778 Sq Ft
    • 63 Priddle Place
    • Colonie, NY

    To Be Built. Welcome to Meadowdale Estates, a maintenance free community conveniently located in the Town of Colonie, presented by Trojanski Custom Builders and featuring amenities such as full 9' finishable basement w/egress window, granite and quartz selections for your kitchen, gas burning fireplace in the Great Room, wide plank engineered hardwood floors, a first floor Primary Suite and paver

    Sarah Trojanski Sterling Real Estate Group

    Section Image
  • 34 Aspen Rd, Latham, NY 12110

    $499,900

    • 3 Beds
    • 2 Baths
    • 1,592 Sq Ft
    • 34 Aspen Rd
    • Latham, NY

    This home has been meticulously maintained and loved ! There have been many upgrades: main floor opened with new kitchen, hardwood floors throughout the main floor and hallway, newer interior staircase, newer bathrooms. Exterior upgrades include newer front stairs, new shed, IG pool liner, backyard retaining wall. Washer, dryer, hot water replaced in 2020. Nothing to do at 34 Aspen Rd but move

    Frederick Field Field Realty

    Section Image

Source: Global MLS

MLS Number: 202520532

Global MLS

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