Elegance coexists w/ comfort in the open concept luxury home by Jeff Almstead w/ captivating Mohawk River views using broad window walls. An open staircase seemlessly connects the 5,078 sf multi-level living space design & a gourmet kitchen & butlers pantry makes for ultimate entertaining. The fabulous 4 BR/3.5 bath home has dramatic architectural details, impressive ceilings, a sunporch, a master suite on each level (nanny, in-law or office w/separate entry), beautiful decks/patios & a 3-car heated garage. Superior Condition
Single-familyProperty Type
1999Year Built
2.4 acresLot Size
$324Est. Price/Sq.Ft.
3 garage spacesParking
Listing by Linda Foglia• KW Platform
•518-281-4445 (agent)
•lindafoglia@kw.com (agent)
Listing by Timothy Mulchy• KW Platform
Bought with Amy Mesch Favreau• Better Homes and Gardens Tech
*Taxable value of land and structures on it ("additions") is determined regularly by local assessors and does not affect market price.
Public record
Public record
Zoning
Beds
3
Baths
2.5
Stories
1
Lot width
—
Lot depth
—
Lot size
2.38 Acres
Year renovated
—
Sq. Ft.
2,922
Year built
1999
Style
Single Family Residential
County
Albany County
APN
012689A00800200020200000000
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Aug 14, 2026.
SFR
Single Family Residential District
The purpose of the Single Family Residential District (SFR) is to provide areas primarily for single-family residential development in the form of detached dwellings. The purpose is to create neighborhoods where people live and conduct their domestic activities. The Single Family Residential District is characterized by traditional suburban residential development.
Property details
Parking
Parking Information
Has Garage
Attached Garage YN: Yes
# of Garage Spaces: 3
# of Parking Total: 7
Parking Features: Off Street, Attached
Interior
Virtual Tour Information
Bathroom Information
# of Bathrooms (Full): 3
# of Bathrooms (Half): 1
# of Bathrooms (Total Integer): 4
Room 1 Information
Type: Primary Bedroom
Room 2 Information
Type: Full Bathroom
Level: First
Room 3 Information
Type: Bedroom
Level: First
Basement Information
Basement: Finished, Full, Sump Pump
Laundry Features
Laundry Features: Main Level
Fireplace Information
Has Fireplace
# of Fireplaces Total: 3
Fireplace Features: Dining Room, Family Room, Gas, Living Room
Interior Features
# of Rooms Total: 3
Interior Features: High Speed Internet, Paddle Fan, Solid Surface Counters, Built-in Features, Central Vacuum
Patio And Porch Features: Deck, Enclosed, Patio, Porch
Roof: Shake
Property Information
Property Sub Type: Single Family Residence
Living Area: 5,078
Construction Materials: Clapboard, Stone
Security Features: Security System
Lot Information
Lot Size Acres: 2.4
Lot Size Square Feet: 104,544
Lot Features: Private, Sloped, Sprinklers In Front, Sprinklers In Rear, Views, Landscaped
Financial
Tax Information
Tax Annual Amount: $21,396
Tax Annual Amount: $21,396
Financial Details: General Taxes: $6,754
Financial Details: School Taxes: $14,642
Utilities
Heating & Cooling
Has Heating
Heating: Forced Air, Natural Gas, Zoned
Has Cooling
Cooling: Central Air
Utility Information
Sewer: Public Sewer
Utilities: Cable Available
Water Source: Public
Location
HOA Information
Has Association
Association Fee: $800
School Information
School District: North Colonie (including Maplewood)
Location Information
Directions: Route 7 West to Forts Ferry Road to right on Onderdonk Avenue to right on Shaker Bay Road. Home is on the right with view of the Mohawk River.
Public facts
Beds: 3
Baths: 2.5
Sq. Ft.: 2,922
Stories: 1.0
Lot Size: 2.38 acres
Style: Single Family Residential
Year Built: 1999
Year Renovated: —
County: Albany County
APN: 012689A00800200020200000000
Home facts updated by county records on Aug 14, 2026
Other
Miscellaneous Information
Other Equipment: Satellite Dish
Around this home
Schools
Boght Hills School
Public K-5 • Assigned • 1.6mi
9/10
Shaker Junior High School
Public 6-8 • Assigned • 3.5mi
8/10
Shaker High School
Public 9-12 • Assigned • 3.6mi
8/10
Provided by GreatSchools
Lifestyle
Provided by Walk Score and Local Logic
Climate risks
1/10 Flood Factor
Minimal risk of a flood reaching the building in the next 30 years
1/10 Fire Factor
Unlikely to be in a wildfire in next 30 years
3/10 Heat Factor
7 days above 97° expected this year, 16 days in 30 years
3/10 Wind Factor
5% chance of strong winds in next 30 years
1/10 Air Factor
0 unhealthy days expected this year, 0 days in 30 years
Provided by First Street
Historical weather
Latham, NY • 12110
Average low and high temperatures (°F)
30
17
32
17
50
30
60
40
68
50
80
60
86
67
81
59
76
55
63
44
49
34
34
21
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Sun exposure
In this area, properties receive around 8.7 hours in
June and 3.5 hours in December, placing it below the
U.S. average for solar exposure.
8.7 hrs
3.5 hrs
JuneDecember
Provided by Shadowmap
Estimated sale price
$1.56M – $1.89M
Sell confidently with a local market expert in Latham. 3 minutes to get started.