See Home Value
Albany 12009
123 Halfmoon Drive
$646,000
● House - Off Market

123 Halfmoon Drive

Guilderland, NY 12009
bedrooms
4 Beds
bathrooms
2 Baths, 1 Half Bath
square feet
2,604 Ft²
$3,843
Est. Monthly
$17
HOA / Fees

About This Property

Best and Final Due 6/8 @ 11 AM.

Get ready to fall in love with 123 Halfmoon Drive! Located in one of Guilderland's favorite neighborhoods, this spacious Colonial is the ultimate setup for anyone who loves to host. The main level features a bright, wide-open layout that makes entertaining a breeze. Need a quiet spot to work? There's a fantastic home office on the first floor, complete with beautiful custom-built-ins. You'll love the everyday convenience of first-floor laundry.

Upstairs, you'll find 4 great-sized bedrooms and 2 baths, giving everyone plenty of room. When you're ready to unwind, head out to the awesome screened-in porch -- it's the perfect spot for your morning coffee or a bug-free dinner.

The current owners have taken care of all the big-ticket items, so you don't have to. You get an updated furnace and AC and a brand-new garage door. Outside, the yard looks incredible and stays green all summer long with zero effort thanks to the sprinkler system.

This place is turnkey, super clean, and sitting in a fantastic community close to parks and in the Guilderland school district. All that's left to do is move right in and start making it your own. Come check it out before it's gone!
Unit Size
2,604 Ft²
Days on Market
51 days
Land Size
0.34 acres
Price per sqft
$232
Property Type
House
Property Taxes
$855
HOA Dues
$17
Year Built
1999

Payment Calculator

Cap Rate Calculator

Last updated: 4 months ago (Global MLS #202618671)

Price History

Date / Event Date Event Price
Jul 24, 2026 Sold
Sold
Jun 9, 2026 In contract -
In contract
Jun 2, 2026 Listed by KW Platform $605,000
Listed by KW Platform
Sep 15, 1999 Sold
Sold

Property Highlights

Air Conditioning
Fireplace

Building Info

Overview

    General

  • Year Built: 1999
  • Effective Year Built: 1999
  • Total Rooms: 8
  • Bedroom Count: 4
  • Bathroom Count: 3
  • Full Bathrooms: 2
  • Partial Bathrooms: 3
  • Building Condition: 6
  • Building Quality: 7
  • Construction Type: 0
  • Building Style: 5
  • Exterior Walls Type: 19
  • Interior Walls Type: 0
  • Roof Shape Type: 0
  • Roof Cover Type: 0
  • Floor Count: 200
  • Floor Cover: 0
  • Basement Type: 2
  • Basement Area: 0
  • Garage Type: 1
  • Garage Square Area: 506
  • Parking Space Count: 2
  • Patio Type: 0
  • Porch Type: 6
  • Pool Type: 0

    Dimensions

  • Lot Size Square Feet: 15,000
  • Lot Size Depth Feet: 1,500
  • Lot Size Frontage Feet: 1,000
  • Total Building Area: 2,422
  • Building Area: 2,422
  • Building Area Measurement: L

    Heating and Cooling

  • Fireplace Count: 1
  • Air Conditioning: 1
  • Heating: 3
  • Heated Square Feet: 2,422
  • Heating Fuel Type: 3

    Utilities

  • Sewer System: 1
  • Water Service: 2

Building

  • Building Type: 0
  • Property Class: R
  • Subdivision: WINDMILL ESTATES FINAL SUBDIVISION
  • Land Acres: 0000000344
  • Standard Land Use Code: 1001
  • County Land Use Code: 210
  • Legal Description 1: WINDMILL ESTS PHASE II LOT 123

Neighborhood

  • School District Name: Guilderland Central School District
  • School Tax School District: GUILDERLAND
  • Census Tract: 014611

Zoning

  • Zoning: R20

Geography

  • Account Number: 03901500010420000000
  • District: 013089
  • Section: 39.15
  • Parcel: 013089 39.15-1-42
  • Block: 1
  • Lot: 42.000
  • Municipality: GUILDERLAND (TOV)
  • Latitude: 42.7081
  • Longitude: -73.9283

    Address

  • Full Address: 123 Halfmoon Dr
  • Address - House Number: 123
  • Address - Street Name: Halfmoon
  • Address - Suffix Type: Dr
  • State: NY
  • City Name: Altamont
  • Carrier Code: R003
  • 4-Digit Zip Code: 2500
  • Zip Code: 12009

Valuation

    Tax

  • Tax Year: 2023
  • Tax Amount: $1,074,636
  • Tax Rate Code Area: 013002

    Appraisal Valuation

  • Standard Deviation: 0.1966
  • Valuation Date: Feb 07, 2024
  • Confidence Score: 73
  • Final Value: 528,535
  • High Value: 632,496
  • Low Value: 424,574

    Market Valuation

  • Market Total Value: $465,882
  • Market Land Value: $92,941
  • Market Improvement Value: $372,941

    Assessments Valuation

  • Assessed Year: 2023
  • Assessed Total Value: $396,000
  • Assessed Land Value: $79,000
  • Assessed Improvements Value: $317,000

    Sales

  • Current Sale Contract Date: Jul 22, 1999
  • Current Sale Recording Date: Sep 15, 1999
  • Current Sale Price:
  • Current Sale Document Type: 71
  • Current Sale Input Document Number: CO1172
Data used for valuation calculations is provided by RealtyHop, and other third party sources

Comparables

Unit
Status
Type
Beds
Baths
ft²
Price/ft²
Asking Price
Listed On
Closing Price
Sold On
HOA + Taxes

About Albany


Similar Homes for Sale

Currently no similar homes around

Nearby Rentals

Unit for rent at 2568 Western Avenue, Altamont, NY, 12009

$2,470 /mo

  • 1 Bed
  • 1 Bath
2568 Western Avenue #AKR, Altamont, NY, 12009 Listing by Karen E Laberge
Unit for rent at 5 Okara Drive, Guilderland, NY, 12303

$1,401 /mo

  • Studio
  • 850 ft²
5 Okara Drive #10, Guilderland, NY, 12303 Listing by Jillian Ferrara
Unit for rent at 3545 Carmen Road, Schenectady, NY, 12303

$995 /mo

  • 1 Bed
  • 1 Bath
3545 Carmen Road #35, Schenectady, NY, 12303 Listing by Todd A Drake


Frequently Asked Questions

When was property at 123 Halfmoon Drive built and last sold?
The property at 123 Halfmoon Drive was built in 1999 and last sold on Jul 22, 1999 for $188,000.
How much is this home worth?
The estimated value of the home located at 123 Halfmoon Drive is $604,515.
What are some comparable homes to 123 Halfmoon Drive?
There are currently no comparable homes to 123 Halfmoon Drive.