HOMESFARMSANDLAND
BuySell
    • Featured Properties
    • Property Showcases
    • Latest Blogs
      • Overview
      • Explore Open Houses
      • Discover Rental Living
      • Escape to Cabin Life
      • Unlock Multi-Family Living
      • Your Perfect Land Awaits
      • Embrace Farm Life
      • Overview
      • Find Rentals
      • Find Cabins
      • Browse Homes
      • Browse Farms
      • Browse Lands
    • Saved Properties
    • Overview
    • Buying Form
    • Buying Process
    • Mortgage Calculator
    • Overview
    • Selling Form
    • Selling Process
    • Free Home Evaluation
      • All of Otsego
      • Cooperstown
      • Oneonta
      • West Oneonta
      • Milford
      • Hartwick
      • Worcester
      • Unadilla
      • Laurens
      • Richfield Springs
      • All of Schoharie
      • Cobleskill
      • Middleburgh
      • Schoharie
      • Sharon Springs
      • Summit
      • Richmondville
      • Esperance
      • All of Chenango
      • Norwich
      • Oxford
      • Greene
      • Bainbridge
      • Sherburne
      • All of Delaware
      • Delhi
      • Stamford
      • Andes
      • Walton
      • Margaretville
      • Roxbury
      • Sidney
      • All of Greene
      • Catskill
      • Windham
      • Hunter
      • Cairo
      • Coxsackie
      • Athens
      • All of Broome
      • Binghamton
      • Vestal
      • Endicott
      • All of Oneida
      • New Hartford
      • Utica
      • Marcy
      • Clinton
      • All of Montgomery
      • Amsterdam
      • Fort Plain
      • Canajoharie
      • Fonda
      • All of Ulster
      • Kingston
      • New Paltz
      • Saugerties
      • Woodstock
      • Marlborough
    • Overview
    • Free Vendor List
    • Practical Guides
    • Need Funding?
    • Property Inspector
    • Down Payment Eligibility
    • Location Sharing?
      • Overview
      • Standard Operating Procedure
      • NYS Buyer-Seller
      • NYS Landlord-Tenant
      • Tenant Rights Notice
      • Fair Housing Notice
      • Privacy Policy
      • Location Services
      • Properties Preferences
      • Map Data Attribution
    • Who We Are
    • Meet the Team
Featured
Featured Properties
Property Showcases
Latest Blogs
Search
Advanced Search
Explore Open Houses
Discover Rental Living
Escape to Cabin Life
Unlock Multi-Family Living
Your Perfect Land Awaits
Embrace Farm Life
Search by Map
Find Rentals
Find Cabins
Browse Homes
Browse Farms
Browse Lands
Saved Properties
Buy
Buying Form
Buying Process
Mortgage Calculator
Sell
Selling Form
Selling Process
Free Home Evaluation
HOMESFARMSANDLAND
  • Otsego
  • Schoharie
  • Chenango
  • Delaware
  • Greene
  • Broome
  • Oneida
  • Montgomery
  • Ulster

Select a county to see cities

Resources
Free Vendor List
Practical Guides
Need Funding?
Property Inspector
Down Payment Eligibility
Location Sharing?
Disclosures
Standard Operating Procedure
NYS Buyer-Seller
NYS Landlord-Tenant
Tenant Rights Notice
Fair Housing Notice
Privacy Policy
Location Services
Properties Preferences
Map Data Attribution
About
Who We Are
Meet the Team

Let's Find Your Next Property.

HOMESFARMSANDLAND.COM

Kevin Lucero

Lic. Real Estate Salesperson

a Charlotteville Realty Team

Independently Owned & Operated

607-282-6242kevin@homesfarmsandland.com

Buying

  • Buying Form
  • Buying Process
  • Mortgage Calculator

Selling

  • Selling Form
  • Selling Process
  • Free Home Evaluation

About Us

  • Who We are
  • Meet the Team

Resources

  • Latest Blogs
  • Free Vendor List
  • PracticalGuides
  • Need Funding?
  • Property Inspector
  • Down Payment Eligibility

Communities

  • Otsego County
  • Schoharie County
  • Chenango County
  • Delaware County
  • Greene County
  • Broome County
  • Oneida County
  • Montgomery County
  • Ulster County

Disclosures

  • Standard Operating Procedure
  • NYS Buyer-Seller
  • NYS Landlord-Tenant
  • Tenant Rights Notice
  • Fair Housing Notice
  • Privacy Policy
  • Location Services
  • Properties Preferences
  • Map Data Attribution

© 2026 Homes, Farms & Land. All rights reserved.

Property at 123 Halfmoon Drive, Guilderland, NY 12009
ACTIVE
0
$605,000

123 Halfmoon DriveGuilderland, NY, 12009

4 Beds2.5 Baths2,604 SqFt0.34 Acres
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!
1 / 57

Est. Monthly

$2,868/MO

$605,000

123 Halfmoon Drive, Guilderland, NY

4 Beds2.5 Baths2,604 SqFt0.34 Acres

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!

StatusActive
Property TypeResidential
Property SubtypeSingle Family Residence
Year Built1999
Total Rooms12 rooms

Est. Monthly Payment

$2,867.68

%
%
yr

Private Mortgage Insurance

Not required

Affordability Checkoptional
$

Enter your annual income to check affordability

Property Details

Property Information

123 Halfmoon Drive

Guilderland, NY 12009 • Albany
4
Beds
2.5
Baths
2,604
SqFt
0.34
Acres
Status
Active
Property Type
Residential
Property Subtype
Single Family Residence
Year Built
199927 years ago
Total Rooms
12 rooms
Tax History
Estimated values, may not reflect current amounts.
  • Annual Tax Amount
    $10,261
Property History
  • Listed for sale
    Jun 3, 2026 • GLOBAL MLS • 202618671
    $605,000
Mortgage Calculator
Estimated monthly payment for this property
$2,867.68
Down Payment
Interest Rate
Loan Term
%
%
yearsyrs.
Affordability Checkoptional
$

Enter your annual income to see if this home fits your budget

Private Mortgage Insurance

Not required — down payment above 20%
MLS Information
  • Source
    Global MLS
  • MLS#
    202618671
  • Listing Office
    KW Platform
  • Last Updated
    5 hours ago

Kitchen & Laundry

  • Kitchen
    • Eat-in Kitchen
    • Modern Kitchen

Appliances

  • Appliances
    • Range
    • Refrigerator
    • Dishwasher
    • Microwave
    • Washer or Dryer

Climate & Systems

  • Heating
    • Natural Gas
    • Forced Air

Interior Features

  • Flooring
    • Carpet
    • Laminate
    • Tile
  • Basement
    • Full
    • Partial
  • Interior Features
    • Walk-In Closet(s)
    • High Speed Internet
    • Eat-in Kitchen

Parking

  • Parking Features
    • Paved
    • Driveway
  • Parking Spaces
    6
  • Garage Spaces
    2

Lot & Grounds

  • Lot Size
    0.34 acres
  • Lot Features
    • Cleared
    • Sloped
    • Wooded
  • Patio & Porch
    • Deck
    • Screened
    • Pressure Treated Deck
    • Front Porch
  • Exterior Features
    Drive-Paved

Type

  • Property Type
    Residential
  • Property Subtype
    Single Family Residence
  • Architectural Style
    Colonial

Structure

  • Construction
    Vinyl Siding
  • Roof
    Asphalt

Condition

  • Year Built
    1999
  • Water
    Public
  • Sewer
    Public Sewer
  • Electric
    200+ Amp Service

607-282-6242, (607) 282-6242, or +1 607 282 6242

Kevin Lucero

Kevin Lucero

Lic. Real Estate Salesperson

CallEmail
Picked for you

Similar Properties

Handpicked listings that match what you're looking at

View all →
  • 4386 Route  50, Saratoga Springs, NY 12866ACTIVE$545,000

    4386 Route 50, Saratoga Springs, NY 12866

    5 Beds3 Baths2,236 SqFt1.58 Acres

    LISTING BY JULIE & CO REALTY LLC

  • 3010 Sunrise Boulevard, Nelson, NY 13061ACTIVE$545,000

    3010 Sunrise Boulevard, Nelson, NY 13061

    3 Beds2.5 Baths1,512 SqFt0.4 Acres

    LISTING BY COLDWELL BANKER FAITH PROPERTIES

  • 6869 Stevens Road, Elbridge, NY 13080ACTIVE$545,000

    6869 Stevens Road, Elbridge, NY 13080

    4 Beds2.5 Baths1,603 SqFt1.7 Acres

    LISTING BY HUNT REAL ESTATE ERA

  • 4335 US Route 11, Richland, NY 13142ACTIVE$545,000

    4335 US Route 11, Richland, NY 13142

    5 Beds2.5 Baths2,716 SqFt1.03 Acres

    LISTING BY CANAAN REALTY

  • 322 Nelson Road, Danby, NY 14850ACTIVE$545,000

    322 Nelson Road, Danby, NY 14850

    4 Beds3 Baths2,047 SqFt1.68 Acres

    LISTING BY WARREN REAL ESTATE OF ITHACA INC.

  • lot 214 Tall Tree Lane Lane, Lysander, NY 13027ACTIVE$545,000

    lot 214 Tall Tree Lane Lane, Lysander, NY 13027

    3 Beds2 Baths1,800 SqFt0.2 Acres

    LISTING BY COLDWELL BANKER PRIME PROP,INC

  • 6685 Curtis Court, Lockport Town, NY 14094ACTIVE$546,900

    6685 Curtis Court, Lockport Town, NY 14094

    2 Beds2 Baths1,924 SqFt0.17 Acres

    LISTING BY MARRANO/MARC EQUITY CORP

  • 12 Berry Patch Lane, Crown Point, NY 12928ACTIVE$547,000

    12 Berry Patch Lane, Crown Point, NY 12928

    2 Beds2 Baths1,111 SqFt0.38 Acres

    LISTING BY COUNTRY ROAD REAL ESTATE

  • 19 Jack Drive, Halfmoon, NY 12118ACTIVE$547,300

    19 Jack Drive, Halfmoon, NY 12118

    3 Beds2 Baths1,550 SqFt0.32 Acres

    LISTING BY COLDWELL BANKER PRIME PROPERTIES

  • LOT 5 Hamilton Way, Schroeppel, NY 13135ACTIVE$547,400

    LOT 5 Hamilton Way, Schroeppel, NY 13135

    3 Beds2.5 Baths2,130 SqFt2.86 Acres

    LISTING BY COLDWELL BANKER PRIME PROP,INC