Member Features

Find Real Estate Bargain!

  • Full foreclosure details

  • Home value, equity and ownership info

  • Find homes priced below market

  • Get full access with a FREE Account

Already a member?

$688,900

Listing Price

6beds

3.5baths

3,117sqft

12,197sqft lot

5 Shamrock Cir, Latham, NY 12110

Member Features

Find Real Estate Bargain!

  • Full foreclosure details

  • Home value, equity and ownership info

  • Find homes priced below market

  • Get full access with a FREE Account

Already a member?

For Sale

Single Family

Home type

229.11

Price / sqft

1993

Year built

Home Details

FOR RENT, SALE or Rent with option!! nnExceptional 6-Bedroom Colonial in Sought-After North Colonie Schools.nnWelcome 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.nEnjoy 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.nThe 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.nTruly move-in ready, this exceptional home combines comfort, space, and style all in a prime location!

Interior Details

Square Feet
  • 3117

Bedrooms
  • 6

Bathrooms
  • 3.5

Heating
  • Has Heating:

    Yes

  • Heating Type:

    Central

Cooling
  • Has Cooling:

    Yes

  • Cooling Type:

    Central

Fuel
  • Has Fuel:

    Yes

  • Fuel Type:

    Gas

Basement
  • Has Basement:

    No

  • Basement Type:

    Full

Flooring
  • Has Flooring:

    No

  • Flooring Type:

    N/A

Fireplace
  • Has Fireplace:

    Yes

  • Fireplace Type:

    N/A

Property Details

Lot Size
  • 12197

Water
  • No

Sewer
  • No

Parking
  • Type:

    Garage, Attached

  • Location:

    N/A

  • Status:

    N/A

  • Number of Spaces:

    2

Deck
  • No

Patio
  • No

Fence
  • No

Pool
  • No

Porch
  • No

Stoop
  • No

Breezeway
  • No

Construction Details

Number of Stories
  • 2

Style
  • Colonial

Exterior
  • Aluminum/vinyl

Foundation
  • N/A

Roof
  • N/A

Roofing Material
  • N/A

Tax History

Year

Amount

Land

Improvement

Percent Change

Assessment

2020

$7,565

$51,500

$154,500

--%

$206,000

2018

$7,439

$51,500

$154,500

--%

$206,000

2017

$4,745

$51,500

$154,500

--%

$206,000

2016

$7,199

$51,500

$154,500

--%

$206,000

2015

$7,331

$41,500

$124,500

--%

$166,000

2013

$1,921

$40,000

$120,000

--%

$160,000

2011

$3,197

$40,000

$120,000

--%

$160,000

percent-home-icon

Average Home Price in 12110

Nearby Properties

Zip Code

Price

Bed

Bath

Sqft

Lot

Sold Date

$688,900

6 Beds

3.5 Baths

3,117 Sqft

12,197 Lot (sqft)

Sold 10/06/2026

$824,800

5 Beds

5 Baths

3,164 Sqft

22,216 Lot (sqft)

Sold 09/29/2026

percent-home-icon

Calculators

Mortgage

Mortgage Calculator

Calculate your monthly mortgage payments.
Household Income
70,000
$
Home price
688,900
$
Down payment
137,780
$
Mortgage Rate
6.5
%
Loan Term
Property Tax Rate
1.1
%
Homeowner's Insurance (Annual)
4,133.4
$
HOA (Monthly)
0
$
PMI
0
$
$4,459
Your Payment
Total Monthly Payment:$4,459
Percent of Income:76%
Affordable:No

Details for 5 SHAMROCK CIR

Property Debt

Foreclosure Contact Details

Similar Homes Nearby