Latham, NY 12110 · Albany County

This four-bedroom, two-and-a-half-bath home in Latham sits on 0.37 acres and offers 2,918 square feet of living space. The interior includes a family room with fireplace, full basement, central air, and forced air heating, along with an attached two-car garage. Outside, a concrete patio with built-in fire pit extends entertaining space into the yard. Located near the Shoppes at Latham Circle, dining options, parks, and major highways, the home provides convenient access to both Albany and Saratoga, as well as Albany International Airport.
***OPEN HOUSE SUNDAY 12-2 8/30 *** Welcome to 40 Brookwood Drive, Latham a spacious and inviting home offering room for everyone, both inside and out. Featuring 5 generously sized bedrooms, 3 full bathrooms, and a 2-car attached garage , this home is designed for comfortable everyday living and effortless entertaining. The warm and welcoming family room features a cozy fireplace, creating the perfect gathering space for relaxing evenings. The thoughtfully designed layout flows seamlessly into the living and dining areas, while the 3-season room overlooking the backyard provides the ideal place to enjoy your morning coffee or unwind with friends throughout much of the year. Step outside to a **concrete patio complete with a built-in fire pit**, perfect for hosting summer barbecues or enjoying crisp fall nights under the stars. The partially finished basement offers exceptional bonus space and is a true retreat, featuring two separate exits, a wine cellar**, and a 6-person sauna ideal for entertaining, hobbies, or creating your own private wellness escape. Located in a desirable Latham neighborhood close to shopping, restaurants, parks, and major highways, this home offers the perfect combination of space, comfort, and convenience. Don't miss your opportunity to make this exceptional property your next home!
The price signals we can read on this listing today. For a true sense of value against recent Latham sales, Sharon will pull the comparable closings and walk you through them.
Curious whether this home is priced right for the neighborhood?
Ask Sharon for the comps33 facts pulled straight from the MLS listing.
Google Maps view. Pan, zoom, click a pin to read about a business or place.
Plan a multi-stop route from this address: drop-off the kid, hit the office, head home. Live traffic from Google.
Try a preset
The district this address is assigned to. Ratings and reviews are hosted on GreatSchools.
Assigned districts can change and are not guaranteed. Confirm enrollment boundaries with the district directly before relying on them.
Latham is in Albany County, NY. There are currently 106 active listings here, ranging from $45,000 to $5,200,000. Listings in this address fall under the North Colonie school district. Priced 33% above the Latham median of $487,450.
See Sharon's Latham community guideSharon represents buyers for this property. Your tour, offer, and inquiries go through her, not the listing brokerage.
Field Realty · Listed by Frederick J Field (36)
Contact: 518-495-1877
MLS #202622471 · Source: Global MLS, Inc.
IDX information is provided exclusively for consumers' personal, non-commercial use, that it may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing, and that the data is deemed reliable but is not guaranteed accurate by the MLS. Sharon Fronk Real Estate is committed to compliance with the Fair Housing Act and provides equal opportunity in housing.
Every change captured by Global MLS since this listing went live.
Public assessment record for the Colonie roll · North Colonie school district · One Family Year-Round Residence
| Year | Assessed value | Full market value | Change |
|---|---|---|---|
| 2025 | $187,900 | $430,000 | +9.8% |
| 2024 | $187,900 | $391,458 | +6.3% |
| 2023 | $187,900 | $368,400 | +11.0% |
| 2022 | $185,000 | $331,839 | +5.8% |
| 2021 | $185,000 | $313,559 |
Assessed and full market values come from the local assessor and lag the market; the tax bill is the assessed value times the town, county and school rates, which the seller’s disclosure will show. STAR and other exemptions are not reflected here.
Real numbers from current MLS data. Not a third-party estimate.





Outside FEMA-mapped flood hazard areas
This point is not inside any Special Flood Hazard Area or moderate-risk zone on the current FEMA flood map. Flood insurance is optional here and usually inexpensive.
See the official FEMA flood map for this pointSource: FEMA National Flood Hazard Layer, checked 2026-09-06. Zones are drawn by FEMA and can change; an elevation certificate governs insurance.