IMMEDIATE OCCUPANCY! Stunning Brand New 4 bed, 2.5 bath Home on a .45-acre lot in heart of Latham! Covered front porch, 9' first-floor ceilings, hardwood floors, designer kitchen with solid surface counters, maple cabinetry w/ soft-close features, stainless steel appliances, large center island, sliding glass door . Convenient location in North Colonie SD. Enjoy a lifestyle of comfort and ease with quick access to shopping, dining, and major highways. Public water and sewer, natural gas.
Closed
$650,000
42 Waterford Avenue, Latham, NY 12110
4beds
2,300sqft
Single Family Residence, Residential
Built in 2025
0.44 Acres Lot
$-- Zestimate®
$283/sqft
$3,481 Estimated rent
Home value
Not available
Estimated sales range
Not available
$3,481/mo
Zestimate® history
Owner options
List your home for rent
$3,481/mo
Rent Zestimate®
Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.
$3,481/mo
Rent Zestimate®
Refinance and save
$4,380/mo
Est. payment
Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.
$4,380/mo
Est. payment
Explore your selling options
Work with a Zillow partner agent
Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.
Get startedList with your own agent
Get your home in front of millions of buyers by listing it on Zillow.
Learn how to do itSell it yourself
Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).
List your homeWhat's special
Covered front porchStainless steel appliancesLarge center islandDesigner kitchenHardwood floorsSliding glass doorSolid surface counters
Zillow last checked:
Listing updated:
Listed by:
John W Mesko 518-466-9700,
Coldwell Banker Prime Properties,
Kimberly H Chapman 518-366-0176,
Coldwell Banker Prime Properties
Bought with:
John W Mesko, 30ME0743299
Coldwell Banker Prime Properties
Source: Global MLS,MLS#: 202611866
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 3
- Full bathrooms: 2
- 1/2 bathrooms: 1
Primary bedroom
- Level: Second
Bedroom
- Level: Second
Bedroom
- Level: Second
Bedroom
- Level: Second
Primary bathroom
- Level: Second
Full bathroom
- Level: Second
Half bathroom
- Level: First
Dining room
- Level: First
Family room
- Level: First
Foyer
- Level: First
Kitchen
- Level: First
Laundry
- Level: Second
Mud room
- Level: First
Heating
- Forced Air, Natural Gas
Cooling
- Central Air
Appliances
- Included: Dishwasher, Microwave, Oven, Range, Refrigerator
Features
- High Speed Internet, Solid Surface Counters, Eat-in Kitchen
- Flooring: Ceramic Tile
- Doors: Sliding Doors
- Basement: Full,Sump Pump
- Number of fireplaces: 1
- Fireplace features: Family Room, Gas
Interior area
- Total structure area: 2,300
- Total interior livable area: 2,300 sqft
- Finished area above ground: 2,300
- Finished area below ground: 0
Property
Parking
- Total spaces: 2
- Parking features: Off Street, Attached
- Attached garage spaces: 2
Features
- Patio & porch: Porch
- Exterior features: Lighting
Lot
- Size: 0.44 Acres
Details
- Parcel number: 012689 19.1428.3
- Special conditions: Standard
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Colonial
- Property subtype: Single Family Residence, Residential
Materials
- Stone, Vinyl Siding
- Roof: Fiberglass
Condition
- New construction: Yes
- Year built: 2025
Details
- Builder model: Seward Mt
Utilities & green energy
- Sewer: Public Sewer
- Water: Public
Community & HOA
HOA
- Has HOA: No
Location
- Region: Latham
Financial & listing details
- Price per square foot: $283/sqft
- Tax assessed value: $1,353
- Annual tax amount: $10,100
- Date on market: 2/11/2026
Price history
| Date | Event | Price |
|---|---|---|
| 6/16/2026 | Sold | $650,000$283/sqft |
Source:  Global MLS #202611866 Report a problem | ||
| 4/1/2026 | Pending sale | $650,000$283/sqft |
Source: Global MLS #202611866 Report a problem | ||
| 3/29/2026 | Price change | $650,000-2.3%$283/sqft |
Source: Global MLS #202611866 Report a problem | ||
| 2/11/2026 | Listed for sale | $665,000-4.3%$289/sqft |
Source: Global MLS #202611866 Report a problem | ||
| 12/16/2025 | Listing removed | $695,000$302/sqft |
Source: Global MLS #202525554 Report a problem | ||
| 9/10/2025 | Listed for sale | $695,000+55.9%$302/sqft |
Source: Global MLS #202525554 Report a problem | ||
| 9/10/2025 | Listing removed | $445,900$194/sqft |
Source: Global MLS #202224901 Report a problem | ||
| 8/17/2022 | Pending sale | $445,900$194/sqft |
Source: Global MLS #202224901 Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2017 | -- | $900 |
| 2016 | -- | $900 |
| 2015 | -- | $900 |
| 2014 | -- | $900 |
| 2013 | -- | $900 |
| 2012 | -- | $900 |
| 2011 | -- | $900 |
| 2010 | -- | $900 |
| 2009 | -- | $900 |
| 2008 | -- | $900 |
| 2007 | -- | $900 |
| 2006 | -- | $900 |
| 2005 | -- | $900 |
| 2004 | -- | $900 |
| 2003 | -- | $900 |
| 2002 | -- | $900 |
| 2001 | -- | $900 |
| 2000 | -- | $900 |
Find assessor info on the county website
Neighborhood: 12110
Nearby homes
- $1,353-- bd-- ba-- sqft36 Cohoes Ave, Latham, NY 12110Off Market
- $3,459-- bd-- ba-- sqft38 Cohoes Ave, Latham, NY 12110Off Market
- $1,353-- bd-- ba-- sqft34 Cohoes Ave, Latham, NY 12110Off Market
- $1,353-- bd-- ba-- sqft40 Cohoes Ave, Latham, NY 12110Off Market
- $699,0004 bd3 ba2.4k sqft44 Waterford Ave, Latham, NY 12110Pending
- $2,707-- bd-- ba-- sqft46 Waterford Ave, Latham, NY 12110Off Market
- $1,353-- bd-- ba-- sqft32 Cohoes Ave, Latham, NY 12110Off Market
- $1,654-- bd-- ba-- sqft30 Cohoes Ave, Latham, NY 12110Off Market
Nearby schools
GreatSchools rating
- 9/10Forts Ferry SchoolGrades: K-5Distance: 1.2 mi
- 8/10Shaker Junior High SchoolGrades: 6-8Distance: 1.3 mi
- 8/10Shaker High SchoolGrades: 9-12Distance: 1.4 mi
Schools provided by the listing agent
- High: Shaker HS
Source: Global MLS. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.
- New York
- Albany County
- Latham
- 12110
- 42 Waterford Avenue
Nearby cities
Nearby zip codes
Other Latham Topics
