Come Explore .... 5 Normandy Square, Guilderland, NY 12009 -- tucked away on a manicured cul-de-sac in the Guilderland School District, this custom home has all the ''I wants'' and more. Much more! Truly needs to be seen to be appreciated.
From the moment you enter the soaring two-story foyer-great room, the double-trayed 18' LED ceiling and floor-to-ceiling windows and fireplace tell you this isn't your average Albany County home. The great room opens to a gourmet kitchen with a massive island, beverage cooler, and pot filler. The breakfast nook and transitional sunroom lead to an expansive covered patio with a woodburning lodge fireplace, raftered ceilings, paddle fans, an all-weather TV, and a natural-gas Weber grill kitchen -- built for effortless, entertaining in the shadows of Thatcher Park.
Less than 100 feet away sits the most flexible space of all: a 40'x60' (2,600+ sq ft) accessory dwelling unit with potential for recreation center/small business headquarters, or even light manufacturing. Could be used for car storage, a golf simulator, a theatre, dance studio, it is a blank slate. The ADU includes a 2BR/1.5BA apartment, ideal for multigenerational living, guests, or more offices for a home-based business.
The 3,781 sq ft, natural-light-filled 4BR/3.5BA main house has a first-floor primary suite and 3-car garage. Combined: over 5,500 sq ft, 6 bedrooms, 4 full and 2 half baths, newer mechanicals, and unparalleled flex space near Costco, Hannaford, and all Guilderland/Altamont has to offer.
This is the unicorn -- that unique Altamont, NY property you've been searching for. Stop by fall in love and say ''AHHH'' -- you've arrived home.
Pending
Price cut: $20.1K (9/9)
$949,800
5 Normandy Square, Guilderland, NY 12009
6beds
3,781sqft
Single Family Residence, Residential
Built in 2004
0.67 Acres Lot
$938,500 Zestimate®
$251/sqft
$-- HOA
What's special
Woodburning lodge fireplaceFloor-to-ceiling windowsMassive islandFirst-floor primary suiteExpansive covered patioSoaring two-story foyer-great roomNatural-gas weber grill kitchen
- 69 days
- 1,356
- 49
Zillow last checked:
Listing updated:
Listed by:
Re Max Capital 518-724-6800,
Jeffrey P Decatur 518-369-5333
Source: Global MLS,MLS#: 202619915
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 6
- Bathrooms: 6
- Full bathrooms: 4
- 1/2 bathrooms: 2
Primary bedroom
- Level: First
Bedroom
- Level: Second
Bedroom
- Level: Second
Bedroom
- Level: Second
Bedroom
- Level: First
Bedroom
- Level: First
Half bathroom
- Level: First
Full bathroom
- Level: First
Full bathroom
- Level: Second
Full bathroom
- Level: Second
Full bathroom
- Level: First
Dining room
- Level: First
Foyer
- Level: First
Great room
- Level: First
Kitchen
- Level: First
Kitchen
- Level: First
Living room
- Level: First
Mud room
- Level: First
Office
- Level: First
Other
- Level: First
Heating
- Forced Air, Natural Gas
Cooling
- Central Air
Appliances
- Included: Dishwasher, Disposal, Double Oven, Range, Refrigerator
- Laundry: Laundry Closet, Main Level
Features
- High Speed Internet, Ceiling Fan(s), Tray Ceiling(s), Walk-In Closet(s), Wired for Sound, Ceramic Tile Bath, Chair Rail, Crown Molding, Eat-in Kitchen, Kitchen Island
- Flooring: Ceramic Tile, Hardwood
- Basement: Full,Unfinished,Walk-Out Access
- Number of fireplaces: 2
- Fireplace features: Family Room, Gas, Wood Burning
Interior area
- Total structure area: 3,781
- Total interior livable area: 3,781 sqft
- Finished area above ground: 3,781
- Finished area below ground: 2,600
Video & virtual tour
Property
Parking
- Total spaces: 15
- Parking features: Other, Paved, Attached, Detached, Driveway, Garage Door Opener, Heated Garage
- Attached garage spaces: 4
- Has uncovered spaces: Yes
Features
- Patio & porch: Other, Covered, Patio
- Exterior features: Other, Lighting, Outdoor Kitchen
- Fencing: Back Yard
Lot
- Size: 0.67 Acres
- Features: Level, Cul-De-Sac, Landscaped
Details
- Additional structures: Other, Guest House, Outdoor Kitchen, RV/Boat Storage, Second Garage, Garage(s)
- Parcel number: 013089 39.00131
- Special conditions: Standard
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Colonial,Custom,Other
- Property subtype: Single Family Residence, Residential
Materials
- Stone, Vinyl Siding
- Roof: Shingle,Asphalt
Condition
- New construction: No
- Year built: 2004
Utilities & green energy
- Electric: Circuit Breakers, Generator
- Sewer: Public Sewer
- Water: Public
Community & HOA
Community
- Security: Security System
HOA
- Has HOA: No
Location
- Region: Altamont
Financial & listing details
- Price per square foot: $251/sqft
- Tax assessed value: $812,000
- Annual tax amount: $15,596
- Date on market: 8/4/2026
Estimated market value
$938,500
$892,000 - $985,000
$4,515/mo
Price history
| Date | Event | Price |
|---|---|---|
| 10/12/2026 | Pending sale | $949,800$251/sqft |
Source:  Global MLS #202619915 Report a problem | ||
| 9/9/2026 | Price change | $949,800-2.1%$251/sqft |
Source: Global MLS #202619915 Report a problem | ||
| 8/25/2026 | Price change | $969,900-3%$257/sqft |
Source: Global MLS #202619915 Report a problem | ||
| 8/4/2026 | Listed for sale | $999,900$264/sqft |
Source: Global MLS #202619915 Report a problem | ||
| 7/24/2026 | Pending sale | $999,900$264/sqft |
Source: Global MLS #202619915 Report a problem | ||
| 6/18/2026 | Listed for sale | $999,900+63.9%$264/sqft |
Source: Global MLS #202619915 Report a problem | ||
| 8/1/2018 | Sold | $609,900+24.2%$161/sqft |
Source: Global MLS #201715176 Report a problem | ||
| 1/14/2005 | Sold | $491,000$130/sqft |
Source: Global MLS #24106746 Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | -- | $609,000 |
| 2024 | -- | $609,000 |
| 2023 | -- | $609,000 |
| 2022 | -- | $609,000 |
| 2021 | -- | $609,000 |
| 2020 | -- | $609,000 |
| 2019 | -- | $609,000 +36.2% |
| 2018 | -- | $447,300 |
| 2017 | -- | $447,300 |
| 2016 | -- | $447,300 |
| 2015 | -- | $447,300 |
| 2014 | -- | $447,300 |
| 2013 | -- | $447,300 |
| 2012 | -- | $447,300 |
| 2011 | -- | $447,300 +11.4% |
| 2010 | -- | $401,700 |
| 2009 | -- | $401,700 |
| 2008 | -- | $401,700 |
| 2007 | -- | $401,700 |
| 2006 | -- | $401,700 |
| 2005 | -- | $401,700 +1047.7% |
| 2004 | -- | $35,000 |
| 2003 | -- | $35,000 |
| 2002 | -- | $35,000 |
Find assessor info on the county website
Monthly payment
Climate risks
Neighborhood: 12009
Nearby schools
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.
Similar homes
- $875,0004 bd4 ba3.8k sqft106 Elizabethfield Way, Altamont, NY 12009Active
MLS ID #202623515, Patrick R Bergeron, Listing by: Four Seasons Sothebys International Realty. Global MLS - $899,0005 bd5 ba4.1k sqft3275 E Lydius Street, Guilderland, NY 12303Active
MLS ID #202622916, John Heath, Listing by: Howard Hanna Capital Inc. Global MLS - $749,9004 bd3 ba2.8k sqft806 Greenthorne Boulevard, Guilderland, NY 12303Active
MLS ID #202623421, Patrick Hartman, Listing by: Field Realty. Global MLS - $824,9004 bd3 ba3.9k sqft1 Milan Court, Niskayuna, NY 12309Active
MLS ID #202623941, Bonnie L Sindel, Listing by: Coldwell Banker Prime Properties. Global MLS - $799,0004 bd4 ba4k sqft302 Quidor Court, Slingerlands, NY 12159Active
MLS ID #20265518, Sarah Weloth, Listing by: Miranda Real Estate Group Inc. HVCRMLS
