$644,400
SOLD AUG 8, 2025

40 Waterford Ave Latham, NY 12110

4 Beds
2.5 Baths
2,600 Sq Ft
0.44 Acres

Recently Sold

$248 Per Sq Ft

38% Above List Price

0 Day on Market

Highlights

  • New Construction
  • Colonial Architecture
  • Stone Countertops
  • Forts Ferry School Rated A-
  • Mud Room
  • No HOA

About This Home

As of August 2025

Hodorowski Homes offers 2450 sq ft TBB 4 bedroom, 2.5 bed colonial with 2 story foyer in convenient Latham location (Other plans to choose from as well). Same signature upscale amenities! Including 9' first floor ceilings, granite kitchen counters, maple cabinetry w/self close, hardwd flrs, ceramic baths, stainless appls, inground sprinklers, sod front yard and more. Decorator assistance and builder team involvement throughout. North Colonie Schools. Photo examples of finishes.

Last Agent to Sell the Property

John Mesko

Coldwell Banker Prime Properties License #30ME0743299 Listed on: 07/27/2022

Coldwell Banker Prime Properties

Last Buyer's Agent

Daniel Reilly

Red Door Realty NY Inc

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $10,500

Year Built

  • Built in 2023 | New Construction

Lot Details

  • 0.44 Acre Lot

Parking

  • 2 Car Attached Garage
  • Off-Street Parking

Home Design

  • Colonial Architecture
  • Fiberglass Roof
  • Stone Siding
  • Vinyl Siding

Interior Spaces

  • 2,600 Sq Ft Home
  • Gas Fireplace
  • Sliding Doors
  • Mud Room
  • Entrance Foyer
  • Family Room
  • Dining Room
  • Ceramic Tile Flooring

Kitchen

  • Eat-In Kitchen
  • Oven
  • Range
  • Microwave
  • Dishwasher
  • Stone Countertops

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Primary bedroom located on second floor
  • Walk-In Closet
  • Bathroom on Main Level
  • Ceramic Tile in Bathrooms

Laundry

  • Laundry Room
  • Laundry on upper level

Basement

  • Basement Fills Entire Space Under The House
  • Sump Pump

Outdoor Features

  • Exterior Lighting
  • Porch

Schools

  • Shaker High School

Utilities

  • Forced Air Heating and Cooling System
  • Heating System Uses Natural Gas
  • High Speed Internet

Community Details

  • No Home Owners Association
  • Saddleback

Home Details

Home Type

Single Family

Est. Annual Taxes

$10,500

Year Built

Built in 2023 | New Construction

Lot Details

0

Parking

2

Listing Details

  • Property Type: Residential
  • Property Sub Type: Single Family Residence
  • Year Built: 2023
  • Directions: Route 7 to Utica Ave to Waterford Ave
  • Above Grade Finished Sq Ft: 2600.0
  • Architectural Style: Colonial
  • Lot Size Acres: 0.44
  • New Construction: Yes
  • Parking Features Parking Total: 2.0
  • Full Bathroom Level: Second
  • Half Bathroom Level: First
  • Laundry Room Level: Second
  • Primary Bathrooms Level: Second
  • Primary Bedroom Level: Second
  • Sale Detail Buyer Zip Code: 12110
  • Sale Detail Seller Contribution: No
  • Garage Yn: Yes
  • Appliances Refrigerators: Yes
  • Architectural Style:Colonial: Yes
  • Laundry Features:Upper Level: Yes
  • Cooling:Central Air: Yes
  • Appliances Microwave: Yes
  • Flooring:Ceramic Tile: Yes
  • Special Features: NewHome

Interior Features

  • Flooring: Ceramic Tile
  • Basement: Full, Sump Pump
  • Interior Amenities: High Speed Internet, Solid Surface Counters, Walk-In Closet(s), Ceramic Tile Bath, Eat-in Kitchen
  • Appliances: Dishwasher, Microwave, Oven, Range, Refrigerator
  • Full Bathrooms: 2
  • Half Bathrooms: 1
  • Total Bedrooms: 4
  • Door Features: Sliding Doors
  • Fireplace Features: Family Room, Gas
  • Fireplaces: 1
  • Living Area: 2600.0
  • Bedroom Level: Second
  • Dining Room Level: First
  • Family Room Level: First
  • Foyer Level: First
  • Kitchen Level: First
  • Mud Room Level: First
  • Bathroom Levels Full Bathroom 1: 2nd
  • Bathroom Levels Full Bathroom 2: 2nd
  • Bathroom Levels Half Bathroom 1: 1st
  • Fireplace: Yes
  • Appliances Dishwasher: Yes
  • Interior Features:High Speed Internet: Yes
  • Full Basement: Yes
  • Kitchen Features:Eat-in Kitchen: Yes
  • Basement:Sump Pump: Yes
  • Interior Features:Walk-In Closet(s): Yes
  • Interior Features:Ceramic Tile Bath: Yes
  • Attic Features:Hatch: Yes
  • Interior Features:Solid Surface Counters: Yes
  • Fireplace Features:Gas2: Yes
  • Appliances:Oven: Yes
  • Appliances Range: Yes
  • Fireplace Features:Family Room: Yes
  • Interior Features:Stone Countertops: Yes

Exterior Features

  • Exterior Features: Lighting
  • Roof: Fiberglass
  • Construction Type: Stone, Vinyl Siding
  • Patio And Porch Features: Porch
  • Waterfront: No
  • Construction Materials:Vinyl Siding: Yes
  • Patio And Porch Features:Porch: Yes
  • Door Features:Sliding Doors: Yes
  • Construction Materials:Stone: Yes
  • Exterior Features:Lighting: Yes

Garage/Parking

  • Garage Spaces: 2.0
  • Parking Features: Off Street, Attached
  • Attached Garage: Yes
  • Total Parking Spaces: 2.0
  • Property Detail:Garage Spaces: 2.0
  • Parking Features:Off Street: Yes
  • Property Detail:Parking YN: Yes
  • Parking Features:Attached: Yes
  • Parking Features:Garage: Yes

Utilities

  • Sewer: Public Sewer
  • Cooling: Central Air
  • Heating: Forced Air, Natural Gas
  • Laundry Features: Laundry Room, Upper Level
  • Water Source: Public
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Heating:Forced Air: Yes
  • Heating:Natural Gas: Yes

Condo/Co-op/Association

  • Association: No

Association/Amenities

  • Parcel Tax HOA:Association YN: No

Schools

  • Junior High Dist: North Colonie (including Maplewood)

Lot Info

  • Parcel #: 000000
  • Lot Size Sq Ft: 19166.4

Tax Info

  • Tax Annual Amount: 10500.0
  • Tax Block: 0
  • Tax Lot: 0
  • Tax Tract: 0

MLS Schools

  • HighSchool: Shaker HS

Ownership History

Date Name Owned For Owner Type

Purchase Details

Closed on
Dec 22, 2006
Sold by
Jeram Bruce D
Bought by
Burns Pamela
Source: Public Records

Range of Values:

Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Purchase History

Date Type Sale Price Title Company
Warranty Deed $210,000 Timothy J Elliott
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
08/08/2025 08/08/25 Sold $644,400 0.0% $248 / Sq Ft
04/11/2025 04/11/25 Price Changed $644,400 +38.3% $248 / Sq Ft
07/24/2022 07/24/22 Pending -- -- --
07/24/2022 07/24/22 For Sale $465,900 -- $179 / Sq Ft
Source: Global MLS

Tax History Compared to Growth

Source: Public Records

Tax History

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2024 $4,987 $118,000 $29,500 $88,500
2023 $4,921 $118,000 $29,500 $88,500
2022 $4,814 $118,000 $29,500 $88,500
2021 $4,793 $118,000 $29,500 $88,500
2020 $4,705 $118,000 $29,500 $88,500
2019 $2,394 $118,000 $29,500 $88,500
2018 $4,123 $118,000 $29,500 $88,500
2017 $0 $118,000 $29,500 $88,500
2016 $3,986 $118,000 $29,500 $88,500
2015 -- $118,000 $29,500 $88,500
2014 -- $118,000 $29,500 $88,500
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: Global MLS

MLS Number: 202223420

Global MLS

APN: 012689-019-014-0001-015-000-0000