Skip main navigation
Pending
    • $605,000

    123 Halfmoon Drive, Guilderland, NY 12009

    4beds
    2,604sqft
    Loading
    Single Family Residence, Residential
    Built in 1999
    0.34 Acres Lot
    $639,800 Zestimate®
    $232/sqft
    $17/mo HOA

    What's special

    Fantastic home officeBrand-new garage doorBright wide-open layoutAwesome screened-in porchBeautiful custom-built-insSprinkler system
    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!
    51 days
    |
    183
    |
    0
    |

    Likely to sell faster than

    Zillow last checked:

    Listing updated:

    Listed by:

    KW Platform 518-724-5800,

    Jessica Baxter 518-925-3575

    Source: Global MLS,MLS#: 202618671MLS Logo

      Facts & features

      Interior

      Bedrooms & bathrooms
      • Bedrooms: 4
      • Bathrooms: 3
      • Full bathrooms: 2
      • 1/2 bathrooms: 1
      Primary bedroom
      • Level: Second
      Bedroom
      • Level: Second
      Bedroom
      • Level: Second
      Bedroom
      • Level: Second
      Primary bathroom
      • Level: Second
      Full bathroom
      • Level: Second
      Half bathroom
      • Level: First
      Dining room
      • Level: First
      Family room
      • Level: First
      Kitchen
      • Level: First
      Living room
      • Level: First
      Office
      • Level: First
      Heating
      • Forced Air, Natural Gas
      Cooling
      • Central Air
      Appliances
      • Included: Dishwasher, Microwave, Range, Refrigerator, Washer/Dryer
      • Laundry: Laundry Closet, Main Level
      Features
      • High Speed Internet, Walk-In Closet(s), Eat-in Kitchen
      • Flooring: Tile, Carpet, Laminate
      • Basement: Full,Partial
      • Number of fireplaces: 2
      Interior area
      • Total structure area: 2,604
      • Total interior livable area: 2,604 sqft
      • Finished area above ground: 2,604
      • Finished area below ground: 620
      Video & virtual tour

      Property

      Parking
      • Total spaces: 6
      • Parking features: Paved, Driveway
      • Garage spaces: 2
      • Has uncovered spaces: Yes
      Features
      • Patio & porch: Pressure Treated Deck, Screened, Deck, Front Porch
      • Exterior features: Lighting
      • Pool features: Above Ground
      Lot
      • Size: 0.34 Acres
      • Features: Sloped, Wooded, Cleared
      Details
      • Parcel number: 013089 39.15142
      • Special conditions: Standard

      Construction

      Type & style
      • Home type: SingleFamily
      • Architectural style: Colonial
      • Property subtype: Single Family Residence, Residential
      Materials
      • Vinyl Siding
      • Roof: Asphalt
      Condition
      • New construction: No
      • Year built: 1999

      Utilities & green energy

      • Sewer: Public Sewer
      • Water: Public

      Community & HOA

      HOA
      • Has HOA: Yes
      • Amenities included: None
      • Services included: Other
      • HOA fee: $200 annually
      Location
      • Region: Altamont

      Financial & listing details

      • Price per square foot: $232/sqft
      • Tax assessed value: $528,000
      • Annual tax amount: $10,261
      • Date on market: 6/3/2026

        Estimated market value

        $639,800

        $608,000 - $672,000

        $3,294/mo

        Price history

        DateEventPrice
        6/9/2026Pending sale$605,000$232/sqft
        Source: Global MLS #202618671 Report a problem
        6/3/2026Listed for sale$605,000+221.8%$232/sqft
        Source: Global MLS #202618671 Report a problem
        9/15/1999Sold$188,000$72/sqft
        Source: Public Record Report a problem

        Public tax history

        YearProperty taxesTax assessment
        2025-- $396,000
        2024-- $396,000
        2023-- $396,000
        2022-- $396,000
        2021-- $396,000
        2020-- $396,000
        2019-- $396,000 +38%
        2018-- $287,000
        2017-- $287,000
        2016-- $287,000
        2015-- $287,000
        2014-- $287,000
        2013-- $287,000
        2012-- $287,000
        2011-- $287,000
        2010-- $287,000
        2009-- $287,000 +3.8%
        2008-- $276,500
        2007-- $276,500
        2006-- $276,500
        2005-- $276,500 +47.2%
        2004-- $187,800
        2003-- $187,800
        2002-- $187,800
        2001-- $187,800
        2000-- $187,800
        Find assessor info on the county website

        Monthly payment

        Estimated monthly payment$1,822
        All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
        HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
        Mortgage interest rates are dependent on a number of factors, including credit score, down payment, and repayment length. Interest rate data provided by Zillow Group Marketplace, Inc. as of 1/1/1970 from various mortgage lenders with which we have lead or other similar arrangements; the Estimated Payment is an average of those rates.
        See how much you could borrow to make a competitive offer.
        Get pre-qualified

        Climate risks

        Neighborhood: 12009

        Getting around

        32 / 100
        Car-Dependent
        41 / 100
        Somewhat Bikeable

        Nearby schools

        GreatSchools rating
        Schools provided by the listing agent
        • High: Guilderland

        Source: Global MLS. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.

        A local agent can set up tours, give advice and negotiate with sellers.

        Browse local experts

        Similar homes

            Nearby cities

            Nearby zip codes

            Other Altamont Topics

              Search
              Updates
              Favorites
              Plan
              Inbox