5 Normandy Square, Altamont, is tucked away on a manicured Cul de sac, this home has all the ''I wants'' and more. Much more! Truly needs to be seen to be appreciated and realized. From the moment you enter the soaring 2 story foyer-great room you will recognize details like the double-trayed 18' LED ceiling, the floor to ceiling windows and fireplace you will realize you are not in your average home. The best is yet to come. The Great room opens into a huge gourmet kitchen with a massive island with beverage cooler putting the perfect chill on your favorite beverage. Can't you just picture it, and don't forget the pot filler! The breakfast nook adjacent to the transitional sunroom opens to an expansive covered patio with stunning woodburning lodge fireplace, raftered ceilings with paddle fans, an all-weather TV, and a natural gas fed built in weber grill kitchen area, perfect for relaxing your cares away in any season. This retreat was built for effortless entertainment and the surprises keep coming. Less than 100 feet away is the most flexible space of all, a 40 X 60 (over 2600 mixed sq ft) accessory dwelling unit with recreational center/ small business headquarters. (Seasonal toy storage, or classic cars, a golf simulator, seriously it's a blank slate.) The ADU has a 2 BR apartment (approx. 1000 SqFt) and 1.5 Baths, great for multigenerational living, guests or office for your homebased business. The entire property has a whole house and ADU generator, so you'll always have access to power. In addition to the over 3780 sq ft natural light filled 4 BR , 3.5 BA main house with a first-floor primary suite, and 3 car garage, there is over 5500 sq ft, and a total of 6 BR, and 4 full, and 2 half baths, with unparalleled flex spaces and newer mechanicals. This is the unicorn, that unique property you have been looking for. You have found that dream, say ''AHHH'', you have arrived home.
Active
$999,900
5 Normandy Square, Guilderland, NY 12009
6beds
3,781sqft
Single Family Residence, Residential
Built in 2004
0.67 Acres Lot
$969,300 Zestimate®
$264/sqft
$-- HOA
What's special
Floor to ceiling windowsUnparalleled flex spacesFirst-floor primary suiteExpansive covered patioBreakfast nookStunning woodburning lodge fireplaceManicured cul de sac
- 23 days |
- 1,520 |
- 101 |
Likely to sell faster than
Zillow last checked:
Listing updated:
Listed by:
RE/MAX Capital 518-724-6800,
Jeffrey P Decatur 518-369-5333
Source: Global MLS,MLS#: 202619915
Loading...
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: $264/sqft
- Tax assessed value: $812,000
- Annual tax amount: $15,596
- Date on market: 6/17/2026
Estimated market value
Zestimate®
$969,300
Estimated sales range
$921,000 - $1.02M
Rent Zestimate®
$4,662/mo
Price history
| Date | Event | Price |
|---|---|---|
| 6/18/2026 | Listed for sale | $999,900+63.9%$264/sqft |
Source: | ||
| 8/1/2018 | Sold | $609,900+24.2%$161/sqft |
Source: | ||
| 1/14/2005 | Sold | $491,000$130/sqft |
Source: | ||
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
Estimated monthly payment$1,822
Principal & interest
$1,547Mortgage insurance
$0Property taxes
$170Home insurance
$105HOA fees
$0Utilities
Not includedAll 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.
Climate risks
Neighborhood: 12009
Nearby schools
GreatSchools rating
- 7/10Lynnwood Elementary SchoolGrades: K-5Distance: 0.3 mi
- 6/10Farnsworth Middle SchoolGrades: 6-8Distance: 3.5 mi
- 9/10Guilderland High SchoolGrades: 9-12Distance: 1.8 mi
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.
- $1,001,9004 bd3 ba4.5k sqft3 Normandy Sq, Altamont, NY 12009Off Market
Save - $800,0005 bd4 ba3.6k sqft7 Normandy Sq, Altamont, NY 12009Sold
Save 
- $431,7002 bd2 ba1.7k sqft5004 Western Tpke, Altamont, NY 12009Off Market
Save - $440,0002 bd2 ba1.9k sqft5008 Western Tpke, Altamont, NY 12009Off Market
Save - $901,3005 bd5 ba4.3k sqft9 Normandy Sq, Altamont, NY 12009Off Market
Save - $805,2004 bd3 ba3.1k sqft1 Normandy Sq, Altamont, NY 12009Off Market
Save - $786,6008 bd3 ba3.3k sqft6 Normandy Sq, Altamont, NY 12009Off Market
Save - $793,7005 bd3 ba3.8k sqft8 Normandy Sq, Altamont, NY 12009Off Market
Save
A local agent can set up tours, give advice and negotiate with sellers.
Similar homes
- $794,9004 bd3 ba2.4k sqft227 Landbridge Drive, Altamont, NY 12009Active
Save
MLS ID #202615544, Dorothy Jones, Listing by: Howard Hanna Capital Inc. Global MLS - $1,169,0004 bd5 ba3.9k sqft268 Boght Road, Watervliet, NY 12189Active
Save
MLS ID #202621305, Kevin Clancy, Listing by: Clancy Real Estate. Global MLS - $659,0004 bd3 ba2.5k sqft1108 Sheldon Drive, Altamont, NY 12009Active
Save
MLS ID #202615596, Kurian Chattathil, Listing by: Empire Plus Real Estate LLC. Global MLS - $649,9005 bd3 ba3.1k sqft240 W Bentwood Court, Albany, NY 12203Active
Save
MLS ID #202621242, Nichole Weston, Listing by: Venture Fox Realty Group LLC. Global MLS - $900,0003 bd3 ba3.5k sqft1 Londonderry Way, Colonie, NY 12309Active
Save MLS ID #202621478, Jamie M Mazuryk, Listing by: Venture Fox Realty Group LLC. Global MLS - $909,0005 bd4 ba3.4k sqft1012 Gideon Trce, Schenectady, NY 12302For Sale
Save MLS ID #11817123, Breia Hunter, Listing by: SimpleList LLC. NY State MLS - $699,9003 bd5 ba2.9k sqft56 Jean Place, Schenectady, NY 12303Active
Save MLS ID #202617180, Giuseppe Tropiano, Listing by: Gucciardo Real Estate LLC. Global MLS - $949,9005 bd5 ba3.8k sqft15 Wildwood Drive, Loudonville, NY 12211Active
Save MLS ID #202618917, Steven J Girvin, Listing by: Howard Hanna Capital Inc. Global MLS - $990,0004 bd4 ba3k sqft13 Devonshire Way, Halfmoon, NY 12065Active
Save MLS ID #202619284, Lucas M Kavanaugh, Listing by: Howard Hanna Capital Inc. Global MLS - $775,0006 bd6 ba3.9k sqft4 Spyglass Hill, Menands, NY 12204Active
Save MLS ID #202621148, Steven J Girvin, Listing by: Howard Hanna Capital Inc. Global MLS - $759,0005 bd4 ba2.9k sqft5504 Tansy Court, Schenectady, NY 12303Active
Save MLS ID #202620528, Andrea Tallman, Listing by: KW Platform. Global MLS - $584,8005 bd3 ba2.9k sqft1037 Timothy Lane, Niskayuna, NY 12309Active
Save MLS ID #202621131, Anthony M Gucciardo, Listing by: Gucciardo Real Estate LLC. Global MLS - $1,160,0004 bd4 ba3.1k sqft150 Bush Drive, East Berne, NY 12059Active
Save MLS ID #202618568, John M Mooney, Listing by: Howard Hanna Capital Inc. Global MLS - $749,9005 bd4 ba3.3k sqft22 Parkside Trail, Ballston Lake, NY 12019Active
Save MLS ID #202621230, Kevin Clancy, Listing by: Clancy Real Estate. Global MLS - $849,9005 bd4 ba3.2k sqft37 Farmview Lane, Waterford, NY 12188Active
Save MLS ID #202620726, Brian L Miranda, Listing by: Miranda Real Estate Group Inc. Global MLS - $924,9004 bd5 ba3.8k sqft9 Lockwood Place, Watervliet, NY 12189Active
Save MLS ID #202616663, Giuseppe Tropiano, Listing by: Gucciardo Real Estate LLC. Global MLS - $549,9003 bd3 ba2.5k sqft703 Maple Lane, Niskayuna, NY 12309Active
Save MLS ID #202619287, Jenn L Baniak-Hollands, Listing by: KW Platform. Global MLS - $1,150,0005 bd4 ba3.6k sqft1 Equestrian Way, Clifton Park, NY 12065Active
Save MLS ID #202619916, Sara L Goodwin Tague, Listing by: Weichert, Realtors - Tri-City Properties. Global MLS - $729,9004 bd3 ba2.7k sqft41 Utica Avenue, Latham, NY 12110Active
Save MLS ID #202621368, Binglin Li, Listing by: KW Platform. Global MLS - $799,9004 bd3 ba4.3k sqft1306 Putnam Road, Schenectady, NY 12306Active
Save MLS ID #202618807, Heidi Rotter, Listing by: Howard Hanna Capital Inc. Global MLS
- Request a tour
as early as today at 7:00 pm
Contact an agent
- New York
- Albany County
- Altamont
- 12009
- 5 Normandy Square