5 Normandy Square
About This Property
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.
Listed By
Payment Calculator
Your Estimated Monthly Payment
Cap Rate Calculator
What does this mean?
Based on our analysis, the cap rate of this property is 1.25%. A negative cap rate indicates that the property might not be feasible as an income-producing asset. The median cap rate for a near zip code 11238 is 4.23%.
How much can I actually make?
Actual monthly rental income may vary between $4,760 and $7,140 depending on unit-specific characteristics. You can change the amount using the slider to further explore.
How is cap rate calculated?
Cap Rate = Net Operating Income (NOI) / Property Asset Value.
When calculating the cap rate, we assume 100% occupancy. Leverage (mortgage) is not considered.
Cap Rate provided by RealtyHop and RentHop, learn more about cap rate here.
Price History
| Date / Event | Date | Event | Price |
|---|---|---|---|
| Oct 12, 2026 | In contract | - | |
| In contract | |||
| Sep 9, 2026 | Price Decreased |
$949,800
↓ $20K
(2.1%) | |
| Price Decreased | |||
| Aug 25, 2026 | Price Decreased |
$969,900
↓ $30K
(3%) | |
| Price Decreased | |||
| Aug 4, 2026 | Relisted | $999,900 | |
| Relisted | |||
| Jul 25, 2026 | In contract | - | |
| In contract | |||
Phone: 425-283-2930
Address: 335 Madison Avenue, New York, NY 10017